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
Ïà¹ØÎĵµ£º
1.¶Á³ö±íÖеÄ×Ö¶ÎÃû
ResultSet rs = test.selectSql("SELECT * from datainfo");
java.sql.ResultSetMetaData md=rs.getMetaData(); //¶Á³öÊý¾Ý¿âµÄ×Ö¶ÎÃû
int nColumn=md.getColumnCount(); //×Ö¶Î×ÜÊý
for(int i=0;i<nColumn;i++)
& ......
1. flashback table table_test to timestamp to_timestamp('20091103000000','yyyymmddhh24miss');
2.Èç¹û報錯ORA-08189: cannot flashback the table because row movement is not enabled
3.alter table table_test enable row movement;
4.OK ......
Ò»¡£²é¿´oracleÊý¾Ý¿âÊÇ·ñΪ¹éµµÄ£Ê½£º
1.select name,log_mode from v$database;
NAME LOG_MODE
------------------ ------------------------
QUERY NOARCHIVELO ......
¸ÐлÌ῵µÂÂÞ¼ÓµÄͶµÝ
¾ÍÏñµ±Ä겨ʿ¶ÙµÄ°®¹úÕßΪ·´¿¹Ó¢¹úÖØË°µÄÐж¯Ò»Ñù£¬NoSQLµÄÖ§³ÖÕßÃÇ´Ó¸÷µØÓ¿À´£¬·ÖÏíËûÃÇÈçºÎÍÆ·»ºÂý¶ø°º¹óµÄ¹ØϵÊý¾Ý¿âµÄ±©Õþ£¬ÔõÑùʹÓøüÓÐЧºÍ¸ü±ãÒ˵ķ½·¨À´¹ÜÀíÊý¾Ý£¬ËûÃÇ¿ªÊ¼¶ÔSQL˵²»£¡NoSQL×éÖ¯ÉϸöÔÂÔھɽðɽµÄÐж¯ÈÃÈËÎŵ½ÁËÊý¾Ý¿â¸ïÃüµÄζµÀ£¬ºÃÏñÒ»¸öÏÖ´úITÒµ°æµÄ²¨ ......
ÅÅÃûº¯ÊýÊÇSQL Server2005мӵŦÄÜ¡£ÔÚSQL Server2005ÖÐÓÐÈçÏÂËĸöÅÅÃûº¯Êý£º
1. row_number ×Ô¶¯Éú³ÉÐкÅ,ÐòºÅÓÉorder by ×ֶξö¶¨
2. rank over Filed, ÓÉrank overµÄ×ֶξö¶¨£¬Ãû´Î²»Á¬Ðø£¬ÈçÓÐ3¸ö²¢ÁеÚÒ»Ãû£¬ÔòºóÐøÃû´ÎÖ±½Ó´Ó4¿ªÊ¼
3. dense_rank£¬ºÍrankÏàËÆ£¬Ö»ÊÇÃû´ÎÁ¬Ðø£¬ÈçÓÐ3¸ö²¢ÁеÚÒ»Ãû£ ......