ORACLE 11g自带DBMS函数包

select object_name,status,object_type from dba_objects where object_name like ‘%DBMS%’ and object_type=’PACKAGE’;

1 DBMS_STANDARD VALID PACKAGE
2 DBMS_REGISTRY VALID PACKAGE
3 DBMS_REGISTRY_SERVER VALID PACKAGE
4 DBMS_PICKLER VALID PACKAGE
5 DBMS_JAVA_TEST VALID PACKAGE
6 DBMS_SPACE_ADMIN VALID PACKAGE
7 DBMS_LOB VALID PACKAGE
8 DBMS_TRANSACTION_INTERNAL_SYS VALID PACKAGE
9 DBMS_SQL VALID PACKAGE
10 DBMS_SYS_SQL VALID PACKAGE
11 DBMS_OUTPUT VALID PACKAGE
12 DBMS_LOGSTDBY VALID PACKAGE
13 DBMS_SESSION VALID PACKAGE
14 DBMS_LOCK VALID PACKAGE
15 DBMS_TYPES VALID PACKAGE
16 DBMS_XMLGEN VALID PACKAGE
17 DBMS_XMLSTORE VALID PACKAGE
18 DBMS_INTERNAL_LOGSTDBY VALID PACKAGE
19 DBMS_INTERNAL_SAFE_SCN VALID PACKAGE
20 DBMS_REGISTRY_SYS VALID PACKAGE
21 DBMS_UTILITY VALID PACKAGE
22 DBMS_ADVISOR VALID PACKAGE
23 DBMS_WARNING VALID PACKAGE
24 DBMS_WARNING_INTERNAL VALID PACKAGE
25 DBMS_TRANSACTION VALID PACKAGE
26 DBMS_ROWID VALID PACKAGE
27 DBMS_PCLXUTIL VALID PACKAGE
28 DBMS_ERRLOG VALID PACKAGE
29 DBMS_ASSERT VALID PACKAGE
30 DBMS_SPACE VALID PACKAGE
31 DBMS_APPLICATION_INFO VALID PACKAGE
32 DBMS_PIPE VALID PACKAGE
33 DBMS_ALERT VALID PACKAGE
34 DBMS_DESCRIBE VALID PACKAGE
35 DBMS_EXPORT_EXTENSION VALID PACKAGE
36 DBMS_JOB VALID PACKAGE
37 DBMS_ODCI VALID PACKAGE
38 DBMS_STATS VALID PACKAGE
39 DBMS_STAT_FUNCS VALID PACKAGE
40 DBMS_DDL VALID PACKAGE
41 DBMS_EDITIONS_UTILITIES VALID PACKAGE
42 DBMS_PREPROCESSOR VALID PACKAGE
43 DBMS_DDL_INTERNAL VALID PACKAGE
44 DBMS_IJOB VALID PACKAGE
45 DBMS_SYS_ERROR VALID PACKAGE
46 DBMS_ZHELP VALID PACKAGE
47 DBMS_ZHELP_IR VALID PACKAGE
48 DBMS_INDEX_UTL VALID PACKAGE
49 DBMS_I_INDEX_UTL VALID PACKAGE
50 DBMS_PSP VALID PACKAGE
51 DBMS_FLASHBACK VALID PACKAGE
52 DBMS_FLASHBACK_ARCHIVE VALID PACKAGE
53 DBMS_XA VALID PACKAGE
54 DBMS_TRANSFORM VALID PACKAGE
55 DBMS_RULE_ADM VALID PACKAGE
56 DBMS_RULE_EXIMP VALID PACKAGE
57 DBMS_RULE VALID PACKAGE
58 DBMS_RULEADM_INTERNAL VALID PACKAGE
59 DBMS_RULE_EXP_UTL VALID PACKAGE
60 DBMS_RULE_EXP_UTLI VALID PACKAGE
61 DBMS_RULE_EXP_EC_INTERNAL VALID PACKAGE
62 DBMS_RULE_EXP_RS_INTERNAL VALID PACKAGE
63 DBMS_RULE_EXP_RL_INTERNAL VALID PACKAGE
64 DBMS_RULE_EXP_EV_CTXS VALID PACKAGE
65 DBMS_RULE_EXP_RULE_SETS VALID PACKAGE
66 DBMS_RULE_EXP_RULES VALID PACKAGE
67 DBMS_RULE_IMP_OBJ VALID PACKAGE
68 DBMS_RULE_COMPATIBLE_90 VALID PACKAGE
69 DBMS_DEBUG VALID PACKAGE
70 DBMS_TRACE VALID PACKAGE
71 DBMS_PLUGTS VALID PACKAGE
72 DBMS_PLUGTSP VALID PACKAGE
73 DBMS_TTS VALID PACKAGE
74 DBMS_EXTENDED_TTS_CHECKS VALID PACKAGE
75 DBMS_TDB VALID PACKAGE
76 DBMS_PITR VALID PACKAGE
77 DBMS_DISTRIBUTED_TRUST_ADMIN VALID PACKAGE
78 DBMS_RLS VALID PACKAGE
79 DBMS_XDS VALID PACKAGE
80 DBMS_XDSUTL VALID PACKAGE
81 DBMS_DBLINK VALID PACKAGE
82 DBMS_REPAIR VALID PACKAGE
83 DBMS_CRYPTO VALID PACKAGE
84 DBMS_OBFUSCATION_TOOLKIT VALID PACKAGE
85 DBMS_SQLHASH VALID PACKAGE
86 DBMS_LOGMNR VALID PACKAGE
87 DBMS_LOGMNR_D VALID PACKAGE
88 DBMS_REPORT VALID PACKAGE
89 DBMS_FGA VALID PACKAGE
90 DBMS_AUDIT_MGMT VALID PACKAGE
91 DBMS_TYPE_UTILITY VALID PACKAGE
92 DBMS_RESUMABLE VALID PACKAGE
93 DBMS_FBT VALID PACKAGE
94 DBMS_SQLJTYPE VALID PACKAGE
95 DBMS_DRS VALID PACKAGE
96 DBMS_DG VALID PACKAGE
97 DBMS_SUMMARY VALID PACKAGE
98 DBMS_DIMENSION VALID PACKAGE
99 DBMS_REDEFINITION VALID PACKAGE
100 DBMS_FILE_TRANSFER VALID PACKAGE
101 DBMS_STORAGE_MAP VALID PACKAGE
102 DBMS_FREQUENT_ITEMSET VALID PACKAGE
103 DBMS_DBVERIFY VALID PACKAGE
104 DBMS_SERVER_TRACE VALID PACKAGE
105 DBMS_CDC_UTILITY VALID PACKAGE
106 DBMS_CDC_PUBLISH VALID PACKAGE
107 DBMS_CDC_SUBSCRIBE VALID PACKAGE
108 DBMS_PROFILER VALID PACKAGE
109 DBMS_HPROF VALID PACKAGE
110 DBMS_SERVICE VALID PACKAGE
111 DBMS_CHANGE_NOTIFICATION VALID PACKAGE
112 DBMS_XPLAN VALID PACKAGE
113 DBMS_DB_VERSION VALID PACKAGE
114 DBMS_SHARED_POOL VALID PACKAGE