Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

±±´óÇàÄñ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


Ïà¹ØÎĵµ£º

oracle±í·ÖÇøÏê½â


http://tianzt.blog.51cto.com/459544/171759   ½ö½ö¹©×Ô¼ºÑ§Ï°Ö®ÓÃ
´ËÎÄ´ÓÒÔϼ¸¸ö·½ÃæÀ´ÕûÀí¹ØÓÚ·ÖÇø±íµÄ¸ÅÄî¼°²Ù×÷:
        1.±í¿Õ¼ä¼°·ÖÇø±íµÄ¸ÅÄî
        2.±í·ÖÇøµÄ¾ßÌå×÷ÓÃ
        3 ......

±±´óÇàÄñoracleѧϰ±Ê¼Ç26 27 28

Êý¾Ý¿â´¥·¢Æ÷
´¥·¢Æ÷Óï¾ä
    Öƶ¨´¥·¢Æ÷¶¨Ê±¡¢Ê¼þ¡¢±íÃû¼°ÀàÐÍ
´¥·¢Æ÷Ö÷Ìå
    ÊÇpl/sql¿ì»ò¶Ô¹ý³ÌµÄµ÷ÓÃ
´¥·¢Æ÷ÏÞÖÆ
    ¿ÉÒÔͨ¹ýwhen×Ó¾äʵÏÖ
DML(insert update delete)
DDL(create alter drop)
Êý¾Ý¿â²Ù×÷(servererror logo ......

Ïòoracle±íÖвåÈë´óÁ¿Êý¾Ý

ÐèÒª´óÁ¿oracle²âÊÔÊý¾Ýʱ£¬¿ÉÒÔʹÓÃÒÔÏ·½·¨¡£
DECLARE
 i INT;
BEGIN
i := 0;
WHILE(i < 100000)
LOOP
 i := i + 1;
 INSERT INTO TEST_TABLE(ID, XM) VALUES(i, 'ÐÕÃû' || i);
END LOOP;
COMMIT;
 END; ......

OracleÊý¾Ý¿âÉè¼Æ

Êý¾ÝownerºÍÊý¾Ý²Ù×÷ÕßÒÔ¼°´úÂë·ÃÎÊʹÓò»Í¬µÄÓû§·ÃÎÊ£¬Ê¹ÓÃÊÚȨµÄ·½Ê½½øÐзÃÎÊ¡£
Êý¾Ý±í´´½¨Ê±Ê¹ÓÃͬÒå´Ê´´½¨
ÊÚȨʱ×îºÃ²»ÒªÊ¹ÓÃwith grant option
ÒÔÇ°²»Ì«Ã÷°×ͬÒå´ÊµÄʹÓã¬ÏÖÔÚÖªµÀÁË¡£±È½ÏºÃµÄÓ¦ÓþÍÊÇ´´½¨±íµÄ±ðÃû
create public ͬÒå´Ê tableName for owner.tableName
 ¸øÊÓͼÊÚȨ¿ÉÒÔʹµÃÓû§·ÃÎʲ»¾ß ......

Oracle Listener ·þÎñ²»ÄÜÆô¶¯µÄÁíÒ»·¢ÏÖ

    ×î½üʱ¼ä£¬¸ü»»ÁËÏîÄ¿×飬×î½üͻȻ·¢ÏÖOracle Listener²»ÄÜÆô¶¯¡£ÒÔÇ°·¢ÏÖ²»ÄÜÆô¶¯µÄÔ­ÒòÊÇ£¬ÖØ×°ÁËOracleºóûÓÐɾ³ýÒÔÇ°µÄ×¢²á±í£¬ÒÔÖÁÓÚĬÈÏÆô¶¯·þÎñµÄÃüÁîÎļþÖ¸ÏòµÄÒÀÈ»ÊÇÒÔÇ°µÄλÖã¬ËùÒÔ²»ÄÜÆô¶¯£¬µ«Õą̂µçÄÔµÄOracleÖ»×°ÁËÒ»´Î¡£
    ×òÌìͻȻ·¢ÏÖ£¬ÔÚlistener.oraÎļþÖеÄHostÅ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ