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

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


Ïà¹ØÎĵµ£º

±Ø±¸sqlÓï¾ä

 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++)
& ......

Oracle»Ö復ÒâÍâ刪³ýµÄ數據

 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µÄ¹éµµÄ£Ê½

Ò»¡£²é¿´oracleÊý¾Ý¿âÊÇ·ñΪ¹éµµÄ£Ê½£º
1.select name,log_mode from v$database;
NAME               LOG_MODE
------------------ ------------------------
QUERY           NOARCHIVELO ......

¶ÔSQL˵²»£¡NoSQLµÄÊý¾Ý¿â¼¼Êõ¸ïÃü

¸ÐлÌ῵µÂÂÞ¼ÓµÄͶµÝ
    ¾ÍÏñµ±Ä겨ʿ¶ÙµÄ°®¹úÕßΪ·´¿¹Ó¢¹úÖØË°µÄÐж¯Ò»Ñù£¬NoSQLµÄÖ§³ÖÕßÃÇ´Ó¸÷µØÓ¿À´£¬·ÖÏíËûÃÇÈçºÎÍÆ·­»ºÂý¶ø°º¹óµÄ¹ØϵÊý¾Ý¿âµÄ±©Õþ£¬ÔõÑùʹÓøüÓÐЧºÍ¸ü±ãÒ˵ķ½·¨À´¹ÜÀíÊý¾Ý£¬ËûÃÇ¿ªÊ¼¶ÔSQL˵²»£¡NoSQL×éÖ¯ÉϸöÔÂÔھɽðɽµÄÐж¯ÈÃÈËÎŵ½ÁËÊý¾Ý¿â¸ïÃüµÄζµÀ£¬ºÃÏñÒ»¸öÏÖ´úITÒµ°æµÄ²¨ ......

SQL Server2005ËĸöÅÅÐòº¯Êý¼ò½é

ÅÅÃûº¯ÊýÊÇSQL Server2005мӵŦÄÜ¡£ÔÚSQL Server2005ÖÐÓÐÈçÏÂËĸöÅÅÃûº¯Êý£º
1. row_number ×Ô¶¯Éú³ÉÐкÅ,ÐòºÅÓÉorder by ×ֶξö¶¨
2. rank over Filed, ÓÉrank overµÄ×ֶξö¶¨£¬Ãû´Î²»Á¬Ðø£¬ÈçÓÐ3¸ö²¢ÁеÚÒ»Ãû£¬ÔòºóÐøÃû´ÎÖ±½Ó´Ó4¿ªÊ¼
3. dense_rank£¬ºÍrankÏàËÆ£¬Ö»ÊÇÃû´ÎÁ¬Ðø£¬ÈçÓÐ3¸ö²¢ÁеÚÒ»Ãû£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ