±±´óÇàÄñoracleѧϰ±Ê¼Ç29 30
oracleÄÚÖóÌÐò°ü
STANDARDºÍDBMS_STANDARD ¶¨ÒåºÍÀ©Õ¹PL/SQLÓïÑÔ»·¾³
DBMS_ALERT Ö§³ÖÊý¾Ý¿âʼþµÄÒ첽֪ͨ
DBMS_APPLICATION_INFO ÔÊÐíΪ¸ú×ÙÄ¿µÄ¶ø×¢²áÓ¦ÓóÌÐò
DBMS_AQ&DBMS_AQADM ¹ÜÀíoracle advanced queuingÑ¡¼þ
DBMS_DEFER¡¢DBMS_DEFER_SYSºÍDBMS_DEFER_QUERY ÔÊÐí¹¹½¨ºÍ¹ÜÀíÑÓ³ÙµÄÔ¶³Ì¹ý³Ìµ÷ÓÃ
DBMS_DDL ijЩDDLÃüÁîµÄpl/sqlµÈЧÏî
CALENDAR ÌṩÈÕÀúά»¤¹¦ÄÜ
DBMS_DESCRIBE ÃèÊö´æ´¢×Ó³ÌÐò
DBMS_LOB ²Ù×ÝLOB¶ÔÏó
DBMS_LOG Ìṩ¶Ô Oracle LOBÊý¾ÝÀàÐͽøÐвÙ×÷µÄ¹¦ÄÜ
DBMS_LOCK Óû§¶¨ÒåµÄËø
DBMS_OUTPUT ´¦ÀíPL/SQL ¿éºÍ×Ó³ÌÐòÊä³öµ÷ÊÔÐÅÏ¢
DBMS_SESSION ÌṩALTER SESSION ÃüÁîµÄPL/SQLµÈЧ¹¦ÄÜ
DBMS_ROWID »ñµÃROWID µÄÏêϸÐÅÏ¢
DBMS_RANDOM ÌṩËæ»úÉú³ÉÆ÷
DBMS_SQL ÔÊÐíÓû§Ê¹Óö¯Ì¬SQL,¹¹ÔìºÍÖ´ÐÐÈÎÒâDMLºÍDDLÓï¾ä
DBMS_JOB Ìá½»ºÍ¹ÜÀíÔÚÊý¾Ý¿âÖÐÖ´ÐеĶ¨Ê±ÈÎÎñ
DBMS_XMLDOM ÓÃDOMÄ£ÐͶÁдXMLÀàÐ͵ÄÊý¾Ý
DBMS_XMLPARSER XML½âÎö,´¦ÀíXMLÎĵµÄÚÈݺͽṹ
DBMS_XMLGEN ½«SQL ²éѯ½á¹ûת»»Îª¹æ·¶µÄXML¸ñʽ
DBMS_XMLQUERY Ìṩ½«Êý¾Ýת»»ÎªXMLÀàÐ͵ŦÄÜ DBMS_XSLPROCESSOR ÌṩXSLT¹¦ÄÜ. ת»»XMLÎĵµ
UTL_FILE ÓÃPL/SQL³ÌÐòÀ´¶Áд²Ù×÷ϵͳÎı¾Îļþ
DBMS_OUTPUTÖеÄһЩ¹ý³Ì
Enable
Disable
Put ½«×Ö·û·ÅÈ뻺³åÇø
Put_line ½«»º³åÇøÖÐÊý¾ÝÊä³ö²¢»»ÐÐ
New_line
Get_line
Get_lines
DBMS_LOB(Ö»ÄÜÓÉsysȨÏÞ²ÅÄܲÙ×÷)
append
compare
copy
erase
fileclose
fileexists
filegetname
getlength
/*´´½¨ÏÂÔØĿ¼±í£¬ÒԼǼÏÂÔصĸ÷ÖÖÎļþ*/
Create Table DownFileList
(
Id Varchar(20) Not Null Primary Key,
Name Varchar(40) Not Null,
FileLocation BFILE,/*Îļþ´æ·ÅλÖÃ*/
Description CLOB/*ÎļþÃèÊö*/
)
/*
´´½¨Ä¿Â¼
Create Or Replace Directory Ŀ¼Ãû AS '±¾µØ»òÍøÂç¹²Ïí·¾¶Ãû';
Create Or Replace Directory FILEDIR AS 'D:\down' »òÕß '\\SERVER\down' \\·þÎñÆ÷Ãû\¹²ÏíÃû
*/
Create Or Replace Directory FILEDIR AS 'D:\temp';--Ö¸¶¨FILEDIRΪ D:\temp Ŀ¼£¨¸ÃĿ¼±ØÐë´æÔÚ£©
insert into downfilelist values
('1001','oracle',BFILENAME(upper('filedir'),'oracle.txt'),'ÕâÊÇÒ»±¾oracleµÄ½Ì³Ì');
ÔÚselect * from downfilelist;ÃüÁîÊÇ£¬BFILE×Ö¶ÎÎÞ·¨ÏÔʾ£¬ÐèҪʹÓÃReadº¯Êý¶ÁÈ¡¡£
read
declare
Ïà¹ØÎĵµ£º
¡¾ÊµÏÖ²½Öè¡¿
1. ´´½¨±íblog_info, ¾ßÓÐIDºÍtitleÁ½¸ö×Ö¶Î, ÆäÖÐID½«ÉèÖÃΪ×Ô¶¯Ôö³¤ÁÐ;
2. ´´½¨ÐòÁÐ:
create sequence sq_blog_info
start with 1
increment by 1
nomaxvalue
nocycle
......
ʱ¼ä: 2006-06-15 À´×Ô£ºCSDN
< type="text/javascript"><!--
google_ad_client = "pub-0103898066674568";
google_ad_width = 728;
google_ad_height = 90;
google_ad_format = "728x90_as";
google_ad_type = "text";
google_ad_channel = "";
google_color_ ......
1)µ¼ÈëoracleÊý¾Ý¿âÎļþ.dmpʱ³öÏÖ´íÎó
imp PERSONNEL_MANAGE/MWQ@MIS file=C:\personnel_manage.dmp fromuser=PERSONNEL_MANAGE ignore=y commit=y grants=y;
IMP-00058: Óöµ½ ORACLE ´íÎó 1017
ORA-01017: invalid username/password; logon denied̞:
¿ÚÁî:
IMP-00058: Óöµ½ ORACLE ´íÎó 1017
ORA-01017: in ......
×î½üʱ¼ä£¬¸ü»»ÁËÏîÄ¿×飬×î½üͻȻ·¢ÏÖOracle Listener²»ÄÜÆô¶¯¡£ÒÔÇ°·¢ÏÖ²»ÄÜÆô¶¯µÄÔÒòÊÇ£¬ÖØ×°ÁËOracleºóûÓÐɾ³ýÒÔÇ°µÄ×¢²á±í£¬ÒÔÖÁÓÚĬÈÏÆô¶¯·þÎñµÄÃüÁîÎļþÖ¸ÏòµÄÒÀÈ»ÊÇÒÔÇ°µÄλÖã¬ËùÒÔ²»ÄÜÆô¶¯£¬µ«Õą̂µçÄÔµÄOracleÖ»×°ÁËÒ»´Î¡£
×òÌìͻȻ·¢ÏÖ£¬ÔÚlistener.oraÎļþÖеÄHostÅ ......