±±´óÇàÄñ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
Ïà¹ØÎĵµ£º
¹ý³ÌÖеÄÊÂÎñ
¶¨Òå¹ý³Ìp1
create or replace procedure p1
as
begin
insert into student values(5,'xdh','m',sysdate);
rollback;
end;
¶¨Òå¹ý³Ìp2
create or replace procedure p2
as
begin
update student set stu_sex = 'a' where stu_id = 3;
p1;
end;
Ö´Ðйý³Ìp2
exec p2;
Ö´ÐÐÍê±Ï·¢ÏÖ ......
Oracle RAC
¡¡¡¡RAC£¬È«³Æreal application clusters£¬ÒëΪ“ÕæÕýÓ¦Óü¯Èº”£¬ ÊÇOracleаæÊý¾Ý¿âÖвÉÓõÄÒ»Ïîм¼Êõ£¬Ò²ÊÇOracleÊý¾Ý¿âÖ§³ÖÍø¸ñ¼ÆËã»·¾³µÄºËÐļ¼Êõ¡£
¡¡¡¡Oracle RACÖ÷ÒªÖ§³ÖOracle9i¡¢10g¡¢11g°æ±¾£¬¿ÉÒÔ¿ÉÒÔÖ§³Ö24 x 7 ÓÐЧµÄÊý¾Ý¿âÓ¦Óà ϵͳ£¬Ôڵͳɱ¾·þÎñÆ÷ÉϹ¹½¨¸ß¿ÉÓÃÐÔÊý¾Ý¿âϵͳ£¬²¢Ç ......
Oracle¹ÜÀíÔ±µÄÁ½ÖÖÈÏÖ¤·½·¨
×¢Ò⣺ÖØÒª
parameter ÖÐremote_login_passwordfile
1¡¢alter system set remote_login_passwordfile= none scope =spfile£»
º¬Ò壺·ÇÃÜÂëÈÏÖ¤£¨´Ëʱ½öosÈÏÖ¤ £©
2¡¢alter system set remote_login_passwordfile= exclusive ......
ÐèÒª´óÁ¿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; ......