Title and Copyright Information
Preface
- Audience
- Documentation Accessibility
- Related Documents
- Conventions
Changes in This Release for Oracle Database PL/SQL Packages and Types Reference
- Changes in Oracle Database 12c Release 2 (12.2)
1 Introduction to Oracle Supplied PL/SQL Packages & Types
- 1.1 Package Overview
- 1.2 Summary of Oracle Supplied PL/SQL Packages and Types
2 Oracle Application Express Packages APEX_APPLICATION Through APEX_ZIP
3 CTX_ADM
4 CTX_ANL
5 CTX_CLS
6 CTX_DDL
7 CTX_DOC
8 CTX_ENTITY
9 CTX_OUTPUT
10 CTX_QUERY
11 CTX_REPORT
12 CTX_THES
13 CTX_ULEXER
14 DBMS_ADDM
- 14.1 DBMS_ADDM Security Model
- 14.2 Summary of DBMS_ADDM Subprograms
15 DBMS_ADVANCED_REWRITE
- 15.1 DBMS_ADVANCED_REWRITE Security Model
- 15.2 Summary of DBMS_ADVANCED_REWRITE Subprograms
16 DBMS_ADVISOR
- 16.1 DBMS_ADVISOR Deprecated Subprograms
- 16.2 DBMS_ADVISOR Security Model
- 16.3 Summary of DBMS_ADVISOR Subprograms
17 DBMS_ALERT
- 17.1 DBMS_ALERT Overview
- 17.2 DBMS_ALERT Security Model
- 17.3 DBMS_ALERT Constants
- 17.4 DBMS_ALERT Restrictions
- 17.5 DBMS_ALERT Exceptions
- 17.6 DBMS_ALERT Operational Notes
- 17.7 DBMS_ALERT Examples
- 17.8 Summary of DBMS_ALERT Subprograms
18 DBMS_APP_CONT
- 18.1 DBMS_APP_CONT Overview
- 18.2 DBMS_APP_CONT Security Model
- 18.3 Summary of DBMS_APP_CONT Subprograms
  - 18.3.1 GET_LTXID_OUTCOME Procedure
19 DBMS_APPLICATION_INFO
- 19.1 DBMS_APPLICATION_INFO Overview
- 19.2 DBMS_APPLICATION_INFO Security Model
- 19.3 DBMS_APPLICATION_INFO Operational Notes
- 19.4 Summary of DBMS_APPLICATION_INFO Subprograms
20 DBMS_APPLY_ADM
- 20.1 DBMS_APPLY_ADM Overview
- 20.2 DBMS_APPLY_ADM Security Model
- 20.3 DBMS_APPLY_ADM Deprecated Subprograms
- 20.4 Summary of DBMS_APPLY_ADM Subprograms
21 DBMS_AQ
- 21.1 DBMS_AQ Security Model
- 21.2 DBMS_AQ Constants
- 21.3 DBMS_AQ Data Types
- 21.4 DBMS_AQ Operational Notes
- 21.5 Summary of DBMS_AQ Subprograms
22 DBMS_AQADM
- 22.1 DBMS_AQADM Security Model
- 22.2 DBMS_AQADM Constants
- 22.3 DBMS_AQADM Subprogram Groups
- 22.4 Summary of DBMS_AQADM Subprograms
23 DBMS_AQELM
- 23.1 DBMS_AQELM Security Model
- 23.2 Summary of DBMS_AQELM Subprograms
24 DBMS_AQIN
- 24.1 DBMS_AQIN Security Model
25 DBMS_ASSERT
- 25.1 DBMS_ASSERT Operational Notes
- 25.2 Summary of DBMS_ASSERT Subprograms
26 DBMS_AUDIT_MGMT
- 26.1 DBMS_AUDIT_MGMT Overview
- 26.2 DBMS_AUDIT_MGMT Deprecated Subprograms
- 26.3 DBMS_AUDIT_MGMT Security Model
- 26.4 DBMS_AUDIT_MGMT Constants
- 26.5 DBMS_AUDIT_MGMT Views
- 26.6 DBMS_AUDIT_MGMT Subprogram Groups
  - 26.6.1 DBMS_AUDIT_MGMT Audit Trail Management Subprograms
  - 26.6.2 DBMS_AUDIT_MGMT Audit Trail Cleanup Subprograms
- 26.7 Summary of DBMS_AUDIT_MGMT Subprograms
27 DBMS_AUDIT_UTIL
- 27.1 DBMS_AUDIT_UTIL Overview
- 27.2 DBMS_AUDIT_UTIL Security Model
- 27.3 DBMS_AUDIT_UTIL Views
- 27.4 Summary of DBMS_AUDIT_UTIL Subprograms
28 DBMS_AUTO_REPORT
- 28.1 DBMS_AUTO_REPORT Overview
- 28.2 DBMS_AUTO_REPORT Security Model
- 28.3 Summary of DBMS_AUTO_REPORT Subprograms
29 DBMS_AUTO_SQLTUNE
- 29.1 DBMS_AUTO_SQLTUNE Overview
- 29.2 DBMS_AUTO_SQLTUNE Security Model
- 29.3 Summary of DBMS_AUTO_SQLTUNE Subprograms
30 DBMS_AUTO_TASK_ADMIN
- 30.1 DBMS_AUTO_TASK_ADMIN Deprecated Subprograms
- 30.2 DBMS_AUTO_TASK_ADMIN Security Model
- 30.3 DBMS_AUTO_TASK_ADMIN Constants
- 30.4 Summary of DBMS_AUTO_TASK_ADMIN Subprograms
31 DBMS_AW_STATS
- 31.1 Using DBMS_AW_STATS
- 31.2 Summary of DBMS_AW_STATS Subprograms
  - 31.2.1 ANALYZE Procedure
  - 31.2.2 CLEAR Procedure
32 DBMS_CAPTURE_ADM
- 32.1 DBMS_CAPTURE_ADM Overview
- 32.2 DBMS_CAPTURE_ADM Security Model
- 32.3 Summary of DBMS_CAPTURE_ADM Subprograms
33 DBMS_COMPARISON
- 33.1 DBMS_COMPARISON Overview
- 33.2 DBMS_COMPARISON Security Model
- 33.3 DBMS_COMPARISON Constants
- 33.4 DBMS_COMPARISON Views
- 33.5 DBMS_COMPARISON Operational Notes
- 33.6 DBMS_COMPARISON Data Structures
  - 33.6.1 COMPARISON_TYPE Record Type
- 33.7 Summary of DBMS_COMPARISON Subprograms
34 DBMS_COMPRESSION
- 34.1 DBMS_COMPRESSION Overview
- 34.2 DBMS_COMPRESSION Security Model
- 34.3 DBMS_COMPRESSION Constants
- 34.4 DBMS_COMPRESSION Data Structures
  - 34.4.1 COMPREC Record Type
  - 34.4.2 COMPRECLIST Table Type
- 34.5 Summary of DBMS_COMPRESSION Subprograms
  - 34.5.1 GET_COMPRESSION_RATIO Procedure
  - 34.5.2 GET_COMPRESSION_TYPE Function
35 DBMS_CONNECTION_POOL
- 35.1 Summary of DBMS_CONNECTION_POOL Subprograms
36 DBMS_CQ_NOTIFICATION
- 36.1 DBMS_CQ_NOTIFICATION Overview
- 36.2 DBMS_CQ_NOTIFICATION Security Model
- 36.3 DBMS_CQ_NOTIFICATION Constants
- 36.4 DBMS_CQ_NOTIFICATION Operational Notes
- 36.5 DBMS_CQ_NOTIFICATION Examples
- 36.6 DBMS_CQ_NOTIFICATION Data Structures
- 36.7 Summary of DBMS_CQ_NOTIFICATION Subprograms
37 DBMS_CREDENTIAL
- 37.1 DBMS_CREDENTIAL Overview
- 37.2 DBMS_CREDENTIAL Security Model
- 37.3 DBMS_CREDENTIAL Operational Notes
- 37.4 Summary of DBMS_CREDENTIAL Subprograms
38 DBMS_CRYPTO
- 38.1 DBMS_CRYPTO Overview
- 38.2 DBMS_CRYPTO Security Model
- 38.3 DBMS_CRYPTO Datatypes
- 38.4 DBMS_CRYPTO Algorithms
- 38.5 DBMS_CRYPTO Restrictions
- 38.6 DBMS_CRYPTO Exceptions
- 38.7 DBMS_CRYPTO Operational Notes
- 38.8 DBMS_CRYPTO Examples
- 38.9 Summary of DBMS_CRYPTO Subprograms
39 DBMS_CSX_ADMIN
- 39.1 DBMS_CSX_ADMIN Overview
- 39.2 DBMS_CSX_ADMIN Security Model
- 39.3 DBMS_CSX_ADMIN Constants
- 39.4 Summary of DBMS_CSX_ADMIN Subprograms
40 DBMS_CUBE
- 40.1 Using DBMS_CUBE
  - 40.1.1 DBMS_CUBE Security Model
- 40.2 Using SQL Aggregation Management
- 40.3 Upgrading 10g Analytic Workspaces
- 40.4 Summary of DBMS_CUBE Subprograms
41 DBMS_CUBE_ADVISE
- 41.1 DBMS_CUBE_ADVISE Security Model
- 41.2 Summary of DBMS_CUBE_ADVISE Subprograms
42 DBMS_CUBE_LOG
- 42.1 Using DBMS_CUBE_LOG
- 42.2 Summary of DBMS_CUBE_LOG Subprograms
43 DBMS_DATA_MINING
- 43.1 DBMS_DATA_MINING Overview
- 43.2 DBMS_DATA_MINING Security Model
- 43.3 DBMS_DATA_MINING — Mining Functions
- 43.4 DBMS_DATA_MINING — Model Settings
- 43.5 DBMS_DATA_MINING Datatypes
- 43.6 Summary of DBMS_DATA_MINING Subprograms
44 DBMS_DATA_MINING_TRANSFORM
- 44.1 DBMS_DATA_MINING_TRANSFORM Overview
- 44.2 DBMS_DATA_MINING_TRANSFORM Operational Notes
- 44.3 DBMS_DATA_MINING_TRANSFORM Security Model
- 44.4 DBMS_DATA_MINING_TRANSFORM Datatypes
- 44.5 DBMS_DATA_MINING_TRANSFORM Constants
- 44.6 Summary of DBMS_DATA_MINING_TRANSFORM Subprograms
45 DBMS_DATAPUMP
- 45.1 DBMS_DATAPUMP Overview
- 45.2 DBMS_DATAPUMP Security Model
- 45.3 DBMS_DATAPUMP Constants
- 45.4 DBMS_DATAPUMP Data Structures
- 45.5 Summary of DBMS_DATAPUMP Subprograms
46 DBMS_DB_VERSION
- 46.1 DBMS_DB_VERSION Overview
- 46.2 DBMS_DB_VERSION Constants
- 46.3 DBMS_DB_VERSION Examples
47 DBMS_DBCOMP
- 47.1 Using DBMS_DBCOMP
- 47.2 DBMS_DBCOMP Security Model
- 47.3 Summary of the DBMS_DBCOMP Subprogram
  - 47.3.1 DBCOMP Procedure
48 DBMS_DBFS_CONTENT
- 48.1 DBMS_DBFS_CONTENT Overview
- 48.2 DBMS_DBFS_CONTENT Security Model
- 48.3 DBMS_DBFS_CONTENT Constants
- 48.4 Exceptions
- 48.5 DBMS_DBFS_CONTENT Operational Notes
- 48.6 DBMS_DBFS_CONTENT Data Structures
- 48.7 Summary of DBMS_DBFS_CONTENT Subprograms
49 DBMS_DBFS_CONTENT_SPI
- 49.1 ODBMS_DBFS_CONTENT_SPI Overview
- 49.2 DBMS_DBFS_CONTENT_SPI Security Model
- 49.3 DBMS_DBFS_CONTENT_SPI Operational Notes
- 49.4 Summary of DBMS_DBFS_CONTENT_SPI Subprograms
50 DBMS_DBFS_HS
- 50.1 DBMS_DBFS_HS Overview
- 50.2 DBMS_DBFS_HS Security Model
- 50.3 DBMS_DBFS_HS Constants
- 50.4 DBMS_DBFS_HS Operational Notes
- 50.5 Summary of DBMS_DBFS_HS Subprograms
51 DBMS_DBFS_SFS
- 51.1 DBMS_DBFS_SFS Overview
- 51.2 DBMS_DBFS_SFS Security Model
- 51.3 DBMS_DBFS_SFS Constants
- 51.4 Summary of DBMS_DBFS_SFS Subprograms
52 DBMS_DDL
- 52.1 DBMS_DDL Deprecated Subprograms
- 52.2 DBMS_DDL Security Model
- 52.3 DBMS_DDL Operational Notes
- 52.4 Summary of DBMS_DDL Subprograms
53 DBMS_DEBUG
- 53.1 DBMS_DEBUG Overview
- 53.2 DBMS_DEBUG Constants
- 53.3 DBMS_DEBUG Variables
- 53.4 DBMS_DEBUG Exceptions
- 53.5 DBMS_DEBUG Operational Notes
- 53.6 DBMS_DEBUG Data Structures
- 53.7 Summary of DBMS_DEBUG Subprograms
54 DBMS_DEBUG_JDWP
- 54.1 DBMS_DEBUG_JDWP Overview
- 54.2 DBMS_DEBUG_JDWP Security Model
- 54.3 Summary DBMS_DEBUG_JDWP Subprograms
55 DBMS_DEBUG_JDWP_CUSTOM
- 55.1 DBMS_DEBUG_JDWP_CUSTOM Overview
- 55.2 DBMS_DEBUG_JDWP_CUSTOM Security Model
- 55.3 Summary DBMS_DEBUG_JDWP_CUSTOM Subprograms
  - 55.3.1 CONNECT_DEBUGGER Procedure
56 DBMS_DESCRIBE
- 56.1 DBMS_DESCRIBE Overview
- 56.2 DBMS_DESCRIBE Security Model
- 56.3 DBMS_DESCRIBE Types
- 56.4 DBMS_DESCRIBE Exceptions
- 56.5 DBMS_DESCRIBE Examples
- 56.6 Summary of DBMS_DESCRIBE Subprograms
  - 56.6.1 DESCRIBE_PROCEDURE Procedure
57 DBMS_DG
- 57.1 Using DBMS_DG
- 57.2 DBMS_DG Security Model
- 57.3 Summary of the DBMS_DG Subprogram
  - 57.3.1 INITIATE_FS_FAILOVER Procedure
58 DBMS_DIMENSION
- 58.1 DBMS_DIMENSION Security Model
- 58.2 Summary of DBMS_DIMENSION Subprograms
  - 58.2.1 DESCRIBE_DIMENSION Procedure
  - 58.2.2 VALIDATE_DIMENSION Procedure
59 DBMS_DISTRIBUTED_TRUST_ADMIN
- 59.1 DBMS_DISTRIBUTED_TRUST_ADMIN Overview
- 59.2 DBMS_DISTRIBUTED_TRUST_ADMIN Security Model
- 59.3 DBMS_DISTRIBUTED_TRUST_ADMIN Examples
- 59.4 Summary of DBMS_DISTRIBUTED_TRUST_ADMIN Subprograms
60 DBMS_DNFS
- 60.1 DBMS_DNFS Security Model
- 60.2 Summary of DBMS_DNFS Subprograms
61 DBMS_DST
- 61.1 DBMS_DST Overview
- 61.2 DBMS_DST Security Model
- 61.3 DBMS_DST Views
- 61.4 Summary of DBMS_DST Subprograms
62 DBMS_EDITIONS_UTILITIES
- 62.1 DBMS_EDITIONS_UTILITIES Overview
- 62.2 DBMS_EDITIONS_UTILITIES Security Model
- 62.3 DBMS_EDITIONS_UTILITIES Exceptions
- 62.4 Summary of DBMS_EDITIONS_UTILITIES Subprograms
  - 62.4.1 SET_EDITIONING_VIEWS_READ_ONLY Procedure
  - 62.4.2 SET_NULL_COLUMN_VALUES_TO_EXPR Procedure
63 DBMS_EPG
- 63.1 DBMS_EPG Overview
- 63.2 DBMS_EPG Security Model
- 63.3 DBMS_EPG Exceptions
- 63.4 DBMS_EPG Data Structures
- 63.5 DBMS_EPG Subprogram Groups
  - 63.5.1 DBMS_EPG Configuration Subprograms
  - 63.5.2 DBMS_EPG Authorization Subprograms
- 63.6 Summary of DBMS_EPG Subprograms
64 DBMS_ERRLOG
- 64.1 DBMS_ERRLOG Security Model
- 64.2 Summary of DBMS_ERRLOG Subprograms
  - 64.2.1 CREATE_ERROR_LOG Procedure
65 DBMS_FGA
- 65.1 DBMS_FGA Security Model
- 65.2 DBMS_FGA Operational Notes
- 65.3 Summary of DBMS_FGA Subprograms
66 DBMS_FILE_GROUP
- 66.1 DBMS_FILE_GROUP Overview
- 66.2 DBMS_FILE_GROUP Security Model
- 66.3 DBMS_FILE_GROUP Constants
- 66.4 DBMS_FILE_GROUP Examples
- 66.5 Summary of DBMS_FILE_GROUP Subprograms
67 DBMS_FILE_TRANSFER
- 67.1 DBMS_FILE_TRANSFER Overview
- 67.2 DBMS_FILE_TRANSFER Security Model
- 67.3 DBMS_FILE_TRANSFER Operational Notes
- 67.4 Summary of DBMS_FILE_TRANSFER Subprograms
68 DBMS_FLASHBACK
- 68.1 DBMS_FLASHBACK Overview
- 68.2 DBMS_FLASHBACK Security Model
- 68.3 DBMS_FLASHBACK Types
- 68.4 DBMS_FLASHBACK Exceptions
- 68.5 DBMS_FLASHBACK Operational Notes
- 68.6 DBMS_FLASHBACK Examples
- 68.7 Summary of DBMS_FLASHBACK Subprograms
69 DBMS_FLASHBACK_ARCHIVE
- 69.1 DBMS_FLASHBACK_ARCHIVE Overview
- 69.2 DBMS_FLASHBACK_ARCHIVE Security Model
- 69.3 DBMS_FLASHBACK_ARCHIVE Constants
- 69.4 Summary of DBMS_FLASHBACK_ARCHIVE Subprograms
70 DBMS_FREQUENT_ITEMSET
- 70.1 Summary of DBMS_FREQUENT_ITEMSET Subprograms
  - 70.1.1 FI_HORIZONTAL Function
  - 70.1.2 FI_TRANSACTIONAL Function
71 DBMS_FS
- 71.1 DBMS_FS Overview
- 71.2 DBMS_FS Security Model
- 71.3 Summary of DBMS_FS Subprograms
72 DBMS_GOLDENGATE_ADM
- 72.1 Using DBMS_GOLDENGATE_ADM
  - 72.1.1 DBMS_GOLDENGATE_ADM Overview
  - 72.1.2 DBMS_GOLDENGATE_ADM Security Model
- 72.2 Summary of DBMS_GOLDENGATE_ADM Subprograms
73 DBMS_GOLDENGATE_AUTH
- 73.1 DBMS_GOLDENGATE_AUTH Overview
- 73.2 DBMS_GOLDENGATE_AUTH Security Model
- 73.3 Summary of DBMS_GOLDENGATE_AUTH Subprograms
  - 73.3.1 GRANT_ADMIN_PRIVILEGE Procedure
  - 73.3.2 REVOKE_ADMIN_PRIVILEGE Procedure
74 DBMS_HADOOP
- 74.1 DBMS_HADOOP Overview
- 74.2 DBMS_HADOOP Security Model
- 74.3 Summary of DBMS_HADOOP Subprograms
  - 74.3.1 CREATE_EXTDDL_FOR_HIVE Procedure
  - 74.3.2 SYNCHRONIZE_PARTITIONS_FOR_HIVE Procedure
75 DBMS_HANG_MANAGER
- 75.1 DBMS_HANG_MANAGER Overview
- 75.2 DBMS_HANG_MANAGER Security Model
- 75.3 DBMS_HANG_MANAGER Constants
- 75.4 DBMS_HANG_MANAGER Exceptions
- 75.5 Summary of DBMS_HANG_MANAGER Subprograms
  - 75.5.1 SET Procedure
76 DBMS_HEAT_MAP
- 76.1 DBMS_HEAT_MAP Overview
- 76.2 DBMS_HEAT_MAP Security Model
- 76.3 Summary of DBMS_HEAT_MAP Subprograms
77 DBMS_HIERARCHY
- 77.1 DBMS_HIERARCHY Overview
- 77.2 DBMS_HIERARCHY Security Model
- 77.3 Summary of DBMS_HIERARCHY Subprograms
78 DBMS_HM
- 78.1 DBMS_HM Security Model
- 78.2 Summary of DBMS_HM Subprograms
  - 78.2.1 GET_RUN_REPORT Function
  - 78.2.2 RUN_CHECK Procedure
79 DBMS_HPROF
- 79.1 Summary of DBMS_HPROF Subprograms
80 DBMS_HS_PARALLEL
- 80.1 Using the DBMS_HS_PARALLEL Subprogram
- 80.2 Summary of DBMS_HS_PARALLEL Subprograms
81 DBMS_HS_PASSTHROUGH
- 81.1 DBMS_HS_PASSTHROUGH Overview
- 81.2 DBMS_HS_PASSTHROUGH Operational Notes
- 81.3 Summary of DBMS_HS_PASSTHROUGH Subprograms
82 DBMS_ILM
- 82.1 DBMS_ILM Overview
- 82.2 DBMS_ILM Security Model
- 82.3 DBMS_ILM Constants
- 82.4 DBMS_ILM Exceptions
- 82.5 Summary of DBMS_ILM Subprograms
83 DBMS_ILM_ADMIN
- 83.1 DBMS_ILM_ADMIN Overview
- 83.2 DBMS_ILM_ADMIN Security Model
- 83.3 DBMS_ILM_ADMIN Constants
- 83.4 Summary of DBMS_ILM_ADMIN Subprograms
84 DBMS_INMEMORY
- 84.1 DBMS_INMEMORY Overview
- 84.2 DBMS_INMEMORY Security Model
- 84.3 Summary of DBMS_INMEMORY Subprograms
85 DBMS_INMEMORY_ADMIN
- 85.1 DBMS_INMEMORY_ADMIN Overview
- 85.2 DBMS_INMEMORY_ADMIN Security Model
- 85.3 DBMS_INMEMORY_ADMIN Operational Notes
- 85.4 Summary of DBMS_INMEMORY_ADMIN Subprograms
86 DBMS_IOT
- 86.1 Summary of DBMS_IOT Subprograms
  - 86.1.1 BUILD_CHAIN_ROWS_TABLE Procedure
  - 86.1.2 BUILD_EXCEPTIONS_TABLE Procedure
87 DBMS_JAVA
88 DBMS_JOB
- 88.1 DBMS_JOB Security Model
- 88.2 DBMS_JOB Operational Notes
- 88.3 Summary of DBMS_JOB Subprograms
89 DBMS_JSON
- 89.1 DBMS_JSON Overview
- 89.2 DBMS_JSON Security Model
- 89.3 DBMS_JSON Constants
- 89.4 Summary of DBMS_JSON Subprograms
90 DBMS_LDAP
91 DBMS_LDAP_UTL
92 DBMS_LIBCACHE
- 92.1 DBMS_LIBCACHE Overview
- 92.2 DBMS_LIBCACHE Security Model
- 92.3 Summary of DBMS_LIBCACHE Subprograms
  - 92.3.1 COMPILE_FROM_REMOTE Procedure
93 DBMS_LOB
- 93.1 DBMS_LOB Overview
- 93.2 DBMS_LOB Deprecated Subprograms
- 93.3 DBMS_LOB Security Model
- 93.4 DBMS_LOB Constants
- 93.5 DBMS_LOB Datatypes
- 93.6 DBMS_LOB Operational Notes
- 93.7 DBMS_LOB Rules and Limits
- 93.8 DBMS_LOB Exceptions
- 93.9 Summary of DBMS_LOB Subprograms
94 DBMS_LOCK
- 94.1 DBMS_LOCK Overview
- 94.2 DBMS_LOCK Security Model
- 94.3 DBMS_LOCK Constants
- 94.4 DBMS_LOCK. Rules and Limits
- 94.5 DBMS_LOCK Operational Notes
- 94.6 Summary of DBMS_LOCK Subprograms
95 DBMS_LOGMNR
- 95.1 DBMS_LOGMNR Overview
- 95.2 DBMS_LOGMNR Security Model
- 95.3 DBMS_LOGMNR Constants
- 95.4 DBMS_LOGMNR Views
- 95.5 DBMS_LOGMNR Operational Notes
- 95.6 Summary of DBMS_LOGMNR Subprograms
96 DBMS_LOGMNR_D
- 96.1 DBMS_LOGMNR_D Overview
- 96.2 DBMS_LOGMNR_D Security Model
- 96.3 Summary of DBMS_LOGMNR_D Subprograms
  - 96.3.1 BUILD Procedure
  - 96.3.2 SET_TABLESPACE Procedure
97 DBMS_LOGSTDBY
- 97.1 DBMS_LOGSTDBY Overview
- 97.2 DBMS_LOGSTDBY Security Model
- 97.3 DBMS_LOGSTDBY Constants
- 97.4 Summary of DBMS_LOGSTDBY Subprograms
98 DBMS_LOGSTDBY_CONTEXT
- 98.1 DBMS_LOGSTDBY_CONTEXT Overview
- 98.2 DBMS_LOGSTDBY_CONTEXT Security Model
- 98.3 Summary of DBMS_LOGSTDBY_CONTEXT Subprograms
99 DBMS_METADATA
- 99.1 DBMS_METADATA Overview
- 99.2 DBMS_METADATA Security Model
- 99.3 Rules and Limits
- 99.4 DBMS_METADATA Data Structures - Object and Table Types
- 99.5 DBMS_METADATA Subprogram Groupings
  - 99.5.1 DBMS_METADATA Subprograms for Retrieving Multiple Objects From the Database
  - 99.5.2 DBMS_METADATA Subprograms for Submitting XML to the Database
- 99.6 Summary of All DBMS_METADATA Subprograms
100 DBMS_METADATA_DIFF
- 100.1 DBMS_METADATA_DIFF Overview
- 100.2 DBMS_METADATA_DIFF Security Model
- 100.3 DBMS_METADATA_DIFF — Browsing APIs for Fetching and Comparing Objects
- 100.4 Summary of DBMS_METADATA_DIFF Subprograms
101 DBMS_MGD_ID_UTL
- 101.1 DBMS_MGD_ID_UTL Security Model
- 101.2 DBMS_MGD_ID_UTL Constants
- 101.3 DBMS_MGD_ID_UTL Exceptions
- 101.4 Summary of DBMS_MGD_ID_UTL Subprograms
102 DBMS_MGWADM
- 102.1 DBMS_MGWADM Security Model
- 102.2 DBMS_MGWADM Deprecated Subprograms
- 102.3 DBMS_MGWADM Constants
- 102.4 DBMS_MGWADM Data Structures
- 102.5 Summary of DBMS_MGWADM Subprograms
103 DBMS_MGWMSG
- 103.1 DBMS_MGWMSG Security Model
- 103.2 DBMS_MGWMSG Constants
- 103.3 DBMS_MGWMSG Types
- 103.4 Summary of DBMS_MGWMSG Subprograms
104 DBMS_MONITOR
- 104.1 Summary of DBMS_MONITOR Subprograms
105 DBMS_MVIEW
- 105.1 DBMS_MVIEW Operational Notes
- 105.2 DBMS_MVIEW Security Model
- 105.3 DBMS_MVIEW Rules and Limits
- 105.4 Summary of DBMS_MVIEW Subprograms
106 DBMS_MVIEW_STATS
- 106.1 DBMS_MVIEW_STATS Overview
- 106.2 DBMS_MVIEW_STATS Security Model
- 106.3 Summary of DBMS_MVIEW_STATS Subprograms
107 DBMS_NETWORK_ACL_ADMIN
- 107.1 DBMS_NETWORK_ACL_ADMIN Overview
- 107.2 DBMS_NETWORK_ACL_ADMIN Deprecated Subprograms
- 107.3 DBMS_NETWORK_ACL_ADMIN Security Model
- 107.4 DBMS_NETWORK_ACL_ADMIN Constants
- 107.5 DBMS_NETWORK_ACL_ADMIN Exceptions
- 107.6 DBMS_NETWORK_ACL_ADMIN Examples
- 107.7 Summary of DBMS_NETWORK_ACL_ADMIN Subprograms
108 DBMS_NETWORK_ACL_UTILITY
- 108.1 DBMS_NETWORK_ACL_UTILITY Security Model
- 108.2 DBMS_NETWORK_ACL_UTILITY Examples
- 108.3 Summary of DBMS_NETWORK_ACL_UTILITY Subprograms
109 DBMS_ODCI
- 109.1 Summary of DBMS_ODCI Subprograms
  - 109.1.1 ESTIMATE_CPU_UNITS Function
110 DBMS_OUTLN
- 110.1 DBMS_OUTLN Overview
- 110.2 DBMS_OUTLN Security Model
- 110.3 Summary of DBMS_OUTLN Subprograms
111 DBMS_OUTPUT
- 111.1 DBMS_OUTPUT Overview
- 111.2 DBMS_OUTPUT Security Model
- 111.3 DBMS_OUTPUT Operational Notes
- 111.4 DBMS_OUTPUT Exceptions
- 111.5 DBMS_OUTPUT Rules and Limits
- 111.6 DBMS_OUTPUT Examples
- 111.7 DBMS_OUTPUT Data Structures
  - 111.7.1 CHARARR Table Type
  - 111.7.2 DBMS_OUTPUT DBMSOUTPUT_LINESARRAY Object Type
- 111.8 Summary of DBMS_OUTPUT Subprograms
112 DBMS_PARALLEL_EXECUTE
- 112.1 DBMS_PARALLEL_EXECUTE Overview
- 112.2 DBMS_PARALLEL_EXECUTE Security Model
- 112.3 DBMS_PARALLEL_EXECUTE Constants
- 112.4 DBMS_PARALLEL_EXECUTE Views
- 112.5 DBMS_PARALLEL_EXECUTE Exceptions
- 112.6 DBMS_PARALLEL_EXECUTE Examples
- 112.7 Summary of DBMS_PARALLEL_EXECUTE Subprograms
113 DBMS_PART
- 113.1 DBMS_PART Security Model
- 113.2 DBMS_PART Operational Notes
- 113.3 Summary of DBMS_PART Subprograms
  - 113.3.1 CLEANUP_GIDX Procedure
  - 113.3.2 CLEANUP_ONLINE_OP Procedure
114 DBMS_PCLXUTIL
- 114.1 DBMS_PCLXUTIL Overview
- 114.2 DBMS_PCLXUTIL Security Model
- 114.3 DBMS_PCLXUTIL Operational Notes
- 114.4 DBMS_PCLXUTIL Rules and Limits
- 114.5 Summary of DBMS_PCLXUTIL Subprograms
  - 114.5.1 BUILD_PART_INDEX Procedure
115 DBMS_PDB
- 115.1 DBMS_PDB Overview
- 115.2 DBMS_PDB Security Model
- 115.3 Summary of DBMS_PDB Subprograms
116 DBMS_PDB_ALTER_SHARING
- 116.1 DBMS_PDB_ALTER_SHARING Overview
- 116.2 DBMS_PDB_ALTER_SHARING Security Model
- 116.3 Summary of DBMS_PDB_ALTER_SHARING Subprograms
117 DBMS_PERF
- 117.1 DBMS_PERF Overview
- 117.2 DBMS_PERF Security Model
- 117.3 Summary of DBMS_PERF Subprograms
118 DBMS_PIPE
- 118.1 DBMS_PIPE Overview
- 118.2 DBMS_PIPE Security Model
- 118.3 DBMS_PIPE Constants
- 118.4 DBMS_PIPE Operational Notes
- 118.5 DBMS_PIPE Exceptions
- 118.6 DBMS_PIPE Examples
- 118.7 Summary of DBMS_PIPE Subprograms
119 DBMS_PLSQL_CODE_COVERAGE
- 119.1 DBMS_PLSQL_CODE_COVERAGE Overview
- 119.2 DBMS_PLSQL_CODE_COVERAGE Security Model
- 119.3 Summary of DBMS_PLSQL_CODE_COVERAGE Subprograms
120 DBMS_PREDICTIVE_ANALYTICS
- 120.1 DBMS_PREDICTIVE_ANALYTICS Overview
- 120.2 DBMS_PREDICTIVE_ANALYTICS Security Model
- 120.3 Summary of DBMS_PREDICTIVE_ANALYTICS Subprograms
121 DBMS_PREPROCESSOR
- 121.1 DBMS_PREPROCESSOR Overview
- 121.2 DBMS_PREPROCESSOR Operating Notes
- 121.3 DBMS_PREPROCESSOR Data Structures
  - 121.3.1 DBMS_PREPROCESSOR SOURCE_LINES_T Table Type
- 121.4 Summary of DBMS_PREPROCESSOR Subprograms
  - 121.4.1 GET_POST_PROCESSED_SOURCE Functions
  - 121.4.2 PRINT_POST_PROCESSED_SOURCE Procedures
122 DBMS_PRIVILEGE_CAPTURE
- 122.1 DBMS_PRIVILEGE_CAPTURE Overview
- 122.2 DBMS_PRIVILEGE_CAPTURE Security Model
- 122.3 DBMS_PRIVILEGE_CAPTURE Constants
- 122.4 DBMS_PRIVILEGE_CAPTURE Examples
- 122.5 Summary of DBMS_PRIVILEGE_CAPTURE Subprograms
123 DBMS_PROCESS
- 123.1 DBMS_PROCESS Overview
- 123.2 DBMS_PROCESS Security Model
- 123.3 Summary of DBMS_PROCESS Subprograms
124 DBMS_PROFILER
- 124.1 DBMS_PROFILER Overview
- 124.2 DBMS_PROFILER Security Model
- 124.3 DBMS_PROFILER Operational Notes
- 124.4 DBMS_PROFILER Exceptions
- 124.5 Summary of DBMS_PROFILER Subprograms
125 DBMS_PROPAGATION_ADM
- 125.1 DBMS_PROPAGATION_ADM Overview
- 125.2 DBMS_PROPAGATION_ADM Security Model
- 125.3 Summary of DBMS_PROPAGATION_ADM Subprograms
126 DBMS_QOPATCH
- 126.1 DBMS_QOPATCH Overview
- 126.2 DBMS_QOPATCH Security Model
- 126.3 DBMS_QOPATCH Operational Notes
- 126.4 DBMS_QOPATCH Exceptions
- 126.5 Summary of DBMS_QOPATCH Subprograms
127 DBMS_RANDOM
- 127.1 DBMS_RANDOM Deprecated Subprograms
- 127.2 DBMS_RANDOM Security Model
- 127.3 DBMS_RANDOM Operational Notes
- 127.4 Summary of DBMS_RANDOM Subprograms
128 DBMS_REDACT
- 128.1 DBMS_REDACT Overview
- 128.2 DBMS_REDACT Security Model
- 128.3 DBMS_REDACT Constants
- 128.4 DBMS_REDACT Operating Procedures
- 128.5 Summary of DBMS_REDACT Subprograms
129 DBMS_REDEFINITION
- 129.1 DBMS_REDEFINITION Overview
- 129.2 DBMS_REDEFINITION Security Model
- 129.3 DBMS_REDEFINITION Constants
- 129.4 DBMS_REDEFINITION Operational Notes
- 129.5 DBMS_REDEFINITION Rules and Limits
- 129.6 DBMS_REDEFINITION Examples
- 129.7 Summary of DBMS_REDEFINITION Subprograms
130 DBMS_REFRESH
- 130.1 DBMS_REFRESH Overview
- 130.2 DBMS_REFRESH Security Model
- 130.3 Summary of DBMS_REFRESH Subprograms
131 DBMS_REPAIR
- 131.1 DBMS_REPAIR Overview
- 131.2 DBMS_REPAIR Security Model
- 131.3 DBMS_REPAIR Constants
- 131.4 DBMS_REPAIR Operating Notes
- 131.5 DBMS_REPAIR Exceptions
- 131.6 DBMS_REPAIR Examples
- 131.7 Summary of DBMS_REPAIR Subprograms
132 DBMS_RESCONFIG
- 132.1 DBMS_RESCONFIG Overview
- 132.2 Summary of DBMS_RESCONFIG Subprograms
133 DBMS_RESOURCE_MANAGER
- 133.1 DBMS_RESOURCE_MANAGER Deprecated Subprograms
- 133.2 DBMS_RESOURCE_MANAGER Security Model
- 133.3 DBMS_RESOURCE_MANAGER Constants
- 133.4 Summary of DBMS_RESOURCE_MANAGER Subprograms
134 DBMS_RESOURCE_MANAGER_PRIVS
- 134.1 Summary of DBMS_RESOURCE_MANAGER_PRIVS Subprograms
135 DBMS_RESULT_CACHE
- 135.1 DBMS_RESULT_CACHE Security Model
- 135.2 DBMS_RESULT_CACHE Constants
- 135.3 Summary of DBMS_RESULT_CACHE Subprograms
136 DBMS_RESUMABLE
- 136.1 DBMS_RESUMABLE Operational Notes
- 136.2 Summary of DBMS_RESUMABLE Subprograms
137 DBMS_RLS
- 137.1 DBMS_RLS Overview
- 137.2 DBMS_RLS Security Model
- 137.3 DBMS_RLS Constants
- 137.4 DBMS_RLS Operational Notes
- 137.5 DBMS_RLS Rules and Limits
- 137.6 Summary of DBMS_RLS Subprograms
138 DBMS_ROLLING
- 138.1 DBMS_ROLLING Overview
- 138.2 DBMS_ROLLING Security Model
- 138.3 Summary of DBMS_ROLLING Subprograms
139 DBMS_ROWID
- 139.1 DBMS_ROWID Security Model
- 139.2 DBMS_ROWID Types
- 139.3 DBMS_ROWID Exceptions
- 139.4 DBMS_ROWID Operational Notes
- 139.5 DBMS_ROWID Examples
- 139.6 Summary of DBMS_ROWID Subprograms
140 DBMS_RULE
- 140.1 DBMS_RULE Overview
- 140.2 DBMS_RULE Security Model
- 140.3 Summary of DBMS_RULE Subprograms
141 DBMS_RULE_ADM
- 141.1 DBMS_RULE_ADM Overview
- 141.2 DBMS_RULE_ADM Security Model
- 141.3 Summary of DBMS_RULE_ADM Subprograms
142 DBMS_SCHEDULER
- 142.1 DBMS_SCHEDULER Deprecated Subprograms
- 142.2 DBMS_SCHEDULER Security Model
- 142.3 DBMS_SCHEDULER Rules and Limits
- 142.4 DBMS_SCHEDULER Operational Notes
- 142.5 DBMS_SCHEDULER Data Structures
- 142.6 Summary of DBMS_SCHEDULER Subprograms
143 DBMS_SERVER_ALERT
- 143.1 DBMS_SERVER_ALERT Security Model
- 143.2 DBMS_SERVER_ALERT Object Types
- 143.3 DBMS_SERVER_ALERT Relational Operators
- 143.4 DBMS_SERVER_ALERT Supported Metrics
- 143.5 Summary of DBMS_SERVER_ALERT Subprograms
144 DBMS_SERVICE
- 144.1 DBMS_SERVICE Overview
- 144.2 DBMS_SERVICE Security Model
- 144.3 DBMS_SERVICE Constants
- 144.4 DBMS_SERVICE Operating Procedures
- 144.5 DBMS_SERVICE Exceptions
- 144.6 Summary of DBMS_SERVICE Subprograms
145 DBMS_SESSION
- 145.1 DBMS_SESSION Security Model
- 145.2 DBMS_SESSION Operational Notes
- 145.3 DBMS_SESSION Data Structures
  - 145.3.1 DBMS_SERVICE INTEGER_ARRAY Table Type
  - 145.3.2 DBMS_SERVICE LNAME_ARRAY Table Type
- 145.4 Summary of DBMS_SESSION Subprograms
146 DBMS_SFW_ACL_ADMIN
- 146.1 DBMS_SFW_ACL_ADMIN Security Model
- 146.2 DBMS_SFW_ACL_ADMIN Operational Notes
- 146.3 DBMS_SFW_ACL_ADMIN Examples
- 146.4 Summary of DBMS_SFW_ACL_ADMIN Subprograms
147 DBMS_SHARED_POOL
- 147.1 DBMS_SHARED_POOL Overview
- 147.2 DBMS_SHARED_POOL Operational Notes
- 147.3 Summary of DBMS_SHARED_POOL Subprograms
148 DBMS_SPACE
- 148.1 DBMS_SPACE Security Model
- 148.2 DBMS_SPACE Data Structures
- 148.3 Summary of DBMS_SPACE Subprograms
149 DBMS_SPACE_ADMIN
- 149.1 DBMS_SPACE_ADMIN Security Model
- 149.2 DBMS_SPACE_ADMIN Constants
- 149.3 DBMS_SPACE_ADMIN Operational Notes
- 149.4 Summary of DBMS_SPACE_ADMIN Subprograms
150 DBMS_SPD
- 150.1 DBMS_SPD Overview
- 150.2 DBMS_SPD Security Model
- 150.3 DBMS_SPD Views
- 150.4 Summary of DBMS_SPD Subprograms
151 DBMS_SPM
- 151.1 DBMS_SPM Overview
- 151.2 DBMS_SPM Security Model
- 151.3 DBMS_SPM Constants
- 151.4 DBMS_SPM Examples
- 151.5 DBMS_SPM Data Structures
  - 151.5.1 DBMS_SPM NAMELIST Table Type
- 151.6 Summary of DBMS_SPM Subprograms
152 DBMS_SQL
- 152.1 DBMS_SQL Overview
- 152.2 DBMS_SQL Security Model
- 152.3 DBMS_SQL Constants
- 152.4 DBMS_SQL Operational Notes
- 152.5 DBMS_SQL Execution Flow
- 152.6 DBMS_SQL Exceptions
- 152.7 DBMS_SQL Examples
- 152.8 DBMS_SQL Data Structures
- 152.9 Summary of DBMS_SQL Subprograms
153 DBMS_SQL_MONITOR
- 153.1 DBMS_SQL_MONITOR Overview
- 153.2 DBMS_SQL_MONITOR Security Model
- 153.3 DBMS_SQL_MONITOR Constants
- 153.4 Summary of DBMS_SQL_MONITOR Subprograms
  - 153.4.1 BEGIN_OPERATION Function