ORACLE 10G PL/SQL PACKAGEѧϰ±Ê¼Ç
DBMS_CHANGE_NOTIFICATION
¶ÔÏó£¨±í£©Êý¾Ý¸üÐÂ֪ͨ
DBMS_APPLICATION_INFO
ÉèÖÃ/¶ÁÈ¡SESSION APPLICATIONÐÅÏ¢£¬²Ù×÷V$SESSION_LONGOPS
DBMS_ALERT
¸æ¾¯
DBMS_DATAPUMP
Êý¾ÝǨÒÆ
DBMS_DB_VERSION
Êý¾Ý¿â°æ±¾¶¨Òå
DBMS_DDL
Compiles¡¢wrapped¡¢Reorganizes ¶ÔÏó
DBMS_DEBUG
ORACLE DEPL/SQL debugger ¹¤¾ß
DBMS_DESCRIBE
»ñÈ¡¶ÔÏóÐÅÏ¢£¬ÀàËÆDESCÃüÁî
DBMS_ERRLOG
¼Ç¼SQL£¨DML)´íÎó£¬ÐèÒªÐÞ¸ÄSQL£¬ÔÚÕý³£SQLºó¼ÓÉϼǼ´úÂë
DBMS_FLASHBACK
Êý¾Ý»ØÀÌ
DBMS_IOT
·ÖÎöchained rows for an index-organized table ºÍ enable_constraint ÓÐÎÊÌâROW
DBMS_JOB
JOB¹ÜÀí
DBMS_LOB
Ìṩ¶ÔBLOBs, CLOBs, NCLOBs, BFILEs, and temporary LOBsµÄ²Ù×÷
DBMS_LOCK
ÌṩһÌ×ORACLE Ðźţ¨LOCK)¹ÜÀí¸øÓ¦ÓÃʹÓã¬×¢Òâ²»ÄܲÙ×÷ORACLE±¾ÉíLOCK
DBMS_LOGMNR
ÈÕÖ¾·ÖÎö
DBMS_LOGMNR_D
ÈÕÖ¾·ÖÎö
DBMS_MONITOR
ORACLE TRACE ¹¤¾ß£¬¿ÉÒÔ¿ØÖƵ½CLIENT,SESSION
DBMS_MVIEW
materialized views¹¤¾ß
DBMS_OBFUSCATION_TOOLKIT
DES¼ÓÃܹ¤¾ß
DBMS_OUTPUT
Êä³ö
DBMS_PCLXUTIL
ʹÓÃJOB¶à·´´½¨/RUBUILD LOCAL INDEX
DBMS_PREPROCESSOR
print or retrieve the source text of a PL/SQL unit in its post-processed form
DBMS_PROFILER
ÊÕ¼¯SESSIONÖÐPL/SQLµÄÔËÐÐÐÅÏ¢£¬ÒÔ½øÐÐÓÅ»¯,ÐèÒªÏÈÔËÐÐPROFTAB.SQL
DBMS_RANDOM
Ëæ»úÊý¹¤¾ß
DBMS_REDEFINITION
ÔÚÏßÖض¨Òå±í
DBMS_REFRESH
½«Ò»×éMVIEWÒ»ÆðË¢ÐÂ
DBMS_REPAIR
ORACLE ÐÞ¸´¹¤¾ß
DBMS_RESOURCE_MANAGER
ORACLE ×ÊÔ´¹ÜÀí
DBMS_RESOURCE_MANAGER_PRIVS
ÅäºÏDBMS_RESOURCE_MANAGERµÄȨÏÞ¹ÜÀí
DBMS_RESUMABLE
¹ÒÆðʧ°ÜÊÂÎñ£¬µÈ´ýÒ»¶¨Ê±¼äºó¼ÌÐø
DBMS_ROWID
ROWID¹¤¾ß
DBMS_SCHEDULER
Ìæ´údbms_job£¬ÌṩÀàÐÍCRONTABµÄ¶¨Ê±¹ÜÀí
DBMS_SERVER_ALERT
ÉèÖÃÌض¨ORACLE·§Öµ¸æ¾¯£¨¿ÉÒÔÉèÖø澯À©Õ¹ÐÅÏ¢£©
DBMS_SESSION
SESSION ÉèÖùÜÀí¹¤¾ß
DBMS_SHARED_POOL
SHARE POOL ¹¤¾ß
DBMS_SPACE
SEGMENT¹ÜÀí¹¤¾ß£¬ÌṩÁ˱íÐèÒª¿Õ¼ä¹ÀËãCREATE_TABLE_COST
DBMS_SPACE_ADMIN
LOCAL MANAGEMENT SEGMENT¹ÜÀí¹¤¾ß
DBMS_SQL
¶¯Ì¬SQLÖ´ÐÐ
DBMS_SQLTUNE
SQL ÓÅ»¯¹¤¾ß
DBMS_STAT_FUNCS
ORACLE ±íÊý¾Ý Êýѧͳ¼Æ
DBMS_STATS
¶ÔÏó·ÖÎö¹¤¾ß
DBMS_TRACE
SESSIONÏÂSQL TRACE
DBMS_TYPES
TYPE¹ÜÀí
DBMS_UTILITY
һЩ±È½ÏÁãÉ¢µÄ¹¤¾ß
UTL_COMPRESS
ѹËõ¹¤¾ß
UTL_FILE
Îļþ²Ù×÷¹¤¾ß
U
Ïà¹ØÎĵµ£º
³õѧlinux+oracle£¬²ÉÓõı¾µØÐéÄâ»ú°²×°linuxµÄ·½Ê½£¬°æ±¾ÊÇRed Hat 5£¬Î¨Ò»¸úÐéÄâ»ú°²×°ÆäËûϵͳ²»Í¬µÄÊÇ£º¶¨ÖÆ£¬Ñ¡IDEÓ²ÅÌ£¬·ñÔò°²×°¹ý³ÌÌáʾÕÒ²»µ½Ó²ÅÌʧ°Ü¡£
±¾ÎÄÖصãÊÇOracle°²×°¹ý³Ì£¬°æ±¾ 10.1.0¡£
3¡¢°²×°Ïà¹ØµÄ¿ª·¢°ü£¨rpm°ü£©£º
rpm -q binutils co ......
This course is aim to train the great DBA with good English speaking.
In recent years, more demands of Oracle DBA, but most of Senior DBAs are required to speak good English.
English has become the great barrier for more peoples in their career development, you must have the deep feeling about it ......
1.ASCII
·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý;
SQL> select ascii(’A’) A,ascii(’a’) a,ascii(’0’) zero,ascii(’ ’) space from dual;
A A ZERO SPACE
--------- --------- --------- ---------
65 97 48 32
2.CHR
¸ø³öÕ ......
Ò»¡£²é¿´oracleÊý¾Ý¿âÊÇ·ñΪ¹éµµÄ£Ê½£º
1.select name,log_mode from v$database;
NAME LOG_MODE
------------------ ------------------------
QUERY NOARCHIVELO ......
WITH V AS(SELECT ROW_NUMBER() OVER(order by fcustid desc) AS RN,* from ts_dict AS SourceView)
SELECT * from V WHERE RN BETWEEN 1 AND 10
תÔصØÖ·£ºhttp://www.cnblogs.com/nokiaguy/archive/2009/02/05/1384860.html
ÅÅÃûº¯ÊýÊÇSQL Server2005мӵŦÄÜ¡£ÔÚSQL Server2005ÖÐÓÐÈçÏÂËĸöÅÅÃûº ......