28 Oracle深度学习笔记——ORACLE自带DBMS函数包

               

28.Oracle深度学习笔记——ORACLE自带DBMS函数包

欢迎转载，转载请标明出处：http://blog.youkuaiyun.com/notbaron/article/details/50830889

12C 包含的DBMS包

查看如下：

sys@TOADDB> col object_name format a25;

sys@TOADDB> select object_name,status,object_typefrom dba_objects where object_name like '%DBMS%' and object_type='PACKAGE';

OBJECT_NAME                    STATUS OBJECT_TYPE

------------------------- ------------------------------

DBMS_STANDARD              VALID   PACKAGE

DBMS_REGISTRY                VALID   PACKAGE

DBMS_REGISTRY_SERVER        VALID   PACKAGE

DBMS_REGISTRY_SIMPLE         VALID   PACKAGE

DBMS_PICKLER                   VALID   PACKAGE

DBMS_JAVA_TEST              VALID   PACKAGE

DBMS_SPACE_ADMIN       VALID   PACKAGE

DBMS_LOB                  VALID  PACKAGE

DBMS_TRANSACTION_INTERNAL VALID   PACKAGE

_SYS

 

DBMS_SQL                  VALID  PACKAGE

DBMS_SYS_SQL                   VALID   PACKAGE

DBMS_OUTPUT                   VALID  PACKAGE

DBMS_LOGSTDBY              VALID   PACKAGE

DBMS_LOGSTDBY_CONTEXT  VALID   PACKAGE

DBMS_SESSION                   VALID   PACKAGE

DBMS_LOCK               VALID  PACKAGE

DBMS_TYPES              VALID  PACKAGE

DBMS_XMLGEN                  VALID  PACKAGE

DBMS_XMLSTORE              VALID   PACKAGE

DBMS_AUTO_REPORT_INTERNAL VALID   PACKAGE

DBMS_INTERNAL_LOGSTDBY          VALID   PACKAGE

DBMS_INTERNAL_SAFE_SCN  VALID   PACKAGE

DBMS_REGISTRY_SYS       VALID   PACKAGE

DBMS_UTILITY                    VALID   PACKAGE

DBMS_ADVISOR                 VALID   PACKAGE

DBMS_ASSERT                     VALID  PACKAGE

DBMS_ODCI               VALID  PACKAGE

DBMS_SCHEDULER                     VALID   PACKAGE

DBMS_ISCHED                    VALID  PACKAGE

DBMS_ISCHED_CHAIN_CONDITI VALID   PACKAGE

ON

 

DBMS_ISCHED_REMDB_JOB  VALID   PACKAGE

DBMS_XS_MTCACHE       VALID   PACKAGE

DBMS_XS_SIDP                   VALID   PACKAGE

DBMS_STATS_INTERNAL            VALID   PACKAGE

DBMS_SQLTUNE_UTIL0    VALID   PACKAGE

DBMS_SQLTUNE_UTIL1    VALID   PACKAGE

DBMS_SQLTUNE_UTIL2    VALID   PACKAGE

DBMS_REPORT                   VALID  PACKAGE

DBMS_OBJECTS_UTILS     VALID   PACKAGE

DBMS_OBJECTS_APPS_UTILS   VALID  PACKAGE

DBMS_WARNING               VALID   PACKAGE

DBMS_WARNING_INTERNAL  VALID   PACKAGE

DBMS_PDB                 VALID  PACKAGE

DBMS_TRANSACTION       VALID   PACKAGE

DBMS_ROWID                     VALID  PACKAGE

DBMS_PCLXUTIL                 VALID   PACKAGE

DBMS_ERRLOG                   VALID  PACKAGE

DBMS_SPACE              VALID  PACKAGE

DBMS_HEAT_MAP             VALID   PACKAGE

DBMS_APPLICATION_INFO      VALID   PACKAGE

DBMS_PIPE                 VALID  PACKAGE

DBMS_ALERT             VALID  PACKAGE

DBMS_DESCRIBE                VALID   PACKAGE

DBMS_EXPORT_EXTENSION_I   VALID  PACKAGE

DBMS_EXPORT_EXTENSION    VALID   PACKAGE

DBMS_JOB                  VALID  PACKAGE

DBMS_STATS               VALID  PACKAGE

DBMS_STAT_FUNCS          VALID   PACKAGE

DBMS_DDL                 VALID  PACKAGE

DBMS_EDITIONS_UTILITIES   VALID  PACKAGE

DBMS_PREPROCESSOR     VALID   PACKAGE

DBMS_DDL_INTERNAL     VALID   PACKAGE

DBMS_IJOB                 VALID  PACKAGE

DBMS_SYS_ERROR             VALID   PACKAGE

DBMS_ZHELP             VALID  PACKAGE

DBMS_ZHELP_IR                VALID   PACKAGE

DBMS_INDEX_UTL             VALID   PACKAGE

DBMS_I_INDEX_UTL         VALID   PACKAGE

DBMS_PSP                   VALID  PACKAGE

DBMS_FLASHBACK             VALID   PACKAGE

DBMS_FLASHBACK_ARCHIVE           VALID   PACKAGE

DBMS_XA                   VALID  PACKAGE

DBMS_TRANSFORM                   VALID  PACKAGE

DBMS_RULE_ADM             VALID   PACKAGE

DBMS_RULE_EXIMP         VALID   PACKAGE

DBMS_RULE               VALID  PACKAGE

DBMS_RULEADM_INTERNAL  VALID   PACKAGE

DBMS_RULE_INTERNAL   VALID   PACKAGE

DBMS_RULE_EXP_UTL      VALID   PACKAGE

DBMS_RULE_EXP_UTLI    VALID   PACKAGE

DBMS_RULE_EXP_EC_INTERNAL VALID   PACKAGE

DBMS_RULE_EXP_RS_INTERNAL VALID   PACKAGE

DBMS_RULE_EXP_RL_INTERNAL VALID   PACKAGE

DBMS_RULE_EXP_EV_CTXS     VALID   PACKAGE

DBMS_RULE_EXP_RULE_SETS   VALID  PACKAGE

DBMS_RULE_EXP_RULES          VALID   PACKAGE

DBMS_RULE_IMP_OBJ     VALID   PACKAGE

DBMS_DEBUG                     VALID  PACKAGE

DBMS_TRACE             VALID  PACKAGE

DBMS_PLUGTS                    VALID  PACKAGE

DBMS_PLUGTSP                  VALID   PACKAGE

DBMS_TTS                   VALID  PACKAGE

DBMS_EXTENDED_TTS_CHECKS  VALID  PACKAGE

DBMS_TDB                 VALID   PACKAGE

DBMS_PITR                 VALID  PACKAGE

DBMS_DISTRIBUTED_TRUST_AD VALID   PACKAGE

MIN

 

DBMS_RLS                   VALID  PACKAGE

DBMS_XDS                  VALID  PACKAGE

DBMS_REPAIR                     VALID  PACKAGE

DBMS_CRYPTO                   VALID  PACKAGE

DBMS_OBFUSCATION_TOOLKIT  VALID  PACKAGE

DBMS_SQLHASH                 VALID   PACKAGE

DBMS_LOGMNR                 VALID  PACKAGE

DBMS_LOGMNR_D                     VALID   PACKAGE

DBMS_FGA                  VALID  PACKAGE

DBMS_AUDIT_MGMT     VALID   PACKAGE

DBMS_TYPE_UTILITY        VALID&nb