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 19c, Version 19.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_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
19 DBMS_APP_CONT_ADMIN
- 19.1 DBMS_APP_CONT_ADMIN Security Model
- 19.2 Summary of DBMS_APP_CONT_ADMIN Subprograms
20 DBMS_APP_CONT_REPORT
- 20.1 DBMS_APP_CONT_REPORT Security Model
- 20.2 Summary of DBMS_APP_CONT_REPORT Subprograms
  - 20.2.1 ACCHK_REPORT Procedure
21 DBMS_APPLICATION_INFO
- 21.1 DBMS_APPLICATION_INFO Overview
- 21.2 DBMS_APPLICATION_INFO Security Model
- 21.3 DBMS_APPLICATION_INFO Operational Notes
- 21.4 Summary of DBMS_APPLICATION_INFO Subprograms
22 DBMS_APPLY_ADM
- 22.1 DBMS_APPLY_ADM Overview
- 22.2 DBMS_APPLY_ADM Security Model
- 22.3 DBMS_APPLY_ADM Deprecated Subprograms
- 22.4 Summary of DBMS_APPLY_ADM Subprograms
23 DBMS_AQ
- 23.1 DBMS_AQ Security Model
- 23.2 DBMS_AQ Constants
- 23.3 DBMS_AQ Data Types
- 23.4 DBMS_AQ Operational Notes
- 23.5 Summary of DBMS_AQ Subprograms
24 DBMS_AQADM
- 24.1 DBMS_AQADM Security Model
- 24.2 DBMS_AQADM Constants
- 24.3 DBMS_AQADM Subprogram Groups
- 24.4 Summary of DBMS_AQADM Subprograms
25 DBMS_AQELM
- 25.1 DBMS_AQELM Security Model
- 25.2 Summary of DBMS_AQELM Subprograms
26 DBMS_AQIN
- 26.1 DBMS_AQIN Security Model
27 DBMS_ASSERT
- 27.1 DBMS_ASSERT Operational Notes
- 27.2 Summary of DBMS_ASSERT Subprograms
28 DBMS_AUDIT_MGMT
- 28.1 DBMS_AUDIT_MGMT Overview
- 28.2 DBMS_AUDIT_MGMT Deprecated Subprograms
- 28.3 DBMS_AUDIT_MGMT Security Model
- 28.4 DBMS_AUDIT_MGMT Constants
- 28.5 DBMS_AUDIT_MGMT Views
- 28.6 DBMS_AUDIT_MGMT Subprogram Groups
  - 28.6.1 DBMS_AUDIT_MGMT Audit Trail Management Subprograms
  - 28.6.2 DBMS_AUDIT_MGMT Audit Trail Cleanup Subprograms
- 28.7 Summary of DBMS_AUDIT_MGMT Subprograms
29 DBMS_AUDIT_UTIL
- 29.1 DBMS_AUDIT_UTIL Overview
- 29.2 DBMS_AUDIT_UTIL Security Model
- 29.3 DBMS_AUDIT_UTIL Views
- 29.4 Summary of DBMS_AUDIT_UTIL Subprograms
30 DBMS_AUTO_SQLTUNE
- 30.1 DBMS_AUTO_SQLTUNE Overview
- 30.2 DBMS_AUTO_SQLTUNE Security Model
- 30.3 Summary of DBMS_AUTO_SQLTUNE Subprograms
31 DBMS_AUTO_INDEX
- 31.1 DBMS_AUTO_INDEX Overview
- 31.2 Summary of DBMS_AUTO_INDEX Subprograms
32 DBMS_AUTO_REPORT
- 32.1 DBMS_AUTO_REPORT Overview
- 32.2 DBMS_AUTO_REPORT Security Model
- 32.3 Summary of DBMS_AUTO_REPORT Subprograms
33 DBMS_AUTO_TASK_ADMIN
- 33.1 DBMS_AUTO_TASK_ADMIN Deprecated Subprograms
- 33.2 DBMS_AUTO_TASK_ADMIN Security Model
- 33.3 DBMS_AUTO_TASK_ADMIN Constants
- 33.4 Summary of DBMS_AUTO_TASK_ADMIN Subprograms
34 DBMS_AW_STATS
- 34.1 Using DBMS_AW_STATS
- 34.2 Summary of DBMS_AW_STATS Subprograms
  - 34.2.1 ANALYZE Procedure
  - 34.2.2 CLEAR Procedure
35 DBMS_BLOCKCHAIN_TABLE
- 35.1 DBMS_BLOCKCHAIN_TABLE Overview
- 35.2 DBMS_BLOCKCHAIN_TABLE Security Model
- 35.3 Summary of DBMS_BLOCKCHAIN_TABLE Subprograms
36 DBMS_CAPTURE_ADM
- 36.1 DBMS_CAPTURE_ADM Overview
- 36.2 DBMS_CAPTURE_ADM Security Model
- 36.3 Summary of DBMS_CAPTURE_ADM Subprograms
37 DBMS_CLOUD
- 37.1 DBMS_CLOUD Overview
- 37.2 Installing the DBMS_CLOUD Package
- 37.3 DBMS_CLOUD Security Model
- 37.4 DBMS_CLOUD Exceptions
- 37.5 Summary of DBMS_CLOUD Subprograms
- 37.6 DBMS_CLOUD Package File URI Formats
- 37.7 DBMS_CLOUD Package Format Options
- 37.8 DBMS_CLOUD Avro and Parquet Support
38 DBMS_COMPARISON
- 38.1 DBMS_COMPARISON Overview
- 38.2 DBMS_COMPARISON Security Model
- 38.3 DBMS_COMPARISON Constants
- 38.4 DBMS_COMPARISON Views
- 38.5 DBMS_COMPARISON Operational Notes
- 38.6 DBMS_COMPARISON Data Structures
  - 38.6.1 COMPARISON_TYPE Record Type
- 38.7 Summary of DBMS_COMPARISON Subprograms
39 DBMS_COMPRESSION
- 39.1 DBMS_COMPRESSION Overview
- 39.2 DBMS_COMPRESSION Security Model
- 39.3 DBMS_COMPRESSION Constants
- 39.4 DBMS_COMPRESSION Data Structures
  - 39.4.1 COMPREC Record Type
  - 39.4.2 COMPRECLIST Table Type
- 39.5 Summary of DBMS_COMPRESSION Subprograms
  - 39.5.1 GET_COMPRESSION_RATIO Procedure
  - 39.5.2 GET_COMPRESSION_TYPE Function
40 DBMS_CONNECTION_POOL
- 40.1 Summary of DBMS_CONNECTION_POOL Subprograms
41 DBMS_CQ_NOTIFICATION
- 41.1 DBMS_CQ_NOTIFICATION Overview
- 41.2 DBMS_CQ_NOTIFICATION Security Model
- 41.3 DBMS_CQ_NOTIFICATION Constants
- 41.4 DBMS_CQ_NOTIFICATION Operational Notes
- 41.5 DBMS_CQ_NOTIFICATION Examples
- 41.6 DBMS_CQ_NOTIFICATION Data Structures
- 41.7 Summary of DBMS_CQ_NOTIFICATION Subprograms
42 DBMS_CREDENTIAL
- 42.1 DBMS_CREDENTIAL Overview
- 42.2 DBMS_CREDENTIAL Security Model
- 42.3 DBMS_CREDENTIAL Operational Notes
- 42.4 Summary of DBMS_CREDENTIAL Subprograms
43 DBMS_CRYPTO
- 43.1 DBMS_CRYPTO Overview
- 43.2 DBMS_CRYPTO Security Model
- 43.3 DBMS_CRYPTO Datatypes
- 43.4 DBMS_CRYPTO Algorithms
- 43.5 DBMS_CRYPTO Restrictions
- 43.6 DBMS_CRYPTO Exceptions
- 43.7 DBMS_CRYPTO Operational Notes
- 43.8 DBMS_CRYPTO Examples
- 43.9 Summary of DBMS_CRYPTO Subprograms
44 DBMS_CSX_ADMIN
- 44.1 DBMS_CSX_ADMIN Overview
- 44.2 DBMS_CSX_ADMIN Security Model
- 44.3 DBMS_CSX_ADMIN Constants
- 44.4 Summary of DBMS_CSX_ADMIN Subprograms
45 DBMS_CUBE
- 45.1 Using DBMS_CUBE
  - 45.1.1 DBMS_CUBE Security Model
- 45.2 Using SQL Aggregation Management
- 45.3 Upgrading 10g Analytic Workspaces
- 45.4 Summary of DBMS_CUBE Subprograms
46 DBMS_CUBE_ADVISE
- 46.1 DBMS_CUBE_ADVISE Security Model
- 46.2 Summary of DBMS_CUBE_ADVISE Subprograms
47 DBMS_CUBE_LOG
- 47.1 Using DBMS_CUBE_LOG
- 47.2 Summary of DBMS_CUBE_LOG Subprograms
48 DBMS_DATA_MINING
- 48.1 DBMS_DATA_MINING Overview
- 48.2 DBMS_DATA_MINING Security Model
- 48.3 DBMS_DATA_MINING — Mining Functions
- 48.4 DBMS_DATA_MINING — Model Settings
- 48.5 DBMS_DATA_MINING — Solver Settings
  - 48.5.1 DBMS_DATA_MINING — Solver Settings: ADMM
  - 48.5.2 DBMS_DATA_MINING — Solver Settings: LBFGS
- 48.6 DBMS_DATA_MINING Datatypes
  - 48.6.1 Deprecated Types
- 48.7 Summary of DBMS_DATA_MINING Subprograms
49 DBMS_DATA_MINING_TRANSFORM
- 49.1 DBMS_DATA_MINING_TRANSFORM Overview
- 49.2 DBMS_DATA_MINING_TRANSFORM Operational Notes
- 49.3 DBMS_DATA_MINING_TRANSFORM Security Model
- 49.4 DBMS_DATA_MINING_TRANSFORM Datatypes
- 49.5 DBMS_DATA_MINING_TRANSFORM Constants
- 49.6 Summary of DBMS_DATA_MINING_TRANSFORM Subprograms
50 DBMS_DATAPUMP
- 50.1 DBMS_DATAPUMP Overview
- 50.2 DBMS_DATAPUMP Security Model
- 50.3 DBMS_DATAPUMP Constants
- 50.4 DBMS_DATAPUMP Data Structures
- 50.5 Summary of DBMS_DATAPUMP Subprograms
51 DBMS_DB_VERSION
- 51.1 DBMS_DB_VERSION Overview
- 51.2 DBMS_DB_VERSION Constants
- 51.3 DBMS_DB_VERSION Examples
52 DBMS_DBCOMP
- 52.1 Using DBMS_DBCOMP
- 52.2 DBMS_DBCOMP Security Model
- 52.3 Summary of the DBMS_DBCOMP Subprogram
  - 52.3.1 DBCOMP Procedure
53 DBMS_DBFS_CONTENT
- 53.1 DBMS_DBFS_CONTENT Overview
- 53.2 DBMS_DBFS_CONTENT Security Model
- 53.3 DBMS_DBFS_CONTENT Constants
- 53.4 Exceptions
- 53.5 DBMS_DBFS_CONTENT Operational Notes
- 53.6 DBMS_DBFS_CONTENT Data Structures
- 53.7 Summary of DBMS_DBFS_CONTENT Subprograms
54 DBMS_DBFS_CONTENT_SPI
- 54.1 ODBMS_DBFS_CONTENT_SPI Overview
- 54.2 DBMS_DBFS_CONTENT_SPI Security Model
- 54.3 DBMS_DBFS_CONTENT_SPI Operational Notes
- 54.4 Summary of DBMS_DBFS_CONTENT_SPI Subprograms
55 DBMS_DBFS_HS
- 55.1 DBMS_DBFS_HS Overview
- 55.2 DBMS_DBFS_HS Security Model
- 55.3 DBMS_DBFS_HS Constants
- 55.4 DBMS_DBFS_HS Operational Notes
- 55.5 Summary of DBMS_DBFS_HS Subprograms
56 DBMS_DBFS_SFS
- 56.1 DBMS_DBFS_SFS Overview
- 56.2 DBMS_DBFS_SFS Security Model
- 56.3 DBMS_DBFS_SFS Constants
- 56.4 Summary of DBMS_DBFS_SFS Subprograms
57 DBMS_DDL
- 57.1 DBMS_DDL Deprecated Subprograms
- 57.2 DBMS_DDL Security Model
- 57.3 DBMS_DDL Operational Notes
- 57.4 Summary of DBMS_DDL Subprograms
58 DBMS_DEBUG
- 58.1 DBMS_DEBUG Overview
- 58.2 DBMS_DEBUG Constants
- 58.3 DBMS_DEBUG Variables
- 58.4 DBMS_DEBUG Exceptions
- 58.5 DBMS_DEBUG Operational Notes
- 58.6 DBMS_DEBUG Data Structures
- 58.7 Summary of DBMS_DEBUG Subprograms
59 DBMS_DEBUG_JDWP
- 59.1 DBMS_DEBUG_JDWP Overview
- 59.2 DBMS_DEBUG_JDWP Security Model
- 59.3 Summary DBMS_DEBUG_JDWP Subprograms
60 DBMS_DEBUG_JDWP_CUSTOM
- 60.1 DBMS_DEBUG_JDWP_CUSTOM Overview
- 60.2 DBMS_DEBUG_JDWP_CUSTOM Security Model
- 60.3 Summary DBMS_DEBUG_JDWP_CUSTOM Subprograms
  - 60.3.1 CONNECT_DEBUGGER Procedure
61 DBMS_DESCRIBE
- 61.1 DBMS_DESCRIBE Overview
- 61.2 DBMS_DESCRIBE Security Model
- 61.3 DBMS_DESCRIBE Types
- 61.4 DBMS_DESCRIBE Exceptions
- 61.5 DBMS_DESCRIBE Examples
- 61.6 Summary of DBMS_DESCRIBE Subprograms
  - 61.6.1 DESCRIBE_PROCEDURE Procedure
62 DBMS_DG
- 62.1 Using DBMS_DG
- 62.2 DBMS_DG Security Model
- 62.3 Summary of the DBMS_DG Subprogram
  - 62.3.1 INITIATE_FS_FAILOVER Procedure
63 DBMS_DICTIONARY_CHECK
- 63.1 Overview of Oracle Database Dictionary Check
- 63.2 Using DBMS_DICTIONARY_CHECK
- 63.3 Summary of DBMS_DICTIONARY_CHECK Subprograms
64 DBMS_DIMENSION
- 64.1 DBMS_DIMENSION Security Model
- 64.2 Summary of DBMS_DIMENSION Subprograms
  - 64.2.1 DESCRIBE_DIMENSION Procedure
  - 64.2.2 VALIDATE_DIMENSION Procedure
65 DBMS_DISTRIBUTED_TRUST_ADMIN
- 65.1 DBMS_DISTRIBUTED_TRUST_ADMIN Overview
- 65.2 DBMS_DISTRIBUTED_TRUST_ADMIN Security Model
- 65.3 DBMS_DISTRIBUTED_TRUST_ADMIN Examples
- 65.4 Summary of DBMS_DISTRIBUTED_TRUST_ADMIN Subprograms
66 DBMS_DNFS
- 66.1 DBMS_DNFS Security Model
- 66.2 Summary of DBMS_DNFS Subprograms
67 DBMS_DST
- 67.1 DBMS_DST Overview
- 67.2 DBMS_DST Security Model
- 67.3 DBMS_DST Views
- 67.4 Summary of DBMS_DST Subprograms
68 DBMS_EDITIONS_UTILITIES
- 68.1 DBMS_EDITIONS_UTILITIES Overview
- 68.2 DBMS_EDITIONS_UTILITIES Security Model
- 68.3 DBMS_EDITIONS_UTILITIES Exceptions
- 68.4 Summary of DBMS_EDITIONS_UTILITIES Subprograms
69 DBMS_EPG
- 69.1 DBMS_EPG Overview
- 69.2 DBMS_EPG Security Model
- 69.3 DBMS_EPG Exceptions
- 69.4 DBMS_EPG Data Structures
- 69.5 DBMS_EPG Subprogram Groups
  - 69.5.1 DBMS_EPG Configuration Subprograms
  - 69.5.2 DBMS_EPG Authorization Subprograms
- 69.6 Summary of DBMS_EPG Subprograms
70 DBMS_ERRLOG
- 70.1 DBMS_ERRLOG Security Model
- 70.2 Summary of DBMS_ERRLOG Subprograms
  - 70.2.1 CREATE_ERROR_LOG Procedure
71 DBMS_FGA
- 71.1 DBMS_FGA Security Model
- 71.2 DBMS_FGA Operational Notes
- 71.3 Summary of DBMS_FGA Subprograms
72 DBMS_FILE_GROUP
- 72.1 DBMS_FILE_GROUP Overview
- 72.2 DBMS_FILE_GROUP Security Model
- 72.3 DBMS_FILE_GROUP Constants
- 72.4 Summary of DBMS_FILE_GROUP Subprograms
73 DBMS_FILE_TRANSFER
- 73.1 DBMS_FILE_TRANSFER Overview
- 73.2 DBMS_FILE_TRANSFER Security Model
- 73.3 DBMS_FILE_TRANSFER Operational Notes
- 73.4 Summary of DBMS_FILE_TRANSFER Subprograms
74 DBMS_FLASHBACK
- 74.1 DBMS_FLASHBACK Overview
- 74.2 DBMS_FLASHBACK Security Model
- 74.3 DBMS_FLASHBACK Types
- 74.4 DBMS_FLASHBACK Exceptions
- 74.5 DBMS_FLASHBACK Operational Notes
- 74.6 DBMS_FLASHBACK Examples
- 74.7 Summary of DBMS_FLASHBACK Subprograms
75 DBMS_FLASHBACK_ARCHIVE
- 75.1 DBMS_FLASHBACK_ARCHIVE Overview
- 75.2 DBMS_FLASHBACK_ARCHIVE Security Model
- 75.3 DBMS_FLASHBACK_ARCHIVE Constants
- 75.4 Summary of DBMS_FLASHBACK_ARCHIVE Subprograms
76 DBMS_FREQUENT_ITEMSET
- 76.1 Summary of DBMS_FREQUENT_ITEMSET Subprograms
  - 76.1.1 FI_HORIZONTAL Function
  - 76.1.2 FI_TRANSACTIONAL Function
77 DBMS_FS
- 77.1 DBMS_FS Overview
- 77.2 DBMS_FS Security Model
- 77.3 Summary of DBMS_FS Subprograms
78 DBMS_GOLDENGATE_ADM
- 78.1 Using DBMS_GOLDENGATE_ADM
  - 78.1.1 DBMS_GOLDENGATE_ADM Overview
  - 78.1.2 DBMS_GOLDENGATE_ADM Security Model
- 78.2 Summary of DBMS_GOLDENGATE_ADM Subprograms
79 DBMS_GOLDENGATE_AUTH
- 79.1 DBMS_GOLDENGATE_AUTH Overview
- 79.2 DBMS_GOLDENGATE_AUTH Security Model
- 79.3 Summary of DBMS_GOLDENGATE_AUTH Subprograms
  - 79.3.1 GRANT_ADMIN_PRIVILEGE Procedure
  - 79.3.2 REVOKE_ADMIN_PRIVILEGE Procedure
80 DBMS_HADOOP
- 80.1 DBMS_HADOOP Overview
- 80.2 DBMS_HADOOP Security Model
- 80.3 Summary of DBMS_HADOOP Subprograms
81 DBMS_HANG_MANAGER
- 81.1 DBMS_HANG_MANAGER Overview
- 81.2 DBMS_HANG_MANAGER Security Model
- 81.3 DBMS_HANG_MANAGER Constants
- 81.4 DBMS_HANG_MANAGER Exceptions
- 81.5 Summary of DBMS_HANG_MANAGER Subprograms
  - 81.5.1 SET Procedure
82 DBMS_HEAT_MAP
- 82.1 DBMS_HEAT_MAP Overview
- 82.2 DBMS_HEAT_MAP Security Model
- 82.3 Summary of DBMS_HEAT_MAP Subprograms
83 DBMS_HIERARCHY
- 83.1 DBMS_HIERARCHY Overview
- 83.2 DBMS_HIERARCHY Security Model
- 83.3 Summary of DBMS_HIERARCHY Subprograms
84 DBMS_HM
- 84.1 DBMS_HM Security Model
- 84.2 Summary of DBMS_HM Subprograms
  - 84.2.1 GET_RUN_REPORT Function
  - 84.2.2 RUN_CHECK Procedure
85 DBMS_HPROF
- 85.1 DBMS_HPROF Security Model
- 85.2 Summary of DBMS_HPROF Subprograms
86 DBMS_HS_PARALLEL
- 86.1 Using the DBMS_HS_PARALLEL Subprogram
- 86.2 Summary of DBMS_HS_PARALLEL Subprograms
87 DBMS_HS_PASSTHROUGH
- 87.1 DBMS_HS_PASSTHROUGH Overview
- 87.2 DBMS_HS_PASSTHROUGH Operational Notes
- 87.3 Summary of DBMS_HS_PASSTHROUGH Subprograms
88 DBMS_ILM
- 88.1 DBMS_ILM Overview
- 88.2 DBMS_ILM Security Model
- 88.3 DBMS_ILM Constants
- 88.4 DBMS_ILM Exceptions
- 88.5 Summary of DBMS_ILM Subprograms
89 DBMS_ILM_ADMIN
- 89.1 DBMS_ILM_ADMIN Overview
- 89.2 DBMS_ILM_ADMIN Security Model
- 89.3 DBMS_ILM_ADMIN Constants
- 89.4 Summary of DBMS_ILM_ADMIN Subprograms
90 DBMS_IMMUTABLE_TABLE
- 90.1 DBMS_IMMUTABLE_TABLE Overview
- 90.2 DBMS_IMMUTABLE_TABLE Security Model
- 90.3 Summary of DBMS_IMMUTABLE_TABLE Subprograms
  - 90.3.1 DELETE_EXPIRED_ROWS Procedure
91 DBMS_INMEMORY
- 91.1 DBMS_INMEMORY Overview
- 91.2 DBMS_INMEMORY Security Model
- 91.3 Summary of DBMS_INMEMORY Subprograms
92 DBMS_INMEMORY_ADMIN
- 92.1 DBMS_INMEMORY_ADMIN Overview
- 92.2 DBMS_INMEMORY_ADMIN Security Model
- 92.3 DBMS_INMEMORY_ADMIN Operational Notes
- 92.4 Summary of DBMS_INMEMORY_ADMIN Subprograms
93 DBMS_INMEMORY_ADVISE
- 93.1 DBMS_INMEMORY_ADVISE Overview
- 93.2 Summary of DBMS_INMEMORY_ADVISE Subprograms
- 93.3 IS_INMEMORY_ELIGIBLE Procedure
94 DBMS_IOT
- 94.1 Summary of DBMS_IOT Subprograms
  - 94.1.1 BUILD_CHAIN_ROWS_TABLE Procedure
  - 94.1.2 BUILD_EXCEPTIONS_TABLE Procedure
95 DBMS_JAVA
96 DBMS_JOB
- 96.1 DBMS_JOB Security Model
- 96.2 DBMS_JOB Operational Notes
- 96.3 Summary of DBMS_JOB Subprograms
97 DBMS_JSON
- 97.1 DBMS_JSON Overview
- 97.2 DBMS_JSON Security Model
- 97.3 DBMS_JSON Constants
- 97.4 Summary of DBMS_JSON Subprograms
98 DBMS_LDAP
99 DBMS_LDAP_UTL
100 DBMS_LIBCACHE
- 100.1 DBMS_LIBCACHE Overview
- 100.2 DBMS_LIBCACHE Security Model
- 100.3 Summary of DBMS_LIBCACHE Subprograms
  - 100.3.1 COMPILE_FROM_REMOTE Procedure
101 DBMS_LOB
- 101.1 DBMS_LOB Overview
- 101.2 DBMS_LOB Deprecated Subprograms
- 101.3 DBMS_LOB Security Model
- 101.4 DBMS_LOB Constants
- 101.5 DBMS_LOB Datatypes
- 101.6 DBMS_LOB Operational Notes
- 101.7 DBMS_LOB Rules and Limits
- 101.8 DBMS_LOB Exceptions
- 101.9 Summary of DBMS_LOB Subprograms
102 DBMS_LOCK
- 102.1 DBMS_LOCK Overview
- 102.2 DBMS_LOCK Security Model
- 102.3 DBMS_LOCK Constants
- 102.4 DBMS_LOCK. Rules and Limits
- 102.5 DBMS_LOCK Operational Notes
- 102.6 Summary of DBMS_LOCK Subprograms
103 DBMS_LOGMNR
- 103.1 DBMS_LOGMNR Overview
- 103.2 DBMS_LOGMNR Security Model
- 103.3 DBMS_LOGMNR Constants
- 103.4 DBMS_LOGMNR Views
- 103.5 DBMS_LOGMNR Operational Notes
- 103.6 Summary of DBMS_LOGMNR Subprograms
104 DBMS_LOGSTDBY
- 104.1 DBMS_LOGSTDBY Overview
- 104.2 DBMS_LOGSTDBY Security Model
- 104.3 DBMS_LOGSTDBY Constants
- 104.4 Summary of DBMS_LOGSTDBY Subprograms
105 DBMS_LOGMNR_D
- 105.1 DBMS_LOGMNR_D Overview
- 105.2 DBMS_LOGMNR_D Security Model
- 105.3 Summary of DBMS_LOGMNR_D Subprograms
  - 105.3.1 BUILD Procedure
  - 105.3.2 SET_TABLESPACE Procedure
106 DBMS_LOGSTDBY_CONTEXT
- 106.1 DBMS_LOGSTDBY_CONTEXT Overview
- 106.2 DBMS_LOGSTDBY_CONTEXT Security Model
- 106.3 Summary of DBMS_LOGSTDBY_CONTEXT Subprograms
107 DBMS_MEMOPTIMIZE
- 107.1 DBMS_MEMOPTIMIZE Overview
- 107.2 Summary of DBMS_MEMOPTIMIZE Subprograms
108 DBMS_MEMOPTIMIZE_ADMIN
- 108.1 DBMS_MEMOPTIMIZE_ADMIN Overview
- 108.2 Summary of DBMS_MEMOPTIMIZE_ADMIN Subprograms
  - 108.2.1 WRITES_FLUSH Procedure
109 DBMS_METADATA
- 109.1 DBMS_METADATA Overview
- 109.2 DBMS_METADATA Security Model
- 109.3 Rules and Limits
- 109.4 DBMS_METADATA Data Structures - Object and Table Types
- 109.5 DBMS_METADATA Subprogram Groupings
  - 109.5.1 DBMS_METADATA Subprograms for Retrieving Multiple Objects From the Database
  - 109.5.2 DBMS_METADATA Subprograms for Submitting XML to the Database
- 109.6 Summary of All DBMS_METADATA Subprograms
110 DBMS_METADATA_DIFF
- 110.1 DBMS_METADATA_DIFF Overview
- 110.2 DBMS_METADATA_DIFF Security Model
- 110.3 DBMS_METADATA_DIFF — Browsing APIs for Fetching and Comparing Objects
- 110.4 Summary of DBMS_METADATA_DIFF Subprograms
111 DBMS_MGD_ID_UTL
- 111.1 DBMS_MGD_ID_UTL Security Model
- 111.2 DBMS_MGD_ID_UTL Constants
- 111.3 DBMS_MGD_ID_UTL Exceptions
- 111.4 Summary of DBMS_MGD_ID_UTL Subprograms
112 DBMS_MGWADM
- 112.1 DBMS_MGWADM Security Model
- 112.2 DBMS_MGWADM Deprecated Subprograms
- 112.3 DBMS_MGWADM Constants
- 112.4 DBMS_MGWADM Data Structures
- 112.5 Summary of DBMS_MGWADM Subprograms
113 DBMS_MGWMSG
- 113.1 DBMS_MGWMSG Security Model
- 113.2 DBMS_MGWMSG Constants
- 113.3 DBMS_MGWMSG Types
- 113.4 Summary of DBMS_MGWMSG Subprograms
114 DBMS_MONITOR
- 114.1 Summary of DBMS_MONITOR Subprograms
115 DBMS_MVIEW
- 115.1 DBMS_MVIEW Operational Notes
- 115.2 DBMS_MVIEW Security Model
- 115.3 DBMS_MVIEW Rules and Limits
- 115.4 Summary of DBMS_MVIEW Subprograms
116 DBMS_MVIEW_STATS
- 116.1 DBMS_MVIEW_STATS Overview
- 116.2 DBMS_MVIEW_STATS Security Model
- 116.3 Summary of DBMS_MVIEW_STATS Subprograms
117 DBMS_NETWORK_ACL_ADMIN
- 117.1 DBMS_NETWORK_ACL_ADMIN Overview
- 117.2 DBMS_NETWORK_ACL_ADMIN Deprecated Subprograms
- 117.3 DBMS_NETWORK_ACL_ADMIN Security Model
- 117.4 DBMS_NETWORK_ACL_ADMIN Constants
- 117.5 DBMS_NETWORK_ACL_ADMIN Exceptions
- 117.6 DBMS_NETWORK_ACL_ADMIN Examples
- 117.7 Summary of DBMS_NETWORK_ACL_ADMIN Subprograms
118 DBMS_NETWORK_ACL_UTILITY
- 118.1 DBMS_NETWORK_ACL_UTILITY Security Model
- 118.2 DBMS_NETWORK_ACL_UTILITY Examples
- 118.3 Summary of DBMS_NETWORK_ACL_UTILITY Subprograms
119 DBMS_ODCI
- 119.1 Summary of DBMS_ODCI Subprograms
  - 119.1.1 ESTIMATE_CPU_UNITS Function
120 DBMS_OPTIM_BUNDLE
- 120.1 DBMS_OPTIM_BUNDLE Security Model
- 120.2 Summary of DBMS_OPTIM_BUNDLE Subprograms
121 DBMS_OUTLN
- 121.1 DBMS_OUTLN Overview
- 121.2 DBMS_OUTLN Security Model
- 121.3 Summary of DBMS_OUTLN Subprograms
122 DBMS_OUTPUT
- 122.1 DBMS_OUTPUT Overview
- 122.2 DBMS_OUTPUT Security Model
- 122.3 DBMS_OUTPUT Operational Notes
- 122.4 DBMS_OUTPUT Exceptions
- 122.5 DBMS_OUTPUT Rules and Limits
- 122.6 DBMS_OUTPUT Examples
- 122.7 DBMS_OUTPUT Data Structures
  - 122.7.1 CHARARR Table Type
  - 122.7.2 DBMS_OUTPUT DBMSOUTPUT_LINESARRAY Object Type
- 122.8 Summary of DBMS_OUTPUT Subprograms
123 DBMS_PARALLEL_EXECUTE
- 123.1 DBMS_PARALLEL_EXECUTE Overview
- 123.2 DBMS_PARALLEL_EXECUTE Security Model
- 123.3 DBMS_PARALLEL_EXECUTE Constants
- 123.4 DBMS_PARALLEL_EXECUTE Views
- 123.5 DBMS_PARALLEL_EXECUTE Exceptions
- 123.6 DBMS_PARALLEL_EXECUTE Examples
- 123.7 Summary of DBMS_PARALLEL_EXECUTE Subprograms
124 DBMS_PART
- 124.1 DBMS_PART Security Model
- 124.2 DBMS_PART Operational Notes
- 124.3 Summary of DBMS_PART Subprograms
125 DBMS_PCLXUTIL
- 125.1 DBMS_PCLXUTIL Overview
- 125.2 DBMS_PCLXUTIL Security Model
- 125.3 DBMS_PCLXUTIL Operational Notes
- 125.4 DBMS_PCLXUTIL Rules and Limits
- 125.5 Summary of DBMS_PCLXUTIL Subprograms
  - 125.5.1 BUILD_PART_INDEX Procedure
126 DBMS_PDB
- 126.1 DBMS_PDB Overview
- 126.2 DBMS_PDB Security Model
- 126.3 Summary of DBMS_PDB Subprograms
127 DBMS_PDB_ALTER_SHARING
- 127.1 DBMS_PDB_ALTER_SHARING Overview
- 127.2 DBMS_PDB_ALTER_SHARING Security Model
- 127.3 Summary of DBMS_PDB_ALTER_SHARING Subprograms
128 DBMS_PERF
- 128.1 DBMS_PERF Overview
- 128.2 DBMS_PERF Security Model
- 128.3 Summary of DBMS_PERF Subprograms
129 DBMS_PIPE
- 129.1 DBMS_PIPE Overview
- 129.2 DBMS_PIPE Security Model
- 129.3 DBMS_PIPE Constants
- 129.4 DBMS_PIPE Operational Notes
- 129.5 DBMS_PIPE Exceptions
- 129.6 DBMS_PIPE Examples
- 129.7 Summary of DBMS_PIPE Subprograms
130 DBMS_PLSQL_CODE_COVERAGE
- 130.1 DBMS_PLSQL_CODE_COVERAGE Overview
- 130.2 DBMS_PLSQL_CODE_COVERAGE Security Model
- 130.3 Summary of DBMS_PLSQL_CODE_COVERAGE Subprograms
131 DBMS_PREDICTIVE_ANALYTICS
- 131.1 DBMS_PREDICTIVE_ANALYTICS Overview
- 131.2 DBMS_PREDICTIVE_ANALYTICS Security Model
- 131.3 Summary of DBMS_PREDICTIVE_ANALYTICS Subprograms
132 DBMS_PREPROCESSOR
- 132.1 DBMS_PREPROCESSOR Overview
- 132.2 DBMS_PREPROCESSOR Operating Notes
- 132.3 DBMS_PREPROCESSOR Data Structures
  - 132.3.1 DBMS_PREPROCESSOR SOURCE_LINES_T Table Type
- 132.4 Summary of DBMS_PREPROCESSOR Subprograms
  - 132.4.1 GET_POST_PROCESSED_SOURCE Functions
  - 132.4.2 PRINT_POST_PROCESSED_SOURCE Procedures
133 DBMS_PRIVILEGE_CAPTURE
- 133.1 DBMS_PRIVILEGE_CAPTURE Overview
- 133.2 DBMS_PRIVILEGE_CAPTURE Security Model
- 133.3 DBMS_PRIVILEGE_CAPTURE Constants
- 133.4 DBMS_PRIVILEGE_CAPTURE Examples
- 133.5 Summary of DBMS_PRIVILEGE_CAPTURE Subprograms
134 DBMS_PROCESS
- 134.1 DBMS_PROCESS Overview
- 134.2 DBMS_PROCESS Security Model
- 134.3 Summary of DBMS_PROCESS Subprograms
135 DBMS_PROFILER
- 135.1 DBMS_PROFILER Overview
- 135.2 DBMS_PROFILER Security Model
- 135.3 DBMS_PROFILER Operational Notes
- 135.4 DBMS_PROFILER Exceptions
- 135.5 Summary of DBMS_PROFILER Subprograms
136 DBMS_PROPAGATION_ADM
- 136.1 DBMS_PROPAGATION_ADM Overview
- 136.2 DBMS_PROPAGATION_ADM Security Model
- 136.3 Summary of DBMS_PROPAGATION_ADM Subprograms
137 DBMS_QOPATCH
- 137.1 DBMS_QOPATCH Overview
- 137.2 DBMS_QOPATCH Security Model
- 137.3 DBMS_QOPATCH Operational Notes
- 137.4 DBMS_QOPATCH Exceptions
- 137.5 Summary of DBMS_QOPATCH Subprograms
138 DBMS_RANDOM
- 138.1 DBMS_RANDOM Deprecated Subprograms
- 138.2 DBMS_RANDOM Security Model
- 138.3 DBMS_RANDOM Operational Notes
- 138.4 Summary of DBMS_RANDOM Subprograms
139 DBMS_REDACT
- 139.1 DBMS_REDACT Overview
- 139.2 DBMS_REDACT Security Model
- 139.3 DBMS_REDACT Constants
- 139.4 DBMS_REDACT Operating Procedures
- 139.5 Summary of DBMS_REDACT Subprograms
140 DBMS_REDEFINITION
- 140.1 DBMS_REDEFINITION Overview
- 140.2 DBMS_REDEFINITION Security Model
- 140.3 DBMS_REDEFINITION Constants
- 140.4 DBMS_REDEFINITION Operational Notes
- 140.5 DBMS_REDEFINITION Rules and Limits
- 140.6 DBMS_REDEFINITION Examples
- 140.7 Summary of DBMS_REDEFINITION Subprograms
141 DBMS_REFRESH
- 141.1 DBMS_REFRESH Overview
- 141.2 DBMS_REFRESH Security Model
- 141.3 Summary of DBMS_REFRESH Subprograms
142 DBMS_REPAIR
- 142.1 DBMS_REPAIR Overview
- 142.2 DBMS_REPAIR Security Model
- 142.3 DBMS_REPAIR Constants
- 142.4 DBMS_REPAIR Operating Notes
- 142.5 DBMS_REPAIR Exceptions
- 142.6 DBMS_REPAIR Examples
- 142.7 Summary of DBMS_REPAIR Subprograms
143 DBMS_RESCONFIG
- 143.1 DBMS_RESCONFIG Overview
- 143.2 Summary of DBMS_RESCONFIG Subprograms
144 DBMS_RESOURCE_MANAGER
- 144.1 DBMS_RESOURCE_MANAGER Deprecated Subprograms
- 144.2 DBMS_RESOURCE_MANAGER Security Model
- 144.3 DBMS_RESOURCE_MANAGER Constants
- 144.4 Summary of DBMS_RESOURCE_MANAGER Subprograms
145 DBMS_RESOURCE_MANAGER_PRIVS
- 145.1 Summary of DBMS_RESOURCE_MANAGER_PRIVS Subprograms
146 DBMS_RESULT_CACHE
- 146.1 DBMS_RESULT_CACHE Security Model
- 146.2 DBMS_RESULT_CACHE Constants
- 146.3 Summary of DBMS_RESULT_CACHE Subprograms
147 DBMS_RESUMABLE
- 147.1 DBMS_RESUMABLE Operational Notes
- 147.2 Summary of DBMS_RESUMABLE Subprograms
148 DBMS_RLS
- 148.1 DBMS_RLS Overview
- 148.2 DBMS_RLS Security Model
- 148.3 DBMS_RLS Constants
- 148.4 DBMS_RLS Operational Notes
- 148.5 DBMS_RLS Rules and Limits
- 148.6 Summary of DBMS_RLS Subprograms
149 DBMS_ROLLING
- 149.1 DBMS_ROLLING Overview
- 149.2 DBMS_ROLLING Security Model
- 149.3 Summary of DBMS_ROLLING Subprograms
150 DBMS_ROWID
- 150.1 DBMS_ROWID Security Model
- 150.2 DBMS_ROWID Types
- 150.3 DBMS_ROWID Exceptions
- 150.4 DBMS_ROWID Operational Notes
- 150.5 DBMS_ROWID Examples
- 150.6 Summary of DBMS_ROWID Subprograms
151 DBMS_RULE
- 151.1 DBMS_RULE Overview
- 151.2 DBMS_RULE Security Model
- 151.3 Summary of DBMS_RULE Subprograms
152 DBMS_RULE_ADM
- 152.1 DBMS_RULE_ADM Overview
- 152.2 DBMS_RULE_ADM Security Model
- 152.3 Summary of DBMS_RULE_ADM Subprograms
153 DBMS_SCHEDULER
- 153.1 DBMS_SCHEDULER Deprecated Subprograms
- 153.2 DBMS_SCHEDULER Security Model
- 153.3 DBMS_SCHEDULER Rules and Limits
- 153.4 DBMS_SCHEDULER Operational Notes
- 153.5 DBMS_SCHEDULER Data Structures
- 153.6 Summary of DBMS_SCHEDULER Subprograms
154 DBMS_SERVER_ALERT
- 154.1 DBMS_SERVER_ALERT Security Model
- 154.2 DBMS_SERVER_ALERT Object Types
- 154.3 DBMS_SERVER_ALERT Relational Operators
- 154.4 DBMS_SERVER_ALERT Supported Metrics
- 154.5 Summary of DBMS_SERVER_ALERT Subprograms
155 DBMS_SERVICE
- 155.1 DBMS_SERVICE Overview
- 155.2 DBMS_SERVICE Security Model
- 155.3 DBMS_SERVICE Constants
- 155.4 DBMS_SERVICE Operating Procedures
- 155.5 DBMS_SERVICE Exceptions
- 155.6 Summary of DBMS_SERVICE Subprograms
156 DBMS_SESSION
- 156.1 DBMS_SESSION Security Model
- 156.2 DBMS_SESSION Operational Notes
- 156.3 DBMS_SESSION Data Structures
  - 156.3.1 DBMS_SERVICE INTEGER_ARRAY Table Type
  - 156.3.2 DBMS_SERVICE LNAME_ARRAY Table Type
- 156.4 Summary of DBMS_SESSION Subprograms
157 DBMS_SFW_ACL_ADMIN
- 157.1 DBMS_SFW_ACL_ADMIN Security Model
- 157.2 DBMS_SFW_ACL_ADMIN Operational Notes
- 157.3 DBMS_SFW_ACL_ADMIN Examples
- 157.4 Summary of DBMS_SFW_ACL_ADMIN Subprograms
158 DBMS_SODA
- 158.1 DBMS_SODA Security Model
- 158.2 Summary of DBMS_SODA Subprograms
159 DBMS_SHARED_POOL
- 159.1 DBMS_SHARED_POOL Overview
- 159.2 DBMS_SHARED_POOL Operational Notes
- 159.3 Summary of DBMS_SHARED_POOL Subprograms
160 DBMS_SPACE
- 160.1 DBMS_SPACE Security Model
- 160.2 DBMS_SPACE Data Structures
- 160.3 Summary of DBMS_SPACE Subprograms
161 DBMS_SPACE_ADMIN
- 161.1 DBMS_SPACE_ADMIN Security Model
- 161.2 DBMS_SPACE_ADMIN Constants
- 161.3 DBMS_SPACE_ADMIN Operational Notes
- 161.4 Summary of DBMS_SPACE_ADMIN Subprograms
162 DBMS_SPD
- 162.1 DBMS_SPD Overview
- 162.2 DBMS_SPD Security Model
- 162.3 DBMS_SPD Views
- 162.4 Summary of DBMS_SPD Subprograms
163 DBMS_SPM
- 163.1 DBMS_SPM Overview
- 163.2 DBMS_SPM Security Model
- 163.3 DBMS_SPM Constants
- 163.4 DBMS_SPM Examples
- 163.5 DBMS_SPM Data Structures
  - 163.5.1 DBMS_SPM NAMELIST Table Type
- 163.6 Summary of DBMS_SPM Subprograms
164 DBMS_SQL
- 164.1 DBMS_SQL Overview
- 164.2 DBMS_SQL Security Model
- 164.3 DBMS_SQL Constants
- 164.4 DBMS_SQL Operational Notes
- 164.5 DBMS_SQL Execution Flow
- 164.6 DBMS_SQL Exceptions
- 164.7 DBMS_SQL Examples
- 164.8 DBMS_SQL Data Structures
- 164.9 Summary of DBMS_SQL Subprograms
165 DBMS_SQL_MONITOR
- 165.1 DBMS_SQL_MONITOR Overview
- 165.2 DBMS_SQL_MONITOR Security Model
- 165.3 DBMS_SQL_MONITOR Constants
- 165.4 Summary of DBMS_SQL_MONITOR Subprograms
166 DBMS_SQL_TRANSLATOR
- 166.1 DBMS_SQL_TRANSLATOR Security Model
- 166.2 DBMS_SQL_TRANSLATOR Constants
- 166.3 DBMS_SQL_TRANSLATOR Operational Notes
- 166.4 DBMS_SQL_TRANSLATOR Exceptions
- 166.5 DBMS_SQL_TRANSLATOR Examples
- 166.6 Summary of DBMS_SQL_TRANSLATOR Subprograms
167 DBMS_SQLDIAG
- 167.1 DBMS_SQLDIAG Overview
- 167.2 DBMS_SQLDIAG Security Model
- 167.3 DBMS_SQLDIAG Constants
- 167.4 Summary of DBMS_SQLDIAG Subprograms
168 DBMS_SQLPA
- 168.1 DBMS_SQLPA Overview
- 168.2 DBMS_SQLPA Security Model
- 168.3 Summary of DBMS_SQLPA Subprograms
169 DBMS_SQLQ
- 169.1 DBMS_SQLQ Overview
- 169.2 Summary of DBMS_SQLQ Subprograms
170 DBMS_SQLSET
- 170.1 DBMS_SQLSET Overview
- 170.2 DBMS_SQLSET Security Model
- 170.3 DBMS_SQLSET Data Structures
  - 170.3.1 SQLSET_ROW Object Type
- 170.4 Summary of DBMS_SQLSET Subprograms
171 DBMS_SQLTUNE
- 171.1 DBMS_SQLTUNE Overview
- 171.2 DBMS_SQLTUNE Security Model
- 171.3 DBMS_SQLTUNE Data Structures
  - 171.3.1 SQLSET_ROW Object Type
- 171.4 DBMS_SQLTUNE Subprogram Groups
- 171.5 Summary of DBMS_SQLTUNE Subprograms
172 DBMS_STAT_FUNCS
- 172.1 Summary of DBMS_STAT_FUNCS Subprograms
173 DBMS_STATS
- 173.1 DBMS_STATS Overview
- 173.2 DBMS_STATS Deprecated Subprograms
- 173.3 DBMS_STATS Types
- 173.4 DBMS_STATS Constants
- 173.5 DBMS_STATS Operational Notes
- 173.6 DBMS_STATS Data Structures
  - 173.6.1 DBMS_STATS STAT_REC Record Type
- 173.7 Summary of DBMS_STATS Subprograms
174 DBMS_STORAGE_MAP
- 174.1 DBMS_STORAGE_MAP Overview
- 174.2 DBMS_STORAGE_MAP Operational Notes
- 174.3 Summary of DBMS_STORAGE_MAP Subprograms
175 DBMS_SYNC_REFRESH
- 175.1 DBMS_SYNC_REFRESH Overview
- 175.2 DBMS_SYNC_REFRESH Security Model
- 175.3 Summary of DBMS_SYNC_REFRESH Subprograms
176 DBMS_TABLE_DATA
- 176.1 DBMS_TABLE_DATA Overview
- 176.2 DBMS_TABLE_DATA Security Model
- 176.3 Summary of DBMS_TABLE_DATA Subprograms
177 DBMS_TDB
- 177.1 DBMS_TDB Overview
- 177.2 DBMS_TDB Security Model
- 177.3 DBMS_TDB Constants
- 177.4 DBMS_TDB Views
- 177.5 DBMS_TDB Operational Notes
- 177.6 Summary of DBMS_TDB Subprograms
  - 177.6.1 CHECK_DB Function
  - 177.6.2 CHECK_EXTERNAL Function
178 DBMS_TF
- 178.1 DBMS_TF Overview
- 178.2 DBMS_TF Security Model
- 178.3 DBMS_TF Constants
- 178.4 DBMS_TF Operational Notes
- 178.5 DBMS_TF Execution Flow
- 178.6 DBMS_TF Restrictions
- 178.7 DBMS_TF Examples
  - 178.7.1 Echo Polymorphic Table Function Example
- 178.8 DBMS_TF Data Structures
- 178.9 Summary of DBMS_TF Subprograms
179 DBMS_TNS
- 179.1 DBMS_TNS Overview
- 179.2 DBMS_TNS Security Model
- 179.3 Summary of DBMS_TNS Subprograms
  - 179.3.1 RESOLVE_TNSNAME Function
180 DBMS_TRACE
- 180.1 DBMS_TRACE Overview
- 180.2 DBMS_TRACE Security Model
- 180.3 DBMS_TRACE Constants
- 180.4 DBMS_TRACE Restrictions
- 180.5 DBMS_TRACE Operational Notes
- 180.6 Summary of DBMS_TRACE Subprograms
181 DBMS_TRANSACTION
- 181.1 DBMS_TRANSACTION Security Model
- 181.2 Summary of DBMS_TRANSACTION Subprograms
182 DBMS_TRANSFORM
- 182.1 Summary of DBMS_TRANSFORM Subprograms
183 DBMS_TSDP_MANAGE
- 183.1 DBMS_TSDP_MANAGE Overview
- 183.2 DBMS_TSDP_MANAGE Security Model
- 183.3 Summary of DBMS_TSDP_MANAGE Subprograms
184 DBMS_TSDP_PROTECT
- 184.1 DBMS_TSDP_PROTECT Overview
- 184.2 DBMS_TSDP_PROTECT Security Model
- 184.3 DBMS_TSDP_PROTECT Constants
- 184.4 DBMS_TSDP_PROTECT Data Structures
  - 184.4.1 FEATURE_OPTIONS Table Type
  - 184.4.2 POLICY_CONDITIONS Table Type
- 184.5 Summary of DBMS_TSDP_PROTECT Subprograms
185 DBMS_TTS
- 185.1 DBMS_TTS Security Model
- 185.2 DBMS_TTS Exceptions
- 185.3 DBMS_TTS Operational Notes
- 185.4 Summary of DBMS_TTS Subprograms
  - 185.4.1 DOWNGRADE Procedure
  - 185.4.2 TRANSPORT_SET_CHECK Procedure
186 DBMS_TYPES
- 186.1 DBMS_TYPES Constants
- 186.2 DBMS_TYPES Exceptions
187 DBMS_UNDO_ADV
- 187.1 Summary of DBMS_UNDO_ADV Subprograms
188 DBMS_UMF
- 188.1 Summary of DBMS_UMF Subprograms
189 DBMS_USER_CERTS
- 189.1 DBMS_USER_CERTS Overview
- 189.2 DBMS_USER_CERTS Security Model
- 189.3 Summary of DBMS_USER_CERTS Subprograms
  - 189.3.1 ADD_CERTIFICATE Procedure
  - 189.3.2 DROP_CERTIFICATE Procedure
190 DBMS_UTILITY
- 190.1 DBMS_UTILITY Deprecated Subprograms
- 190.2 DBMS_UTILITY Security Model
- 190.3 DBMS_UTILITY Constants
- 190.4 DBMS_UTILITY Exceptions
- 190.5 DBMS_UTILITY Data Structures
- 190.6 Summary of DBMS_UTILITY Subprograms
191 DBMS_WARNING
- 191.1 DBMS_WARNING Security Model
- 191.2 Summary of DBMS_WARNING Subprograms
192 DBMS_WM
193 DBMS_WORKLOAD_CAPTURE
- 193.1 DBMS_WORKLOAD_CAPTURE Overview
- 193.2 DBMS_WORKLOAD_CAPTURE Security Model
- 193.3 Summary of DBMS_WORKLOAD_CAPTURE Subprograms
194 DBMS_WORKLOAD_REPLAY
- 194.1 DBMS_WORKLOAD_REPLAY Overview
- 194.2 DBMS_WORKLOAD_REPLAY Security Model
- 194.3 Summary of DBMS_WORKLOAD_REPLAY Subprograms
195 DBMS_WORKLOAD_REPOSITORY
- 195.1 DBMS_WORKLOAD_REPOSITORY Examples
- 195.2 DBMS_WORKLOAD_REPOSITORY Data Structures
- 195.3 Summary of DBMS_WORKLOAD_REPOSITORY Subprograms
196 DBMS_XA
- 196.1 DBMS_XA Overview
- 196.2 DBMS_XA Security Model
- 196.3 DBMS_XA Constants
- 196.4 DBMS_XA Operational Notes
- 196.5 DBMS_XA Data Structures
  - 196.5.1 DBMS_XA DBMS_XA_XID Object Type
  - 196.5.2 DBMS_XA DBMS_XA_XID_ARRAY Table Type
- 196.6 Summary of DBMS_XA Subprograms
197 DBMS_XDB
- 197.1 DBMS_XDB Overview
- 197.2 DBMS_XDB Security Model
- 197.3 DBMS_XDB Constants
- 197.4 Summary of DBMS_XDB Subprograms
198 DBMS_XDB_ADMIN
- 198.1 DBMS_XDB_ADMIN Security Model
- 198.2 Summary of DBMS_XDB_ADMIN Subprograms
199 DBMS_XDB_CONFIG
- 199.1 DBMS_XDB_CONFIG Overview
- 199.2 DBMS_XDB_CONFIG Security Model
- 199.3 DBMS_XDB_CONFIG Constants
- 199.4 Summary of DBMS_XDB_CONFIG Subprograms
200 DBMS_XDB_CONSTANTS
- 200.1 DBMS_XDB_CONSTANTS Security Model
- 200.2 Summary of DBMS_XDB_CONSTANTS Subprograms
201 DBMS_XDB_REPOS
- 201.1 DBMS_XDB_REPOS Overview
- 201.2 DBMS_XDB_REPOS Security Model
- 201.3 DBMS_XDB_REPOS Constants
- 201.4 Summary of DBMS_XDB_REPOS Subprograms
202 DBMS_XDB_VERSION
- 202.1 DBMS_XDB_VERSION Security Model
- 202.2 Summary of DBMS_XDB_VERSION Subprograms
203 DBMS_XDBRESOURCE
- 203.1 DBMS_XDBRESOURCE Overview
- 203.2 DBMS_XDBRESOURCE Security Model
- 203.3 Summary of DBMS_XDBRESOURCE Subprograms
204 DBMS_XDBT
- 204.1 DBMS_XDBT Overview
- 204.2 DBMS_XDBT Security Model
- 204.3 DBMS_XDBT Operational Notes
- 204.4 Summary of DBMS_XDBT Subprograms
205 DBMS_XDBZ
- 205.1 DBMS_XDBZ Security Model
- 205.2 DBMS_XDBZ Constants
- 205.3 Summary of DBMS_XDBZ Subprograms
206 DBMS_XEVENT
- 206.1 DBMS_XEVENT Security Model
- 206.2 DBMS_XEVENT Constants
- 206.3 Subprogram Groups
- 206.4 Summary of DBMS_XEVENT Subprograms
207 DBMS_XMLDOM
- 207.1 DBMS_XMLDOM Overview
- 207.2 DBMS_XMLDOM Security Model
- 207.3 DBMS_XMLDOM Constants
- 207.4 DBMS_XMLDOM Types
- 207.5 DBMS_XMLDOM Exceptions
- 207.6 DBMS_XMLDOM Subprogram Groups
- 207.7 Summary of DBMS_XMLDOM Subprograms
208 DBMS_XMLGEN
- 208.1 DBMS_XMLGEN Security Model
- 208.2 Summary of DBMS_XMLGEN Subprograms
209 DBMS_XMLINDEX
- 209.1 DBMS_XMLINDEX Overview
- 209.2 DBMS_XMLINDEX Security Model
- 209.3 Summary of DBMS_XMLINDEX Subprograms
210 DBMS_XMLPARSER
- 210.1 DBMS_XMLPARSER Security Model
- 210.2 Summary of DBMS_XMLPARSER Subprograms
211 DBMS_XMLQUERY
- 211.1 DBMS_XMLQUERY Security Model
- 211.2 DBMS_XMLQUERY Constants
- 211.3 Types
- 211.4 Summary of DBMS_XMLQUERY Subprograms
212 DBMS_XMLSAVE
- 212.1 DBMS_XMLSAVE Security Model
- 212.2 DBMS_XMLSAVE Constants
- 212.3 Types
- 212.4 Summary of DBMS_XMLSAVE Subprograms
213 DBMS_XMLSCHEMA
- 213.1 DBMS_XMLSCHEMA Overview
- 213.2 DBMS_XMLSCHEMA Security Model
- 213.3 DBMS_XMLSCHEMA Constants
- 213.4 Views
- 213.5 DBMS_XMLSCHEMA Operational Notes
- 213.6 Summary of DBMS_XMLSCHEMA Subprograms
214 DBMS_XMLSCHEMA_ANNOTATE
- 214.1 DBMS_XMLSCHEMA_ANNOTATE Overview
- 214.2 DBMS_XMLSCHEMA_ANNOTATE Security Model
- 214.3 Summary of DBMS_XMLSCHEMA_ANNOTATE Subprograms
215 DBMS_XMLSCHEMA_UTIL
- 215.1 DBMS_XMLSCHEMA_UTIL Security Model
- 215.2 Summary of DBMS_XMLSCHEMA_UTIL Subprograms
  - 215.2.1 CONFORMING Function
  - 215.2.2 VALIDATE Procedure
216 DBMS_XMLSTORAGE_MANAGE
- 216.1 DBMS_XMLSTORAGE_MANAGE Overview
- 216.2 DBMS_XMLSTORAGE_MANAGE Security Model
- 216.3 Summary of DBMS_XMLSTORAGE_MANAGE Subprograms
217 DBMS_XMLSTORE
- 217.1 DBMS_XMLSTORE Security Model
- 217.2 Types
- 217.3 Summary of DBMS_XMLSTORE Subprograms
218 DBMS_XPLAN
- 218.1 DBMS_XPLAN Overview
- 218.2 DBMS_XPLAN Security Model
- 218.3 DBMS_XPLAN Data Structures
  - 218.3.1 DBMS_XPLAN PLAN_OBJECT_LIST Table Type
- 218.4 Examples
- 218.5 Summary of DBMS_XPLAN Subprograms
219 DBMS_XSLPROCESSOR
- 219.1 DBMS_XSLPROCESSOR Overview
- 219.2 DBMS_XSLPROCESSOR Deprecated Subprograms
- 219.3 DBMS_XSLPROCESSOR Security Model
- 219.4 Summary of DBMS_XSLPROCESSOR Subprograms
220 DBMS_XSTREAM_ADM
- 220.1 DBMS_XSTREAM_ADM Overview
- 220.2 DBMS_XSTREAM_ADM Security Model
- 220.3 DBMS_XSTREAM_ADM Operational Notes
- 220.4 Summary of DBMS_XSTREAM_ADM Subprograms
221 DBMS_XSTREAM_AUTH
- 221.1 DBMS_XSTREAM_AUTH Overview
- 221.2 DBMS_XSTREAM_AUTH Security Model
- 221.3 Summary of DBMS_XSTREAM_AUTH Subprograms
222 DEBUG_EXTPROC
- 222.1 DEBUG_EXTPROC Security Model
- 222.2 DEBUG_EXTPROC Operational Notes
- 222.3 Rules and Limits
- 222.4 Summary of DEBUG_EXTPROC Subprograms
  - 222.4.1 STARTUP_EXTPROC_AGENT Procedure
223 HTF
- 223.1 HTF Deprecated Subprograms
- 223.2 HTF Operational Notes
- 223.3 Rules and Limits
- 223.4 HTF Examples
- 223.5 Summary of Tags
- 223.6 Summary of HTF Subprograms
224 HTP
- 224.1 HTP Operational Notes
- 224.2 HTP Rules and Limits
- 224.3 HTP Examples
- 224.4 HTP Summary of Tags
- 224.5 Summary of HTP Subprograms
225 OWA_CACHE
- 225.1 OWA_CACHE Constants
- 225.2 Summary of OWA_CACHE Subprograms
226 OWA_COOKIE
- 226.1 OWA_CUSTOM Overview
- 226.2 OWA_COOKIE Types
- 226.3 OWA_COOKIE Rules and Limits
- 226.4 Summary of OWA_COOKIE Subprograms
227 OWA_CUSTOM
- 227.1 OWA_CUSTOM Constants
- 227.2 Summary of OWA_CUSTOM Subprograms
  - 227.2.1 AUTHORIZE Function
228 OWA_IMAGE
- 228.1 OWA_IMAGE Overview
- 228.2 OWA_IMAGE Types
- 228.3 OWA_IMAGE Variables
- 228.4 OWA_IMAGE Examples
- 228.5 Summary of OWA_IMAGE Subprograms
  - 228.5.1 GET_X Function
  - 228.5.2 GET_Y Function
229 OWA_OPT_LOCK
- 229.1 OWA_OPT_LOCK Overview
- 229.2 OWA_TEXT Types
- 229.3 Summary of OWA_OPT_LOCK Subprograms
230 OWA_PATTERN
- 230.1 OWA_PATTERN Types
- 230.2 OWA_PATTERN Operational Notes
- 230.3 Summary of OWA_PATTERN Subprograms
231 OWA_SEC
- 231.1 OWA_SEC Operational Notes
- 231.2 Summary of OWA_SEC Subprograms
232 OWA_TEXT
- 232.1 OWA_OPT_LOCK Types
- 232.2 Summary of OWA_TEXT Subprograms
233 OWA_UTIL
- 233.1 OWA_UTIL Overview
- 233.2 OWA_UTIL Types
- 233.3 Summary of OWA_UTIL Subprograms
234 SDO_CS
235 SDO_CSW_PROCESS
236 SDO_GCDR
237 SDO_GEOM
238 SDO_GEOR
239 SDO_GEOR_ADMIN
240 SDO_GEOR_AGGR
241 SDO_GEOR_RA
242 SDO_GEOR_UTL
243 SDO_LRS
244 SDO_MIGRATE
245 SDO_NET
246 SDO_NFE
247 SDO_OLS
248 SDO_PC_PKG
249 SDO_SAM
250 SDO_TIN_PKG
251 SDO_TOPO
252 SDO_TOPO_MAP
253 SDO_TUNE
254 SDO_UTIL
255 SDO_WFS_LOCK
256 SDO_WFS_PROCESS
257 SEM_APIS
258 SEM_OLS
259 SEM_PERF
260 SEM_RDFCTX
261 SEM_RDFSA
262 UTL_CALL_STACK
- 262.1 UTL_CALL_STACK Overview
- 262.2 UTL_CALL_STACK Security Model
- 262.3 UTL_CALL_STACK Operational Notes
- 262.4 UTL_CALL_STACK Exceptions
- 262.5 UTL_CALL_STACK Data Structures
  - 262.5.1 UNIT_QUALIFIED_NAME
- 262.6 Summary of UTL_CALL_STACK Subprograms
263 UTL_COLL
- 263.1 Summary of UTL_COLL Subprograms
  - 263.1.1 IS_LOCATOR Function
264 UTL_COMPRESS
- 264.1 UTL_COMPRESS Constants
- 264.2 UTL_COMPRESS Exceptions
- 264.3 UTL_COMPRESS Operational Notes
- 264.4 Summary of UTL_COMPRESS Subprograms
265 UTL_ENCODE
- 265.1 Summary of UTL_ENCODE Subprograms
266 UTL_FILE
- 266.1 UTL_FILE Security Model
- 266.2 UTL_FILE Operational Notes
- 266.3 UTL_FILE Rules and Limits
- 266.4 UTL_FILE Exceptions
- 266.5 UTL_FILE Examples
- 266.6 UTL_FILE Data Structures
  - 266.6.1 FILETYPE Record Type
- 266.7 Summary of UTL_FILE Subprograms
267 UTL_HTTP
- 267.1 UTL_HTTP Overview
- 267.2 UTL_HTTP Security Model
- 267.3 UTL_HTTP Constants
- 267.4 UTL_HTTP Exceptions
- 267.5 UTL_HTTP Examples
- 267.6 UTL_HTTP Data Structures
- 267.7 UTL_HTTP Operations
- 267.8 UTL_HTTP Subprogram Groups
- 267.9 Summary of UTL_HTTP Subprograms
268 UTL_I18N
- 268.1 UTL_I18N Overview
- 268.2 UTL_I18N Security Model
- 268.3 UTL_I18N Constants
- 268.4 Summary of UTL_I18N Subprograms
269 UTL_IDENT
- 269.1 UTL_IDENT Overview
- 269.2 UTL_IDENT Security Model
- 269.3 UTL_IDENT Constants
270 UTL_INADDR
- 270.1 UTL_INADDR Security Model
- 270.2 UTL_INADDR Exceptions
- 270.3 UTL_INADDR Examples
- 270.4 Summary of UTL_INADDR Subprograms
  - 270.4.1 GET_HOST_ADDRESS Function
  - 270.4.2 GET_HOST_NAME Function
271 UTL_LMS
- 271.1 UTL_LMS Security Model
- 271.2 Summary of UTL_LMS Subprograms
  - 271.2.1 FORMAT_MESSAGE Function
  - 271.2.2 GET_MESSAGE Function
272 UTL_MAIL
- 272.1 UTL_MAIL Security Model
- 272.2 UTL_MAIL Operational Notes
- 272.3 UTL_MAIL Rules and Limits
- 272.4 Summary of UTL_MAIL Subprograms
273 UTL_MATCH
- 273.1 UTL_MATCH Overview
- 273.2 UTL_MATCH Security Model
- 273.3 Summary of UTL_MATCH Subprograms
274 UTL_NLA
- 274.1 UTL_NLA Overview
- 274.2 UTL_NLA Rules and Limits
- 274.3 UTL_NLA Security Model
- 274.4 Subprogram Groups
- 274.5 Summary of UTL_NLA Subprograms
275 UTL_RAW
- 275.1 UTL_RAW Overview
- 275.2 UTL_RAW Operational Notes
- 275.3 Summary of UTL_RAW Subprograms
276 UTL_RECOMP
- 276.1 UTL_RECOMP Overview
- 276.2 UTL_RECOMP Operational Notes
- 276.3 UTL_RECOMP Examples
- 276.4 Summary of UTL_RECOMP Subprograms
  - 276.4.1 RECOMP_PARALLEL Procedure
  - 276.4.2 RECOMP_SERIAL Procedure
277 UTL_REF
- 277.1 UTL_REF Overview
- 277.2 UTL_REF Security Model
- 277.3 UTL_REF Types
- 277.4 UTL_REF Exceptions
- 277.5 Summary of UTL_REF Subprograms
278 UTL_RPADV
- 278.1 UTL_RPADV Overview
- 278.2 DBMS_COMPARISON Security Model
- 278.3 UTL_RPADV Operational Notes
- 278.4 Summary of UTL_RPADV Subprograms
279 UTL_SMTP
- 279.1 UTL_SMTP Overview
- 279.2 UTL_SMTP Security Model
- 279.3 UTL_SMTP Constants
- 279.4 UTL_SMTP Types
- 279.5 UTL_SMTP Reply Codes
- 279.6 UTL_SMTP Operational Notes
- 279.7 UTL_SMTP Exceptions
- 279.8 UTL_SMTP Rules and Limits
- 279.9 UTL_SMTP Examples
- 279.10 Summary of UTL_SMTP Subprograms
280 UTL_TCP
- 280.1 UTL_TCP Overview
- 280.2 UTL_TCP Security Model
- 280.3 UTL_TCP Types
- 280.4 UTL_TCP Exceptions
- 280.5 UTL_TCP Rules and Limits
- 280.6 UTL_TCP Examples
- 280.7 Summary of UTL_TCP Subprograms
281 UTL_URL
- 281.1 UTL_URL Overview
- 281.2 UTL_URL Exceptions
- 281.3 UTL_URL Examples
- 281.4 Summary of UTL_URL Subprograms
  - 281.4.1 ESCAPE Function
  - 281.4.2 UNESCAPE Function
282 WPG_DOCLOAD
- 282.1 WPG_DOCLOAD Constants
- 282.2 Summary of WPG_DOCLOAD Subprograms
  - 282.2.1 DOWNLOAD_FILE Procedures
283 ANYDATA TYPE
- 283.1 ANYDATA TYPE Restrictions
- 283.2 ANYDATA TYPE Operational Notes
- 283.3 Summary of ANYDATA Subprograms
284 ANYDATASET TYPE
- 284.1 ANYDATASET TYPE Construction
- 284.2 Summary of ANYDATASET TYPE Subprograms
285 ANYTYPE TYPE
- 285.1 Summary of ANYTYPE Subprograms
286 Oracle Database Advanced Queuing (AQ) Types
- 286.1 Advanced Queuing (AQ)Types Security Model
- 286.2 Oracle Database Advanced Queuing (AQ) Types —Summary of Types
287 DBFS Content Interface Types
- 287.1 DDBFS Content Interface Types Overview
- 287.2 DBFS Content Interface Types Security Model
- 287.3 DBFS Content Interface Types —Data Structures
288 Database URI TYPEs
- 288.1 Summary of URITYPE Supertype Subprograms
- 288.2 Summary of HTTPURITYPE Subtype Subprograms
- 288.3 Summary of DBURITYPE Subtype Subprogams
- 288.4 Summary of XDBURITYPE Subtype Subprograms
- 288.5 Summary of URIFACTORY Package Subprograms
289 JMS Types
- 289.1 JMS Types Overview
- 289.2 JMS Types Security Model
- 289.3 Java Versus PL/SQL Datatypes
- 289.4 More on Bytes, Stream and Map Messages
- 289.5 Upcasting and Downcasting Between General and Specific Messages
- 289.6 JMS Types Error Reporting
- 289.7 Oracle JMS Type Constants
- 289.8 CONVERT_JMS_SELECTOR
- 289.9 Summary of JMS Types
290 JSON Data Structures
- 290.1 JSON_ELEMENT_T Object Type
- 290.2 JSON_OBJECT_T Object Type
- 290.3 JSON_ARRAY_T Object Type
- 290.4 JSON_SCALAR_T Object Type
- 290.5 JSON_KEY_LIST Type
291 Logical Change Record TYPEs
- 291.1 Logical Change Record TYPEs Overview
- 291.2 Logical Change Record Types Security Model
- 291.3 Summary of Logical Change Record Types
292 MGD_ID Package Types
- 292.1 MGD_ID Package Types Security Model
- 292.2 Summary of Types
- 292.3 Summary of MGD_ID Subprograms
293 Rule TYPEs
- 293.1 Rule TYPEs Overview
- 293.2 Rule TYPEs Security Model
- 293.3 Summary of Rule Types
294 SODA Types
- 294.1 SODA Types Overview
- 294.2 SODA Types Security Model
- 294.3 Summary of SODA Types
295 UTL Streams Types
- 295.1 UTL Streams Types Security Model
- 295.2 Summary of UTL Binary Streams Types
296 XMLTYPE
- 296.1 Summary of XMLType Subprograms
Index