±±´óÇàÄñ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
Ïà¹ØÎĵµ£º
×Ó³ÌÐò ÃüÃûµÄpl/sql¿é
create procedure ¹ý³ÌÃû [²ÎÊý1 in|out|in out¡]
¾Ö²¿±äÁ¿ÉùÃ÷
Ö´ÐÐÓï¾ä
in
out
in out
¹ý³ÌÃû(²ÎÊýÀï±í); create or replace
procedure add123 as
i integer;
j integer;
begin
i:=1;
j:=2;
dbms_output.put_l ......
2010-03-12 21:21:26
sqlplusµÇ½¶ÌÏûÏ¢oracleÊý¾Ý¿âʱÌáʾ“ORA-28000: Õʺű»Ëø¶¨”¡£
תÌù£ºhttp://blog.csdn.net/shongyu/archive/2009/06/01/4233260.aspx
È·¶¨ÊÇÓÉÓÚoracle11gÖÐĬÈÏÔÚdefault¸ÅÒªÎļþÖÐÉèÖÃÁË“FAILED_LOGIN_ATTEMPTS=10´Î”£¬µ±ÊäÈëÃÜÂë´íÎó´ÎÊý´ïµ½ÉèÖÃÖµ½«µ¼Ö´ËÎÊÌâ¡£
° ......
ÐèÒª´óÁ¿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; ......
Õâ´ÎµÄ¾ÀúÊÇ×Ô¼ºÕÒÀ´µÄ£¬ÔÚ°²×°ÁË10gµÄÄÇ̨»úÉÏÉý¼¶ÏÂÄÚ´æÒ²±ãÄܺöÓÆÄÇȺÓÑ£¬²»¹ýÏëÏ뻹ÊÇÕÛÌÚϰɣ¬¸øÒƵ½ÅäÖúõãµÄServerÉÏÃæ£¬ËûÃÇÓÃÆðÀ´Ë³ÐÄ£¬ÎÒ×Ô¼ºÒ²ÄÜÕÛÌÚµã¾Ñé¡£
132µÄϵͳÊÇSuSE10.2µÄ£¬Ö®Ç°ÒѾ°²×°ÁËOracle 9i£¬Õâ¾ÍÒâζ×űØÐëÏÈÐ¶ÔØµô9i£¬±¾ÒÔΪ°²×°10gµÄrunInstallerÄܹ»Ð¶Ôصô9i£¬¿É³¢ÊÔÁ˺þö¼ÊdzöÏÖex ......