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

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

欢迎转载，转载请标明出处：http://blog.csdn.net/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   PACKAGE

DBMS_RESUMABLE                    VALID   PACKAGE

DBMS_FBT                  VALID  PACKAGE

DBMS_DRS                  VALID  PACKAGE

DBMS_DG                  VALID  PACKAGE

DBMS_SUMMARY              VALID   PACKAGE

DBMS_DIMENSION                     VALID   PACKAGE

DBMS_REDEFINITION       VALID   PACKAGE

DBMS_FILE_TRANSFER     VALID   PACKAGE

DBMS_STORAGE_MAP     VALID   PACKAGE

DBMS_FREQUENT_ITEMSET    VALID   PACKAGE

DBMS_DBVERIFY                VALID   PACKAGE

DBMS_SERVER_TRACE     VALID   PACKAGE

DBMS_CDC_UTILITY         VALID   PACKAGE

DBMS_CDC_PUBLISH        VALID   PACKAGE

DBMS_CDC_SUBSCRIBE   VALID   PACKAGE

DBMS_PROFILER                VALID   PACKAGE

DBMS_HPROF            VALID  PACKAGE

DBMS_SERVICE                   VALID   PACKAGE

DBMS_SERVICE_PRVT      VALID   PACKAGE

DBMS_CHANGE_NOTIFICATION  VALID  PACKAGE

DBMS_XPLAN             VALID  PACKAGE

DBMS_DB_VERSION        VALID   PACKAGE

DBMS_SHARED_POOL      VALID   PACKAGE

DBMS_RESULT_CACHE     VALID   PACKAGE

DBMS_RESULT_CACHE_API     VALID   PACKAGE

DBMS_CLIENT_RESULT_CACHE  VALID  PACKAGE

DBMS_CONNECTION_POOL     VALID   PACKAGE

DBMS_AQ                  VALID  PACKAGE

DBMS_AQADM                   VALID  PACKAGE

DBMS_AQ_IMPORT_INTERNAL   VALID  PACKAGE

DBMS_AQELM                     VALID  PACKAGE

DBMS_AQ_EXP_QUEUE_TABLES  VALID  PACKAGE

DBMS_AQ_EXP_INDEX_TABLES  VALID  PACKAGE

DBMS_AQ_EXP_TIMEMGR_TABLE VALID   PACKAGE

S

 

DBMS_AQ_EXP_HISTORY_TABLE VALID   PACKAGE

S

 

DBMS_AQ_EXP_DEQUEUELOG_TA VALID   PACKAGE

BLES

 

DBMS_AQ_EXP_CMT_TIME_TABL VALID   PACKAGE

ES

 

DBMS_AQ_EXP_SIGNATURE_TAB VALID   PACKAGE

LES

 

DBMS_AQ_EXP_SUBSCRIBER_TA VALID   PACKAGE

BLES

 

DBMS_AQ_EXP_QUEUES           VALID   PACKAGE

DBMS_AQ_SYS_EXP_INTERNAL  VALID  PACKAGE

DBMS_AQ_SYS_EXP_ACTIONS   VALID  PACKAGE

DBMS_AQ_EXP_ZECURITY        VALID   PACKAGE

DBMS_AQ_SYS_IMP_INTERNAL  VALID  PACKAGE

DBMS_AQ_IMP_ZECURITY       VALID   PACKAGE

DBMS_AQ_IMP_INTERNAL       VALID   PACKAGE

DBMS_SERVER_ALERT      VALID   PACKAGE

DBMS_MONITOR               VALID   PACKAGE

DBMS_HM                 VALID  PACKAGE

DBMS_IR                    VALID  PACKAGE

DBMS_SESSION_STATE      VALID   PACKAGE

DBMS_LOBUTIL                  VALID   PACKAGE

DBMS_MANAGEMENT_PACKS         VALID   PACKAGE

DBMS_ADDM             VALID  PACKAGE

DBMS_TRANSFORM_INTERNAL   VALID  PACKAGE

DBMS_TRANSFORM_EXIMP_INTE VALID   PACKAGE

RNAL

 

DBMS_TRANSFORM_EXIMP    VALID   PACKAGE

DBMS_RMIN_SYS               VALID   PACKAGE

DBMS_RMIN              VALID  PACKAGE

DBMS_RESOURCE_MANAGER         VALID   PACKAGE

DBMS_RESOURCE_MANAGER_PRI VALID   PACKAGE

VS

 

DBMS_RMGR_PLAN_EXPORT          VALID   PACKAGE

DBMS_RMGR_GROUP_EXPORT      VALID   PACKAGE

DBMS_RMGR_PACT_EXPORT           VALID   PACKAGE

DBMS_PRVTRMIE              VALID   PACKAGE

DBMS_SCHED_MAIN_EXPORT         VALID   PACKAGE

DBMS_SCHED_PROGRAM_EXPORT VALID   PACKAGE

DBMS_SCHED_JOB_EXPORT   VALID   PACKAGE

DBMS_SCHED_WINDOW_EXPORT  VALID  PACKAGE

DBMS_SCHED_WINGRP_EXPORT  VALID  PACKAGE

DBMS_SCHED_CLASS_EXPORT   VALID  PACKAGE

DBMS_SCHED_SCHEDULE_EXPOR VALID   PACKAGE

T

 

DBMS_SCHED_CHAIN_EXPORT   VALID  PACKAGE

DBMS_SCHED_CREDENTIAL_EXP VALID   PACKAGE

ORT

 

DBMS_SCHED_FILE_WATCHER_E VALID   PACKAGE

XPORT

 

DBMS_SCHED_ATTRIBUTE_EXPO VALID   PACKAGE

RT

 

DBMS_SCHED_EXPORT_CALLOUT VALID   PACKAGE

S

 

DBMS_SCHED_ARGUMENT_IMPOR VALID   PACKAGE

T

 

DBMS_DATAPUMP_UTL   VALID   PACKAGE

DBMS_METADATA              VALID   PACKAGE

DBMS_METADATA_BUILD         VALID   PACKAGE

DBMS_METADATA_DPBUILD  VALID   PACKAGE

DBMS_METADATA_DIFF   VALID   PACKAGE

DBMS_DATAPUMP             VALID   PACKAGE

DBMS_TDE_TOOLKIT        VALID   PACKAGE

DBMS_TDE_TOOLKIT_FFI          VALID   PACKAGE

DBMS_SUMREF_UTIL        VALID   PACKAGE

DBMS_SERVER_ALERT_EXPORT  VALID  PACKAGE

DBMS_WORKLOAD_REPOSITORY  VALID  PACKAGE

DBMS_PERF                VALID  PACKAGE

DBMS_SWRF_REPORT_INTERNAL VALID   PACKAGE

DBMS_SWRF_INTERNAL            VALID   PACKAGE

DBMS_AWR_REPORT_LAYOUT        VALID   PACKAGE

DBMS_ASH_INTERNAL     VALID   PACKAGE

DBMS_WORKLOAD_CAPTURE         VALID   PACKAGE

DBMS_WORKLOAD_REPLAY     VALID   PACKAGE

DBMS_FEATURE_USAGE_REPORT VALID   PACKAGE

DBMS_FEATURE_USAGE            VALID   PACKAGE

DBMS_UNDO_ADV            VALID   PACKAGE

DBMS_SPM                 VALID  PACKAGE

DBMS_SPM_INTERNAL     VALID   PACKAGE

DBMS_SMB                 VALID  PACKAGE

DBMS_SMB_INTERNAL   VALID   PACKAGE

DBMS_LCR                  VALID  PACKAGE

DBMS_STREAMS_TABLESPACE_A VALID   PACKAGE

DM

 

DBMS_STREAMS                 VALID   PACKAGE

DBMS_STREAMS_ADM     VALID   PACKAGE

DBMS_STREAMS_MESSAGING         VALID   PACKAGE

DBMS_STREAMS_AUTH   VALID   PACKAGE

DBMS_STREAMS_ADVISOR_ADM  VALID  PACKAGE

DBMS_STREAMS_HANDLER_ADM  VALID  PACKAGE

DBMS_APPLY_ADM                     VALID   PACKAGE

DBMS_CAPTURE_ADM     VALID   PACKAGE

DBMS_PROPAGATION_ADM    VALID   PACKAGE

DBMS_FILE_GROUP         VALID   PACKAGE

DBMS_COMPARISON       VALID   PACKAGE

DBMS_XSTREAM_ADM    VALID   PACKAGE

DBMS_XSTREAM_AUTH   VALID   PACKAGE

DBMS_GOLDENGATE_AUTH    VALID   PACKAGE

DBMS_STREAMS_LCR_INT       VALID   PACKAGE

DBMS_RECOVERABLE_SCRIPT   VALID  PACKAGE

DBMS_RECO_SCRIPT_INVOK  VALID   PACKAGE

DBMS_RECO_SCRIPT_INT         VALID   PACKAGE

DBMS_STREAMS_MT       VALID   PACKAGE

DBMS_STREAMS_SM       VALID   PACKAGE

DBMS_STREAMS_AUTO_INT   VALID   PACKAGE

DBMS_STREAMS_HANDLER_INTE VALID   PACKAGE

RNAL

 

DBMS_APPLY_HANDLER_ADM        VALID   PACKAGE

DBMS_APPLY_HANDLER_INTERN VALID   PACKAGE

AL

 

DBMS_STREAMS_ADM_UTL    VALID   PACKAGE

DBMS_STREAMS_DECL    VALID   PACKAGE

DBMS_STREAMS_ADM_UTL_INT  VALID  PACKAGE

DBMS_STREAMS_ADM_UTL_INVO VALID   PACKAGE

K

 

DBMS_STREAMS_CONTROL_ADM  VALID  PACKAGE

DBMS_STREAMS_ADM_IVK     VALID   PACKAGE

DBMS_APPLY_ADM_INTERNAL   VALID  PACKAGE

DBMS_APPLY_PROCESS    VALID   PACKAGE

DBMS_APPLY_ERROR        VALID   PACKAGE

DBMS_APPLY_POSITION   VALID   PACKAGE

DBMS_APPLY_ADM_IVK   VALID   PACKAGE

DBMS_CAPTURE_ADM_INTERNAL VALID   PACKAGE

DBMS_CAPTURE_PROCESS       VALID   PACKAGE

DBMS_CAPTURE_ADM_IVK     VALID   PACKAGE

DBMS_PROPAGATION_INTERNAL VALID   PACKAGE

DBMS_STREAMS_ADV_ADM_UTL  VALID  PACKAGE

DBMS_STREAMS_ADV_ADM_UTL_ VALID   PACKAGE

INVOK

 

DBMS_LOGREP_DEF_PROC_UTL  VALID  PACKAGE

DBMS_STREAMS_RPC       VALID   PACKAGE

DBMS_STREAMS_RPC_INTERNAL VALID   PACKAGE

DBMS_STREAMS_PUB_RPC      VALID   PACKAGE

DBMS_STREAMS_CDC_ADM   VALID   PACKAGE

DBMS_CAPTURE_SWITCH_INTER VALID   PACKAGE

NAL

 

DBMS_CAPTURE_SWITCH_ADM   VALID  PACKAGE

DBMS_XSTREAM_ADM_UTL    VALID   PACKAGE

DBMS_XSTREAM_ADM_INTERNAL VALID   PACKAGE

DBMS_XSTREAM_UTL_IVK       VALID   PACKAGE

DBMS_XSTREAM_GG       VALID   PACKAGE

DBMS_XSTREAM_GG_ADM     VALID   PACKAGE

DBMS_XSTREAM_GG_INTERNAL  VALID  PACKAGE

DBMS_XSTREAM_AUTH_IVK   VALID   PACKAGE

DBMS_STREAMS_MC      VALID   PACKAGE

DBMS_STREAMS_MC_INV        VALID   PACKAGE

DBMS_SQLTUNE                 VALID   PACKAGE

DBMS_AUTO_SQLTUNE    VALID   PACKAGE

DBMS_SQLPA              VALID  PACKAGE

DBMS_AUTO_REPORT      VALID   PACKAGE

DBMS_RAT_MASK              VALID   PACKAGE

DBMS_SQLDIAG                  VALID   PACKAGE

DBMS_REPCAT_DECL        VALID   PACKAGE

DBMS_REPCAT_CACHE    VALID   PACKAGE

DBMS_REPCAT_INTERNAL_PACK VALID   PACKAGE

AGE

 

DBMS_REPCAT_INTERNAL        VALID   PACKAGE

DBMS_INTERNAL_TRIGGER    VALID   PACKAGE

DBMS_ITRIGGER_UTL      VALID   PACKAGE

DBMS_REPCAT_OUTPUT           VALID   PACKAGE

DBMS_REPUTIL                   VALID   PACKAGE

DBMS_REPUTIL2                VALID   PACKAGE

DBMS_DEFERGEN              VALID   PACKAGE

DBMS_DEFERGEN_UTIL   VALID   PACKAGE

DBMS_DEFER_QUERY       VALID   PACKAGE

DBMS_DEFER             VALID  PACKAGE

DBMS_DEFER_SYS              VALID   PACKAGE

DBMS_REPCAT_OBJ_UTL          VALID   PACKAGE

DBMS_REPCAT_UTL         VALID   PACKAGE

DBMS_DEFER_QUERY_UTL      VALID   PACKAGE

DBMS_DEFER_ENQ_UTL           VALID   PACKAGE

DBMS_DEFER_REPCAT     VALID   PACKAGE

DBMS_ASYNCRPC_PUSH           VALID   PACKAGE

DBMS_DEFER_SYS_PART1         VALID   PACKAGE

DBMS_DEFER_INTERNAL_QUERY VALID   PACKAGE

DBMS_DEFER_INTERNAL_SYS   VALID  PACKAGE

DBMS_DEFER_IMPORT_INTERNA VALID   PACKAGE

L

 

DBMS_DEFER_QUERY_DEFINER  VALID  PACKAGE

DBMS_DEFER_DEFINER   VALID   PACKAGE

DBMS_DEFER_SYS_DEFINER   VALID   PACKAGE

DBMS_REPCAT_SQL_UTL          VALID   PACKAGE

DBMS_REPCAT_COMMON_UTL      VALID   PACKAGE

DBMS_REPCAT_SNA         VALID   PACKAGE

DBMS_ISNAPSHOT             VALID   PACKAGE

DBMS_IREFRESH                VALID   PACKAGE

DBMS_SNAPSHOT_UTL     VALID   PACKAGE

DBMS_SNAP_INTERNAL   VALID   PACKAGE

DBMS_SNAP_REPAPI         VALID   PACKAGE

DBMS_REFRESH_EXP_SITES    VALID   PACKAGE

DBMS_REFRESH_EXP_LWM      VALID   PACKAGE

DBMS_REPCAT_SNA_UTL          VALID   PACKAGE

DBMS_REPCAT_UNTRUSTED  VALID   PACKAGE

DBMS_REPCAT_ADMIN    VALID   PACKAGE

DBMS_REPCAT_FLA          VALID   PACKAGE

DBMS_REPCAT_FLA_UTL           VALID   PACKAGE

DBMS_OFFLINE_SNAPSHOT     VALID   PACKAGE

DBMS_OFFLINE_RGT_INTERNAL VALID   PACKAGE

DBMS_OFFLINE_RGT         VALID   PACKAGE

DBMS_REPCAT                    VALID  PACKAGE

DBMS_INTERNAL_REPCAT        VALID   PACKAGE

DBMS_REPCAT_AUTH       VALID   PACKAGE

DBMS_REPCAT_AUTH       VALID   PACKAGE

DBMS_REPCAT_CONF       VALID   PACKAGE

DBMS_REPCAT_MAS        VALID   PACKAGE

DBMS_REPCAT_RPC         VALID   PACKAGE

DBMS_REPCAT_RPC_UTL          VALID   PACKAGE

DBMS_REPCAT_UTL2        VALID   PACKAGE

DBMS_REPCAT_UTL3        VALID   PACKAGE

DBMS_REPCAT_UTL4        VALID   PACKAGE

DBMS_REPCAT_VALIDATE         VALID   PACKAGE

DBMSOBJGWRAPPER      VALID   PACKAGE

DBMS_REPCAT_FLA_MAS         VALID   PACKAGE

DBMS_REPCAT_RQ            VALID   PACKAGE

DBMS_REPCAT_ADD_MASTER        VALID   PACKAGE

DBMS_OFFLINE_INTERNAL       VALID   PACKAGE

DBMS_OFFLINE_UTL         VALID   PACKAGE

DBMS_OFFLINE_OG_INTERNAL  VALID  PACKAGE

DBMS_REPCAT_MIGRATION   VALID   PACKAGE

DBMS_REPCAT_MIG        VALID   PACKAGE

DBMS_RECTIFIER_DIFF    VALID   PACKAGE

DBMS_OFFLINE_OG         VALID   PACKAGE

DBMS_REPCAT_RGT        VALID   PACKAGE

DBMS_REPCAT_RGT_ALT          VALID   PACKAGE

DBMS_REPCAT_RGT_CHK         VALID   PACKAGE

DBMS_REPCAT_RGT_CUST       VALID   PACKAGE

DBMS_REPCAT_RGT_CUST2   VALID   PACKAGE

DBMS_REPCAT_RGT_UTL         VALID   PACKAGE

DBMS_REPCAT_RGT_EXP          VALID   PACKAGE

DBMS_REPCAT_INSTANTIATE   VALID  PACKAGE

DBMS_XS_SYSTEM             VALID   PACKAGE

DBMS_XS_SYSTEM_FFI     VALID   PACKAGE

DBMS_XS_FIDM                  VALID   PACKAGE

DBMS_CACHEUTIL             VALID   PACKAGE

DBMS_DST                  VALID  PACKAGE

DBMS_COMPRESSION      VALID   PACKAGE

DBMS_ILM                  VALID  PACKAGE

DBMS_ILM_ADMIN                    VALID   PACKAGE

DBMS_PARALLEL_EXECUTE     VALID   PACKAGE

DBMS_PARALLEL_EXECUTE_INT VALID   PACKAGE

ERNAL

 

DBMS_DBFS_CONTENT    VALID   PACKAGE

DBMS_DBFS_CONTENT_ADMIN   VALID  PACKAGE

DBMS_DBFS_CONTENT_SPI    VALID   PACKAGE

DBMS_FUSE                VALID  PACKAGE

DBMS_DBFS_SFS                 VALID   PACKAGE

DBMS_DBFS_SFS_ADMIN          VALID   PACKAGE

DBMS_DBFS_HS                  VALID   PACKAGE

DBMS_DNFS               VALID  PACKAGE

DBMS_ADR                 VALID  PACKAGE

DBMS_ADR_APP                 VALID   PACKAGE

DBMS_ADR_INTERNAL     VALID   PACKAGE

DBMS_XS_SESSIONS          VALID   PACKAGE

DBMS_REDACT                   VALID  PACKAGE

DBMS_SQL_TRANSLATOR          VALID   PACKAGE

DBMS_GSM_COMMON            VALID   PACKAGE

DBMS_GSM_UTILITY         VALID   PACKAGE

DBMS_GSM_NOPRIV       VALID   PACKAGE

DBMS_GSM_DBADMIN    VALID   PACKAGE

DBMS_GSM_POOLADMIN        VALID   PACKAGE

DBMS_GSM_CLOUDADMIN     VALID   PACKAGE

DBMS_GSM_ALERTS        VALID   PACKAGE

DBMS_APP_CONT              VALID   PACKAGE

DBMS_APP_CONT_PRVT           VALID   PACKAGE

DBMS_SCN                  VALID  PACKAGE

DBMS_SPD                  VALID  PACKAGE

DBMS_SPD_INTERNAL      VALID   PACKAGE

DBMS_FS                    VALID  PACKAGE

DBMS_SQL_MONITOR      VALID   PACKAGE

DBMS_PRIVILEGE_CAPTURE   VALID   PACKAGE

DBMS_PRIV_CAPTURE     VALID   PACKAGE

DBMS_SYSTEM                    VALID  PACKAGE

DBMS_PART                VALID  PACKAGE

DBMS_ROLLING                  VALID   PACKAGE

DBMS_TSDP_MANAGE     VALID   PACKAGE

DBMS_TSDP_PROTECT     VALID   PACKAGE

DBMS_INMEMORY            VALID   PACKAGE

DBMS_SQLPATCH               VALID   PACKAGE

DBMS_METADATA_INT     VALID   PACKAGE

DBMS_METADATA_UTIL   VALID   PACKAGE

DBMS_QOPATCH                VALID   PACKAGE

DBMS_PRVT_TRACE        VALID   PACKAGE

DBMS_HA_ALERTS             VALID   PACKAGE

DBMS_HA_ALERTS_PRVT          VALID   PACKAGE

DBMS_LOGREP_UTIL        VALID   PACKAGE

DBMS_LOGREP_UTIL_INVOK  VALID   PACKAGE

DBMS_LOGREP_EXP         VALID   PACKAGE

DBMS_LOGREP_IMP        VALID   PACKAGE

DBMS_LOGREP_IMP_INTERNAL  VALID  PACKAGE

DBMS_STREAMS_DATAPUMP          VALID   PACKAGE

DBMS_STREAMS_DATAPUMP_UTI VALID   PACKAGE

L

 

DBMS_RCVMAN                 VALID  PACKAGE

DBMS_BACKUP_RESTORE         VALID   PACKAGE

DBMS_RANDOM                VALID  PACKAGE

DBMS_DEBUG_JDWP      VALID   PACKAGE

DBMS_SNAPSHOT              VALID   PACKAGE

DBMS_REFRESH                  VALID   PACKAGE

DBMS_SUM_RWEQ_EXPORT_INTE VALID   PACKAGE

RNAL

 

DBMS_SUM_RWEQ_EXPORT   VALID   PACKAGE

DBMS_XRWMV                   VALID  PACKAGE

DBMS_ADVANCED_REWRITE           VALID   PACKAGE

DBMS_AQJMS            VALID  PACKAGE

DBMS_AQJMS_INTERNAL         VALID   PACKAGE

DBMS_JMS_PLSQL             VALID   PACKAGE

DBMS_AQIN               VALID  PACKAGE

DBMS_AQADM_SYS                    VALID   PACKAGE

DBMS_AQ_BQVIEW                    VALID   PACKAGE

DBMS_PRVTAQIS                VALID   PACKAGE

DBMS_PRVTAQIP                VALID   PACKAGE

DBMS_PRVTAQIM              VALID   PACKAGE

DBMS_AQADM_SYSCALLS         VALID   PACKAGE

DBMS_AQADM_INV                   VALID   PACKAGE

DBMS_PRVTSQDS               VALID   PACKAGE

DBMS_PRVTSQIS                VALID   PACKAGE

DBMS_SQADM_SYSCALLS         VALID   PACKAGE

DBMS_SERVER_ALERT_PRVT  VALID   PACKAGE

DBMS_CREDENTIAL         VALID   PACKAGE

DBMS_LOGMNR_INTERNAL     VALID   PACKAGE

DBMS_LOGMNR_LOGREP_DICT   VALID  PACKAGE

DBMS_LOGMNR_SESSION        VALID   PACKAGE

DBMS_AQ_INV                    VALID  PACKAGE

DBMS_DATA_MINING_TRANSFOR VALID   PACKAGE

M

 

DBMS_DATA_MINING       VALID   PACKAGE

DBMS_PREDICTIVE_ANALYTICS VALID   PACKAGE

DBMS_SUMVDM                VALID  PACKAGE

DBMS_AUTO_TASK            VALID   PACKAGE

DBMS_AUTO_TASK_ADMIN     VALID   PACKAGE

DBMS_AUTO_TASK_IMMEDIATE  VALID  PACKAGE

DBMS_AUTO_TASK_EXPORT   VALID   PACKAGE

DBMS_SQLTUNE_INTERNAL    VALID   PACKAGE

DBMSHSXP                  VALID   PACKAGE

DBMS_STREAMS_TBS_INT        VALID   PACKAGE

DBMS_STREAMS_TBS_INT_INVO VALID   PACKAGE

K

 

DBMS_FILE_GROUP_DECL        VALID   PACKAGE

DBMS_FILE_GROUP_UTL          VALID   PACKAGE

DBMS_FILE_GROUP_UTL_INVOK VALID   PACKAGE

DBMS_FILE_GROUP_INTERNAL_ VALID   PACKAGE

INVOK

 

DBMS_FILE_GROUP_EXP           VALID   PACKAGE

DBMS_FILE_GROUP_EXP_INTER VALID   PACKAGE

NAL

 

DBMS_FILE_GROUP_IMP          VALID   PACKAGE

DBMS_FILE_GROUP_IMP_INTER VALID   PACKAGE

NAL

 

DBMS_CMP_INT                 VALID   PACKAGE

DBMS_DEBUG_JDWP_CUSTOM      VALID   PACKAGE

DBMS_JAVA_DUMP                    VALID   PACKAGE

DBMS_LDAP               VALID  PACKAGE

DBMS_LDAP_UTL               VALID   PACKAGE

DBMS_LDAP_API_FFI        VALID   PACKAGE

DBMS_DEFERGEN_LOB    VALID   PACKAGE

DBMS_DEFERGEN_AUDIT         VALID   PACKAGE

DBMS_DEFERGEN_RESOLUTION  VALID  PACKAGE

DBMS_DEFERGEN_PRIORITY  VALID   PACKAGE

DBMS_DEFERGEN_INTERNAL          VALID   PACKAGE

DBMS_DEFERGEN_WRAP         VALID   PACKAGE

DBMS_MAINT_GEN                    VALID   PACKAGE

DBMSOBJG                 VALID  PACKAGE

DBMSOBJG2               VALID  PACKAGE

DBMSOBJG_DP                   VALID  PACKAGE

DBMS_REPCAT_SNA_INTERNAL  VALID  PACKAGE

DBMS_OFFLINE_SNAPSHOT_INT VALID   PACKAGE

ERNAL

 

DBMS_ISYNCREF                VALID   PACKAGE

DBMS_SYNC_REFRESH     VALID   PACKAGE

DBMS_REPCAT_DEFINER          VALID   PACKAGE

DBMS_REPCAT_MIG_INTERNAL  VALID  PACKAGE

DBMS_REPCAT_EXP         VALID   PACKAGE

DBMS_RECTIFIER_FRIENDS     VALID   PACKAGE

DBMS_RECTIFIER_DIFF_INTER VALID   PACKAGE

NAL

 

DBMS_NETWORK_ACL_ADMIN       VALID   PACKAGE

DBMS_NETWORK_ACL_UTILITY  VALID  PACKAGE

DBMS_WLM               VALID  PACKAGE

DBMSZEXP_SYSPKGGRNT          VALID   PACKAGE

DBMS_STAT_FUNCS_AUX          VALID   PACKAGE

DBMS_SQLPLUS_SCRIPT   VALID   PACKAGE

DBMS_PSWMG_IMPORT           VALID   PACKAGE

DBMS_CRYPTO_FFI          VALID   PACKAGE

DBMS_OBFUSCATION_TOOLKIT_ VALID   PACKAGE

FFI

 

DBMS_SERVICE_CONST   VALID   PACKAGE

DBMS_SERVICE_ERR         VALID   PACKAGE

DBMS_XS_SESSIONS_FFI   VALID   PACKAGE

DBMS_RESULT_CACHE_INTERNA VALID   PACKAGE

L

 

DBMS_WRR_INTERNAL    VALID   PACKAGE

DBMS_INTERNAL_ROLLING    VALID   PACKAGE

DBMS_REDEFINITION_INTERNA VALID   PACKAGE

L

 

DBMS_AUTOTASK_PRVT            VALID   PACKAGE

DBMS_FEATURE_USAGE_INTERN VALID   PACKAGE

AL

 

DBMS_SQLDIAG_INTERNAL    VALID   PACKAGE

DBMS_SQLTCB_INTERNAL        VALID   PACKAGE

DBMS_DM_UTIL                 VALID   PACKAGE

DBMS_DM_MODEL_EXP           VALID   PACKAGE

DBMS_DM_MODEL_IMP          VALID   PACKAGE

DBMS_DM_EXP_INTERNAL      VALID   PACKAGE

DBMS_DATA_MINING_INTERNAL VALID   PACKAGE

DBMS_APBACKEND                    VALID   PACKAGE

DBMS_ARCH_PROVIDER_INTL   VALID  PACKAGE

DBMS_LOB_AM_PRIVATE         VALID   PACKAGE

DBMS_XS_PRINCIPALS      VALID   PACKAGE

DBMS_REDACT_INT         VALID   PACKAGE

DBMS_SECUREFILE_LOG_ADMIN VALID   PACKAGE

DBMS_SQL_TRANSLATOR_EXPOR VALID   PACKAGE

T

 

DBMS_LOG                 VALID  PACKAGE

DBMS_CDC_IPUBLISH      VALID   PACKAGE

DBMS_CDC_SYS_IPUBLISH      VALID   PACKAGE

DBMS_CDC_ISUBSCRIBE           VALID   PACKAGE

DBMS_CDC_DPUTIL         VALID   PACKAGE

DBMS_CDC_IMPDP                    VALID   PACKAGE

DBMS_CDC_IMPDPV       VALID   PACKAGE

DBMS_CDC_EXPDP                     VALID   PACKAGE

DBMS_CDC_EXPVDP        VALID   PACKAGE

DBMS_PREUP             VALID  PACKAGE

DBMS_HS                   VALID  PACKAGE

DBMS_HS_ALT                     VALID  PACKAGE

DBMS_HS_CHK                   VALID  PACKAGE

DBMS_HS_UTL                    VALID  PACKAGE

DBMS_HS_PARALLEL_METADATA VALID   PACKAGE

DBMS_HS_PARALLEL         VALID   PACKAGE

DBMS_AW                  VALID  PACKAGE

DBMS_AW_EXP                   VALID  PACKAGE

DBMS_AW_STATS               VALID   PACKAGE

DBMS_CUBE_LOG              VALID   PACKAGE

DBMS_XMLSCHEMA                   VALID   PACKAGE

DBMS_XDBZ               VALID  PACKAGE

DBMS_XMLDOM                VALID  PACKAGE

DBMS_XDBRESOURCE      VALID   PACKAGE

DBMS_XDB                 VALID  PACKAGE

DBMS_XDB_CONFIG        VALID   PACKAGE

DBMS_XDB_REPOS            VALID   PACKAGE

DBMS_XDB_ADMIN                    VALID   PACKAGE

DBMS_CSX_ADMIN                     VALID   PACKAGE

DBMS_XLSB                VALID  PACKAGE

DBMS_XMLSCHEMA_LSB          VALID   PACKAGE

DBMS_XDBUTIL_INT         VALID   PACKAGE

DBMS_XDB_PRINT             VALID   PACKAGE

DBMS_XDBNFS                    VALID  PACKAGE

DBMS_CSX_INT                   VALID   PACKAGE

DBMS_XDBZ0             VALID  PACKAGE

DBMS_XMLPARSER            VALID   PACKAGE

DBMS_XSLPROCESSOR      VALID   PACKAGE

DBMS_CLOBUTIL                VALID   PACKAGE

DBMS_XMLDOM_ICD      VALID   PACKAGE

DBMS_XMLSCHEMA_INT          VALID   PACKAGE

DBMS_METADATA_HACK          VALID   PACKAGE

DBMS_XDB_VERSION       VALID   PACKAGE

DBMS_XMLINDEX              VALID   PACKAGE

DBMS_XMLINDEX0            VALID   PACKAGE

DBMS_EPG                  VALID  PACKAGE

DBMS_RESCONFIG             VALID   PACKAGE

DBMS_XEVENT                    VALID  PACKAGE

DBMS_XMLTRANSLATIONS       VALID   PACKAGE

DBMS_XDBREPOS              VALID   PACKAGE

DBMS_REGXDB                   VALID  PACKAGE

DBMS_XDB_CONSTANTS           VALID   PACKAGE

DBMS_XMLSCHEMA_ANNOTATE   VALID  PACKAGE

DBMS_XMLSTORAGE_MANAGE      VALID   PACKAGE

PRVT_DBMS_MANAGE_XMLSTORA VALID   PACKAGE

GE

 

DBMS_XDB_CONTENT      VALID   PACKAGE

DBMS_CRYPTO_TOOLKIT_TYPES VALID   PACKAGE

DBMS_CRYPTO_TOOLKIT          VALID   PACKAGE

DBMS_CRYPTO_TOOLKIT_FFI   VALID  PACKAGE

DBMS_JAVA                VALID  PACKAGE

DBMS_JAVA_DEFINERS     VALID   PACKAGE

DBMS_JAVA_MISC             VALID   PACKAGE

DBMS_JVM_EXP_PERMS           VALID   PACKAGE

DBMS_XMLQUERY             VALID   PACKAGE

DBMS_XMLSAVE                 VALID   PACKAGE

DBMS_SQLJTYPE                 VALID   PACKAGE

DBMS_XQUERYINT            VALID   PACKAGE

DBMS_XQUERY                   VALID  PACKAGE

DBMS_XDBT               VALID  PACKAGE

DBMS_CUBE_ADVISE        VALID   PACKAGE

DBMS_CUBE_ADVISE_SEC        VALID   PACKAGE

DBMS_CUBE               VALID  PACKAGE

DBMS_CUBE_EXP               VALID   PACKAGE

DBMS_AW_XML                  VALID  PACKAGE

DBMS_CUBE_UTIL             VALID   PACKAGE

WWV_DBMS_SQL               VALID   PACKAGE

DBMS_MACSEC_FUNCTION     VALID   PACKAGE

DBMS_MACOUT                 VALID  PACKAGE

DBMS_MACUTL                  VALID  PACKAGE

DBMS_MACADM                VALID  PACKAGE

DBMS_MACAUD                 VALID  PACKAGE

DBMS_MACSEC_RULES    VALID   PACKAGE

DBMS_MACSEC                  VALID  PACKAGE

DBMS_MACOLS                  VALID  PACKAGE

DBMS_MACSEC_ROLES    VALID   PACKAGE

DBMS_MACSEC_ROLE_ADMIN       VALID   PACKAGE

DBMS_MACOLS_SESSION          VALID   PACKAGE

DBMS_CLUSTDB                 VALID   PACKAGE

 

606 rows selected.

查看DBMS源码

如下：

sys@TOADDB> select text from dba_source t wheret.type='PACKAGE BODY' and name = 'DBMS_ROWID';

 

TEXT

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

package body dbms_rowid wrapped

a000000

1

abcd

abcd

abcd

abcd

abcd

abcd

abcd

abcd

abcd

abcd

abcd

abcd

abcd

abcd

abcd

b

15f9 432

gQ2jDzZiZra+vY4sS/I7LkHn+JIwg81ULtATfC/NWA/uBRvTB2GxAIiCkSnT2mUbmBLm5TMl

hFwmANK7sd851NsEWjNLCR/p84jQwYbtCN1dojHvAKb6ovnmh5215Ov5+YH+xtU+HhSoXRRE

1jT3ZxowxU7YPgrPsCAFZUmiIeW2sKLtbqmJbqWLdTdZgf+50zF4YmXVc9M+l55u2B8BjXDQ

vH5LDqQw1fgSmPXx0rgao9hnb4n7MS2OlVOdSe7VyMP6mbPBGlWPX1lAEMjRlFarrIrHFW2E

CVR9wjVRr0DluoYDPah9cljyM2dD6vGENRPy95iSWgqXV0W6Rt2RIW1n5+GjpQw28Y+57ADd

92FuHPvGWEANKhHdd6N57D1RJ46gRB/njJXPMs4TJQHk2HDG7iYNJFKobcW/FfvjuNj9N7Tj

NjisTzU8Y495qmFZBgeUEbSKi6V1NYQZGNQ7+9lU3elqWCWn2oGnoQ7snbnGGk7Ivs454diH

TetZlr2UXEO+CtSUkjPdIC1kKGjDEq5m7k1ge+dZv7l0fRLVfwQXuBa+VU9X+D/Gn7i6hQks

0HfZM2bJbqMY4b93GwvP/41MpuJqRdjEPN9o7j++oGm07jP9sHt3foxxZDGP9+2XaoUzq4Gy

rtaT/WFa5umzJAhW+SAPlD4YGdVG+q3fxevG/4r7uEOaLATqtRCT9eCG2cE/iRJ00ODQgBoA

wgL172kZwDRhkNHBqDl+wRIqoCyPn48jKwvO4Kofuy4Dyp1Vr/kgoZh9VrfrN1nUzmqLJM4S

JOTuebNOeARoUIYiknY/6bo5k/Rvcgv2wWr9YBpD3t6dNIJnLXgr1FgEW+6OgE8GqQlycKaa

bUNCRu6TKemFvzeh9vuPHt1VV0DRKL/6q99QUGX/WLO+AWVRjMwhYFnT0NrdPY84Nxa9DfFs

XurMMh2peOYWF8o003W90YOikzSKPK7Auvaf9g2H+8cOD6KlTOUlUk3sYiUyKvxUzmhrtUeP

kbjEDK4o3VuAF6NYnX6RtcmEVQWyzKOZupKsMCGaT/n7P4LhNA==

这个是加密过的了哈。