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 Release 21c, Version 21.1
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_ACTIVITY
- 14.1 Using DBMS_ACTIVITY
- 14.2 Summary of DBMS_ACTIVITY Subprograms
15 DBMS_ADDM
- 15.1 DBMS_ADDM Security Model
- 15.2 Summary of DBMS_ADDM Subprograms
16 DBMS_ADVANCED_REWRITE
- 16.1 DBMS_ADVANCED_REWRITE Security Model
- 16.2 Summary of DBMS_ADVANCED_REWRITE Subprograms
17 DBMS_ADVISOR
- 17.1 DBMS_ADVISOR Deprecated Subprograms
- 17.2 DBMS_ADVISOR Security Model
- 17.3 Summary of DBMS_ADVISOR Subprograms
18 DBMS_ALERT
- 18.1 DBMS_ALERT Overview
- 18.2 DBMS_ALERT Security Model
- 18.3 DBMS_ALERT Constants
- 18.4 DBMS_ALERT Restrictions
- 18.5 DBMS_ALERT Exceptions
- 18.6 DBMS_ALERT Operational Notes
- 18.7 DBMS_ALERT Examples
- 18.8 Summary of DBMS_ALERT Subprograms
19 DBMS_APP_CONT
- 19.1 DBMS_APP_CONT Overview
- 19.2 DBMS_APP_CONT Security Model
- 19.3 Summary of DBMS_APP_CONT Subprograms
20 DBMS_APP_CONT_ADMIN
- 20.1 DBMS_APP_CONT_ADMIN Security Model
- 20.2 Summary of DBMS_APP_CONT_ADMIN Subprograms
21 DBMS_APP_CONT_REPORT
- 21.1 DBMS_APP_CONT_REPORT Security Model
- 21.2 Summary of DBMS_APP_CONT_REPORT Subprograms
  - 21.2.1 ACCHK_REPORT Procedure
22 DBMS_APPLICATION_INFO
- 22.1 DBMS_APPLICATION_INFO Overview
- 22.2 DBMS_APPLICATION_INFO Security Model
- 22.3 DBMS_APPLICATION_INFO Operational Notes
- 22.4 Summary of DBMS_APPLICATION_INFO Subprograms
23 DBMS_APPLY_ADM
- 23.1 DBMS_APPLY_ADM Overview
- 23.2 DBMS_APPLY_ADM Security Model
- 23.3 DBMS_APPLY_ADM Deprecated Subprograms
- 23.4 Summary of DBMS_APPLY_ADM Subprograms
24 DBMS_AQ
- 24.1 DBMS_AQ Security Model
- 24.2 DBMS_AQ Constants
- 24.3 DBMS_AQ Data Types
- 24.4 DBMS_AQ Operational Notes
- 24.5 Summary of DBMS_AQ Subprograms
25 DBMS_AQADM
- 25.1 DBMS_AQADM Security Model
- 25.2 DBMS_AQADM Constants
- 25.3 DBMS_AQADM Subprogram Groups
- 25.4 Summary of DBMS_AQADM Subprograms
26 DBMS_AQELM
- 26.1 DBMS_AQELM Security Model
- 26.2 Summary of DBMS_AQELM Subprograms
27 DBMS_AQIN
- 27.1 DBMS_AQIN Security Model
28 DBMS_ASSERT
- 28.1 DBMS_ASSERT Operational Notes
- 28.2 Summary of DBMS_ASSERT Subprograms
29 DBMS_AUDIT_MGMT
- 29.1 DBMS_AUDIT_MGMT Overview
- 29.2 DBMS_AUDIT_MGMT Deprecated Subprograms
- 29.3 DBMS_AUDIT_MGMT Security Model
- 29.4 DBMS_AUDIT_MGMT Constants
- 29.5 DBMS_AUDIT_MGMT Views
- 29.6 DBMS_AUDIT_MGMT Subprogram Groups
  - 29.6.1 DBMS_AUDIT_MGMT Audit Trail Management Subprograms
  - 29.6.2 DBMS_AUDIT_MGMT Audit Trail Cleanup Subprograms
- 29.7 Summary of DBMS_AUDIT_MGMT Subprograms
30 DBMS_AUDIT_UTIL
- 30.1 DBMS_AUDIT_UTIL Overview
- 30.2 DBMS_AUDIT_UTIL Security Model
- 30.3 DBMS_AUDIT_UTIL Views
- 30.4 Summary of DBMS_AUDIT_UTIL Subprograms
31 DBMS_AUTO_SQLTUNE
- 31.1 DBMS_AUTO_SQLTUNE Overview
- 31.2 DBMS_AUTO_SQLTUNE Security Model
- 31.3 Summary of DBMS_AUTO_SQLTUNE Subprograms
32 DBMS_AUTO_INDEX
- 32.1 DBMS_AUTO_INDEX Overview
- 32.2 Summary of DBMS_AUTO_INDEX Subprograms
33 DBMS_AUTO_MV
- 33.1 Using DBMS_AUTO_MV
- 33.2 Summary of DBMS_AUTO_MV Subprograms
34 DBMS_AUTO_REPORT
- 34.1 DBMS_AUTO_REPORT Overview
- 34.2 DBMS_AUTO_REPORT Security Model
- 34.3 Summary of DBMS_AUTO_REPORT Subprograms
35 DBMS_AUTO_TASK_ADMIN
- 35.1 DBMS_AUTO_TASK_ADMIN Deprecated Subprograms
- 35.2 DBMS_AUTO_TASK_ADMIN Security Model
- 35.3 DBMS_AUTO_TASK_ADMIN Constants
- 35.4 Summary of DBMS_AUTO_TASK_ADMIN Subprograms
36 DBMS_AUTO_ZONEMAP
- 36.1 DBMS_AUTO_TASK_ADMIN Security Model
- 36.2 Summary of DBMS_AUTO_ZONEMAP Subprograms
  - 36.2.1 ACTIVITY_REPORT Function
  - 36.2.2 CONFIGURE Procedure
37 DBMS_AVTUNE
- 37.1 DBMS_AVTUNE Overview
- 37.2 DBMS_AVTUNE Security Model
- 37.3 Summary of DBMS_AVTUNE Subprograms
38 DBMS_AW_STATS
- 38.1 Using DBMS_AW_STATS
- 38.2 Summary of DBMS_AW_STATS Subprograms
  - 38.2.1 ANALYZE Procedure
  - 38.2.2 CLEAR Procedure
39 DBMS_BLOCKCHAIN_TABLE
- 39.1 DBMS_BLOCKCHAIN_TABLE Overview
- 39.2 DBMS_BLOCKCHAIN_TABLE Security Model
- 39.3 Summary of DBMS_BLOCKCHAIN_TABLE Subprograms
40 DBMS_CAPTURE_ADM
- 40.1 DBMS_CAPTURE_ADM Overview
- 40.2 DBMS_CAPTURE_ADM Security Model
- 40.3 Summary of DBMS_CAPTURE_ADM Subprograms
41 DBMS_CLOUD
- 41.1 DBMS_CLOUD Overview
- 41.2 Installing the DBMS_CLOUD Package
- 41.3 DBMS_CLOUD Security Model
- 41.4 DBMS_CLOUD Exceptions
- 41.5 Summary of DBMS_CLOUD Subprograms
- 41.6 DBMS_CLOUD Package File URI Formats
- 41.7 DBMS_CLOUD Package Format Options
- 41.8 DBMS_CLOUD Avro and Parquet Support
42 DBMS_COMPARISON
- 42.1 DBMS_COMPARISON Overview
- 42.2 DBMS_COMPARISON Security Model
- 42.3 DBMS_COMPARISON Constants
- 42.4 DBMS_COMPARISON Views
- 42.5 DBMS_COMPARISON Operational Notes
- 42.6 DBMS_COMPARISON Data Structures
  - 42.6.1 COMPARISON_TYPE Record Type
- 42.7 Summary of DBMS_COMPARISON Subprograms
43 DBMS_COMPRESSION
- 43.1 DBMS_COMPRESSION Overview
- 43.2 DBMS_COMPRESSION Security Model
- 43.3 DBMS_COMPRESSION Constants
- 43.4 DBMS_COMPRESSION Data Structures
  - 43.4.1 COMPREC Record Type
  - 43.4.2 COMPRECLIST Table Type
- 43.5 Summary of DBMS_COMPRESSION Subprograms
  - 43.5.1 GET_COMPRESSION_RATIO Procedure
  - 43.5.2 GET_COMPRESSION_TYPE Function
44 DBMS_CONNECTION_POOL
- 44.1 Summary of DBMS_CONNECTION_POOL Subprograms
45 DBMS_CQ_NOTIFICATION
- 45.1 DBMS_CQ_NOTIFICATION Overview
- 45.2 DBMS_CQ_NOTIFICATION Security Model
- 45.3 DBMS_CQ_NOTIFICATION Constants
- 45.4 DBMS_CQ_NOTIFICATION Operational Notes
- 45.5 DBMS_CQ_NOTIFICATION Examples
- 45.6 DBMS_CQ_NOTIFICATION Data Structures
- 45.7 Summary of DBMS_CQ_NOTIFICATION Subprograms
46 DBMS_CREDENTIAL
- 46.1 DBMS_CREDENTIAL Overview
- 46.2 DBMS_CREDENTIAL Security Model
- 46.3 DBMS_CREDENTIAL Operational Notes
- 46.4 Summary of DBMS_CREDENTIAL Subprograms
47 DBMS_CRYPTO
- 47.1 DBMS_CRYPTO Overview
- 47.2 DBMS_CRYPTO Security Model
- 47.3 DBMS_CRYPTO Constants
- 47.4 DBMS_CRYPTO Datatypes
- 47.5 DBMS_CRYPTO Algorithms
- 47.6 DBMS_CRYPTO Restrictions
- 47.7 DBMS_CRYPTO Exceptions
- 47.8 DBMS_CRYPTO Operational Notes
- 47.9 DBMS_CRYPTO Examples
- 47.10 Summary of DBMS_CRYPTO Subprograms
48 DBMS_CSX_ADMIN
- 48.1 DBMS_CSX_ADMIN Overview
- 48.2 DBMS_CSX_ADMIN Security Model
- 48.3 DBMS_CSX_ADMIN Constants
- 48.4 Summary of DBMS_CSX_ADMIN Subprograms
49 DBMS_CUBE
- 49.1 Using DBMS_CUBE
  - 49.1.1 DBMS_CUBE Security Model
- 49.2 Using SQL Aggregation Management
- 49.3 Upgrading 10g Analytic Workspaces
- 49.4 Summary of DBMS_CUBE Subprograms
50 DBMS_CUBE_ADVISE
- 50.1 DBMS_CUBE_ADVISE Security Model
- 50.2 Summary of DBMS_CUBE_ADVISE Subprograms
51 DBMS_CUBE_LOG
- 51.1 Using DBMS_CUBE_LOG
- 51.2 Summary of DBMS_CUBE_LOG Subprograms
52 DBMS_DATA_MINING
- 52.1 DBMS_DATA_MINING Overview
- 52.2 DBMS_DATA_MINING Security Model
- 52.3 DBMS_DATA_MINING — Machine Learning Functions
- 52.4 DBMS_DATA_MINING — Model Settings
- 52.5 DBMS_DATA_MINING — Algorithm Specific Model Settings
- 52.6 DBMS_DATA_MINING — Solver Settings
- 52.7 DBMS_DATA_MINING Datatypes
  - 52.7.1 Deprecated Types
- 52.8 Summary of DBMS_DATA_MINING Subprograms
53 DBMS_DATA_MINING_TRANSFORM
- 53.1 DBMS_DATA_MINING_TRANSFORM Overview
- 53.2 DBMS_DATA_MINING_TRANSFORM Operational Notes
- 53.3 DBMS_DATA_MINING_TRANSFORM Security Model
- 53.4 DBMS_DATA_MINING_TRANSFORM Datatypes
- 53.5 DBMS_DATA_MINING_TRANSFORM Constants
- 53.6 Summary of DBMS_DATA_MINING_TRANSFORM Subprograms
54 DBMS_DATAPUMP
- 54.1 DBMS_DATAPUMP Overview
- 54.2 DBMS_DATAPUMP Security Model
- 54.3 DBMS_DATAPUMP Constants
- 54.4 DBMS_DATAPUMP Data Structures
- 54.5 Summary of DBMS_DATAPUMP Subprograms
55 DBMS_DB_VERSION
- 55.1 DBMS_DB_VERSION Overview
- 55.2 DBMS_DB_VERSION Constants
- 55.3 DBMS_DB_VERSION Examples
56 DBMS_DBCOMP
- 56.1 Using DBMS_DBCOMP
- 56.2 DBMS_DBCOMP Security Model
- 56.3 Summary of the DBMS_DBCOMP Subprogram
  - 56.3.1 DBCOMP Procedure
57 DBMS_DBFS_CONTENT
- 57.1 DBMS_DBFS_CONTENT Overview
- 57.2 DBMS_DBFS_CONTENT Security Model
- 57.3 DBMS_DBFS_CONTENT Constants
- 57.4 Exceptions
- 57.5 DBMS_DBFS_CONTENT Operational Notes
- 57.6 DBMS_DBFS_CONTENT Data Structures
- 57.7 Summary of DBMS_DBFS_CONTENT Subprograms
58 DBMS_DBFS_CONTENT_SPI
- 58.1 ODBMS_DBFS_CONTENT_SPI Overview
- 58.2 DBMS_DBFS_CONTENT_SPI Security Model
- 58.3 DBMS_DBFS_CONTENT_SPI Operational Notes
- 58.4 Summary of DBMS_DBFS_CONTENT_SPI Subprograms
59 DBMS_DBFS_HS
- 59.1 DBMS_DBFS_HS Overview
- 59.2 DBMS_DBFS_HS Security Model
- 59.3 DBMS_DBFS_HS Constants
- 59.4 DBMS_DBFS_HS Operational Notes
- 59.5 Summary of DBMS_DBFS_HS Subprograms
60 DBMS_DBFS_SFS
- 60.1 DBMS_DBFS_SFS Overview
- 60.2 DBMS_DBFS_SFS Security Model
- 60.3 DBMS_DBFS_SFS Constants
- 60.4 Summary of DBMS_DBFS_SFS Subprograms
61 DBMS_DDL
- 61.1 DBMS_DDL Deprecated Subprograms
- 61.2 DBMS_DDL Security Model
- 61.3 DBMS_DDL Operational Notes
- 61.4 Summary of DBMS_DDL Subprograms
62 DBMS_DEBUG
- 62.1 DBMS_DEBUG Overview
- 62.2 DBMS_DEBUG Constants
- 62.3 DBMS_DEBUG Variables
- 62.4 DBMS_DEBUG Exceptions
- 62.5 DBMS_DEBUG Operational Notes
- 62.6 DBMS_DEBUG Data Structures
- 62.7 Summary of DBMS_DEBUG Subprograms
63 DBMS_DEBUG_JDWP
- 63.1 DBMS_DEBUG_JDWP Overview
- 63.2 DBMS_DEBUG_JDWP Security Model
- 63.3 Summary DBMS_DEBUG_JDWP Subprograms
64 DBMS_DEBUG_JDWP_CUSTOM
- 64.1 DBMS_DEBUG_JDWP_CUSTOM Overview
- 64.2 DBMS_DEBUG_JDWP_CUSTOM Security Model
- 64.3 Summary DBMS_DEBUG_JDWP_CUSTOM Subprograms
  - 64.3.1 CONNECT_DEBUGGER Procedure
65 DBMS_DESCRIBE
- 65.1 DBMS_DESCRIBE Overview
- 65.2 DBMS_DESCRIBE Security Model
- 65.3 DBMS_DESCRIBE Types
- 65.4 DBMS_DESCRIBE Exceptions
- 65.5 DBMS_DESCRIBE Examples
- 65.6 Summary of DBMS_DESCRIBE Subprograms
  - 65.6.1 DESCRIBE_PROCEDURE Procedure
66 DBMS_DG
- 66.1 Using DBMS_DG
- 66.2 DBMS_DG Security Model
- 66.3 Summary of the DBMS_DG Subprogram
  - 66.3.1 INITIATE_FS_FAILOVER Procedure
67 DBMS_DIMENSION
- 67.1 DBMS_DIMENSION Security Model
- 67.2 Summary of DBMS_DIMENSION Subprograms
  - 67.2.1 DESCRIBE_DIMENSION Procedure
  - 67.2.2 VALIDATE_DIMENSION Procedure
68 DBMS_DISTRIBUTED_TRUST_ADMIN
- 68.1 DBMS_DISTRIBUTED_TRUST_ADMIN Overview
- 68.2 DBMS_DISTRIBUTED_TRUST_ADMIN Security Model
- 68.3 DBMS_DISTRIBUTED_TRUST_ADMIN Examples
- 68.4 Summary of DBMS_DISTRIBUTED_TRUST_ADMIN Subprograms
69 DBMS_DNFS
- 69.1 DBMS_DNFS Security Model
- 69.2 Summary of DBMS_DNFS Subprograms
70 DBMS_DST
- 70.1 DBMS_DST Overview
- 70.2 DBMS_DST Security Model
- 70.3 DBMS_DST Views
- 70.4 Summary of DBMS_DST Subprograms
71 DBMS_EDITIONS_UTILITIES
- 71.1 DBMS_EDITIONS_UTILITIES Overview
- 71.2 DBMS_EDITIONS_UTILITIES Security Model
- 71.3 DBMS_EDITIONS_UTILITIES Exceptions
- 71.4 Summary of DBMS_EDITIONS_UTILITIES Subprograms
72 DBMS_EPG
- 72.1 DBMS_EPG Overview
- 72.2 DBMS_EPG Security Model
- 72.3 DBMS_EPG Exceptions
- 72.4 DBMS_EPG Data Structures
- 72.5 DBMS_EPG Subprogram Groups
  - 72.5.1 DBMS_EPG Configuration Subprograms
  - 72.5.2 DBMS_EPG Authorization Subprograms
- 72.6 Summary of DBMS_EPG Subprograms
73 DBMS_ERRLOG
- 73.1 DBMS_ERRLOG Security Model
- 73.2 Summary of DBMS_ERRLOG Subprograms
  - 73.2.1 CREATE_ERROR_LOG Procedure
74 DBMS_FGA
- 74.1 DBMS_FGA Security Model
- 74.2 DBMS_FGA Operational Notes
- 74.3 Summary of DBMS_FGA Subprograms
75 DBMS_FILE_GROUP
- 75.1 DBMS_FILE_GROUP Overview
- 75.2 DBMS_FILE_GROUP Security Model
- 75.3 DBMS_FILE_GROUP Constants
- 75.4 Summary of DBMS_FILE_GROUP Subprograms
76 DBMS_FILE_TRANSFER
- 76.1 DBMS_FILE_TRANSFER Overview
- 76.2 DBMS_FILE_TRANSFER Security Model
- 76.3 DBMS_FILE_TRANSFER Operational Notes
- 76.4 Summary of DBMS_FILE_TRANSFER Subprograms
77 DBMS_FLASHBACK
- 77.1 DBMS_FLASHBACK Overview
- 77.2 DBMS_FLASHBACK Security Model
- 77.3 DBMS_FLASHBACK Types
- 77.4 DBMS_FLASHBACK Exceptions
- 77.5 DBMS_FLASHBACK Operational Notes
- 77.6 DBMS_FLASHBACK Examples
- 77.7 Summary of DBMS_FLASHBACK Subprograms
78 DBMS_FLASHBACK_ARCHIVE
- 78.1 DBMS_FLASHBACK_ARCHIVE Overview
- 78.2 DBMS_FLASHBACK_ARCHIVE Security Model
- 78.3 DBMS_FLASHBACK_ARCHIVE Constants
- 78.4 Summary of DBMS_FLASHBACK_ARCHIVE Subprograms
79 DBMS_FLASHBACK_ARCHIVE_MIGRATE
- 79.1 DBMS_FLASHBACK_ARCHIVE_MIGRATE Overview
- 79.2 DBMS_FLASHBACK_ARCHIVE_MIGRATE Security Model
- 79.3 DBMS_FLASHBACK_ARCHIVE_MIGRATE Operational Notes
- 79.4 DBMS_FLASHBACK_ARCHIVE_MIGRATE Examples
- 79.5 Summary of DBMS_FLASHBACK Subprograms
80 DBMS_FREQUENT_ITEMSET
- 80.1 Summary of DBMS_FREQUENT_ITEMSET Subprograms
  - 80.1.1 FI_HORIZONTAL Function
  - 80.1.2 FI_TRANSACTIONAL Function
81 DBMS_FS
- 81.1 DBMS_FS Overview
- 81.2 DBMS_FS Security Model
- 81.3 Summary of DBMS_FS Subprograms
82 DBMS_GOLDENGATE_ADM
- 82.1 Using DBMS_GOLDENGATE_ADM
  - 82.1.1 DBMS_GOLDENGATE_ADM Overview
  - 82.1.2 DBMS_GOLDENGATE_ADM Security Model
- 82.2 Summary of DBMS_GOLDENGATE_ADM Subprograms
83 DBMS_GOLDENGATE_AUTH
- 83.1 DBMS_GOLDENGATE_AUTH Overview
- 83.2 DBMS_GOLDENGATE_AUTH Security Model
- 83.3 Summary of DBMS_GOLDENGATE_AUTH Subprograms
  - 83.3.1 GRANT_ADMIN_PRIVILEGE Procedure
  - 83.3.2 REVOKE_ADMIN_PRIVILEGE Procedure
84 DBMS_HADOOP
- 84.1 DBMS_HADOOP Overview
- 84.2 DBMS_HADOOP Security Model
- 84.3 Summary of DBMS_HADOOP Subprograms
85 DBMS_HANG_MANAGER
- 85.1 DBMS_HANG_MANAGER Overview
- 85.2 DBMS_HANG_MANAGER Security Model
- 85.3 DBMS_HANG_MANAGER Constants
- 85.4 DBMS_HANG_MANAGER Exceptions
- 85.5 Summary of DBMS_HANG_MANAGER Subprograms
  - 85.5.1 SET Procedure
86 DBMS_HEAT_MAP
- 86.1 DBMS_HEAT_MAP Overview
- 86.2 DBMS_HEAT_MAP Security Model
- 86.3 Summary of DBMS_HEAT_MAP Subprograms
87 DBMS_HIERARCHY
- 87.1 DBMS_HIERARCHY Overview
- 87.2 DBMS_HIERARCHY Security Model
- 87.3 Summary of DBMS_HIERARCHY Subprograms
88 DBMS_HM
- 88.1 DBMS_HM Security Model
- 88.2 Summary of DBMS_HM Subprograms
  - 88.2.1 GET_RUN_REPORT Function
  - 88.2.2 RUN_CHECK Procedure
89 DBMS_HPROF
- 89.1 DBMS_HPROF Security Model
- 89.2 Summary of DBMS_HPROF Subprograms
90 DBMS_HS_PARALLEL
- 90.1 Using the DBMS_HS_PARALLEL Subprogram
- 90.2 Summary of DBMS_HS_PARALLEL Subprograms
91 DBMS_HS_PASSTHROUGH
- 91.1 DBMS_HS_PASSTHROUGH Overview
- 91.2 DBMS_HS_PASSTHROUGH Operational Notes
- 91.3 Summary of DBMS_HS_PASSTHROUGH Subprograms
92 DBMS_ILM
- 92.1 DBMS_ILM Overview
- 92.2 DBMS_ILM Security Model
- 92.3 DBMS_ILM Constants
- 92.4 DBMS_ILM Exceptions
- 92.5 Summary of DBMS_ILM Subprograms
93 DBMS_ILM_ADMIN
- 93.1 DBMS_ILM_ADMIN Overview
- 93.2 DBMS_ILM_ADMIN Security Model
- 93.3 DBMS_ILM_ADMIN Constants
- 93.4 Summary of DBMS_ILM_ADMIN Subprograms
94 DBMS_IMMUTABLE_TABLE
- 94.1 DBMS_IMMUTABLE_TABLE Overview
- 94.2 DBMS_IMMUTABLE_TABLE Security Model
- 94.3 Summary of DBMS_IMMUTABLE_TABLE Subprograms
  - 94.3.1 DELETE_EXPIRED_ROWS Procedure
95 DBMS_INMEMORY
- 95.1 DBMS_INMEMORY Overview
- 95.2 DBMS_INMEMORY Security Model
- 95.3 Summary of DBMS_INMEMORY Subprograms
96 DBMS_INMEMORY_ADMIN
- 96.1 DBMS_INMEMORY_ADMIN Overview
- 96.2 DBMS_INMEMORY_ADMIN Security Model
- 96.3 DBMS_INMEMORY_ADMIN Operational Notes
- 96.4 Summary of DBMS_INMEMORY_ADMIN Subprograms
97 DBMS_IOT
- 97.1 Summary of DBMS_IOT Subprograms
  - 97.1.1 BUILD_CHAIN_ROWS_TABLE Procedure
  - 97.1.2 BUILD_EXCEPTIONS_TABLE Procedure
98 DBMS_JAVA
99 DBMS_JOB
- 99.1 DBMS_JOB Security Model
- 99.2 DBMS_JOB Operational Notes
- 99.3 Summary of DBMS_JOB Subprograms
100 DBMS_JSON
- 100.1 DBMS_JSON Overview
- 100.2 DBMS_JSON Security Model
- 100.3 DBMS_JSON Constants
- 100.4 Summary of DBMS_JSON Subprograms
101 DBMS_LDAP
102 DBMS_LDAP_UTL
103 DBMS_LIBCACHE
- 103.1 DBMS_LIBCACHE Overview
- 103.2 DBMS_LIBCACHE Security Model
- 103.3 Summary of DBMS_LIBCACHE Subprograms
  - 103.3.1 COMPILE_FROM_REMOTE Procedure
104 DBMS_LOB
- 104.1 DBMS_LOB Overview
- 104.2 DBMS_LOB Security Model
- 104.3 DBMS_LOB Constants
- 104.4 DBMS_LOB Datatypes
- 104.5 DBMS_LOB Operational Notes
- 104.6 DBMS_LOB Rules and Limits
- 104.7 DBMS_LOB Exceptions
- 104.8 Summary of DBMS_LOB Subprograms
105 DBMS_LOCK
- 105.1 DBMS_LOCK Overview
- 105.2 DBMS_LOCK Security Model
- 105.3 DBMS_LOCK Constants
- 105.4 DBMS_LOCK. Rules and Limits
- 105.5 DBMS_LOCK Operational Notes
- 105.6 Summary of DBMS_LOCK Subprograms
106 DBMS_LOGMNR
- 106.1 DBMS_LOGMNR Overview
- 106.2 DBMS_LOGMNR Security Model
- 106.3 DBMS_LOGMNR Constants
- 106.4 DBMS_LOGMNR Views
- 106.5 DBMS_LOGMNR Operational Notes
- 106.6 Summary of DBMS_LOGMNR Subprograms
107 DBMS_LOGSTDBY
- 107.1 DBMS_LOGSTDBY Overview
- 107.2 DBMS_LOGSTDBY Security Model
- 107.3 DBMS_LOGSTDBY Constants
- 107.4 Summary of DBMS_LOGSTDBY Subprograms
108 DBMS_LOGMNR_D
- 108.1 DBMS_LOGMNR_D Overview
- 108.2 DBMS_LOGMNR_D Security Model
- 108.3 Summary of DBMS_LOGMNR_D Subprograms
  - 108.3.1 BUILD Procedure
  - 108.3.2 SET_TABLESPACE Procedure
109 DBMS_LOGSTDBY_CONTEXT
- 109.1 DBMS_LOGSTDBY_CONTEXT Overview
- 109.2 DBMS_LOGSTDBY_CONTEXT Security Model
- 109.3 Summary of DBMS_LOGSTDBY_CONTEXT Subprograms
110 DBMS_MEMOPTIMIZE
- 110.1 DBMS_MEMOPTIMIZE Overview
- 110.2 Summary of DBMS_MEMOPTIMIZE Subprograms
111 DBMS_MEMOPTIMIZE_ADMIN
- 111.1 DBMS_MEMOPTIMIZE_ADMIN Overview
- 111.2 Summary of DBMS_MEMOPTIMIZE_ADMIN Subprograms
  - 111.2.1 WRITES_FLUSH Procedure
112 DBMS_METADATA
- 112.1 DBMS_METADATA Overview
- 112.2 DBMS_METADATA Security Model
- 112.3 Rules and Limits
- 112.4 DBMS_METADATA Data Structures - Object and Table Types
- 112.5 DBMS_METADATA Subprogram Groupings
  - 112.5.1 DBMS_METADATA Subprograms for Retrieving Multiple Objects From the Database
  - 112.5.2 DBMS_METADATA Subprograms for Submitting XML to the Database
- 112.6 Summary of All DBMS_METADATA Subprograms
113 DBMS_METADATA_DIFF
- 113.1 DBMS_METADATA_DIFF Overview
- 113.2 DBMS_METADATA_DIFF Security Model
- 113.3 DBMS_METADATA_DIFF — Browsing APIs for Fetching and Comparing Objects
- 113.4 Summary of DBMS_METADATA_DIFF Subprograms
114 DBMS_MGD_ID_UTL
- 114.1 DBMS_MGD_ID_UTL Security Model
- 114.2 DBMS_MGD_ID_UTL Constants
- 114.3 DBMS_MGD_ID_UTL Exceptions
- 114.4 Summary of DBMS_MGD_ID_UTL Subprograms
115 DBMS_MGWADM
- 115.1 DBMS_MGWADM Security Model
- 115.2 DBMS_MGWADM Deprecated Subprograms
- 115.3 DBMS_MGWADM Constants
- 115.4 DBMS_MGWADM Data Structures
- 115.5 Summary of DBMS_MGWADM Subprograms
116 DBMS_MGWMSG
- 116.1 DBMS_MGWMSG Security Model
- 116.2 DBMS_MGWMSG Constants
- 116.3 DBMS_MGWMSG Types
- 116.4 Summary of DBMS_MGWMSG Subprograms
117 DBMS_MLE
- 117.1 DBMS_MLE Overview
- 117.2 DBMS_MLE Security Model
- 117.3 Summary of DBMS_MLE Subprograms
118 DBMS_MONITOR
- 118.1 Summary of DBMS_MONITOR Subprograms
119 DBMS_MVIEW
- 119.1 DBMS_MVIEW Operational Notes
- 119.2 DBMS_MVIEW Security Model
- 119.3 DBMS_MVIEW Rules and Limits
- 119.4 Summary of DBMS_MVIEW Subprograms
120 DBMS_MVIEW_STATS
- 120.1 DBMS_MVIEW_STATS Overview
- 120.2 DBMS_MVIEW_STATS Security Model
- 120.3 Summary of DBMS_MVIEW_STATS Subprograms
121 DBMS_NETWORK_ACL_ADMIN
- 121.1 DBMS_NETWORK_ACL_ADMIN Overview
- 121.2 DBMS_NETWORK_ACL_ADMIN Deprecated Subprograms
- 121.3 DBMS_NETWORK_ACL_ADMIN Security Model
- 121.4 DBMS_NETWORK_ACL_ADMIN Constants
- 121.5 DBMS_NETWORK_ACL_ADMIN Exceptions
- 121.6 DBMS_NETWORK_ACL_ADMIN Examples
- 121.7 Summary of DBMS_NETWORK_ACL_ADMIN Subprograms
122 DBMS_NETWORK_ACL_UTILITY
- 122.1 DBMS_NETWORK_ACL_UTILITY Security Model
- 122.2 DBMS_NETWORK_ACL_UTILITY Examples
- 122.3 Summary of DBMS_NETWORK_ACL_UTILITY Subprograms
123 DBMS_ODCI
- 123.1 Summary of DBMS_ODCI Subprograms
  - 123.1.1 ESTIMATE_CPU_UNITS Function
124 DBMS_OPTIM_BUNDLE
- 124.1 DBMS_OPTIM_BUNDLE Security Model
- 124.2 Summary of DBMS_OPTIM_BUNDLE Subprograms
125 DBMS_OUTLN
- 125.1 DBMS_OUTLN Overview
- 125.2 DBMS_OUTLN Security Model
- 125.3 Summary of DBMS_OUTLN Subprograms
126 DBMS_OUTPUT
- 126.1 DBMS_OUTPUT Overview
- 126.2 DBMS_OUTPUT Security Model
- 126.3 DBMS_OUTPUT Operational Notes
- 126.4 DBMS_OUTPUT Exceptions
- 126.5 DBMS_OUTPUT Rules and Limits
- 126.6 DBMS_OUTPUT Examples
- 126.7 DBMS_OUTPUT Data Structures
  - 126.7.1 CHARARR Table Type
  - 126.7.2 DBMS_OUTPUT DBMSOUTPUT_LINESARRAY Object Type
- 126.8 Summary of DBMS_OUTPUT Subprograms
127 DBMS_PARALLEL_EXECUTE
- 127.1 DBMS_PARALLEL_EXECUTE Overview
- 127.2 DBMS_PARALLEL_EXECUTE Security Model
- 127.3 DBMS_PARALLEL_EXECUTE Constants
- 127.4 DBMS_PARALLEL_EXECUTE Views
- 127.5 DBMS_PARALLEL_EXECUTE Exceptions
- 127.6 DBMS_PARALLEL_EXECUTE Examples
- 127.7 Summary of DBMS_PARALLEL_EXECUTE Subprograms
128 DBMS_PART
- 128.1 DBMS_PART Security Model
- 128.2 DBMS_PART Operational Notes
- 128.3 Summary of DBMS_PART Subprograms
129 DBMS_PCLXUTIL
- 129.1 DBMS_PCLXUTIL Overview
- 129.2 DBMS_PCLXUTIL Security Model
- 129.3 DBMS_PCLXUTIL Operational Notes
- 129.4 DBMS_PCLXUTIL Rules and Limits
- 129.5 Summary of DBMS_PCLXUTIL Subprograms
  - 129.5.1 BUILD_PART_INDEX Procedure
130 DBMS_PDB
- 130.1 DBMS_PDB Overview
- 130.2 DBMS_PDB Security Model
- 130.3 Summary of DBMS_PDB Subprograms
131 DBMS_PDB_ALTER_SHARING
- 131.1 DBMS_PDB_ALTER_SHARING Overview
- 131.2 DBMS_PDB_ALTER_SHARING Security Model
- 131.3 Summary of DBMS_PDB_ALTER_SHARING Subprograms
132 DBMS_PERF
- 132.1 DBMS_PERF Overview
- 132.2 DBMS_PERF Security Model
- 132.3 Summary of DBMS_PERF Subprograms
133 DBMS_PIPE
- 133.1 DBMS_PIPE Overview
- 133.2 DBMS_PIPE Security Model
- 133.3 DBMS_PIPE Constants
- 133.4 DBMS_PIPE Operational Notes
- 133.5 DBMS_PIPE Exceptions
- 133.6 DBMS_PIPE Examples
- 133.7 Summary of DBMS_PIPE Subprograms
134 DBMS_PLSQL_CODE_COVERAGE
- 134.1 DBMS_PLSQL_CODE_COVERAGE Overview
- 134.2 DBMS_PLSQL_CODE_COVERAGE Security Model
- 134.3 DBMS_PLSQL_CODE_COVERAGE Constants
- 134.4 DBMS_PLSQL_CODE_COVERAGE Data Structures
  - 134.4.1 MAP_REC Record Type
  - 134.4.2 T_MAP_REC Table Type
- 134.5 Summary of DBMS_PLSQL_CODE_COVERAGE Subprograms
135 DBMS_PREDICTIVE_ANALYTICS
- 135.1 DBMS_PREDICTIVE_ANALYTICS Overview
- 135.2 DBMS_PREDICTIVE_ANALYTICS Security Model
- 135.3 Summary of DBMS_PREDICTIVE_ANALYTICS Subprograms
136 DBMS_PREPROCESSOR
- 136.1 DBMS_PREPROCESSOR Overview
- 136.2 DBMS_PREPROCESSOR Operating Notes
- 136.3 DBMS_PREPROCESSOR Data Structures
  - 136.3.1 DBMS_PREPROCESSOR SOURCE_LINES_T Table Type
- 136.4 Summary of DBMS_PREPROCESSOR Subprograms
  - 136.4.1 GET_POST_PROCESSED_SOURCE Functions
  - 136.4.2 PRINT_POST_PROCESSED_SOURCE Procedures
137 DBMS_PRIVILEGE_CAPTURE
- 137.1 DBMS_PRIVILEGE_CAPTURE Overview
- 137.2 DBMS_PRIVILEGE_CAPTURE Security Model
- 137.3 DBMS_PRIVILEGE_CAPTURE Constants
- 137.4 DBMS_PRIVILEGE_CAPTURE Examples
- 137.5 Summary of DBMS_PRIVILEGE_CAPTURE Subprograms
138 DBMS_PROCESS
- 138.1 DBMS_PROCESS Overview
- 138.2 DBMS_PROCESS Security Model
- 138.3 Summary of DBMS_PROCESS Subprograms
139 DBMS_PROFILER
- 139.1 DBMS_PROFILER Overview
- 139.2 DBMS_PROFILER Security Model
- 139.3 DBMS_PROFILER Operational Notes
- 139.4 DBMS_PROFILER Exceptions
- 139.5 Summary of DBMS_PROFILER Subprograms
140 DBMS_PROPAGATION_ADM
- 140.1 DBMS_PROPAGATION_ADM Overview
- 140.2 DBMS_PROPAGATION_ADM Security Model
- 140.3 Summary of DBMS_PROPAGATION_ADM Subprograms
141 DBMS_QOPATCH
- 141.1 DBMS_QOPATCH Overview
- 141.2 DBMS_QOPATCH Security Model
- 141.3 DBMS_QOPATCH Operational Notes
- 141.4 DBMS_QOPATCH Exceptions
- 141.5 Summary of DBMS_QOPATCH Subprograms
142 DBMS_RANDOM
- 142.1 DBMS_RANDOM Deprecated Subprograms
- 142.2 DBMS_RANDOM Security Model
- 142.3 DBMS_RANDOM Operational Notes
- 142.4 Summary of DBMS_RANDOM Subprograms
143 DBMS_REDACT
- 143.1 DBMS_REDACT Overview
- 143.2 DBMS_REDACT Security Model
- 143.3 DBMS_REDACT Constants
- 143.4 DBMS_REDACT Operating Procedures
- 143.5 Summary of DBMS_REDACT Subprograms
144 DBMS_REDEFINITION
- 144.1 DBMS_REDEFINITION Overview
- 144.2 DBMS_REDEFINITION Security Model
- 144.3 DBMS_REDEFINITION Constants
- 144.4 DBMS_REDEFINITION Operational Notes
- 144.5 DBMS_REDEFINITION Rules and Limits
- 144.6 DBMS_REDEFINITION Examples
- 144.7 Summary of DBMS_REDEFINITION Subprograms
145 DBMS_REFRESH
- 145.1 DBMS_REFRESH Overview
- 145.2 DBMS_REFRESH Security Model
- 145.3 Summary of DBMS_REFRESH Subprograms
146 DBMS_REPAIR
- 146.1 DBMS_REPAIR Overview
- 146.2 DBMS_REPAIR Security Model
- 146.3 DBMS_REPAIR Constants
- 146.4 DBMS_REPAIR Operating Notes
- 146.5 DBMS_REPAIR Exceptions
- 146.6 DBMS_REPAIR Examples
- 146.7 Summary of DBMS_REPAIR Subprograms
147 DBMS_RESCONFIG
- 147.1 DBMS_RESCONFIG Overview
- 147.2 Summary of DBMS_RESCONFIG Subprograms
148 DBMS_RESOURCE_MANAGER
- 148.1 DBMS_RESOURCE_MANAGER Deprecated Subprograms
- 148.2 DBMS_RESOURCE_MANAGER Security Model
- 148.3 DBMS_RESOURCE_MANAGER Constants
- 148.4 Summary of DBMS_RESOURCE_MANAGER Subprograms
149 DBMS_RESOURCE_MANAGER_PRIVS
- 149.1 Summary of DBMS_RESOURCE_MANAGER_PRIVS Subprograms
150 DBMS_RESULT_CACHE
- 150.1 DBMS_RESULT_CACHE Security Model
- 150.2 DBMS_RESULT_CACHE Constants
- 150.3 Summary of DBMS_RESULT_CACHE Subprograms
151 DBMS_RESUMABLE
- 151.1 DBMS_RESUMABLE Operational Notes
- 151.2 Summary of DBMS_RESUMABLE Subprograms
152 DBMS_RLS
- 152.1 DBMS_RLS Overview
- 152.2 DBMS_RLS Security Model
- 152.3 DBMS_RLS Constants
- 152.4 DBMS_RLS Operational Notes
- 152.5 DBMS_RLS Rules and Limits
- 152.6 Summary of DBMS_RLS Subprograms
153 DBMS_ROLLING
- 153.1 DBMS_ROLLING Overview
- 153.2 DBMS_ROLLING Security Model
- 153.3 Summary of DBMS_ROLLING Subprograms
154 DBMS_ROWID
- 154.1 DBMS_ROWID Security Model
- 154.2 DBMS_ROWID Types
- 154.3 DBMS_ROWID Exceptions
- 154.4 DBMS_ROWID Operational Notes
- 154.5 DBMS_ROWID Examples
- 154.6 Summary of DBMS_ROWID Subprograms
155 DBMS_RULE
- 155.1 DBMS_RULE Overview
- 155.2 DBMS_RULE Security Model
- 155.3 Summary of DBMS_RULE Subprograms
156 DBMS_RULE_ADM
- 156.1 DBMS_RULE_ADM Overview
- 156.2 DBMS_RULE_ADM Security Model
- 156.3 Summary of DBMS_RULE_ADM Subprograms
157 DBMS_SCHEDULER
- 157.1 DBMS_SCHEDULER Deprecated Subprograms
- 157.2 DBMS_SCHEDULER Security Model
- 157.3 DBMS_SCHEDULER Rules and Limits
- 157.4 DBMS_SCHEDULER Operational Notes
- 157.5 DBMS_SCHEDULER Data Structures
- 157.6 Summary of DBMS_SCHEDULER Subprograms
158 DBMS_SERVER_ALERT
- 158.1 DBMS_SERVER_ALERT Security Model
- 158.2 DBMS_SERVER_ALERT Object Types
- 158.3 DBMS_SERVER_ALERT Relational Operators
- 158.4 DBMS_SERVER_ALERT Supported Metrics
- 158.5 Summary of DBMS_SERVER_ALERT Subprograms
159 DBMS_SERVICE
- 159.1 DBMS_SERVICE Overview
- 159.2 DBMS_SERVICE Security Model
- 159.3 DBMS_SERVICE Constants
- 159.4 DBMS_SERVICE Operating Procedures
- 159.5 DBMS_SERVICE Exceptions
- 159.6 Summary of DBMS_SERVICE Subprograms
160 DBMS_SESSION
- 160.1 DBMS_SESSION Security Model
- 160.2 DBMS_SESSION Operational Notes
- 160.3 DBMS_SESSION Data Structures
  - 160.3.1 DBMS_SERVICE INTEGER_ARRAY Table Type
  - 160.3.2 DBMS_SERVICE LNAME_ARRAY Table Type
- 160.4 Summary of DBMS_SESSION Subprograms
161 DBMS_SFW_ACL_ADMIN
- 161.1 DBMS_SFW_ACL_ADMIN Security Model
- 161.2 DBMS_SFW_ACL_ADMIN Operational Notes
- 161.3 DBMS_SFW_ACL_ADMIN Examples
- 161.4 Summary of DBMS_SFW_ACL_ADMIN Subprograms
162 DBMS_SODA
- 162.1 DBMS_SODA Security Model
- 162.2 Summary of DBMS_SODA Subprograms
- 162.3 Summary of SODA Online Redefinition Subprograms
163 DBMS_SHARED_POOL
- 163.1 DBMS_SHARED_POOL Overview
- 163.2 DBMS_SHARED_POOL Operational Notes
- 163.3 Summary of DBMS_SHARED_POOL Subprograms
164 DBMS_SPACE
- 164.1 DBMS_SPACE Security Model
- 164.2 DBMS_SPACE Data Structures
- 164.3 Summary of DBMS_SPACE Subprograms
165 DBMS_SPACE_ADMIN
- 165.1 DBMS_SPACE_ADMIN Security Model
- 165.2 DBMS_SPACE_ADMIN Constants
- 165.3 DBMS_SPACE_ADMIN Operational Notes
- 165.4 Summary of DBMS_SPACE_ADMIN Subprograms
166 DBMS_SPD
- 166.1 DBMS_SPD Overview
- 166.2 DBMS_SPD Security Model
- 166.3 DBMS_SPD Views
- 166.4 Summary of DBMS_SPD Subprograms
167 DBMS_SPM
- 167.1 DBMS_SPM Overview
- 167.2 DBMS_SPM Security Model
- 167.3 DBMS_SPM Constants
- 167.4 DBMS_SPM Examples
- 167.5 DBMS_SPM Data Structures
  - 167.5.1 DBMS_SPM NAMELIST Table Type
- 167.6 Summary of DBMS_SPM Subprograms
168 DBMS_SQL
- 168.1 DBMS_SQL Overview
- 168.2 DBMS_SQL Security Model
- 168.3 DBMS_SQL Constants
- 168.4 DBMS_SQL Operational Notes
- 168.5 DBMS_SQL Execution Flow
- 168.6 DBMS_SQL Exceptions
- 168.7 DBMS_SQL Examples
- 168.8 DBMS_SQL Data Structures
- 168.9 Summary of DBMS_SQL Subprograms
169 DBMS_SQL_MONITOR
- 169.1 DBMS_SQL_MONITOR Overview
- 169.2 DBMS_SQL_MONITOR Security Model
- 169.3 DBMS_SQL_MONITOR Constants
- 169.4 Summary of DBMS_SQL_MONITOR Subprograms
170 DBMS_SQL_TRANSLATOR
- 170.1 DBMS_SQL_TRANSLATOR Security Model
- 170.2 DBMS_SQL_TRANSLATOR Constants
- 170.3 DBMS_SQL_TRANSLATOR Operational Notes
- 170.4 DBMS_SQL_TRANSLATOR Exceptions
- 170.5 DBMS_SQL_TRANSLATOR Examples
- 170.6 Summary of DBMS_SQL_TRANSLATOR Subprograms
171 DBMS_SQLDIAG
- 171.1 DBMS_SQLDIAG Overview
- 171.2 DBMS_SQLDIAG Security Model
- 171.3 DBMS_SQLDIAG Constants
- 171.4 Summary of DBMS_SQLDIAG Subprograms
172 DBMS_SQLPA
- 172.1 DBMS_SQLPA Overview
- 172.2 DBMS_SQLPA Security Model
- 172.3 Summary of DBMS_SQLPA Subprograms
173 DBMS_SQLQ
- 173.1 DBMS_SQLQ Overview
- 173.2 Summary of DBMS_SQLQ Subprograms
174 DBMS_SQLSET
- 174.1 DBMS_SQLSET Overview
- 174.2 DBMS_SQLSET Security Model
- 174.3 DBMS_SQLSET Data Structures
  - 174.3.1 SQLSET_ROW Object Type
- 174.4 Summary of DBMS_SQLSET Subprograms
175 DBMS_SQLTUNE
- 175.1 DBMS_SQLTUNE Overview
- 175.2 DBMS_SQLTUNE Security Model
- 175.3 DBMS_SQLTUNE Data Structures
  - 175.3.1 SQLSET_ROW Object Type
- 175.4 DBMS_SQLTUNE Subprogram Groups
- 175.5 Summary of DBMS_SQLTUNE Subprograms
176 DBMS_STAT_FUNCS
- 176.1 Summary of DBMS_STAT_FUNCS Subprograms
177 DBMS_STATS
- 177.1 DBMS_STATS Overview
- 177.2 DBMS_STATS Deprecated Subprograms
- 177.3 DBMS_STATS Types
- 177.4 DBMS_STATS Constants
- 177.5 DBMS_STATS Operational Notes
- 177.6 DBMS_STATS Data Structures
  - 177.6.1 DBMS_STATS STAT_REC Record Type
- 177.7 Summary of DBMS_STATS Subprograms
178 DBMS_STORAGE_MAP
- 178.1 DBMS_STORAGE_MAP Overview
- 178.2 DBMS_STORAGE_MAP Operational Notes
- 178.3 Summary of DBMS_STORAGE_MAP Subprograms
179 DBMS_SYNC_REFRESH
- 179.1 DBMS_SYNC_REFRESH Overview
- 179.2 DBMS_SYNC_REFRESH Security Model
- 179.3 Summary of DBMS_SYNC_REFRESH Subprograms
180 DBMS_TABLE_DATA
- 180.1 DBMS_TABLE_DATA Overview
- 180.2 DBMS_TABLE_DATA Security Model
- 180.3 Summary of DBMS_TABLE_DATA Subprograms
181 DBMS_TDB
- 181.1 DBMS_TDB Overview
- 181.2 DBMS_TDB Security Model
- 181.3 DBMS_TDB Constants
- 181.4 DBMS_TDB Views
- 181.5 DBMS_TDB Operational Notes
- 181.6 Summary of DBMS_TDB Subprograms
  - 181.6.1 CHECK_DB Function
  - 181.6.2 CHECK_EXTERNAL Function
182 DBMS_TF
- 182.1 DBMS_TF Overview
- 182.2 DBMS_TF Security Model
- 182.3 DBMS_TF Constants
- 182.4 DBMS_TF Operational Notes
- 182.5 DBMS_TF Execution Flow
- 182.6 DBMS_TF Restrictions
- 182.7 DBMS_TF Examples
  - 182.7.1 Echo Polymorphic Table Function Example
- 182.8 DBMS_TF Data Structures
- 182.9 Summary of DBMS_TF Subprograms
183 DBMS_TNS
- 183.1 DBMS_TNS Overview
- 183.2 DBMS_TNS Security Model
- 183.3 Summary of DBMS_TNS Subprograms
  - 183.3.1 RESOLVE_TNSNAME Function
184 DBMS_TRACE
- 184.1 DBMS_TRACE Overview
- 184.2 DBMS_TRACE Security Model
- 184.3 DBMS_TRACE Constants
- 184.4 DBMS_TRACE Restrictions
- 184.5 DBMS_TRACE Operational Notes
- 184.6 Summary of DBMS_TRACE Subprograms
185 DBMS_TRANSACTION
- 185.1 DBMS_TRANSACTION Security Model
- 185.2 Summary of DBMS_TRANSACTION Subprograms
186 DBMS_TRANSFORM
- 186.1 Summary of DBMS_TRANSFORM Subprograms
187 DBMS_TSDP_MANAGE
- 187.1 DBMS_TSDP_MANAGE Overview
- 187.2 DBMS_TSDP_MANAGE Security Model
- 187.3 Summary of DBMS_TSDP_MANAGE Subprograms
188 DBMS_TSDP_PROTECT
- 188.1 DBMS_TSDP_PROTECT Overview
- 188.2 DBMS_TSDP_PROTECT Security Model
- 188.3 DBMS_TSDP_PROTECT Constants
- 188.4 DBMS_TSDP_PROTECT Data Structures
  - 188.4.1 FEATURE_OPTIONS Table Type
  - 188.4.2 POLICY_CONDITIONS Table Type
- 188.5 Summary of DBMS_TSDP_PROTECT Subprograms
189 DBMS_TTS
- 189.1 DBMS_TTS Security Model
- 189.2 DBMS_TTS Exceptions
- 189.3 DBMS_TTS Operational Notes
- 189.4 Summary of DBMS_TTS Subprograms
  - 189.4.1 DOWNGRADE Procedure
  - 189.4.2 TRANSPORT_SET_CHECK Procedure
190 DBMS_TYPES
- 190.1 DBMS_TYPES Constants
- 190.2 DBMS_TYPES Exceptions
191 DBMS_UMF
- 191.1 Summary of DBMS_UMF Subprograms
192 DBMS_UNDO_ADV
- 192.1 Summary of DBMS_UNDO_ADV Subprograms
193 DBMS_USER_CERTS
- 193.1 DBMS_USER_CERTS Overview
- 193.2 DBMS_USER_CERTS Security Model
- 193.3 Summary of DBMS_USER_CERTS Subprograms
  - 193.3.1 ADD_CERTIFICATE Procedure
  - 193.3.2 DROP_CERTIFICATE Procedure
194 DBMS_UTILITY
- 194.1 DBMS_UTILITY Deprecated Subprograms
- 194.2 DBMS_UTILITY Security Model
- 194.3 DBMS_UTILITY Constants
- 194.4 DBMS_UTILITY Exceptions
- 194.5 DBMS_UTILITY Data Structures
- 194.6 Summary of DBMS_UTILITY Subprograms
195 DBMS_WARNING
- 195.1 DBMS_WARNING Security Model
- 195.2 Summary of DBMS_WARNING Subprograms
196 DBMS_WM
197 DBMS_WORKLOAD_CAPTURE
- 197.1 DBMS_WORKLOAD_CAPTURE Overview
- 197.2 DBMS_WORKLOAD_CAPTURE Security Model
- 197.3 Summary of DBMS_WORKLOAD_CAPTURE Subprograms
198 DBMS_WORKLOAD_REPLAY
- 198.1 DBMS_WORKLOAD_REPLAY Overview
- 198.2 DBMS_WORKLOAD_REPLAY Security Model
- 198.3 Summary of DBMS_WORKLOAD_REPLAY Subprograms
199 DBMS_WORKLOAD_REPOSITORY
- 199.1 DBMS_WORKLOAD_REPOSITORY Examples
- 199.2 DBMS_WORKLOAD_REPOSITORY Data Structures
- 199.3 Summary of DBMS_WORKLOAD_REPOSITORY Subprograms
200 DBMS_XA
- 200.1 DBMS_XA Overview
- 200.2 DBMS_XA Security Model
- 200.3 DBMS_XA Constants
- 200.4 DBMS_XA Operational Notes
- 200.5 DBMS_XA Data Structures
  - 200.5.1 DBMS_XA DBMS_XA_XID Object Type
  - 200.5.2 DBMS_XA DBMS_XA_XID_ARRAY Table Type
- 200.6 Summary of DBMS_XA Subprograms
201 DBMS_XDB
- 201.1 DBMS_XDB Overview
- 201.2 DBMS_XDB Security Model
- 201.3 DBMS_XDB Constants
- 201.4 Summary of DBMS_XDB Subprograms
202 DBMS_XDB_ADMIN
- 202.1 DBMS_XDB_ADMIN Security Model
- 202.2 Summary of DBMS_XDB_ADMIN Subprograms
203 DBMS_XDB_CONFIG
- 203.1 DBMS_XDB_CONFIG Overview
- 203.2 DBMS_XDB_CONFIG Security Model
- 203.3 DBMS_XDB_CONFIG Constants
- 203.4 Summary of DBMS_XDB_CONFIG Subprograms
204 DBMS_XDB_CONSTANTS
- 204.1 DBMS_XDB_CONSTANTS Security Model
- 204.2 Summary of DBMS_XDB_CONSTANTS Subprograms
205 DBMS_XDB_REPOS
- 205.1 DBMS_XDB_REPOS Overview
- 205.2 DBMS_XDB_REPOS Security Model
- 205.3 DBMS_XDB_REPOS Constants
- 205.4 Summary of DBMS_XDB_REPOS Subprograms
206 DBMS_XDB_VERSION
- 206.1 DBMS_XDB_VERSION Security Model
- 206.2 Summary of DBMS_XDB_VERSION Subprograms
207 DBMS_XDBRESOURCE
- 207.1 DBMS_XDBRESOURCE Overview
- 207.2 DBMS_XDBRESOURCE Security Model
- 207.3 Summary of DBMS_XDBRESOURCE Subprograms
208 DBMS_XDBZ
- 208.1 DBMS_XDBZ Security Model
- 208.2 DBMS_XDBZ Constants
- 208.3 Summary of DBMS_XDBZ Subprograms
209 DBMS_XEVENT
- 209.1 DBMS_XEVENT Security Model
- 209.2 DBMS_XEVENT Constants
- 209.3 Subprogram Groups
- 209.4 Summary of DBMS_XEVENT Subprograms
210 DBMS_XMLDOM
- 210.1 DBMS_XMLDOM Overview
- 210.2 DBMS_XMLDOM Security Model
- 210.3 DBMS_XMLDOM Constants
- 210.4 DBMS_XMLDOM Types
- 210.5 DBMS_XMLDOM Exceptions
- 210.6 DBMS_XMLDOM Subprogram Groups
- 210.7 Summary of DBMS_XMLDOM Subprograms
211 DBMS_XMLGEN
- 211.1 DBMS_XMLGEN Security Model
- 211.2 Summary of DBMS_XMLGEN Subprograms
212 DBMS_XMLINDEX
- 212.1 DBMS_XMLINDEX Overview
- 212.2 DBMS_XMLINDEX Security Model
- 212.3 Summary of DBMS_XMLINDEX Subprograms
213 DBMS_XMLPARSER
- 213.1 DBMS_XMLPARSER Security Model
- 213.2 Summary of DBMS_XMLPARSER Subprograms
214 DBMS_XMLSCHEMA
- 214.1 DBMS_XMLSCHEMA Overview
- 214.2 DBMS_XMLSCHEMA Security Model
- 214.3 DBMS_XMLSCHEMA Constants
- 214.4 Views
- 214.5 DBMS_XMLSCHEMA Operational Notes
- 214.6 Summary of DBMS_XMLSCHEMA Subprograms
215 DBMS_XMLSCHEMA_ANNOTATE
- 215.1 DBMS_XMLSCHEMA_ANNOTATE Overview
- 215.2 DBMS_XMLSCHEMA_ANNOTATE Security Model
- 215.3 Summary of DBMS_XMLSCHEMA_ANNOTATE Subprograms
216 DBMS_XMLSCHEMA_UTIL
- 216.1 DBMS_XMLSCHEMA_UTIL Security Model
- 216.2 Summary of DBMS_XMLSCHEMA_UTIL Subprograms
  - 216.2.1 CONFORMING Function
  - 216.2.2 VALIDATE Procedure
217 DBMS_XMLSTORAGE_MANAGE
- 217.1 DBMS_XMLSTORAGE_MANAGE Overview
- 217.2 DBMS_XMLSTORAGE_MANAGE Security Model
- 217.3 Summary of DBMS_XMLSTORAGE_MANAGE Subprograms
218 DBMS_XMLSTORE
- 218.1 DBMS_XMLSTORE Security Model
- 218.2 Types
- 218.3 Summary of DBMS_XMLSTORE Subprograms
219 DBMS_XPLAN
- 219.1 DBMS_XPLAN Overview
- 219.2 DBMS_XPLAN Security Model
- 219.3 DBMS_XPLAN Data Structures
  - 219.3.1 DBMS_XPLAN PLAN_OBJECT_LIST Table Type
- 219.4 Examples
- 219.5 Summary of DBMS_XPLAN Subprograms
220 DBMS_XSLPROCESSOR
- 220.1 DBMS_XSLPROCESSOR Overview
- 220.2 DBMS_XSLPROCESSOR Security Model
- 220.3 Summary of DBMS_XSLPROCESSOR Subprograms
221 DBMS_XSTREAM_ADM
- 221.1 DBMS_XSTREAM_ADM Overview
- 221.2 DBMS_XSTREAM_ADM Security Model
- 221.3 DBMS_XSTREAM_ADM Operational Notes
- 221.4 Summary of DBMS_XSTREAM_ADM Subprograms
222 DBMS_XSTREAM_AUTH
- 222.1 DBMS_XSTREAM_AUTH Overview
- 222.2 DBMS_XSTREAM_AUTH Security Model
- 222.3 Summary of DBMS_XSTREAM_AUTH Subprograms
223 DEBUG_EXTPROC
- 223.1 DEBUG_EXTPROC Security Model
- 223.2 DEBUG_EXTPROC Operational Notes
- 223.3 Rules and Limits
- 223.4 Summary of DEBUG_EXTPROC Subprograms
  - 223.4.1 STARTUP_EXTPROC_AGENT Procedure
224 HTF
- 224.1 HTF Deprecated Subprograms
- 224.2 HTF Operational Notes
- 224.3 Rules and Limits
- 224.4 HTF Examples
- 224.5 Summary of Tags
- 224.6 Summary of HTF Subprograms
225 HTP
- 225.1 HTP Operational Notes
- 225.2 HTP Rules and Limits
- 225.3 HTP Examples
- 225.4 HTP Summary of Tags
- 225.5 Summary of HTP Subprograms
226 OWA_CACHE
- 226.1 OWA_CACHE Constants
- 226.2 Summary of OWA_CACHE Subprograms
227 OWA_COOKIE
- 227.1 OWA_CUSTOM Overview
- 227.2 OWA_COOKIE Types
- 227.3 OWA_COOKIE Rules and Limits
- 227.4 Summary of OWA_COOKIE Subprograms
228 OWA_CUSTOM
- 228.1 OWA_CUSTOM Constants
- 228.2 Summary of OWA_CUSTOM Subprograms
  - 228.2.1 AUTHORIZE Function
229 OWA_IMAGE
- 229.1 OWA_IMAGE Overview
- 229.2 OWA_IMAGE Types
- 229.3 OWA_IMAGE Variables
- 229.4 OWA_IMAGE Examples
- 229.5 Summary of OWA_IMAGE Subprograms
  - 229.5.1 GET_X Function
  - 229.5.2 GET_Y Function
230 OWA_OPT_LOCK
- 230.1 OWA_OPT_LOCK Overview
- 230.2 OWA_TEXT Types
- 230.3 Summary of OWA_OPT_LOCK Subprograms
231 OWA_PATTERN
- 231.1 OWA_PATTERN Types
- 231.2 OWA_PATTERN Operational Notes
- 231.3 Summary of OWA_PATTERN Subprograms
232 OWA_SEC
- 232.1 OWA_SEC Operational Notes
- 232.2 Summary of OWA_SEC Subprograms
233 OWA_TEXT
- 233.1 OWA_OPT_LOCK Types
- 233.2 Summary of OWA_TEXT Subprograms
234 OWA_UTIL
- 234.1 OWA_UTIL Overview
- 234.2 OWA_UTIL Types
- 234.3 Summary of OWA_UTIL Subprograms
235 SDO_CS
236 SDO_CSW_PROCESS
237 SDO_GCDR
238 SDO_GEOM
239 SDO_GEOR
240 SDO_GEOR_ADMIN
241 SDO_GEOR_AGGR
242 SDO_GEOR_RA
243 SDO_GEOR_UTL
244 SDO_LRS
245 SDO_MIGRATE
246 SDO_NET
247 SDO_NFE
248 SDO_OLS
249 SDO_PC_PKG
250 SDO_SAM
251 SDO_TIN_PKG
252 SDO_TOPO
253 SDO_TOPO_MAP
254 SDO_TUNE
255 SDO_UTIL
256 SDO_WFS_LOCK
257 SDO_WFS_PROCESS
258 SEM_APIS
259 SEM_OLS
260 SEM_PERF
261 SEM_RDFCTX
262 SEM_RDFSA
263 UTL_CALL_STACK
- 263.1 UTL_CALL_STACK Overview
- 263.2 UTL_CALL_STACK Security Model
- 263.3 UTL_CALL_STACK Operational Notes
- 263.4 UTL_CALL_STACK Exceptions
- 263.5 UTL_CALL_STACK Data Structures
  - 263.5.1 UNIT_QUALIFIED_NAME
- 263.6 Summary of UTL_CALL_STACK Subprograms
264 UTL_COLL
- 264.1 Summary of UTL_COLL Subprograms
  - 264.1.1 IS_LOCATOR Function
265 UTL_COMPRESS
- 265.1 UTL_COMPRESS Constants
- 265.2 UTL_COMPRESS Exceptions
- 265.3 UTL_COMPRESS Operational Notes
- 265.4 Summary of UTL_COMPRESS Subprograms
266 UTL_ENCODE
- 266.1 Summary of UTL_ENCODE Subprograms
267 UTL_FILE
- 267.1 UTL_FILE Security Model
- 267.2 UTL_FILE Operational Notes
- 267.3 UTL_FILE Rules and Limits
- 267.4 UTL_FILE Exceptions
- 267.5 UTL_FILE Examples
- 267.6 UTL_FILE Data Structures
  - 267.6.1 FILETYPE Record Type
- 267.7 Summary of UTL_FILE Subprograms
268 UTL_HTTP
- 268.1 UTL_HTTP Overview
- 268.2 UTL_HTTP Security Model
- 268.3 UTL_HTTP Constants
- 268.4 UTL_HTTP Exceptions
- 268.5 UTL_HTTP Examples
- 268.6 UTL_HTTP Data Structures
- 268.7 UTL_HTTP Operations
- 268.8 UTL_HTTP Subprogram Groups
- 268.9 Summary of UTL_HTTP Subprograms
269 UTL_I18N
- 269.1 UTL_I18N Overview
- 269.2 UTL_I18N Security Model
- 269.3 UTL_I18N Constants
- 269.4 Summary of UTL_I18N Subprograms
270 UTL_IDENT
- 270.1 UTL_IDENT Overview
- 270.2 UTL_IDENT Security Model
- 270.3 UTL_IDENT Constants
271 UTL_INADDR
- 271.1 UTL_INADDR Security Model
- 271.2 UTL_INADDR Exceptions
- 271.3 UTL_INADDR Examples
- 271.4 Summary of UTL_INADDR Subprograms
  - 271.4.1 GET_HOST_ADDRESS Function
  - 271.4.2 GET_HOST_NAME Function
272 UTL_LMS
- 272.1 UTL_LMS Security Model
- 272.2 Summary of UTL_LMS Subprograms
  - 272.2.1 FORMAT_MESSAGE Function
  - 272.2.2 GET_MESSAGE Function
273 UTL_MAIL
- 273.1 UTL_MAIL Security Model
- 273.2 UTL_MAIL Operational Notes
- 273.3 UTL_MAIL Rules and Limits
- 273.4 Summary of UTL_MAIL Subprograms
274 UTL_MATCH
- 274.1 UTL_MATCH Overview
- 274.2 UTL_MATCH Security Model
- 274.3 Summary of UTL_MATCH Subprograms
275 UTL_NLA
- 275.1 UTL_NLA Overview
- 275.2 UTL_NLA Rules and Limits
- 275.3 UTL_NLA Security Model
- 275.4 Subprogram Groups
- 275.5 Summary of UTL_NLA Subprograms
276 UTL_RAW
- 276.1 UTL_RAW Overview
- 276.2 UTL_RAW Operational Notes
- 276.3 Summary of UTL_RAW Subprograms
277 UTL_RECOMP
- 277.1 UTL_RECOMP Overview
- 277.2 UTL_RECOMP Operational Notes
- 277.3 UTL_RECOMP Examples
- 277.4 Summary of UTL_RECOMP Subprograms
  - 277.4.1 RECOMP_PARALLEL Procedure
  - 277.4.2 RECOMP_SERIAL Procedure
278 UTL_REF
- 278.1 UTL_REF Overview
- 278.2 UTL_REF Security Model
- 278.3 UTL_REF Types
- 278.4 UTL_REF Exceptions
- 278.5 Summary of UTL_REF Subprograms
279 UTL_RPADV
- 279.1 UTL_RPADV Overview
- 279.2 DBMS_COMPARISON Security Model
- 279.3 UTL_RPADV Operational Notes
- 279.4 Summary of UTL_RPADV Subprograms
280 UTL_SMTP
- 280.1 UTL_SMTP Overview
- 280.2 UTL_SMTP Security Model
- 280.3 UTL_SMTP Constants
- 280.4 UTL_SMTP Types
- 280.5 UTL_SMTP Reply Codes
- 280.6 UTL_SMTP Operational Notes
- 280.7 UTL_SMTP Exceptions
- 280.8 UTL_SMTP Rules and Limits
- 280.9 UTL_SMTP Examples
- 280.10 Summary of UTL_SMTP Subprograms
281 UTL_TCP
- 281.1 UTL_TCP Overview
- 281.2 UTL_TCP Security Model
- 281.3 UTL_TCP Types
- 281.4 UTL_TCP Exceptions
- 281.5 UTL_TCP Rules and Limits
- 281.6 UTL_TCP Examples
- 281.7 Summary of UTL_TCP Subprograms
282 UTL_URL
- 282.1 UTL_URL Overview
- 282.2 UTL_URL Exceptions
- 282.3 UTL_URL Examples
- 282.4 Summary of UTL_URL Subprograms
  - 282.4.1 ESCAPE Function
  - 282.4.2 UNESCAPE Function
283 WPG_DOCLOAD
- 283.1 WPG_DOCLOAD Constants
- 283.2 Summary of WPG_DOCLOAD Subprograms
  - 283.2.1 DOWNLOAD_FILE Procedures
284 ANYDATA TYPE
- 284.1 ANYDATA TYPE Restrictions
- 284.2 ANYDATA TYPE Operational Notes
- 284.3 Summary of ANYDATA Subprograms
285 ANYDATASET TYPE
- 285.1 ANYDATASET TYPE Construction
- 285.2 Summary of ANYDATASET TYPE Subprograms
286 ANYTYPE TYPE
- 286.1 Summary of ANYTYPE Subprograms
287 Oracle Database Advanced Queuing (AQ) Types
- 287.1 Advanced Queuing (AQ)Types Security Model
- 287.2 Oracle Database Advanced Queuing (AQ) Types —Summary of Types
288 DBFS Content Interface Types
- 288.1 DDBFS Content Interface Types Overview
- 288.2 DBFS Content Interface Types Security Model
- 288.3 DBFS Content Interface Types —Data Structures
289 Database URI TYPEs
- 289.1 Summary of URITYPE Supertype Subprograms
- 289.2 Summary of HTTPURITYPE Subtype Subprograms
- 289.3 Summary of DBURITYPE Subtype Subprogams
- 289.4 Summary of XDBURITYPE Subtype Subprograms
- 289.5 Summary of URIFACTORY Package Subprograms
290 JMS Types
- 290.1 JMS Types Overview
- 290.2 JMS Types Security Model
- 290.3 Java Versus PL/SQL Datatypes
- 290.4 More on Bytes, Stream and Map Messages
- 290.5 Upcasting and Downcasting Between General and Specific Messages
- 290.6 JMS Types Error Reporting
- 290.7 Oracle JMS Type Constants
- 290.8 CONVERT_JMS_SELECTOR
- 290.9 Summary of JMS Types
291 JSON Data Structures
- 291.1 JSON_ELEMENT_T Object Type
- 291.2 JSON_OBJECT_T Object Type
- 291.3 JSON_ARRAY_T Object Type
- 291.4 JSON_SCALAR_T Object Type
- 291.5 JSON_KEY_LIST Type
292 Logical Change Record TYPEs
- 292.1 Logical Change Record TYPEs Overview
- 292.2 Logical Change Record Types Security Model
- 292.3 Summary of Logical Change Record Types
293 MGD_ID Package Types
- 293.1 MGD_ID Package Types Security Model
- 293.2 Summary of Types
- 293.3 Summary of MGD_ID Subprograms
294 Rule TYPEs
- 294.1 Rule TYPEs Overview
- 294.2 Rule TYPEs Security Model
- 294.3 Summary of Rule Types
295 SODA Types
- 295.1 SODA Types Overview
- 295.2 SODA Types Security Model
- 295.3 Summary of SODA Types
296 UTL Streams Types
- 296.1 UTL Streams Types Security Model
- 296.2 Summary of UTL Binary Streams Types
297 XMLTYPE
- 297.1 Summary of XMLType Subprograms
Index