Table of Contents
- Title and Copyright Information
- Preface
- Changes in This Release for Oracle AI Database PL/SQL Packages and Types Reference
- 1 Introduction to Oracle Supplied PL/SQL Packages & Types
- 2 Oracle Application Express Packages APEX_APPLICATION Through APEX_ZIP
- 3 CTX_ADM
- 4 CTX_ANL
- 5 CTX_DDL
- 6 CTX_CLS
- 7 CTX_DOC
- 8 CTX_ENTITY
- 9 CTX_OUTPUT
- 10 CTX_QUERY
- 11 CTX_REPORT
- 12 CTX_THES
- 13 CTX_ULEXER
- 14 DBMS_ACTIVITY
- 
               
               
                  
                  15
                       DBMS_ADDM
               
                  
               
               
               - 15.1 DBMS_ADDM Security Model
- 
                     
                     
                        
                        15.2
                            Summary of DBMS_ADDM Subprograms
                     
                        
                     
                     
                     - 15.2.1 ANALYZE_DB Procedure
- 15.2.2 ANALYZE_INST Procedure
- 15.2.3 ANALYZE_PARTIAL Procedure
- 15.2.4 COMPARE_CAPTURE_REPLAY_REPORT Function
- 15.2.5 COMPARE_DATABASES Function
- 15.2.6 COMPARE_INSTANCES Function
- 15.2.7 COMPARE_REPLAY_REPLAY_REPORT Function
- 15.2.8 DELETE Procedure
- 15.2.9 DELETE_FINDING_DIRECTIVE Procedure
- 15.2.10 DELETE_PARAMETER_DIRECTIVE Procedure
- 15.2.11 DELETE_SEGMENT_DIRECTIVE Procedure
- 15.2.12 DELETE_SQL_DIRECTIVE Procedure
- 15.2.13 FAILED_AUTO_TASKS_REPORT Function
- 15.2.14 GET_ASH_QUERY Function
- 15.2.15 GET_REPORT Function
- 15.2.16 INSERT_FINDING_DIRECTIVE Procedure
- 15.2.17 INSERT_PARAMETER_DIRECTIVE Procedure
- 15.2.18 INSERT_SEGMENT_DIRECTIVE Procedure
- 15.2.19 INSERT_SQL_DIRECTIVE Procedure
- 15.2.20 REAL_TIME_ADDM_REPORT Function
- 15.2.21 REEXECUTE_FAILED_AUTO_TASKS Procedure
 
 
- 16 DBMS_ADVANCED_REWRITE
- 
               
               
                  
                  17
                      DBMS_ADVISOR
               
                  
               
               
               - 17.1 DBMS_ADVISOR Deprecated Subprograms
- 17.2 DBMS_ADVISOR Security Model
- 
                     
                     
                        
                        17.3
                            Summary of DBMS_ADVISOR Subprograms
                     
                        
                     
                     
                     - 17.3.1 ADD_SQLWKLD_REF Procedure
- 17.3.2 ADD_SQLWKLD_STATEMENT Procedure
- 17.3.3 ADD_STS_REF Procedure
- 17.3.4 CANCEL_TASK Procedure
- 17.3.5 COPY_SQLWKLD_TO_STS Procedure
- 17.3.6 CREATE_FILE Procedure
- 17.3.7 CREATE_OBJECT Procedure
- 17.3.8 CREATE_SQLWKLD Procedure
- 17.3.9 CREATE_TASK Procedures
- 17.3.10 DELETE_SQLWKLD Procedure
- 17.3.11 DELETE_SQLWKLD_REF Procedure
- 17.3.12 DELETE_SQLWKLD_STATEMENT Procedure
- 17.3.13 DELETE_STS_REF Procedure
- 17.3.14 DELETE_TASK Procedure
- 17.3.15 EXECUTE_TASK Procedure
- 17.3.16 GET_REC_ATTRIBUTES Procedure
- 17.3.17 GET_TASK_REPORT Function
- 17.3.18 GET_TASK_SCRIPT Function
- 17.3.19 IMPLEMENT_TASK Procedure
- 17.3.20 IMPORT_SQLWKLD_SCHEMA Procedure
- 17.3.21 IMPORT_SQLWKLD_SQLCACHE Procedure
- 17.3.22 IMPORT_SQLWKLD_STS Procedure
- 17.3.23 IMPORT_SQLWKLD_SUMADV Procedure
- 17.3.24 IMPORT_SQLWKLD_USER Procedure
- 17.3.25 INTERRUPT_TASK Procedure
- 17.3.26 MARK_RECOMMENDATION Procedure
- 17.3.27 QUICK_TUNE Procedure
- 17.3.28 RESET_SQLWKLD Procedure
- 17.3.29 RESET_TASK Procedure
- 17.3.30 SET_DEFAULT_SQLWKLD_PARAMETER Procedure
- 17.3.31 SET_DEFAULT_TASK_PARAMETER Procedure
- 17.3.32 SET_SQLWKLD_PARAMETER Procedure
- 17.3.33 SET_TASK_PARAMETER Procedure
- 17.3.34 TUNE_MVIEW Procedure
- 17.3.35 UPDATE_OBJECT Procedure
- 17.3.36 UPDATE_REC_ATTRIBUTES Procedure
- 17.3.37 UPDATE_SQLWKLD_ATTRIBUTES Procedure
- 17.3.38 UPDATE_SQLWKLD_STATEMENT Procedure
- 17.3.39 UPDATE_TASK_ATTRIBUTES Procedure
 
 
- 18 DBMS_AUTOIM
- 19 DBMS_ALERT
- 20 DBMS_APP_CONT
- 
               
               
                  
                  21
                      DBMS_APP_CONT_ADMIN
               
                  
               
               
               - 21.1 DBMS_APP_CONT_ADMIN Security Model
- 
                     
                     
                        
                        21.2
                            Summary of DBMS_APP_CONT_ADMIN Subprograms
                     
                        
                     
                     
                     - 21.2.1 ACCHK_CLEAR_FILTER Procedure
- 21.2.2 ACCHK_PURGE Procedure
- 21.2.3 ACCHK_SET Procedure
- 21.2.4 ACCHK_SET_FILTER Procedure
- 21.2.5 ACCHK_SHOW_FILTERS Procedure
- 21.2.6 ADD_SQL_CONNECTION_TEST Procedure
- 21.2.7 CHECK_REPLAY_RULES Procedure
- 21.2.8 CREATE_CHILD_SERVICE Procedure
- 21.2.9 DELETE_CHILD_SERVICE Procedure
- 21.2.10 DELETE_SQL_CONNECTION_TEST Procedure
- 21.2.11 DISABLE_CONNECTION_TEST Procedure
- 21.2.12 DISABLE_FAILOVER Procedure
- 21.2.13 DISABLE_SMART_CONNECTION Procedure
- 21.2.14 ENABLE_AC Procedure
- 21.2.15 ENABLE_CONNECTION_TEST Procedure
- 21.2.16 ENABLE_RESET_STATE Procedure
- 21.2.17 ENABLE_SMART_CONNECTION Procedure
- 21.2.18 ENABLE_TAC Procedure
- 21.2.19 ENABLE_TAF Procedure
- 21.2.20 ENABLE_TG Procedure
- 21.2.21 MODIFY_SERVICE Procedure
- 21.2.22 RESET_REPLAY_RULES Procedure
- 21.2.23 SET_DRAINING Procedure
- 21.2.24 SET_LOAD_BALANCING_GOAL Procedure
- 21.2.25 SET_REPLAY_RULES Procedure
 
 
- 22 DBMS_APP_CONT_REPORT
- 23 DBMS_APPLICATION_INFO
- 
               
               
                  
                  24
                       DBMS_APPLY_ADM
               
                  
               
               
               - 24.1 DBMS_APPLY_ADM Overview
- 24.2 DBMS_APPLY_ADM Security Model
- 24.3 DBMS_APPLY_ADM Deprecated Subprograms
- 
                     
                     
                        
                        24.4
                            Summary of DBMS_APPLY_ADM Subprograms
                     
                        
                     
                     
                     - 24.4.1 ALTER_APPLY Procedure
- 24.4.2 CLEAR_KEY_COLUMNS Procedure
- 24.4.3 COMPARE_OLD_VALUES Procedure
- 24.4.4 CREATE_APPLY Procedure
- 24.4.5 CREATE_OBJECT_DEPENDENCY Procedure
- 24.4.6 DELETE_ALL_ERRORS Procedure
- 24.4.7 DELETE_ERROR Procedure
- 24.4.8 DROP_APPLY Procedure
- 24.4.9 DROP_OBJECT_DEPENDENCY Procedure
- 24.4.10 EXECUTE_ALL_ERRORS Procedure
- 24.4.11 EXECUTE_ERROR Procedure
- 24.4.12 GET_ERROR_MESSAGE Function
- 24.4.13 HANDLE_COLLISIONS
- 24.4.14 SET_DML_CONFLICT_HANDLER Procedure
- 24.4.15 SET_DML_HANDLER Procedure
- 24.4.16 SET_ENQUEUE_DESTINATION Procedure
- 24.4.17 SET_EXECUTE Procedure
- 24.4.18 SET_GLOBAL_INSTANTIATION_SCN Procedure
- 24.4.19 SET_KEY_COLUMNS Procedures
- 24.4.20 SET_PARAMETER Procedure
- 24.4.21 SET_REPERROR_HANDLER Procedure
- 24.4.22 SET_SCHEMA_INSTANTIATION_SCN Procedure
- 24.4.23 SET_TABLE_INSTANTIATION_SCN Procedure
- 24.4.24 SET_UPDATE_CONFLICT_HANDLER Procedure
- 24.4.25 SET_VALUE_DEPENDENCY Procedure
- 24.4.26 START_APPLY Procedure
- 24.4.27 STOP_APPLY Procedure
 
 
- 25 DBMS_AQ
- 
               
               
                  
                  26
                       DBMS_AQADM 
               
                  
               
               
               - 26.1 DBMS_AQADM Security Model
- 26.2 DBMS_AQADM Constants
- 
                     
                     
                        
                        26.3
                            DBMS_AQADM Subprogram Groups
                     
                        
                     
                     
                     - 26.3.1 DBMS_AQADM Queue Table Subprograms
- 26.3.2 DBMS_AQADM Privilege Subprograms
- 26.3.3 DBMS_AQADM Queue Subprograms
- 26.3.4 DBMS_AQADM Subscriber Subprograms
- 26.3.5 DBMS_AQADM OKafka Subprograms
- 26.3.6 DBMS_AQADM Propagation Subprograms
- 26.3.7 DBMS_AQADM Miscellaneous Subprograms
- 26.3.8 DBMS_AQADM Agent Subprograms
- 26.3.9 DBMS_AQADM Alias Subprograms
 
- 
                     
                     
                        
                        26.4
                            Summary of DBMS_AQADM Subprograms
                     
                        
                     
                     
                     - 26.4.1 ADD_ALIAS_TO_LDAP Procedure
- 26.4.2 ADD_SUBSCRIBER Procedure
- 26.4.3 ALTER_AQ_AGENT Procedure
- 26.4.4 ALTER_PROPAGATION_SCHEDULE Procedure
- 26.4.5 ALTER_QUEUE Procedure
- 26.4.6 ALTER_QUEUE_TABLE Procedure
- 26.4.7 ALTER_SHARDED_QUEUE Procedure
- 26.4.8 ALTER_SUBSCRIBER Procedure
- 26.4.9 ALTER_TRANSACTIONAL_EVENT_QUEUE Procedure
- 26.4.10 CREATE_AQ_AGENT Procedure
- 26.4.11 CREATE_DATABASE_KAFKA_TOPIC Procedure
- 26.4.12 CREATE_NP_QUEUE Procedure
- 26.4.13 CREATE_QUEUE Procedure
- 26.4.14 CREATE_QUEUE_TABLE Procedure
- 26.4.15 CREATE_SHARDED_QUEUE Procedure
- 26.4.16 CREATE_EXCEPTION_QUEUE Procedure
- 26.4.17 CREATE_EQ EXCEPTION_QUEUE Procedure
- 26.4.18 CREATE_TRANSACTIONAL_EVENT_QUEUE Procedure
- 26.4.19 DEL_ALIAS_FROM_LDAP Procedure
- 26.4.20 DISABLE_DB_ACCESS Procedure
- 26.4.21 DISABLE_PROPAGATION_SCHEDULE Procedure
- 26.4.22 DROP_AQ_AGENT Procedure
- 26.4.23 DROP_DATABASE_KAFKA_TOPIC Procedure
- 26.4.24 DROP_QUEUE Procedure
- 26.4.25 DROP_QUEUE_TABLE Procedure
- 26.4.26 DROP_SHARDED_QUEUE Procedure
- 26.4.27 DROP_TRANSACTIONAL_EVENT_QUEUE Procedure
- 26.4.28 ENABLE_DB_ACCESS Procedure
- 26.4.29 ENABLE_JMS_TYPES Procedure
- 26.4.30 ENABLE_PROPAGATION_SCHEDULE Procedure
- 26.4.31 GET_MAX_STREAMS_POOL Procedure
- 26.4.32 GET_MIN_STREAMS_POOL Procedure
- 26.4.33 GET_QUEUE_PARAMETER Procedure
- 26.4.34 GET_WATERMARK Procedure
- 26.4.35 GRANT_QUEUE_PRIVILEGE Procedure
- 26.4.36 GRANT_SYSTEM_PRIVILEGE Procedure
- 26.4.37 MIGRATE_QUEUE_TABLE Procedure
- 26.4.38 MOVE_QUEUE_TABLE Procedure
- 26.4.39 PURGE_QUEUE_TABLE Procedure
- 26.4.40 QUEUE_SUBSCRIBERS Function
- 26.4.41 REMOVE_SUBSCRIBER Procedure
- 26.4.42 REVOKE_QUEUE_PRIVILEGE Procedure
- 26.4.43 REVOKE_SYSTEM_PRIVILEGE Procedure
- 26.4.44 SCHEDULE_PROPAGATION Procedure
- 26.4.45 SET_QUEUE_PARAMETER Procedure
- 26.4.46 SET_MAX_STREAMS_POOL Procedure
- 26.4.47 SET_MIN_STREAMS_POOL Procedure
- 26.4.48 SET_WATERMARK Procedure
- 26.4.49 START_QUEUE Procedure
- 26.4.50 STOP_QUEUE Procedure
- 26.4.51 UNSCHEDULE_PROPAGATION Procedure
- 26.4.52 UNSET_QUEUE_PARAMETER Procedure
- 26.4.53 VERIFY_QUEUE_TYPES Procedure
 
 
- 27 DBMS_AQELM
- 28 DBMS_AQIN
- 
               
               
                  
                  29
                       DBMS_AQMIGTOOL
               
                  
               
               
               - 29.1 DBMS_AQMIGTOOL Security Model
- 29.2 DBMS_AQMIGTOOL Constants
- 
                     
                     
                        
                        29.3
                            Summary of DBMS_AQMIGTOOL Subprograms
                     
                        
                     
                     
                     - 29.3.1 CANCEL_MIGRATION Procedure
- 29.3.2 CHECK_MIGRATED_MESSAGES Procedure
- 29.3.3 CHECK_MIGRATION_TO_TXEVENTQ Procedure
- 29.3.4 CHECK_STATUS Procedure
- 29.3.5 CLEAR_UNSUPPORTED_FEATURE_TABLE Procedure
- 29.3.6 COMMIT_MIGRATION Procedure
- 29.3.7 DISABLE_MIGRATION_CHECK Procedure
- 29.3.8 INIT_MIGRATION Procedure
- 29.3.9 PURGE_QUEUE_MESSAGES Procedure
- 29.3.10 RECOVER_MIGRATION Procedure
- 29.3.11 RENAME_QUEUE Procedure
 
 
- 30 DBMS_ASSERT
- 
               
               
                  
                  31
                      DBMS_AUDIT_MGMT
               
                  
               
               
               - 31.1 DBMS_AUDIT_MGMT Overview
- 31.2 DBMS_AUDIT_MGMT Deprecated and Desupported Subprograms
- 31.3 DBMS_AUDIT_MGMT Security Model
- 31.4 DBMS_AUDIT_MGMT Constants
- 31.5 DBMS_AUDIT_MGMT Views
- 31.6 DBMS_AUDIT_MGMT Subprogram Groups
- 
                     
                     
                        
                        31.7
                            Summary of DBMS_AUDIT_MGMT Subprograms
                     
                        
                     
                     
                     - 31.7.1 ALTER_PARTITION_INTERVAL Procedure
- 31.7.2 CLEAN_AUDIT_TRAIL Procedure
- 31.7.3 CLEAR_AUDIT_TRAIL_PROPERTY Procedure
- 31.7.4 CLEAR_LAST_ARCHIVE_TIMESTAMP Procedure
- 31.7.5 CREATE_PURGE_JOB Procedure
- 31.7.6 DEINIT_CLEANUP Procedure
- 31.7.7 DROP_OLD_UNIFIED_AUDIT_TABLES Procedure
- 31.7.8 DROP_PURGE_JOB Procedure
- 31.7.9 GET_AUDIT_COMMIT_DELAY Function
- 31.7.10 GET_ AUDIT_TRAIL_PROPERTY_VALUE Function
- 31.7.11 GET_LAST_ARCHIVE_TIMESTAMP Function
- 31.7.12 INIT_CLEANUP Procedure
- 31.7.13 IS_CLEANUP_INITIALIZED Function
- 31.7.14 LOAD_UNIFIED_AUDIT_FILES Procedure
- 31.7.15 SET_AUDIT_TRAIL_LOCATION Procedure
- 31.7.16 SET_AUDIT_TRAIL_PROPERTY Procedure
- 31.7.17 SET_LAST_ARCHIVE_TIMESTAMP Procedure
- 31.7.18 SET_PURGE_JOB_INTERVAL Procedure
- 31.7.19 SET_PURGE_JOB_STATUS Procedure
- 31.7.20 TRANSFER_UNIFIED_AUDIT_RECORDS Procedure
 
 
- 32 DBMS_AUDIT_UTIL
- 33 DBMS_AUTO_CLUSTERING
- 34 DBMS_AUTO_SQLTUNE
- 35 DBMS_AUTO_INDEX
- 36 DBMS_AUTO_MV
- 37 DBMS_AUTO_REPORT
- 38 DBMS_AUTO_TASK_ADMIN
- 39 DBMS_AUTO_ZONEMAP
- 
               
               
                  
                  40
                      DBMS_AVTUNE
               
                  
               
               
               - 40.1 DBMS_AVTUNE Overview
- 40.2 DBMS_AVTUNE Security Model
- 
                     
                     
                        
                        40.3
                            Summary of DBMS_AVTUNE Subprograms
                     
                        
                     
                     
                     - 40.3.1 AUTO_CACHE_CREATE Procedure
- 40.3.2 AUTO_CACHE_DISABLE Procedure
- 40.3.3 AUTO_CACHE_ENABLE Procedure
- 40.3.4 AUTO_CACHE_MODIFY Procedure
- 40.3.5 AUTO_CACHE_REFRESH Procedure
- 40.3.6 AUTO_CACHE_REMOVE Procedure
- 40.3.7 AUTO_CACHE_TUNE Procedure
- 40.3.8 AUTO_CACHE_STAR_DISABLE Procedure
- 40.3.9 AUTO_CACHE_STAR_ENABLE Procedure
- 40.3.10 AUTO_CACHE_STAR_MODIFY Procedure
- 40.3.11 AUTO_CACHE_STAR_REFRESH Procedure
 
 
- 41 DBMS_AW_STATS
- 
               
               
                  
                  42
                      DBMS_BLOCKCHAIN_TABLE
               
                  
               
               
               - 42.1 DBMS_BLOCKCHAIN_TABLE Overview
- 42.2 DBMS_BLOCKCHAIN_TABLE Security Model
- 
                     
                     
                        
                        42.3
                            Summary of DBMS_BLOCKCHAIN_TABLE Subprograms
                     
                        
                     
                     
                     - 42.3.1 ADD_INTERVAL_PARTITIONING Procedure
- 42.3.2 COUNTERSIGN_ROW Procedure
- 42.3.3 COUNTERSIGN_ROW_SPECIFIED_BY_KEY_COLUMNS Procedure
- 42.3.4 DELETE_EXPIRED_ROWS Procedure
- 42.3.5 GET_BLOCKCHAIN_DIGEST Function
- 42.3.6 GET_BLOCKCHAIN_DIGEST_FOR_SELECTED_ROWS Function
- 42.3.7 GET_BYTES_FOR_ROW_HASH Procedure
- 42.3.8 GET_BYTES_FOR_ROW_HASH_SPECIFIED_BY_KEY_COLUMNS Procedure
- 42.3.9 GET_BYTES_FOR_ROW_SIGNATURE Procedure
- 42.3.10 GET_BYTES_FOR_ROW_SIGNATURE_SPECIFIED_BY_KEY_COLUMNS Procedure
- 42.3.11 GET_SIGNED_BLOCKCHAIN_DIGEST Function
- 42.3.12 GET_SIGNED_BLOCKCHAIN_DIGEST_FOR_SELECTED_ROWS Function
- 42.3.13 SIGN_ROW Procedure
- 42.3.14 SIGN_ROW_SPECIFIED_BY_KEY_COLUMNS Procedure
- 42.3.15 SIGN_ROW_SPECIFIED_BY_KEY_COLUMNS_WITH_COUNTERSIGNATURE Procedure
- 42.3.16 SIGN_ROW_WITH_COUNTERSIGNATURE Procedure
- 42.3.17 VERIFY_ROWS Procedure
- 42.3.18 VERIFY_TABLE_BLOCKCHAIN Procedure
- 42.3.19 VERIFY_USER_BLOCKCHAIN_ROWS Procedure
 
 
- 43 DBMS_AWRAPP
- 44 DBMS_AWRAPP_ADMIN
- 45 DBMS_BLOCKER_RESOLVER
- 
               
               
                  
                  46
                       DBMS_CAPTURE_ADM
               
                  
               
               
               - 46.1 DBMS_CAPTURE_ADM Overview
- 46.2 DBMS_CAPTURE_ADM Security Model
- 
                     
                     
                        
                        46.3
                            Summary of DBMS_CAPTURE_ADM Subprograms
                     
                        
                     
                     
                     - 46.3.1 ABORT_GLOBAL_INSTANTIATION Procedure
- 46.3.2 ABORT_SCHEMA_INSTANTIATION Procedure
- 46.3.3 ABORT_SYNC_INSTANTIATION Procedure
- 46.3.4 ABORT_TABLE_INSTANTIATION Procedure
- 46.3.5 ALTER_CAPTURE Procedure
- 46.3.6 ALTER_SYNC_CAPTURE Procedure
- 46.3.7 BUILD Procedure
- 46.3.8 CREATE_CAPTURE Procedure
- 46.3.9 CREATE_SYNC_CAPTURE Procedure
- 46.3.10 DROP_CAPTURE Procedure
- 46.3.11 INCLUDE_EXTRA_ATTRIBUTE Procedure
- 46.3.12 PREPARE_GLOBAL_INSTANTIATION Procedure
- 46.3.13 PREPARE_SCHEMA_INSTANTIATION Procedure
- 46.3.14 PREPARE_SYNC_INSTANTIATION Function
- 46.3.15 PREPARE_TABLE_INSTANTIATION Procedure
- 46.3.16 SET_PARAMETER Procedure
- 46.3.17 START_CAPTURE Procedure
- 46.3.18 STOP_CAPTURE Procedure
 
 
- 47 DBMS_CACHEUTIL
- 
               
               
                  
                  48
                      DBMS_CLOUD
               
                  
               
               
               - 48.1 Installing DBMS_CLOUD
- 48.2 DBMS_CLOUD Endpoint Management
- 
                     
                     
                        
                        48.3
                            DBMS_CLOUD Subprograms and REST APIs
                     
                        
                     
                     
                     - 48.3.1 DBMS_CLOUD for Access Management
- 
                           
                           
                              
                              48.3.2
                                  DBMS_CLOUD  for Objects and Files
                           
                              
                           
                           
                           - 48.3.2.1 COPY_COLLECTION Procedure
- 48.3.2.2 COPY_DATA Procedure
- 48.3.2.3 COPY_DATA Procedure for Avro or Parquet Files
- 48.3.2.4 COPY_OBJECT Procedure
- 48.3.2.5 CREATE_EXTERNAL_PART_TABLE Procedure
- 48.3.2.6 CREATE_EXTERNAL_TABLE Procedure
- 48.3.2.7 CREATE_EXTERNAL_TABLE Procedure for Apache Iceberg
- 48.3.2.8 CREATE_EXTERNAL_TABLE Procedure for Avro or Parquet Files
- 48.3.2.9 CREATE_HYBRID_PART_TABLE Procedure
- 48.3.2.10 DELETE_ALL_OPERATIONS Procedure
- 48.3.2.11 DELETE_FILE Procedure
- 48.3.2.12 DELETE_OBJECT Procedure
- 48.3.2.13 DELETE_OPERATION Procedure
- 48.3.2.14 EXPORT_DATA Procedure
- 48.3.2.15 GET_OBJECT Procedure and Function
- 48.3.2.16 LIST_FILES Function
- 48.3.2.17 LIST_OBJECTS Function
- 48.3.2.18 MOVE_OBJECT Procedure
- 48.3.2.19 PUT_OBJECT Procedure
- 48.3.2.20 SYNC_EXTERNAL_PART_TABLE Procedure
- 48.3.2.21 VALIDATE_EXTERNAL_PART_TABLE Procedure
- 48.3.2.22 VALIDATE_EXTERNAL_TABLE Procedure
- 48.3.2.23 VALIDATE_HYBRID_PART_TABLE Procedure
 
- 48.3.3 DBMS_CLOUD for Bulk File Management
- 
                           
                           
                              
                              48.3.4
                                  DBMS_CLOUD REST APIs
                           
                              
                           
                           
                           - 48.3.4.1 DBMS_CLOUD REST API Overview
- 48.3.4.2 DBMS_CLOUD REST API Constants
- 48.3.4.3 DBMS_CLOUD REST API Results Cache
- 48.3.4.4 GET_RESPONSE_HEADERS Function
- 48.3.4.5 GET_RESPONSE_RAW Function
- 48.3.4.6 GET_RESPONSE_STATUS_CODE Function
- 48.3.4.7 GET_RESPONSE_TEXT Function
- 48.3.4.8 GET_API_RESULT_CACHE_SIZE Function
- 48.3.4.9 SEND_REQUEST Function and Procedure
- 48.3.4.10 SET_API_RESULT_CACHE_SIZE Procedure
- 48.3.4.11 DBMS_CLOUD REST API Examples
 
 
- 
                     
                     
                        
                        48.4
                            DBMS_CLOUD  URI Formats
                     
                        
                     
                     
                     - 48.4.1 Oracle Cloud Infrastructure Object Storage Native URI Format
- 48.4.2 Oracle Cloud Infrastructure Object Storage Swift URI Format
- 48.4.3 Oracle Cloud Infrastructure Object Storage URI Format Using Pre-Authenticated Request URL
- 48.4.4 URI Format Using Public URL
- 48.4.5 Oracle Cloud Infrastructure Object Storage Classic URI Format
- 48.4.6 Amazon S3 URI Format
- 48.4.7 Amazon S3 Compatible URI Format
- 48.4.8 GitHub Raw URL Format
- 48.4.9 Additional Customer-Managed URI Formats
 
- 48.5 DBMS_CLOUD Package Format Options
- 48.6 DBMS_CLOUD Package Format Options for EXPORT_DATA
- 
                     
                     
                        
                        48.7
                            DBMS_CLOUD Avro and Parquet Support
                     
                        
                     
                     
                     - 48.7.1 DBMS_CLOUD Package Format Options for Avro or Parquet
- 48.7.2 DBMS_CLOUD Package Avro to Oracle Data Type Mapping
- 48.7.3 DBMS_CLOUD Package ORC to Oracle Data Type Mapping
- 48.7.4 DBMS_CLOUD Package Parquet to Oracle Data Type Mapping
- 48.7.5 DBMS_CLOUD Package Oracle Data Type to Parquet Mapping
- 48.7.6 DBMS_CLOUD Package Avro and Parquet Complex Types
- 48.7.7 DBMS_CLOUD Package Avro and Parquet to Oracle Column Name Mapping
 
- 48.8 DBMS_CLOUD Exceptions
 
- 49 DBMS_CLOUD_AI
- 50 DBMS_CLOUD_NOTIFICATION
- 51 DBMS_CLOUD_PIPELINE
- 
               
               
                  
                  52
                      DBMS_CLOUD_REPO
               
                  
               
               
               - 52.1 DBMS_CLOUD_REPO Overview
- 52.2 DBMS_CLOUD_REPO Data Structures
- 52.3 DBMS_CLOUD_REPO Subprogram Groups
- 
                     
                     
                        
                        52.4
                            Summary of DBMS_CLOUD_REPO
                        Subprograms
                     
                        
                     
                     
                     - 52.4.1 CREATE_BRANCH Procedure
- 52.4.2 CREATE_REPOSITORY Procedure
- 52.4.3 DELETE_BRANCH Procedure
- 52.4.4 DELETE_FILE Procedure
- 52.4.5 DELETE_REPOSITORY Procedure
- 52.4.6 EXPORT_OBJECT Procedure
- 52.4.7 EXPORT_SCHEMA Procedure
- 52.4.8 GET_FILE Procedure and Function
- 52.4.9 INIT_AWS_REPO Function
- 52.4.10 INIT_AZURE_REPO Function
- 52.4.11 INIT_GITHUB_REPO Function
- 52.4.12 INIT_REPO Function
- 52.4.13 INSTALL_FILE Procedure
- 52.4.14 INSTALL_SQL Procedure
- 52.4.15 LIST_BRANCHES Function
- 52.4.16 LIST_COMMITS Function
- 52.4.17 LIST_FILES Function
- 52.4.18 LIST_REPOSITORIES Function
- 52.4.19 MERGE_BRANCH Procedure
- 52.4.20 PUT_FILE Procedure
- 52.4.21 UPDATE_REPOSITORY Procedure
 
 
- 53 DBMS_COMPARISON
- 54 DBMS_COMPRESSION
- 55 DBMS_CONNECTION_POOL
- 
               
               
                  
                  56
                       DBMS_CQ_NOTIFICATION
               
                  
               
               
               - 56.1 DBMS_CQ_NOTIFICATION Overview
- 56.2 DBMS_CQ_NOTIFICATION Security Model
- 56.3 DBMS_CQ_NOTIFICATION Constants
- 56.4 DBMS_CQ_NOTIFICATION Operational Notes
- 56.5 DBMS_CQ_NOTIFICATION Examples
- 
                     
                     
                        
                        56.6
                            DBMS_CQ_NOTIFICATION Data Structures
                     
                        
                     
                     
                     - 56.6.1 CQ_NOTIFICATION$_DESCRIPTOR Object Type
- 56.6.2 CQ_NOTIFICATION$_QUERY Object Type
- 56.6.3 CQ_NOTIFICATION$_QUERY_ARRAY Object (Array) Type
- 56.6.4 CQ_NOTIFICATION$_TABLE Object Type
- 56.6.5 CQ_NOTIFICATION$_TABLE_ARRAY Object (Array) Type
- 56.6.6 CQ_NOTIFICATION$_ROW Object Type
- 56.6.7 CQ_NOTIFICATION$_ROW_ARRAY Object (Array) Type
- 56.6.8 CQ_NOTIFICATION$_REG_INFO Object Type
 
- 56.7 Summary of DBMS_CQ_NOTIFICATION Subprograms
 
- 57 DBMS_CREDENTIAL
- 
               
               
                  
                  58
                       DBMS_CRYPTO
               
                  
               
               
               - 58.1 DBMS_CRYPTO Overview
- 58.2 DBMS_CRYPTO Security Model
- 58.3 DBMS_CRYPTO Constants
- 58.4 DBMS_CRYPTO Datatypes
- 58.5 DBMS_CRYPTO Algorithms
- 58.6 DBMS_CRYPTO Restrictions
- 58.7 DBMS_CRYPTO Exceptions
- 58.8 DBMS_CRYPTO Operational Notes
- 58.9 DBMS_CRYPTO Examples
- 
                     
                     
                        
                        58.10
                            Summary of DBMS_CRYPTO Subprograms
                     
                        
                     
                     
                     - 58.10.1 DECRYPT Functions
- 58.10.2 DECRYPT Procedures
- 58.10.3 ECDHDERIVE_SHAREDSECRET Function
- 58.10.4 ECDH_GENKEYPAIR Function
- 58.10.5 ENCRYPT Functions
- 58.10.6 ENCRYPT Procedures
- 58.10.7 HASH Function
- 58.10.8 HASH_LEN Function
- 58.10.9 MAC Function
- 58.10.10 KMACXOF Function
- 58.10.11 PKDECRYPT Function
- 58.10.12 PKENCRYPT Function
- 58.10.13 RANDOMBYTES Function
- 58.10.14 RANDOMINTEGER Function
- 58.10.15 RANDOMNUMBER Function
- 58.10.16 SIGN Function
- 58.10.17 VERIFY Function
 
 
- 59 DBMS_CSX_ADMIN
- 
               
               
                  
                  60
                       DBMS_CUBE
               
                  
               
               
               - 60.1 Using DBMS_CUBE
- 60.2 Using SQL Aggregation Management
- 60.3 Upgrading 10g Analytic Workspaces
- 
                     
                     
                        
                        60.4
                            Summary of DBMS_CUBE Subprograms
                     
                        
                     
                     
                     - 60.4.1 BUILD Procedure
- 60.4.2 CREATE_EXPORT_OPTIONS Procedure
- 60.4.3 CREATE_IMPORT_OPTIONS Procedure
- 60.4.4 CREATE_MVIEW Function
- 60.4.5 DERIVE_FROM_MVIEW Function
- 60.4.6 DROP_MVIEW Procedure
- 60.4.7 EXPORT_XML Procedure
- 60.4.8 EXPORT_XML_TO_FILE Procedure
- 60.4.9 IMPORT_XML Procedure
- 60.4.10 INITIALIZE_CUBE_UPGRADE Procedure
- 60.4.11 REFRESH_MVIEW Procedure
- 60.4.12 UPGRADE_AW Procedure
- 60.4.13 VALIDATE_XML Procedure
 
 
- 61 DBMS_CUBE_ADVISE
- 
               
               
                  
                  62
                      DBMS_CUBE_LOG 
               
                  
               
               
               - 
                     
                     
                        
                        62.1
                            Using DBMS_CUBE_LOG
                     
                        
                     
                     
                     - 62.1.1 DBMS_CUBE_LOG — Logging Types
- 62.1.2 DBMS_CUBE_LOG — Logging Targets
- 62.1.3 DBMS_CUBE_LOG — Verbosity Levels
- 62.1.4 DBMS_CUBE_LOG Security Model
- 62.1.5 DBMS_CUBE_LOG — Creating Cube Logs
- 62.1.6 DBMS_CUBE_LOG — Cube Build Log
- 62.1.7 DBMS_CUBE_LOG — Cube Dimension Compile Log
- 62.1.8 DBMS_CUBE_LOG — Cube Operations Log
- 62.1.9 DBMS_CUBE_LOG — Cube Rejected Records Log
 
- 
                     
                     
                        
                        62.2
                            Summary of DBMS_CUBE_LOG Subprograms
                     
                        
                     
                     
                     - 62.2.1 DEFAULT_NAME Function
- 62.2.2 DISABLE Procedure
- 62.2.3 ENABLE Procedure
- 62.2.4 FLUSH Procedure
- 62.2.5 GET_LOG Procedure
- 62.2.6 GET_LOG_SPEC Function
- 62.2.7 GET_PARAMETER Function
- 62.2.8 LEVEL_HIGH Function
- 62.2.9 LEVEL_HIGHEST Function
- 62.2.10 LEVEL_LOW Function
- 62.2.11 LEVEL_LOWEST Function
- 62.2.12 LEVEL_MEDIUM Function
- 62.2.13 SET_LOG_SPEC Procedure
- 62.2.14 SET_PARAMETER Procedure
- 62.2.15 TABLE_CREATE Procedure
- 62.2.16 TARGET_FILE Function
- 62.2.17 TARGET_LOB Function
- 62.2.18 TARGET_TABLE Function
- 62.2.19 TARGET_TRACE Function
- 62.2.20 TYPE_BUILD Function
- 62.2.21 TYPE_DIMENSION_COMPILE Function
- 62.2.22 TYPE_OPERATIONS Function
- 62.2.23 TYPE_REJECTED_RECORDS Function
- 62.2.24 VERSION Function
 
 
- 
                     
                     
                        
                        62.1
                            Using DBMS_CUBE_LOG
                     
                        
                     
                     
                     
- 
               
               
                  
                  63
                        DBMS_DATA_MINING
               
                  
               
               
               - 63.1 DBMS_DATA_MINING Overview
- 63.2 DBMS_DATA_MINING Security Model
- 63.3 DBMS_DATA_MINING — Machine Learning Functions
- 63.4 DBMS_DATA_MINING — Model Settings
- 
                     
                     
                        
                        63.5
                            DBMS_DATA_MINING — Algorithm Specific Model Settings
                     
                        
                     
                     
                     - 63.5.1 DBMS_DATA_MINING — Algorithm Settings: ALGO_EXTENSIBLE_LANG
- 63.5.2 DBMS_DATA_MINING — Algorithm Settings: CUR Matrix Decomposition
- 63.5.3 DBMS_DATA_MINING — Algorithm Settings: Decision Tree
- 63.5.4 DBMS_DATA_MINING — Algorithm Settings: Expectation Maximization
- 63.5.5 DBMS_DATA_MINING — Algorithm Settings: Explicit Semantic Analysis
- 63.5.6 DBMS_DATA_MINING — Algorithm Settings: Exponential Smoothing
- 63.5.7 DBMS_DATA_MINING — Algorithm Settings: Generalized Linear Model
- 63.5.8 DBMS_DATA_MINING — Algorithm Settings: k-Means
- 63.5.9 DBMS_DATA_MINING - Algorithm Settings: Multivariate State Estimation Technique - Sequential Probability Ratio Test
- 63.5.10 DBMS_DATA_MINING — Algorithm Settings: Naive Bayes
- 63.5.11 DBMS_DATA_MINING — Algorithm Settings: Neural Network
- 63.5.12 DBMS_DATA_MINING — Algorithm Settings: Non-Negative Matrix Factorization
- 63.5.13 DBMS_DATA_MINING — Algorithm Settings: O-Cluster
- 63.5.14 DBMS_DATA_MINING — Algorithm Settings: Random Forest
- 63.5.15 DBMS_DATA_MINING — Algorithm Constants and Settings: Singular Value Decomposition
- 63.5.16 DBMS_DATA_MINING — Algorithm Settings: Support Vector Machine
- 63.5.17 DBMS_DATA_MINING — Algorithm Settings: XGBoost
 
- 63.6 DBMS_DATA_MINING — Solver Settings
- 63.7 DBMS_DATA_MINING Datatypes
- 
                     
                     
                        
                        63.8
                            Summary of DBMS_DATA_MINING
                        Subprograms
                     
                        
                     
                     
                     - 63.8.1 ADD_COST_MATRIX Procedure
- 63.8.2 ADD_PARTITION Procedure
- 63.8.3 ALTER_REVERSE_EXPRESSION Procedure
- 63.8.4 APPLY Procedure
- 63.8.5 COMPUTE_CONFUSION_MATRIX Procedure
- 63.8.6 COMPUTE_CONFUSION_MATRIX_PART Procedure
- 63.8.7 COMPUTE_LIFT Procedure
- 63.8.8 COMPUTE_LIFT_PART Procedure
- 63.8.9 COMPUTE_ROC Procedure
- 63.8.10 COMPUTE_ROC_PART Procedure
- 63.8.11 CREATE_MODEL Procedure
- 63.8.12 CREATE_MODEL2 Procedure
- 63.8.13 Create Model Using Registration Information
- 63.8.14 DROP_ALGORITHM Procedure
- 63.8.15 DROP_PARTITION Procedure
- 63.8.16 DROP_MODEL Procedure
- 63.8.17 EXPORT_MODEL Procedure
- 63.8.18 EXPORT_SERMODEL Procedure
- 63.8.19 FETCH_JSON_SCHEMA Procedure
- 63.8.20 GET_ASSOCIATION_RULES Function
- 63.8.21 GET_FREQUENT_ITEMSETS Function
- 63.8.22 GET_MODEL_COST_MATRIX Function
- 63.8.23 GET_MODEL_DETAILS_AI Function
- 63.8.24 GET_MODEL_DETAILS_EM Function
- 63.8.25 GET_MODEL_DETAILS_EM_COMP Function
- 63.8.26 GET_MODEL_DETAILS_EM_PROJ Function
- 63.8.27 GET_MODEL_DETAILS_GLM Function
- 63.8.28 GET_MODEL_DETAILS_GLOBAL Function
- 63.8.29 GET_MODEL_DETAILS_KM Function
- 63.8.30 GET_MODEL_DETAILS_NB Function
- 63.8.31 GET_MODEL_DETAILS_NMF Function
- 63.8.32 GET_MODEL_DETAILS_OC Function
- 63.8.33 GET_MODEL_SETTINGS Function
- 63.8.34 GET_MODEL_SIGNATURE Function
- 63.8.35 GET_MODEL_DETAILS_SVD Function
- 63.8.36 GET_MODEL_DETAILS_SVM Function
- 63.8.37 GET_MODEL_DETAILS_XML Function
- 63.8.38 GET_MODEL_TRANSFORMATIONS Function
- 63.8.39 GET_TRANSFORM_LIST Procedure
- 63.8.40 IMPORT_MODEL Procedure
- 63.8.41 IMPORT_ONNX_MODEL Procedure
- 63.8.42 IMPORT_SERMODEL Procedure
- 63.8.43 JSON Schema for R Extensible Algorithm
- 63.8.44 REGISTER_ALGORITHM Procedure
- 63.8.45 RANK_APPLY Procedure
- 63.8.46 REMOVE_COST_MATRIX Procedure
- 63.8.47 RENAME_MODEL Procedure
 
 
- 
               
               
                  
                  64
                      DBMS_DATA_MINING_TRANSFORM
               
                  
               
               
               - 64.1 DBMS_DATA_MINING_TRANSFORM Overview
- 64.2 DBMS_DATA_MINING_TRANSFORM Operational Notes
- 64.3 DBMS_DATA_MINING_TRANSFORM Security Model
- 64.4 DBMS_DATA_MINING_TRANSFORM Datatypes
- 64.5 DBMS_DATA_MINING_TRANSFORM Constants
- 
                     
                     
                        
                        64.6
                            Summary of DBMS_DATA_MINING_TRANSFORM Subprograms
                     
                        
                     
                     
                     - 64.6.1 CREATE_BIN_CAT Procedure
- 64.6.2 CREATE_BIN_NUM Procedure
- 64.6.3 CREATE_CLIP Procedure
- 64.6.4 CREATE_COL_REM Procedure
- 64.6.5 CREATE_MISS_CAT Procedure
- 64.6.6 CREATE_MISS_NUM Procedure
- 64.6.7 CREATE_NORM_LIN Procedure
- 64.6.8 DESCRIBE_STACK Procedure
- 64.6.9 GET_EXPRESSION Function
- 64.6.10 INSERT_AUTOBIN_NUM_EQWIDTH Procedure
- 64.6.11 INSERT_BIN_CAT_FREQ Procedure
- 64.6.12 INSERT_BIN_NUM_EQWIDTH Procedure
- 64.6.13 INSERT_BIN_NUM_QTILE Procedure
- 64.6.14 INSERT_BIN_SUPER Procedure
- 64.6.15 INSERT_CLIP_TRIM_TAIL Procedure
- 64.6.16 INSERT_CLIP_WINSOR_TAIL Procedure
- 64.6.17 INSERT_MISS_CAT_MODE Procedure
- 64.6.18 INSERT_MISS_NUM_MEAN Procedure
- 64.6.19 INSERT_NORM_LIN_MINMAX Procedure
- 64.6.20 INSERT_NORM_LIN_SCALE Procedure
- 64.6.21 INSERT_NORM_LIN_ZSCORE Procedure
- 64.6.22 SET_EXPRESSION Procedure
- 64.6.23 SET_TRANSFORM Procedure
- 64.6.24 STACK_BIN_CAT Procedure
- 64.6.25 STACK_BIN_NUM Procedure
- 64.6.26 STACK_CLIP Procedure
- 64.6.27 STACK_COL_REM Procedure
- 64.6.28 STACK_MISS_CAT Procedure
- 64.6.29 STACK_MISS_NUM Procedure
- 64.6.30 STACK_NORM_LIN Procedure
- 64.6.31 XFORM_BIN_CAT Procedure
- 64.6.32 XFORM_BIN_NUM Procedure
- 64.6.33 XFORM_CLIP Procedure
- 64.6.34 XFORM_COL_REM Procedure
- 64.6.35 XFORM_EXPR_NUM Procedure
- 64.6.36 XFORM_EXPR_STR Procedure
- 64.6.37 XFORM_MISS_CAT Procedure
- 64.6.38 XFORM_MISS_NUM Procedure
- 64.6.39 XFORM_NORM_LIN Procedure
- 64.6.40 XFORM_STACK Procedure
 
 
- 
               
               
                  
                  65
                       DBMS_DATAPUMP
               
                  
               
               
               - 65.1 DBMS_DATAPUMP Overview
- 65.2 DBMS_DATAPUMP Security Model
- 65.3 DBMS_DATAPUMP Constants
- 65.4 DBMS_DATAPUMP Data Structures
- 
                     
                     
                        
                        65.5
                            Summary of DBMS_DATAPUMP Subprograms
                     
                        
                     
                     
                     - 65.5.1 ADD_FILE Procedure
- 65.5.2 ATTACH Function
- 65.5.3 DATA_FILTER Procedures
- 65.5.4 DATA_REMAP Procedure
- 65.5.5 DETACH Procedure
- 65.5.6 GET_DUMPFILE_INFO Procedure
- 65.5.7 GET_STATUS Procedure
- 65.5.8 LOG_ENTRY Procedure
- 65.5.9 METADATA_FILTER Procedure
- 65.5.10 METADATA_REMAP Procedure
- 65.5.11 METADATA_TRANSFORM Procedure
- 65.5.12 OPEN Function
- 65.5.13 SET_PARALLEL Procedure
- 65.5.14 SET_PARAMETER Procedures
- 65.5.15 START_JOB Procedure
- 65.5.16 STOP_JOB Procedure
- 65.5.17 WAIT_FOR_JOB Procedure
 
 
- 66 DBMS_DB_VERSION
- 67 DBMS_DBCOMP
- 
               
               
                  
                  68
                       DBMS_DBFS_CONTENT 
               
                  
               
               
               - 68.1 DBMS_DBFS_CONTENT Overview
- 68.2 DBMS_DBFS_CONTENT Security Model
- 68.3 DBMS_DBFS_CONTENT Constants
- 68.4 Exceptions
- 68.5 DBMS_DBFS_CONTENT Operational Notes
- 
                     
                     
                        
                        68.6
                            DBMS_DBFS_CONTENT Data Structures
                     
                        
                     
                     
                     - 68.6.1 DBMS_DBFS_CONTENT FEATURE_T Record Type
- 68.6.2 DBMS_DBFS_CONTENT MOUNT_T Record Type
- 68.6.3 DBMS_DBFS_CONTENT PATH_ITEM_T Record Type
- 68.6.4 DBMS_DBFS_CONTENT PROP_ITEM_T Record Type
- 68.6.5 PROPERTY_T Record Type
- 68.6.6 DBMS_DBFS_CONTENT STORE_T Record Type
- 68.6.7 DBMS_DBFS_CONTENT FEATURES_T Table Type
- 68.6.8 MOUNTS_T Table Type
- 68.6.9 DBMS_DBFS_CONTENT PATH_ITEMS_T Table Type
- 68.6.10 DBMS_DBFS_CONTENT PROP_ITEMS_T Table Type
- 68.6.11 DBMS_DBFS_CONTENT PROPERTIES_T Table Type
- 68.6.12 STORES_T Table Type
 
- 
                     
                     
                        
                        68.7
                            Summary of DBMS_DBFS_CONTENT Subprograms
                     
                        
                     
                     
                     - 68.7.1 CHECKACCESS Function
- 68.7.2 CHECKSPI Functions and Procedures
- 68.7.3 CREATEDIRECTORY Procedures
- 68.7.4 CREATEFILE Procedures
- 68.7.5 CREATELINK Procedures
- 68.7.6 CREATEREFERENCE Procedures
- 68.7.7 DECODEFEATURES Function
- 68.7.8 DELETECONTENT Procedure
- 68.7.9 DELETEDIRECTORY Procedure
- 68.7.10 DELETEFILE Procedure
- 68.7.11 FEATURENAME Function
- 68.7.12 FLUSHSTATS Function
- 68.7.13 GETDEFAULTACL Procedure
- 68.7.14 GETDEFAULTASOF Procedure
- 68.7.15 GETDEFAULTCONTEXT Procedure
- 68.7.16 GETDEFAULTOWNER Procedure
- 68.7.17 GETDEFAULTPRINCIPAL Procedure
- 68.7.18 GETFEATURESBYMOUNT Function
- 68.7.19 GETFEATURESBYNAME Function
- 68.7.20 GETFEATURESBYPATH Function
- 68.7.21 GETPATH Procedures
- 68.7.22 GETPATHBYMOUNTID Function
- 68.7.23 GETPATHBYSTOREID Function
- 68.7.24 GETPATHNOWAIT Procedures
- 68.7.25 GETSTOREBYMOUNT Function
- 68.7.26 GETSTOREBYNAME Function
- 68.7.27 GETSTOREBYPATH Function
- 68.7.28 GETSTATS Procedure
- 68.7.29 GETTRACE Function
- 68.7.30 GETVERSION Function
- 68.7.31 ISPATHLOCKED Procedure
- 68.7.32 LIST Function
- 68.7.33 LISTALLPROPERTIES Function
- 68.7.34 LISTALLCONTENT Function
- 68.7.35 LISTMOUNTS Function
- 68.7.36 LISTSTORES Function
- 68.7.37 LOCKPATH Procedure
- 68.7.38 MOUNTSTORE Procedure
- 68.7.39 NORMALIZEPATH Functions
- 68.7.40 PROPANY Functions
- 68.7.41 PROPERTIESH2T Function
- 68.7.42 PROPERTIEST2H Function
- 68.7.43 PROPNUMBER Function
- 68.7.44 PROPRAW Function
- 68.7.45 PROPTIMESTAMP Function
- 68.7.46 PROPVARCHAR2 Function
- 68.7.47 PURGEALL Procedure
- 68.7.48 PURGEPATH Procedure
- 68.7.49 PUTPATH Procedures
- 68.7.50 REGISTERSTORE Procedure
- 68.7.51 RENAMEPATH Procedures
- 68.7.52 RESTOREALL Procedure
- 68.7.53 RESTOREPATH Procedure
- 68.7.54 SETDEFAULTACL Procedure
- 68.7.55 SETDEFAULTASOF Procedure
- 68.7.56 SETDEFAULTCONTEXT Procedure
- 68.7.57 SETDEFAULTOWNER Procedure
- 68.7.58 SETDEFAULTPRINCIPAL Procedure
- 68.7.59 SETPATH Procedures
- 68.7.60 SETSTATS Procedure
- 68.7.61 SETTRACE Procedure
- 68.7.62 SPACEUSAGE Procedure
- 68.7.63 TRACE Procedure
- 68.7.64 TRACEENABLED Function
- 68.7.65 UNLOCKPATH Procedure
- 68.7.66 UNMOUNTSTORE Procedure
- 68.7.67 UNREGISTERSTORE Procedure
 
 
- 
               
               
                  
                  69
                       DBMS_DBFS_CONTENT_SPI 
               
                  
               
               
               - 69.1 ODBMS_DBFS_CONTENT_SPI Overview
- 69.2 DBMS_DBFS_CONTENT_SPI Security Model
- 69.3 DBMS_DBFS_CONTENT_SPI Operational Notes
- 
                     
                     
                        
                        69.4
                            Summary of DBMS_DBFS_CONTENT_SPI Subprograms
                     
                        
                     
                     
                     - 69.4.1 CHECKACCESS Function
- 69.4.2 CREATEDIRECTORY Procedure
- 69.4.3 CREATEFILE Procedure
- 69.4.4 CREATELINK Procedure
- 69.4.5 CREATEREFERENCE Procedure
- 69.4.6 DELETECONTENT Procedure
- 69.4.7 DELETEDIRECTORY Procedure
- 69.4.8 DELETEFILE Procedure
- 69.4.9 GETFEATURES Function
- 69.4.10 GETPATH Procedures
- 69.4.11 GETPATHBYSTOREID Function
- 69.4.12 GETPATHNOWAIT Procedure
- 69.4.13 GETSTOREID Function
- 69.4.14 GETVERSION Function
- 69.4.15 ISPATHLOCKED Procedure
- 69.4.16 LIST Function
- 69.4.17 LOCKPATH Procedure
- 69.4.18 PURGEALL Procedure
- 69.4.19 PURGEPATH Procedure
- 69.4.20 PUTPATH Procedures
- 69.4.21 RENAMEPATH Procedure
- 69.4.22 RESTOREALL Procedure
- 69.4.23 RESTOREPATH Procedure
- 69.4.24 SEARCH Function
- 69.4.25 SETPATH Procedure
- 69.4.26 SPACEUSAGE Procedure
- 69.4.27 UNLOCKPATH Procedure
 
 
- 
               
               
                  
                  70
                       DBMS_DBFS_HS
               
                  
               
               
               - 70.1 DBMS_DBFS_HS Overview
- 70.2 DBMS_DBFS_HS Security Model
- 70.3 DBMS_DBFS_HS Constants
- 70.4 DBMS_DBFS_HS Operational Notes
- 
                     
                     
                        
                        70.5
                            Summary of DBMS_DBFS_HS Subprograms
                     
                        
                     
                     
                     - 70.5.1 CLEANUPUNUSEDBACKUPFILES Procedure
- 70.5.2 CREATEBUCKET Procedure
- 70.5.3 CREATESTORE Procedure
- 70.5.4 DEREGSTORECOMMAND Function
- 70.5.5 DROPSTORE Procedure
- 70.5.6 FLUSHCACHE Procedure
- 70.5.7 GETSTOREPROPERTY Function
- 70.5.8 RECONFIGCACHE Procedure
- 70.5.9 REGISTERSTORECOMMAND Procedure
- 70.5.10 SENDCOMMAND Procedure
- 70.5.11 SETSTOREPROPERTY Procedure
- 70.5.12 STOREPUSH Procedure
 
 
- 71 DBMS_DBFS_SFS
- 72 DBMS_DDL
- 
               
               
                  
                  73
                       DBMS_DEBUG
               
                  
               
               
               - 73.1 DBMS_DEBUG Overview
- 73.2 DBMS_DEBUG Constants
- 73.3 DBMS_DEBUG Variables
- 73.4 DBMS_DEBUG Exceptions
- 73.5 DBMS_DEBUG Operational Notes
- 73.6 DBMS_DEBUG Data Structures
- 
                     
                     
                        
                        73.7
                            Summary of DBMS_DEBUG Subprograms
                     
                        
                     
                     
                     - 73.7.1 ATTACH_SESSION Procedure
- 73.7.2 CONTINUE Function
- 73.7.3 DEBUG_OFF Procedure
- 73.7.4 DEBUG_ON Procedure
- 73.7.5 DELETE_BREAKPOINT Function
- 73.7.6 DELETE_OER_BREAKPOINT Function
- 73.7.7 DETACH_SESSION Procedure
- 73.7.8 DISABLE_BREAKPOINT Function
- 73.7.9 ENABLE_BREAKPOINT Function
- 73.7.10 EXECUTE Procedure
- 73.7.11 GET_INDEXES Function
- 73.7.12 GET_MORE_SOURCE Procedure
- 73.7.13 GET_LINE_MAP Function
- 73.7.14 GET_RUNTIME_INFO Function
- 73.7.15 GET_TIMEOUT_BEHAVIOUR Function
- 73.7.16 GET_VALUE Function
- 73.7.17 INITIALIZE Function
- 73.7.18 PING Procedure
- 73.7.19 PRINT_BACKTRACE Procedure
- 73.7.20 PRINT_INSTANTIATIONS Procedure
- 73.7.21 PROBE_VERSION Procedure
- 73.7.22 SELF_CHECK Procedure
- 73.7.23 SET_BREAKPOINT Function
- 73.7.24 SET_OER_BREAKPOINT Function
- 73.7.25 SET_TIMEOUT Function
- 73.7.26 SET_TIMEOUT_BEHAVIOUR Procedure
- 73.7.27 SET_VALUE Function
- 73.7.28 SHOW_BREAKPOINTS Procedures
- 73.7.29 SHOW_FRAME_SOURCE Procedure
- 73.7.30 SHOW_SOURCE Procedures
- 73.7.31 SYNCHRONIZE Function
- 73.7.32 TARGET_PROGRAM_RUNNING Procedure
 
 
- 74 DBMS_DEBUG_JDWP
- 75 DBMS_DEBUG_JDWP_CUSTOM
- 76 DBMS_DESCRIBE
- 77 DBMS_DEVELOPER
- 78 DBMS_DG
- 79 DBMS_DICTIONARY_CHECK
- 80 DBMS_DIMENSION
- 81 DBMS_DISTRIBUTED_TRUST_ADMIN
- 82 DBMS_DNFS
- 
               
               
                  
                  83
                       DBMS_DST
               
                  
               
               
               - 83.1 DBMS_DST Overview
- 83.2 DBMS_DST Security Model
- 83.3 DBMS_DST Views
- 
                     
                     
                        
                        83.4
                            Summary of DBMS_DST Subprograms
                     
                        
                     
                     
                     - 83.4.1 BEGIN_PREPARE Procedure
- 83.4.2 BEGIN_UPGRADE Procedure
- 83.4.3 CREATE_AFFECTED_TABLE Procedure
- 83.4.4 CREATE_ERROR_TABLE Procedure
- 83.4.5 CREATE_TRIGGER_TABLE Procedure
- 83.4.6 END_PREPARE Procedure
- 83.4.7 END_UPGRADE Procedure
- 83.4.8 FIND_AFFECTED_TABLES Procedure
- 83.4.9 UPGRADE_DATABASE Procedure
- 83.4.10 UPGRADE_SCHEMA Procedure
- 83.4.11 UPGRADE_TABLE Procedure
 
 
- 84 DBMS_EDITIONS_UTILITIES
- 
               
               
                  
                  85
                       DBMS_EPG
               
                  
               
               
               - 85.1 DBMS_EPG Overview
- 85.2 DBMS_EPG Security Model
- 85.3 DBMS_EPG Exceptions
- 85.4 DBMS_EPG Data Structures
- 85.5 DBMS_EPG Subprogram Groups
- 
                     
                     
                        
                        85.6
                            Summary of DBMS_EPG Subprograms
                     
                        
                     
                     
                     - 85.6.1 AUTHORIZE_DAD Procedure
- 85.6.2 CREATE_DAD Procedure
- 85.6.3 DEAUTHORIZE_DAD Procedure
- 85.6.4 DELETE_DAD_ATTRIBUTE Procedure
- 85.6.5 DELETE_GLOBAL_ATTRIBUTE Procedure
- 85.6.6 DROP_DAD Procedure
- 85.6.7 GET_ALL_DAD_ATTRIBUTES Procedure
- 85.6.8 GET_ALL_DAD_MAPPINGS Procedure
- 85.6.9 GET_ALL_GLOBAL_ATTRIBUTES Procedure
- 85.6.10 GET_DAD_ATTRIBUTE Function
- 85.6.11 GET_DAD_LIST Procedure
- 85.6.12 GET_GLOBAL_ATTRIBUTE Function
- 85.6.13 MAP_DAD Procedure
- 85.6.14 SET_DAD_ATTRIBUTE Procedure
- 85.6.15 SET_GLOBAL_ATTRIBUTE Procedure
- 85.6.16 UNMAP_DAD Procedure
 
 
- 86 DBMS_ERRLOG
- 87 DBMS_FGA
- 88 DBMS_FILE_TRANSFER
- 89 DBMS_FLASHBACK
- 
               
               
                  
                  90
                       DBMS_FLASHBACK_ARCHIVE
               
                  
               
               
               - 90.1 DBMS_FLASHBACK_ARCHIVE Overview
- 90.2 DBMS_FLASHBACK_ARCHIVE Security Model
- 90.3 DBMS_FLASHBACK_ARCHIVE Constants
- 
                     
                     
                        
                        90.4
                            Summary of DBMS_FLASHBACK_ARCHIVE Subprograms
                     
                        
                     
                     
                     - 90.4.1 ADD_TABLE_TO_APPLICATION Procedure
- 90.4.2 CREATE_TEMP_HISTORY_TABLE Procedure
- 90.4.3 DISABLE_APPLICATION Procedure
- 90.4.4 DISABLE_ASOF_VALID_TIME Procedure
- 90.4.5 DISASSOCIATE_FBA Procedure
- 90.4.6 DROP_APPLICATION Procedure
- 90.4.7 ENABLE_APPLICATION Procedure
- 90.4.8 ENABLE_AT_VALID_TIME Procedure
- 90.4.9 EXTEND_MAPPINGS Procedure
- 90.4.10 GET_CURRENT_LIFESPAN_DIGEST Function
- 90.4.11 GET_SYS_CONTEXT Function
- 90.4.12 IMPORT_HISTORY Procedure
- 90.4.13 LOCK_DOWN_APPLICATION Procedure
- 90.4.14 PURGE_CONTEXT Procedure
- 90.4.15 REASSOCIATE_FBA Procedure
- 90.4.16 REGISTER_APPLICATION Procedure
- 90.4.17 REMOVE_TABLE_FROM_APPLICATION Procedure
- 90.4.18 SET_CONTEXT_LEVEL Procedure
- 90.4.19 VERIFY_BLOCKCHAIN_LIFESPAN Procedure
 
 
- 91 DBMS_FLASHBACK_ARCHIVE_MIGRATE
- 92 DBMS_FREQUENT_ITEMSET
- 93 DBMS_FS
- 
               
               
                  
                  94
                       DBMS_GOLDENGATE_ADM
               
                  
               
               
               - 94.1 Using DBMS_GOLDENGATE_ADM
- 
                     
                     
                        
                        94.2
                            Summary of DBMS_GOLDENGATE_ADM Subprograms
                     
                        
                     
                     
                     - 94.2.1 ADD_AUTO_CDR Procedure
- 94.2.2 ADD_AUTO_CDR_COLUMN_GROUP Procedure
- 94.2.3 ADD_AUTO_CDR_DELTA_RES Procedure
- 94.2.4 ALTER_AUTO_CDR Procedure
- 94.2.5 ALTER_AUTO_CDR_COLUMN_GROUP Procedure
- 94.2.6 DELETE_PROCREP_EXCLUSION_OBJ Procedure
- 94.2.7 GG_PROCEDURE_REPLICATION_ON Function
- 94.2.8 INSERT_PROCREP_EXCLUSION_OBJ Procedure
- 94.2.9 PURGE_TOMBSTONES Procedure
- 94.2.10 REMOVE_AUTO_CDR Procedure
- 94.2.11 REMOVE_AUTO_CDR_COLUMN_GROUP Procedure
- 94.2.12 REMOVE_AUTO_CDR_DELTA_RES Procedure
 
 
- 95 DBMS_GOLDENGATE_AUTH
- 96 DBMS_HADOOP
- 97 DBMS_HEAT_MAP
- 98 DBMS_HEAT_MAP_ADMIN
- 
               
               
                  
                  99
                      DBMS_HIERARCHY
               
                  
               
               
               - 99.1 DBMS_HIERARCHY Overview
- 99.2 DBMS_HIERARCHY Security Model
- 
                     
                     
                        
                        99.3
                            Summary of DBMS_HIERARCHY Subprograms
                     
                        
                     
                     
                     - 99.3.1 CREATE_VALIDATE_LOG_TABLE Procedure
- 99.3.2 CREATE_VIEW_FOR_FACT_ROWS Procedure
- 99.3.3 CREATE_VIEW_FOR_STAR_ROWS Procedure
- 99.3.4 GET_MV_SQL_FOR_AV_CACHE Function
- 99.3.5 GET_MV_SQL_FOR_STAR_CACHE Function
- 99.3.6 UPGRADE_VALIDATE_LOG_TABLE Procedure
- 99.3.7 VALIDATE_ANALYTIC_VIEW Function
- 99.3.8 VALIDATE_CHECK_SUCCESS Function
- 99.3.9 VALIDATE_HIERARCHY Function
 
 
- 100 DBMS_HM
- 101 DBMS_HPROF
- 102 DBMS_HS_PARALLEL
- 
               
               
                  
                  103
                       DBMS_HS_PASSTHROUGH
               
                  
               
               
               - 103.1 DBMS_HS_PASSTHROUGH Overview
- 103.2 DBMS_HS_PASSTHROUGH Operational Notes
- 
                     
                     
                        
                        103.3
                            Summary of DBMS_HS_PASSTHROUGH Subprograms
                     
                        
                     
                     
                     - 103.3.1 BIND_INOUT_VARIABLE Procedure
- 103.3.2 BIND_INOUT_VARIABLE_RAW Procedure
- 103.3.3 BIND_OUT_VARIABLE Procedure
- 103.3.4 BIND_OUT_VARIABLE_RAW Procedure
- 103.3.5 BIND_VARIABLE Procedure
- 103.3.6 BIND_VARIABLE_RAW Procedure
- 103.3.7 CLOSE_CURSOR Procedure
- 103.3.8 EXECUTE_IMMEDIATE Procedure
- 103.3.9 EXECUTE_NON_QUERY Function
- 103.3.10 FETCH_ROW Function
- 103.3.11 GET_VALUE Procedure
- 103.3.12 GET_VALUE_RAW Procedure
- 103.3.13 OPEN_CURSOR Function
- 103.3.14 PARSE Procedure
 
 
- 104 DBMS_HYBRID_VECTOR
- 105 DBMS_ILM
- 
               
               
                  
                  106
                       DBMS_ILM_ADMIN
               
                  
               
               
               - 106.1 DBMS_ILM_ADMIN Overview
- 106.2 DBMS_ILM_ADMIN Security Model
- 106.3 DBMS_ILM_ADMIN Constants
- 
                     
                     
                        
                        106.4
                            Summary of DBMS_ILM_ADMIN Subprograms
                     
                        
                     
                     
                     - 106.4.1 CLEAR_HEAT_MAP_ALL Procedure
- 106.4.2 CLEAR_HEAT_MAP_TABLE Procedure
- 106.4.3 CUSTOMIZE_ILM Procedure
- 106.4.4 DISABLE_AUTO_OPTIMIZE Procedure
- 106.4.5 DISABLE_ILM Procedure
- 106.4.6 ENABLE_AUTO_OPTIMIZE Procedure
- 106.4.7 ENABLE_ILM Procedure
- 106.4.8 IGNORE_AUTO_OPTIMIZE_CRITERIA Procedure
- 106.4.9 SET_HEAT_MAP_ALL Procedure
- 106.4.10 SET_HEAT_MAP_START Procedure
- 106.4.11 SET_HEAT_MAP_TABLE Procedure
 
 
- 107 DBMS_IMMUTABLE_TABLE
- 108 DBMS_INMEMORY
- 
               
               
                  
                  109
                      DBMS_INMEMORY_ADMIN
               
                  
               
               
               - 109.1 DBMS_INMEMORY_ADMIN Overview
- 109.2 DBMS_INMEMORY_ADMIN Security Model
- 109.3 DBMS_INMEMORY_ADMIN Operational Notes
- 
                     
                     
                        
                        109.4
                            Summary of DBMS_INMEMORY_ADMIN Subprograms
                     
                        
                     
                     
                     - 109.4.1 AIM_GET_PARAMETER Procedure
- 109.4.2 AIM_SET_PARAMETER Procedure
- 109.4.3 FASTSTART_DISABLE Procedure
- 109.4.4 FASTSTART_ENABLE Procedure
- 109.4.5 FASTSTART_MIGRATE_STORAGE Procedure
- 109.4.6 GET_FASTSTART_TABLESPACE Function
- 109.4.7 IME_CAPTURE_EXPRESSIONS Procedure
- 109.4.8 IME_CLOSE_CAPTURE_WINDOW Procedure
- 109.4.9 IME_DROP_ALL_EXPRESSIONS Procedure
- 109.4.10 IME_GET_CAPTURE_STATE Procedure
- 109.4.11 IME_OPEN_CAPTURE_WINDOW Procedure
- 109.4.12 IME_POPULATE_EXPRESSIONS Procedure
- 109.4.13 POPULATE_WAIT Function
 
 
- 110 DBMS_INMEMORY_ADVISE
- 111 DBMS_IOT
- 112 DBMS_JAVA
- 113 DBMS_JOB
- 
               
               
                  
                  114
                      DBMS_JSON_DUALITY
               
                  
               
               
               - 114.1 DBMS_JSON_DUALITY Overview
- 114.2 DBMS_JSON_DUALITY Security
- 
                     
                     
                        
                        114.3
                            Summary of DBMS_JSON_Duality
                        Subprograms
                     
                        
                     
                     
                     - 114.3.1 INFER_SCHEMA Function
- 114.3.2 GENERATE_SCHEMA Function
- 114.3.3 INFER_AND_GENERATE_SCHEMA Function
- 114.3.4 VALIDATE_SCHEMA_REPORT Function
- 114.3.5 IMPORT Procedure
- 114.3.6 IMPORT_ALL Procedure
- 114.3.7 VALIDATE_IMPORT_REPORT Function
- 114.3.8 BEGIN_TRANSACTION Procedure
- 114.3.9 COMMIT_TRANSACTION Procedure
- 114.3.10 REGISTER Procedure
- 114.3.11 GET_GRAPHQL_SCHEMA FUNCTION
 
 
- 115 DBMS_JSON
- 116 DBMS_JSON_SCHEMA
- 117 DBMS_KAFKA
- 118 DBMS_KAFKA_ADM
- 119 DBMS_LDAP
- 120 DBMS_LDAP_UTL
- 121 DBMS_LIBCACHE
- 
               
               
                  
                  122
                       DBMS_LOB
               
                  
               
               
               - 122.1 DBMS_LOB Overview
- 122.2 DBMS_LOB Security Model
- 122.3 DBMS_LOB Constants
- 122.4 DBMS_LOB Datatypes
- 122.5 DBMS_LOB Operational Notes
- 122.6 DBMS_LOB Rules and Limits
- 122.7 DBMS_LOB Exceptions
- 
                     
                     
                        
                        122.8
                            Summary of DBMS_LOB Subprograms
                     
                        
                     
                     
                     - 122.8.1 APPEND Procedures
- 122.8.2 CLOB2FILE Procedure
- 122.8.3 CLOSE Procedure
- 122.8.4 COMPARE Functions
- 122.8.5 CONVERTTOBLOB Procedure
- 122.8.6 CONVERTTOCLOB Procedure
- 122.8.7 COPY Procedures
- 122.8.8 COPY_DBFS_LINK Procedures
- 122.8.9 COPY_FROM_DBFS_LINK
- 122.8.10 CREATETEMPORARY Procedures
- 122.8.11 DBFS_LINK_GENERATE_PATH Functions
- 122.8.12 ERASE Procedures
- 122.8.13 FILECLOSE Procedure
- 122.8.14 FILECLOSEALL Procedure
- 122.8.15 FILEEXISTS Function
- 122.8.16 FILEGETNAME Procedure
- 122.8.17 FILEISOPEN Function
- 122.8.18 FILEOPEN Procedure
- 122.8.19 FRAGMENT_DELETE Procedure
- 122.8.20 FRAGMENT_INSERT Procedures
- 122.8.21 FRAGMENT_MOVE Procedure
- 122.8.22 FRAGMENT_REPLACE Procedures
- 122.8.23 FREETEMPORARY Procedures
- 122.8.24 GET_DBFS_LINK Functions
- 122.8.25 GET_DBFS_LINK_STATE Procedures
- 122.8.26 GET_LOB_DEDUPLICATION_RATIO Function
- 122.8.27 GETCONTENTTYPE Functions
- 122.8.28 GET_STORAGE_LIMIT Function
- 122.8.29 GETCHUNKSIZE Functions
- 122.8.30 GETLENGTH Functions
- 122.8.31 GETOPTIONS Functions
- 122.8.32 INSTR Functions
- 122.8.33 ISOPEN Functions
- 122.8.34 ISREMOTE Function
- 122.8.35 ISSECUREFILE Function
- 122.8.36 ISTEMPORARY Functions
- 122.8.37 LOADBLOBFROMFILE Procedure
- 122.8.38 LOADCLOBFROMFILE Procedure
- 122.8.39 MOVE_TO_DBFS_LINK Procedures
- 122.8.40 OPEN Procedures
- 122.8.41 READ Procedures
- 122.8.42 SET_DBFS_LINK Procedures
- 122.8.43 SETCONTENTTYPE Procedure
- 122.8.44 SETOPTIONS Procedures
- 122.8.45 SUBSTR Functions
- 122.8.46 TRIM Procedures
- 122.8.47 WRITE Procedures
- 122.8.48 WRITEAPPEND Procedures
 
 
- 123 DBMS_LOCK
- 124 DBMS_LOGMNR
- 
               
               
                  
                  125
                      DBMS_LOGSTDBY
               
                  
               
               
               - 125.1 DBMS_LOGSTDBY Overview
- 125.2 DBMS_LOGSTDBY Security Model
- 125.3 DBMS_LOGSTDBY Constants
- 
                     
                     
                        
                        125.4
                            Summary of DBMS_LOGSTDBY Subprograms
                     
                        
                     
                     
                     - 125.4.1 APPLY_SET Procedure
- 125.4.2 APPLY_UNSET Procedure
- 125.4.3 BUILD Procedure
- 125.4.4 INSTANTIATE_TABLE Procedure
- 125.4.5 IS_APPLY_SERVER Function
- 125.4.6 MAP_PRIMARY_SCN Function
- 125.4.7 PREPARE_FOR_NEW_PRIMARY Procedure
- 125.4.8 PURGE_SESSION Procedure
- 125.4.9 REBUILD Procedure
- 125.4.10 SET_TABLESPACE Procedure
- 125.4.11 SKIP Procedure
- 125.4.12 SKIP_ERROR Procedure
- 125.4.13 SKIP_TRANSACTION Procedure
- 125.4.14 UNSKIP Procedure
- 125.4.15 UNSKIP_ERROR Procedure
- 125.4.16 UNSKIP_TRANSACTION Procedure
 
 
- 126 DBMS_LOGMNR_D
- 127 DBMS_LOGSTDBY_CONTEXT
- 128 DBMS_MEMOPTIMIZE
- 129 DBMS_MEMOPTIMIZE_ADMIN
- 
               
               
                  
                  130
                      DBMS_METADATA
               
                  
               
               
               - 130.1 DBMS_METADATA Overview
- 130.2 DBMS_METADATA Security Model
- 130.3 Rules and Limits
- 130.4 DBMS_METADATA Data Structures - Object and Table Types
- 130.5 DBMS_METADATA Subprogram Groupings
- 
                     
                     
                        
                        130.6
                            Summary of All DBMS_METADATA Subprograms
                     
                        
                     
                     
                     - 130.6.1 ADD_TRANSFORM Function
- 130.6.2 CLOSE Procedure
- 130.6.3 CONVERT Functions and Procedures
- 130.6.4 FETCH_xxx Functions and Procedures
- 130.6.5 GET_xxx Functions
- 130.6.6 GET_QUERY Function
- 130.6.7 OPEN Function
- 130.6.8 OPENW Function
- 130.6.9 PUT Function
- 130.6.10 SET_COUNT Procedure
- 130.6.11 SET_FILTER Procedure
- 130.6.12 SET_PARSE_ITEM Procedure
- 130.6.13 SET_TRANSFORM_PARAM and SET_REMAP_PARAM Procedures
 
 
- 131 DBMS_METADATA_DIFF
- 
               
               
                  
                  132
                       DBMS_MGD_ID_UTL 
               
                  
               
               
               - 132.1 DBMS_MGD_ID_UTL Security Model
- 132.2 DBMS_MGD_ID_UTL Constants
- 132.3 DBMS_MGD_ID_UTL Exceptions
- 
                     
                     
                        
                        132.4
                            Summary of DBMS_MGD_ID_UTL Subprograms
                     
                        
                     
                     
                     - 132.4.1 ADD_SCHEME Procedure
- 132.4.2 CREATE_CATEGORY Function
- 132.4.3 EPC_TO_ORACLE_SCHEME Function
- 132.4.4 GET_CATEGORY_ID Function
- 132.4.5 GET_COMPONENTS Function
- 132.4.6 GET_ENCODINGS Function
- 132.4.7 GET_JAVA_LOGGING_LEVEL Function
- 132.4.8 GET_PLSQL_LOGGING_LEVEL Function
- 132.4.9 GET_SCHEME_NAMES Function
- 132.4.10 GET_TDT_XML Function
- 132.4.11 GET_VALIDATOR Function
- 132.4.12 REFRESH_CATEGORY Function
- 132.4.13 REMOVE_CATEGORY Procedure
- 132.4.14 REMOVE_PROXY Procedure
- 132.4.15 REMOVE_SCHEME Procedure
- 132.4.16 SET_JAVA_LOGGING_LEVEL Procedure
- 132.4.17 SET_PLSQL_LOGGING_LEVEL Procedure
- 132.4.18 SET_PROXY Procedure
- 132.4.19 VALIDATE_SCHEME Function
 
 
- 
               
               
                  
                  133
                       DBMS_MGWADM
               
                  
               
               
               - 133.1 DBMS_MGWADM Security Model
- 133.2 DBMS_MGWADM Deprecated Subprograms
- 133.3 DBMS_MGWADM Constants
- 133.4 DBMS_MGWADM Data Structures
- 
                     
                     
                        
                        133.5
                            Summary of DBMS_MGWADM Subprograms
                     
                        
                     
                     
                     - 133.5.1 ADD_SUBSCRIBER Procedure
- 133.5.2 ALTER_AGENT Procedures
- 133.5.3 ALTER_JOB Procedure
- 133.5.4 ALTER_MSGSYSTEM_LINK Procedure for TIB/Rendezvous
- 133.5.5 ALTER_MSGSYSTEM_LINK Procedure for WebSphere MQ
- 133.5.6 ALTER_PROPAGATION_SCHEDULE Procedure
- 133.5.7 ALTER_SUBSCRIBER Procedure
- 133.5.8 CLEANUP_GATEWAY Procedures
- 133.5.9 CREATE_AGENT Procedure
- 133.5.10 CREATE_JOB Procedure
- 133.5.11 CREATE_MSGSYSTEM_LINK Procedures for TIB/Rendezvous
- 133.5.12 CREATE_MSGSYSTEM_LINK Procedures for WebSphere MQ
- 133.5.13 DB_CONNECT_INFO Procedure
- 133.5.14 DISABLE_JOB Procedure
- 133.5.15 DISABLE_PROPAGATION_SCHEDULE Procedure
- 133.5.16 ENABLE_JOB Procedure
- 133.5.17 ENABLE_PROPAGATION_SCHEDULE Procedure
- 133.5.18 REGISTER_FOREIGN_QUEUE Procedure
- 133.5.19 REMOVE_AGENT Procedure
- 133.5.20 REMOVE_JOB Procedure
- 133.5.21 REMOVE_MSGSYSTEM_LINK Procedure
- 133.5.22 REMOVE_OPTION Procedure
- 133.5.23 REMOVE_SUBSCRIBER Procedure
- 133.5.24 RESET_JOB Procedure
- 133.5.25 RESET_SUBSCRIBER Procedure
- 133.5.26 SCHEDULE_PROPAGATION Procedure
- 133.5.27 SET_LOG_LEVEL Procedures
- 133.5.28 SET_OPTION Procedure
- 133.5.29 SHUTDOWN Procedures
- 133.5.30 STARTUP Procedures
- 133.5.31 UNREGISTER_FOREIGN_QUEUE Procedure
- 133.5.32 UNSCHEDULE_PROPAGATION Procedure
 
 
- 
               
               
                  
                  134
                       DBMS_MGWMSG
               
                  
               
               
               - 134.1 DBMS_MGWMSG Security Model
- 134.2 DBMS_MGWMSG Constants
- 
                     
                     
                        
                        134.3
                            DBMS_MGWMSG Types
                     
                        
                     
                     
                     - 134.3.1 DBMS_MGWMSG SYS.MGW_NAME_VALUE_T Type
- 134.3.2 DBMS_MGWMSG SYS.MGW_NAME_TYPE_ARRAY_T Type
- 134.3.3 DBMS_MGWMSG SYS.MGW_TEXT_VALUE_T Type
- 134.3.4 DBMS_MGWMSG SYS.MGW_RAW_VALUE_T Type
- 134.3.5 DBMS_MGWMSG SYS.MGW_BASIC_MSG_T Type
- 134.3.6 DBMS_MGWMSG SYS.MGW_NUMBER_ARRAY_T Type
- 134.3.7 DBMS_MGWMSG SYS.MGW_TIBRV_FIELD_T Type
- 134.3.8 DBMS_MGWMSG SYS.MGW_TIBRV_MSG_T Type
 
- 
                     
                     
                        
                        134.4
                            Summary of DBMS_MGWMSG Subprograms
                     
                        
                     
                     
                     - 134.4.1 LCR_TO_XML Function
- 134.4.2 NVARRAY_ADD Procedure
- 134.4.3 NVARRAY_FIND_NAME Function
- 134.4.4 NVARRAY_FIND_NAME_TYPE Function
- 134.4.5 NVARRAY_GET Function
- 134.4.6 NVARRAY_GET_BOOLEAN Function
- 134.4.7 NVARRAY_GET_BYTE Function
- 134.4.8 NVARRAY_GET_DATE Function
- 134.4.9 NVARRAY_GET_DOUBLE Function
- 134.4.10 NVARRAY_GET_FLOAT Function
- 134.4.11 NVARRAY_GET_INTEGER Function
- 134.4.12 NVARRAY_GET_LONG Function
- 134.4.13 NVARRAY_GET_RAW Function
- 134.4.14 NVARRAY_GET_SHORT Function
- 134.4.15 NVARRAY_GET_TEXT Function
- 134.4.16 XML_TO_LCR Function
 
 
- 
               
               
                  
                  135
                      DBMS_MLE
               
                  
               
               
               - 135.1 DBMS_MLE Overview
- 135.2 DBMS_MLE Security Model
- 
                     
                     
                        
                        135.3
                            Summary of DBMS_MLE Subprograms
                     
                        
                     
                     
                     - 135.3.1 CREATE_CONTEXT Function
- 135.3.2 DISABLE_CTX_STDERR Procedure
- 135.3.3 DISABLE_CTX_STDOUT Procedure
- 135.3.4 DISABLE_DEBUGGING Procedure
- 135.3.5 DISABLE_ICS_STDERR Procedure
- 135.3.6 DISABLE_ICS_STDOUT Procedure
- 135.3.7 DISABLE_STDERR Procedure
- 135.3.8 DISABLE_STDOUT Procedure
- 135.3.9 DROP_CONTEXT Procedure
- 135.3.10 ENABLE_DEBUGGING Procedure
- 135.3.11 EVAL Procedure
- 135.3.12 EXPORT_TO_MLE Procedure
- 135.3.13 GET_AVAILABLE_LANGUAGES Function
- 135.3.14 GET_CTX_ERROR_STACK Function
- 135.3.15 GET_ERROR_STACK Function
- 135.3.16 IMPORT_FROM_MLE Procedure
- 135.3.17 PARSE_DEBUG_OUTPUT Function
- 135.3.18 SET_CTX_STDERR Procedure
- 135.3.19 SET_CTX_STDERR_TO_DBMS_OUTPUT Procedure
- 135.3.20 SET_CTX_STDOUT Procedure
- 135.3.21 SET_CTX_STDOUT_TO_DBMS_OUTPUT Procedure
- 135.3.22 SET_ICS_STDERR Procedure
- 135.3.23 SET_ICS_STDERR_TO_DBMS_OUTPUT Procedure
- 135.3.24 SET_ICS_STDOUT Procedure
- 135.3.25 SET_ICS_STDOUT_TO_DBMS_OUTPUT Procedure
- 135.3.26 SET_STDERR Procedure
- 135.3.27 SET_STDERR_TO_DBMS_OUTPUT Procedure
- 135.3.28 SET_STDOUT Procedure
- 135.3.29 SET_STDOUT_TO_DBMS_OUTPUT Procedure
 
 
- 
               
               
                  
                  136
                       DBMS_MONITOR
               
                  
               
               
               - 
                     
                     
                        
                        136.1
                            Summary of DBMS_MONITOR Subprograms
                     
                        
                     
                     
                     - 136.1.1 CLIENT_ID_STAT_DISABLE Procedure
- 136.1.2 CLIENT_ID_STAT_ENABLE Procedure
- 136.1.3 CLIENT_ID_TRACE_DISABLE Procedure
- 136.1.4 CLIENT_ID_TRACE_ENABLE Procedure
- 136.1.5 DATABASE_TRACE_DISABLE Procedure
- 136.1.6 DATABASE_TRACE_ENABLE Procedure
- 136.1.7 SERV_MOD_ACT_STAT_DISABLE Procedure
- 136.1.8 SERV_MOD_ACT_STAT_ENABLE Procedure
- 136.1.9 SERV_MOD_ACT_TRACE_DISABLE Procedure
- 136.1.10 SERV_MOD_ACT_TRACE_ENABLE Procedure
- 136.1.11 SESSION_TRACE_DISABLE Procedure
- 136.1.12 SESSION_TRACE_ENABLE Procedure
 
 
- 
                     
                     
                        
                        136.1
                            Summary of DBMS_MONITOR Subprograms
                     
                        
                     
                     
                     
- 
               
               
                  
                  137
                       DBMS_MVIEW
               
                  
               
               
               - 137.1 DBMS_MVIEW Operational Notes
- 137.2 DBMS_MVIEW Security Model
- 137.3 DBMS_MVIEW Rules and Limits
- 
                     
                     
                        
                        137.4
                            Summary of DBMS_MVIEW Subprograms
                     
                        
                     
                     
                     - 137.4.1 BEGIN_TABLE_REORGANIZATION Procedure
- 137.4.2 END_TABLE_REORGANIZATION Procedure
- 137.4.3 ESTIMATE_MVIEW_SIZE Procedure
- 137.4.4 EXPLAIN_MVIEW Procedure
- 137.4.5 EXPLAIN_REWRITE Procedure
- 137.4.6 FMARKER Procedure
- 137.4.7 I_AM_A_REFRESH Function
- 137.4.8 PMARKER Function
- 137.4.9 PURGE_DIRECT_LOAD_LOG Procedure
- 137.4.10 PURGE_LOG Procedure
- 137.4.11 PURGE_MVIEW_FROM_LOG Procedure
- 137.4.12 REFRESH Procedures
- 137.4.13 REFRESH_ALL_MVIEWS Procedure
- 137.4.14 REFRESH_DEPENDENT Procedures
- 137.4.15 REGISTER_MVIEW Procedure
- 137.4.16 UNREGISTER_MVIEW Procedure
 
 
- 138 DBMS_MVIEW_STATS
- 
               
               
                  
                  139
                       DBMS_NETWORK_ACL_ADMIN
               
                  
               
               
               - 139.1 DBMS_NETWORK_ACL_ADMIN Overview
- 139.2 DBMS_NETWORK_ACL_ADMIN Deprecated Subprograms
- 139.3 DBMS_NETWORK_ACL_ADMIN Security Model
- 139.4 DBMS_NETWORK_ACL_ADMIN Constants
- 139.5 DBMS_NETWORK_ACL_ADMIN Exceptions
- 139.6 DBMS_NETWORK_ACL_ADMIN Examples
- 
                     
                     
                        
                        139.7
                            Summary of DBMS_NETWORK_ACL_ADMIN Subprograms
                     
                        
                     
                     
                     - 139.7.1 ADD_PRIVILEGE Procedure
- 139.7.2 APPEND_HOST_ACE Procedure
- 139.7.3 APPEND_HOST_ACL Procedure
- 139.7.4 APPEND_WALLET_ACE Procedure
- 139.7.5 APPEND_WALLET_ACL Procedure
- 139.7.6 ASSIGN_ACL Procedure
- 139.7.7 ASSIGN_WALLET_ACL Procedure
- 139.7.8 CHECK_PRIVILEGE Function
- 139.7.9 CHECK_PRIVILEGE_ACLID Function
- 139.7.10 CREATE_ACL Procedure
- 139.7.11 DELETE_PRIVILEGE Procedure
- 139.7.12 DROP_ACL Procedure
- 139.7.13 REMOVE_HOST_ACE Procedure
- 139.7.14 REMOVE_WALLET_ACE Procedure
- 139.7.15 SET_HOST_ACL Procedure
- 139.7.16 SET_WALLET_ACL Procedure
- 139.7.17 UNASSIGN_ACL Procedure
- 139.7.18 UNASSIGN_WALLET_ACL Procedure
 
 
- 140 DBMS_NETWORK_ACL_UTILITY
- 141 DBMS_ODCI
- 142 DBMS_OPTIM_BUNDLE
- 143 DBMS_OUTLN
- 144 DBMS_OUTPUT
- 
               
               
                  
                  145
                       DBMS_PARALLEL_EXECUTE 
               
                  
               
               
               - 145.1 DBMS_PARALLEL_EXECUTE Overview
- 145.2 DBMS_PARALLEL_EXECUTE Security Model
- 145.3 DBMS_PARALLEL_EXECUTE Constants
- 145.4 DBMS_PARALLEL_EXECUTE Views
- 145.5 DBMS_PARALLEL_EXECUTE Exceptions
- 145.6 DBMS_PARALLEL_EXECUTE Examples
- 
                     
                     
                        
                        145.7
                            Summary of DBMS_PARALLEL_EXECUTE Subprograms
                     
                        
                     
                     
                     - 145.7.1 ADM_DROP_CHUNKS Procedure
- 145.7.2 ADM_DROP_TASK Procedure
- 145.7.3 ADM_TASK_STATUS Function
- 145.7.4 ADM_STOP_TASK Procedure
- 145.7.5 CREATE_TASK Procedure
- 145.7.6 CREATE_CHUNKS_BY_NUMBER_COL Procedure
- 145.7.7 CREATE_CHUNKS_BY_ROWID Procedure
- 145.7.8 CREATE_CHUNKS_BY_SQL Procedure
- 145.7.9 DROP_TASK Procedure
- 145.7.10 DROP_CHUNKS Procedure
- 145.7.11 GENERATE_TASK_NAME Function
- 145.7.12 GET_NUMBER_COL_CHUNK Procedure
- 145.7.13 GET_ROWID_CHUNK Procedure
- 145.7.14 PURGE_PROCESSED_CHUNKS Procedure
- 145.7.15 RESUME_TASK Procedures
- 145.7.16 RUN_TASK Procedure
- 145.7.17 SET_CHUNK_STATUS Procedure
- 145.7.18 STOP_TASK Procedure
- 145.7.19 TASK_STATUS Procedure
 
 
- 146 DBMS_PART
- 147 DBMS_PCLXUTIL
- 
               
               
                  
                  148
                      DBMS_PDB
               
                  
               
               
               - 148.1 DBMS_PDB Overview
- 148.2 DBMS_PDB Security Model
- 
                     
                     
                        
                        148.3
                            Summary of DBMS_PDB Subprograms
                     
                        
                     
                     
                     - 148.3.1 CHECK_PLUG_COMPATIBILITY Function
- 148.3.2 DESCRIBE Procedure
- 148.3.3 EXPORTRMANBACKUP Procedure
- 148.3.4 RECOVER Procedure
- 148.3.5 SET_DATA_LINKED Procedure
- 148.3.6 SET_EXT_DATA_LINKED Procedure
- 148.3.7 SET_METADATA_LINKED Procedure
- 148.3.8 SET_PROFILE_EXPLICIT Procedure
- 148.3.9 SET_ROLE_EXPLICIT Procedure
- 148.3.10 SET_USER_EXPLICIT Procedure
 
 
- 149 DBMS_PDB_ALTER_SHARING
- 150 DBMS_PERF
- 
               
               
                  
                  151
                       DBMS_PIPE 
               
                  
               
               
               - 151.1 DBMS_PIPE Overview
- 151.2 DBMS_PIPE Security Model
- 151.3 DBMS_PIPE Constants
- 151.4 DBMS_PIPE Operational Notes
- 151.5 DBMS_PIPE Exceptions
- 151.6 DBMS_PIPE Examples
- 
                     
                     
                        
                        151.7
                            Summary of DBMS_PIPE Subprograms
                     
                        
                     
                     
                     - 151.7.1 CREATE_PIPE Function
- 151.7.2 GET_CREDENTIAL_NAME Function
- 151.7.3 GET_LOCATION_URI Function
- 151.7.4 NEXT_ITEM_TYPE Function
- 151.7.5 PACK_MESSAGE Procedures
- 151.7.6 PURGE Procedure
- 151.7.7 RECEIVE_MESSAGE Function
- 151.7.8 RESET_BUFFER Procedure
- 151.7.9 REMOVE_PIPE Function
- 151.7.10 SEND_MESSAGE Function
- 151.7.11 SET_CREDENTIAL_NAME Procedure
- 151.7.12 SET_LOCATION_URI Procedure
- 151.7.13 UNIQUE_SESSION_NAME Function
- 151.7.14 UNPACK_MESSAGE Procedures
 
 
- 152 DBMS_PLSQL_CODE_COVERAGE
- 153 DBMS_PREDICTIVE_ANALYTICS
- 154 DBMS_PREPROCESSOR
- 155 DBMS_PRIVILEGE_CAPTURE
- 156 DBMS_PROCESS
- 157 DBMS_PROFILER
- 158 DBMS_PROPAGATION_ADM
- 
               
               
                  
                  159
                       DBMS_QOPATCH 
               
                  
               
               
               - 159.1 DBMS_QOPATCH Overview
- 159.2 DBMS_QOPATCH Security Model
- 159.3 DBMS_QOPATCH Operational Notes
- 159.4 DBMS_QOPATCH Exceptions
- 
                     
                     
                        
                        159.5
                            Summary of DBMS_QOPATCH Subprograms
                     
                        
                     
                     
                     - 159.5.1 CHECK_PATCH_INSTALLED Function
- 159.5.2 GET_OPATCH_BUGS Function
- 159.5.3 GET_OPATCH_COUNT Function
- 159.5.4 GET_OPATCH_DATA Function
- 159.5.5 GET_OPATCH_FILES Function
- 159.5.6 GET_OPATCH_INSTALL_INFO Function
- 159.5.7 GET_OPATCH_LIST Function
- 159.5.8 GET_OPATCH_LSINVENTORY
- 159.5.9 GET_OPATCH_OLAYS Function
- 159.5.10 GET_OPATCH_PREQS Function
- 159.5.11 GET_OPATCH_XSLT
- 159.5.12 GET_PATCH_DETAILS Function
- 159.5.13 GET_SQLPATCH_STATUS Procedure
- 159.5.14 IS_PATCH_INSTALLED Function
- 159.5.15 OPATCH_COMPARE_CURRENT Function
- 159.5.16 OPATCH_COMPARE_NODES Function
- 159.5.17 SET_CURRENT_OPINST Procedure
 
 
- 160 DBMS_RANDOM
- 
               
               
                  
                  161
                       DBMS_REDACT
               
                  
               
               
               - 161.1 DBMS_REDACT Overview
- 161.2 DBMS_REDACT Security Model
- 161.3 DBMS_REDACT Constants
- 161.4 DBMS_REDACT Operating Procedures
- 
                     
                     
                        
                        161.5
                            Summary of DBMS_REDACT Subprograms
                     
                        
                     
                     
                     - 161.5.1 ADD_POLICY Procedure
- 161.5.2 ALTER_POLICY Procedure
- 161.5.3 APPLY_POLICY_EXPR_TO_COL Procedure
- 161.5.4 CREATE_POLICY_EXPRESSION Procedure
- 161.5.5 DISABLE_POLICY Procedure
- 161.5.6 DROP_POLICY Procedure
- 161.5.7 DROP_POLICY_EXPRESSION Procedure
- 161.5.8 ENABLE_POLICY Procedure
- 161.5.9 UPDATE_FULL_REDACTION_VALUES Procedure
- 161.5.10 UPDATE_POLICY_EXPRESSION Procedure
 
 
- 
               
               
                  
                  162
                       DBMS_REDEFINITION 
               
                  
               
               
               - 162.1 DBMS_REDEFINITION Overview
- 162.2 DBMS_REDEFINITION Security Model
- 162.3 DBMS_REDEFINITION Constants
- 162.4 DBMS_REDEFINITION Operational Notes
- 162.5 DBMS_REDEFINITION Rules and Limits
- 162.6 DBMS_REDEFINITION Examples
- 
                     
                     
                        
                        162.7
                            Summary of DBMS_REDEFINITION Subprograms
                     
                        
                     
                     
                     - 162.7.1 ABORT_REDEF_TABLE Procedure
- 162.7.2 ABORT_ROLLBACK Procedure
- 162.7.3 ABORT_UPDATE Procedure
- 162.7.4 CAN_REDEF_TABLE Procedure
- 162.7.5 COPY_TABLE_DEPENDENTS Procedure
- 162.7.6 EXECUTE_UPDATE Procedure
- 162.7.7 FINISH_REDEF_TABLE Procedure
- 162.7.8 REDEF_TABLE Procedure
- 162.7.9 REGISTER_DEPENDENT_OBJECT Procedure
- 162.7.10 ROLLBACK Procedure
- 162.7.11 SET_PARAM Procedure
- 162.7.12 START_REDEF_TABLE Procedure
- 162.7.13 SYNC_INTERIM_TABLE Procedure
- 162.7.14 UNREGISTER_DEPENDENT_OBJECT Procedure
 
 
- 163 DBMS_REFRESH
- 164 DBMS_REPAIR
- 
               
               
                  
                  165
                       DBMS_RESCONFIG
               
                  
               
               
               - 165.1 DBMS_RESCONFIG Overview
- 
                     
                     
                        
                        165.2
                            Summary of DBMS_RESCONFIG Subprograms
                     
                        
                     
                     
                     - 165.2.1 ADDREPOSITORYRESCONFIG Procedure
- 165.2.2 ADDRESCONFIG Procedure
- 165.2.3 APPENDRESCONFIG Procedure
- 165.2.4 DELETEREPOSITORYRESCONFIG Procedure
- 165.2.5 DELETERESCONFIG Procedures
- 165.2.6 GETLISTENERS Function
- 165.2.7 GETREPOSITORYRESCONFIG Function
- 165.2.8 GETREPOSITORYRESCONFIGPATHS Function
- 165.2.9 GETRESCONFIG Function
- 165.2.10 GETRESCONFIGPATHS Function
- 165.2.11 PATCHREPOSITORYRESCONFIGLIST Procedure
 
 
- 
               
               
                  
                  166
                       DBMS_RESOURCE_MANAGER
               
                  
               
               
               - 166.1 DBMS_RESOURCE_MANAGER Deprecated Subprograms
- 166.2 DBMS_RESOURCE_MANAGER Security Model
- 166.3 DBMS_RESOURCE_MANAGER Constants
- 
                     
                     
                        
                        166.4
                            Summary of DBMS_RESOURCE_MANAGER Subprograms
                     
                        
                     
                     
                     - 166.4.1 BEGIN_SQL_BLOCK Procedure
- 166.4.2 CALIBRATE_IO Procedure
- 166.4.3 CLEAR_PENDING_AREA Procedure
- 166.4.4 CREATE_CATEGORY Procedure
- 166.4.5 CREATE_CDB_PLAN Procedure
- 166.4.6 CREATE_CDB_PLAN_DIRECTIVE Procedure
- 166.4.7 CREATE_CDB_PROFILE_DIRECTIVE Procedure
- 166.4.8 CREATE_CONSUMER_GROUP Procedure
- 166.4.9 CREATE_PENDING_AREA Procedure
- 166.4.10 CREATE_PLAN Procedure
- 166.4.11 CREATE_PLAN_DIRECTIVE Procedure
- 166.4.12 CREATE_SIMPLE_PLAN Procedure
- 166.4.13 DELETE_CATEGORY Procedure
- 166.4.14 DELETE_CDB_PLAN Procedure
- 166.4.15 DELETE_CDB_PLAN_DIRECTIVE Procedure
- 166.4.16 DELETE_CDB_PROFILE_DIRECTIVE Procedure
- 166.4.17 DELETE_CONSUMER_GROUP Procedure
- 166.4.18 DELETE_PLAN Procedure
- 166.4.19 DELETE_PLAN_CASCADE Procedure
- 166.4.20 DELETE_PLAN_DIRECTIVE Procedure
- 166.4.21 DEQUEUE_PARALLEL_STATEMENT Procedure
- 166.4.22 END_SQL_BLOCK Procedure
- 166.4.23 SET_CONSUMER_GROUP_MAPPING Procedure
- 166.4.24 SET_CONSUMER_GROUP_MAPPING_PRI Procedure
- 166.4.25 SET_INITIAL_CONSUMER_GROUP Procedure
- 166.4.26 SUBMIT_PENDING_AREA Procedure
- 166.4.27 SWITCH_CONSUMER_GROUP_FOR_SESS Procedure
- 166.4.28 SWITCH_CONSUMER_GROUP_FOR_USER Procedure
- 166.4.29 SWITCH_PLAN Procedure
- 166.4.30 UPDATE_CATEGORY Procedure
- 166.4.31 UPDATE_CDB_AUTOTASK_DIRECTIVE Procedure
- 166.4.32 UPDATE_CDB_DEFAULT_DIRECTIVE Procedure
- 166.4.33 UPDATE_CDB_PLAN Procedure
- 166.4.34 UPDATE_CDB_PLAN_DIRECTIVE Procedure
- 166.4.35 UPDATE_CDB_PROFILE_DIRECTIVE Procedure
- 166.4.36 UPDATE_CONSUMER_GROUP Procedure
- 166.4.37 UPDATE_PLAN Procedure
- 166.4.38 UPDATE_PLAN_DIRECTIVE Procedure
- 166.4.39 VALIDATE_PENDING_AREA Procedure
 
 
- 167 DBMS_RESOURCE_MANAGER_PRIVS
- 
               
               
                  
                  168
                       DBMS_RESULT_CACHE 
               
                  
               
               
               - 168.1 DBMS_RESULT_CACHE Security Model
- 168.2 DBMS_RESULT_CACHE Constants
- 
                     
                     
                        
                        168.3
                            Summary of DBMS_RESULT_CACHE Subprograms
                     
                        
                     
                     
                     - 168.3.1 BLACK_LIST Function
- 168.3.2 BLACK_LIST_ADD Procedure
- 168.3.3 BLACK_LIST_CLEAR Procedure
- 168.3.4 BLACK_LIST_REMOVE Procedure
- 168.3.5 BYPASS Procedure
- 168.3.6 FLUSH Function & Procedure
- 168.3.7 IGNORE_LIST Function
- 168.3.8 IGNORE_LIST_ADD Procedure
- 168.3.9 IGNORE_LIST_CLEAR Procedure
- 168.3.10 IGNORE_LIST_REMOVE Procedure
- 168.3.11 INVALIDATE Functions & Procedures
- 168.3.12 INVALIDATE_OBJECT Functions & Procedures
- 168.3.13 MEMORY_REPORT Procedure
- 168.3.14 OBJECT_BLACK_LIST Function
- 168.3.15 OBJECT_BLACK_LIST_ADD Procedure
- 168.3.16 OBJECT_BLACK_LIST_CLEAR Procedure
- 168.3.17 OBJECT_BLACK_LIST_REMOVE Procedure
- 168.3.18 STATUS Function
- 168.3.19 BLOCK_LIST Function
- 168.3.20 BLOCK_LIST_ADD Procedure
- 168.3.21 BLOCK_LIST_CLEAR Procedure
- 168.3.22 BLOCK_LIST_REMOVE Procedure
- 168.3.23 OBJECT_BLOCK_LIST Function
- 168.3.24 OBJECT_BLOCK_LIST_ADD Procedure
- 168.3.25 OBJECT_BLOCK_LIST_CLEAR Procedure
- 168.3.26 OBJECT_BLOCK_LIST_REMOVE Procedure
 
 
- 169 DBMS_RESUMABLE
- 
               
               
                  
                  170
                       DBMS_RLS
               
                  
               
               
               - 170.1 DBMS_RLS Overview
- 170.2 DBMS_RLS Security Model
- 170.3 DBMS_RLS Constants
- 170.4 DBMS_RLS Operational Notes
- 170.5 DBMS_RLS Rules and Limits
- 
                     
                     
                        
                        170.6
                            Summary of DBMS_RLS Subprograms
                     
                        
                     
                     
                     - 170.6.1 ADD_GROUPED_POLICY Procedure
- 170.6.2 ADD_POLICY Procedure
- 170.6.3 ADD_POLICY_CONTEXT Procedure
- 170.6.4 ALTER_POLICY Procedure
- 170.6.5 ALTER_GROUPED_POLICY Procedure
- 170.6.6 CREATE_POLICY_GROUP Procedure
- 170.6.7 DELETE_POLICY_GROUP Procedure
- 170.6.8 DISABLE_GROUPED_POLICY Procedure
- 170.6.9 DROP_GROUPED_POLICY Procedure
- 170.6.10 DROP_POLICY Procedure
- 170.6.11 DROP_POLICY_CONTEXT Procedure
- 170.6.12 ENABLE_GROUPED_POLICY Procedure
- 170.6.13 ENABLE_POLICY Procedure
- 170.6.14 REFRESH_GROUPED_POLICY Procedure
- 170.6.15 REFRESH_POLICY Procedure
 
 
- 171 DBMS_ROLLING
- 
               
               
                  
                  172
                       DBMS_ROWID 
               
                  
               
               
               - 172.1 DBMS_ROWID Security Model
- 172.2 DBMS_ROWID Types
- 172.3 DBMS_ROWID Exceptions
- 172.4 DBMS_ROWID Operational Notes
- 172.5 DBMS_ROWID Examples
- 
                     
                     
                        
                        172.6
                            Summary of DBMS_ROWID Subprograms
                     
                        
                     
                     
                     - 172.6.1 ROWID_BLOCK_NUMBER Function
- 172.6.2 ROWID_CREATE Function
- 172.6.3 ROWID_INFO Procedure
- 172.6.4 ROWID_OBJECT Function
- 172.6.5 ROWID_RELATIVE_FNO Function
- 172.6.6 ROWID_ROW_NUMBER Function
- 172.6.7 ROWID_TO_ABSOLUTE_FNO Function
- 172.6.8 ROWID_TO_EXTENDED Function
- 172.6.9 ROWID_TO_RESTRICTED Function
- 172.6.10 ROWID_TYPE Function
- 172.6.11 ROWID_VERIFY Function
 
 
- 
               
               
                  
                  173
                       DBMS_RULE
               
                  
               
               
               - 173.1 DBMS_RULE Overview
- 173.2 DBMS_RULE Security Model
- 
                     
                     
                        
                        173.3
                            Summary of DBMS_RULE Subprograms
                     
                        
                     
                     
                     - 173.3.1 CLOSE_ITERATOR Procedure
- 173.3.2 EVALUATE Procedure
- 173.3.3 EVALUATE_EXPRESSION Procedure
- 173.3.4 EVALUATE_EXPRESSION_ITERATOR Procedure
- 173.3.5 EVALUATE_RULE Procedure
- 173.3.6 EVALUATE_RULE_ITERATOR Procedure
- 173.3.7 GET_NEXT_HIT Function
- 173.3.8 GET_NEXT_RESULT Function
- 173.3.9 IS_FAST Procedure
 
 
- 
               
               
                  
                  174
                       DBMS_RULE_ADM
               
                  
               
               
               - 174.1 DBMS_RULE_ADM Overview
- 174.2 DBMS_RULE_ADM Security Model
- 
                     
                     
                        
                        174.3
                            Summary of DBMS_RULE_ADM Subprograms
                     
                        
                     
                     
                     - 174.3.1 ADD_RULE Procedure
- 174.3.2 ALTER_EVALUATION_CONTEXT Procedure
- 174.3.3 ALTER_RULE Procedure
- 174.3.4 CREATE_EVALUATION_CONTEXT Procedure
- 174.3.5 CREATE_RULE Procedure
- 174.3.6 CREATE_RULE_SET Procedure
- 174.3.7 DROP_EVALUATION_CONTEXT Procedure
- 174.3.8 DROP_RULE Procedure
- 174.3.9 DROP_RULE_SET Procedure
- 174.3.10 GRANT_OBJECT_PRIVILEGE Procedure
- 174.3.11 GRANT_SCHEMA_PRIVILEGE Procedure
- 174.3.12 GRANT_SYSTEM_PRIVILEGE Procedure
- 174.3.13 REMOVE_RULE Procedure
- 174.3.14 REVOKE_OBJECT_PRIVILEGE Procedure
- 174.3.15 REVOKE_SCHEMA_PRIVILEGE Procedure
- 174.3.16 REVOKE_SYSTEM_PRIVILEGE Procedure
 
 
- 175 DBMS_SAGA_ADM
- 176 DBMS_SAGA
- 
               
               
                  
                  177
                       DBMS_SCHEDULER
               
                  
               
               
               - 177.1 DBMS_SCHEDULER Deprecated Subprograms
- 177.2 DBMS_SCHEDULER Security Model
- 177.3 DBMS_SCHEDULER Rules and Limits
- 177.4 DBMS_SCHEDULER Operational Notes
- 
                     
                     
                        
                        177.5
                            DBMS_SCHEDULER Data Structures
                     
                        
                     
                     
                     - 177.5.1 DBMS_SCHEDULER JOBARG Object Type
- 177.5.2 JOBARG_ARRAY Table Type
- 177.5.3 DBMS_SCHEDULER JOB_DEFINITION Object Type
- 177.5.4 JOB_DEFINITION_ARRAY Table Type
- 177.5.5 JOBATTR Object Type
- 177.5.6 JOBATTR_ARRAY Table Type
- 177.5.7 SCHEDULER$_STEP_TYPE Object Type
- 177.5.8 SCHEDULER$_STEP_TYPE_LIST Table Type
- 177.5.9 SCHEDULER$_EVENT_INFO Object Type
- 177.5.10 SCHEDULER_FILEWATCHER_RESULT Object Type
- 177.5.11 SCHEDULER_FILEWATCHER_REQUEST Object Type
 
- 
                     
                     
                        
                        177.6
                            Summary of DBMS_SCHEDULER Subprograms
                     
                        
                     
                     
                     - 177.6.1 ADD_EVENT_QUEUE_SUBSCRIBER Procedure
- 177.6.2 ADD_GROUP_MEMBER Procedure
- 177.6.3 ADD_JOB_EMAIL_NOTIFICATION Procedure
- 177.6.4 ADD_TO_INCOMPATIBILITY Procedure
- 177.6.5 ALTER_CHAIN Procedure
- 177.6.6 ALTER_RUNNING_CHAIN Procedure
- 177.6.7 CLOSE_WINDOW Procedure
- 177.6.8 COPY_JOB Procedure
- 177.6.9 CREATE_CHAIN Procedure
- 177.6.10 CREATE_CREDENTIAL Procedure
- 177.6.11 CREATE_DATABASE_DESTINATION Procedure
- 177.6.12 CREATE_EVENT_SCHEDULE Procedure
- 177.6.13 CREATE_FILE_WATCHER Procedure
- 177.6.14 CREATE_GROUP Procedure
- 177.6.15 CREATE_INCOMPATIBILITY Procedure
- 177.6.16 CREATE_JOB Procedure
- 177.6.17 CREATE_JOB_CLASS Procedure
- 177.6.18 CREATE_JOBS Procedure
- 177.6.19 CREATE_PROGRAM Procedure
- 177.6.20 CREATE_RESOURCE Procedure
- 177.6.21 CREATE_SCHEDULE Procedure
- 177.6.22 CREATE_WINDOW Procedure
- 177.6.23 DEFINE_ANYDATA_ARGUMENT Procedure
- 177.6.24 DEFINE_CHAIN_EVENT_STEP Procedure
- 177.6.25 DEFINE_CHAIN_RULE Procedure
- 177.6.26 DEFINE_CHAIN_STEP Procedure
- 177.6.27 DEFINE_METADATA_ARGUMENT Procedure
- 177.6.28 DEFINE_PROGRAM_ARGUMENT Procedure
- 177.6.29 DISABLE Procedure
- 177.6.30 DROP_AGENT_DESTINATION Procedure
- 177.6.31 DROP_CHAIN Procedure
- 177.6.32 DROP_CHAIN_RULE Procedure
- 177.6.33 DROP_CHAIN_STEP Procedure
- 177.6.34 DROP_CREDENTIAL Procedure
- 177.6.35 DROP_DATABASE_DESTINATION Procedure
- 177.6.36 DROP_FILE_WATCHER Procedure
- 177.6.37 DROP_GROUP Procedure
- 177.6.38 DROP_INCOMPATIBILITY Procedure
- 177.6.39 DROP_JOB Procedure
- 177.6.40 DROP_JOB_CLASS Procedure
- 177.6.41 DROP_PROGRAM Procedure
- 177.6.42 DROP_PROGRAM_ARGUMENT Procedure
- 177.6.43 DROP_RESOURCE Procedure
- 177.6.44 DROP_SCHEDULE Procedure
- 177.6.45 DROP_WINDOW Procedure
- 177.6.46 DUMP_IN_MEMORY_TRACE Procedure
- 177.6.47 ENABLE Procedure
- 177.6.48 END_DETACHED_JOB_RUN Procedure
- 177.6.49 EVALUATE_CALENDAR_STRING Procedure
- 177.6.50 EVALUATE_RUNNING_CHAIN Procedure
- 177.6.51 GENERATE_JOB_NAME Function
- 177.6.52 GET_AGENT_INFO Function
- 177.6.53 GET_AGENT_VERSION Function
- 177.6.54 GET_ATTRIBUTE Procedure
- 177.6.55 GET_FILE Procedure
- 177.6.56 GET_SCHEDULER_ATTRIBUTE Procedure
- 177.6.57 OPEN_WINDOW Procedure
- 177.6.58 PURGE_LOG Procedure
- 177.6.59 PUT_FILE Procedure
- 177.6.60 REMOVE_EVENT_QUEUE_SUBSCRIBER Procedure
- 177.6.61 REMOVE_FROM_INCOMPATIBILITY Procedure
- 177.6.62 REMOVE_GROUP_MEMBER Procedure
- 177.6.63 REMOVE_JOB_EMAIL_NOTIFICATION Procedure
- 177.6.64 RESET_JOB_ARGUMENT_VALUE Procedure
- 177.6.65 RUN_CHAIN Procedure
- 177.6.66 RUN_JOB Procedure
- 177.6.67 SET_AGENT_REGISTRATION_PASS Procedure
- 177.6.68 SET_ATTRIBUTE Procedure
- 177.6.69 SET_ATTRIBUTE_NULL Procedure
- 177.6.70 SET_JOB_ANYDATA_VALUE Procedure
- 177.6.71 SET_JOB_ARGUMENT_VALUE Procedure
- 177.6.72 SET_JOB_ATTRIBUTES Procedure
- 177.6.73 SET_RESOURCE_CONSTRAINT Procedure
- 177.6.74 SET_SCHEDULER_ATTRIBUTE Procedure
- 177.6.75 STOP_JOB Procedure
 
 
- 178 DBMS_SEARCH
- 179 DBMS_SERVER_ALERT
- 180 DBMS_SERVICE
- 
               
               
                  
                  181
                       DBMS_SESSION 
               
                  
               
               
               - 181.1 DBMS_SESSION Security Model
- 181.2 DBMS_SESSION Operational Notes
- 181.3 DBMS_SESSION Data Structures
- 
                     
                     
                        
                        181.4
                            Summary of DBMS_SESSION Subprograms
                     
                        
                     
                     
                     - 181.4.1 CLEAR_ALL_CONTEXT Procedure
- 181.4.2 CLEAR_ALL_LOCAL_CONTEXTS Procedure
- 181.4.3 CLEAR_CONTEXT Procedure
- 181.4.4 CLEAR_IDENTIFIER Procedure
- 181.4.5 CLOSE_DATABASE_LINK Procedure
- 181.4.6 CURRENT_IS_ROLE_ENABLED Function
- 181.4.7 FREE_UNUSED_USER_MEMORY Procedure
- 181.4.8 GET_PACKAGE_MEMORY_UTILIZATION Procedure
- 181.4.9 IS_ROLE_ENABLED Function
- 181.4.10 IS_SESSION_ALIVE Function
- 181.4.11 LIST_CONTEXT Procedures
- 181.4.12 MODIFY_PACKAGE_STATE Procedure
- 181.4.13 RESET_PACKAGE Procedure
- 181.4.14 SESSION_IS_ROLE_ENABLED Function
- 181.4.15 SESSION_TRACE_DISABLE Procedure
- 181.4.16 SESSION _TRACE_ENABLE Procedure
- 181.4.17 SET_CONTEXT Procedure
- 181.4.18 SET_EDITION_DEFERRED Procedure
- 181.4.19 SET_IDENTIFIER Procedure
- 181.4.20 SET_NLS Procedure
- 181.4.21 SET_ROLE Procedure
- 181.4.22 SET_SQL_TRACE Procedure
- 181.4.23 SLEEP Procedure
- 181.4.24 SWITCH_CURRENT_CONSUMER_GROUP Procedure
- 181.4.25 UNIQUE_SESSION_ID Function
- 181.4.26 USE_DEFAULT_EDITION_ALWAYS procedure
- 181.4.27 USE_DEFAULT_EDITION_DEFERRED procedure
 
 
- 182 DBMS_SFW_ACL_ADMIN
- 183 DBMS_SHARED_POOL
- 184 DBMS_SHARDING_DIRECTORY
- 
               
               
                  
                  185
                      DBMS_SODA
               
                  
               
               
               - 185.1 DBMS_SODA Security Model
- 
                     
                     
                        
                        185.2
                            Summary of DBMS_SODA Subprograms
                     
                        
                     
                     
                     - 185.2.1 CREATE_COLLECTION Function
- 185.2.2 DROP_COLLECTION Function
- 185.2.3 GET_AS_OF_SCN Function
- 185.2.4 GET_AS_OF_TIMESTAMP Function
- 185.2.5 GET_DEFAULT_METADATA_AS_CLOB Function
- 185.2.6 GET_DEFAULT_METADATA_AS_VARCHAR2 Function
- 185.2.7 LIST_COLLECTION_NAMES Function
- 185.2.8 OPEN_COLLECTION Function
 
- 
                     
                     
                        
                        185.3
                            Summary of SODA Online Redefinition
                        Subprograms
                     
                        
                     
                     
                     - 185.3.1 ABORT_REDEF_COLLECTION Procedure
- 185.3.2 CAN_REDEF_COLLECTION Procedure
- 185.3.3 COPY_COLLECTION_DEPENDENTS Procedure
- 185.3.4 CREATE_INTERIM_COLLECTION Procedure
- 185.3.5 FINISH_REDEF_COLLECTION Procedure
- 185.3.6 START_REDEF_COLLECTION Procedure
- 185.3.7 SYNC_INTERIM_COLLETION Procedure
- 185.3.8 TO_UUID Function
 
 
- 
               
               
                  
                  186
                       DBMS_SPACE
               
                  
               
               
               - 186.1 DBMS_SPACE Security Model
- 186.2 DBMS_SPACE Data Structures
- 
                     
                     
                        
                        186.3
                            Summary of DBMS_SPACE Subprograms
                     
                        
                     
                     
                     - 186.3.1 DBMS_SPACE ASA_RECOMMENDATIONS Function
- 186.3.2 CREATE_INDEX_COST Procedure
- 186.3.3 CREATE_TABLE_COST Procedures
- 186.3.4 FREE_BLOCKS Procedure
- 186.3.5 ISDATAFILEDROPPABLE_NAME Procedure
- 186.3.6 OBJECT_DEPENDENT_SEGMENTS Function
- 186.3.7 OBJECT_GROWTH_TREND Function
- 186.3.8 SHRINK_TABLESPACE Procedure
- 186.3.9 SPACE_USAGE Procedures
- 186.3.10 UNUSED_SPACE Procedure
 
 
- 
               
               
                  
                  187
                       DBMS_SPACE_ADMIN
               
                  
               
               
               - 187.1 DBMS_SPACE_ADMIN Security Model
- 187.2 DBMS_SPACE_ADMIN Constants
- 187.3 DBMS_SPACE_ADMIN Operational Notes
- 
                     
                     
                        
                        187.4
                            Summary of DBMS_SPACE_ADMIN Subprograms
                     
                        
                     
                     
                     - 187.4.1 ASSM_SEGMENT_VERIFY Procedure
- 187.4.2 ASSM_TABLESPACE_VERIFY Procedure
- 187.4.3 DROP_EMPTY_SEGMENTS Procedure
- 187.4.4 GET_SEGADV_ATTRIB Procedure
- 187.4.5 MATERIALIZE_DEFERRED_SEGMENTS Procedure
- 187.4.6 SEGMENT_CORRUPT Procedure
- 187.4.7 SEGMENT_DROP_CORRUPT Procedure
- 187.4.8 SEGMENT_DUMP Procedure
- 187.4.9 SEGMENT_VERIFY Procedure
- 187.4.10 SET_SEGADV_ATTRIB Procedure
- 187.4.11 TABLESPACE_FIX_BITMAPS Procedure
- 187.4.12 TABLESPACE_FIX_SEGMENT_STATES Procedure
- 187.4.13 TABLESPACE_MIGRATE_FROM_LOCAL Procedure
- 187.4.14 TABLESPACE_MIGRATE_TO_LOCAL Procedure
- 187.4.15 TABLESPACE_REBUILD_BITMAPS Procedure
- 187.4.16 TABLESPACE_REBUILD_QUOTAS Procedure
- 187.4.17 TABLESPACE_RELOCATE_BITMAPS Procedure
- 187.4.18 TABLESPACE_VERIFY Procedure
 
 
- 
               
               
                  
                  188
                       DBMS_SPD 
               
                  
               
               
               - 188.1 DBMS_SPD Overview
- 188.2 DBMS_SPD Security Model
- 188.3 DBMS_SPD Views
- 
                     
                     
                        
                        188.4
                            Summary of DBMS_SPD Subprograms
                     
                        
                     
                     
                     - 188.4.1 ALTER_SQL_PLAN_DIRECTIVE Procedure
- 188.4.2 CREATE_STGTAB_DIRECTIVE Procedure
- 188.4.3 DROP_SQL_PLAN_DIRECTIVE Procedure
- 188.4.4 FLUSH_SQL_PLAN_DIRECTIVE Procedure
- 188.4.5 GET_PREFS Function
- 188.4.6 PACK_STGTAB_DIRECTIVE Function
- 188.4.7 SET_PREFS Procedure
- 188.4.8 UNPACK_STGTAB_DIRECTIVE Function
 
 
- 
               
               
                  
                  189
                      DBMS_SPM 
               
                  
               
               
               - 189.1 DBMS_SPM Overview
- 189.2 DBMS_SPM Security Model
- 189.3 DBMS_SPM Constants
- 189.4 DBMS_SPM Examples
- 189.5 DBMS_SPM Data Structures
- 
                     
                     
                        
                        189.6
                            Summary of DBMS_SPM Subprograms
                     
                        
                     
                     
                     - 189.6.1 ACCEPT_SQL_PLAN_BASELINE Procedure
- 189.6.2 ADD_VERIFIED_SQL_PLAN_BASELINE Function
- 189.6.3 ALTER_SQL_PLAN_BASELINE Function
- 189.6.4 CANCEL_EVOLVE_TASK Procedure
- 189.6.5 CONFIGURE Procedure
- 189.6.6 CREATE_EVOLVE_TASK Function
- 189.6.7 CREATE_STGTAB_BASELINE Procedure
- 189.6.8 DROP_EVOLVE_TASK Procedure
- 189.6.9 DROP_MIGRATED_STORED_OUTLINE Function
- 189.6.10 DROP_SQL_PLAN_BASELINE Function
- 189.6.11 EVOLVE_SQL_PLAN_BASELINE Function
- 189.6.12 EXECUTE_EVOLVE_TASK Function
- 189.6.13 INTERRUPT_EVOLVE_TASK Procedure
- 189.6.14 LOAD_PLANS_FROM_AWR Function
- 189.6.15 LOAD_PLANS_FROM_CURSOR_CACHE Functions
- 189.6.16 LOAD_PLANS_FROM_SQLSET Function
- 189.6.17 MIGRATE_STORED_OUTLINE Functions
- 189.6.18 PACK_STGTAB_BASELINE Function
- 189.6.19 RESET_EVOLVE_TASK Procedure
- 189.6.20 RESUME_EVOLVE_TASK Procedure
- 189.6.21 REPORT_AUTO_EVOLVE_TASK Function
- 189.6.22 REPORT_EVOLVE_TASK Function
- 189.6.23 SET_EVOLVE_TASK_PARAMETER Procedure
- 189.6.24 UNPACK_STGTAB_BASELINE Function
 
 
- 
               
               
                  
                  190
                       DBMS_SQL
               
                  
               
               
               - 190.1 DBMS_SQL Overview
- 190.2 DBMS_SQL Security Model
- 190.3 DBMS_SQL Constants
- 190.4 DBMS_SQL Operational Notes
- 
                     
                     
                        
                        190.5
                            DBMS_SQL Execution Flow
                     
                        
                     
                     
                     - 190.5.1 OPEN_CURSOR
- 190.5.2 PARSE
- 190.5.3 BIND_VARIABLE, BIND_VARIABLE_PKG or BIND_ARRAY
- 190.5.4 DEFINE_COLUMN, DEFINE_COLUMN_LONG, or DEFINE_ARRAY
- 190.5.5 EXECUTE
- 190.5.6 FETCH_ROWS or EXECUTE_AND_FETCH
- 190.5.7 VARIABLE_VALUE, VARIABLE_VALUE_PKG, COLUMN_VALUE, or COLUMN_VALUE_LONG
- 190.5.8 CLOSE_CURSOR
 
- 190.6 DBMS_SQL Exceptions
- 190.7 DBMS_SQL Examples
- 
                     
                     
                        
                        190.8
                            DBMS_SQL Data Structures
                     
                        
                     
                     
                     - 190.8.1 DBMS_SQL DESC_REC Record Type
- 190.8.2 DBMS_SQL DESC_REC2 Record Type
- 190.8.3 DBMS_SQL DESC_REC3 Record Type
- 190.8.4 DBMS_SQL DESC_REC4 Record Type
- 190.8.5 DBMS_SQL BFILE_TABLE Table Type
- 190.8.6 DBMS_SQL BINARY_DOUBLE_TABLE Table Type
- 190.8.7 DBMS_SQL BINARY_FLOAT_TABLE Table Type
- 190.8.8 DBMS_SQL BLOB_TABLE Table Type
- 190.8.9 DBMS_SQL BOOLEAN_TABLE Table Type
- 190.8.10 DBMS_SQL CLOB_TABLE Table Type
- 190.8.11 DBMS_SQL DATE_TABLE Table Type
- 190.8.12 DBMS_SQL DESC_TAB Table Type
- 190.8.13 DBMS_SQL DESC_TAB2 Table Type
- 190.8.14 DBMS_SQL DESC_TAB3 Table Type
- 190.8.15 DBMS_SQL DESC_TAB4 Table Type
- 190.8.16 DBMS_SQL INTERVAL_DAY_TO_SECOND_TABLE Table Type
- 190.8.17 DBMS_SQL INTERVAL_YEAR_TO_MONTH_TABLE Table Type
- 190.8.18 DBMS_SQL JSON_TABLE Table Type
- 190.8.19 DBMS_SQL NUMBER_TABLE Table Type
- 190.8.20 DBMS_SQL TIME_TABLE Table Type
- 190.8.21 DBMS_SQL TIME_WITH_TIME_ZONE_TABLE Table Type
- 190.8.22 DBMS_SQL TIMESTAMP_TABLE Table Type
- 190.8.23 DBMS_SQL TIMESTAMP_WITH_LTZ_TABLE Table Type
- 190.8.24 DBMS_SQL TIMESTAMP_WITH_TIME_ZONE_TABLE Table Type
- 190.8.25 DBMS_SQL UROWID_TABLE Table Type
- 190.8.26 DBMS_SQL VARCHAR2_TABLE Table Type
- 190.8.27 DBMS_SQL VARCHAR2A Table Type
- 190.8.28 DBMS_SQL VARCHAR2S Table Type
- 190.8.29 DBMS_SQL VECTOR Table Type
 
- 
                     
                     
                        
                        190.9
                            Summary of DBMS_SQL Subprograms
                     
                        
                     
                     
                     - 190.9.1 BIND_ARRAY Procedures
- 190.9.2 BIND_VARIABLE Procedures
- 190.9.3 BIND_VARIABLE_PKG Procedure
- 190.9.4 CLOSE_CURSOR Procedure
- 190.9.5 COLUMN_VALUE Procedure
- 190.9.6 COLUMN_VALUE_LONG Procedure
- 190.9.7 DEFINE_ARRAY Procedure
- 190.9.8 DEFINE_COLUMN Procedures
- 190.9.9 DEFINE_COLUMN_CHAR Procedure
- 190.9.10 DEFINE_COLUMN_LONG Procedure
- 190.9.11 DEFINE_COLUMN_RAW Procedure
- 190.9.12 DEFINE_COLUMN_ROWID Procedure
- 190.9.13 DESCRIBE_COLUMNS Procedure
- 190.9.14 DESCRIBE_COLUMNS2 Procedure
- 190.9.15 DESCRIBE_COLUMNS3 Procedure
- 190.9.16 EXECUTE Function
- 190.9.17 EXECUTE_AND_FETCH Function
- 190.9.18 FETCH_ROWS Function
- 190.9.19 GET_NEXT_RESULT Procedures
- 190.9.20 IS_OPEN Function
- 190.9.21 LAST_ERROR_POSITION Function
- 190.9.22 LAST_ROW_COUNT Function
- 190.9.23 LAST_ROW_ID Function
- 190.9.24 LAST_SQL_FUNCTION_CODE Function
- 190.9.25 OPEN_CURSOR Functions
- 190.9.26 PARSE Procedures
- 190.9.27 RETURN_RESULT Procedures
- 190.9.28 TO_CURSOR_NUMBER Function
- 190.9.29 TO_REFCURSOR Function
- 190.9.30 VARIABLE_VALUE Procedures
- 190.9.31 VARIABLE_VALUE_PKG Procedure
 
 
- 
               
               
                  
                  191
                      DBMS_SQL_FIREWALL
               
                  
               
               
               - 191.1 DBMS_SQL_FIREWALL Overview
- 191.2 DBMS_SQL_FIREWALL Security Model
- 191.3 DBMS_SQL_FIREWALL Constants
- 
                     
                     
                        
                        191.4
                            Summary of DBMS_SQL_FIREWALL Subprograms
                     
                        
                     
                     
                     - 191.4.1 ADD_ALLOWED_CONTEXT Procedure
- 191.4.2 APPEND_ALLOW_LIST Procedure
- 191.4.3 APPEND_ALLOW_LIST_SINGLE_SQL Procedure
- 191.4.4 CREATE_CAPTURE Procedure
- 191.4.5 DELETE_ALLOWED_CONTEXT Procedure
- 191.4.6 DELETE_ALLOWED_SQL Procedure
- 191.4.7 DISABLE Procedure
- 191.4.8 DISABLE_ALLOW_LIST Procedure
- 191.4.9 DROP_ALLOW_LIST Procedure
- 191.4.10 DROP_CAPTURE Procedure
- 191.4.11 ENABLE Procedure
- 191.4.12 ENABLE_ALLOW_LIST Procedure
- 191.4.13 EXCLUDE Procedure
- 191.4.14 EXPORT_ALLOW_LIST Procedure
- 191.4.15 FLUSH_LOGS Procedure
- 191.4.16 GENERATE_ALLOW_LIST Procedure
- 191.4.17 IMPORT_ALLOW_LIST Procedure
- 191.4.18 INCLUDE Procedure
- 191.4.19 PURGE_LOG Procedure
- 191.4.20 START_CAPTURE Procedure
- 191.4.21 STOP_CAPTURE Procedure
- 191.4.22 UPDATE_ALLOW_LIST_ENFORCEMENT Procedure
 
 
- 192 DBMS_SQL_MONITOR
- 
               
               
                  
                  193
                       DBMS_SQL_TRANSLATOR 
               
                  
               
               
               - 193.1 DBMS_SQL_TRANSLATOR Security Model
- 193.2 DBMS_SQL_TRANSLATOR Constants
- 193.3 DBMS_SQL_TRANSLATOR Operational Notes
- 193.4 DBMS_SQL_TRANSLATOR Exceptions
- 193.5 DBMS_SQL_TRANSLATOR Examples
- 
                     
                     
                        
                        193.6
                            Summary of DBMS_SQL_TRANSLATOR Subprograms
                     
                        
                     
                     
                     - 193.6.1 CREATE_PROFILE Procedure
- 193.6.2 DEREGISTER_SQL_TRANSLATION Procedure
- 193.6.3 DEREGISTER_ERROR_TRANSLATION Procedure
- 193.6.4 DROP_PROFILE Procedure
- 193.6.5 ENABLE_ERROR_TRANSLATION Procedure
- 193.6.6 ENABLE_SQL_TRANSLATION Procedure
- 193.6.7 EXPORT_PROFILE Procedure
- 193.6.8 IMPORT_PROFILE Procedure
- 193.6.9 REGISTER_ERROR_TRANSLATION Procedure
- 193.6.10 REGISTER_SQL_TRANSLATION Procedure
- 193.6.11 SET_ATTRIBUTE Procedure
- 193.6.12 SQL_HASH Function
- 193.6.13 SQL_ID Function
- 193.6.14 TRANSLATE_ERROR Procedure
- 193.6.15 TRANSLATE_SQL Procedure
 
 
- 
               
               
                  
                  194
                       DBMS_SQLDIAG
               
                  
               
               
               - 194.1 DBMS_SQLDIAG Overview
- 194.2 DBMS_SQLDIAG Security Model
- 194.3 DBMS_SQLDIAG Constants
- 
                     
                     
                        
                        194.4
                            Summary of DBMS_SQLDIAG Subprograms
                     
                        
                     
                     
                     - 194.4.1 ACCEPT_SQL_PATCH Function & Procedure
- 194.4.2 ALTER_SQL_PATCH Procedure
- 194.4.3 CANCEL_DIAGNOSIS_TASK Procedure
- 194.4.4 CREATE_DIAGNOSIS_TASK Functions
- 194.4.5 CREATE_SQL_PATCH Function
- 194.4.6 CREATE_STGTAB_SQLPATCH Procedure
- 194.4.7 DROP_DIAGNOSIS_TASK Procedure
- 194.4.8 DROP_SQL_PATCH Procedure
- 194.4.9 EXECUTE_DIAGNOSIS_TASK Procedure
- 194.4.10 EXPLAIN_SQL_TESTCASE Function
- 194.4.11 EXPORT_SQL_TESTCASE Procedures
- 194.4.12 EXPORT_SQL_TESTCASE_DIR_BY_INC Function
- 194.4.13 EXPORT_SQL_TESTCASE_DIR_BY_TXT Function
- 194.4.14 GET_FIX_CONTROL Function
- 194.4.15 GET_SQL Function
- 194.4.16 IMPORT_SQL_TESTCASE Procedures
- 194.4.17 INCIDENTID_2_SQL Procedure
- 194.4.18 INTERRUPT_DIAGNOSIS_TASK Procedure
- 194.4.19 LOAD_SQLSET_FROM_TCB Function
- 194.4.20 PACK_STGTAB_SQLPATCH Procedure
- 194.4.21 REPLAY_SQL_TESTCASE Function
- 194.4.22 REPORT_SQL Function
- 194.4.23 REPORT_DIAGNOSIS_TASK Function
- 194.4.24 RESET_DIAGNOSIS_TASK Procedure
- 194.4.25 RESUME_DIAGNOSIS_TASK Procedure
- 194.4.26 SET_DIAGNOSIS_TASK_PARAMETER Procedure
- 194.4.27 SQL_DIAGNOSE_AND_REPAIR Function
- 194.4.28 UNPACK_STGTAB_SQLPATCH Procedure
 
 
- 
               
               
                  
                  195
                       DBMS_SQLPA
               
                  
               
               
               - 195.1 DBMS_SQLPA Overview
- 195.2 DBMS_SQLPA Security Model
- 
                     
                     
                        
                        195.3
                            Summary of DBMS_SQLPA Subprograms
                     
                        
                     
                     
                     - 195.3.1 CANCEL_ANALYSIS_TASK Procedure
- 195.3.2 CREATE_ANALYSIS_TASK Functions
- 195.3.3 DROP_ANALYSIS_TASK Procedure
- 195.3.4 EXECUTE_ANALYSIS_TASK Function & Procedure
- 195.3.5 INTERRUPT_ANALYSIS_TASK Procedure
- 195.3.6 REPORT_ANALYSIS_TASK Function
- 195.3.7 RESET_ANALYSIS_TASK Procedure
- 195.3.8 RESUME_ANALYSIS_TASK Procedure
- 195.3.9 SET_ANALYSIS_TASK_PARAMETER Procedures
- 195.3.10 SET_ANALYSIS_DEFAULT_PARAMETER Procedures
 
 
- 
               
               
                  
                  196
                      DBMS_SQLQ
               
                  
               
               
               - 196.1 DBMS_SQLQ Overview
- 
                     
                     
                        
                        196.2
                            Summary of DBMS_SQLQ Subprograms
                     
                        
                     
                     
                     - 196.2.1 ALTER_QUARANTINE Procedure
- 196.2.2 CREATE_QUARANTINE_BY_SQL_ID Function
- 196.2.3 CREATE_QUARANTINE_BY_SQL_TEXT Function
- 196.2.4 CREATE_STGTAB_QUARANTINE Procedure
- 196.2.5 DROP_QUARANTINE Procedure
- 196.2.6 GET_PARAM_VALUE_QUARANTINE Function
- 196.2.7 PACK_STGTAB_QUARANTINE Function
- 196.2.8 UNPACK_STGTAB_QUARANTINE Function
 
 
- 
               
               
                  
                  197
                      DBMS_SQLSET
               
                  
               
               
               - 197.1 DBMS_SQLSET Overview
- 197.2 DBMS_SQLSET Security Model
- 197.3 DBMS_SQLSET Data Structures
- 
                     
                     
                        
                        197.4
                            Summary of DBMS_SQLSET Subprograms
                     
                        
                     
                     
                     - 197.4.1 ADD_REFERENCE Function
- 197.4.2 CAPTURE_CURSOR_CACHE Procedure
- 197.4.3 CREATE_SQLSET Procedure and Function
- 197.4.4 CREATE_STGTAB Procedure
- 197.4.5 DELETE_SQLSET Procedure
- 197.4.6 DROP_SQLSET Procedure
- 197.4.7 LOAD_SQLSET Procedure
- 197.4.8 PACK_STGTAB Procedure
- 197.4.9 REMAP_STGTAB Procedure
- 197.4.10 REMOVE_REFERENCE Procedure
- 197.4.11 SELECT_CURSOR_CACHE Function
- 197.4.12 SELECT_SQL_TRACE Function
- 197.4.13 SELECT_SQLPA_TASK Function
- 197.4.14 SELECT_SQLSET Function
- 197.4.15 SELECT_WORKLOAD_REPOSITORY Function
- 197.4.16 UNPACK_STGTAB Procedure
- 197.4.17 UPDATE_SQLSET Procedures
 
 
- 
               
               
                  
                  198
                      DBMS_SQLTUNE
               
                  
               
               
               - 198.1 DBMS_SQLTUNE Overview
- 198.2 DBMS_SQLTUNE Security Model
- 198.3 DBMS_SQLTUNE Data Structures
- 198.4 DBMS_SQLTUNE Subprogram Groups
- 
                     
                     
                        
                        198.5
                            Summary of DBMS_SQLTUNE Subprograms
                     
                        
                     
                     
                     - 198.5.1 ACCEPT_ALL_SQL_PROFILES Procedure
- 198.5.2 ACCEPT_SQL_PROFILE Procedure and Function
- 198.5.3 ADD_SQLSET_REFERENCE Function
- 198.5.4 ALTER_SQL_PROFILE Procedure
- 198.5.5 CANCEL_TUNING_TASK Procedure
- 198.5.6 CAPTURE_CURSOR_CACHE_SQLSET Procedure
- 198.5.7 CREATE_SQL_PLAN_BASELINE Procedure
- 198.5.8 CREATE_SQLSET Procedure and Function
- 198.5.9 CREATE_STGTAB_SQLPROF Procedure
- 198.5.10 CREATE_STGTAB_SQLSET Procedure
- 198.5.11 CREATE_TUNING_TASK Functions
- 198.5.12 DELETE_SQLSET Procedure
- 198.5.13 DROP_SQL_PROFILE Procedure
- 198.5.14 DROP_SQLSET Procedure
- 198.5.15 DROP_TUNING_TASK Procedure
- 198.5.16 EXECUTE_TUNING_TASK Function and Procedure
- 198.5.17 IMPLEMENT_TUNING_TASK Procedure
- 198.5.18 INTERRUPT_TUNING_TASK Procedure
- 198.5.19 LOAD_SQLSET Procedure
- 198.5.20 PACK_STGTAB_SQLPROF Procedure
- 198.5.21 PACK_STGTAB_SQLSET Procedure
- 198.5.22 REMAP_STGTAB_SQLPROF Procedure
- 198.5.23 REMAP_STGTAB_SQLSET Procedure
- 198.5.24 REMOVE_SQLSET_REFERENCE Procedure
- 198.5.25 REPORT_AUTO_TUNING_TASK Function
- 198.5.26 REPORT_SQL_DETAIL Function
- 198.5.27 REPORT_SQL_MONITOR Function
- 198.5.28 REPORT_SQL_MONITOR_LIST Function
- 198.5.29 REPORT_TUNING_TASK Function
- 198.5.30 REPORT_TUNING_TASK_XML Function
- 198.5.31 RESET_TUNING_TASK Procedure
- 198.5.32 RESUME_TUNING_TASK Procedure
- 198.5.33 SCHEDULE_TUNING_TASK Function
- 198.5.34 SCRIPT_TUNING_TASK Function
- 198.5.35 SELECT_CURSOR_CACHE Function
- 198.5.36 SELECT_SQL_TRACE Function
- 198.5.37 SELECT_SQLPA_TASK Function
- 198.5.38 SELECT_SQLSET Function
- 198.5.39 SELECT_WORKLOAD_REPOSITORY Function
- 198.5.40 SET_TUNING_TASK_PARAMETER Procedures
- 198.5.41 SQLTEXT_TO_SIGNATURE Function
- 198.5.42 UNPACK_STGTAB_SQLPROF Procedure
- 198.5.43 UNPACK_STGTAB_SQLSET Procedure
- 198.5.44 UPDATE_SQLSET Procedures
 
 
- 199 DBMS_STAT_FUNCS
- 
               
               
                  
                  200
                       DBMS_STATS
               
                  
               
               
               - 200.1 DBMS_STATS Overview
- 200.2 DBMS_STATS Deprecated Subprograms
- 200.3 DBMS_STATS Types
- 200.4 DBMS_STATS Constants
- 200.5 DBMS_STATS Operational Notes
- 200.6 DBMS_STATS Data Structures
- 
                     
                     
                        
                        200.7
                            Summary of DBMS_STATS Subprograms
                     
                        
                     
                     
                     - 200.7.1 ALTER_STATS_HISTORY_RETENTION Procedure
- 200.7.2 CANCEL_ADVISOR_TASK Procedure
- 200.7.3 CONFIGURE_ADVISOR_FILTER Function
- 200.7.4 CONFIGURE_ADVISOR_OBJ_FILTER Function
- 200.7.5 CONFIGURE_ADVISOR_OPR_FILTER Functions
- 200.7.6 CONFIGURE_ADVISOR_RULE_FILTER Function
- 200.7.7 CONVERT_RAW_VALUE Procedures
- 200.7.8 CONVERT_RAW_VALUE_NVARCHAR Procedure
- 200.7.9 CONVERT_RAW_VALUE_ROWID Procedure
- 200.7.10 COPY_TABLE_STATS Procedure
- 200.7.11 CREATE_ADVISOR_TASK Function
- 200.7.12 CREATE_EXTENDED_STATS Function
- 200.7.13 CREATE_STAT_TABLE Procedure
- 200.7.14 DELETE_COLUMN_STATS Procedure
- 200.7.15 DELETE_DATABASE_PREFS Procedure
- 200.7.16 DELETE_DATABASE_STATS Procedure
- 200.7.17 DELETE_DICTIONARY_STATS Procedure
- 200.7.18 DELETE_FIXED_OBJECTS_STATS Procedure
- 200.7.19 DELETE_INDEX_STATS Procedure
- 200.7.20 DELETE_PENDING_STATS Procedure
- 200.7.21 DELETE_PLSQL_PREFS Procedure
- 200.7.22 DELETE_PROCESSING_RATE Procedure
- 200.7.23 DELETE_SCHEMA_PREFS Procedure
- 200.7.24 DELETE_SCHEMA_STATS Procedure
- 200.7.25 DELETE_SYSTEM_STATS Procedure
- 200.7.26 DELETE_TABLE_PREFS Procedure
- 200.7.27 DELETE_TABLE_STATS Procedure
- 200.7.28 DIFF_TABLE_STATS_IN_HISTORY Function
- 200.7.29 DIFF_TABLE_STATS_IN_PENDING Function
- 200.7.30 DIFF_TABLE_STATS_IN_STATTAB Function
- 200.7.31 DROP_ADVISOR_TASK Procedure
- 200.7.32 DROP_EXTENDED_STATS Procedure
- 200.7.33 DROP_STAT_TABLE Procedure
- 200.7.34 EXECUTE_ADVISOR_TASK Function
- 200.7.35 EXPORT_COLUMN_STATS Procedure
- 200.7.36 EXPORT_DATABASE_PREFS Procedure
- 200.7.37 EXPORT_DATABASE_STATS Procedure
- 200.7.38 EXPORT_DICTIONARY_STATS Procedure
- 200.7.39 EXPORT_FIXED_OBJECTS_STATS Procedure
- 200.7.40 EXPORT_INDEX_STATS Procedure
- 200.7.41 EXPORT_PENDING_STATS Procedure
- 200.7.42 EXPORT_SCHEMA_PREFS Procedure
- 200.7.43 EXPORT_SCHEMA_STATS Procedure
- 200.7.44 EXPORT_SYSTEM_STATS Procedure
- 200.7.45 EXPORT_TABLE_PREFS Procedure
- 200.7.46 EXPORT_TABLE_STATS Procedure
- 200.7.47 FLUSH_DATABASE_MONITORING_INFO Procedure
- 200.7.48 GATHER_DATABASE_STATS Procedures
- 200.7.49 GATHER_DICTIONARY_STATS Procedure
- 200.7.50 GATHER_FIXED_OBJECTS_STATS Procedure
- 200.7.51 GATHER_INDEX_STATS Procedure
- 200.7.52 GATHER_PROCESSING_RATE Procedure
- 200.7.53 GATHER_SCHEMA_STATS Procedures
- 200.7.54 GATHER_SYSTEM_STATS Procedure
- 200.7.55 GATHER_TABLE_STATS Procedure
- 200.7.56 GENERATE_STATS Procedure
- 200.7.57 GET_ADVISOR_OPR_FILTER Procedure
- 200.7.58 GET_ADVISOR_RECS Function
- 200.7.59 GET_COLUMN_STATS Procedures
- 200.7.60 GET_INDEX_STATS Procedures
- 200.7.61 GET_PARAM Function
- 200.7.62 GET_PLSQL_PREFS Procedure
- 200.7.63 GET_PREFS Function
- 200.7.64 GET_STATS_HISTORY_AVAILABILITY Function
- 200.7.65 GET_STATS_HISTORY_RETENTION Function
- 200.7.66 GET_SYSTEM_STATS Procedure
- 200.7.67 GET_TABLE_STATS Procedure
- 200.7.68 IMPLEMENT_ADVISOR_TASK Function
- 200.7.69 IMPORT_COLUMN_STATS Procedure
- 200.7.70 IMPORT_DATABASE_PREFS Procedure
- 200.7.71 IMPORT_DATABASE_STATS Procedure
- 200.7.72 IMPORT_DICTIONARY_STATS Procedure
- 200.7.73 IMPORT_FIXED_OBJECTS_STATS Procedure
- 200.7.74 IMPORT_INDEX_STATS Procedure
- 200.7.75 IMPORT_SCHEMA_PREFS Procedure
- 200.7.76 IMPORT_SCHEMA_STATS Procedure
- 200.7.77 IMPORT_SYSTEM_STATS Procedure
- 200.7.78 IMPORT_TABLE_PREFS Procedure
- 200.7.79 IMPORT_TABLE_STATS Procedure
- 200.7.80 INTERRUPT_ADVISOR_TASK Procedure
- 200.7.81 LOCK_PARTITION_STATS Procedure
- 200.7.82 LOCK_SCHEMA_STATS Procedure
- 200.7.83 LOCK_TABLE_STATS Procedure
- 200.7.84 MERGE_COL_USAGE Procedure
- 200.7.85 PREPARE_COLUMN_VALUES Procedures
- 200.7.86 PREPARE_COLUMN_VALUES_NVARCHAR Procedure
- 200.7.87 PREPARE_COLUMN_VALUES_ROWID Procedure
- 200.7.88 PUBLISH_PENDING_STATS Procedure
- 200.7.89 PURGE_STATS Procedure
- 200.7.90 REMAP_STAT_TABLE Procedure
- 200.7.91 REPORT_ADVISOR_TASK Function
- 200.7.92 REPORT_COL_USAGE Function
- 200.7.93 REPORT_GATHER_AUTO_STATS Function
- 200.7.94 REPORT_GATHER_DATABASE_STATS Functions
- 200.7.95 REPORT_GATHER_DICTIONARY_STATS Functions
- 200.7.96 REPORT_GATHER_FIXED_OBJ_STATS Function
- 200.7.97 REPORT_GATHER_SCHEMA_STATS Functions
- 200.7.98 REPORT_GATHER_TABLE_STATS Function
- 200.7.99 REPORT_SINGLE_STATS_OPERATION Function
- 200.7.100 REPORT_STATS_OPERATIONS Function
- 200.7.101 RESET_ADVISOR_TASK Procedure
- 200.7.102 RESET_COL_USAGE Procedure
- 200.7.103 RESET_GLOBAL_PLSQL_PREFS_DEF Procedure
- 200.7.104 RESET_PARAM_DEFAULTS Procedure
- 200.7.105 RESTORE_DATABASE_STATS Procedure
- 200.7.106 RESTORE_DICTIONARY_STATS Procedure
- 200.7.107 RESTORE_FIXED_OBJECTS_STATS Procedure
- 200.7.108 RESTORE_SCHEMA_STATS Procedure
- 200.7.109 RESTORE_SYSTEM_STATS Procedure
- 200.7.110 RESTORE_TABLE_STATS Procedure
- 200.7.111 RESUME_ADVISOR_TASK Procedure
- 200.7.112 SCRIPT_ADVISOR_TASK Function
- 200.7.113 SEED_COL_USAGE Procedure
- 200.7.114 SET_ADVISOR_TASK_PARAMETER Procedure
- 200.7.115 SET_COLUMN_STATS Procedures
- 200.7.116 SET_DATABASE_PREFS Procedure
- 200.7.117 SET_GLOBAL_PLSQL_PREFS Procedure
- 200.7.118 SET_GLOBAL_PREFS Procedure
- 200.7.119 SET_INDEX_STATS Procedures
- 200.7.120 SET_PARAM Procedure
- 200.7.121 SET_PLSQL_PREFS Procedure
- 200.7.122 SET_PROCESSING_RATE Procedure
- 200.7.123 SET_SCHEMA_PREFS Procedure
- 200.7.124 SET_SYSTEM_STATS Procedure
- 200.7.125 SET_TABLE_PREFS Procedure
- 200.7.126 SET_TABLE_STATS Procedure
- 200.7.127 SHOW_EXTENDED_STATS_NAME Function
- 200.7.128 TRANSFER_STATS Procedure
- 200.7.129 UNLOCK_PARTITION_STATS Procedure
- 200.7.130 UNLOCK_SCHEMA_STATS Procedure
- 200.7.131 UNLOCK_TABLE_STATS Procedure
- 200.7.132 UPGRADE_STAT_TABLE Procedure
 
 
- 201 DBMS_STORAGE_MAP
- 
               
               
                  
                  202
                       DBMS_SYNC_REFRESH
               
                  
               
               
               - 202.1 DBMS_SYNC_REFRESH Overview
- 202.2 DBMS_SYNC_REFRESH Security Model
- 
                     
                     
                        
                        202.3
                            Summary of DBMS_SYNC_REFRESH Subprograms
                     
                        
                     
                     
                     - 202.3.1 ABORT_REFRESH Procedure
- 202.3.2 ALTER_REFRESH_STATS_RETENTION Procedure
- 202.3.3 CAN_SYNCREF_TABLE Procedure
- 202.3.4 EXECUTE_REFRESH Procedure
- 202.3.5 GET_ALL_GROUP_IDS Function
- 202.3.6 GET_GROUP_ID Function
- 202.3.7 GET_GROUP_ID_LIST Function
- 202.3.8 PREPARE_REFRESH Procedure
- 202.3.9 PREPARE_STAGING_LOG Procedure
- 202.3.10 PURGE_REFRESH_STATS Procedure
- 202.3.11 REGISTER_MVIEWS
- 202.3.12 REGISTER_PARTITION_OPERATION Procedure
- 202.3.13 UNREGISTER_MVIEWS
- 202.3.14 UNREGISTER_PARTITION_OPERATION Procedure
 
 
- 203 DBMS_TABLE_DATA
- 204 DBMS_TDB
- 205 DBMS_TELEMETRY_ADMIN
- 206 DBMS_TELEMETRY_INGEST
- 207 DBMS_TELEMETRY_QUERY
- 208 DBMS_TELEMETRY_WORKSPACE
- 
               
               
                  
                  209
                      DBMS_TF
               
                  
               
               
               - 209.1 DBMS_TF Overview
- 209.2 DBMS_TF Security Model
- 209.3 DBMS_TF Constants
- 209.4 DBMS_TF Operational Notes
- 209.5 DBMS_TF Execution Flow
- 209.6 DBMS_TF Restrictions
- 209.7 DBMS_TF Examples
- 
                     
                     
                        
                        209.8
                            DBMS_TF Data Structures
                     
                        
                     
                     
                     - 209.8.1 Supported Types Collections
- 209.8.2 COLUMN_DATA_T Record Type
- 209.8.3 COLUMN_METADATA_T Record Type
- 209.8.4 COLUMN_T Record Type
- 209.8.5 DESCRIBE_T Record Type
- 209.8.6 ENV_T Record Type
- 209.8.7 PARALLEL_ENV_T Record Type
- 209.8.8 TABLE_T Record Type
- 209.8.9 COLUMNS_NEW_T Table Type
- 209.8.10 COLUMNS_T Table Type
- 209.8.11 COLUMNS_WITH_TYPE_T Table Type
- 209.8.12 TABLE_COLUMNS_T Table Type
- 209.8.13 ROW_SET_T Table Type
- 209.8.14 XID_T Subtype
 
- 
                     
                     
                        
                        209.9
                            Summary of DBMS_TF Subprograms
                     
                        
                     
                     
                     - 209.9.1 COLUMN_TYPE_NAME Function
- 209.9.2 COL_TO_CHAR Function
- 209.9.3 CSTORE_EXISTS Function
- 209.9.4 CSTORE_GET Procedure
- 209.9.5 GET_COL Procedure
- 209.9.6 GET_ENV Function
- 209.9.7 GET_ROW_SET Procedure
- 209.9.8 GET_XID Function
- 209.9.9 PUT_COL Procedure
- 209.9.10 PUT_ROW_SET Procedure
- 209.9.11 ROW_REPLICATION Procedure
- 209.9.12 ROW_TO_CHAR Function
- 209.9.13 SUPPORTED_TYPE Function
- 209.9.14 TRACE Procedure
- 209.9.15 XSTORE_CLEAR Procedure
- 209.9.16 XSTORE_EXISTS Function
- 209.9.17 XSTORE_GET Procedure
- 209.9.18 XSTORE_REMOVE Procedure
- 209.9.19 XSTORE_SET Procedure
 
 
- 210 DBMS_TNS
- 211 DBMS_TRACE
- 
               
               
                  
                  212
                       DBMS_TRANSACTION
               
                  
               
               
               - 212.1 DBMS_TRANSACTION Security Model
- 
                     
                     
                        
                        212.2
                            Summary of DBMS_TRANSACTION Subprograms
                     
                        
                     
                     
                     - 212.2.1 ADVISE_COMMIT Procedure
- 212.2.2 ADVISE_NOTHING Procedure
- 212.2.3 ADVISE_ROLLBACK Procedure
- 212.2.4 COMMIT Procedure
- 212.2.5 COMMIT_COMMENT Procedure
- 212.2.6 COMMIT_FORCE Procedure
- 212.2.7 GET_TRANSACTION_ID Function
- 212.2.8 GET_TRANSACTION_TIMEOUT Function
- 212.2.9 GET_TRANSACTION_TYPE Function
- 212.2.10 LOCAL_TRANSACTION_ID Function
- 212.2.11 PURGE_LOST_DB_ENTRY Procedure
- 212.2.12 PURGE_MIXED Procedure
- 212.2.13 READ_ONLY Procedure
- 212.2.14 READ_WRITE Procedure
- 212.2.15 ROLLBACK Procedure
- 212.2.16 ROLLBACK_FORCE Procedure
- 212.2.17 ROLLBACK_SAVEPOINT Procedure
- 212.2.18 SAVEPOINT Procedure
- 212.2.19 START_TRANSACTION Function
- 212.2.20 STEP_ID Function
- 212.2.21 SUSPEND_TRANSACTION Procedure
- 212.2.22 USE_ROLLBACK_SEGMENT Procedure
 
 
- 213 DBMS_TRANSFORM
- 
               
               
                  
                  214
                       DBMS_TSDP_MANAGE
               
                  
               
               
               - 214.1 DBMS_TSDP_MANAGE Overview
- 214.2 DBMS_TSDP_MANAGE Security Model
- 
                     
                     
                        
                        214.3
                            Summary of DBMS_TSDP_MANAGE Subprograms
                     
                        
                     
                     
                     - 214.3.1 ADD_SENSITIVE_COLUMN Procedure
- 214.3.2 ALTER_SENSITIVE_COLUMN Procedure
- 214.3.3 ADD_SENSITIVE_TYPE Procedure
- 214.3.4 DROP_SENSITIVE_COLUMN Procedure
- 214.3.5 DROP_SENSITIVE_TYPE Procedure
- 214.3.6 DROP_SENSITIVE_TYPE_SOURCE Procedure
- 214.3.7 IMPORT_DISCOVERY_RESULT Procedure
- 214.3.8 IMPORT_SENSITIVE_TYPES Procedure
- 214.3.9 REMOVE_DISCOVERY_RESULT Procedure
 
 
- 
               
               
                  
                  215
                       DBMS_TSDP_PROTECT
               
                  
               
               
               - 215.1 DBMS_TSDP_PROTECT Overview
- 215.2 DBMS_TSDP_PROTECT Security Model
- 215.3 DBMS_TSDP_PROTECT Constants
- 215.4 DBMS_TSDP_PROTECT Data Structures
- 
                     
                     
                        
                        215.5
                            Summary of DBMS_TSDP_PROTECT Subprograms
                     
                        
                     
                     
                     - 215.5.1 ADD_POLICY Procedure
- 215.5.2 ALTER_POLICY Procedure
- 215.5.3 ASSOCIATE_POLICY Procedure
- 215.5.4 DISABLE_PROTECTION_COLUMN Procedure
- 215.5.5 DISABLE_PROTECTION_SOURCE Procedure
- 215.5.6 DISABLE_PROTECTION_TYPE Procedure
- 215.5.7 DROP_POLICY Procedure
- 215.5.8 ENABLE_PROTECTION_COLUMN Procedure
- 215.5.9 ENABLE_PROTECTION_SOURCE Procedure
- 215.5.10 ENABLE_PROTECTION_TYPE Procedure
 
 
- 216 DBMS_TTS
- 217 DBMS_TYPES
- 
               
               
                  
                  218
                      DBMS_UMF
               
                  
               
               
               - 
                     
                     
                        
                        218.1
                            Summary of DBMS_UMF Subprograms
                     
                        
                     
                     
                     - 218.1.1 CONFIGURE_NODE Procedure
- 218.1.2 CREATE_LINK Procedure
- 218.1.3 CREATE_TOPOLOGY Procedure
- 218.1.4 DROP_LINK Procedure
- 218.1.5 DROP_TOPOLOGY Procedure
- 218.1.6 ENABLE_SERVICE Procedure
- 218.1.7 GET_NODE_ID_LOCAL Function
- 218.1.8 GET_NODE_NAME_LOCAL Function
- 218.1.9 GET_TARGET_ID Function
- 218.1.10 GET_TOPOLOGY_NAME_LOCAL Function
- 218.1.11 QUERY_LINK_INFO Procedure
- 218.1.12 QUERY_NODE_INFO Procedures
- 218.1.13 REGISTER_NODE Function and Procedure
- 218.1.14 SWITCH_DESTINATION Procedure
- 218.1.15 UNCONFIGURE_NODE Procedure
- 218.1.16 UNREGISTER_NODE Procedure
 
 
- 
                     
                     
                        
                        218.1
                            Summary of DBMS_UMF Subprograms
                     
                        
                     
                     
                     
- 219 DBMS_UNDO_ADV
- 220 DBMS_USER_CERTS
- 221 DBMS_USERDIAG
- 
               
               
                  
                  222
                       DBMS_UTILITY 
               
                  
               
               
               - 222.1 DBMS_UTILITY Deprecated Subprograms
- 222.2 DBMS_UTILITY Security Model
- 222.3 DBMS_UTILITY Constants
- 222.4 DBMS_UTILITY Exceptions
- 
                     
                     
                        
                        222.5
                            DBMS_UTILITY Data Structures
                     
                        
                     
                     
                     - 222.5.1 DBMS_UTILITY INSTANCE_RECORD Record Type
- 222.5.2 DBMS_UTILITY DBLINK_ARRAY TABLE Type
- 222.5.3 DBMS_UTILITY INDEX_TABLE_TYPE Table Type
- 222.5.4 DBMS_UTILITY INSTANCE_TABLE Table Type
- 222.5.5 DBMS_UTILITY LNAME_ARRAY Table Type
- 222.5.6 DBMS_UTILITY NAME_ARRAY Table Type
- 222.5.7 DBMS_UTILITY NUMBER_ARRAY Table Type
- 222.5.8 DBMS_UTILITY UNCL_ARRAY Table Type
 
- 
                     
                     
                        
                        222.6
                            Summary of DBMS_UTILITY Subprograms
                     
                        
                     
                     
                     - 222.6.1 ACTIVE_INSTANCES Procedure
- 222.6.2 ANALYZE_DATABASE Procedure
- 222.6.3 ANALYZE_PART_OBJECT Procedure
- 222.6.4 ANALYZE_SCHEMA Procedure
- 222.6.5 CANONICALIZE Procedure
- 222.6.6 COMMA_TO_TABLE Procedures
- 222.6.7 COMPILE_SCHEMA Procedure
- 222.6.8 CREATE_ALTER_TYPE_ERROR_TABLE Procedure
- 222.6.9 CURRENT_INSTANCE Function
- 222.6.10 DATA_BLOCK_ADDRESS_BLOCK Function
- 222.6.11 DATA_BLOCK_ADDRESS_FILE Function
- 222.6.12 DB_VERSION Procedure
- 222.6.13 EXEC_DDL_STATEMENT Procedure
- 222.6.14 EXPAND_SQL_TEXT Procedure
- 222.6.15 FORMAT_CALL_STACK Function
- 222.6.16 FORMAT_ERROR_BACKTRACE Function
- 222.6.17 FORMAT_ERROR_STACK Function
- 222.6.18 GET_CPU_TIME Function
- 222.6.19 GET_DEPENDENCY Procedure
- 222.6.20 GET_ENDIANNESS Function
- 222.6.21 GET_HASH_VALUE Function
- 222.6.22 GET_PARAMETER_VALUE Function
- 222.6.23 GET_SQL_HASH Function
- 222.6.24 GET_TIME Function
- 222.6.25 GET_TZ_TRANSITIONS Procedure
- 222.6.26 INVALIDATE Procedure
- 222.6.27 IS_BIT_SET Function
- 222.6.28 IS_CLUSTER_DATABASE Function
- 222.6.29 MAKE_DATA_BLOCK_ADDRESS Function
- 222.6.30 NAME_RESOLVE Procedure
- 222.6.31 NAME_TOKENIZE Procedure
- 222.6.32 OLD_CURRENT_SCHEMA Function
- 222.6.33 OLD_CURRENT_USER Function
- 222.6.34 PORT_STRING Function
- 222.6.35 SQLID_TO_SQLHASH Function
- 222.6.36 TABLE_TO_COMMA Procedures
- 222.6.37 VALIDATE Procedure
- 222.6.38 WAIT_ON_PENDING_DML Function
 
 
- 
               
               
                  
                  223
                      DBMS_VECTOR
               
                  
               
               
               - 
                     
                     
                        
                        223.1
                            Summary of DBMS_VECTOR Subprograms
                     
                        
                     
                     
                     - 223.1.1 CREATE_CREDENTIAL
- 223.1.2 CREATE_INDEX
- 223.1.3 DISABLE_CHECKPOINT
- 223.1.4 DROP_CREDENTIAL
- 223.1.5 ENABLE_CHECKPOINT
- 223.1.6 DROP_ONNX_MODEL Procedure
- 223.1.7 GET_INDEX_STATUS
- 223.1.8 INDEX_ACCURACY_QUERY
- 223.1.9 INDEX_ACCURACY_REPORT
- 223.1.10 INDEX_VECTOR_MEMORY_ADVISOR
- 223.1.11 LOAD_ONNX_MODEL
- 223.1.12 LOAD_ONNX_MODEL_CLOUD
- 223.1.13 QUERY
- 223.1.14 REBUILD_INDEX
- 223.1.15 RERANK
- 223.1.16 UTL_TO_CHUNKS
- 223.1.17 UTL_TO_EMBEDDING and UTL_TO_EMBEDDINGS
- 223.1.18 UTL_TO_GENERATE_TEXT
 
 
- 
                     
                     
                        
                        223.1
                            Summary of DBMS_VECTOR Subprograms
                     
                        
                     
                     
                     
- 
               
               
                  
                  224
                      DBMS_VECTOR_CHAIN
               
                  
               
               
               - 
                     
                     
                        
                        224.1
                            Summary of DBMS_VECTOR_CHAIN Subprograms
                     
                        
                     
                     
                     - 224.1.1 CREATE_CREDENTIAL
- 224.1.2 CREATE_LANG_DATA
- 224.1.3 CREATE_PREFERENCE
- 224.1.4 CREATE_VOCABULARY
- 224.1.5 DROP_CREDENTIAL
- 224.1.6 DROP_LANG_DATA
- 224.1.7 DROP_PREFERENCE
- 224.1.8 DROP_VOCABULARY
- 224.1.9 RERANK
- 224.1.10 UTL_TO_CHUNKS
- 224.1.11 UTL_TO_EMBEDDING and UTL_TO_EMBEDDINGS
- 224.1.12 UTL_TO_GENERATE_TEXT
- 224.1.13 UTL_TO_TEXT
- 224.1.14 UTL_TO_SUMMARY
 
- 224.2 Supported Languages and Data File Locations
 
- 
                     
                     
                        
                        224.1
                            Summary of DBMS_VECTOR_CHAIN Subprograms
                     
                        
                     
                     
                     
- 225 DBMS_WARNING
- 226 DBMS_WM
- 
               
               
                  
                  227
                       DBMS_WORKLOAD_CAPTURE
               
                  
               
               
               - 227.1 DBMS_WORKLOAD_CAPTURE Overview
- 227.2 DBMS_WORKLOAD_CAPTURE Security Model
- 
                     
                     
                        
                        227.3
                            Summary of DBMS_WORKLOAD_CAPTURE Subprograms
                     
                        
                     
                     
                     - 227.3.1 ADD_FILTER Procedures
- 227.3.2 DECRYPT_CAPTURE Procedure
- 227.3.3 DELETE_CAPTURE_INFO Procedure
- 227.3.4 DELETE_FILTER Procedure
- 227.3.5 ENCRYPT_CAPTURE Procedure
- 227.3.6 EXPORT_AWR Procedure
- 227.3.7 FINISH_CAPTURE Procedure
- 227.3.8 GET_CAPTURE_INFO Function
- 227.3.9 IMPORT_AWR Function
- 227.3.10 REPORT Function
- 227.3.11 START_CAPTURE Procedure
 
 
- 
               
               
                  
                  228
                       DBMS_WORKLOAD_REPLAY 
               
                  
               
               
               - 228.1 DBMS_WORKLOAD_REPLAY Overview
- 228.2 DBMS_WORKLOAD_REPLAY Security Model
- 
                     
                     
                        
                        228.3
                            Summary of DBMS_WORKLOAD_REPLAY Subprograms
                     
                        
                     
                     
                     - 228.3.1 ADD_CAPTURE Function
- 228.3.2 ADD_FILTER Procedure
- 228.3.3 ADD_SCHEDULE_ORDERING Function
- 228.3.4 ASSIGN_GROUP_TO_INSTANCE Procedure
- 228.3.5 BEGIN_REPLAY_SCHEDULE Procedure
- 228.3.6 CALIBRATE Function
- 228.3.7 CANCEL_REPLAY Procedure
- 228.3.8 COMPARE_PERIOD_REPORT Procedure
- 228.3.9 COMPARE_SQLSET_REPORT Function
- 228.3.10 CREATE_FILTER_SET Procedure
- 228.3.11 DELETE_FILTER Procedure
- 228.3.12 DELETE_REPLAY_INFO Procedure
- 228.3.13 END_REPLAY_SCHEDULE Procedure
- 228.3.14 EXPORT_AWR Procedure
- 228.3.15 GENERATE_CAPTURE_SUBSET Procedure
- 228.3.16 GET_DIVERGING_STATEMENT Function
- 228.3.17 GET_REPLAY_DIRECTORY Function
- 228.3.18 GET_REPLAY_INFO Function
- 228.3.19 GET_REPLAY_TIMEOUT Procedure
- 228.3.20 IMPORT_AWR Function
- 228.3.21 INITIALIZE_CONSOLIDATED_REPLAY Procedure
- 228.3.22 INITIALIZE_REPLAY Procedure
- 228.3.23 IS_REPLAY_PAUSED Function
- 228.3.24 LOAD_LONG_SQLTEXT Procedure
- 228.3.25 PAUSE_REPLAY Procedure
- 228.3.26 POPULATE_DIVERGENCE Procedure
- 228.3.27 PREPARE_CONSOLIDATED_REPLAY Procedure
- 228.3.28 PREPARE_REPLAY Procedure
- 228.3.29 PROCESS_CAPTURE Procedure
- 228.3.30 REMAP_CONNECTION Procedure
- 228.3.31 REMOVE_CAPTURE Procedure
- 228.3.32 REMOVE_SCHEDULE_ORDERING Procedure
- 228.3.33 REPORT Function
- 228.3.34 RESUME_REPLAY Procedure
- 228.3.35 REUSE_REPLAY_FILTER_SET Procedure
- 228.3.36 SET_ADVANCED_PARAMETER Procedure
- 228.3.37 SET_REPLAY_DIRECTORY Procedure
- 228.3.38 SET_REPLAY_TIMEOUT Procedure
- 228.3.39 SET_SQL_MAPPING Procedure
- 228.3.40 SET_USER_MAPPING Procedure
- 228.3.41 START_CONSOLIDATED_REPLAY Procedure
- 228.3.42 START_REPLAY Procedure
- 228.3.43 USE_FILTER_SET Procedure
 
 
- 
               
               
                  
                  229
                       DBMS_WORKLOAD_REPOSITORY
               
                  
               
               
               - 229.1 DBMS_WORKLOAD_REPOSITORY Examples
- 229.2 DBMS_WORKLOAD_REPOSITORY Data Structures
- 
                     
                     
                        
                        229.3
                            Summary of DBMS_WORKLOAD_REPOSITORY Subprograms
                     
                        
                     
                     
                     - 229.3.1 ADD_COLORED_SQL Procedure
- 229.3.2 ASH_GLOBAL_REPORT_HTML Function
- 229.3.3 ASH_GLOBAL_REPORT_TEXT Function
- 229.3.4 ASH_REPORT_ANALYTICS Function
- 229.3.5 ASH_REPORT_HTML Function
- 229.3.6 ASH_REPORT_TEXT Function
- 229.3.7 AWR_DIFF_REPORT_HTML Function
- 229.3.8 AWR_DIFF_REPORT_TEXT Function
- 229.3.9 AWR_EXP Procedure
- 229.3.10 AWR_GLOBAL_DIFF_REPORT_HTML Functions
- 229.3.11 AWR_GLOBAL_DIFF_REPORT_TEXT Functions
- 229.3.12 AWR_GLOBAL_REPORT_HTML Functions
- 229.3.13 AWR_GLOBAL_REPORT_TEXT Functions
- 229.3.14 AWR_IMP Procedure
- 229.3.15 AWR_REPORT_HTML Function
- 229.3.16 AWR_REPORT_TEXT Function
- 229.3.17 AWR_SET_REPORT_THRESHOLDS Procedure
- 229.3.18 AWR_SQL_REPORT_HTML Function
- 229.3.19 AWR_SQL_REPORT_TEXT Function
- 229.3.20 CONTROL_RESTRICTED_SNAPSHOT Procedure
- 229.3.21 CREATE_APPMAP Procedure
- 229.3.22 CREATE_BASELINE Functions and Procedures
- 229.3.23 CREATE_BASELINE_TEMPLATE Procedures
- 229.3.24 CREATE_REMOTE_SNAPSHOT Function and Procedure
- 229.3.25 CREATE_SNAPSHOT Function and Procedure
- 229.3.26 DROP_APPMAP Procedure
- 229.3.27 DROP_BASELINE Procedure
- 229.3.28 DROP_BASELINE_TEMPLATE Procedure
- 229.3.29 DROP_SNAPSHOT_RANGE Procedure
- 229.3.30 EXCLUDE_APPMAP Procedure
- 229.3.31 GET_AWR_ID Function
- 229.3.32 INCLUDE_APPMAP Procedure
- 229.3.33 LOCAL_AWR_DBID Function
- 229.3.34 MODIFY_AWREXP_SETTINGS Procedure
- 229.3.35 MODIFY_BASELINE_WINDOW_SIZE Procedure
- 229.3.36 MODIFY_SNAPSHOT_SETTINGS Procedures
- 229.3.37 PURGE_SQL_DETAILS Procedure
- 229.3.38 REGISTER_REMOTE_DATABASE Procedures
- 229.3.39 REMOVE_COLORED_SQL Procedure
- 229.3.40 RENAME_BASELINE Procedure
- 229.3.41 SELECT_BASELINE_DETAILS Function
- 229.3.42 SELECT_BASELINE_METRIC Function
- 229.3.43 UNREGISTER_REMOTE_DATABASE Procedures
- 229.3.44 UPDATE_DATAFILE_INFO Procedure
- 229.3.45 UPDATE_OBJECT_INFO Procedure
 
 
- 
               
               
                  
                  230
                      DBMS_XDB
               
                  
               
               
               - 230.1 DBMS_XDB Overview
- 230.2 DBMS_XDB Security Model
- 230.3 DBMS_XDB Constants
- 
                     
                     
                        
                        230.4
                            Summary of DBMS_XDB Subprograms
                     
                        
                     
                     
                     - 230.4.1 ACLCHECKPRIVILEGES Function
- 230.4.2 APPENDRESOURCEMETADATA Procedure
- 230.4.3 CHANGEOWNER Procedure
- 230.4.4 CHANGEPRIVILEGES Function
- 230.4.5 CHECKPRIVILEGES Function
- 230.4.6 CREATEFOLDER Function
- 230.4.7 CREATEOIDPATH Function
- 230.4.8 CREATERESOURCE Functions
- 230.4.9 DELETERESOURCE Procedure
- 230.4.10 DELETERESOURCEMETADATA Procedures
- 230.4.11 ENABLEDIGESTAUTHENTICATION Procedure
- 230.4.12 EXISTSRESOURCE Function
- 230.4.13 GETACLDOCUMENT Function
- 230.4.14 GETCONTENTBLOB Function
- 230.4.15 GETCONTENTCLOB Function
- 230.4.16 GETCONTENTVARCHAR2 Function
- 230.4.17 GETCONTENTXMLREF Function
- 230.4.18 GETCONTENTXMLTYPE Function
- 230.4.19 GETHTTPREQUESTHEADER Function
- 230.4.20 GETLOCKTOKEN Procedure
- 230.4.21 GETPRIVILEGES Function
- 230.4.22 GETRESOID Function
- 230.4.23 GETXDB_TABLESPACE Function
- 230.4.24 HASBLOBCONTENT Function
- 230.4.25 HASCHARCONTENT Function
- 230.4.26 HASXMLCONTENT Function
- 230.4.27 HASXMLREFERENCE Function
- 230.4.28 ISFOLDER Function
- 230.4.29 LINK Procedures
- 230.4.30 LOCKRESOURCE Function
- 230.4.31 PROCESSLINKS Procedure
- 230.4.32 PURGERESOURCEMETADATA Procedure
- 230.4.33 RENAMERESOURCE Procedure
- 230.4.34 SETACL Procedure
- 230.4.35 SPLITPATH Procedure
- 230.4.36 TOUCHRESOURCE Procedure
- 230.4.37 UNLOCKRESOURCE Function
- 230.4.38 UPDATERESOURCEMETADATA Procedures
 
 
- 231 DBMS_XA
- 232 DBMS_XDB_ADMIN
- 
               
               
                  
                  233
                       DBMS_XDB_CONFIG 
               
                  
               
               
               - 233.1 DBMS_XDB_CONFIG Overview
- 233.2 DBMS_XDB_CONFIG Security Model
- 233.3 DBMS_XDB_CONFIG Constants
- 
                     
                     
                        
                        233.4
                            Summary of DBMS_XDB_CONFIG Subprograms
                     
                        
                     
                     
                     - 233.4.1 ADDHTTPEXPIREMAPPING Procedure
- 233.4.2 ADDMIMEMAPPING Procedure
- 233.4.3 ADDSCHEMALOCMAPPING Procedure
- 233.4.4 ADDSERVLET Procedure
- 233.4.5 ADDSERVLETMAPPING Procedure
- 233.4.6 ADDSERVLETSECROLE Procedure
- 233.4.7 ADDXMLEXTENSION Procedure
- 233.4.8 CFG_GET Function
- 233.4.9 CFG_REFRESH Procedure
- 233.4.10 CFG_UPDATE Procedure
- 233.4.11 DELETEHTTPEXPIREMAPPING Procedure
- 233.4.12 DELETEMIMEMAPPING Procedure
- 233.4.13 DELETESCHEMALOCMAPPING Procedure
- 233.4.14 DELETESERVLET Procedure
- 233.4.15 DELETESERVLETMAPPING Procedure
- 233.4.16 DELETESERVLETSECROLE Procedure
- 233.4.17 DELETEXMLEXTENSION Procedure
- 233.4.18 ENABLEDIGESTAUTHENTICATION Procedure
- 233.4.19 GETFTPPORT Function
- 233.4.20 GETHTTPCONFIGREALM Function
- 233.4.21 GETHTTPPORT Function
- 233.4.22 GETHTTPSPORT Function
- 233.4.23 GETLISTENERENDPOINT Procedure
- 233.4.24 GETREMOTEHTTPPORT Function
- 233.4.25 GETREMOTEHTTPSPORT Function
- 233.4.26 ISGLOBALPORTENABLED Function
- 233.4.27 SETFTPPORT Procedure
- 233.4.28 SETHTTPPORT Procedure
- 233.4.29 SETHTTPCONFIGREALM Procedure
- 233.4.30 SETHTTPSPORT Procedure
- 233.4.31 SETLISTENERENDPOINT Procedure
- 233.4.32 SETLISTENERLOCALACCESS Procedure
- 233.4.33 SETREMOTEHTTPPORT Procedure
- 233.4.34 SETREMOTEHTTPSPORT Procedure
- 233.4.35 USEDPORT Function
 
 
- 
               
               
                  
                  234
                      DBMS_XDB_CONSTANTS 
               
                  
               
               
               - 234.1 DBMS_XDB_CONSTANTS Security Model
- 
                     
                     
                        
                        234.2
                            Summary of DBMS_XDB_CONSTANTS Subprograms
                     
                        
                     
                     
                     - 234.2.1 ENCODING_DEFAULT Function
- 234.2.2 ENCODING_ISOLATIN1 Function
- 234.2.3 ENCODING_UTF8 Function
- 234.2.4 ENCODING_WIN1252 Function
- 234.2.5 NAMESPACE_ACL Function
- 234.2.6 NAMESPACE_METADATA Function
- 234.2.7 NAMESPACE_ORACLE Function
- 234.2.8 NAMESPACE_ORACLE_XDB Function
- 234.2.9 NAMESPACE_RESOURCE Function
- 234.2.10 NAMESPACE_RESOURCE_EVENT Function
- 234.2.11 NAMESPACE_RESOURCE_CONFIG Function
- 234.2.12 NAMESPACE_XDBSCHEMA Function
- 234.2.13 NAMESPACE_XMLDIFF Function
- 234.2.14 NAMESPACE_XMLINSTANCE Function
- 234.2.15 NAMESPACE_XMLSCHEMA Function
- 234.2.16 NSPREFIX_ACL_ACL Function
- 234.2.17 NSPREFIX_RESCONFIG_RC Function
- 234.2.18 NSPREFIX_RESOURCE_R Function
- 234.2.19 NSPREFIX_XDB_XDB Function
- 234.2.20 NSPREFIX_XMLINSTANCE_XSI Function
- 234.2.21 NSPREFIX_XMLDIFF_XD Function
- 234.2.22 NSPREFIX_XMLSCHEMA_XSD Function
- 234.2.23 SCHEMAURL_ACL Function
- 234.2.24 SCHEMAELEM_RES_ACL Function
- 234.2.25 SCHEMAELEM_RESCONTENT_BINARY Function
- 234.2.26 SCHEMAELEM_RESCONTENT_TEXT Function
- 234.2.27 SCHEMAURL_RESOURCE Function
- 234.2.28 SCHEMAURL_XDBSCHEMA Function
- 234.2.29 XDBSCHEMA_PREFIXES Function
- 234.2.30 XSD_ATTRIBUTE Function
- 234.2.31 XSD_COMPLEX_TYPE Function
- 234.2.32 XSD_ELEMENT Function
- 234.2.33 XSD_GROUP Function
 
 
- 
               
               
                  
                  235
                       DBMS_XDB_REPOS 
               
                  
               
               
               - 235.1 DBMS_XDB_REPOS Overview
- 235.2 DBMS_XDB_REPOS Security Model
- 235.3 DBMS_XDB_REPOS Constants
- 
                     
                     
                        
                        235.4
                            Summary of DBMS_XDB_REPOS Subprograms
                     
                        
                     
                     
                     - 235.4.1 ACLCHECKPRIVILEGES Function
- 235.4.2 APPENDRESOURCEMETADATA Procedure
- 235.4.3 CHANGEOWNER Procedure
- 235.4.4 CHANGEPRIVILEGES Function
- 235.4.5 CHECKPRIVILEGES Function
- 235.4.6 CREATEFOLDER Function
- 235.4.7 CREATEOIDPATH Function
- 235.4.8 CREATERESOURCE Functions
- 235.4.9 DELETERESOURCE Procedure
- 235.4.10 DELETERESOURCEMETADATA Procedures
- 235.4.11 EXISTSRESOURCE Function
- 235.4.12 GETACLDOCUMENT Function
- 235.4.13 GETCONTENTBLOB Function
- 235.4.14 GETCONTENTCLOB Function
- 235.4.15 GETCONTENTVARCHAR2 Function
- 235.4.16 GETCONTENTXMLREF Function
- 235.4.17 GETCONTENTXMLTYPE Function
- 235.4.18 GETLOCKTOKEN Procedure
- 235.4.19 GETPRIVILEGES Function
- 235.4.20 GETRESOID Function
- 235.4.21 GETXDB_TABLESPACE Function
- 235.4.22 HASBLOBCONTENT Function
- 235.4.23 HASCHARCONTENT Function
- 235.4.24 HASXMLCONTENT Function
- 235.4.25 HASXMLREFERENCE Function
- 235.4.26 ISFOLDER Function
- 235.4.27 LINK Procedures
- 235.4.28 LOCKRESOURCE Function
- 235.4.29 PROCESSLINKS Procedure
- 235.4.30 PURGERESOURCEMETADATA Procedure
- 235.4.31 RENAMERESOURCE Procedure
- 235.4.32 SETACL Procedure
- 235.4.33 SPLITPATH Procedure
- 235.4.34 TOUCHRESOURCE Procedure
- 235.4.35 UNLOCKRESOURCE Function
- 235.4.36 UPDATERESOURCEMETADATA Procedures
 
 
- 
               
               
                  
                  236
                       DBMS_XDB_VERSION
               
                  
               
               
               - 236.1 DBMS_XDB_VERSION Security Model
- 
                     
                     
                        
                        236.2
                            Summary of DBMS_XDB_VERSION Subprograms
                     
                        
                     
                     
                     - 236.2.1 CHECKIN Function
- 236.2.2 CHECKOUT Procedure
- 236.2.3 GETCONTENTSBLOBBYRESID Function
- 236.2.4 GETCONTENTSCLOBBYRESID Function
- 236.2.5 GETCONTENTSXMLBYRESID Function
- 236.2.6 GETPREDECESSORS Function
- 236.2.7 GETPREDSBYRESID Function
- 236.2.8 GETRESOURCEBYRESID Function
- 236.2.9 GETSUCCESSORS Function
- 236.2.10 GETSUCCSBYRESID Function
- 236.2.11 MAKEVERSIONED Function
- 236.2.12 UNCHECKOUT Function
 
 
- 
               
               
                  
                  237
                       DBMS_XDBRESOURCE 
               
                  
               
               
               - 237.1 DBMS_XDBRESOURCE Overview
- 237.2 DBMS_XDBRESOURCE Security Model
- 
                     
                     
                        
                        237.3
                            Summary of DBMS_XDBRESOURCE Subprograms
                     
                        
                     
                     
                     - 237.3.1 FREERESOURCE Procedure
- 237.3.2 GETACL Function
- 237.3.3 GETACLDOCFROMRES Function
- 237.3.4 GETAUTHOR Function
- 237.3.5 GETCHARACTERSET Function
- 237.3.6 GETCOMMENT Function
- 237.3.7 GETCONTENTBLOB Function
- 237.3.8 GETCONTENTCLOB Function
- 237.3.9 GETCONTENTREF Function
- 237.3.10 GETCONTENTTYPE Function
- 237.3.11 GETCONTENTXML Function
- 237.3.12 GETCONTENTVARCHAR2 Function
- 237.3.13 GETCREATIONDATE Function
- 237.3.14 GETCREATOR Function
- 237.3.15 GETCUSTOMMETADATA Function
- 237.3.16 GETDISPLAYNAME Function
- 237.3.17 GETLANGUAGE Function
- 237.3.18 GETLASTMODIFIER Function
- 237.3.19 GETMODIFICATIONDATE Function
- 237.3.20 GETOWNER Function
- 237.3.21 GETREFCOUNT Function
- 237.3.22 GETVERSIONID Function
- 237.3.23 HASACLCHANGED Function
- 237.3.24 HASAUTHORCHANGED Function
- 237.3.25 HASCHANGED Function
- 237.3.26 HASCHARACTERSETCHANGED Function
- 237.3.27 HASCOMMENTCHANGED Function
- 237.3.28 HASCONTENTCHANGED Function
- 237.3.29 HASCONTENTTYPECHANGED Function
- 237.3.30 HASCREATIONDATECHANGED Function
- 237.3.31 HASCREATORCHANGED Function
- 237.3.32 HASCUSTOMMETADATACHANGED Function
- 237.3.33 HASDISPLAYNAMECHANGED Function
- 237.3.34 HASLANGUAGECHANGED Function
- 237.3.35 HASLASTMODIFIERCHANGED Function
- 237.3.36 HASMODIFICATIONDATECHANGED Function
- 237.3.37 HASOWNERCHANGED Function
- 237.3.38 HASREFCOUNTCHANGED Function
- 237.3.39 HASVERSIONIDCHANGED Function
- 237.3.40 ISFOLDER Function
- 237.3.41 ISNULL Function
- 237.3.42 MAKEDOCUMENT Function
- 237.3.43 SAVE Procedure
- 237.3.44 SETACL Procedure
- 237.3.45 SETAUTHOR Procedure
- 237.3.46 SETCHARACTERSET Procedure
- 237.3.47 SETCOMMENT Procedure
- 237.3.48 SETCONTENT Procedures
- 237.3.49 SETCONTENTTYPE Procedure
- 237.3.50 SETCUSTOMMETADATA Procedure
- 237.3.51 SETDISPLAYNAME Procedure
- 237.3.52 SETLANGUAGE Procedure
- 237.3.53 SETOWNER Procedure
 
 
- 238 DBMS_XDBZ
- 
               
               
                  
                  239
                       DBMS_XEVENT 
               
                  
               
               
               - 239.1 DBMS_XEVENT Security Model
- 239.2 DBMS_XEVENT Constants
- 239.3 Subprogram Groups
- 
                     
                     
                        
                        239.4
                            Summary of DBMS_XEVENT Subprograms
                     
                        
                     
                     
                     - 239.4.1 CLEAR Procedure
- 239.4.2 GETAPPLICATIONDATA Function
- 239.4.3 GETCHILDOID Function
- 239.4.4 GETCURRENTUSER Function
- 239.4.5 GETEVENT Function
- 239.4.6 GETFIRST Function
- 239.4.7 GETHANDLERLIST Function
- 239.4.8 GETINTERFACE Function
- 239.4.9 GETLANGUAGE Function
- 239.4.10 GETLINK Function
- 239.4.11 GETLINKNAME Function
- 239.4.12 GETLOCK Function
- 239.4.13 GETLANGUAGE Function
- 239.4.14 GETNAME Function
- 239.4.15 GETNEXT Function
- 239.4.16 GETOLDRESOURCE Function
- 239.4.17 GETOPENACCESSMODE Function
- 239.4.18 GETOPENDENYMODE Function
- 239.4.19 GETOUTPUTSTREAM Function
- 239.4.20 GETPARAMETER Function
- 239.4.21 GETPARENT Function
- 239.4.22 GETPARENTNAME Function
- 239.4.23 GETPARENTOID Function
- 239.4.24 GETPARENTPATH Function
- 239.4.25 GETPATH Function
- 239.4.26 GETRESOURCE Function
- 239.4.27 GETSCHEMA Function
- 239.4.28 GETSOURCE Function
- 239.4.29 GETUPDATEBYTECOUNT Function
- 239.4.30 GETUPDATEBYTEOFFSET Function
- 239.4.31 GETXDBEVENT Function
- 239.4.32 ISNULL Functions
- 239.4.33 REMOVE Procedure
- 239.4.34 SETRENDERPATH Procedure
- 239.4.35 SETRENDERSTREAM Procedure
 
 
- 
               
               
                  
                  240
                       DBMS_XMLDOM
               
                  
               
               
               - 240.1 DBMS_XMLDOM Overview
- 240.2 DBMS_XMLDOM Security Model
- 240.3 DBMS_XMLDOM Constants
- 240.4 DBMS_XMLDOM Types
- 240.5 DBMS_XMLDOM Exceptions
- 
                     
                     
                        
                        240.6
                            DBMS_XMLDOM Subprogram Groups
                     
                        
                     
                     
                     - 240.6.1 DBMS_XMLDOM DOMNode Subprograms
- 240.6.2 DBMS_XMLDOM DOMAttr Subprograms
- 240.6.3 DBMS_XMLDOM DOMCDataSection Subprograms
- 240.6.4 DBMS_XMLDOM DOMCharacterData Subprograms
- 240.6.5 DBMS_XMLDOM DOMComment Subprograms
- 240.6.6 DBMS_XMLDOM DOMDocument Subprograms
- 240.6.7 DBMS_XMLDOM DOMDocumentFragment Subprograms
- 240.6.8 DBMS_XMLDOM DOMDocumentType Subprograms
- 240.6.9 DBMS_XMLDOM DOMElement Subprograms
- 240.6.10 DBMS_XMLDOM DOMEntity Subprograms
- 240.6.11 DBMS_XMLDOM DOMEntityReference Subprograms
- 240.6.12 DBMS_XMLDOM DOMImplementation Subprograms
- 240.6.13 DBMS_XMLDOM DOMNamedNodeMap Subprograms
- 240.6.14 DBMS_XMLDOM DOMNodeList Subprograms
- 240.6.15 DBMS_XMLDOM DOMNotation Subprograms
- 240.6.16 DBMS_XMLDOM DOMProcessingInstruction Subprograms
- 240.6.17 DBMS_XMLDOM DOMText Subprograms
 
- 
                     
                     
                        
                        240.7
                            Summary of DBMS_XMLDOM Subprograms
                     
                        
                     
                     
                     - 240.7.1 ADOPTNODE Function
- 240.7.2 APPENDCHILD Function
- 240.7.3 APPENDDATA Procedure
- 240.7.4 CLONENODE Function
- 240.7.5 CREATEATTRIBUTE Functions
- 240.7.6 CREATECDATASECTION Function
- 240.7.7 CREATECOMMENT Function
- 240.7.8 CREATEDOCUMENT Function
- 240.7.9 CREATEDOCUMENTFRAGMENT Function
- 240.7.10 CREATEELEMENT Functions
- 240.7.11 CREATEENTITYREFERENCE Function
- 240.7.12 CREATEPROCESSINGINSTRUCTION Function
- 240.7.13 CREATETEXTNODE Function
- 240.7.14 DELETEDATA Procedure
- 240.7.15 FINDENTITY Function
- 240.7.16 FINDNOTATION Function
- 240.7.17 FREEDOCFRAG Procedure
- 240.7.18 FREEDOCUMENT Procedure
- 240.7.19 FREEELEMENT Procedure
- 240.7.20 FREENODE Procedure
- 240.7.21 FREENODELIST Procedure
- 240.7.22 GETATTRIBUTE Functions
- 240.7.23 GETATTRIBUTENODE Functions
- 240.7.24 GETATTRIBUTES Function
- 240.7.25 GETCHARSET Function
- 240.7.26 GETCHILDNODES Function
- 240.7.27 GETCHILDRENBYTAGNAME Functions
- 240.7.28 GETDATA Functions
- 240.7.29 GETDOCTYPE Function
- 240.7.30 GETDOCUMENTELEMENT Function
- 240.7.31 GETELEMENTSBYTAGNAME Functions
- 240.7.32 GETENTITIES Function
- 240.7.33 GETEXPANDEDNAME Procedure and Functions
- 240.7.34 GETFIRSTCHILD Function
- 240.7.35 GETIMPLEMENTATION Function
- 240.7.36 GETLASTCHILD Function
- 240.7.37 GETLENGTH Functions
- 240.7.38 GETLOCALNAME Procedure and Functions
- 240.7.39 GETNAME Functions
- 240.7.40 GETNAMEDITEM Function
- 240.7.41 GETNAMESPACE Procedure and Functions
- 240.7.42 GETNEXTSIBLING Function
- 240.7.43 GETNODETYPE Function
- 240.7.44 GETNODENAME Function
- 240.7.45 GETNODEVALUE Function
- 240.7.46 GETNODEVALUEASBINARYSTREAM Function & Procedure
- 240.7.47 GETNODEVALUEASCHARACTERSTREAM Function & Procedure
- 240.7.48 GETNOTATIONNAME Function
- 240.7.49 GETNOTATIONS Function
- 240.7.50 GETTARGET Function
- 240.7.51 GETOWNERDOCUMENT Function
- 240.7.52 GETOWNERELEMENT Function
- 240.7.53 GETPARENTNODE Function
- 240.7.54 GETPREFIX Function
- 240.7.55 GETPREVIOUSSIBLING Function
- 240.7.56 GETPUBLICID Functions
- 240.7.57 GETQUALIFIEDNAME Functions
- 240.7.58 GETSCHEMANODE Function
- 240.7.59 GETSPECIFIED Function
- 240.7.60 GETSTANDALONE Function
- 240.7.61 GETSYSTEMID Functions
- 240.7.62 GETTAGNAME Function
- 240.7.63 GETVALUE Function
- 240.7.64 GETVERSION Function
- 240.7.65 GETXMLTYPE Function
- 240.7.66 HASATTRIBUTE Functions
- 240.7.67 HASATTRIBUTES Function
- 240.7.68 HASCHILDNODES Function
- 240.7.69 HASFEATURE Function
- 240.7.70 IMPORTNODE Function
- 240.7.71 INSERTBEFORE Function
- 240.7.72 INSERTDATA Procedure
- 240.7.73 ISNULL Functions
- 240.7.74 ITEM Functions
- 240.7.75 MAKEATTR Function
- 240.7.76 MAKECDATASECTION Function
- 240.7.77 MAKECHARACTERDATA Function
- 240.7.78 MAKECOMMENT Function
- 240.7.79 MAKEDOCUMENT Function
- 240.7.80 MAKEDOCUMENTFRAGMENT Function
- 240.7.81 MAKEDOCUMENTTYPE Function
- 240.7.82 MAKEELEMENT Function
- 240.7.83 MAKEENTITY Function
- 240.7.84 MAKEENTITYREFERENCE Function
- 240.7.85 MAKENODE Functions
- 240.7.86 MAKENOTATION Function
- 240.7.87 MAKEPROCESSINGINSTRUCTION Function
- 240.7.88 MAKETEXT Function
- 240.7.89 NEWDOMDOCUMENT Functions
- 240.7.90 NORMALIZE Procedure
- 240.7.91 REMOVEATTRIBUTE Procedures
- 240.7.92 REMOVEATTRIBUTENODE Function
- 240.7.93 REMOVECHILD Function
- 240.7.94 REMOVENAMEDITEM Function
- 240.7.95 REPLACECHILD Function
- 240.7.96 REPLACEDATA Procedure
- 240.7.97 RESOLVENAMESPACEPREFIX Function
- 240.7.98 SETATTRIBUTE Procedures
- 240.7.99 SETATTRIBUTENODE Functions
- 240.7.100 SETCHARSET Procedure
- 240.7.101 SETDATA Procedures
- 240.7.102 SETDOCTYPE Procedure
- 240.7.103 SETNAMEDITEM Function
- 240.7.104 SETNODEVALUE Procedure
- 240.7.105 SETNODEVALUEASBINARYSTREAM Function & Procedure
- 240.7.106 SETNODEVALUEASCHARACTERSTREAM Function & Procedure
- 240.7.107 SETPREFIX Procedure
- 240.7.108 SETSTANDALONE Procedure
- 240.7.109 SETVALUE Procedure
- 240.7.110 SETVERSION Procedure
- 240.7.111 SPLITTEXT Function
- 240.7.112 SUBSTRINGDATA Function
- 240.7.113 USEBINARYSTREAM Function
- 240.7.114 WRITETOBUFFER Procedures
- 240.7.115 WRITETOCLOB Procedures
- 240.7.116 WRITETOFILE Procedures
 
 
- 
               
               
                  
                  241
                       DBMS_XMLGEN
               
                  
               
               
               - 241.1 DBMS_XMLGEN Security Model
- 
                     
                     
                        
                        241.2
                            Summary of DBMS_XMLGEN Subprograms
                     
                        
                     
                     
                     - 241.2.1 CLOSECONTEXT Procedure
- 241.2.2 CONVERT Functions
- 241.2.3 GETNUMROWSPROCESSED Function
- 241.2.4 GETXML Functions
- 241.2.5 GETXMLTYPE Functions
- 241.2.6 NEWCONTEXT Functions
- 241.2.7 NEWCONTEXTFROMHIERARCHY Function
- 241.2.8 RESTARTQUERY Procedure
- 241.2.9 SETCONVERTSPECIALCHARS Procedure
- 241.2.10 SETMAXROWS Procedure
- 241.2.11 SETNULLHANDLING Procedure
- 241.2.12 SETROWSETTAG Procedure
- 241.2.13 SETROWTAG Procedure
- 241.2.14 SETSKIPROWS Procedure
- 241.2.15 USEITEMTAGSFORCOLL Procedure
- 241.2.16 USENULLATTRIBUTEINDICATOR Procedure
 
 
- 242 DBMS_XMLINDEX
- 
               
               
                  
                  243
                       DBMS_XMLPARSER
               
                  
               
               
               - 243.1 DBMS_XMLPARSER Security Model
- 
                     
                     
                        
                        243.2
                            Summary of DBMS_XMLPARSER Subprograms
                     
                        
                     
                     
                     - 243.2.1 FREEPARSER
- 243.2.2 GETDOCTYPE
- 243.2.3 GETDOCUMENT
- 243.2.4 GETRELEASEVERSION
- 243.2.5 GETVALIDATIONMODE
- 243.2.6 NEWPARSER
- 243.2.7 PARSE
- 243.2.8 PARSEBUFFER
- 243.2.9 PARSECLOB
- 243.2.10 PARSEDTD
- 243.2.11 PARSEDTDBUFFER
- 243.2.12 PARSEDTDCLOB
- 243.2.13 SETBASEDIR
- 243.2.14 SETDOCTYPE Procedure
- 243.2.15 SETERRORLOG Procedure
- 243.2.16 SETPRESERVEWHITESPACE
- 243.2.17 SETVALIDATIONMODE
- 243.2.18 SHOWWARNINGS
 
 
- 244 DBMS_XMLSCHEMA
- 
               
               
                  
                  245
                       DBMS_XMLSCHEMA_ANNOTATE
               
                  
               
               
               - 245.1 DBMS_XMLSCHEMA_ANNOTATE Overview
- 245.2 DBMS_XMLSCHEMA_ANNOTATE Security Model
- 
                     
                     
                        
                        245.3
                            Summary of DBMS_XMLSCHEMA_ANNOTATE Subprograms
                     
                        
                     
                     
                     - 245.3.1 ADDXDBNAMESPACE Procedure
- 245.3.2 DISABLEDEFAULTTABLECREATION Procedure
- 245.3.3 DISABLEMAINTAINDOM Procedure
- 245.3.4 ENABLEDEFAULTTABLECREATION Procedure
- 245.3.5 ENABLEMAINTAINDOM Procedure
- 245.3.6 GETSCHEMAANNOTATIONS Function
- 245.3.7 GETSIDXDEFFROMVIEW Function
- 245.3.8 PRINTWARNINGS Procedure
- 245.3.9 REMOVEANYSTORAGE Procedure
- 245.3.10 REMOVEDEFAULTTABLE Procedure
- 245.3.11 REMOVEMAINTAINDOM Procedure
- 245.3.12 REMOVEOUTOFLINE Procedure
- 245.3.13 REMOVESQLCOLLTYPE Procedure
- 245.3.14 REMOVESQLNAME Procedure
- 245.3.15 REMOVESQLTYPE Procedure
- 245.3.16 REMOVESQLTYPEMAPPING Procedure
- 245.3.17 REMOVETABLEPROPS Procedure
- 245.3.18 REMOVETIMESTAMPWITHTIMEZONE Procedure
- 245.3.19 SETANYSTORAGE Procedure
- 245.3.20 SETDEFAULTTABLE Procedure
- 245.3.21 SETOUTOFLINE Procedure
- 245.3.22 SETSCHEMAANNOTATATIONS Procedure
- 245.3.23 SETSQLCOLLTYPE Procedure
- 245.3.24 SETSQLNAME Procedure
- 245.3.25 SETSQLTYPE Procedure
- 245.3.26 SETSQLTYPEMAPPING Procedure
- 245.3.27 SETTABLEPROPS Procedure
- 245.3.28 SETTIMESTAMPWITHTIMEZONE Procedure
 
 
- 246 DBMS_XMLSCHEMA_UTIL
- 
               
               
                  
                  247
                       DBMS_XMLSTORAGE_MANAGE
               
                  
               
               
               - 247.1 DBMS_XMLSTORAGE_MANAGE Overview
- 247.2 DBMS_XMLSTORAGE_MANAGE Security Model
- 
                     
                     
                        
                        247.3
                            Summary of DBMS_XMLSTORAGE_MANAGE Subprograms
                     
                        
                     
                     
                     - 247.3.1 DISABLEINDEXESANDCONSTRAINTS Procedure
- 247.3.2 ENABLEINDEXESANDCONSTRAINTS Procedure
- 247.3.3 EXCHANGEPOSTPROC Procedure
- 247.3.4 EXCHANGEPREPROC Procedure
- 247.3.5 INDEXXMLREFERENCES Procedure
- 247.3.6 REFPARTITIONEXCHANGEIN Procedure
- 247.3.7 REFPARTITIONEXCHANGEOUT Procedure
- 247.3.8 RENAMECOLLECTIONTABLE Procedure
- 247.3.9 SCOPEXMLREFERENCES Procedure
- 247.3.10 XPATH2TABCOLMAPPING Function
 
 
- 248 DBMS_XMLSTORE
- 249 DBMS_XPLAN
- 
               
               
                  
                  250
                       DBMS_XSLPROCESSOR
               
                  
               
               
               - 250.1 DBMS_XSLPROCESSOR Overview
- 250.2 DBMS_XSLPROCESSOR Security Model
- 
                     
                     
                        
                        250.3
                            Summary of DBMS_XSLPROCESSOR Subprograms
                     
                        
                     
                     
                     - 250.3.1 FREEPROCESSOR Procedure
- 250.3.2 FREESTYLESHEET Procedure
- 250.3.3 NEWPROCESSOR Function
- 250.3.4 NEWSTYLESHEET Functions
- 250.3.5 PROCESSXSL Functions and Procedures
- 250.3.6 REMOVEPARAM Procedure
- 250.3.7 RESETPARAMS Procedure
- 250.3.8 SELECTNODES Function
- 250.3.9 SELECTSINGLENODE Function
- 250.3.10 SETERRORLOG Procedure
- 250.3.11 SETPARAM Procedure
- 250.3.12 SHOWWARNINGS Procedure
- 250.3.13 TRANSFORMNODE Function
- 250.3.14 VALUEOF Function and Procedure
 
 
- 
               
               
                  
                  251
                       DBMS_XSTREAM_ADM
               
                  
               
               
               - 251.1 DBMS_XSTREAM_ADM Overview
- 251.2 DBMS_XSTREAM_ADM Security Model
- 251.3 DBMS_XSTREAM_ADM Operational Notes
- 
                     
                     
                        
                        251.4
                            Summary of DBMS_XSTREAM_ADM Subprograms
                     
                        
                     
                     
                     - 251.4.1 ADD_COLUMN Procedure
- 251.4.2 ADD_GLOBAL_PROPAGATION_RULES Procedure
- 251.4.3 ADD_GLOBAL_RULES Procedure
- 251.4.4 ADD_OUTBOUND Procedure
- 251.4.5 ADD_SCHEMA_PROPAGATION_RULES Procedure
- 251.4.6 ADD_SCHEMA_RULES Procedure
- 251.4.7 ADD_SUBSET_OUTBOUND_RULES Procedure
- 251.4.8 ADD_SUBSET_PROPAGATION_RULES Procedure
- 251.4.9 ADD_SUBSET_RULES Procedure
- 251.4.10 ADD_TABLE_PROPAGATION_RULES Procedure
- 251.4.11 ADD_TABLE_RULES Procedure
- 251.4.12 ALTER_INBOUND Procedure
- 251.4.13 ALTER_OUTBOUND Procedure
- 251.4.14 CREATE_INBOUND Procedure
- 251.4.15 CREATE_OUTBOUND Procedure
- 251.4.16 DELETE_COLUMN Procedure
- 251.4.17 DROP_INBOUND Procedure
- 251.4.18 DROP_OUTBOUND Procedure
- 251.4.19 ENABLE_GG_XSTREAM_FOR_STREAMS Procedure
- 251.4.20 GET_MESSAGE_TRACKING Function
- 251.4.21 GET_TAG Function
- 251.4.22 IS_GG_XSTREAM_FOR_STREAMS Function
- 251.4.23 KEEP_COLUMNS Procedure
- 251.4.24 MERGE_STREAMS Procedure
- 251.4.25 MERGE_STREAMS_JOB Procedure
- 251.4.26 PURGE_SOURCE_CATALOG Procedure
- 251.4.27 RECOVER_OPERATION Procedure
- 251.4.28 REMOVE_QUEUE Procedure
- 251.4.29 REMOVE_RULE Procedure
- 251.4.30 REMOVE_SUBSET_OUTBOUND_RULES Procedure
- 251.4.31 REMOVE_XSTREAM_CONFIGURATION Procedure
- 251.4.32 RENAME_COLUMN Procedure
- 251.4.33 RENAME_SCHEMA Procedure
- 251.4.34 RENAME_TABLE Procedure
- 251.4.35 SET_MESSAGE_TRACKING Procedure
- 251.4.36 SET_PARAMETER Procedure
- 251.4.37 SET_TAG Procedure
- 251.4.38 SET_UP_QUEUE Procedure
- 251.4.39 SPLIT_STREAMS Procedure
- 251.4.40 START_OUTBOUND Procedure
- 251.4.41 STOP_OUTBOUND Procedure
 
 
- 252 DEBUG_EXTPROC
- 
               
               
                  
                  253
                       HTF
               
                  
               
               
               - 253.1 HTF Deprecated Subprograms
- 253.2 HTF Operational Notes
- 253.3 Rules and Limits
- 253.4 HTF Examples
- 253.5 Summary of Tags
- 
                     
                     
                        
                        253.6
                            Summary of HTF Subprograms
                     
                        
                     
                     
                     - 253.6.1 ADDRESS Function
- 253.6.2 ANCHOR Function
- 253.6.3 ANCHOR2 Function
- 253.6.4 APPLETCLOSE Function
- 253.6.5 APPLETOPEN Function
- 253.6.6 AREA Function
- 253.6.7 BASE Function
- 253.6.8 BASEFONT Function
- 253.6.9 BGSOUND Function
- 253.6.10 BIG Function
- 253.6.11 BLOCKQUOTECLOSE Function
- 253.6.12 BLOCKQUOTEOPEN Function
- 253.6.13 BODYCLOSE Function
- 253.6.14 BODYOPEN Function
- 253.6.15 BOLD Function
- 253.6.16 BR Function
- 253.6.17 CENTER Function
- 253.6.18 CENTERCLOSE Function
- 253.6.19 CENTEROPEN Function
- 253.6.20 CITE Function
- 253.6.21 CODE Function
- 253.6.22 COMMENT Function
- 253.6.23 DFN Function
- 253.6.24 DIRLISTCLOSE Function
- 253.6.25 DIRLISTOPEN Function
- 253.6.26 DIV Function
- 253.6.27 DLISTCLOSE Function
- 253.6.28 DLISTDEF Function
- 253.6.29 DLISTOPEN Function
- 253.6.30 DLISTTERM Function
- 253.6.31 EM Function
- 253.6.32 EMPHASIS Function
- 253.6.33 ESCAPE_SC Function
- 253.6.34 ESCAPE_URL Function
- 253.6.35 FONTCLOSE Function
- 253.6.36 FONTOPEN Function
- 253.6.37 FORMAT_CELL Function
- 253.6.38 FORMCHECKBOX Function
- 253.6.39 FORMCLOSE Function
- 253.6.40 FORMFILE Function
- 253.6.41 FORMHIDDEN Function
- 253.6.42 FORMIMAGE Function
- 253.6.43 FORMOPEN Function
- 253.6.44 FORMPASSWORD Function
- 253.6.45 FORMRADIO Function
- 253.6.46 FORMRESET Function
- 253.6.47 FORMSELECTCLOSE Function
- 253.6.48 FORMSELECTOPEN Function
- 253.6.49 FORMSELECTOPTION Function
- 253.6.50 FORMSUBMIT Function
- 253.6.51 FORMTEXT Function
- 253.6.52 FORMTEXTAREA Function
- 253.6.53 FORMTEXTAREA2 Function
- 253.6.54 FORMTEXTAREACLOSE Function
- 253.6.55 FORMTEXTAREAOPEN Function
- 253.6.56 FORMTEXTAREAOPEN2 Function
- 253.6.57 FRAME Function
- 253.6.58 FRAMESETCLOSE Function
- 253.6.59 FRAMESETOPEN Function
- 253.6.60 HEADCLOSE Function
- 253.6.61 HEADER Function
- 253.6.62 HEADOPEN Function
- 253.6.63 HR Function
- 253.6.64 HTMLCLOSE Function
- 253.6.65 HTMLOPEN Function
- 253.6.66 IMG Function
- 253.6.67 IMG2 Function
- 253.6.68 ISINDEX Function
- 253.6.69 ITALIC Function
- 253.6.70 KBD Function
- 253.6.71 KEYBOARD Function
- 253.6.72 LINE Function
- 253.6.73 LINKREL Function
- 253.6.74 LINKREV Function
- 253.6.75 LISTHEADER Function
- 253.6.76 LISTINGCLOSE Function
- 253.6.77 LISTINGOPEN Function
- 253.6.78 LISTITEM Function
- 253.6.79 MAILTO Function
- 253.6.80 MAPCLOSE Function
- 253.6.81 MAPOPEN Function
- 253.6.82 MENULISTCLOSE Function
- 253.6.83 MENULISTOPEN Function
- 253.6.84 META Function
- 253.6.85 NL Function
- 253.6.86 NOBR Function
- 253.6.87 NOFRAMESCLOSE Function
- 253.6.88 NOFRAMESOPEN Function
- 253.6.89 OLISTCLOSE Function
- 253.6.90 OLISTOPEN Function
- 253.6.91 PARA Function
- 253.6.92 PARAGRAPH Function
- 253.6.93 PARAM Function
- 253.6.94 PLAINTEXT Function
- 253.6.95 PRECLOSE Function
- 253.6.96 PREOPEN Function
- 253.6.97 PRINT Functions
- 253.6.98 PRN Functions
- 253.6.99 S Function
- 253.6.100 SAMPLE Function
- 253.6.101 SCRIPT Function
- 253.6.102 SMALL Function
- 253.6.103 STRIKE Function
- 253.6.104 STRONG Function
- 253.6.105 STYLE Function
- 253.6.106 SUB Function
- 253.6.107 SUP Function
- 253.6.108 TABLECAPTION Function
- 253.6.109 TABLECLOSE Function
- 253.6.110 TABLEDATA Function
- 253.6.111 TABLEHEADER Function
- 253.6.112 TABLEOPEN Function
- 253.6.113 TABLEROWCLOSE Function
- 253.6.114 TABLEROWOPEN Function
- 253.6.115 TELETYPE Function
- 253.6.116 TITLE Function
- 253.6.117 ULISTCLOSE Function
- 253.6.118 ULISTOPEN Function
- 253.6.119 UNDERLINE Function
- 253.6.120 VARIABLE Function
- 253.6.121 WBR Function
 
 
- 
               
               
                  
                  254
                       HTP
               
                  
               
               
               - 254.1 HTP Operational Notes
- 254.2 HTP Rules and Limits
- 254.3 HTP Examples
- 254.4 HTP Summary of Tags
- 
                     
                     
                        
                        254.5
                            Summary of HTP Subprograms
                     
                        
                     
                     
                     - 254.5.1 ADDRESS Procedure
- 254.5.2 ANCHOR Procedure
- 254.5.3 ANCHOR2 Procedure
- 254.5.4 APPLETCLOSE Procedure
- 254.5.5 APPLETOPEN Procedure
- 254.5.6 AREA Procedure
- 254.5.7 BASE Procedure
- 254.5.8 BASEFONT Procedure
- 254.5.9 BGSOUND Procedure
- 254.5.10 BIG Procedure
- 254.5.11 BLOCKQUOTECLOSE Procedure
- 254.5.12 BLOCKQUOTEOPEN Procedure
- 254.5.13 BODYCLOSE Procedure
- 254.5.14 BODYOPEN Procedure
- 254.5.15 BOLD Procedure
- 254.5.16 BR Procedure
- 254.5.17 CENTER Procedure
- 254.5.18 CENTERCLOSE Procedure
- 254.5.19 CENTEROPEN Procedure
- 254.5.20 CITE Procedure
- 254.5.21 CODE Procedure
- 254.5.22 COMMENT Procedure
- 254.5.23 DFN Procedure
- 254.5.24 DIRLISTCLOSE Procedure
- 254.5.25 DIRLISTOPEN Procedure
- 254.5.26 DIV Procedure
- 254.5.27 DLISTCLOSE Procedure
- 254.5.28 DLISTDEF Procedure
- 254.5.29 DLISTOPEN Procedure
- 254.5.30 DLISTTERM Procedure
- 254.5.31 EM Procedure
- 254.5.32 EMPHASIS Procedure
- 254.5.33 ESCAPE_SC Procedure
- 254.5.34 FONTCLOSE Procedure
- 254.5.35 FONTOPEN Procedure
- 254.5.36 FORMCHECKBOX Procedure
- 254.5.37 FORMCLOSE Procedure
- 254.5.38 FORMOPEN Procedure
- 254.5.39 FORMFILE Procedure
- 254.5.40 FORMHIDDEN Procedure
- 254.5.41 FORMIMAGE Procedure
- 254.5.42 FORMPASSWORD Procedure
- 254.5.43 FORMRADIO Procedure
- 254.5.44 FORMRESET Procedure
- 254.5.45 FORMSELECTCLOSE Procedure
- 254.5.46 FORMSELECTOPEN Procedure
- 254.5.47 FORMSELECTOPTION Procedure
- 254.5.48 FORMSUBMIT Procedure
- 254.5.49 FORMTEXT Procedure
- 254.5.50 FORMTEXTAREA Procedure
- 254.5.51 FORMTEXTAREA2 Procedure
- 254.5.52 FORMTEXTAREACLOSE Procedure
- 254.5.53 FORMTEXTAREAOPEN Procedure
- 254.5.54 FORMTEXTAREAOPEN2 Procedure
- 254.5.55 FRAME Procedure
- 254.5.56 FRAMESETCLOSE Procedure
- 254.5.57 FRAMESETOPEN Procedure
- 254.5.58 HEADCLOSE Procedure
- 254.5.59 HEADER Procedure
- 254.5.60 HEADOPEN Procedure
- 254.5.61 HR Procedure
- 254.5.62 HTMLCLOSE Procedure
- 254.5.63 HTMLOPEN Procedure
- 254.5.64 IMG Procedure
- 254.5.65 IMG2 Procedure
- 254.5.66 ISINDEX Procedure
- 254.5.67 ITALIC Procedure
- 254.5.68 KBD Procedure
- 254.5.69 KEYBOARD Procedure
- 254.5.70 LINE Procedure
- 254.5.71 LINKREL Procedure
- 254.5.72 LINKREV Procedure
- 254.5.73 LISTHEADER Procedure
- 254.5.74 LISTINGCLOSE Procedure
- 254.5.75 LISTINGOPEN Procedure
- 254.5.76 LISTITEM Procedure
- 254.5.77 MAILTO Procedure
- 254.5.78 MAPCLOSE Procedure
- 254.5.79 MAPOPEN Procedure
- 254.5.80 MENULISTCLOSE Procedure
- 254.5.81 MENULISTOPEN Procedure
- 254.5.82 META Procedure
- 254.5.83 NL Procedure
- 254.5.84 NOBR Procedure
- 254.5.85 NOFRAMESCLOSE Procedure
- 254.5.86 NOFRAMESOPEN Procedure
- 254.5.87 OLISTCLOSE Procedure
- 254.5.88 OLISTOPEN Procedure
- 254.5.89 PARA Procedure
- 254.5.90 PARAGRAPH Procedure
- 254.5.91 PARAM Procedure
- 254.5.92 PLAINTEXT Procedure
- 254.5.93 PRECLOSE Procedure
- 254.5.94 PREOPEN Procedure
- 254.5.95 PRINT Procedures
- 254.5.96 PRINTS Procedure
- 254.5.97 PRN Procedures
- 254.5.98 PS Procedure
- 254.5.99 S Procedure
- 254.5.100 SAMPLE Procedure
- 254.5.101 SCRIPT Procedure
- 254.5.102 SMALL Procedure
- 254.5.103 STRIKE Procedure
- 254.5.104 STRONG Procedure
- 254.5.105 STYLE Procedure
- 254.5.106 SUB Procedure
- 254.5.107 SUP Procedure
- 254.5.108 TABLECAPTION Procedure
- 254.5.109 TABLECLOSE Procedure
- 254.5.110 TABLEDATA Procedure
- 254.5.111 TABLEHEADER Procedure
- 254.5.112 TABLEOPEN Procedure
- 254.5.113 TABLEROWCLOSE Procedure
- 254.5.114 TABLEROWOPEN Procedure
- 254.5.115 TELETYPE Procedure
- 254.5.116 TITLE Procedure
- 254.5.117 ULISTCLOSE Procedure
- 254.5.118 ULISTOPEN Procedure
- 254.5.119 UNDERLINE Procedure
- 254.5.120 VARIABLE Procedure
- 254.5.121 WBR Procedure
 
 
- 255 OWA_CACHE
- 256 OWA_COOKIE
- 257 OWA_CUSTOM
- 258 OWA_IMAGE
- 259 OWA_OPT_LOCK
- 260 OWA_PATTERN
- 261 OWA_SEC
- 262 OWA_TEXT
- 
               
               
                  
                  263
                       OWA_UTIL
               
                  
               
               
               - 263.1 OWA_UTIL Overview
- 263.2 OWA_UTIL Types
- 
                     
                     
                        
                        263.3
                            Summary of OWA_UTIL Subprograms
                     
                        
                     
                     
                     - 263.3.1 BIND_VARIABLES Function
- 263.3.2 CALENDARPRINT Procedures
- 263.3.3 CELLSPRINT Procedures
- 263.3.4 CHOOSE_DATE Procedure
- 263.3.5 GET_CGI_ENV Function
- 263.3.6 GET_OWA_SERVICE_PATH Function
- 263.3.7 GET_PROCEDURE Function
- 263.3.8 HTTP_HEADER_CLOSE Procedure
- 263.3.9 LISTPRINT Procedure
- 263.3.10 MIME_HEADER Procedure
- 263.3.11 PRINT_CGI_ENV Procedure
- 263.3.12 REDIRECT_URL Procedure
- 263.3.13 SHOWPAGE Procedure
- 263.3.14 SHOWSOURCE Procedure
- 263.3.15 SIGNATURE procedure
- 263.3.16 STATUS_LINE Procedure
- 263.3.17 TABLEPRINT Function
- 263.3.18 TODATE Function
- 263.3.19 WHO_CALLED_ME Procedure
 
 
- 264 SDO_CS
- 265 SDO_CSW_PROCESS
- 266 SDO_GCDR
- 267 SDO_GEOM
- 268 SDO_GEOR
- 269 SDO_GEOR_ADMIN
- 270 SDO_GEOR_AGGR
- 271 SDO_GEOR_RA
- 272 SDO_GEOR_UTL
- 273 SDO_LRS
- 274 SDO_MIGRATE
- 275 SDO_NET
- 276 SDO_NFE
- 277 SDO_OLS
- 278 SDO_PC_PKG
- 279 SDO_SAM
- 280 SDO_TIN_PKG
- 281 SDO_TOPO
- 282 SDO_TOPO_MAP
- 283 SDO_TUNE
- 284 SDO_UTIL
- 285 SDO_WFS_LOCK
- 286 SDO_WFS_PROCESS
- 287 SEM_APIS
- 288 SEM_OLS
- 289 SEM_PERF
- 290 SEM_RDFCTX
- 291 SEM_RDFSA
- 
               
               
                  
                  292
                       UTL_CALL_STACK 
               
                  
               
               
               - 292.1 UTL_CALL_STACK Overview
- 292.2 UTL_CALL_STACK Security Model
- 292.3 UTL_CALL_STACK Operational Notes
- 292.4 UTL_CALL_STACK Exceptions
- 292.5 UTL_CALL_STACK Data Structures
- 
                     
                     
                        
                        292.6
                            Summary of UTL_CALL_STACK Subprograms
                     
                        
                     
                     
                     - 292.6.1 BACKTRACE_DEPTH Function
- 292.6.2 BACKTRACE_LINE Function
- 292.6.3 BACKTRACE_UNIT Function
- 292.6.4 CURRENT_EDITION Function
- 292.6.5 CONCATENATE_SUBPROGRAM Function
- 292.6.6 DYNAMIC_DEPTH Function
- 292.6.7 ERROR_DEPTH Function
- 292.6.8 ERROR_MSG Function
- 292.6.9 ERROR_NUMBER Function
- 292.6.10 LEXICAL_DEPTH Function
- 292.6.11 OWNER Function
- 292.6.12 UNIT_LINE Function
- 292.6.13 SUBPROGRAM Function
 
 
- 293 UTL_COLL
- 
               
               
                  
                  294
                       UTL_COMPRESS
               
                  
               
               
               - 294.1 UTL_COMPRESS Constants
- 294.2 UTL_COMPRESS Exceptions
- 294.3 UTL_COMPRESS Operational Notes
- 
                     
                     
                        
                        294.4
                            Summary of UTL_COMPRESS Subprograms
                     
                        
                     
                     
                     - 294.4.1 ISOPEN Function
- 294.4.2 LZ_COMPRESS Functions and Procedures
- 294.4.3 LZ_COMPRESS_ADD Procedure
- 294.4.4 LZ_COMPRESS_CLOSE
- 294.4.5 LZ_COMPRESS_OPEN
- 294.4.6 LZ_UNCOMPRESS Functions and Procedures
- 294.4.7 LZ_UNCOMPRESS_EXTRACT Procedure
- 294.4.8 LZ_UNCOMPRESS_OPEN Function
- 294.4.9 LZ_UNCOMPRESS_CLOSE Procedure
 
 
- 
               
               
                  
                  295
                       UTL_ENCODE 
               
                  
               
               
               - 
                     
                     
                        
                        295.1
                            Summary of UTL_ENCODE Subprograms
                     
                        
                     
                     
                     - 295.1.1 BASE64_DECODE Function
- 295.1.2 BASE64_ENCODE Function
- 295.1.3 MIMEHEADER_DECODE Function
- 295.1.4 MIMEHEADER_ENCODE Function
- 295.1.5 QUOTED_PRINTABLE_DECODE Function
- 295.1.6 QUOTED_PRINTABLE_ENCODE Function
- 295.1.7 TEXT_DECODE Function
- 295.1.8 TEXT_ENCODE Function
- 295.1.9 UUDECODE Function
- 295.1.10 UUENCODE Function
 
 
- 
                     
                     
                        
                        295.1
                            Summary of UTL_ENCODE Subprograms
                     
                        
                     
                     
                     
- 
               
               
                  
                  296
                       UTL_FILE
               
                  
               
               
               - 296.1 UTL_FILE Security Model
- 296.2 UTL_FILE Operational Notes
- 296.3 UTL_FILE Rules and Limits
- 296.4 UTL_FILE Exceptions
- 296.5 UTL_FILE Examples
- 296.6 UTL_FILE Data Structures
- 
                     
                     
                        
                        296.7
                            Summary of UTL_FILE Subprograms
                     
                        
                     
                     
                     - 296.7.1 FCLOSE Procedure
- 296.7.2 FCLOSE_ALL Procedure
- 296.7.3 FCOPY Procedure
- 296.7.4 FFLUSH Procedure
- 296.7.5 FGETATTR Procedure
- 296.7.6 FGETPOS Function
- 296.7.7 FOPEN Function
- 296.7.8 FOPEN_NCHAR Function
- 296.7.9 FREMOVE Procedure
- 296.7.10 FRENAME Procedure
- 296.7.11 FSEEK Procedure
- 296.7.12 GET_LINE Procedure
- 296.7.13 GET_LINE_NCHAR Procedure
- 296.7.14 GET_RAW Procedure
- 296.7.15 IS_OPEN Function
- 296.7.16 NEW_LINE Procedure
- 296.7.17 PUT Procedure
- 296.7.18 PUT_LINE Procedure
- 296.7.19 PUT_LINE_NCHAR Procedure
- 296.7.20 PUT_NCHAR Procedure
- 296.7.21 PUTF Procedure
- 296.7.22 PUTF_NCHAR Procedure
- 296.7.23 PUT_RAW Procedure
 
 
- 
               
               
                  
                  297
                       UTL_HTTP
               
                  
               
               
               - 297.1 UTL_HTTP Overview
- 297.2 UTL_HTTP Security Model
- 297.3 UTL_HTTP Constants
- 297.4 UTL_HTTP Exceptions
- 
                     
                     
                        
                        297.5
                            UTL_HTTP Examples
                     
                        
                     
                     
                     - 297.5.1 UTL_HTTP General Usage
- 297.5.2 UTL_HTTP Retrieving HTTP Response Headers
- 297.5.3 UTL_HTTP Handling HTTP Authentication
- 297.5.4 UTL_HTTP Handling HTTP Digest Authentication
- 297.5.5 UTL_HTTP Retrieving and Restoring Cookies
- 297.5.6 UTL_HTTP Making HTTP Request with Private Wallet and Cookie Table
- 297.5.7 UTL_HTTP Using a Proxy Server
 
- 297.6 UTL_HTTP Data Structures
- 
                     
                     
                        
                        297.7
                            UTL_HTTP Operations
                     
                        
                     
                     
                     - 297.7.1 UTL_HTTP Operational Flow
- 297.7.2 UTL_HTTP Simple HTTP Fetches
- 297.7.3 UTL_HTTP HTTP Requests
- 297.7.4 UTL_HTTP HTTP Responses
- 297.7.5 UTL_HTTP HTTP Cookies
- 297.7.6 UTL_HTTP HTTP Persistent Connections
- 297.7.7 UTL_HTTP Error Conditions
- 297.7.8 UTL_HTTP Session Settings
- 297.7.9 UTL_HTTP Request Context
- 297.7.10 UTL_HTTP External Password Store
 
- 
                     
                     
                        
                        297.8
                            UTL_HTTP Subprogram Groups
                     
                        
                     
                     
                     - 297.8.1 UTL_HTTP Simple HTTP Fetches in a Single Call Subprograms
- 297.8.2 UTL_HTTP Session Settings Subprograms
- 297.8.3 UTL_HTTP HTTP Requests Subprograms
- 297.8.4 UTL_HTTP HTTP Request Contexts Subprograms
- 297.8.5 UTL_HTTP HTTP Responses Subprograms
- 297.8.6 UTL_HTTP HTTP Cookies Subprograms
- 297.8.7 UTL_HTTP HTTP Persistent Connections Subprograms
- 297.8.8 UTL_HTTP Error Conditions Subprograms
 
- 
                     
                     
                        
                        297.9
                            Summary of UTL_HTTP Subprograms
                     
                        
                     
                     
                     - 297.9.1 ADD_COOKIES Procedure
- 297.9.2 BEGIN_REQUEST Function
- 297.9.3 CLEAR_COOKIES Procedure
- 297.9.4 CLOSE_PERSISTENT_CONN Procedure
- 297.9.5 CLOSE_PERSISTENT_CONNS Procedure
- 297.9.6 CREATE_REQUEST_CONTEXT Function
- 297.9.7 DESTROY_REQUEST_CONTEXT Procedure
- 297.9.8 END_REQUEST Procedure
- 297.9.9 END_RESPONSE Procedure
- 297.9.10 GET_AUTHENTICATION Procedure
- 297.9.11 GET_BODY_CHARSET Procedure
- 297.9.12 GET_COOKIE_COUNT Function
- 297.9.13 GET_COOKIE_SUPPORT Procedure
- 297.9.14 GET_COOKIES Function
- 297.9.15 GET_DETAILED_EXCP_SUPPORT Procedure
- 297.9.16 GET_DETAILED_SQLCODE Function
- 297.9.17 GET_DETAILED_SQLERRM Function
- 297.9.18 GET_FOLLOW_REDIRECT Procedure
- 297.9.19 GET_HEADER Procedure
- 297.9.20 GET_HEADER_BY_NAME Procedure
- 297.9.21 GET_HEADER_COUNT Function
- 297.9.22 GET_PERSISTENT_CONN_COUNT Function
- 297.9.23 GET_PERSISTENT_CONN_SUPPORT Procedure
- 297.9.24 GET_PERSISTENT_CONNS Procedure
- 297.9.25 GET_PROXY Procedure
- 297.9.26 GET_RESPONSE Function
- 297.9.27 GET_RESPONSE_ERROR_CHECK Procedure
- 297.9.28 GET_TRANSFER_TIMEOUT Procedure
- 297.9.29 READ_LINE Procedure
- 297.9.30 READ_RAW Procedure
- 297.9.31 READ_TEXT Procedure
- 297.9.32 REQUEST Function
- 297.9.33 REQUEST_PIECES Function
- 297.9.34 SET_AUTHENTICATION Procedure
- 297.9.35 SET_AUTHENTICATION_FROM_WALLET Procedure
- 297.9.36 SET_BODY_CHARSET Procedures
- 297.9.37 SET_COOKIE_SUPPORT Procedures
- 297.9.38 SET_DETAILED_EXCP_SUPPORT Procedure
- 297.9.39 SET_FOLLOW_REDIRECT Procedures
- 297.9.40 SET_HEADER Procedure
- 297.9.41 SET_PERSISTENT_CONN_SUPPORT Procedure
- 297.9.42 SET_PROXY Procedure
- 297.9.43 SET_RESPONSE_ERROR_CHECK Procedure
- 297.9.44 SET_TRANSFER_TIMEOUT Procedure
- 297.9.45 SET_WALLET Procedure
- 297.9.46 WRITE_LINE Procedure
- 297.9.47 WRITE_RAW Procedure
- 297.9.48 WRITE_TEXT Procedure
 
 
- 
               
               
                  
                  298
                       UTL_I18N
               
                  
               
               
               - 298.1 UTL_I18N Overview
- 298.2 UTL_I18N Security Model
- 298.3 UTL_I18N Constants
- 298.4 UTL_I18N Data Structures
- 
                     
                     
                        
                        298.5
                            Summary of UTL_I18N Subprograms
                     
                        
                     
                     
                     - 298.5.1 DETECT_CHARSET Procedure
- 298.5.2 DETECT_LANGUAGE Procedure
- 298.5.3 DETECT_LANGUAGE_CHARSET Procedure
- 298.5.4 ESCAPE_REFERENCE Function
- 298.5.5 GET_COMMON_TIME_ZONES Function
- 298.5.6 GET_DEFAULT_CHARSET Function
- 298.5.7 GET_DEFAULT_ISO_CURRENCY Function
- 298.5.8 GET_DEFAULT_LINGUISTIC_SORT Function
- 298.5.9 GET_LOCAL_LANGUAGES Function
- 298.5.10 GET_LOCAL_LINGUISTIC_SORTS Function
- 298.5.11 GET_LOCAL_TERRITORIES Function
- 298.5.12 GET_LOCAL_TIME_ZONES Function
- 298.5.13 GET_MAX_CHARACTER_SIZE Function
- 298.5.14 GET_TRANSLATION Function
- 298.5.15 MAP_CHARSET Function
- 298.5.16 MAP_FROM_SHORT_LANGUAGE Function
- 298.5.17 MAP_LANGUAGE_FROM_ISO Function
- 298.5.18 MAP_LOCALE_TO_ISO Function
- 298.5.19 MAP_TERRITORY_FROM_ISO Function
- 298.5.20 MAP_TO_SHORT_LANGUAGE Function
- 298.5.21 RAW_TO_CHAR Functions
- 298.5.22 RAW_TO_NCHAR Functions
- 298.5.23 STRING_TO_RAW Function
- 298.5.24 TRANSLITERATE Function
- 298.5.25 UNESCAPE_REFERENCE Function
- 298.5.26 VALIDATE_CHARACTER_ENCODING Functions
 
 
- 299 UTL_IDENT
- 300 UTL_INADDR
- 301 UTL_LMS
- 302 UTL_MAIL
- 303 UTL_MATCH
- 
               
               
                  
                  304
                       UTL_NLA
               
                  
               
               
               - 304.1 UTL_NLA Overview
- 304.2 UTL_NLA Rules and Limits
- 304.3 UTL_NLA Security Model
- 
                     
                     
                        
                        304.4
                            Subprogram Groups
                     
                        
                     
                     
                     - 304.4.1 UTL_NLA BLAS Level 1 (Vector-Vector Operations) Subprograms
- 304.4.2 UTL_NLA BLAS Level 2 (Matrix-Vector Operations) Subprograms
- 304.4.3 UTL_NLA BLAS Level 3 (Matrix-Matrix Operations) Subprograms
- 304.4.4 UTL_NLA LAPACK Driver Routines (Linear Equations) Subprograms
- 304.4.5 UTL_NLA LAPACK Driver Routines (LLS and Eigenvalue Problems) Subprograms
 
- 
                     
                     
                        
                        304.5
                            Summary of UTL_NLA Subprograms
                     
                        
                     
                     
                     - 304.5.1 BLAS_ASUM Functions
- 304.5.2 BLAS_AXPY Procedures
- 304.5.3 BLAS_COPY Procedures
- 304.5.4 BLAS_DOT Functions
- 304.5.5 BLAS_GBMV Procedures
- 304.5.6 BLAS_GEMM Procedures
- 304.5.7 BLAS_GEMV Procedures
- 304.5.8 BLAS_GER Procedures
- 304.5.9 BLAS_IAMAX Functions
- 304.5.10 BLAS_NRM2 Functions
- 304.5.11 BLAS_ROT Procedures
- 304.5.12 BLAS_ROTG Procedures
- 304.5.13 BLAS_SCAL Procedures
- 304.5.14 BLAS_SPMV Procedures
- 304.5.15 BLAS_SPR Procedures
- 304.5.16 BLAS_SPR2 Procedures
- 304.5.17 BLAS_SBMV Procedures
- 304.5.18 BLAS_SWAP Procedures
- 304.5.19 BLAS_SYMM Procedures
- 304.5.20 BLAS_SYMV Procedures
- 304.5.21 BLAS_SYR Procedures
- 304.5.22 BLAS_SYR2 Procedures
- 304.5.23 BLAS_SYR2K Procedures
- 304.5.24 BLAS_SYRK Procedures
- 304.5.25 BLAS_TBMV Procedures
- 304.5.26 BLAS_TBSV Procedures
- 304.5.27 BLAS_TPMV Procedures
- 304.5.28 BLAS_TPSV Procedures
- 304.5.29 BLAS_TRMM Procedures
- 304.5.30 BLAS_TRMV Procedures
- 304.5.31 BLAS_TRSM Procedures
- 304.5.32 BLAS_TRSV Procedures
- 304.5.33 LAPACK_GBSV Procedures
- 304.5.34 LAPACK_GEES Procedures
- 304.5.35 LAPACK_GELS Procedures
- 304.5.36 LAPACK_GESDD Procedures
- 304.5.37 LAPACK_GESV Procedure
- 304.5.38 LAPACK_GESVD Procedures
- 304.5.39 LAPACK_GEEV Procedures
- 304.5.40 LAPACK_GTSV Procedure
- 304.5.41 LAPACK_PBSV Procedures
- 304.5.42 LAPACK_POSV Procedures
- 304.5.43 LAPACK_PPSV Procedures
- 304.5.44 LAPACK_PTSV Procedures
- 304.5.45 LAPACK_SBEV Procedures
- 304.5.46 LAPACK_SBEVD Procedures
- 304.5.47 LAPACK_SPEV Procedures
- 304.5.48 LAPACK_SPEVD Procedures
- 304.5.49 LAPACK_SPSV Procedures
- 304.5.50 LAPACK_STEV Procedures
- 304.5.51 LAPACK_STEVD Procedures
- 304.5.52 LAPACK_SYEV Procedures
- 304.5.53 LAPACK_SYEVD Procedures
- 304.5.54 LAPACK_SYSV Procedures
 
 
- 
               
               
                  
                  305
                       UTL_RAW
               
                  
               
               
               - 305.1 UTL_RAW Overview
- 305.2 UTL_RAW Operational Notes
- 
                     
                     
                        
                        305.3
                            Summary of UTL_RAW Subprograms
                     
                        
                     
                     
                     - 305.3.1 BIT_AND Function
- 305.3.2 BIT_COMPLEMENT Function
- 305.3.3 BIT_OR Function
- 305.3.4 BIT_XOR Function
- 305.3.5 CAST_FROM_BINARY_DOUBLE Function
- 305.3.6 CAST_FROM_BINARY_FLOAT Function
- 305.3.7 CAST_FROM_BINARY_INTEGER Function
- 305.3.8 CAST_FROM_NUMBER Function
- 305.3.9 CAST_TO_BINARY_DOUBLE Function
- 305.3.10 CAST_TO_BINARY_FLOAT Function
- 305.3.11 CAST_TO_BINARY_INTEGER Function
- 305.3.12 CAST_TO_NUMBER Function
- 305.3.13 CAST_TO_NVARCHAR2 Function
- 305.3.14 CAST_TO_RAW Function
- 305.3.15 CAST_TO_VARCHAR2 Function
- 305.3.16 COMPARE Function
- 305.3.17 CONCAT Function
- 305.3.18 CONVERT Function
- 305.3.19 COPIES Function
- 305.3.20 LENGTH Function
- 305.3.21 OVERLAY Function
- 305.3.22 REVERSE Function
- 305.3.23 SUBSTR Function
- 305.3.24 TRANSLATE Function
- 305.3.25 TRANSLITERATE Function
- 305.3.26 XRANGE Function
 
 
- 306 UTL_RECOMP
- 307 UTL_REF
- 308 UTL_RPADV
- 
               
               
                  
                  309
                       UTL_SMTP
               
                  
               
               
               - 309.1 UTL_SMTP Overview
- 309.2 UTL_SMTP Security Model
- 309.3 UTL_SMTP Constants
- 309.4 UTL_SMTP Types
- 309.5 UTL_SMTP Reply Codes
- 309.6 UTL_SMTP Operational Notes
- 309.7 UTL_SMTP Exceptions
- 309.8 UTL_SMTP Rules and Limits
- 309.9 UTL_SMTP Examples
- 
                     
                     
                        
                        309.10
                            Summary of UTL_SMTP Subprograms
                     
                        
                     
                     
                     - 309.10.1 AUTH Function and Procedure
- 309.10.2 CLOSE_CONNECTION Procedure
- 309.10.3 CLOSE_DATA Function and Procedure
- 309.10.4 COMMAND Function and Procedure
- 309.10.5 COMMAND_REPLIES Function
- 309.10.6 DATA Function and Procedure
- 309.10.7 EHLO Function and Procedure
- 309.10.8 HELO Function and Procedure
- 309.10.9 HELP Function
- 309.10.10 MAIL Function and Procedure
- 309.10.11 NOOP Function and Procedure
- 309.10.12 OPEN_CONNECTION Functions
- 309.10.13 OPEN_DATA Function and Procedure
- 309.10.14 QUIT Function and Procedure
- 309.10.15 RCPT Function
- 309.10.16 RSET Function and Procedure
- 309.10.17 STARTTLS Function and Procedure
- 309.10.18 VRFY Function
- 309.10.19 WRITE_DATA Procedure
- 309.10.20 WRITE_RAW_DATA Procedure
 
 
- 
               
               
                  
                  310
                       UTL_TCP
               
                  
               
               
               - 310.1 UTL_TCP Overview
- 310.2 UTL_TCP Security Model
- 310.3 UTL_TCP Types
- 310.4 UTL_TCP Exceptions
- 310.5 UTL_TCP Rules and Limits
- 310.6 UTL_TCP Examples
- 
                     
                     
                        
                        310.7
                            Summary of UTL_TCP Subprograms
                     
                        
                     
                     
                     - 310.7.1 AVAILABLE Function
- 310.7.2 CLOSE_ALL_CONNECTIONS Procedure
- 310.7.3 CLOSE_CONNECTION Procedure
- 310.7.4 FLUSH Procedure
- 310.7.5 GET_LINE Function
- 310.7.6 GET_LINE_NCHAR Function
- 310.7.7 GET_RAW Function
- 310.7.8 GET_TEXT Function
- 310.7.9 GET_TEXT_NCHAR Function
- 310.7.10 OPEN_CONNECTION Function
- 310.7.11 READ_LINE Function
- 310.7.12 READ_RAW Function
- 310.7.13 READ_TEXT Function
- 310.7.14 SECURE_CONNECTION Procedure
- 310.7.15 WRITE_LINE Function
- 310.7.16 WRITE_RAW Function
- 310.7.17 WRITE_TEXT Function
 
 
- 311 UTL_URL
- 312 WPG_DOCLOAD
- 313 ANYDATA TYPE
- 
               
               
                  
                  314
                       ANYDATASET TYPE
               
                  
               
               
               - 314.1 ANYDATASET TYPE Construction
- 
                     
                     
                        
                        314.2
                            Summary of ANYDATASET TYPE Subprograms 
                     
                        
                     
                     
                     - 314.2.1 ADDINSTANCE Member Procedure
- 314.2.2 BEGINCREATE Static Procedure
- 314.2.3 ENDCREATE Member Procedure
- 314.2.4 GET* Member Functions
- 314.2.5 GETCOUNT Member Function
- 314.2.6 GETINSTANCE Member Function
- 314.2.7 GETTYPE Member Function
- 314.2.8 GETTYPENAME Member Function
- 314.2.9 PIECEWISE Member Procedure
- 314.2.10 SET* Member Procedures
 
 
- 315 ANYTYPE TYPE
- 
               
               
                  
                  316
                      Oracle Database Advanced Queuing (AQ) Types
               
                  
               
               
               - 316.1 Advanced Queuing (AQ)Types Security Model
- 
                     
                     
                        
                        316.2
                            Oracle Database Advanced Queuing (AQ) Types —Summary of Types
                     
                        
                     
                     
                     - 316.2.1 AQ$_AGENT Type
- 316.2.2 AQ$_AGENT_LIST_T Type
- 316.2.3 AQ$_DESCRIPTOR Type
- 316.2.4 AQ$_NTFN_DESCRIPTOR Type
- 316.2.5 AQ$_NTFN_MSGID_ARRAY Type
- 316.2.6 AQ$_POST_INFO Type
- 316.2.7 AQ$_POST_INFO_LIST Type
- 316.2.8 AQ$_PURGE_OPTIONS_T Type
- 316.2.9 AQ$_RECIPIENT_LIST_T Type
- 316.2.10 AQ$_REG_INFO Type
- 316.2.11 AQ$_REG_INFO_LIST Type
- 316.2.12 AQ$_SUBSCRIBER_LIST_T Type
- 316.2.13 DEQUEUE_OPTIONS_T Type
- 316.2.14 ENQUEUE_OPTIONS_T Type
- 316.2.15 QUEUE_PROPS_T Type
- 316.2.16 SEEK_INPUT_T Type
- 316.2.17 SEEK_OUTPUT_T Type
- 316.2.18 SYS.MSG_PROP_T Type
- 316.2.19 MESSAGE_PROPERTIES_T Type
- 316.2.20 MESSAGE_PROPERTIES_ARRAY_T Type
- 316.2.21 MSGID_ARRAY_T Type
 
 
- 317 DBFS Content Interface Types
- 
               
               
                  
                  318
                      Database URI TYPEs 
               
                  
               
               
               - 318.1 Summary of URITYPE Supertype Subprograms
- 
                     
                     
                        
                        318.2
                            Summary of HTTPURITYPE Subtype Subprograms
                     
                        
                     
                     
                     - 318.2.1 HttpUriType Subtype CREATEURI
- 318.2.2 HttpUriType Subtype GETBLOB
- 318.2.3 HttpUriType Subtype GETCLOB
- 318.2.4 HttpUriType Subtype GETCONTENTTYPE
- 318.2.5 HttpUriType Subtype GETEXTERNALURL
- 318.2.6 HttpUriType Subtype GETURL
- 318.2.7 HttpUriType Subtype GETXML
- 318.2.8 HttpUriType Subtype HTTPURITYPE
 
- 318.3 Summary of DBURITYPE Subtype Subprogams
- 318.4 Summary of XDBURITYPE Subtype Subprograms
- 318.5 Summary of URIFACTORY Package Subprograms
 
- 
               
               
                  
                  319
                      JMS Types
               
                  
               
               
               - 319.1 JMS Types Overview
- 319.2 JMS Types Security Model
- 319.3 Java Versus PL/SQL Datatypes
- 319.4 More on Bytes, Stream and Map Messages
- 319.5 Upcasting and Downcasting Between General and Specific Messages
- 319.6 JMS Types Error Reporting
- 319.7 Oracle JMS Type Constants
- 319.8 CONVERT_JMS_SELECTOR
- 
                     
                     
                        
                        319.9
                            Summary of JMS Types
                     
                        
                     
                     
                     - 319.9.1 SYS.AQ$_JMS_MESSAGE Type
- 319.9.2 SYS.AQ$_JMS_TEXT_MESSAGE Type
- 319.9.3 SYS.AQ$_JMS_BYTES_MESSAGE Type
- 319.9.4 SYS.AQ$_JMS_MAP_MESSAGE Type
- 319.9.5 SYS.AQ$_JMS_STREAM_MESSAGE Type
- 319.9.6 SYS.AQ$_JMS_OBJECT_MESSAGE Type
- 319.9.7 SYS.AQ$_JMS_NAMEARRAY Type
- 319.9.8 SYS.AQ$_JMS_VALUE Type
- 319.9.9 SYS.AQ$_JMS_EXCEPTION Type
 
 
- 320 JSON Data Structures
- 321 Logical Change Record TYPEs
- 322 MGD_ID Package Types
- 
               
               
                  
                  323
                      Rule TYPEs
               
                  
               
               
               - 323.1 Rule TYPEs Overview
- 323.2 Rule TYPEs Security Model
- 
                     
                     
                        
                        323.3
                            Summary of Rule Types
                     
                        
                     
                     
                     - 323.3.1 RE$ATTRIBUTE_VALUE Type
- 323.3.2 RE$ATTRIBUTE_VALUE_LIST Type
- 323.3.3 RE$COLUMN_VALUE Type
- 323.3.4 RE$COLUMN_VALUE_LIST Type
- 323.3.5 RE$NAME_ARRAY Type
- 323.3.6 RE$NV_ARRAY Type
- 323.3.7 RE$NV_LIST Type
- 323.3.8 RE$NV_NODE Type
- 323.3.9 RE$RULE_HIT Type
- 323.3.10 RE$RULE_HIT_LIST Type
- 323.3.11 RE$RULE_NAME Type
- 323.3.12 RE$RULE_NAME_LIST Type
- 323.3.13 RE$TABLE_ALIAS Type
- 323.3.14 RE$TABLE_ALIAS_LIST Type
- 323.3.15 RE$TABLE_VALUE Type
- 323.3.16 RE$TABLE_VALUE_LIST Type
- 323.3.17 RE$VALUE Type
- 323.3.18 RE$VALUE_LIST Type
- 323.3.19 RE$VARIABLE_TYPE Type
- 323.3.20 RE$VARIABLE_TYPE_LIST Type
- 323.3.21 RE$VARIABLE_VALUE Type
- 323.3.22 RE$VARIABLE_VALUE_LIST Type
 
 
- 
               
               
                  
                  324
                      SODA Types
               
                  
               
               
               - 324.1 SODA Types Overview
- 324.2 SODA Types Security Model
- 
                     
                     
                        
                        324.3
                            Summary of SODA Types
                     
                        
                     
                     
                     - 
                           
                           
                              
                              324.3.1
                                  SODA_Collection_T Type
                           
                              
                           
                           
                           - 324.3.1.1 CREATE_INDEX Function
- 324.3.1.2 CREATE_VIEW_FROM_DG Function
- 324.3.1.3 DROP_INDEX Function
- 324.3.1.4 FIND Function
- 324.3.1.5 FIND_ONE Function
- 324.3.1.6 GET_DATA_GUIDE Function
- 324.3.1.7 GET_INDEX Function
- 324.3.1.8 GET_METADATA Function
- 324.3.1.9 GET_NAME Function
- 324.3.1.10 INSERT_ONE Function
- 324.3.1.11 INSERT_ONE_AND_GET Function
- 324.3.1.12 LIST_INDEXES Function
- 324.3.1.13 REMOVE_ONE Function
- 324.3.1.14 REPLACE_ONE Function
- 324.3.1.15 REPLACE_ONE_AND_GET Function
- 324.3.1.16 SAVE Function
- 324.3.1.17 SAVE_AND_GET Function
- 324.3.1.18 TRUNCATE Function
 
- 
                           
                           
                              
                              324.3.2
                                  SODA_Document_T Type
                           
                              
                           
                           
                           - 324.3.2.1 GET_BLOB Function
- 324.3.2.2 GET_CLOB Function
- 324.3.2.3 GET_CREATED_ON Function
- 324.3.2.4 GET_DATA_TYPE Function
- 324.3.2.5 GET_JSON Function
- 324.3.2.6 GET_KEY Function
- 324.3.2.7 GET_LAST_MODIFIED Function
- 324.3.2.8 GET_MEDIA_TYPE Function
- 324.3.2.9 GET_VARCHAR2 Function
- 324.3.2.10 GET_VERSION Function
- 324.3.2.11 SODA_Document_T Function
 
- 
                           
                           
                              
                              324.3.3
                                  SODA_OPERATION_T Type
                           
                              
                           
                           
                           - 324.3.3.1 ACQUIRE_LOCK Function
- 324.3.3.2 AS_OF_SCN Function
- 324.3.3.3 AS_OF_TIMESTAMP Function
- 324.3.3.4 COUNT Function
- 324.3.3.5 FILTER Function
- 324.3.3.6 GET_CURSOR Function
- 324.3.3.7 GET_DATA_GUIDE Function
- 324.3.3.8 GET_ONE Function
- 324.3.3.9 HINT Function
- 324.3.3.10 KEY Function
- 324.3.3.11 KEYS Function
- 324.3.3.12 LIMIT Function
- 324.3.3.13 REMOVE Function
- 324.3.3.14 REPLACE_ONE Function
- 324.3.3.15 REPLACE_ONE_AND_GET Function
- 324.3.3.16 SAMPLE Function
- 324.3.3.17 SKIP Function
- 324.3.3.18 VERSION Function
 
- 324.3.4 SODA_CURSOR_T Type
 
- 
                           
                           
                              
                              324.3.1
                                  SODA_Collection_T Type
                           
                              
                           
                           
                           
 
- 325 UTL Streams Types
- 
               
               
                  
                  326
                      XMLTYPE
               
                  
               
               
               - 
                     
                     
                        
                        326.1
                            Summary of XMLType Subprograms
                     
                        
                     
                     
                     - 326.1.1 CREATENONSCHEMABASEDXML
- 326.1.2 CREATESCHEMABASEDXML
- 326.1.3 CREATEXML
- 326.1.4 EXISTSNODE
- 326.1.5 EXTRACT
- 326.1.6 GETBLOBVAL
- 326.1.7 GETCLOBVAL
- 326.1.8 GETNAMESPACE
- 326.1.9 GETNUMBERVAL
- 326.1.10 GETROOTELEMENT
- 326.1.11 GETSCHEMAURL
- 326.1.12 GETSTRINGVAL
- 326.1.13 ISFRAGMENT
- 326.1.14 ISSCHEMABASED
- 326.1.15 ISSCHEMAVALID
- 326.1.16 ISSCHEMAVALIDATED
- 326.1.17 SCHEMAVALIDATE
- 326.1.18 SETSCHEMAVALIDATED
- 326.1.19 TOOBJECT
- 326.1.20 TRANSFORM
- 326.1.21 XMLTYPE
 
 
- 
                     
                     
                        
                        326.1
                            Summary of XMLType Subprograms
                     
                        
                     
                     
                     
- Index