Table of Contents
- Title and Copyright Information
- Preface
- Changes in This Release for Oracle 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 DBMS_SAGA_ADM
- 11 CTX_QUERY
- 12 CTX_REPORT
- 13 CTX_THES
- 14 CTX_ULEXER
- 15 DBMS_ACTIVITY
-
16
DBMS_ADDM
- 16.1 DBMS_ADDM Security Model
-
16.2
Summary of DBMS_ADDM Subprograms
- 16.2.1 ANALYZE_DB Procedure
- 16.2.2 ANALYZE_INST Procedure
- 16.2.3 ANALYZE_PARTIAL Procedure
- 16.2.4 COMPARE_CAPTURE_REPLAY_REPORT Function
- 16.2.5 COMPARE_DATABASES Function
- 16.2.6 COMPARE_INSTANCES Function
- 16.2.7 COMPARE_REPLAY_REPLAY_REPORT Function
- 16.2.8 DELETE Procedure
- 16.2.9 DELETE_FINDING_DIRECTIVE Procedure
- 16.2.10 DELETE_PARAMETER_DIRECTIVE Procedure
- 16.2.11 DELETE_SEGMENT_DIRECTIVE Procedure
- 16.2.12 DELETE_SQL_DIRECTIVE Procedure
- 16.2.13 FAILED_AUTO_TASKS_REPORT Function
- 16.2.14 GET_ASH_QUERY Function
- 16.2.15 GET_REPORT Function
- 16.2.16 INSERT_FINDING_DIRECTIVE Procedure
- 16.2.17 INSERT_PARAMETER_DIRECTIVE Procedure
- 16.2.18 INSERT_SEGMENT_DIRECTIVE Procedure
- 16.2.19 INSERT_SQL_DIRECTIVE Procedure
- 16.2.20 REAL_TIME_ADDM_REPORT Function
- 16.2.21 REEXECUTE_FAILED_AUTO_TASKS Procedure
- 17 DBMS_ADVANCED_REWRITE
-
18
DBMS_ADVISOR
- 18.1 DBMS_ADVISOR Deprecated Subprograms
- 18.2 DBMS_ADVISOR Security Model
-
18.3
Summary of DBMS_ADVISOR Subprograms
- 18.3.1 ADD_SQLWKLD_REF Procedure
- 18.3.2 ADD_SQLWKLD_STATEMENT Procedure
- 18.3.3 ADD_STS_REF Procedure
- 18.3.4 CANCEL_TASK Procedure
- 18.3.5 COPY_SQLWKLD_TO_STS Procedure
- 18.3.6 CREATE_FILE Procedure
- 18.3.7 CREATE_OBJECT Procedure
- 18.3.8 CREATE_SQLWKLD Procedure
- 18.3.9 CREATE_TASK Procedures
- 18.3.10 DELETE_SQLWKLD Procedure
- 18.3.11 DELETE_SQLWKLD_REF Procedure
- 18.3.12 DELETE_SQLWKLD_STATEMENT Procedure
- 18.3.13 DELETE_STS_REF Procedure
- 18.3.14 DELETE_TASK Procedure
- 18.3.15 EXECUTE_TASK Procedure
- 18.3.16 GET_REC_ATTRIBUTES Procedure
- 18.3.17 GET_TASK_REPORT Function
- 18.3.18 GET_TASK_SCRIPT Function
- 18.3.19 IMPLEMENT_TASK Procedure
- 18.3.20 IMPORT_SQLWKLD_SCHEMA Procedure
- 18.3.21 IMPORT_SQLWKLD_SQLCACHE Procedure
- 18.3.22 IMPORT_SQLWKLD_STS Procedure
- 18.3.23 IMPORT_SQLWKLD_SUMADV Procedure
- 18.3.24 IMPORT_SQLWKLD_USER Procedure
- 18.3.25 INTERRUPT_TASK Procedure
- 18.3.26 MARK_RECOMMENDATION Procedure
- 18.3.27 QUICK_TUNE Procedure
- 18.3.28 RESET_SQLWKLD Procedure
- 18.3.29 RESET_TASK Procedure
- 18.3.30 SET_DEFAULT_SQLWKLD_PARAMETER Procedure
- 18.3.31 SET_DEFAULT_TASK_PARAMETER Procedure
- 18.3.32 SET_SQLWKLD_PARAMETER Procedure
- 18.3.33 SET_TASK_PARAMETER Procedure
- 18.3.34 TUNE_MVIEW Procedure
- 18.3.35 UPDATE_OBJECT Procedure
- 18.3.36 UPDATE_REC_ATTRIBUTES Procedure
- 18.3.37 UPDATE_SQLWKLD_ATTRIBUTES Procedure
- 18.3.38 UPDATE_SQLWKLD_STATEMENT Procedure
- 18.3.39 UPDATE_TASK_ATTRIBUTES Procedure
- 19 DBMS_AUTOIM
- 20 DBMS_ALERT
- 21 DBMS_APP_CONT
-
22
DBMS_APP_CONT_ADMIN
- 22.1 DBMS_APP_CONT_ADMIN Security Model
-
22.2
Summary of DBMS_APP_CONT_ADMIN Subprograms
- 22.2.1 ACCHK_CLEAR_FILTER Procedure
- 22.2.2 ACCHK_PURGE Procedure
- 22.2.3 ACCHK_SET Procedure
- 22.2.4 ACCHK_SET_FILTER Procedure
- 22.2.5 ACCHK_SHOW_FILTERS Procedure
- 22.2.6 ADD_SQL_CONNECTION_TEST Procedure
- 22.2.7 CHECK_REPLAY_RULES Procedure
- 22.2.8 CREATE_CHILD_SERVICE Procedure
- 22.2.9 DELETE_CHILD_SERVICE Procedure
- 22.2.10 DELETE_SQL_CONNECTION_TEST Procedure
- 22.2.11 DISABLE_CONNECTION_TEST Procedure
- 22.2.12 DISABLE_FAILOVER Procedure
- 22.2.13 DISABLE_SMART_CONNECTION Procedure
- 22.2.14 ENABLE_AC Procedure
- 22.2.15 ENABLE_CONNECTION_TEST Procedure
- 22.2.16 ENABLE_RESET_STATE Procedure
- 22.2.17 ENABLE_SMART_CONNECTION Procedure
- 22.2.18 ENABLE_TAC Procedure
- 22.2.19 ENABLE_TAF Procedure
- 22.2.20 ENABLE_TG Procedure
- 22.2.21 MODIFY_SERVICE Procedure
- 22.2.22 RESET_REPLAY_RULES Procedure
- 22.2.23 SET_DRAINING Procedure
- 22.2.24 SET_LOAD_BALANCING_GOAL Procedure
- 22.2.25 SET_REPLAY_RULES Procedure
- 23 DBMS_APP_CONT_REPORT
- 24 DBMS_APPLICATION_INFO
-
25
DBMS_APPLY_ADM
- 25.1 DBMS_APPLY_ADM Overview
- 25.2 DBMS_APPLY_ADM Security Model
- 25.3 DBMS_APPLY_ADM Deprecated Subprograms
-
25.4
Summary of DBMS_APPLY_ADM Subprograms
- 25.4.1 ALTER_APPLY Procedure
- 25.4.2 CLEAR_KEY_COLUMNS Procedure
- 25.4.3 COMPARE_OLD_VALUES Procedure
- 25.4.4 CREATE_APPLY Procedure
- 25.4.5 CREATE_OBJECT_DEPENDENCY Procedure
- 25.4.6 DELETE_ALL_ERRORS Procedure
- 25.4.7 DELETE_ERROR Procedure
- 25.4.8 DROP_APPLY Procedure
- 25.4.9 DROP_OBJECT_DEPENDENCY Procedure
- 25.4.10 EXECUTE_ALL_ERRORS Procedure
- 25.4.11 EXECUTE_ERROR Procedure
- 25.4.12 GET_ERROR_MESSAGE Function
- 25.4.13 HANDLE_COLLISIONS
- 25.4.14 SET_DML_CONFLICT_HANDLER Procedure
- 25.4.15 SET_DML_HANDLER Procedure
- 25.4.16 SET_ENQUEUE_DESTINATION Procedure
- 25.4.17 SET_EXECUTE Procedure
- 25.4.18 SET_GLOBAL_INSTANTIATION_SCN Procedure
- 25.4.19 SET_KEY_COLUMNS Procedures
- 25.4.20 SET_PARAMETER Procedure
- 25.4.21 SET_REPERROR_HANDLER Procedure
- 25.4.22 SET_SCHEMA_INSTANTIATION_SCN Procedure
- 25.4.23 SET_TABLE_INSTANTIATION_SCN Procedure
- 25.4.24 SET_UPDATE_CONFLICT_HANDLER Procedure
- 25.4.25 SET_VALUE_DEPENDENCY Procedure
- 25.4.26 START_APPLY Procedure
- 25.4.27 STOP_APPLY Procedure
- 26 DBMS_AQ
-
27
DBMS_AQADM
- 27.1 DBMS_AQADM Security Model
- 27.2 DBMS_AQADM Constants
-
27.3
DBMS_AQADM Subprogram Groups
- 27.3.1 DBMS_AQADM Queue Table Subprograms
- 27.3.2 DBMS_AQADM Privilege Subprograms
- 27.3.3 DBMS_AQADM Queue Subprograms
- 27.3.4 DBMS_AQADM Subscriber Subprograms
- 27.3.5 DBMS_AQADM OKafka Subprograms
- 27.3.6 DBMS_AQADM Propagation Subprograms
- 27.3.7 DBMS_AQADM Miscellaneous Subprograms
- 27.3.8 DBMS_AQADM Agent Subprograms
- 27.3.9 DBMS_AQADM Alias Subprograms
-
27.4
Summary of DBMS_AQADM Subprograms
- 27.4.1 ADD_ALIAS_TO_LDAP Procedure
- 27.4.2 ADD_SUBSCRIBER Procedure
- 27.4.3 ALTER_AQ_AGENT Procedure
- 27.4.4 ALTER_PROPAGATION_SCHEDULE Procedure
- 27.4.5 ALTER_QUEUE Procedure
- 27.4.6 ALTER_QUEUE_TABLE Procedure
- 27.4.7 ALTER_SHARDED_QUEUE Procedure
- 27.4.8 ALTER_SUBSCRIBER Procedure
- 27.4.9 ALTER_TRANSACTIONAL_EVENT_QUEUE Procedure
- 27.4.10 CREATE_AQ_AGENT Procedure
- 27.4.11 CREATE_DATABASE_KAFKA_TOPIC Procedure
- 27.4.12 CREATE_NP_QUEUE Procedure
- 27.4.13 CREATE_QUEUE Procedure
- 27.4.14 CREATE_QUEUE_TABLE Procedure
- 27.4.15 CREATE_SHARDED_QUEUE Procedure
- 27.4.16 CREATE_EXCEPTION_QUEUE Procedure
- 27.4.17 CREATE_EQ EXCEPTION_QUEUE Procedure
- 27.4.18 CREATE_TRANSACTIONAL_EVENT_QUEUE Procedure
- 27.4.19 DEL_ALIAS_FROM_LDAP Procedure
- 27.4.20 DISABLE_DB_ACCESS Procedure
- 27.4.21 DISABLE_PROPAGATION_SCHEDULE Procedure
- 27.4.22 DROP_AQ_AGENT Procedure
- 27.4.23 DROP_DATABASE_KAFKA_TOPIC Procedure
- 27.4.24 DROP_QUEUE Procedure
- 27.4.25 DROP_QUEUE_TABLE Procedure
- 27.4.26 DROP_SHARDED_QUEUE Procedure
- 27.4.27 DROP_TRANSACTIONAL_EVENT_QUEUE Procedure
- 27.4.28 ENABLE_DB_ACCESS Procedure
- 27.4.29 ENABLE_JMS_TYPES Procedure
- 27.4.30 ENABLE_PROPAGATION_SCHEDULE Procedure
- 27.4.31 GET_MAX_STREAMS_POOL Procedure
- 27.4.32 GET_MIN_STREAMS_POOL Procedure
- 27.4.33 GET_QUEUE_PARAMETER Procedure
- 27.4.34 GET_WATERMARK Procedure
- 27.4.35 GRANT_QUEUE_PRIVILEGE Procedure
- 27.4.36 GRANT_SYSTEM_PRIVILEGE Procedure
- 27.4.37 MIGRATE_QUEUE_TABLE Procedure
- 27.4.38 MOVE_QUEUE_TABLE Procedure
- 27.4.39 PURGE_QUEUE_TABLE Procedure
- 27.4.40 QUEUE_SUBSCRIBERS Function
- 27.4.41 REMOVE_SUBSCRIBER Procedure
- 27.4.42 REVOKE_QUEUE_PRIVILEGE Procedure
- 27.4.43 REVOKE_SYSTEM_PRIVILEGE Procedure
- 27.4.44 SCHEDULE_PROPAGATION Procedure
- 27.4.45 SET_QUEUE_PARAMETER Procedure
- 27.4.46 SET_MAX_STREAMS_POOL Procedure
- 27.4.47 SET_MIN_STREAMS_POOL Procedure
- 27.4.48 SET_WATERMARK Procedure
- 27.4.49 START_QUEUE Procedure
- 27.4.50 STOP_QUEUE Procedure
- 27.4.51 UNSCHEDULE_PROPAGATION Procedure
- 27.4.52 UNSET_QUEUE_PARAMETER Procedure
- 27.4.53 VERIFY_QUEUE_TYPES Procedure
- 28 DBMS_AQELM
- 29 DBMS_AQIN
-
30
DBMS_AQMIGTOOL
- 30.1 DBMS_AQMIGTOOL Security Model
- 30.2 DBMS_AQMIGTOOL Constants
-
30.3
Summary of DBMS_AQMIGTOOL Subprograms
- 30.3.1 CANCEL_MIGRATION Procedure
- 30.3.2 CHECK_MIGRATED_MESSAGES Procedure
- 30.3.3 CHECK_MIGRATION_TO_TXEVENTQ Procedure
- 30.3.4 CHECK_STATUS Procedure
- 30.3.5 CLEAR_UNSUPPORTED_FEATURE_TABLE Procedure
- 30.3.6 COMMIT_MIGRATION Procedure
- 30.3.7 DISABLE_MIGRATION_CHECK Procedure
- 30.3.8 INIT_MIGRATION Procedure
- 30.3.9 PURGE_QUEUE_MESSAGES Procedure
- 30.3.10 RECOVER_MIGRATION Procedure
- 30.3.11 RENAME_QUEUE Procedure
- 31 DBMS_ASSERT
-
32
DBMS_AUDIT_MGMT
- 32.1 DBMS_AUDIT_MGMT Overview
- 32.2 DBMS_AUDIT_MGMT Deprecated and Desupported Subprograms
- 32.3 DBMS_AUDIT_MGMT Security Model
- 32.4 DBMS_AUDIT_MGMT Constants
- 32.5 DBMS_AUDIT_MGMT Views
- 32.6 DBMS_AUDIT_MGMT Subprogram Groups
-
32.7
Summary of DBMS_AUDIT_MGMT Subprograms
- 32.7.1 ALTER_PARTITION_INTERVAL Procedure
- 32.7.2 CLEAN_AUDIT_TRAIL Procedure
- 32.7.3 CLEAR_AUDIT_TRAIL_PROPERTY Procedure
- 32.7.4 CLEAR_LAST_ARCHIVE_TIMESTAMP Procedure
- 32.7.5 CREATE_PURGE_JOB Procedure
- 32.7.6 DEINIT_CLEANUP Procedure
- 32.7.7 DROP_OLD_UNIFIED_AUDIT_TABLES Procedure
- 32.7.8 DROP_PURGE_JOB Procedure
- 32.7.9 GET_AUDIT_COMMIT_DELAY Function
- 32.7.10 GET_ AUDIT_TRAIL_PROPERTY_VALUE Function
- 32.7.11 GET_LAST_ARCHIVE_TIMESTAMP Function
- 32.7.12 INIT_CLEANUP Procedure
- 32.7.13 IS_CLEANUP_INITIALIZED Function
- 32.7.14 LOAD_UNIFIED_AUDIT_FILES Procedure
- 32.7.15 SET_AUDIT_TRAIL_LOCATION Procedure
- 32.7.16 SET_AUDIT_TRAIL_PROPERTY Procedure
- 32.7.17 SET_LAST_ARCHIVE_TIMESTAMP Procedure
- 32.7.18 SET_PURGE_JOB_INTERVAL Procedure
- 32.7.19 SET_PURGE_JOB_STATUS Procedure
- 32.7.20 TRANSFER_UNIFIED_AUDIT_RECORDS Procedure
- 33 DBMS_AUDIT_UTIL
- 34 DBMS_AUTO_CLUSTERING
- 35 DBMS_AUTO_SQLTUNE
- 36 DBMS_AUTO_INDEX
- 37 DBMS_AUTO_MV
- 38 DBMS_AUTO_REPORT
- 39 DBMS_AUTO_TASK_ADMIN
- 40 DBMS_AUTO_ZONEMAP
-
41
DBMS_AVTUNE
- 41.1 DBMS_AVTUNE Overview
- 41.2 DBMS_AVTUNE Security Model
-
41.3
Summary of DBMS_AVTUNE Subprograms
- 41.3.1 AUTO_CACHE_CREATE Procedure
- 41.3.2 AUTO_CACHE_DISABLE Procedure
- 41.3.3 AUTO_CACHE_ENABLE Procedure
- 41.3.4 AUTO_CACHE_MODIFY Procedure
- 41.3.5 AUTO_CACHE_REFRESH Procedure
- 41.3.6 AUTO_CACHE_REMOVE Procedure
- 41.3.7 AUTO_CACHE_TUNE Procedure
- 41.3.8 AUTO_CACHE_STAR_DISABLE Procedure
- 41.3.9 AUTO_CACHE_STAR_ENABLE Procedure
- 41.3.10 AUTO_CACHE_STAR_MODIFY Procedure
- 41.3.11 AUTO_CACHE_STAR_REFRESH Procedure
- 42 DBMS_AW_STATS
-
43
DBMS_BLOCKCHAIN_TABLE
- 43.1 DBMS_BLOCKCHAIN_TABLE Overview
- 43.2 DBMS_BLOCKCHAIN_TABLE Security Model
-
43.3
Summary of DBMS_BLOCKCHAIN_TABLE Subprograms
- 43.3.1 ADD_INTERVAL_PARTITIONING Procedure
- 43.3.2 COUNTERSIGN_ROW Procedure
- 43.3.3 COUNTERSIGN_ROW_SPECIFIED_BY_KEY_COLUMNS Procedure
- 43.3.4 DELETE_EXPIRED_ROWS Procedure
- 43.3.5 GET_BLOCKCHAIN_DIGEST Function
- 43.3.6 GET_BLOCKCHAIN_DIGEST_FOR_SELECTED_ROWS Function
- 43.3.7 GET_BYTES_FOR_ROW_HASH Procedure
- 43.3.8 GET_BYTES_FOR_ROW_HASH_SPECIFIED_BY_KEY_COLUMNS Procedure
- 43.3.9 GET_BYTES_FOR_ROW_SIGNATURE Procedure
- 43.3.10 GET_BYTES_FOR_ROW_SIGNATURE_SPECIFIED_BY_KEY_COLUMNS Procedure
- 43.3.11 GET_SIGNED_BLOCKCHAIN_DIGEST Function
- 43.3.12 GET_SIGNED_BLOCKCHAIN_DIGEST_FOR_SELECTED_ROWS Function
- 43.3.13 SIGN_ROW Procedure
- 43.3.14 SIGN_ROW_SPECIFIED_BY_KEY_COLUMNS Procedure
- 43.3.15 SIGN_ROW_SPECIFIED_BY_KEY_COLUMNS_WITH_COUNTERSIGNATURE Procedure
- 43.3.16 SIGN_ROW_WITH_COUNTERSIGNATURE Procedure
- 43.3.17 VERIFY_ROWS Procedure
- 43.3.18 VERIFY_TABLE_BLOCKCHAIN Procedure
- 43.3.19 VERIFY_USER_BLOCKCHAIN_ROWS Procedure
- 44 DBMS_BLOCKER_RESOLVER
-
45
DBMS_CAPTURE_ADM
- 45.1 DBMS_CAPTURE_ADM Overview
- 45.2 DBMS_CAPTURE_ADM Security Model
-
45.3
Summary of DBMS_CAPTURE_ADM Subprograms
- 45.3.1 ABORT_GLOBAL_INSTANTIATION Procedure
- 45.3.2 ABORT_SCHEMA_INSTANTIATION Procedure
- 45.3.3 ABORT_SYNC_INSTANTIATION Procedure
- 45.3.4 ABORT_TABLE_INSTANTIATION Procedure
- 45.3.5 ALTER_CAPTURE Procedure
- 45.3.6 ALTER_SYNC_CAPTURE Procedure
- 45.3.7 BUILD Procedure
- 45.3.8 CREATE_CAPTURE Procedure
- 45.3.9 CREATE_SYNC_CAPTURE Procedure
- 45.3.10 DROP_CAPTURE Procedure
- 45.3.11 INCLUDE_EXTRA_ATTRIBUTE Procedure
- 45.3.12 PREPARE_GLOBAL_INSTANTIATION Procedure
- 45.3.13 PREPARE_SCHEMA_INSTANTIATION Procedure
- 45.3.14 PREPARE_SYNC_INSTANTIATION Function
- 45.3.15 PREPARE_TABLE_INSTANTIATION Procedure
- 45.3.16 SET_PARAMETER Procedure
- 45.3.17 START_CAPTURE Procedure
- 45.3.18 STOP_CAPTURE Procedure
- 46 DBMS_CACHEUTIL
-
47
DBMS_CLOUD
- 47.1 Installing DBMS_CLOUD
- 47.2 DBMS_CLOUD Endpoint Management
-
47.3
DBMS_CLOUD Subprograms and REST APIs
- 47.3.1 DBMS_CLOUD for Access Management
-
47.3.2
DBMS_CLOUD for Objects and Files
- 47.3.2.1 COPY_COLLECTION Procedure
- 47.3.2.2 COPY_DATA Procedure
- 47.3.2.3 COPY_DATA Procedure for Avro or Parquet Files
- 47.3.2.4 COPY_OBJECT Procedure
- 47.3.2.5 CREATE_EXTERNAL_PART_TABLE Procedure
- 47.3.2.6 CREATE_EXTERNAL_TABLE Procedure
- 47.3.2.7 CREATE_EXTERNAL_TABLE Procedure for Apache Iceberg
- 47.3.2.8 CREATE_EXTERNAL_TABLE Procedure for Avro or Parquet Files
- 47.3.2.9 CREATE_HYBRID_PART_TABLE Procedure
- 47.3.2.10 DELETE_ALL_OPERATIONS Procedure
- 47.3.2.11 DELETE_FILE Procedure
- 47.3.2.12 DELETE_OBJECT Procedure
- 47.3.2.13 DELETE_OPERATION Procedure
- 47.3.2.14 EXPORT_DATA Procedure
- 47.3.2.15 GET_OBJECT Procedure and Function
- 47.3.2.16 LIST_FILES Function
- 47.3.2.17 LIST_OBJECTS Function
- 47.3.2.18 MOVE_OBJECT Procedure
- 47.3.2.19 PUT_OBJECT Procedure
- 47.3.2.20 SYNC_EXTERNAL_PART_TABLE Procedure
- 47.3.2.21 VALIDATE_EXTERNAL_PART_TABLE Procedure
- 47.3.2.22 VALIDATE_EXTERNAL_TABLE Procedure
- 47.3.2.23 VALIDATE_HYBRID_PART_TABLE Procedure
- 47.3.3 DBMS_CLOUD for Bulk File Management
-
47.3.4
DBMS_CLOUD REST APIs
- 47.3.4.1 DBMS_CLOUD REST API Overview
- 47.3.4.2 DBMS_CLOUD REST API Constants
- 47.3.4.3 DBMS_CLOUD REST API Results Cache
- 47.3.4.4 GET_RESPONSE_HEADERS Function
- 47.3.4.5 GET_RESPONSE_RAW Function
- 47.3.4.6 GET_RESPONSE_STATUS_CODE Function
- 47.3.4.7 GET_RESPONSE_TEXT Function
- 47.3.4.8 GET_API_RESULT_CACHE_SIZE Function
- 47.3.4.9 SEND_REQUEST Function and Procedure
- 47.3.4.10 SET_API_RESULT_CACHE_SIZE Procedure
- 47.3.4.11 DBMS_CLOUD REST API Examples
-
47.4
DBMS_CLOUD URI Formats
- 47.4.1 Oracle Cloud Infrastructure Object Storage Native URI Format
- 47.4.2 Oracle Cloud Infrastructure Object Storage Swift URI Format
- 47.4.3 Oracle Cloud Infrastructure Object Storage URI Format Using Pre-Authenticated Request URL
- 47.4.4 URI Format Using Public URL
- 47.4.5 Oracle Cloud Infrastructure Object Storage Classic URI Format
- 47.4.6 Amazon S3 URI Format
- 47.4.7 Amazon S3 Compatible URI Format
- 47.4.8 GitHub Raw URL Format
- 47.4.9 Additional Customer-Managed URI Formats
- 47.5 DBMS_CLOUD Package Format Options
- 47.6 DBMS_CLOUD Package Format Options for EXPORT_DATA
-
47.7
DBMS_CLOUD Avro and Parquet Support
- 47.7.1 DBMS_CLOUD Package Format Options for Avro or Parquet
- 47.7.2 DBMS_CLOUD Package Avro to Oracle Data Type Mapping
- 47.7.3 DBMS_CLOUD Package ORC to Oracle Data Type Mapping
- 47.7.4 DBMS_CLOUD Package Parquet to Oracle Data Type Mapping
- 47.7.5 DBMS_CLOUD Package Oracle Data Type to Parquet Mapping
- 47.7.6 DBMS_CLOUD Package Avro and Parquet Complex Types
- 47.7.7 DBMS_CLOUD Package Avro and Parquet to Oracle Column Name Mapping
- 47.8 DBMS_CLOUD Exceptions
- 48 DBMS_CLOUD_AI
- 49 DBMS_CLOUD_NOTIFICATION
- 50 DBMS_CLOUD_PIPELINE
-
51
DBMS_CLOUD_REPO
- 51.1 DBMS_CLOUD_REPO Overview
- 51.2 DBMS_CLOUD_REPO Data Structures
- 51.3 DBMS_CLOUD_REPO Subprogram Groups
-
51.4
Summary of DBMS_CLOUD_REPO
Subprograms
- 51.4.1 CREATE_BRANCH Procedure
- 51.4.2 CREATE_REPOSITORY Procedure
- 51.4.3 DELETE_BRANCH Procedure
- 51.4.4 DELETE_FILE Procedure
- 51.4.5 DELETE_REPOSITORY Procedure
- 51.4.6 EXPORT_OBJECT Procedure
- 51.4.7 EXPORT_SCHEMA Procedure
- 51.4.8 GET_FILE Procedure and Function
- 51.4.9 INIT_AWS_REPO Function
- 51.4.10 INIT_AZURE_REPO Function
- 51.4.11 INIT_GITHUB_REPO Function
- 51.4.12 INIT_REPO Function
- 51.4.13 INSTALL_FILE Procedure
- 51.4.14 INSTALL_SQL Procedure
- 51.4.15 LIST_BRANCHES Function
- 51.4.16 LIST_COMMITS Function
- 51.4.17 LIST_FILES Function
- 51.4.18 LIST_REPOSITORIES Function
- 51.4.19 MERGE_BRANCH Procedure
- 51.4.20 PUT_FILE Procedure
- 51.4.21 UPDATE_REPOSITORY Procedure
- 52 DBMS_COMPARISON
- 53 DBMS_COMPRESSION
- 54 DBMS_CONNECTION_POOL
-
55
DBMS_CQ_NOTIFICATION
- 55.1 DBMS_CQ_NOTIFICATION Overview
- 55.2 DBMS_CQ_NOTIFICATION Security Model
- 55.3 DBMS_CQ_NOTIFICATION Constants
- 55.4 DBMS_CQ_NOTIFICATION Operational Notes
- 55.5 DBMS_CQ_NOTIFICATION Examples
-
55.6
DBMS_CQ_NOTIFICATION Data Structures
- 55.6.1 CQ_NOTIFICATION$_DESCRIPTOR Object Type
- 55.6.2 CQ_NOTIFICATION$_QUERY Object Type
- 55.6.3 CQ_NOTIFICATION$_QUERY_ARRAY Object (Array) Type
- 55.6.4 CQ_NOTIFICATION$_TABLE Object Type
- 55.6.5 CQ_NOTIFICATION$_TABLE_ARRAY Object (Array) Type
- 55.6.6 CQ_NOTIFICATION$_ROW Object Type
- 55.6.7 CQ_NOTIFICATION$_ROW_ARRAY Object (Array) Type
- 55.6.8 CQ_NOTIFICATION$_REG_INFO Object Type
- 55.7 Summary of DBMS_CQ_NOTIFICATION Subprograms
- 56 DBMS_CREDENTIAL
-
57
DBMS_CRYPTO
- 57.1 DBMS_CRYPTO Overview
- 57.2 DBMS_CRYPTO Security Model
- 57.3 DBMS_CRYPTO Constants
- 57.4 DBMS_CRYPTO Datatypes
- 57.5 DBMS_CRYPTO Algorithms
- 57.6 DBMS_CRYPTO Restrictions
- 57.7 DBMS_CRYPTO Exceptions
- 57.8 DBMS_CRYPTO Operational Notes
- 57.9 DBMS_CRYPTO Examples
-
57.10
Summary of DBMS_CRYPTO Subprograms
- 57.10.1 DECRYPT Functions
- 57.10.2 DECRYPT Procedures
- 57.10.3 ECDHDERIVE_SHAREDSECRET Function
- 57.10.4 ECDH_GENKEYPAIR Function
- 57.10.5 ENCRYPT Functions
- 57.10.6 ENCRYPT Procedures
- 57.10.7 HASH Function
- 57.10.8 HASH_LEN Function
- 57.10.9 MAC Function
- 57.10.10 KMACXOF Function
- 57.10.11 PKDECRYPT Function
- 57.10.12 PKENCRYPT Function
- 57.10.13 RANDOMBYTES Function
- 57.10.14 RANDOMINTEGER Function
- 57.10.15 RANDOMNUMBER Function
- 57.10.16 SIGN Function
- 57.10.17 VERIFY Function
- 58 DBMS_CSX_ADMIN
-
59
DBMS_CUBE
- 59.1 Using DBMS_CUBE
- 59.2 Using SQL Aggregation Management
- 59.3 Upgrading 10g Analytic Workspaces
-
59.4
Summary of DBMS_CUBE Subprograms
- 59.4.1 BUILD Procedure
- 59.4.2 CREATE_EXPORT_OPTIONS Procedure
- 59.4.3 CREATE_IMPORT_OPTIONS Procedure
- 59.4.4 CREATE_MVIEW Function
- 59.4.5 DERIVE_FROM_MVIEW Function
- 59.4.6 DROP_MVIEW Procedure
- 59.4.7 EXPORT_XML Procedure
- 59.4.8 EXPORT_XML_TO_FILE Procedure
- 59.4.9 IMPORT_XML Procedure
- 59.4.10 INITIALIZE_CUBE_UPGRADE Procedure
- 59.4.11 REFRESH_MVIEW Procedure
- 59.4.12 UPGRADE_AW Procedure
- 59.4.13 VALIDATE_XML Procedure
- 60 DBMS_CUBE_ADVISE
-
61
DBMS_CUBE_LOG
-
61.1
Using DBMS_CUBE_LOG
- 61.1.1 DBMS_CUBE_LOG — Logging Types
- 61.1.2 DBMS_CUBE_LOG — Logging Targets
- 61.1.3 DBMS_CUBE_LOG — Verbosity Levels
- 61.1.4 DBMS_CUBE_LOG Security Model
- 61.1.5 DBMS_CUBE_LOG — Creating Cube Logs
- 61.1.6 DBMS_CUBE_LOG — Cube Build Log
- 61.1.7 DBMS_CUBE_LOG — Cube Dimension Compile Log
- 61.1.8 DBMS_CUBE_LOG — Cube Operations Log
- 61.1.9 DBMS_CUBE_LOG — Cube Rejected Records Log
-
61.2
Summary of DBMS_CUBE_LOG Subprograms
- 61.2.1 DEFAULT_NAME Function
- 61.2.2 DISABLE Procedure
- 61.2.3 ENABLE Procedure
- 61.2.4 FLUSH Procedure
- 61.2.5 GET_LOG Procedure
- 61.2.6 GET_LOG_SPEC Function
- 61.2.7 GET_PARAMETER Function
- 61.2.8 LEVEL_HIGH Function
- 61.2.9 LEVEL_HIGHEST Function
- 61.2.10 LEVEL_LOW Function
- 61.2.11 LEVEL_LOWEST Function
- 61.2.12 LEVEL_MEDIUM Function
- 61.2.13 SET_LOG_SPEC Procedure
- 61.2.14 SET_PARAMETER Procedure
- 61.2.15 TABLE_CREATE Procedure
- 61.2.16 TARGET_FILE Function
- 61.2.17 TARGET_LOB Function
- 61.2.18 TARGET_TABLE Function
- 61.2.19 TARGET_TRACE Function
- 61.2.20 TYPE_BUILD Function
- 61.2.21 TYPE_DIMENSION_COMPILE Function
- 61.2.22 TYPE_OPERATIONS Function
- 61.2.23 TYPE_REJECTED_RECORDS Function
- 61.2.24 VERSION Function
-
61.1
Using DBMS_CUBE_LOG
-
62
DBMS_DATA_MINING
- 62.1 DBMS_DATA_MINING Overview
- 62.2 DBMS_DATA_MINING Security Model
- 62.3 DBMS_DATA_MINING — Machine Learning Functions
- 62.4 DBMS_DATA_MINING — Model Settings
-
62.5
DBMS_DATA_MINING — Algorithm Specific Model Settings
- 62.5.1 DBMS_DATA_MINING — Algorithm Settings: ALGO_EXTENSIBLE_LANG
- 62.5.2 DBMS_DATA_MINING — Algorithm Settings: CUR Matrix Decomposition
- 62.5.3 DBMS_DATA_MINING — Algorithm Settings: Decision Tree
- 62.5.4 DBMS_DATA_MINING — Algorithm Settings: Expectation Maximization
- 62.5.5 DBMS_DATA_MINING — Algorithm Settings: Explicit Semantic Analysis
- 62.5.6 DBMS_DATA_MINING — Algorithm Settings: Exponential Smoothing
- 62.5.7 DBMS_DATA_MINING — Algorithm Settings: Generalized Linear Model
- 62.5.8 DBMS_DATA_MINING — Algorithm Settings: k-Means
- 62.5.9 DBMS_DATA_MINING - Algorithm Settings: Multivariate State Estimation Technique - Sequential Probability Ratio Test
- 62.5.10 DBMS_DATA_MINING — Algorithm Settings: Naive Bayes
- 62.5.11 DBMS_DATA_MINING — Algorithm Settings: Neural Network
- 62.5.12 DBMS_DATA_MINING — Algorithm Settings: Non-Negative Matrix Factorization
- 62.5.13 DBMS_DATA_MINING — Algorithm Settings: O-Cluster
- 62.5.14 DBMS_DATA_MINING — Algorithm Settings: Random Forest
- 62.5.15 DBMS_DATA_MINING — Algorithm Constants and Settings: Singular Value Decomposition
- 62.5.16 DBMS_DATA_MINING — Algorithm Settings: Support Vector Machine
- 62.5.17 DBMS_DATA_MINING — Algorithm Settings: XGBoost
- 62.6 DBMS_DATA_MINING — Solver Settings
- 62.7 DBMS_DATA_MINING Datatypes
-
62.8
Summary of DBMS_DATA_MINING
Subprograms
- 62.8.1 ADD_COST_MATRIX Procedure
- 62.8.2 ADD_PARTITION Procedure
- 62.8.3 ALTER_REVERSE_EXPRESSION Procedure
- 62.8.4 APPLY Procedure
- 62.8.5 COMPUTE_CONFUSION_MATRIX Procedure
- 62.8.6 COMPUTE_CONFUSION_MATRIX_PART Procedure
- 62.8.7 COMPUTE_LIFT Procedure
- 62.8.8 COMPUTE_LIFT_PART Procedure
- 62.8.9 COMPUTE_ROC Procedure
- 62.8.10 COMPUTE_ROC_PART Procedure
- 62.8.11 CREATE_MODEL Procedure
- 62.8.12 CREATE_MODEL2 Procedure
- 62.8.13 Create Model Using Registration Information
- 62.8.14 DROP_ALGORITHM Procedure
- 62.8.15 DROP_PARTITION Procedure
- 62.8.16 DROP_MODEL Procedure
- 62.8.17 EXPORT_MODEL Procedure
- 62.8.18 EXPORT_SERMODEL Procedure
- 62.8.19 FETCH_JSON_SCHEMA Procedure
- 62.8.20 GET_ASSOCIATION_RULES Function
- 62.8.21 GET_FREQUENT_ITEMSETS Function
- 62.8.22 GET_MODEL_COST_MATRIX Function
- 62.8.23 GET_MODEL_DETAILS_AI Function
- 62.8.24 GET_MODEL_DETAILS_EM Function
- 62.8.25 GET_MODEL_DETAILS_EM_COMP Function
- 62.8.26 GET_MODEL_DETAILS_EM_PROJ Function
- 62.8.27 GET_MODEL_DETAILS_GLM Function
- 62.8.28 GET_MODEL_DETAILS_GLOBAL Function
- 62.8.29 GET_MODEL_DETAILS_KM Function
- 62.8.30 GET_MODEL_DETAILS_NB Function
- 62.8.31 GET_MODEL_DETAILS_NMF Function
- 62.8.32 GET_MODEL_DETAILS_OC Function
- 62.8.33 GET_MODEL_SETTINGS Function
- 62.8.34 GET_MODEL_SIGNATURE Function
- 62.8.35 GET_MODEL_DETAILS_SVD Function
- 62.8.36 GET_MODEL_DETAILS_SVM Function
- 62.8.37 GET_MODEL_DETAILS_XML Function
- 62.8.38 GET_MODEL_TRANSFORMATIONS Function
- 62.8.39 GET_TRANSFORM_LIST Procedure
- 62.8.40 IMPORT_MODEL Procedure
- 62.8.41 IMPORT_ONNX_MODEL Procedure
- 62.8.42 IMPORT_SERMODEL Procedure
- 62.8.43 JSON Schema for R Extensible Algorithm
- 62.8.44 REGISTER_ALGORITHM Procedure
- 62.8.45 RANK_APPLY Procedure
- 62.8.46 REMOVE_COST_MATRIX Procedure
- 62.8.47 RENAME_MODEL Procedure
-
63
DBMS_DATA_MINING_TRANSFORM
- 63.1 DBMS_DATA_MINING_TRANSFORM Overview
- 63.2 DBMS_DATA_MINING_TRANSFORM Operational Notes
- 63.3 DBMS_DATA_MINING_TRANSFORM Security Model
- 63.4 DBMS_DATA_MINING_TRANSFORM Datatypes
- 63.5 DBMS_DATA_MINING_TRANSFORM Constants
-
63.6
Summary of DBMS_DATA_MINING_TRANSFORM Subprograms
- 63.6.1 CREATE_BIN_CAT Procedure
- 63.6.2 CREATE_BIN_NUM Procedure
- 63.6.3 CREATE_CLIP Procedure
- 63.6.4 CREATE_COL_REM Procedure
- 63.6.5 CREATE_MISS_CAT Procedure
- 63.6.6 CREATE_MISS_NUM Procedure
- 63.6.7 CREATE_NORM_LIN Procedure
- 63.6.8 DESCRIBE_STACK Procedure
- 63.6.9 GET_EXPRESSION Function
- 63.6.10 INSERT_AUTOBIN_NUM_EQWIDTH Procedure
- 63.6.11 INSERT_BIN_CAT_FREQ Procedure
- 63.6.12 INSERT_BIN_NUM_EQWIDTH Procedure
- 63.6.13 INSERT_BIN_NUM_QTILE Procedure
- 63.6.14 INSERT_BIN_SUPER Procedure
- 63.6.15 INSERT_CLIP_TRIM_TAIL Procedure
- 63.6.16 INSERT_CLIP_WINSOR_TAIL Procedure
- 63.6.17 INSERT_MISS_CAT_MODE Procedure
- 63.6.18 INSERT_MISS_NUM_MEAN Procedure
- 63.6.19 INSERT_NORM_LIN_MINMAX Procedure
- 63.6.20 INSERT_NORM_LIN_SCALE Procedure
- 63.6.21 INSERT_NORM_LIN_ZSCORE Procedure
- 63.6.22 SET_EXPRESSION Procedure
- 63.6.23 SET_TRANSFORM Procedure
- 63.6.24 STACK_BIN_CAT Procedure
- 63.6.25 STACK_BIN_NUM Procedure
- 63.6.26 STACK_CLIP Procedure
- 63.6.27 STACK_COL_REM Procedure
- 63.6.28 STACK_MISS_CAT Procedure
- 63.6.29 STACK_MISS_NUM Procedure
- 63.6.30 STACK_NORM_LIN Procedure
- 63.6.31 XFORM_BIN_CAT Procedure
- 63.6.32 XFORM_BIN_NUM Procedure
- 63.6.33 XFORM_CLIP Procedure
- 63.6.34 XFORM_COL_REM Procedure
- 63.6.35 XFORM_EXPR_NUM Procedure
- 63.6.36 XFORM_EXPR_STR Procedure
- 63.6.37 XFORM_MISS_CAT Procedure
- 63.6.38 XFORM_MISS_NUM Procedure
- 63.6.39 XFORM_NORM_LIN Procedure
- 63.6.40 XFORM_STACK Procedure
-
64
DBMS_DATAPUMP
- 64.1 DBMS_DATAPUMP Overview
- 64.2 DBMS_DATAPUMP Security Model
- 64.3 DBMS_DATAPUMP Constants
- 64.4 DBMS_DATAPUMP Data Structures
-
64.5
Summary of DBMS_DATAPUMP Subprograms
- 64.5.1 ADD_FILE Procedure
- 64.5.2 ATTACH Function
- 64.5.3 DATA_FILTER Procedures
- 64.5.4 DATA_REMAP Procedure
- 64.5.5 DETACH Procedure
- 64.5.6 GET_DUMPFILE_INFO Procedure
- 64.5.7 GET_STATUS Procedure
- 64.5.8 LOG_ENTRY Procedure
- 64.5.9 METADATA_FILTER Procedure
- 64.5.10 METADATA_REMAP Procedure
- 64.5.11 METADATA_TRANSFORM Procedure
- 64.5.12 OPEN Function
- 64.5.13 SET_PARALLEL Procedure
- 64.5.14 SET_PARAMETER Procedures
- 64.5.15 START_JOB Procedure
- 64.5.16 STOP_JOB Procedure
- 64.5.17 WAIT_FOR_JOB Procedure
- 65 DBMS_DB_VERSION
- 66 DBMS_DBCOMP
-
67
DBMS_DBFS_CONTENT
- 67.1 DBMS_DBFS_CONTENT Overview
- 67.2 DBMS_DBFS_CONTENT Security Model
- 67.3 DBMS_DBFS_CONTENT Constants
- 67.4 Exceptions
- 67.5 DBMS_DBFS_CONTENT Operational Notes
-
67.6
DBMS_DBFS_CONTENT Data Structures
- 67.6.1 DBMS_DBFS_CONTENT FEATURE_T Record Type
- 67.6.2 DBMS_DBFS_CONTENT MOUNT_T Record Type
- 67.6.3 DBMS_DBFS_CONTENT PATH_ITEM_T Record Type
- 67.6.4 DBMS_DBFS_CONTENT PROP_ITEM_T Record Type
- 67.6.5 PROPERTY_T Record Type
- 67.6.6 DBMS_DBFS_CONTENT STORE_T Record Type
- 67.6.7 DBMS_DBFS_CONTENT FEATURES_T Table Type
- 67.6.8 MOUNTS_T Table Type
- 67.6.9 DBMS_DBFS_CONTENT PATH_ITEMS_T Table Type
- 67.6.10 DBMS_DBFS_CONTENT PROP_ITEMS_T Table Type
- 67.6.11 DBMS_DBFS_CONTENT PROPERTIES_T Table Type
- 67.6.12 STORES_T Table Type
-
67.7
Summary of DBMS_DBFS_CONTENT Subprograms
- 67.7.1 CHECKACCESS Function
- 67.7.2 CHECKSPI Functions and Procedures
- 67.7.3 CREATEDIRECTORY Procedures
- 67.7.4 CREATEFILE Procedures
- 67.7.5 CREATELINK Procedures
- 67.7.6 CREATEREFERENCE Procedures
- 67.7.7 DECODEFEATURES Function
- 67.7.8 DELETECONTENT Procedure
- 67.7.9 DELETEDIRECTORY Procedure
- 67.7.10 DELETEFILE Procedure
- 67.7.11 FEATURENAME Function
- 67.7.12 FLUSHSTATS Function
- 67.7.13 GETDEFAULTACL Procedure
- 67.7.14 GETDEFAULTASOF Procedure
- 67.7.15 GETDEFAULTCONTEXT Procedure
- 67.7.16 GETDEFAULTOWNER Procedure
- 67.7.17 GETDEFAULTPRINCIPAL Procedure
- 67.7.18 GETFEATURESBYMOUNT Function
- 67.7.19 GETFEATURESBYNAME Function
- 67.7.20 GETFEATURESBYPATH Function
- 67.7.21 GETPATH Procedures
- 67.7.22 GETPATHBYMOUNTID Function
- 67.7.23 GETPATHBYSTOREID Function
- 67.7.24 GETPATHNOWAIT Procedures
- 67.7.25 GETSTOREBYMOUNT Function
- 67.7.26 GETSTOREBYNAME Function
- 67.7.27 GETSTOREBYPATH Function
- 67.7.28 GETSTATS Procedure
- 67.7.29 GETTRACE Function
- 67.7.30 GETVERSION Function
- 67.7.31 ISPATHLOCKED Procedure
- 67.7.32 LIST Function
- 67.7.33 LISTALLPROPERTIES Function
- 67.7.34 LISTALLCONTENT Function
- 67.7.35 LISTMOUNTS Function
- 67.7.36 LISTSTORES Function
- 67.7.37 LOCKPATH Procedure
- 67.7.38 MOUNTSTORE Procedure
- 67.7.39 NORMALIZEPATH Functions
- 67.7.40 PROPANY Functions
- 67.7.41 PROPERTIESH2T Function
- 67.7.42 PROPERTIEST2H Function
- 67.7.43 PROPNUMBER Function
- 67.7.44 PROPRAW Function
- 67.7.45 PROPTIMESTAMP Function
- 67.7.46 PROPVARCHAR2 Function
- 67.7.47 PURGEALL Procedure
- 67.7.48 PURGEPATH Procedure
- 67.7.49 PUTPATH Procedures
- 67.7.50 REGISTERSTORE Procedure
- 67.7.51 RENAMEPATH Procedures
- 67.7.52 RESTOREALL Procedure
- 67.7.53 RESTOREPATH Procedure
- 67.7.54 SETDEFAULTACL Procedure
- 67.7.55 SETDEFAULTASOF Procedure
- 67.7.56 SETDEFAULTCONTEXT Procedure
- 67.7.57 SETDEFAULTOWNER Procedure
- 67.7.58 SETDEFAULTPRINCIPAL Procedure
- 67.7.59 SETPATH Procedures
- 67.7.60 SETSTATS Procedure
- 67.7.61 SETTRACE Procedure
- 67.7.62 SPACEUSAGE Procedure
- 67.7.63 TRACE Procedure
- 67.7.64 TRACEENABLED Function
- 67.7.65 UNLOCKPATH Procedure
- 67.7.66 UNMOUNTSTORE Procedure
- 67.7.67 UNREGISTERSTORE Procedure
-
68
DBMS_DBFS_CONTENT_SPI
- 68.1 ODBMS_DBFS_CONTENT_SPI Overview
- 68.2 DBMS_DBFS_CONTENT_SPI Security Model
- 68.3 DBMS_DBFS_CONTENT_SPI Operational Notes
-
68.4
Summary of DBMS_DBFS_CONTENT_SPI Subprograms
- 68.4.1 CHECKACCESS Function
- 68.4.2 CREATEDIRECTORY Procedure
- 68.4.3 CREATEFILE Procedure
- 68.4.4 CREATELINK Procedure
- 68.4.5 CREATEREFERENCE Procedure
- 68.4.6 DELETECONTENT Procedure
- 68.4.7 DELETEDIRECTORY Procedure
- 68.4.8 DELETEFILE Procedure
- 68.4.9 GETFEATURES Function
- 68.4.10 GETPATH Procedures
- 68.4.11 GETPATHBYSTOREID Function
- 68.4.12 GETPATHNOWAIT Procedure
- 68.4.13 GETSTOREID Function
- 68.4.14 GETVERSION Function
- 68.4.15 ISPATHLOCKED Procedure
- 68.4.16 LIST Function
- 68.4.17 LOCKPATH Procedure
- 68.4.18 PURGEALL Procedure
- 68.4.19 PURGEPATH Procedure
- 68.4.20 PUTPATH Procedures
- 68.4.21 RENAMEPATH Procedure
- 68.4.22 RESTOREALL Procedure
- 68.4.23 RESTOREPATH Procedure
- 68.4.24 SEARCH Function
- 68.4.25 SETPATH Procedure
- 68.4.26 SPACEUSAGE Procedure
- 68.4.27 UNLOCKPATH Procedure
-
69
DBMS_DBFS_HS
- 69.1 DBMS_DBFS_HS Overview
- 69.2 DBMS_DBFS_HS Security Model
- 69.3 DBMS_DBFS_HS Constants
- 69.4 DBMS_DBFS_HS Operational Notes
-
69.5
Summary of DBMS_DBFS_HS Subprograms
- 69.5.1 CLEANUPUNUSEDBACKUPFILES Procedure
- 69.5.2 CREATEBUCKET Procedure
- 69.5.3 CREATESTORE Procedure
- 69.5.4 DEREGSTORECOMMAND Function
- 69.5.5 DROPSTORE Procedure
- 69.5.6 FLUSHCACHE Procedure
- 69.5.7 GETSTOREPROPERTY Function
- 69.5.8 RECONFIGCACHE Procedure
- 69.5.9 REGISTERSTORECOMMAND Procedure
- 69.5.10 SENDCOMMAND Procedure
- 69.5.11 SETSTOREPROPERTY Procedure
- 69.5.12 STOREPUSH Procedure
- 70 DBMS_DBFS_SFS
- 71 DBMS_DDL
-
72
DBMS_DEBUG
- 72.1 DBMS_DEBUG Overview
- 72.2 DBMS_DEBUG Constants
- 72.3 DBMS_DEBUG Variables
- 72.4 DBMS_DEBUG Exceptions
- 72.5 DBMS_DEBUG Operational Notes
- 72.6 DBMS_DEBUG Data Structures
-
72.7
Summary of DBMS_DEBUG Subprograms
- 72.7.1 ATTACH_SESSION Procedure
- 72.7.2 CONTINUE Function
- 72.7.3 DEBUG_OFF Procedure
- 72.7.4 DEBUG_ON Procedure
- 72.7.5 DELETE_BREAKPOINT Function
- 72.7.6 DELETE_OER_BREAKPOINT Function
- 72.7.7 DETACH_SESSION Procedure
- 72.7.8 DISABLE_BREAKPOINT Function
- 72.7.9 ENABLE_BREAKPOINT Function
- 72.7.10 EXECUTE Procedure
- 72.7.11 GET_INDEXES Function
- 72.7.12 GET_MORE_SOURCE Procedure
- 72.7.13 GET_LINE_MAP Function
- 72.7.14 GET_RUNTIME_INFO Function
- 72.7.15 GET_TIMEOUT_BEHAVIOUR Function
- 72.7.16 GET_VALUE Function
- 72.7.17 INITIALIZE Function
- 72.7.18 PING Procedure
- 72.7.19 PRINT_BACKTRACE Procedure
- 72.7.20 PRINT_INSTANTIATIONS Procedure
- 72.7.21 PROBE_VERSION Procedure
- 72.7.22 SELF_CHECK Procedure
- 72.7.23 SET_BREAKPOINT Function
- 72.7.24 SET_OER_BREAKPOINT Function
- 72.7.25 SET_TIMEOUT Function
- 72.7.26 SET_TIMEOUT_BEHAVIOUR Procedure
- 72.7.27 SET_VALUE Function
- 72.7.28 SHOW_BREAKPOINTS Procedures
- 72.7.29 SHOW_FRAME_SOURCE Procedure
- 72.7.30 SHOW_SOURCE Procedures
- 72.7.31 SYNCHRONIZE Function
- 72.7.32 TARGET_PROGRAM_RUNNING Procedure
- 73 DBMS_DEBUG_JDWP
- 74 DBMS_DEBUG_JDWP_CUSTOM
- 75 DBMS_DESCRIBE
- 76 DBMS_DEVELOPER
- 77 DBMS_DG
- 78 DBMS_DICTIONARY_CHECK
- 79 DBMS_DIMENSION
- 80 DBMS_DISTRIBUTED_TRUST_ADMIN
- 81 DBMS_DNFS
-
82
DBMS_DST
- 82.1 DBMS_DST Overview
- 82.2 DBMS_DST Security Model
- 82.3 DBMS_DST Views
-
82.4
Summary of DBMS_DST Subprograms
- 82.4.1 BEGIN_PREPARE Procedure
- 82.4.2 BEGIN_UPGRADE Procedure
- 82.4.3 CREATE_AFFECTED_TABLE Procedure
- 82.4.4 CREATE_ERROR_TABLE Procedure
- 82.4.5 CREATE_TRIGGER_TABLE Procedure
- 82.4.6 END_PREPARE Procedure
- 82.4.7 END_UPGRADE Procedure
- 82.4.8 FIND_AFFECTED_TABLES Procedure
- 82.4.9 UPGRADE_DATABASE Procedure
- 82.4.10 UPGRADE_SCHEMA Procedure
- 82.4.11 UPGRADE_TABLE Procedure
- 83 DBMS_EDITIONS_UTILITIES
-
84
DBMS_EPG
- 84.1 DBMS_EPG Overview
- 84.2 DBMS_EPG Security Model
- 84.3 DBMS_EPG Exceptions
- 84.4 DBMS_EPG Data Structures
- 84.5 DBMS_EPG Subprogram Groups
-
84.6
Summary of DBMS_EPG Subprograms
- 84.6.1 AUTHORIZE_DAD Procedure
- 84.6.2 CREATE_DAD Procedure
- 84.6.3 DEAUTHORIZE_DAD Procedure
- 84.6.4 DELETE_DAD_ATTRIBUTE Procedure
- 84.6.5 DELETE_GLOBAL_ATTRIBUTE Procedure
- 84.6.6 DROP_DAD Procedure
- 84.6.7 GET_ALL_DAD_ATTRIBUTES Procedure
- 84.6.8 GET_ALL_DAD_MAPPINGS Procedure
- 84.6.9 GET_ALL_GLOBAL_ATTRIBUTES Procedure
- 84.6.10 GET_DAD_ATTRIBUTE Function
- 84.6.11 GET_DAD_LIST Procedure
- 84.6.12 GET_GLOBAL_ATTRIBUTE Function
- 84.6.13 MAP_DAD Procedure
- 84.6.14 SET_DAD_ATTRIBUTE Procedure
- 84.6.15 SET_GLOBAL_ATTRIBUTE Procedure
- 84.6.16 UNMAP_DAD Procedure
- 85 DBMS_ERRLOG
- 86 DBMS_FGA
- 87 DBMS_FILE_TRANSFER
- 88 DBMS_FLASHBACK
-
89
DBMS_FLASHBACK_ARCHIVE
- 89.1 DBMS_FLASHBACK_ARCHIVE Overview
- 89.2 DBMS_FLASHBACK_ARCHIVE Security Model
- 89.3 DBMS_FLASHBACK_ARCHIVE Constants
-
89.4
Summary of DBMS_FLASHBACK_ARCHIVE Subprograms
- 89.4.1 ADD_TABLE_TO_APPLICATION Procedure
- 89.4.2 CREATE_TEMP_HISTORY_TABLE Procedure
- 89.4.3 DISABLE_APPLICATION Procedure
- 89.4.4 DISABLE_ASOF_VALID_TIME Procedure
- 89.4.5 DISASSOCIATE_FBA Procedure
- 89.4.6 DROP_APPLICATION Procedure
- 89.4.7 ENABLE_APPLICATION Procedure
- 89.4.8 ENABLE_AT_VALID_TIME Procedure
- 89.4.9 EXTEND_MAPPINGS Procedure
- 89.4.10 GET_CURRENT_LIFESPAN_DIGEST Function
- 89.4.11 GET_SYS_CONTEXT Function
- 89.4.12 IMPORT_HISTORY Procedure
- 89.4.13 LOCK_DOWN_APPLICATION Procedure
- 89.4.14 PURGE_CONTEXT Procedure
- 89.4.15 REASSOCIATE_FBA Procedure
- 89.4.16 REGISTER_APPLICATION Procedure
- 89.4.17 REMOVE_TABLE_FROM_APPLICATION Procedure
- 89.4.18 SET_CONTEXT_LEVEL Procedure
- 89.4.19 VERIFY_BLOCKCHAIN_LIFESPAN Procedure
- 90 DBMS_FLASHBACK_ARCHIVE_MIGRATE
- 91 DBMS_FREQUENT_ITEMSET
- 92 DBMS_FS
-
93
DBMS_GOLDENGATE_ADM
- 93.1 Using DBMS_GOLDENGATE_ADM
-
93.2
Summary of DBMS_GOLDENGATE_ADM Subprograms
- 93.2.1 ADD_AUTO_CDR Procedure
- 93.2.2 ADD_AUTO_CDR_COLUMN_GROUP Procedure
- 93.2.3 ADD_AUTO_CDR_DELTA_RES Procedure
- 93.2.4 ALTER_AUTO_CDR Procedure
- 93.2.5 ALTER_AUTO_CDR_COLUMN_GROUP Procedure
- 93.2.6 DELETE_PROCREP_EXCLUSION_OBJ Procedure
- 93.2.7 GG_PROCEDURE_REPLICATION_ON Function
- 93.2.8 INSERT_PROCREP_EXCLUSION_OBJ Procedure
- 93.2.9 PURGE_TOMBSTONES Procedure
- 93.2.10 REMOVE_AUTO_CDR Procedure
- 93.2.11 REMOVE_AUTO_CDR_COLUMN_GROUP Procedure
- 93.2.12 REMOVE_AUTO_CDR_DELTA_RES Procedure
- 94 DBMS_GOLDENGATE_AUTH
- 95 DBMS_HADOOP
- 96 DBMS_HEAT_MAP
-
97
DBMS_HIERARCHY
- 97.1 DBMS_HIERARCHY Overview
- 97.2 DBMS_HIERARCHY Security Model
-
97.3
Summary of DBMS_HIERARCHY Subprograms
- 97.3.1 CREATE_VALIDATE_LOG_TABLE Procedure
- 97.3.2 CREATE_VIEW_FOR_FACT_ROWS Procedure
- 97.3.3 CREATE_VIEW_FOR_STAR_ROWS Procedure
- 97.3.4 GET_MV_SQL_FOR_AV_CACHE Function
- 97.3.5 GET_MV_SQL_FOR_STAR_CACHE Function
- 97.3.6 UPGRADE_VALIDATE_LOG_TABLE Procedure
- 97.3.7 VALIDATE_ANALYTIC_VIEW Function
- 97.3.8 VALIDATE_CHECK_SUCCESS Function
- 97.3.9 VALIDATE_HIERARCHY Function
- 98 DBMS_HM
- 99 DBMS_HPROF
- 100 DBMS_HS_PARALLEL
-
101
DBMS_HS_PASSTHROUGH
- 101.1 DBMS_HS_PASSTHROUGH Overview
- 101.2 DBMS_HS_PASSTHROUGH Operational Notes
-
101.3
Summary of DBMS_HS_PASSTHROUGH Subprograms
- 101.3.1 BIND_INOUT_VARIABLE Procedure
- 101.3.2 BIND_INOUT_VARIABLE_RAW Procedure
- 101.3.3 BIND_OUT_VARIABLE Procedure
- 101.3.4 BIND_OUT_VARIABLE_RAW Procedure
- 101.3.5 BIND_VARIABLE Procedure
- 101.3.6 BIND_VARIABLE_RAW Procedure
- 101.3.7 CLOSE_CURSOR Procedure
- 101.3.8 EXECUTE_IMMEDIATE Procedure
- 101.3.9 EXECUTE_NON_QUERY Function
- 101.3.10 FETCH_ROW Function
- 101.3.11 GET_VALUE Procedure
- 101.3.12 GET_VALUE_RAW Procedure
- 101.3.13 OPEN_CURSOR Function
- 101.3.14 PARSE Procedure
- 102 DBMS_HYBRID_VECTOR
- 103 DBMS_ILM
-
104
DBMS_ILM_ADMIN
- 104.1 DBMS_ILM_ADMIN Overview
- 104.2 DBMS_ILM_ADMIN Security Model
- 104.3 DBMS_ILM_ADMIN Constants
-
104.4
Summary of DBMS_ILM_ADMIN Subprograms
- 104.4.1 CLEAR_HEAT_MAP_ALL Procedure
- 104.4.2 CLEAR_HEAT_MAP_TABLE Procedure
- 104.4.3 CUSTOMIZE_ILM Procedure
- 104.4.4 DISABLE_AUTO_OPTIMIZE Procedure
- 104.4.5 DISABLE_ILM Procedure
- 104.4.6 ENABLE_AUTO_OPTIMIZE Procedure
- 104.4.7 ENABLE_ILM Procedure
- 104.4.8 IGNORE_AUTO_OPTIMIZE_CRITERIA Procedure
- 104.4.9 SET_HEAT_MAP_ALL Procedure
- 104.4.10 SET_HEAT_MAP_START Procedure
- 104.4.11 SET_HEAT_MAP_TABLE Procedure
- 105 DBMS_IMMUTABLE_TABLE
- 106 DBMS_INMEMORY
-
107
DBMS_INMEMORY_ADMIN
- 107.1 DBMS_INMEMORY_ADMIN Overview
- 107.2 DBMS_INMEMORY_ADMIN Security Model
- 107.3 DBMS_INMEMORY_ADMIN Operational Notes
-
107.4
Summary of DBMS_INMEMORY_ADMIN Subprograms
- 107.4.1 AIM_GET_PARAMETER Procedure
- 107.4.2 AIM_SET_PARAMETER Procedure
- 107.4.3 FASTSTART_DISABLE Procedure
- 107.4.4 FASTSTART_ENABLE Procedure
- 107.4.5 FASTSTART_MIGRATE_STORAGE Procedure
- 107.4.6 GET_FASTSTART_TABLESPACE Function
- 107.4.7 IME_CAPTURE_EXPRESSIONS Procedure
- 107.4.8 IME_CLOSE_CAPTURE_WINDOW Procedure
- 107.4.9 IME_DROP_ALL_EXPRESSIONS Procedure
- 107.4.10 IME_GET_CAPTURE_STATE Procedure
- 107.4.11 IME_OPEN_CAPTURE_WINDOW Procedure
- 107.4.12 IME_POPULATE_EXPRESSIONS Procedure
- 107.4.13 POPULATE_WAIT Function
- 108 DBMS_INMEMORY_ADVISE
- 109 DBMS_IOT
- 110 DBMS_JAVA
- 111 DBMS_JOB
-
112
DBMS_JSON_DUALITY
- 112.1 DBMS_JSON_DUALITY Overview
- 112.2 DBMS_JSON_DUALITY Security
-
112.3
Summary of DBMS_JSON_Duality
Subprograms
- 112.3.1 INFER_SCHEMA Function
- 112.3.2 GENERATE_SCHEMA Function
- 112.3.3 INFER_AND_GENERATE_SCHEMA Function
- 112.3.4 VALIDATE_SCHEMA_REPORT Function
- 112.3.5 IMPORT Procedure
- 112.3.6 IMPORT_ALL Procedure
- 112.3.7 VALIDATE_IMPORT_REPORT Function
- 112.3.8 BEGIN_TRANSACTION Procedure
- 112.3.9 COMMIT_TRANSACTION Procedure
- 112.3.10 REGISTER Procedure
- 113 DBMS_JSON
- 114 DBMS_JSON_SCHEMA
- 115 DBMS_KAFKA
- 116 DBMS_KAFKA_ADM
- 117 DBMS_LDAP
- 118 DBMS_LDAP_UTL
- 119 DBMS_LIBCACHE
-
120
DBMS_LOB
- 120.1 DBMS_LOB Overview
- 120.2 DBMS_LOB Security Model
- 120.3 DBMS_LOB Constants
- 120.4 DBMS_LOB Datatypes
- 120.5 DBMS_LOB Operational Notes
- 120.6 DBMS_LOB Rules and Limits
- 120.7 DBMS_LOB Exceptions
-
120.8
Summary of DBMS_LOB Subprograms
- 120.8.1 APPEND Procedures
- 120.8.2 CLOB2FILE Procedure
- 120.8.3 CLOSE Procedure
- 120.8.4 COMPARE Functions
- 120.8.5 CONVERTTOBLOB Procedure
- 120.8.6 CONVERTTOCLOB Procedure
- 120.8.7 COPY Procedures
- 120.8.8 COPY_DBFS_LINK Procedures
- 120.8.9 COPY_FROM_DBFS_LINK
- 120.8.10 CREATETEMPORARY Procedures
- 120.8.11 DBFS_LINK_GENERATE_PATH Functions
- 120.8.12 ERASE Procedures
- 120.8.13 FILECLOSE Procedure
- 120.8.14 FILECLOSEALL Procedure
- 120.8.15 FILEEXISTS Function
- 120.8.16 FILEGETNAME Procedure
- 120.8.17 FILEISOPEN Function
- 120.8.18 FILEOPEN Procedure
- 120.8.19 FRAGMENT_DELETE Procedure
- 120.8.20 FRAGMENT_INSERT Procedures
- 120.8.21 FRAGMENT_MOVE Procedure
- 120.8.22 FRAGMENT_REPLACE Procedures
- 120.8.23 FREETEMPORARY Procedures
- 120.8.24 GET_DBFS_LINK Functions
- 120.8.25 GET_DBFS_LINK_STATE Procedures
- 120.8.26 GET_LOB_DEDUPLICATION_RATIO Function
- 120.8.27 GETCONTENTTYPE Functions
- 120.8.28 GET_STORAGE_LIMIT Function
- 120.8.29 GETCHUNKSIZE Functions
- 120.8.30 GETLENGTH Functions
- 120.8.31 GETOPTIONS Functions
- 120.8.32 INSTR Functions
- 120.8.33 ISOPEN Functions
- 120.8.34 ISREMOTE Function
- 120.8.35 ISSECUREFILE Function
- 120.8.36 ISTEMPORARY Functions
- 120.8.37 LOADBLOBFROMFILE Procedure
- 120.8.38 LOADCLOBFROMFILE Procedure
- 120.8.39 MOVE_TO_DBFS_LINK Procedures
- 120.8.40 OPEN Procedures
- 120.8.41 READ Procedures
- 120.8.42 SET_DBFS_LINK Procedures
- 120.8.43 SETCONTENTTYPE Procedure
- 120.8.44 SETOPTIONS Procedures
- 120.8.45 SUBSTR Functions
- 120.8.46 TRIM Procedures
- 120.8.47 WRITE Procedures
- 120.8.48 WRITEAPPEND Procedures
- 121 DBMS_LOCK
- 122 DBMS_LOGMNR
-
123
DBMS_LOGSTDBY
- 123.1 DBMS_LOGSTDBY Overview
- 123.2 DBMS_LOGSTDBY Security Model
- 123.3 DBMS_LOGSTDBY Constants
-
123.4
Summary of DBMS_LOGSTDBY Subprograms
- 123.4.1 APPLY_SET Procedure
- 123.4.2 APPLY_UNSET Procedure
- 123.4.3 BUILD Procedure
- 123.4.4 INSTANTIATE_TABLE Procedure
- 123.4.5 IS_APPLY_SERVER Function
- 123.4.6 MAP_PRIMARY_SCN Function
- 123.4.7 PREPARE_FOR_NEW_PRIMARY Procedure
- 123.4.8 PURGE_SESSION Procedure
- 123.4.9 REBUILD Procedure
- 123.4.10 SET_TABLESPACE Procedure
- 123.4.11 SKIP Procedure
- 123.4.12 SKIP_ERROR Procedure
- 123.4.13 SKIP_TRANSACTION Procedure
- 123.4.14 UNSKIP Procedure
- 123.4.15 UNSKIP_ERROR Procedure
- 123.4.16 UNSKIP_TRANSACTION Procedure
- 124 DBMS_LOGMNR_D
- 125 DBMS_LOGSTDBY_CONTEXT
- 126 DBMS_MEMOPTIMIZE
- 127 DBMS_MEMOPTIMIZE_ADMIN
-
128
DBMS_METADATA
- 128.1 DBMS_METADATA Overview
- 128.2 DBMS_METADATA Security Model
- 128.3 Rules and Limits
- 128.4 DBMS_METADATA Data Structures - Object and Table Types
- 128.5 DBMS_METADATA Subprogram Groupings
-
128.6
Summary of All DBMS_METADATA Subprograms
- 128.6.1 ADD_TRANSFORM Function
- 128.6.2 CLOSE Procedure
- 128.6.3 CONVERT Functions and Procedures
- 128.6.4 FETCH_xxx Functions and Procedures
- 128.6.5 GET_xxx Functions
- 128.6.6 GET_QUERY Function
- 128.6.7 OPEN Function
- 128.6.8 OPENW Function
- 128.6.9 PUT Function
- 128.6.10 SET_COUNT Procedure
- 128.6.11 SET_FILTER Procedure
- 128.6.12 SET_PARSE_ITEM Procedure
- 128.6.13 SET_TRANSFORM_PARAM and SET_REMAP_PARAM Procedures
- 129 DBMS_METADATA_DIFF
-
130
DBMS_MGD_ID_UTL
- 130.1 DBMS_MGD_ID_UTL Security Model
- 130.2 DBMS_MGD_ID_UTL Constants
- 130.3 DBMS_MGD_ID_UTL Exceptions
-
130.4
Summary of DBMS_MGD_ID_UTL Subprograms
- 130.4.1 ADD_SCHEME Procedure
- 130.4.2 CREATE_CATEGORY Function
- 130.4.3 EPC_TO_ORACLE_SCHEME Function
- 130.4.4 GET_CATEGORY_ID Function
- 130.4.5 GET_COMPONENTS Function
- 130.4.6 GET_ENCODINGS Function
- 130.4.7 GET_JAVA_LOGGING_LEVEL Function
- 130.4.8 GET_PLSQL_LOGGING_LEVEL Function
- 130.4.9 GET_SCHEME_NAMES Function
- 130.4.10 GET_TDT_XML Function
- 130.4.11 GET_VALIDATOR Function
- 130.4.12 REFRESH_CATEGORY Function
- 130.4.13 REMOVE_CATEGORY Procedure
- 130.4.14 REMOVE_PROXY Procedure
- 130.4.15 REMOVE_SCHEME Procedure
- 130.4.16 SET_JAVA_LOGGING_LEVEL Procedure
- 130.4.17 SET_PLSQL_LOGGING_LEVEL Procedure
- 130.4.18 SET_PROXY Procedure
- 130.4.19 VALIDATE_SCHEME Function
-
131
DBMS_MGWADM
- 131.1 DBMS_MGWADM Security Model
- 131.2 DBMS_MGWADM Deprecated Subprograms
- 131.3 DBMS_MGWADM Constants
- 131.4 DBMS_MGWADM Data Structures
-
131.5
Summary of DBMS_MGWADM Subprograms
- 131.5.1 ADD_SUBSCRIBER Procedure
- 131.5.2 ALTER_AGENT Procedures
- 131.5.3 ALTER_JOB Procedure
- 131.5.4 ALTER_MSGSYSTEM_LINK Procedure for TIB/Rendezvous
- 131.5.5 ALTER_MSGSYSTEM_LINK Procedure for WebSphere MQ
- 131.5.6 ALTER_PROPAGATION_SCHEDULE Procedure
- 131.5.7 ALTER_SUBSCRIBER Procedure
- 131.5.8 CLEANUP_GATEWAY Procedures
- 131.5.9 CREATE_AGENT Procedure
- 131.5.10 CREATE_JOB Procedure
- 131.5.11 CREATE_MSGSYSTEM_LINK Procedures for TIB/Rendezvous
- 131.5.12 CREATE_MSGSYSTEM_LINK Procedures for WebSphere MQ
- 131.5.13 DB_CONNECT_INFO Procedure
- 131.5.14 DISABLE_JOB Procedure
- 131.5.15 DISABLE_PROPAGATION_SCHEDULE Procedure
- 131.5.16 ENABLE_JOB Procedure
- 131.5.17 ENABLE_PROPAGATION_SCHEDULE Procedure
- 131.5.18 REGISTER_FOREIGN_QUEUE Procedure
- 131.5.19 REMOVE_AGENT Procedure
- 131.5.20 REMOVE_JOB Procedure
- 131.5.21 REMOVE_MSGSYSTEM_LINK Procedure
- 131.5.22 REMOVE_OPTION Procedure
- 131.5.23 REMOVE_SUBSCRIBER Procedure
- 131.5.24 RESET_JOB Procedure
- 131.5.25 RESET_SUBSCRIBER Procedure
- 131.5.26 SCHEDULE_PROPAGATION Procedure
- 131.5.27 SET_LOG_LEVEL Procedures
- 131.5.28 SET_OPTION Procedure
- 131.5.29 SHUTDOWN Procedures
- 131.5.30 STARTUP Procedures
- 131.5.31 UNREGISTER_FOREIGN_QUEUE Procedure
- 131.5.32 UNSCHEDULE_PROPAGATION Procedure
-
132
DBMS_MGWMSG
- 132.1 DBMS_MGWMSG Security Model
- 132.2 DBMS_MGWMSG Constants
-
132.3
DBMS_MGWMSG Types
- 132.3.1 DBMS_MGWMSG SYS.MGW_NAME_VALUE_T Type
- 132.3.2 DBMS_MGWMSG SYS.MGW_NAME_TYPE_ARRAY_T Type
- 132.3.3 DBMS_MGWMSG SYS.MGW_TEXT_VALUE_T Type
- 132.3.4 DBMS_MGWMSG SYS.MGW_RAW_VALUE_T Type
- 132.3.5 DBMS_MGWMSG SYS.MGW_BASIC_MSG_T Type
- 132.3.6 DBMS_MGWMSG SYS.MGW_NUMBER_ARRAY_T Type
- 132.3.7 DBMS_MGWMSG SYS.MGW_TIBRV_FIELD_T Type
- 132.3.8 DBMS_MGWMSG SYS.MGW_TIBRV_MSG_T Type
-
132.4
Summary of DBMS_MGWMSG Subprograms
- 132.4.1 LCR_TO_XML Function
- 132.4.2 NVARRAY_ADD Procedure
- 132.4.3 NVARRAY_FIND_NAME Function
- 132.4.4 NVARRAY_FIND_NAME_TYPE Function
- 132.4.5 NVARRAY_GET Function
- 132.4.6 NVARRAY_GET_BOOLEAN Function
- 132.4.7 NVARRAY_GET_BYTE Function
- 132.4.8 NVARRAY_GET_DATE Function
- 132.4.9 NVARRAY_GET_DOUBLE Function
- 132.4.10 NVARRAY_GET_FLOAT Function
- 132.4.11 NVARRAY_GET_INTEGER Function
- 132.4.12 NVARRAY_GET_LONG Function
- 132.4.13 NVARRAY_GET_RAW Function
- 132.4.14 NVARRAY_GET_SHORT Function
- 132.4.15 NVARRAY_GET_TEXT Function
- 132.4.16 XML_TO_LCR Function
-
133
DBMS_MLE
- 133.1 DBMS_MLE Overview
- 133.2 DBMS_MLE Security Model
-
133.3
Summary of DBMS_MLE Subprograms
- 133.3.1 CREATE_CONTEXT Function
- 133.3.2 DISABLE_CTX_STDERR Procedure
- 133.3.3 DISABLE_CTX_STDOUT Procedure
- 133.3.4 DISABLE_DEBUGGING Procedure
- 133.3.5 DISABLE_ICS_STDERR Procedure
- 133.3.6 DISABLE_ICS_STDOUT Procedure
- 133.3.7 DISABLE_STDERR Procedure
- 133.3.8 DISABLE_STDOUT Procedure
- 133.3.9 DROP_CONTEXT Procedure
- 133.3.10 ENABLE_DEBUGGING Procedure
- 133.3.11 EVAL Procedure
- 133.3.12 EXPORT_TO_MLE Procedure
- 133.3.13 GET_AVAILABLE_LANGUAGES Function
- 133.3.14 GET_CTX_ERROR_STACK Function
- 133.3.15 GET_ERROR_STACK Function
- 133.3.16 IMPORT_FROM_MLE Procedure
- 133.3.17 PARSE_DEBUG_OUTPUT Function
- 133.3.18 SET_CTX_STDERR Procedure
- 133.3.19 SET_CTX_STDERR_TO_DBMS_OUTPUT Procedure
- 133.3.20 SET_CTX_STDOUT Procedure
- 133.3.21 SET_CTX_STDOUT_TO_DBMS_OUTPUT Procedure
- 133.3.22 SET_ICS_STDERR Procedure
- 133.3.23 SET_ICS_STDERR_TO_DBMS_OUTPUT Procedure
- 133.3.24 SET_ICS_STDOUT Procedure
- 133.3.25 SET_ICS_STDOUT_TO_DBMS_OUTPUT Procedure
- 133.3.26 SET_STDERR Procedure
- 133.3.27 SET_STDERR_TO_DBMS_OUTPUT Procedure
- 133.3.28 SET_STDOUT Procedure
- 133.3.29 SET_STDOUT_TO_DBMS_OUTPUT Procedure
-
134
DBMS_MONITOR
-
134.1
Summary of DBMS_MONITOR Subprograms
- 134.1.1 CLIENT_ID_STAT_DISABLE Procedure
- 134.1.2 CLIENT_ID_STAT_ENABLE Procedure
- 134.1.3 CLIENT_ID_TRACE_DISABLE Procedure
- 134.1.4 CLIENT_ID_TRACE_ENABLE Procedure
- 134.1.5 DATABASE_TRACE_DISABLE Procedure
- 134.1.6 DATABASE_TRACE_ENABLE Procedure
- 134.1.7 SERV_MOD_ACT_STAT_DISABLE Procedure
- 134.1.8 SERV_MOD_ACT_STAT_ENABLE Procedure
- 134.1.9 SERV_MOD_ACT_TRACE_DISABLE Procedure
- 134.1.10 SERV_MOD_ACT_TRACE_ENABLE Procedure
- 134.1.11 SESSION_TRACE_DISABLE Procedure
- 134.1.12 SESSION_TRACE_ENABLE Procedure
-
134.1
Summary of DBMS_MONITOR Subprograms
-
135
DBMS_MVIEW
- 135.1 DBMS_MVIEW Operational Notes
- 135.2 DBMS_MVIEW Security Model
- 135.3 DBMS_MVIEW Rules and Limits
-
135.4
Summary of DBMS_MVIEW Subprograms
- 135.4.1 BEGIN_TABLE_REORGANIZATION Procedure
- 135.4.2 END_TABLE_REORGANIZATION Procedure
- 135.4.3 ESTIMATE_MVIEW_SIZE Procedure
- 135.4.4 EXPLAIN_MVIEW Procedure
- 135.4.5 EXPLAIN_REWRITE Procedure
- 135.4.6 I_AM_A_REFRESH Function
- 135.4.7 PMARKER Function
- 135.4.8 PURGE_DIRECT_LOAD_LOG Procedure
- 135.4.9 PURGE_LOG Procedure
- 135.4.10 PURGE_MVIEW_FROM_LOG Procedure
- 135.4.11 REFRESH Procedures
- 135.4.12 REFRESH_ALL_MVIEWS Procedure
- 135.4.13 REFRESH_DEPENDENT Procedures
- 135.4.14 REGISTER_MVIEW Procedure
- 135.4.15 UNREGISTER_MVIEW Procedure
- 136 DBMS_MVIEW_STATS
-
137
DBMS_NETWORK_ACL_ADMIN
- 137.1 DBMS_NETWORK_ACL_ADMIN Overview
- 137.2 DBMS_NETWORK_ACL_ADMIN Deprecated Subprograms
- 137.3 DBMS_NETWORK_ACL_ADMIN Security Model
- 137.4 DBMS_NETWORK_ACL_ADMIN Constants
- 137.5 DBMS_NETWORK_ACL_ADMIN Exceptions
- 137.6 DBMS_NETWORK_ACL_ADMIN Examples
-
137.7
Summary of DBMS_NETWORK_ACL_ADMIN Subprograms
- 137.7.1 ADD_PRIVILEGE Procedure
- 137.7.2 APPEND_HOST_ACE Procedure
- 137.7.3 APPEND_HOST_ACL Procedure
- 137.7.4 APPEND_WALLET_ACE Procedure
- 137.7.5 APPEND_WALLET_ACL Procedure
- 137.7.6 ASSIGN_ACL Procedure
- 137.7.7 ASSIGN_WALLET_ACL Procedure
- 137.7.8 CHECK_PRIVILEGE Function
- 137.7.9 CHECK_PRIVILEGE_ACLID Function
- 137.7.10 CREATE_ACL Procedure
- 137.7.11 DELETE_PRIVILEGE Procedure
- 137.7.12 DROP_ACL Procedure
- 137.7.13 REMOVE_HOST_ACE Procedure
- 137.7.14 REMOVE_WALLET_ACE Procedure
- 137.7.15 SET_HOST_ACL Procedure
- 137.7.16 SET_WALLET_ACL Procedure
- 137.7.17 UNASSIGN_ACL Procedure
- 137.7.18 UNASSIGN_WALLET_ACL Procedure
- 138 DBMS_NETWORK_ACL_UTILITY
- 139 DBMS_ODCI
- 140 DBMS_OPTIM_BUNDLE
- 141 DBMS_OUTLN
- 142 DBMS_OUTPUT
-
143
DBMS_PARALLEL_EXECUTE
- 143.1 DBMS_PARALLEL_EXECUTE Overview
- 143.2 DBMS_PARALLEL_EXECUTE Security Model
- 143.3 DBMS_PARALLEL_EXECUTE Constants
- 143.4 DBMS_PARALLEL_EXECUTE Views
- 143.5 DBMS_PARALLEL_EXECUTE Exceptions
- 143.6 DBMS_PARALLEL_EXECUTE Examples
-
143.7
Summary of DBMS_PARALLEL_EXECUTE Subprograms
- 143.7.1 ADM_DROP_CHUNKS Procedure
- 143.7.2 ADM_DROP_TASK Procedure
- 143.7.3 ADM_TASK_STATUS Function
- 143.7.4 ADM_STOP_TASK Procedure
- 143.7.5 CREATE_TASK Procedure
- 143.7.6 CREATE_CHUNKS_BY_NUMBER_COL Procedure
- 143.7.7 CREATE_CHUNKS_BY_ROWID Procedure
- 143.7.8 CREATE_CHUNKS_BY_SQL Procedure
- 143.7.9 DROP_TASK Procedure
- 143.7.10 DROP_CHUNKS Procedure
- 143.7.11 GENERATE_TASK_NAME Function
- 143.7.12 GET_NUMBER_COL_CHUNK Procedure
- 143.7.13 GET_ROWID_CHUNK Procedure
- 143.7.14 PURGE_PROCESSED_CHUNKS Procedure
- 143.7.15 RESUME_TASK Procedures
- 143.7.16 RUN_TASK Procedure
- 143.7.17 SET_CHUNK_STATUS Procedure
- 143.7.18 STOP_TASK Procedure
- 143.7.19 TASK_STATUS Procedure
- 144 DBMS_PART
- 145 DBMS_PCLXUTIL
-
146
DBMS_PDB
- 146.1 DBMS_PDB Overview
- 146.2 DBMS_PDB Security Model
-
146.3
Summary of DBMS_PDB Subprograms
- 146.3.1 CHECK_PLUG_COMPATIBILITY Function
- 146.3.2 DESCRIBE Procedure
- 146.3.3 EXPORTRMANBACKUP Procedure
- 146.3.4 RECOVER Procedure
- 146.3.5 SET_DATA_LINKED Procedure
- 146.3.6 SET_EXT_DATA_LINKED Procedure
- 146.3.7 SET_METADATA_LINKED Procedure
- 146.3.8 SET_PROFILE_EXPLICIT Procedure
- 146.3.9 SET_ROLE_EXPLICIT Procedure
- 146.3.10 SET_USER_EXPLICIT Procedure
- 147 DBMS_PDB_ALTER_SHARING
- 148 DBMS_PERF
-
149
DBMS_PIPE
- 149.1 DBMS_PIPE Overview
- 149.2 DBMS_PIPE Security Model
- 149.3 DBMS_PIPE Constants
- 149.4 DBMS_PIPE Operational Notes
- 149.5 DBMS_PIPE Exceptions
- 149.6 DBMS_PIPE Examples
-
149.7
Summary of DBMS_PIPE Subprograms
- 149.7.1 CREATE_PIPE Function
- 149.7.2 GET_CREDENTIAL_NAME Function
- 149.7.3 GET_LOCATION_URI Function
- 149.7.4 NEXT_ITEM_TYPE Function
- 149.7.5 PACK_MESSAGE Procedures
- 149.7.6 PURGE Procedure
- 149.7.7 RECEIVE_MESSAGE Function
- 149.7.8 RESET_BUFFER Procedure
- 149.7.9 REMOVE_PIPE Function
- 149.7.10 SEND_MESSAGE Function
- 149.7.11 SET_CREDENTIAL_NAME Procedure
- 149.7.12 SET_LOCATION_URI Procedure
- 149.7.13 UNIQUE_SESSION_NAME Function
- 149.7.14 UNPACK_MESSAGE Procedures
- 150 DBMS_PLSQL_CODE_COVERAGE
- 151 DBMS_PREDICTIVE_ANALYTICS
- 152 DBMS_PREPROCESSOR
- 153 DBMS_PRIVILEGE_CAPTURE
- 154 DBMS_PROCESS
- 155 DBMS_PROFILER
- 156 DBMS_PROPAGATION_ADM
-
157
DBMS_QOPATCH
- 157.1 DBMS_QOPATCH Overview
- 157.2 DBMS_QOPATCH Security Model
- 157.3 DBMS_QOPATCH Operational Notes
- 157.4 DBMS_QOPATCH Exceptions
-
157.5
Summary of DBMS_QOPATCH Subprograms
- 157.5.1 CHECK_PATCH_INSTALLED Function
- 157.5.2 GET_OPATCH_BUGS Function
- 157.5.3 GET_OPATCH_COUNT Function
- 157.5.4 GET_OPATCH_DATA Function
- 157.5.5 GET_OPATCH_FILES Function
- 157.5.6 GET_OPATCH_INSTALL_INFO Function
- 157.5.7 GET_OPATCH_LIST Function
- 157.5.8 GET_OPATCH_LSINVENTORY
- 157.5.9 GET_OPATCH_OLAYS Function
- 157.5.10 GET_OPATCH_PREQS Function
- 157.5.11 GET_OPATCH_XSLT
- 157.5.12 GET_PATCH_DETAILS Function
- 157.5.13 GET_SQLPATCH_STATUS Procedure
- 157.5.14 IS_PATCH_INSTALLED Function
- 157.5.15 OPATCH_COMPARE_CURRENT Function
- 157.5.16 OPATCH_COMPARE_NODES Function
- 157.5.17 SET_CURRENT_OPINST Procedure
- 158 DBMS_RANDOM
-
159
DBMS_REDACT
- 159.1 DBMS_REDACT Overview
- 159.2 DBMS_REDACT Security Model
- 159.3 DBMS_REDACT Constants
- 159.4 DBMS_REDACT Operating Procedures
-
159.5
Summary of DBMS_REDACT Subprograms
- 159.5.1 ADD_POLICY Procedure
- 159.5.2 ALTER_POLICY Procedure
- 159.5.3 APPLY_POLICY_EXPR_TO_COL Procedure
- 159.5.4 CREATE_POLICY_EXPRESSION Procedure
- 159.5.5 DISABLE_POLICY Procedure
- 159.5.6 DROP_POLICY Procedure
- 159.5.7 DROP_POLICY_EXPRESSION Procedure
- 159.5.8 ENABLE_POLICY Procedure
- 159.5.9 UPDATE_FULL_REDACTION_VALUES Procedure
- 159.5.10 UPDATE_POLICY_EXPRESSION Procedure
-
160
DBMS_REDEFINITION
- 160.1 DBMS_REDEFINITION Overview
- 160.2 DBMS_REDEFINITION Security Model
- 160.3 DBMS_REDEFINITION Constants
- 160.4 DBMS_REDEFINITION Operational Notes
- 160.5 DBMS_REDEFINITION Rules and Limits
- 160.6 DBMS_REDEFINITION Examples
-
160.7
Summary of DBMS_REDEFINITION Subprograms
- 160.7.1 ABORT_REDEF_TABLE Procedure
- 160.7.2 ABORT_ROLLBACK Procedure
- 160.7.3 ABORT_UPDATE Procedure
- 160.7.4 CAN_REDEF_TABLE Procedure
- 160.7.5 COPY_TABLE_DEPENDENTS Procedure
- 160.7.6 EXECUTE_UPDATE Procedure
- 160.7.7 FINISH_REDEF_TABLE Procedure
- 160.7.8 REDEF_TABLE Procedure
- 160.7.9 REGISTER_DEPENDENT_OBJECT Procedure
- 160.7.10 ROLLBACK Procedure
- 160.7.11 SET_PARAM Procedure
- 160.7.12 START_REDEF_TABLE Procedure
- 160.7.13 SYNC_INTERIM_TABLE Procedure
- 160.7.14 UNREGISTER_DEPENDENT_OBJECT Procedure
- 161 DBMS_REFRESH
- 162 DBMS_REPAIR
-
163
DBMS_RESCONFIG
- 163.1 DBMS_RESCONFIG Overview
-
163.2
Summary of DBMS_RESCONFIG Subprograms
- 163.2.1 ADDREPOSITORYRESCONFIG Procedure
- 163.2.2 ADDRESCONFIG Procedure
- 163.2.3 APPENDRESCONFIG Procedure
- 163.2.4 DELETEREPOSITORYRESCONFIG Procedure
- 163.2.5 DELETERESCONFIG Procedures
- 163.2.6 GETLISTENERS Function
- 163.2.7 GETREPOSITORYRESCONFIG Function
- 163.2.8 GETREPOSITORYRESCONFIGPATHS Function
- 163.2.9 GETRESCONFIG Function
- 163.2.10 GETRESCONFIGPATHS Function
- 163.2.11 PATCHREPOSITORYRESCONFIGLIST Procedure
-
164
DBMS_RESOURCE_MANAGER
- 164.1 DBMS_RESOURCE_MANAGER Deprecated Subprograms
- 164.2 DBMS_RESOURCE_MANAGER Security Model
- 164.3 DBMS_RESOURCE_MANAGER Constants
-
164.4
Summary of DBMS_RESOURCE_MANAGER Subprograms
- 164.4.1 BEGIN_SQL_BLOCK Procedure
- 164.4.2 CALIBRATE_IO Procedure
- 164.4.3 CLEAR_PENDING_AREA Procedure
- 164.4.4 CREATE_CATEGORY Procedure
- 164.4.5 CREATE_CDB_PLAN Procedure
- 164.4.6 CREATE_CDB_PLAN_DIRECTIVE Procedure
- 164.4.7 CREATE_CDB_PROFILE_DIRECTIVE Procedure
- 164.4.8 CREATE_CONSUMER_GROUP Procedure
- 164.4.9 CREATE_PENDING_AREA Procedure
- 164.4.10 CREATE_PLAN Procedure
- 164.4.11 CREATE_PLAN_DIRECTIVE Procedure
- 164.4.12 CREATE_SIMPLE_PLAN Procedure
- 164.4.13 DELETE_CATEGORY Procedure
- 164.4.14 DELETE_CDB_PLAN Procedure
- 164.4.15 DELETE_CDB_PLAN_DIRECTIVE Procedure
- 164.4.16 DELETE_CDB_PROFILE_DIRECTIVE Procedure
- 164.4.17 DELETE_CONSUMER_GROUP Procedure
- 164.4.18 DELETE_PLAN Procedure
- 164.4.19 DELETE_PLAN_CASCADE Procedure
- 164.4.20 DELETE_PLAN_DIRECTIVE Procedure
- 164.4.21 DEQUEUE_PARALLEL_STATEMENT Procedure
- 164.4.22 END_SQL_BLOCK Procedure
- 164.4.23 SET_CONSUMER_GROUP_MAPPING Procedure
- 164.4.24 SET_CONSUMER_GROUP_MAPPING_PRI Procedure
- 164.4.25 SET_INITIAL_CONSUMER_GROUP Procedure
- 164.4.26 SUBMIT_PENDING_AREA Procedure
- 164.4.27 SWITCH_CONSUMER_GROUP_FOR_SESS Procedure
- 164.4.28 SWITCH_CONSUMER_GROUP_FOR_USER Procedure
- 164.4.29 SWITCH_PLAN Procedure
- 164.4.30 UPDATE_CATEGORY Procedure
- 164.4.31 UPDATE_CDB_AUTOTASK_DIRECTIVE Procedure
- 164.4.32 UPDATE_CDB_DEFAULT_DIRECTIVE Procedure
- 164.4.33 UPDATE_CDB_PLAN Procedure
- 164.4.34 UPDATE_CDB_PLAN_DIRECTIVE Procedure
- 164.4.35 UPDATE_CDB_PROFILE_DIRECTIVE Procedure
- 164.4.36 UPDATE_CONSUMER_GROUP Procedure
- 164.4.37 UPDATE_PLAN Procedure
- 164.4.38 UPDATE_PLAN_DIRECTIVE Procedure
- 164.4.39 VALIDATE_PENDING_AREA Procedure
- 165 DBMS_RESOURCE_MANAGER_PRIVS
-
166
DBMS_RESULT_CACHE
- 166.1 DBMS_RESULT_CACHE Security Model
- 166.2 DBMS_RESULT_CACHE Constants
-
166.3
Summary of DBMS_RESULT_CACHE Subprograms
- 166.3.1 BLACK_LIST Function
- 166.3.2 BLACK_LIST_ADD Procedure
- 166.3.3 BLACK_LIST_CLEAR Procedure
- 166.3.4 BLACK_LIST_REMOVE Procedure
- 166.3.5 BYPASS Procedure
- 166.3.6 FLUSH Function & Procedure
- 166.3.7 IGNORE_LIST Function
- 166.3.8 IGNORE_LIST_ADD Procedure
- 166.3.9 IGNORE_LIST_CLEAR Procedure
- 166.3.10 IGNORE_LIST_REMOVE Procedure
- 166.3.11 INVALIDATE Functions & Procedures
- 166.3.12 INVALIDATE_OBJECT Functions & Procedures
- 166.3.13 MEMORY_REPORT Procedure
- 166.3.14 OBJECT_BLACK_LIST Function
- 166.3.15 OBJECT_BLACK_LIST_ADD Procedure
- 166.3.16 OBJECT_BLACK_LIST_CLEAR Procedure
- 166.3.17 OBJECT_BLACK_LIST_REMOVE Procedure
- 166.3.18 STATUS Function
- 166.3.19 BLOCK_LIST Function
- 166.3.20 BLOCK_LIST_ADD Procedure
- 166.3.21 BLOCK_LIST_CLEAR Procedure
- 166.3.22 BLOCK_LIST_REMOVE Procedure
- 166.3.23 OBJECT_BLOCK_LIST Function
- 166.3.24 OBJECT_BLOCK_LIST_ADD Procedure
- 166.3.25 OBJECT_BLOCK_LIST_CLEAR Procedure
- 166.3.26 OBJECT_BLOCK_LIST_REMOVE Procedure
- 167 DBMS_RESUMABLE
-
168
DBMS_RLS
- 168.1 DBMS_RLS Overview
- 168.2 DBMS_RLS Security Model
- 168.3 DBMS_RLS Constants
- 168.4 DBMS_RLS Operational Notes
- 168.5 DBMS_RLS Rules and Limits
-
168.6
Summary of DBMS_RLS Subprograms
- 168.6.1 ADD_GROUPED_POLICY Procedure
- 168.6.2 ADD_POLICY Procedure
- 168.6.3 ADD_POLICY_CONTEXT Procedure
- 168.6.4 ALTER_POLICY Procedure
- 168.6.5 ALTER_GROUPED_POLICY Procedure
- 168.6.6 CREATE_POLICY_GROUP Procedure
- 168.6.7 DELETE_POLICY_GROUP Procedure
- 168.6.8 DISABLE_GROUPED_POLICY Procedure
- 168.6.9 DROP_GROUPED_POLICY Procedure
- 168.6.10 DROP_POLICY Procedure
- 168.6.11 DROP_POLICY_CONTEXT Procedure
- 168.6.12 ENABLE_GROUPED_POLICY Procedure
- 168.6.13 ENABLE_POLICY Procedure
- 168.6.14 REFRESH_GROUPED_POLICY Procedure
- 168.6.15 REFRESH_POLICY Procedure
- 169 DBMS_ROLLING
-
170
DBMS_ROWID
- 170.1 DBMS_ROWID Security Model
- 170.2 DBMS_ROWID Types
- 170.3 DBMS_ROWID Exceptions
- 170.4 DBMS_ROWID Operational Notes
- 170.5 DBMS_ROWID Examples
-
170.6
Summary of DBMS_ROWID Subprograms
- 170.6.1 ROWID_BLOCK_NUMBER Function
- 170.6.2 ROWID_CREATE Function
- 170.6.3 ROWID_INFO Procedure
- 170.6.4 ROWID_OBJECT Function
- 170.6.5 ROWID_RELATIVE_FNO Function
- 170.6.6 ROWID_ROW_NUMBER Function
- 170.6.7 ROWID_TO_ABSOLUTE_FNO Function
- 170.6.8 ROWID_TO_EXTENDED Function
- 170.6.9 ROWID_TO_RESTRICTED Function
- 170.6.10 ROWID_TYPE Function
- 170.6.11 ROWID_VERIFY Function
-
171
DBMS_RULE
- 171.1 DBMS_RULE Overview
- 171.2 DBMS_RULE Security Model
-
171.3
Summary of DBMS_RULE Subprograms
- 171.3.1 CLOSE_ITERATOR Procedure
- 171.3.2 EVALUATE Procedure
- 171.3.3 EVALUATE_EXPRESSION Procedure
- 171.3.4 EVALUATE_EXPRESSION_ITERATOR Procedure
- 171.3.5 EVALUATE_RULE Procedure
- 171.3.6 EVALUATE_RULE_ITERATOR Procedure
- 171.3.7 GET_NEXT_HIT Function
- 171.3.8 GET_NEXT_RESULT Function
- 171.3.9 IS_FAST Procedure
-
172
DBMS_RULE_ADM
- 172.1 DBMS_RULE_ADM Overview
- 172.2 DBMS_RULE_ADM Security Model
-
172.3
Summary of DBMS_RULE_ADM Subprograms
- 172.3.1 ADD_RULE Procedure
- 172.3.2 ALTER_EVALUATION_CONTEXT Procedure
- 172.3.3 ALTER_RULE Procedure
- 172.3.4 CREATE_EVALUATION_CONTEXT Procedure
- 172.3.5 CREATE_RULE Procedure
- 172.3.6 CREATE_RULE_SET Procedure
- 172.3.7 DROP_EVALUATION_CONTEXT Procedure
- 172.3.8 DROP_RULE Procedure
- 172.3.9 DROP_RULE_SET Procedure
- 172.3.10 GRANT_OBJECT_PRIVILEGE Procedure
- 172.3.11 GRANT_SCHEMA_PRIVILEGE Procedure
- 172.3.12 GRANT_SYSTEM_PRIVILEGE Procedure
- 172.3.13 REMOVE_RULE Procedure
- 172.3.14 REVOKE_OBJECT_PRIVILEGE Procedure
- 172.3.15 REVOKE_SCHEMA_PRIVILEGE Procedure
- 172.3.16 REVOKE_SYSTEM_PRIVILEGE Procedure
- 173 DBMS_SAGA
-
174
DBMS_SCHEDULER
- 174.1 DBMS_SCHEDULER Deprecated Subprograms
- 174.2 DBMS_SCHEDULER Security Model
- 174.3 DBMS_SCHEDULER Rules and Limits
- 174.4 DBMS_SCHEDULER Operational Notes
-
174.5
DBMS_SCHEDULER Data Structures
- 174.5.1 DBMS_SCHEDULER JOBARG Object Type
- 174.5.2 JOBARG_ARRAY Table Type
- 174.5.3 DBMS_SCHEDULER JOB_DEFINITION Object Type
- 174.5.4 JOB_DEFINITION_ARRAY Table Type
- 174.5.5 JOBATTR Object Type
- 174.5.6 JOBATTR_ARRAY Table Type
- 174.5.7 SCHEDULER$_STEP_TYPE Object Type
- 174.5.8 SCHEDULER$_STEP_TYPE_LIST Table Type
- 174.5.9 SCHEDULER$_EVENT_INFO Object Type
- 174.5.10 SCHEDULER_FILEWATCHER_RESULT Object Type
- 174.5.11 SCHEDULER_FILEWATCHER_REQUEST Object Type
-
174.6
Summary of DBMS_SCHEDULER Subprograms
- 174.6.1 ADD_EVENT_QUEUE_SUBSCRIBER Procedure
- 174.6.2 ADD_GROUP_MEMBER Procedure
- 174.6.3 ADD_JOB_EMAIL_NOTIFICATION Procedure
- 174.6.4 ADD_TO_INCOMPATIBILITY Procedure
- 174.6.5 ALTER_CHAIN Procedure
- 174.6.6 ALTER_RUNNING_CHAIN Procedure
- 174.6.7 CLOSE_WINDOW Procedure
- 174.6.8 COPY_JOB Procedure
- 174.6.9 CREATE_CHAIN Procedure
- 174.6.10 CREATE_CREDENTIAL Procedure
- 174.6.11 CREATE_DATABASE_DESTINATION Procedure
- 174.6.12 CREATE_EVENT_SCHEDULE Procedure
- 174.6.13 CREATE_FILE_WATCHER Procedure
- 174.6.14 CREATE_GROUP Procedure
- 174.6.15 CREATE_INCOMPATIBILITY Procedure
- 174.6.16 CREATE_JOB Procedure
- 174.6.17 CREATE_JOB_CLASS Procedure
- 174.6.18 CREATE_JOBS Procedure
- 174.6.19 CREATE_PROGRAM Procedure
- 174.6.20 CREATE_RESOURCE Procedure
- 174.6.21 CREATE_SCHEDULE Procedure
- 174.6.22 CREATE_WINDOW Procedure
- 174.6.23 DEFINE_ANYDATA_ARGUMENT Procedure
- 174.6.24 DEFINE_CHAIN_EVENT_STEP Procedure
- 174.6.25 DEFINE_CHAIN_RULE Procedure
- 174.6.26 DEFINE_CHAIN_STEP Procedure
- 174.6.27 DEFINE_METADATA_ARGUMENT Procedure
- 174.6.28 DEFINE_PROGRAM_ARGUMENT Procedure
- 174.6.29 DISABLE Procedure
- 174.6.30 DROP_AGENT_DESTINATION Procedure
- 174.6.31 DROP_CHAIN Procedure
- 174.6.32 DROP_CHAIN_RULE Procedure
- 174.6.33 DROP_CHAIN_STEP Procedure
- 174.6.34 DROP_CREDENTIAL Procedure
- 174.6.35 DROP_DATABASE_DESTINATION Procedure
- 174.6.36 DROP_FILE_WATCHER Procedure
- 174.6.37 DROP_GROUP Procedure
- 174.6.38 DROP_INCOMPATIBILITY Procedure
- 174.6.39 DROP_JOB Procedure
- 174.6.40 DROP_JOB_CLASS Procedure
- 174.6.41 DROP_PROGRAM Procedure
- 174.6.42 DROP_PROGRAM_ARGUMENT Procedure
- 174.6.43 DROP_RESOURCE Procedure
- 174.6.44 DROP_SCHEDULE Procedure
- 174.6.45 DROP_WINDOW Procedure
- 174.6.46 DUMP_IN_MEMORY_TRACE Procedure
- 174.6.47 ENABLE Procedure
- 174.6.48 END_DETACHED_JOB_RUN Procedure
- 174.6.49 EVALUATE_CALENDAR_STRING Procedure
- 174.6.50 EVALUATE_RUNNING_CHAIN Procedure
- 174.6.51 GENERATE_JOB_NAME Function
- 174.6.52 GET_AGENT_INFO Function
- 174.6.53 GET_AGENT_VERSION Function
- 174.6.54 GET_ATTRIBUTE Procedure
- 174.6.55 GET_FILE Procedure
- 174.6.56 GET_SCHEDULER_ATTRIBUTE Procedure
- 174.6.57 OPEN_WINDOW Procedure
- 174.6.58 PURGE_LOG Procedure
- 174.6.59 PUT_FILE Procedure
- 174.6.60 REMOVE_EVENT_QUEUE_SUBSCRIBER Procedure
- 174.6.61 REMOVE_FROM_INCOMPATIBILITY Procedure
- 174.6.62 REMOVE_GROUP_MEMBER Procedure
- 174.6.63 REMOVE_JOB_EMAIL_NOTIFICATION Procedure
- 174.6.64 RESET_JOB_ARGUMENT_VALUE Procedure
- 174.6.65 RUN_CHAIN Procedure
- 174.6.66 RUN_JOB Procedure
- 174.6.67 SET_AGENT_REGISTRATION_PASS Procedure
- 174.6.68 SET_ATTRIBUTE Procedure
- 174.6.69 SET_ATTRIBUTE_NULL Procedure
- 174.6.70 SET_JOB_ANYDATA_VALUE Procedure
- 174.6.71 SET_JOB_ARGUMENT_VALUE Procedure
- 174.6.72 SET_JOB_ATTRIBUTES Procedure
- 174.6.73 SET_RESOURCE_CONSTRAINT Procedure
- 174.6.74 SET_SCHEDULER_ATTRIBUTE Procedure
- 174.6.75 STOP_JOB Procedure
- 175 DBMS_SEARCH
- 176 DBMS_SERVER_ALERT
- 177 DBMS_SERVICE
-
178
DBMS_SESSION
- 178.1 DBMS_SESSION Security Model
- 178.2 DBMS_SESSION Operational Notes
- 178.3 DBMS_SESSION Data Structures
-
178.4
Summary of DBMS_SESSION Subprograms
- 178.4.1 CLEAR_ALL_CONTEXT Procedure
- 178.4.2 CLEAR_ALL_LOCAL_CONTEXTS Procedure
- 178.4.3 CLEAR_CONTEXT Procedure
- 178.4.4 CLEAR_IDENTIFIER Procedure
- 178.4.5 CLOSE_DATABASE_LINK Procedure
- 178.4.6 CURRENT_IS_ROLE_ENABLED Function
- 178.4.7 FREE_UNUSED_USER_MEMORY Procedure
- 178.4.8 GET_PACKAGE_MEMORY_UTILIZATION Procedure
- 178.4.9 IS_ROLE_ENABLED Function
- 178.4.10 IS_SESSION_ALIVE Function
- 178.4.11 LIST_CONTEXT Procedures
- 178.4.12 MODIFY_PACKAGE_STATE Procedure
- 178.4.13 RESET_PACKAGE Procedure
- 178.4.14 SESSION_IS_ROLE_ENABLED Function
- 178.4.15 SESSION_TRACE_DISABLE Procedure
- 178.4.16 SESSION _TRACE_ENABLE Procedure
- 178.4.17 SET_CONTEXT Procedure
- 178.4.18 SET_EDITION_DEFERRED Procedure
- 178.4.19 SET_IDENTIFIER Procedure
- 178.4.20 SET_NLS Procedure
- 178.4.21 SET_ROLE Procedure
- 178.4.22 SET_SQL_TRACE Procedure
- 178.4.23 SLEEP Procedure
- 178.4.24 SWITCH_CURRENT_CONSUMER_GROUP Procedure
- 178.4.25 UNIQUE_SESSION_ID Function
- 178.4.26 USE_DEFAULT_EDITION_ALWAYS procedure
- 178.4.27 USE_DEFAULT_EDITION_DEFERRED procedure
- 179 DBMS_SFW_ACL_ADMIN
- 180 DBMS_SHARED_POOL
- 181 DBMS_SHARDING_DIRECTORY
-
182
DBMS_SODA
- 182.1 DBMS_SODA Security Model
-
182.2
Summary of DBMS_SODA Subprograms
- 182.2.1 CREATE_COLLECTION Function
- 182.2.2 DROP_COLLECTION Function
- 182.2.3 GET_AS_OF_SCN Function
- 182.2.4 GET_AS_OF_TIMESTAMP Function
- 182.2.5 GET_DEFAULT_METADATA_AS_CLOB Function
- 182.2.6 GET_DEFAULT_METADATA_AS_VARCHAR2 Function
- 182.2.7 LIST_COLLECTION_NAMES Function
- 182.2.8 OPEN_COLLECTION Function
-
182.3
Summary of SODA Online Redefinition
Subprograms
- 182.3.1 ABORT_REDEF_COLLECTION Procedure
- 182.3.2 CAN_REDEF_COLLECTION Procedure
- 182.3.3 COPY_COLLECTION_DEPENDENTS Procedure
- 182.3.4 CREATE_INTERIM_COLLECTION Procedure
- 182.3.5 FINISH_REDEF_COLLECTION Procedure
- 182.3.6 START_REDEF_COLLECTION Procedure
- 182.3.7 SYNC_INTERIM_COLLETION Procedure
- 182.3.8 TO_UUID Function
-
183
DBMS_SPACE
- 183.1 DBMS_SPACE Security Model
- 183.2 DBMS_SPACE Data Structures
-
183.3
Summary of DBMS_SPACE Subprograms
- 183.3.1 DBMS_SPACE ASA_RECOMMENDATIONS Function
- 183.3.2 CREATE_INDEX_COST Procedure
- 183.3.3 CREATE_TABLE_COST Procedures
- 183.3.4 FREE_BLOCKS Procedure
- 183.3.5 ISDATAFILEDROPPABLE_NAME Procedure
- 183.3.6 OBJECT_DEPENDENT_SEGMENTS Function
- 183.3.7 OBJECT_GROWTH_TREND Function
- 183.3.8 SHRINK_TABLESPACE Procedure
- 183.3.9 SPACE_USAGE Procedures
- 183.3.10 UNUSED_SPACE Procedure
-
184
DBMS_SPACE_ADMIN
- 184.1 DBMS_SPACE_ADMIN Security Model
- 184.2 DBMS_SPACE_ADMIN Constants
- 184.3 DBMS_SPACE_ADMIN Operational Notes
-
184.4
Summary of DBMS_SPACE_ADMIN Subprograms
- 184.4.1 ASSM_SEGMENT_VERIFY Procedure
- 184.4.2 ASSM_TABLESPACE_VERIFY Procedure
- 184.4.3 DROP_EMPTY_SEGMENTS Procedure
- 184.4.4 GET_SEGADV_ATTRIB Procedure
- 184.4.5 MATERIALIZE_DEFERRED_SEGMENTS Procedure
- 184.4.6 SEGMENT_CORRUPT Procedure
- 184.4.7 SEGMENT_DROP_CORRUPT Procedure
- 184.4.8 SEGMENT_DUMP Procedure
- 184.4.9 SEGMENT_VERIFY Procedure
- 184.4.10 SET_SEGADV_ATTRIB Procedure
- 184.4.11 TABLESPACE_FIX_BITMAPS Procedure
- 184.4.12 TABLESPACE_FIX_SEGMENT_STATES Procedure
- 184.4.13 TABLESPACE_MIGRATE_FROM_LOCAL Procedure
- 184.4.14 TABLESPACE_MIGRATE_TO_LOCAL Procedure
- 184.4.15 TABLESPACE_REBUILD_BITMAPS Procedure
- 184.4.16 TABLESPACE_REBUILD_QUOTAS Procedure
- 184.4.17 TABLESPACE_RELOCATE_BITMAPS Procedure
- 184.4.18 TABLESPACE_VERIFY Procedure
-
185
DBMS_SPD
- 185.1 DBMS_SPD Overview
- 185.2 DBMS_SPD Security Model
- 185.3 DBMS_SPD Views
-
185.4
Summary of DBMS_SPD Subprograms
- 185.4.1 ALTER_SQL_PLAN_DIRECTIVE Procedure
- 185.4.2 CREATE_STGTAB_DIRECTIVE Procedure
- 185.4.3 DROP_SQL_PLAN_DIRECTIVE Procedure
- 185.4.4 FLUSH_SQL_PLAN_DIRECTIVE Procedure
- 185.4.5 GET_PREFS Function
- 185.4.6 PACK_STGTAB_DIRECTIVE Function
- 185.4.7 SET_PREFS Procedure
- 185.4.8 UNPACK_STGTAB_DIRECTIVE Function
-
186
DBMS_SPM
- 186.1 DBMS_SPM Overview
- 186.2 DBMS_SPM Security Model
- 186.3 DBMS_SPM Constants
- 186.4 DBMS_SPM Examples
- 186.5 DBMS_SPM Data Structures
-
186.6
Summary of DBMS_SPM Subprograms
- 186.6.1 ACCEPT_SQL_PLAN_BASELINE Procedure
- 186.6.2 ADD_VERIFIED_SQL_PLAN_BASELINE Function
- 186.6.3 ALTER_SQL_PLAN_BASELINE Function
- 186.6.4 CANCEL_EVOLVE_TASK Procedure
- 186.6.5 CONFIGURE Procedure
- 186.6.6 CREATE_EVOLVE_TASK Function
- 186.6.7 CREATE_STGTAB_BASELINE Procedure
- 186.6.8 DROP_EVOLVE_TASK Procedure
- 186.6.9 DROP_MIGRATED_STORED_OUTLINE Function
- 186.6.10 DROP_SQL_PLAN_BASELINE Function
- 186.6.11 EVOLVE_SQL_PLAN_BASELINE Function
- 186.6.12 EXECUTE_EVOLVE_TASK Function
- 186.6.13 INTERRUPT_EVOLVE_TASK Procedure
- 186.6.14 LOAD_PLANS_FROM_AWR Function
- 186.6.15 LOAD_PLANS_FROM_CURSOR_CACHE Functions
- 186.6.16 LOAD_PLANS_FROM_SQLSET Function
- 186.6.17 MIGRATE_STORED_OUTLINE Functions
- 186.6.18 PACK_STGTAB_BASELINE Function
- 186.6.19 RESET_EVOLVE_TASK Procedure
- 186.6.20 RESUME_EVOLVE_TASK Procedure
- 186.6.21 REPORT_AUTO_EVOLVE_TASK Function
- 186.6.22 REPORT_EVOLVE_TASK Function
- 186.6.23 SET_EVOLVE_TASK_PARAMETER Procedure
- 186.6.24 UNPACK_STGTAB_BASELINE Function
-
187
DBMS_SQL
- 187.1 DBMS_SQL Overview
- 187.2 DBMS_SQL Security Model
- 187.3 DBMS_SQL Constants
- 187.4 DBMS_SQL Operational Notes
-
187.5
DBMS_SQL Execution Flow
- 187.5.1 OPEN_CURSOR
- 187.5.2 PARSE
- 187.5.3 BIND_VARIABLE, BIND_VARIABLE_PKG or BIND_ARRAY
- 187.5.4 DEFINE_COLUMN, DEFINE_COLUMN_LONG, or DEFINE_ARRAY
- 187.5.5 EXECUTE
- 187.5.6 FETCH_ROWS or EXECUTE_AND_FETCH
- 187.5.7 VARIABLE_VALUE, VARIABLE_VALUE_PKG, COLUMN_VALUE, or COLUMN_VALUE_LONG
- 187.5.8 CLOSE_CURSOR
- 187.6 DBMS_SQL Exceptions
- 187.7 DBMS_SQL Examples
-
187.8
DBMS_SQL Data Structures
- 187.8.1 DBMS_SQL DESC_REC Record Type
- 187.8.2 DBMS_SQL DESC_REC2 Record Type
- 187.8.3 DBMS_SQL DESC_REC3 Record Type
- 187.8.4 DBMS_SQL DESC_REC4 Record Type
- 187.8.5 DBMS_SQL BFILE_TABLE Table Type
- 187.8.6 DBMS_SQL BINARY_DOUBLE_TABLE Table Type
- 187.8.7 DBMS_SQL BINARY_FLOAT_TABLE Table Type
- 187.8.8 DBMS_SQL BLOB_TABLE Table Type
- 187.8.9 DBMS_SQL BOOLEAN_TABLE Table Type
- 187.8.10 DBMS_SQL CLOB_TABLE Table Type
- 187.8.11 DBMS_SQL DATE_TABLE Table Type
- 187.8.12 DBMS_SQL DESC_TAB Table Type
- 187.8.13 DBMS_SQL DESC_TAB2 Table Type
- 187.8.14 DBMS_SQL DESC_TAB3 Table Type
- 187.8.15 DBMS_SQL DESC_TAB4 Table Type
- 187.8.16 DBMS_SQL INTERVAL_DAY_TO_SECOND_TABLE Table Type
- 187.8.17 DBMS_SQL INTERVAL_YEAR_TO_MONTH_TABLE Table Type
- 187.8.18 DBMS_SQL JSON_TABLE Table Type
- 187.8.19 DBMS_SQL NUMBER_TABLE Table Type
- 187.8.20 DBMS_SQL TIME_TABLE Table Type
- 187.8.21 DBMS_SQL TIME_WITH_TIME_ZONE_TABLE Table Type
- 187.8.22 DBMS_SQL TIMESTAMP_TABLE Table Type
- 187.8.23 DBMS_SQL TIMESTAMP_WITH_LTZ_TABLE Table Type
- 187.8.24 DBMS_SQL TIMESTAMP_WITH_TIME_ZONE_TABLE Table Type
- 187.8.25 DBMS_SQL UROWID_TABLE Table Type
- 187.8.26 DBMS_SQL VARCHAR2_TABLE Table Type
- 187.8.27 DBMS_SQL VARCHAR2A Table Type
- 187.8.28 DBMS_SQL VARCHAR2S Table Type
- 187.8.29 DBMS_SQL VECTOR Table Type
-
187.9
Summary of DBMS_SQL Subprograms
- 187.9.1 BIND_ARRAY Procedures
- 187.9.2 BIND_VARIABLE Procedures
- 187.9.3 BIND_VARIABLE_PKG Procedure
- 187.9.4 CLOSE_CURSOR Procedure
- 187.9.5 COLUMN_VALUE Procedure
- 187.9.6 COLUMN_VALUE_LONG Procedure
- 187.9.7 DEFINE_ARRAY Procedure
- 187.9.8 DEFINE_COLUMN Procedures
- 187.9.9 DEFINE_COLUMN_CHAR Procedure
- 187.9.10 DEFINE_COLUMN_LONG Procedure
- 187.9.11 DEFINE_COLUMN_RAW Procedure
- 187.9.12 DEFINE_COLUMN_ROWID Procedure
- 187.9.13 DESCRIBE_COLUMNS Procedure
- 187.9.14 DESCRIBE_COLUMNS2 Procedure
- 187.9.15 DESCRIBE_COLUMNS3 Procedure
- 187.9.16 EXECUTE Function
- 187.9.17 EXECUTE_AND_FETCH Function
- 187.9.18 FETCH_ROWS Function
- 187.9.19 GET_NEXT_RESULT Procedures
- 187.9.20 IS_OPEN Function
- 187.9.21 LAST_ERROR_POSITION Function
- 187.9.22 LAST_ROW_COUNT Function
- 187.9.23 LAST_ROW_ID Function
- 187.9.24 LAST_SQL_FUNCTION_CODE Function
- 187.9.25 OPEN_CURSOR Functions
- 187.9.26 PARSE Procedures
- 187.9.27 RETURN_RESULT Procedures
- 187.9.28 TO_CURSOR_NUMBER Function
- 187.9.29 TO_REFCURSOR Function
- 187.9.30 VARIABLE_VALUE Procedures
- 187.9.31 VARIABLE_VALUE_PKG Procedure
-
188
DBMS_SQL_FIREWALL
- 188.1 DBMS_SQL_FIREWALL Overview
- 188.2 DBMS_SQL_FIREWALL Security Model
- 188.3 DBMS_SQL_FIREWALL Constants
-
188.4
Summary of DBMS_SQL_FIREWALL Subprograms
- 188.4.1 ADD_ALLOWED_CONTEXT Procedure
- 188.4.2 APPEND_ALLOW_LIST Procedure
- 188.4.3 APPEND_ALLOW_LIST_SINGLE_SQL Procedure
- 188.4.4 CREATE_CAPTURE Procedure
- 188.4.5 DELETE_ALLOWED_CONTEXT Procedure
- 188.4.6 DELETE_ALLOWED_SQL Procedure
- 188.4.7 DISABLE Procedure
- 188.4.8 DISABLE_ALLOW_LIST Procedure
- 188.4.9 DROP_ALLOW_LIST Procedure
- 188.4.10 DROP_CAPTURE Procedure
- 188.4.11 ENABLE Procedure
- 188.4.12 ENABLE_ALLOW_LIST Procedure
- 188.4.13 EXCLUDE Procedure
- 188.4.14 EXPORT_ALLOW_LIST Procedure
- 188.4.15 FLUSH_LOGS Procedure
- 188.4.16 GENERATE_ALLOW_LIST Procedure
- 188.4.17 IMPORT_ALLOW_LIST Procedure
- 188.4.18 INCLUDE Procedure
- 188.4.19 PURGE_LOG Procedure
- 188.4.20 START_CAPTURE Procedure
- 188.4.21 STOP_CAPTURE Procedure
- 188.4.22 UPDATE_ALLOW_LIST_ENFORCEMENT Procedure
- 189 DBMS_SQL_MONITOR
-
190
DBMS_SQL_TRANSLATOR
- 190.1 DBMS_SQL_TRANSLATOR Security Model
- 190.2 DBMS_SQL_TRANSLATOR Constants
- 190.3 DBMS_SQL_TRANSLATOR Operational Notes
- 190.4 DBMS_SQL_TRANSLATOR Exceptions
- 190.5 DBMS_SQL_TRANSLATOR Examples
-
190.6
Summary of DBMS_SQL_TRANSLATOR Subprograms
- 190.6.1 CREATE_PROFILE Procedure
- 190.6.2 DEREGISTER_SQL_TRANSLATION Procedure
- 190.6.3 DEREGISTER_ERROR_TRANSLATION Procedure
- 190.6.4 DROP_PROFILE Procedure
- 190.6.5 ENABLE_ERROR_TRANSLATION Procedure
- 190.6.6 ENABLE_SQL_TRANSLATION Procedure
- 190.6.7 EXPORT_PROFILE Procedure
- 190.6.8 IMPORT_PROFILE Procedure
- 190.6.9 REGISTER_ERROR_TRANSLATION Procedure
- 190.6.10 REGISTER_SQL_TRANSLATION Procedure
- 190.6.11 SET_ATTRIBUTE Procedure
- 190.6.12 SQL_HASH Function
- 190.6.13 SQL_ID Function
- 190.6.14 TRANSLATE_ERROR Procedure
- 190.6.15 TRANSLATE_SQL Procedure
-
191
DBMS_SQLDIAG
- 191.1 DBMS_SQLDIAG Overview
- 191.2 DBMS_SQLDIAG Security Model
- 191.3 DBMS_SQLDIAG Constants
-
191.4
Summary of DBMS_SQLDIAG Subprograms
- 191.4.1 ACCEPT_SQL_PATCH Function & Procedure
- 191.4.2 ALTER_SQL_PATCH Procedure
- 191.4.3 CANCEL_DIAGNOSIS_TASK Procedure
- 191.4.4 CREATE_DIAGNOSIS_TASK Functions
- 191.4.5 CREATE_SQL_PATCH Function
- 191.4.6 CREATE_STGTAB_SQLPATCH Procedure
- 191.4.7 DROP_DIAGNOSIS_TASK Procedure
- 191.4.8 DROP_SQL_PATCH Procedure
- 191.4.9 EXECUTE_DIAGNOSIS_TASK Procedure
- 191.4.10 EXPLAIN_SQL_TESTCASE Function
- 191.4.11 EXPORT_SQL_TESTCASE Procedures
- 191.4.12 EXPORT_SQL_TESTCASE_DIR_BY_INC Function
- 191.4.13 EXPORT_SQL_TESTCASE_DIR_BY_TXT Function
- 191.4.14 GET_FIX_CONTROL Function
- 191.4.15 GET_SQL Function
- 191.4.16 IMPORT_SQL_TESTCASE Procedures
- 191.4.17 INCIDENTID_2_SQL Procedure
- 191.4.18 INTERRUPT_DIAGNOSIS_TASK Procedure
- 191.4.19 LOAD_SQLSET_FROM_TCB Function
- 191.4.20 PACK_STGTAB_SQLPATCH Procedure
- 191.4.21 REPLAY_SQL_TESTCASE Function
- 191.4.22 REPORT_SQL Function
- 191.4.23 REPORT_DIAGNOSIS_TASK Function
- 191.4.24 RESET_DIAGNOSIS_TASK Procedure
- 191.4.25 RESUME_DIAGNOSIS_TASK Procedure
- 191.4.26 SET_DIAGNOSIS_TASK_PARAMETER Procedure
- 191.4.27 SQL_DIAGNOSE_AND_REPAIR Function
- 191.4.28 UNPACK_STGTAB_SQLPATCH Procedure
-
192
DBMS_SQLPA
- 192.1 DBMS_SQLPA Overview
- 192.2 DBMS_SQLPA Security Model
-
192.3
Summary of DBMS_SQLPA Subprograms
- 192.3.1 CANCEL_ANALYSIS_TASK Procedure
- 192.3.2 CREATE_ANALYSIS_TASK Functions
- 192.3.3 DROP_ANALYSIS_TASK Procedure
- 192.3.4 EXECUTE_ANALYSIS_TASK Function & Procedure
- 192.3.5 INTERRUPT_ANALYSIS_TASK Procedure
- 192.3.6 REPORT_ANALYSIS_TASK Function
- 192.3.7 RESET_ANALYSIS_TASK Procedure
- 192.3.8 RESUME_ANALYSIS_TASK Procedure
- 192.3.9 SET_ANALYSIS_TASK_PARAMETER Procedures
- 192.3.10 SET_ANALYSIS_DEFAULT_PARAMETER Procedures
-
193
DBMS_SQLQ
- 193.1 DBMS_SQLQ Overview
-
193.2
Summary of DBMS_SQLQ Subprograms
- 193.2.1 ALTER_QUARANTINE Procedure
- 193.2.2 CREATE_QUARANTINE_BY_SQL_ID Function
- 193.2.3 CREATE_QUARANTINE_BY_SQL_TEXT Function
- 193.2.4 CREATE_STGTAB_QUARANTINE Procedure
- 193.2.5 DROP_QUARANTINE Procedure
- 193.2.6 GET_PARAM_VALUE_QUARANTINE Function
- 193.2.7 PACK_STGTAB_QUARANTINE Function
- 193.2.8 UNPACK_STGTAB_QUARANTINE Function
-
194
DBMS_SQLSET
- 194.1 DBMS_SQLSET Overview
- 194.2 DBMS_SQLSET Security Model
- 194.3 DBMS_SQLSET Data Structures
-
194.4
Summary of DBMS_SQLSET Subprograms
- 194.4.1 ADD_REFERENCE Function
- 194.4.2 CAPTURE_CURSOR_CACHE Procedure
- 194.4.3 CREATE_SQLSET Procedure and Function
- 194.4.4 CREATE_STGTAB Procedure
- 194.4.5 DELETE_SQLSET Procedure
- 194.4.6 DROP_SQLSET Procedure
- 194.4.7 LOAD_SQLSET Procedure
- 194.4.8 PACK_STGTAB Procedure
- 194.4.9 REMAP_STGTAB Procedure
- 194.4.10 REMOVE_REFERENCE Procedure
- 194.4.11 SELECT_CURSOR_CACHE Function
- 194.4.12 SELECT_SQL_TRACE Function
- 194.4.13 SELECT_SQLPA_TASK Function
- 194.4.14 SELECT_SQLSET Function
- 194.4.15 SELECT_WORKLOAD_REPOSITORY Function
- 194.4.16 UNPACK_STGTAB Procedure
- 194.4.17 UPDATE_SQLSET Procedures
-
195
DBMS_SQLTUNE
- 195.1 DBMS_SQLTUNE Overview
- 195.2 DBMS_SQLTUNE Security Model
- 195.3 DBMS_SQLTUNE Data Structures
- 195.4 DBMS_SQLTUNE Subprogram Groups
-
195.5
Summary of DBMS_SQLTUNE Subprograms
- 195.5.1 ACCEPT_ALL_SQL_PROFILES Procedure
- 195.5.2 ACCEPT_SQL_PROFILE Procedure and Function
- 195.5.3 ADD_SQLSET_REFERENCE Function
- 195.5.4 ALTER_SQL_PROFILE Procedure
- 195.5.5 CANCEL_TUNING_TASK Procedure
- 195.5.6 CAPTURE_CURSOR_CACHE_SQLSET Procedure
- 195.5.7 CREATE_SQL_PLAN_BASELINE Procedure
- 195.5.8 CREATE_SQLSET Procedure and Function
- 195.5.9 CREATE_STGTAB_SQLPROF Procedure
- 195.5.10 CREATE_STGTAB_SQLSET Procedure
- 195.5.11 CREATE_TUNING_TASK Functions
- 195.5.12 DELETE_SQLSET Procedure
- 195.5.13 DROP_SQL_PROFILE Procedure
- 195.5.14 DROP_SQLSET Procedure
- 195.5.15 DROP_TUNING_TASK Procedure
- 195.5.16 EXECUTE_TUNING_TASK Function and Procedure
- 195.5.17 IMPLEMENT_TUNING_TASK Procedure
- 195.5.18 INTERRUPT_TUNING_TASK Procedure
- 195.5.19 LOAD_SQLSET Procedure
- 195.5.20 PACK_STGTAB_SQLPROF Procedure
- 195.5.21 PACK_STGTAB_SQLSET Procedure
- 195.5.22 REMAP_STGTAB_SQLPROF Procedure
- 195.5.23 REMAP_STGTAB_SQLSET Procedure
- 195.5.24 REMOVE_SQLSET_REFERENCE Procedure
- 195.5.25 REPORT_AUTO_TUNING_TASK Function
- 195.5.26 REPORT_SQL_DETAIL Function
- 195.5.27 REPORT_SQL_MONITOR Function
- 195.5.28 REPORT_SQL_MONITOR_LIST Function
- 195.5.29 REPORT_TUNING_TASK Function
- 195.5.30 REPORT_TUNING_TASK_XML Function
- 195.5.31 RESET_TUNING_TASK Procedure
- 195.5.32 RESUME_TUNING_TASK Procedure
- 195.5.33 SCHEDULE_TUNING_TASK Function
- 195.5.34 SCRIPT_TUNING_TASK Function
- 195.5.35 SELECT_CURSOR_CACHE Function
- 195.5.36 SELECT_SQL_TRACE Function
- 195.5.37 SELECT_SQLPA_TASK Function
- 195.5.38 SELECT_SQLSET Function
- 195.5.39 SELECT_WORKLOAD_REPOSITORY Function
- 195.5.40 SET_TUNING_TASK_PARAMETER Procedures
- 195.5.41 SQLTEXT_TO_SIGNATURE Function
- 195.5.42 UNPACK_STGTAB_SQLPROF Procedure
- 195.5.43 UNPACK_STGTAB_SQLSET Procedure
- 195.5.44 UPDATE_SQLSET Procedures
- 196 DBMS_STAT_FUNCS
-
197
DBMS_STATS
- 197.1 DBMS_STATS Overview
- 197.2 DBMS_STATS Deprecated Subprograms
- 197.3 DBMS_STATS Types
- 197.4 DBMS_STATS Constants
- 197.5 DBMS_STATS Operational Notes
- 197.6 DBMS_STATS Data Structures
-
197.7
Summary of DBMS_STATS Subprograms
- 197.7.1 ALTER_STATS_HISTORY_RETENTION Procedure
- 197.7.2 CANCEL_ADVISOR_TASK Procedure
- 197.7.3 CONFIGURE_ADVISOR_FILTER Function
- 197.7.4 CONFIGURE_ADVISOR_OBJ_FILTER Function
- 197.7.5 CONFIGURE_ADVISOR_OPR_FILTER Functions
- 197.7.6 CONFIGURE_ADVISOR_RULE_FILTER Function
- 197.7.7 CONVERT_RAW_VALUE Procedures
- 197.7.8 CONVERT_RAW_VALUE_NVARCHAR Procedure
- 197.7.9 CONVERT_RAW_VALUE_ROWID Procedure
- 197.7.10 COPY_TABLE_STATS Procedure
- 197.7.11 CREATE_ADVISOR_TASK Function
- 197.7.12 CREATE_EXTENDED_STATS Function
- 197.7.13 CREATE_STAT_TABLE Procedure
- 197.7.14 DELETE_COLUMN_STATS Procedure
- 197.7.15 DELETE_DATABASE_PREFS Procedure
- 197.7.16 DELETE_DATABASE_STATS Procedure
- 197.7.17 DELETE_DICTIONARY_STATS Procedure
- 197.7.18 DELETE_FIXED_OBJECTS_STATS Procedure
- 197.7.19 DELETE_INDEX_STATS Procedure
- 197.7.20 DELETE_PENDING_STATS Procedure
- 197.7.21 DELETE_PLSQL_PREFS Procedure
- 197.7.22 DELETE_PROCESSING_RATE Procedure
- 197.7.23 DELETE_SCHEMA_PREFS Procedure
- 197.7.24 DELETE_SCHEMA_STATS Procedure
- 197.7.25 DELETE_SYSTEM_STATS Procedure
- 197.7.26 DELETE_TABLE_PREFS Procedure
- 197.7.27 DELETE_TABLE_STATS Procedure
- 197.7.28 DIFF_TABLE_STATS_IN_HISTORY Function
- 197.7.29 DIFF_TABLE_STATS_IN_PENDING Function
- 197.7.30 DIFF_TABLE_STATS_IN_STATTAB Function
- 197.7.31 DROP_ADVISOR_TASK Procedure
- 197.7.32 DROP_EXTENDED_STATS Procedure
- 197.7.33 DROP_STAT_TABLE Procedure
- 197.7.34 EXECUTE_ADVISOR_TASK Function
- 197.7.35 EXPORT_COLUMN_STATS Procedure
- 197.7.36 EXPORT_DATABASE_PREFS Procedure
- 197.7.37 EXPORT_DATABASE_STATS Procedure
- 197.7.38 EXPORT_DICTIONARY_STATS Procedure
- 197.7.39 EXPORT_FIXED_OBJECTS_STATS Procedure
- 197.7.40 EXPORT_INDEX_STATS Procedure
- 197.7.41 EXPORT_PENDING_STATS Procedure
- 197.7.42 EXPORT_SCHEMA_PREFS Procedure
- 197.7.43 EXPORT_SCHEMA_STATS Procedure
- 197.7.44 EXPORT_SYSTEM_STATS Procedure
- 197.7.45 EXPORT_TABLE_PREFS Procedure
- 197.7.46 EXPORT_TABLE_STATS Procedure
- 197.7.47 FLUSH_DATABASE_MONITORING_INFO Procedure
- 197.7.48 GATHER_DATABASE_STATS Procedures
- 197.7.49 GATHER_DICTIONARY_STATS Procedure
- 197.7.50 GATHER_FIXED_OBJECTS_STATS Procedure
- 197.7.51 GATHER_INDEX_STATS Procedure
- 197.7.52 GATHER_PROCESSING_RATE Procedure
- 197.7.53 GATHER_SCHEMA_STATS Procedures
- 197.7.54 GATHER_SYSTEM_STATS Procedure
- 197.7.55 GATHER_TABLE_STATS Procedure
- 197.7.56 GENERATE_STATS Procedure
- 197.7.57 GET_ADVISOR_OPR_FILTER Procedure
- 197.7.58 GET_ADVISOR_RECS Function
- 197.7.59 GET_COLUMN_STATS Procedures
- 197.7.60 GET_INDEX_STATS Procedures
- 197.7.61 GET_PARAM Function
- 197.7.62 GET_PLSQL_PREFS Procedure
- 197.7.63 GET_PREFS Function
- 197.7.64 GET_STATS_HISTORY_AVAILABILITY Function
- 197.7.65 GET_STATS_HISTORY_RETENTION Function
- 197.7.66 GET_SYSTEM_STATS Procedure
- 197.7.67 GET_TABLE_STATS Procedure
- 197.7.68 IMPLEMENT_ADVISOR_TASK Function
- 197.7.69 IMPORT_COLUMN_STATS Procedure
- 197.7.70 IMPORT_DATABASE_PREFS Procedure
- 197.7.71 IMPORT_DATABASE_STATS Procedure
- 197.7.72 IMPORT_DICTIONARY_STATS Procedure
- 197.7.73 IMPORT_FIXED_OBJECTS_STATS Procedure
- 197.7.74 IMPORT_INDEX_STATS Procedure
- 197.7.75 IMPORT_SCHEMA_PREFS Procedure
- 197.7.76 IMPORT_SCHEMA_STATS Procedure
- 197.7.77 IMPORT_SYSTEM_STATS Procedure
- 197.7.78 IMPORT_TABLE_PREFS Procedure
- 197.7.79 IMPORT_TABLE_STATS Procedure
- 197.7.80 INTERRUPT_ADVISOR_TASK Procedure
- 197.7.81 LOCK_PARTITION_STATS Procedure
- 197.7.82 LOCK_SCHEMA_STATS Procedure
- 197.7.83 LOCK_TABLE_STATS Procedure
- 197.7.84 MERGE_COL_USAGE Procedure
- 197.7.85 PREPARE_COLUMN_VALUES Procedures
- 197.7.86 PREPARE_COLUMN_VALUES_NVARCHAR Procedure
- 197.7.87 PREPARE_COLUMN_VALUES_ROWID Procedure
- 197.7.88 PUBLISH_PENDING_STATS Procedure
- 197.7.89 PURGE_STATS Procedure
- 197.7.90 REMAP_STAT_TABLE Procedure
- 197.7.91 REPORT_ADVISOR_TASK Function
- 197.7.92 REPORT_COL_USAGE Function
- 197.7.93 REPORT_GATHER_AUTO_STATS Function
- 197.7.94 REPORT_GATHER_DATABASE_STATS Functions
- 197.7.95 REPORT_GATHER_DICTIONARY_STATS Functions
- 197.7.96 REPORT_GATHER_FIXED_OBJ_STATS Function
- 197.7.97 REPORT_GATHER_SCHEMA_STATS Functions
- 197.7.98 REPORT_GATHER_TABLE_STATS Function
- 197.7.99 REPORT_SINGLE_STATS_OPERATION Function
- 197.7.100 REPORT_STATS_OPERATIONS Function
- 197.7.101 RESET_ADVISOR_TASK Procedure
- 197.7.102 RESET_COL_USAGE Procedure
- 197.7.103 RESET_GLOBAL_PLSQL_PREFS_DEF Procedure
- 197.7.104 RESET_PARAM_DEFAULTS Procedure
- 197.7.105 RESTORE_DATABASE_STATS Procedure
- 197.7.106 RESTORE_DICTIONARY_STATS Procedure
- 197.7.107 RESTORE_FIXED_OBJECTS_STATS Procedure
- 197.7.108 RESTORE_SCHEMA_STATS Procedure
- 197.7.109 RESTORE_SYSTEM_STATS Procedure
- 197.7.110 RESTORE_TABLE_STATS Procedure
- 197.7.111 RESUME_ADVISOR_TASK Procedure
- 197.7.112 SCRIPT_ADVISOR_TASK Function
- 197.7.113 SEED_COL_USAGE Procedure
- 197.7.114 SET_ADVISOR_TASK_PARAMETER Procedure
- 197.7.115 SET_COLUMN_STATS Procedures
- 197.7.116 SET_DATABASE_PREFS Procedure
- 197.7.117 SET_GLOBAL_PLSQL_PREFS Procedure
- 197.7.118 SET_GLOBAL_PREFS Procedure
- 197.7.119 SET_INDEX_STATS Procedures
- 197.7.120 SET_PARAM Procedure
- 197.7.121 SET_PLSQL_PREFS Procedure
- 197.7.122 SET_PROCESSING_RATE Procedure
- 197.7.123 SET_SCHEMA_PREFS Procedure
- 197.7.124 SET_SYSTEM_STATS Procedure
- 197.7.125 SET_TABLE_PREFS Procedure
- 197.7.126 SET_TABLE_STATS Procedure
- 197.7.127 SHOW_EXTENDED_STATS_NAME Function
- 197.7.128 TRANSFER_STATS Procedure
- 197.7.129 UNLOCK_PARTITION_STATS Procedure
- 197.7.130 UNLOCK_SCHEMA_STATS Procedure
- 197.7.131 UNLOCK_TABLE_STATS Procedure
- 197.7.132 UPGRADE_STAT_TABLE Procedure
- 198 DBMS_STORAGE_MAP
-
199
DBMS_SYNC_REFRESH
- 199.1 DBMS_SYNC_REFRESH Overview
- 199.2 DBMS_SYNC_REFRESH Security Model
-
199.3
Summary of DBMS_SYNC_REFRESH Subprograms
- 199.3.1 ABORT_REFRESH Procedure
- 199.3.2 ALTER_REFRESH_STATS_RETENTION Procedure
- 199.3.3 CAN_SYNCREF_TABLE Procedure
- 199.3.4 EXECUTE_REFRESH Procedure
- 199.3.5 GET_ALL_GROUP_IDS Function
- 199.3.6 GET_GROUP_ID Function
- 199.3.7 GET_GROUP_ID_LIST Function
- 199.3.8 PREPARE_REFRESH Procedure
- 199.3.9 PREPARE_STAGING_LOG Procedure
- 199.3.10 PURGE_REFRESH_STATS Procedure
- 199.3.11 REGISTER_MVIEWS
- 199.3.12 REGISTER_PARTITION_OPERATION Procedure
- 199.3.13 UNREGISTER_MVIEWS
- 199.3.14 UNREGISTER_PARTITION_OPERATION Procedure
- 200 DBMS_TABLE_DATA
- 201 DBMS_TDB
-
202
DBMS_TF
- 202.1 DBMS_TF Overview
- 202.2 DBMS_TF Security Model
- 202.3 DBMS_TF Constants
- 202.4 DBMS_TF Operational Notes
- 202.5 DBMS_TF Execution Flow
- 202.6 DBMS_TF Restrictions
- 202.7 DBMS_TF Examples
-
202.8
DBMS_TF Data Structures
- 202.8.1 Supported Types Collections
- 202.8.2 COLUMN_DATA_T Record Type
- 202.8.3 COLUMN_METADATA_T Record Type
- 202.8.4 COLUMN_T Record Type
- 202.8.5 DESCRIBE_T Record Type
- 202.8.6 ENV_T Record Type
- 202.8.7 PARALLEL_ENV_T Record Type
- 202.8.8 TABLE_T Record Type
- 202.8.9 COLUMNS_NEW_T Table Type
- 202.8.10 COLUMNS_T Table Type
- 202.8.11 COLUMNS_WITH_TYPE_T Table Type
- 202.8.12 TABLE_COLUMNS_T Table Type
- 202.8.13 ROW_SET_T Table Type
- 202.8.14 XID_T Subtype
-
202.9
Summary of DBMS_TF Subprograms
- 202.9.1 COLUMN_TYPE_NAME Function
- 202.9.2 COL_TO_CHAR Function
- 202.9.3 CSTORE_EXISTS Function
- 202.9.4 CSTORE_GET Procedure
- 202.9.5 GET_COL Procedure
- 202.9.6 GET_ENV Function
- 202.9.7 GET_ROW_SET Procedure
- 202.9.8 GET_XID Function
- 202.9.9 PUT_COL Procedure
- 202.9.10 PUT_ROW_SET Procedure
- 202.9.11 ROW_REPLICATION Procedure
- 202.9.12 ROW_TO_CHAR Function
- 202.9.13 SUPPORTED_TYPE Function
- 202.9.14 TRACE Procedure
- 202.9.15 XSTORE_CLEAR Procedure
- 202.9.16 XSTORE_EXISTS Function
- 202.9.17 XSTORE_GET Procedure
- 202.9.18 XSTORE_REMOVE Procedure
- 202.9.19 XSTORE_SET Procedure
- 203 DBMS_TNS
- 204 DBMS_TRACE
-
205
DBMS_TRANSACTION
- 205.1 DBMS_TRANSACTION Security Model
-
205.2
Summary of DBMS_TRANSACTION Subprograms
- 205.2.1 ADVISE_COMMIT Procedure
- 205.2.2 ADVISE_NOTHING Procedure
- 205.2.3 ADVISE_ROLLBACK Procedure
- 205.2.4 COMMIT Procedure
- 205.2.5 COMMIT_COMMENT Procedure
- 205.2.6 COMMIT_FORCE Procedure
- 205.2.7 GET_TRANSACTION_ID Function
- 205.2.8 GET_TRANSACTION_TIMEOUT Function
- 205.2.9 GET_TRANSACTION_TYPE Function
- 205.2.10 LOCAL_TRANSACTION_ID Function
- 205.2.11 PURGE_LOST_DB_ENTRY Procedure
- 205.2.12 PURGE_MIXED Procedure
- 205.2.13 READ_ONLY Procedure
- 205.2.14 READ_WRITE Procedure
- 205.2.15 ROLLBACK Procedure
- 205.2.16 ROLLBACK_FORCE Procedure
- 205.2.17 ROLLBACK_SAVEPOINT Procedure
- 205.2.18 SAVEPOINT Procedure
- 205.2.19 START_TRANSACTION Function
- 205.2.20 STEP_ID Function
- 205.2.21 SUSPEND_TRANSACTION Procedure
- 205.2.22 USE_ROLLBACK_SEGMENT Procedure
- 206 DBMS_TRANSFORM
-
207
DBMS_TSDP_MANAGE
- 207.1 DBMS_TSDP_MANAGE Overview
- 207.2 DBMS_TSDP_MANAGE Security Model
-
207.3
Summary of DBMS_TSDP_MANAGE Subprograms
- 207.3.1 ADD_SENSITIVE_COLUMN Procedure
- 207.3.2 ALTER_SENSITIVE_COLUMN Procedure
- 207.3.3 ADD_SENSITIVE_TYPE Procedure
- 207.3.4 DROP_SENSITIVE_COLUMN Procedure
- 207.3.5 DROP_SENSITIVE_TYPE Procedure
- 207.3.6 DROP_SENSITIVE_TYPE_SOURCE Procedure
- 207.3.7 IMPORT_DISCOVERY_RESULT Procedure
- 207.3.8 IMPORT_SENSITIVE_TYPES Procedure
- 207.3.9 REMOVE_DISCOVERY_RESULT Procedure
-
208
DBMS_TSDP_PROTECT
- 208.1 DBMS_TSDP_PROTECT Overview
- 208.2 DBMS_TSDP_PROTECT Security Model
- 208.3 DBMS_TSDP_PROTECT Constants
- 208.4 DBMS_TSDP_PROTECT Data Structures
-
208.5
Summary of DBMS_TSDP_PROTECT Subprograms
- 208.5.1 ADD_POLICY Procedure
- 208.5.2 ALTER_POLICY Procedure
- 208.5.3 ASSOCIATE_POLICY Procedure
- 208.5.4 DISABLE_PROTECTION_COLUMN Procedure
- 208.5.5 DISABLE_PROTECTION_SOURCE Procedure
- 208.5.6 DISABLE_PROTECTION_TYPE Procedure
- 208.5.7 DROP_POLICY Procedure
- 208.5.8 ENABLE_PROTECTION_COLUMN Procedure
- 208.5.9 ENABLE_PROTECTION_SOURCE Procedure
- 208.5.10 ENABLE_PROTECTION_TYPE Procedure
- 209 DBMS_TTS
- 210 DBMS_TYPES
-
211
DBMS_UMF
-
211.1
Summary of DBMS_UMF Subprograms
- 211.1.1 CONFIGURE_NODE Procedure
- 211.1.2 CREATE_LINK Procedure
- 211.1.3 CREATE_TOPOLOGY Procedure
- 211.1.4 DROP_LINK Procedure
- 211.1.5 DROP_TOPOLOGY Procedure
- 211.1.6 ENABLE_SERVICE Procedure
- 211.1.7 GET_NODE_ID_LOCAL Function
- 211.1.8 GET_NODE_NAME_LOCAL Function
- 211.1.9 GET_TARGET_ID Function
- 211.1.10 GET_TOPOLOGY_NAME_LOCAL Function
- 211.1.11 QUERY_LINK_INFO Procedure
- 211.1.12 QUERY_NODE_INFO Procedures
- 211.1.13 REGISTER_NODE Function and Procedure
- 211.1.14 SWITCH_DESTINATION Procedure
- 211.1.15 UNCONFIGURE_NODE Procedure
- 211.1.16 UNREGISTER_NODE Procedure
-
211.1
Summary of DBMS_UMF Subprograms
- 212 DBMS_UNDO_ADV
- 213 DBMS_USER_CERTS
- 214 DBMS_USERDIAG
-
215
DBMS_UTILITY
- 215.1 DBMS_UTILITY Deprecated Subprograms
- 215.2 DBMS_UTILITY Security Model
- 215.3 DBMS_UTILITY Constants
- 215.4 DBMS_UTILITY Exceptions
-
215.5
DBMS_UTILITY Data Structures
- 215.5.1 DBMS_UTILITY INSTANCE_RECORD Record Type
- 215.5.2 DBMS_UTILITY DBLINK_ARRAY TABLE Type
- 215.5.3 DBMS_UTILITY INDEX_TABLE_TYPE Table Type
- 215.5.4 DBMS_UTILITY INSTANCE_TABLE Table Type
- 215.5.5 DBMS_UTILITY LNAME_ARRAY Table Type
- 215.5.6 DBMS_UTILITY NAME_ARRAY Table Type
- 215.5.7 DBMS_UTILITY NUMBER_ARRAY Table Type
- 215.5.8 DBMS_UTILITY UNCL_ARRAY Table Type
-
215.6
Summary of DBMS_UTILITY Subprograms
- 215.6.1 ACTIVE_INSTANCES Procedure
- 215.6.2 ANALYZE_DATABASE Procedure
- 215.6.3 ANALYZE_PART_OBJECT Procedure
- 215.6.4 ANALYZE_SCHEMA Procedure
- 215.6.5 CANONICALIZE Procedure
- 215.6.6 COMMA_TO_TABLE Procedures
- 215.6.7 COMPILE_SCHEMA Procedure
- 215.6.8 CREATE_ALTER_TYPE_ERROR_TABLE Procedure
- 215.6.9 CURRENT_INSTANCE Function
- 215.6.10 DATA_BLOCK_ADDRESS_BLOCK Function
- 215.6.11 DATA_BLOCK_ADDRESS_FILE Function
- 215.6.12 DB_VERSION Procedure
- 215.6.13 EXEC_DDL_STATEMENT Procedure
- 215.6.14 EXPAND_SQL_TEXT Procedure
- 215.6.15 FORMAT_CALL_STACK Function
- 215.6.16 FORMAT_ERROR_BACKTRACE Function
- 215.6.17 FORMAT_ERROR_STACK Function
- 215.6.18 GET_CPU_TIME Function
- 215.6.19 GET_DEPENDENCY Procedure
- 215.6.20 GET_ENDIANNESS Function
- 215.6.21 GET_HASH_VALUE Function
- 215.6.22 GET_PARAMETER_VALUE Function
- 215.6.23 GET_SQL_HASH Function
- 215.6.24 GET_TIME Function
- 215.6.25 GET_TZ_TRANSITIONS Procedure
- 215.6.26 INVALIDATE Procedure
- 215.6.27 IS_BIT_SET Function
- 215.6.28 IS_CLUSTER_DATABASE Function
- 215.6.29 MAKE_DATA_BLOCK_ADDRESS Function
- 215.6.30 NAME_RESOLVE Procedure
- 215.6.31 NAME_TOKENIZE Procedure
- 215.6.32 OLD_CURRENT_SCHEMA Function
- 215.6.33 OLD_CURRENT_USER Function
- 215.6.34 PORT_STRING Function
- 215.6.35 SQLID_TO_SQLHASH Function
- 215.6.36 TABLE_TO_COMMA Procedures
- 215.6.37 VALIDATE Procedure
- 215.6.38 WAIT_ON_PENDING_DML Function
-
216
DBMS_VECTOR
-
216.1
Summary of DBMS_VECTOR Subprograms
- 216.1.1 CREATE_CREDENTIAL
- 216.1.2 CREATE_INDEX
- 216.1.3 DISABLE_CHECKPOINT
- 216.1.4 DROP_CREDENTIAL
- 216.1.5 ENABLE_CHECKPOINT
- 216.1.6 DROP_ONNX_MODEL Procedure
- 216.1.7 GET_INDEX_STATUS
- 216.1.8 INDEX_ACCURACY_QUERY
- 216.1.9 INDEX_ACCURACY_REPORT
- 216.1.10 INDEX_VECTOR_MEMORY_ADVISOR
- 216.1.11 LOAD_ONNX_MODEL
- 216.1.12 LOAD_ONNX_MODEL_CLOUD
- 216.1.13 QUERY
- 216.1.14 REBUILD_INDEX
- 216.1.15 RERANK
- 216.1.16 UTL_TO_CHUNKS
- 216.1.17 UTL_TO_EMBEDDING and UTL_TO_EMBEDDINGS
- 216.1.18 UTL_TO_GENERATE_TEXT
-
216.1
Summary of DBMS_VECTOR Subprograms
-
217
DBMS_VECTOR_CHAIN
-
217.1
Summary of DBMS_VECTOR_CHAIN Subprograms
- 217.1.1 CREATE_CREDENTIAL
- 217.1.2 CREATE_LANG_DATA
- 217.1.3 CREATE_PREFERENCE
- 217.1.4 CREATE_VOCABULARY
- 217.1.5 DROP_CREDENTIAL
- 217.1.6 DROP_LANG_DATA
- 217.1.7 DROP_PREFERENCE
- 217.1.8 DROP_VOCABULARY
- 217.1.9 RERANK
- 217.1.10 UTL_TO_CHUNKS
- 217.1.11 UTL_TO_EMBEDDING and UTL_TO_EMBEDDINGS
- 217.1.12 UTL_TO_GENERATE_TEXT
- 217.1.13 UTL_TO_TEXT
- 217.1.14 UTL_TO_SUMMARY
- 217.2 Supported Languages and Data File Locations
-
217.1
Summary of DBMS_VECTOR_CHAIN Subprograms
- 218 DBMS_WARNING
- 219 DBMS_WM
-
220
DBMS_WORKLOAD_CAPTURE
- 220.1 DBMS_WORKLOAD_CAPTURE Overview
- 220.2 DBMS_WORKLOAD_CAPTURE Security Model
-
220.3
Summary of DBMS_WORKLOAD_CAPTURE Subprograms
- 220.3.1 ADD_FILTER Procedures
- 220.3.2 DECRYPT_CAPTURE Procedure
- 220.3.3 DELETE_CAPTURE_INFO Procedure
- 220.3.4 DELETE_FILTER Procedure
- 220.3.5 ENCRYPT_CAPTURE Procedure
- 220.3.6 EXPORT_AWR Procedure
- 220.3.7 FINISH_CAPTURE Procedure
- 220.3.8 GET_CAPTURE_INFO Function
- 220.3.9 IMPORT_AWR Function
- 220.3.10 REPORT Function
- 220.3.11 START_CAPTURE Procedure
-
221
DBMS_WORKLOAD_REPLAY
- 221.1 DBMS_WORKLOAD_REPLAY Overview
- 221.2 DBMS_WORKLOAD_REPLAY Security Model
-
221.3
Summary of DBMS_WORKLOAD_REPLAY Subprograms
- 221.3.1 ADD_CAPTURE Function
- 221.3.2 ADD_FILTER Procedure
- 221.3.3 ADD_SCHEDULE_ORDERING Function
- 221.3.4 ASSIGN_GROUP_TO_INSTANCE Procedure
- 221.3.5 BEGIN_REPLAY_SCHEDULE Procedure
- 221.3.6 CALIBRATE Function
- 221.3.7 CANCEL_REPLAY Procedure
- 221.3.8 COMPARE_PERIOD_REPORT Procedure
- 221.3.9 COMPARE_SQLSET_REPORT Function
- 221.3.10 CREATE_FILTER_SET Procedure
- 221.3.11 DELETE_FILTER Procedure
- 221.3.12 DELETE_REPLAY_INFO Procedure
- 221.3.13 END_REPLAY_SCHEDULE Procedure
- 221.3.14 EXPORT_AWR Procedure
- 221.3.15 GENERATE_CAPTURE_SUBSET Procedure
- 221.3.16 GET_DIVERGING_STATEMENT Function
- 221.3.17 GET_REPLAY_DIRECTORY Function
- 221.3.18 GET_REPLAY_INFO Function
- 221.3.19 GET_REPLAY_TIMEOUT Procedure
- 221.3.20 IMPORT_AWR Function
- 221.3.21 INITIALIZE_CONSOLIDATED_REPLAY Procedure
- 221.3.22 INITIALIZE_REPLAY Procedure
- 221.3.23 IS_REPLAY_PAUSED Function
- 221.3.24 LOAD_LONG_SQLTEXT Procedure
- 221.3.25 PAUSE_REPLAY Procedure
- 221.3.26 POPULATE_DIVERGENCE Procedure
- 221.3.27 PREPARE_CONSOLIDATED_REPLAY Procedure
- 221.3.28 PREPARE_REPLAY Procedure
- 221.3.29 PROCESS_CAPTURE Procedure
- 221.3.30 REMAP_CONNECTION Procedure
- 221.3.31 REMOVE_CAPTURE Procedure
- 221.3.32 REMOVE_SCHEDULE_ORDERING Procedure
- 221.3.33 REPORT Function
- 221.3.34 RESUME_REPLAY Procedure
- 221.3.35 REUSE_REPLAY_FILTER_SET Procedure
- 221.3.36 SET_ADVANCED_PARAMETER Procedure
- 221.3.37 SET_REPLAY_DIRECTORY Procedure
- 221.3.38 SET_REPLAY_TIMEOUT Procedure
- 221.3.39 SET_SQL_MAPPING Procedure
- 221.3.40 SET_USER_MAPPING Procedure
- 221.3.41 START_CONSOLIDATED_REPLAY Procedure
- 221.3.42 START_REPLAY Procedure
- 221.3.43 USE_FILTER_SET Procedure
-
222
DBMS_WORKLOAD_REPOSITORY
- 222.1 DBMS_WORKLOAD_REPOSITORY Examples
- 222.2 DBMS_WORKLOAD_REPOSITORY Data Structures
-
222.3
Summary of DBMS_WORKLOAD_REPOSITORY Subprograms
- 222.3.1 ADD_COLORED_SQL Procedure
- 222.3.2 ASH_GLOBAL_REPORT_HTML Function
- 222.3.3 ASH_GLOBAL_REPORT_TEXT Function
- 222.3.4 ASH_REPORT_ANALYTICS Function
- 222.3.5 ASH_REPORT_HTML Function
- 222.3.6 ASH_REPORT_TEXT Function
- 222.3.7 AWR_DIFF_REPORT_HTML Function
- 222.3.8 AWR_DIFF_REPORT_TEXT Function
- 222.3.9 AWR_EXP Procedure
- 222.3.10 AWR_GLOBAL_DIFF_REPORT_HTML Functions
- 222.3.11 AWR_GLOBAL_DIFF_REPORT_TEXT Functions
- 222.3.12 AWR_GLOBAL_REPORT_HTML Functions
- 222.3.13 AWR_GLOBAL_REPORT_TEXT Functions
- 222.3.14 AWR_IMP Procedure
- 222.3.15 AWR_REPORT_HTML Function
- 222.3.16 AWR_REPORT_TEXT Function
- 222.3.17 AWR_SET_REPORT_THRESHOLDS Procedure
- 222.3.18 AWR_SQL_REPORT_HTML Function
- 222.3.19 AWR_SQL_REPORT_TEXT Function
- 222.3.20 CONTROL_RESTRICTED_SNAPSHOT Procedure
- 222.3.21 CREATE_BASELINE Functions and Procedures
- 222.3.22 CREATE_BASELINE_TEMPLATE Procedures
- 222.3.23 CREATE_REMOTE_SNAPSHOT Function and Procedure
- 222.3.24 CREATE_SNAPSHOT Function and Procedure
- 222.3.25 DROP_BASELINE Procedure
- 222.3.26 DROP_BASELINE_TEMPLATE Procedure
- 222.3.27 DROP_SNAPSHOT_RANGE Procedure
- 222.3.28 LOCAL_AWR_DBID Function
- 222.3.29 MODIFY_BASELINE_WINDOW_SIZE Procedure
- 222.3.30 MODIFY_SNAPSHOT_SETTINGS Procedures
- 222.3.31 PURGE_SQL_DETAILS Procedure
- 222.3.32 REGISTER_REMOTE_DATABASE Procedures
- 222.3.33 REMOVE_COLORED_SQL Procedure
- 222.3.34 RENAME_BASELINE Procedure
- 222.3.35 SELECT_BASELINE_DETAILS Function
- 222.3.36 SELECT_BASELINE_METRIC Function
- 222.3.37 UNREGISTER_REMOTE_DATABASE Procedures
- 222.3.38 UPDATE_DATAFILE_INFO Procedure
- 222.3.39 UPDATE_OBJECT_INFO Procedure
-
223
DBMS_XDB
- 223.1 DBMS_XDB Overview
- 223.2 DBMS_XDB Security Model
- 223.3 DBMS_XDB Constants
-
223.4
Summary of DBMS_XDB Subprograms
- 223.4.1 ACLCHECKPRIVILEGES Function
- 223.4.2 APPENDRESOURCEMETADATA Procedure
- 223.4.3 CHANGEOWNER Procedure
- 223.4.4 CHANGEPRIVILEGES Function
- 223.4.5 CHECKPRIVILEGES Function
- 223.4.6 CREATEFOLDER Function
- 223.4.7 CREATEOIDPATH Function
- 223.4.8 CREATERESOURCE Functions
- 223.4.9 DELETERESOURCE Procedure
- 223.4.10 DELETERESOURCEMETADATA Procedures
- 223.4.11 ENABLEDIGESTAUTHENTICATION Procedure
- 223.4.12 EXISTSRESOURCE Function
- 223.4.13 GETACLDOCUMENT Function
- 223.4.14 GETCONTENTBLOB Function
- 223.4.15 GETCONTENTCLOB Function
- 223.4.16 GETCONTENTVARCHAR2 Function
- 223.4.17 GETCONTENTXMLREF Function
- 223.4.18 GETCONTENTXMLTYPE Function
- 223.4.19 GETHTTPREQUESTHEADER Function
- 223.4.20 GETLOCKTOKEN Procedure
- 223.4.21 GETPRIVILEGES Function
- 223.4.22 GETRESOID Function
- 223.4.23 GETXDB_TABLESPACE Function
- 223.4.24 HASBLOBCONTENT Function
- 223.4.25 HASCHARCONTENT Function
- 223.4.26 HASXMLCONTENT Function
- 223.4.27 HASXMLREFERENCE Function
- 223.4.28 ISFOLDER Function
- 223.4.29 LINK Procedures
- 223.4.30 LOCKRESOURCE Function
- 223.4.31 PROCESSLINKS Procedure
- 223.4.32 PURGERESOURCEMETADATA Procedure
- 223.4.33 RENAMERESOURCE Procedure
- 223.4.34 SETACL Procedure
- 223.4.35 SPLITPATH Procedure
- 223.4.36 TOUCHRESOURCE Procedure
- 223.4.37 UNLOCKRESOURCE Function
- 223.4.38 UPDATERESOURCEMETADATA Procedures
- 224 DBMS_XA
- 225 DBMS_XDB_ADMIN
-
226
DBMS_XDB_CONFIG
- 226.1 DBMS_XDB_CONFIG Overview
- 226.2 DBMS_XDB_CONFIG Security Model
- 226.3 DBMS_XDB_CONFIG Constants
-
226.4
Summary of DBMS_XDB_CONFIG Subprograms
- 226.4.1 ADDHTTPEXPIREMAPPING Procedure
- 226.4.2 ADDMIMEMAPPING Procedure
- 226.4.3 ADDSCHEMALOCMAPPING Procedure
- 226.4.4 ADDSERVLET Procedure
- 226.4.5 ADDSERVLETMAPPING Procedure
- 226.4.6 ADDSERVLETSECROLE Procedure
- 226.4.7 ADDXMLEXTENSION Procedure
- 226.4.8 CFG_GET Function
- 226.4.9 CFG_REFRESH Procedure
- 226.4.10 CFG_UPDATE Procedure
- 226.4.11 DELETEHTTPEXPIREMAPPING Procedure
- 226.4.12 DELETEMIMEMAPPING Procedure
- 226.4.13 DELETESCHEMALOCMAPPING Procedure
- 226.4.14 DELETESERVLET Procedure
- 226.4.15 DELETESERVLETMAPPING Procedure
- 226.4.16 DELETESERVLETSECROLE Procedure
- 226.4.17 DELETEXMLEXTENSION Procedure
- 226.4.18 ENABLEDIGESTAUTHENTICATION Procedure
- 226.4.19 GETFTPPORT Function
- 226.4.20 GETHTTPCONFIGREALM Function
- 226.4.21 GETHTTPPORT Function
- 226.4.22 GETHTTPSPORT Function
- 226.4.23 GETLISTENERENDPOINT Procedure
- 226.4.24 GETREMOTEHTTPPORT Function
- 226.4.25 GETREMOTEHTTPSPORT Function
- 226.4.26 ISGLOBALPORTENABLED Function
- 226.4.27 SETFTPPORT Procedure
- 226.4.28 SETHTTPPORT Procedure
- 226.4.29 SETHTTPCONFIGREALM Procedure
- 226.4.30 SETHTTPSPORT Procedure
- 226.4.31 SETLISTENERENDPOINT Procedure
- 226.4.32 SETLISTENERLOCALACCESS Procedure
- 226.4.33 SETREMOTEHTTPPORT Procedure
- 226.4.34 SETREMOTEHTTPSPORT Procedure
- 226.4.35 USEDPORT Function
-
227
DBMS_XDB_CONSTANTS
- 227.1 DBMS_XDB_CONSTANTS Security Model
-
227.2
Summary of DBMS_XDB_CONSTANTS Subprograms
- 227.2.1 ENCODING_DEFAULT Function
- 227.2.2 ENCODING_ISOLATIN1 Function
- 227.2.3 ENCODING_UTF8 Function
- 227.2.4 ENCODING_WIN1252 Function
- 227.2.5 NAMESPACE_ACL Function
- 227.2.6 NAMESPACE_METADATA Function
- 227.2.7 NAMESPACE_ORACLE Function
- 227.2.8 NAMESPACE_ORACLE_XDB Function
- 227.2.9 NAMESPACE_RESOURCE Function
- 227.2.10 NAMESPACE_RESOURCE_EVENT Function
- 227.2.11 NAMESPACE_RESOURCE_CONFIG Function
- 227.2.12 NAMESPACE_XDBSCHEMA Function
- 227.2.13 NAMESPACE_XMLDIFF Function
- 227.2.14 NAMESPACE_XMLINSTANCE Function
- 227.2.15 NAMESPACE_XMLSCHEMA Function
- 227.2.16 NSPREFIX_ACL_ACL Function
- 227.2.17 NSPREFIX_RESCONFIG_RC Function
- 227.2.18 NSPREFIX_RESOURCE_R Function
- 227.2.19 NSPREFIX_XDB_XDB Function
- 227.2.20 NSPREFIX_XMLINSTANCE_XSI Function
- 227.2.21 NSPREFIX_XMLDIFF_XD Function
- 227.2.22 NSPREFIX_XMLSCHEMA_XSD Function
- 227.2.23 SCHEMAURL_ACL Function
- 227.2.24 SCHEMAELEM_RES_ACL Function
- 227.2.25 SCHEMAELEM_RESCONTENT_BINARY Function
- 227.2.26 SCHEMAELEM_RESCONTENT_TEXT Function
- 227.2.27 SCHEMAURL_RESOURCE Function
- 227.2.28 SCHEMAURL_XDBSCHEMA Function
- 227.2.29 XDBSCHEMA_PREFIXES Function
- 227.2.30 XSD_ATTRIBUTE Function
- 227.2.31 XSD_COMPLEX_TYPE Function
- 227.2.32 XSD_ELEMENT Function
- 227.2.33 XSD_GROUP Function
-
228
DBMS_XDB_REPOS
- 228.1 DBMS_XDB_REPOS Overview
- 228.2 DBMS_XDB_REPOS Security Model
- 228.3 DBMS_XDB_REPOS Constants
-
228.4
Summary of DBMS_XDB_REPOS Subprograms
- 228.4.1 ACLCHECKPRIVILEGES Function
- 228.4.2 APPENDRESOURCEMETADATA Procedure
- 228.4.3 CHANGEOWNER Procedure
- 228.4.4 CHANGEPRIVILEGES Function
- 228.4.5 CHECKPRIVILEGES Function
- 228.4.6 CREATEFOLDER Function
- 228.4.7 CREATEOIDPATH Function
- 228.4.8 CREATERESOURCE Functions
- 228.4.9 DELETERESOURCE Procedure
- 228.4.10 DELETERESOURCEMETADATA Procedures
- 228.4.11 EXISTSRESOURCE Function
- 228.4.12 GETACLDOCUMENT Function
- 228.4.13 GETCONTENTBLOB Function
- 228.4.14 GETCONTENTCLOB Function
- 228.4.15 GETCONTENTVARCHAR2 Function
- 228.4.16 GETCONTENTXMLREF Function
- 228.4.17 GETCONTENTXMLTYPE Function
- 228.4.18 GETLOCKTOKEN Procedure
- 228.4.19 GETPRIVILEGES Function
- 228.4.20 GETRESOID Function
- 228.4.21 GETXDB_TABLESPACE Function
- 228.4.22 HASBLOBCONTENT Function
- 228.4.23 HASCHARCONTENT Function
- 228.4.24 HASXMLCONTENT Function
- 228.4.25 HASXMLREFERENCE Function
- 228.4.26 ISFOLDER Function
- 228.4.27 LINK Procedures
- 228.4.28 LOCKRESOURCE Function
- 228.4.29 PROCESSLINKS Procedure
- 228.4.30 PURGERESOURCEMETADATA Procedure
- 228.4.31 RENAMERESOURCE Procedure
- 228.4.32 SETACL Procedure
- 228.4.33 SPLITPATH Procedure
- 228.4.34 TOUCHRESOURCE Procedure
- 228.4.35 UNLOCKRESOURCE Function
- 228.4.36 UPDATERESOURCEMETADATA Procedures
-
229
DBMS_XDB_VERSION
- 229.1 DBMS_XDB_VERSION Security Model
-
229.2
Summary of DBMS_XDB_VERSION Subprograms
- 229.2.1 CHECKIN Function
- 229.2.2 CHECKOUT Procedure
- 229.2.3 GETCONTENTSBLOBBYRESID Function
- 229.2.4 GETCONTENTSCLOBBYRESID Function
- 229.2.5 GETCONTENTSXMLBYRESID Function
- 229.2.6 GETPREDECESSORS Function
- 229.2.7 GETPREDSBYRESID Function
- 229.2.8 GETRESOURCEBYRESID Function
- 229.2.9 GETSUCCESSORS Function
- 229.2.10 GETSUCCSBYRESID Function
- 229.2.11 MAKEVERSIONED Function
- 229.2.12 UNCHECKOUT Function
-
230
DBMS_XDBRESOURCE
- 230.1 DBMS_XDBRESOURCE Overview
- 230.2 DBMS_XDBRESOURCE Security Model
-
230.3
Summary of DBMS_XDBRESOURCE Subprograms
- 230.3.1 FREERESOURCE Procedure
- 230.3.2 GETACL Function
- 230.3.3 GETACLDOCFROMRES Function
- 230.3.4 GETAUTHOR Function
- 230.3.5 GETCHARACTERSET Function
- 230.3.6 GETCOMMENT Function
- 230.3.7 GETCONTENTBLOB Function
- 230.3.8 GETCONTENTCLOB Function
- 230.3.9 GETCONTENTREF Function
- 230.3.10 GETCONTENTTYPE Function
- 230.3.11 GETCONTENTXML Function
- 230.3.12 GETCONTENTVARCHAR2 Function
- 230.3.13 GETCREATIONDATE Function
- 230.3.14 GETCREATOR Function
- 230.3.15 GETCUSTOMMETADATA Function
- 230.3.16 GETDISPLAYNAME Function
- 230.3.17 GETLANGUAGE Function
- 230.3.18 GETLASTMODIFIER Function
- 230.3.19 GETMODIFICATIONDATE Function
- 230.3.20 GETOWNER Function
- 230.3.21 GETREFCOUNT Function
- 230.3.22 GETVERSIONID Function
- 230.3.23 HASACLCHANGED Function
- 230.3.24 HASAUTHORCHANGED Function
- 230.3.25 HASCHANGED Function
- 230.3.26 HASCHARACTERSETCHANGED Function
- 230.3.27 HASCOMMENTCHANGED Function
- 230.3.28 HASCONTENTCHANGED Function
- 230.3.29 HASCONTENTTYPECHANGED Function
- 230.3.30 HASCREATIONDATECHANGED Function
- 230.3.31 HASCREATORCHANGED Function
- 230.3.32 HASCUSTOMMETADATACHANGED Function
- 230.3.33 HASDISPLAYNAMECHANGED Function
- 230.3.34 HASLANGUAGECHANGED Function
- 230.3.35 HASLASTMODIFIERCHANGED Function
- 230.3.36 HASMODIFICATIONDATECHANGED Function
- 230.3.37 HASOWNERCHANGED Function
- 230.3.38 HASREFCOUNTCHANGED Function
- 230.3.39 HASVERSIONIDCHANGED Function
- 230.3.40 ISFOLDER Function
- 230.3.41 ISNULL Function
- 230.3.42 MAKEDOCUMENT Function
- 230.3.43 SAVE Procedure
- 230.3.44 SETACL Procedure
- 230.3.45 SETAUTHOR Procedure
- 230.3.46 SETCHARACTERSET Procedure
- 230.3.47 SETCOMMENT Procedure
- 230.3.48 SETCONTENT Procedures
- 230.3.49 SETCONTENTTYPE Procedure
- 230.3.50 SETCUSTOMMETADATA Procedure
- 230.3.51 SETDISPLAYNAME Procedure
- 230.3.52 SETLANGUAGE Procedure
- 230.3.53 SETOWNER Procedure
- 231 DBMS_XDBZ
-
232
DBMS_XEVENT
- 232.1 DBMS_XEVENT Security Model
- 232.2 DBMS_XEVENT Constants
- 232.3 Subprogram Groups
-
232.4
Summary of DBMS_XEVENT Subprograms
- 232.4.1 CLEAR Procedure
- 232.4.2 GETAPPLICATIONDATA Function
- 232.4.3 GETCHILDOID Function
- 232.4.4 GETCURRENTUSER Function
- 232.4.5 GETEVENT Function
- 232.4.6 GETFIRST Function
- 232.4.7 GETHANDLERLIST Function
- 232.4.8 GETINTERFACE Function
- 232.4.9 GETLANGUAGE Function
- 232.4.10 GETLINK Function
- 232.4.11 GETLINKNAME Function
- 232.4.12 GETLOCK Function
- 232.4.13 GETLANGUAGE Function
- 232.4.14 GETNAME Function
- 232.4.15 GETNEXT Function
- 232.4.16 GETOLDRESOURCE Function
- 232.4.17 GETOPENACCESSMODE Function
- 232.4.18 GETOPENDENYMODE Function
- 232.4.19 GETOUTPUTSTREAM Function
- 232.4.20 GETPARAMETER Function
- 232.4.21 GETPARENT Function
- 232.4.22 GETPARENTNAME Function
- 232.4.23 GETPARENTOID Function
- 232.4.24 GETPARENTPATH Function
- 232.4.25 GETPATH Function
- 232.4.26 GETRESOURCE Function
- 232.4.27 GETSCHEMA Function
- 232.4.28 GETSOURCE Function
- 232.4.29 GETUPDATEBYTECOUNT Function
- 232.4.30 GETUPDATEBYTEOFFSET Function
- 232.4.31 GETXDBEVENT Function
- 232.4.32 ISNULL Functions
- 232.4.33 REMOVE Procedure
- 232.4.34 SETRENDERPATH Procedure
- 232.4.35 SETRENDERSTREAM Procedure
-
233
DBMS_XMLDOM
- 233.1 DBMS_XMLDOM Overview
- 233.2 DBMS_XMLDOM Security Model
- 233.3 DBMS_XMLDOM Constants
- 233.4 DBMS_XMLDOM Types
- 233.5 DBMS_XMLDOM Exceptions
-
233.6
DBMS_XMLDOM Subprogram Groups
- 233.6.1 DBMS_XMLDOM DOMNode Subprograms
- 233.6.2 DBMS_XMLDOM DOMAttr Subprograms
- 233.6.3 DBMS_XMLDOM DOMCDataSection Subprograms
- 233.6.4 DBMS_XMLDOM DOMCharacterData Subprograms
- 233.6.5 DBMS_XMLDOM DOMComment Subprograms
- 233.6.6 DBMS_XMLDOM DOMDocument Subprograms
- 233.6.7 DBMS_XMLDOM DOMDocumentFragment Subprograms
- 233.6.8 DBMS_XMLDOM DOMDocumentType Subprograms
- 233.6.9 DBMS_XMLDOM DOMElement Subprograms
- 233.6.10 DBMS_XMLDOM DOMEntity Subprograms
- 233.6.11 DBMS_XMLDOM DOMEntityReference Subprograms
- 233.6.12 DBMS_XMLDOM DOMImplementation Subprograms
- 233.6.13 DBMS_XMLDOM DOMNamedNodeMap Subprograms
- 233.6.14 DBMS_XMLDOM DOMNodeList Subprograms
- 233.6.15 DBMS_XMLDOM DOMNotation Subprograms
- 233.6.16 DBMS_XMLDOM DOMProcessingInstruction Subprograms
- 233.6.17 DBMS_XMLDOM DOMText Subprograms
-
233.7
Summary of DBMS_XMLDOM Subprograms
- 233.7.1 ADOPTNODE Function
- 233.7.2 APPENDCHILD Function
- 233.7.3 APPENDDATA Procedure
- 233.7.4 CLONENODE Function
- 233.7.5 CREATEATTRIBUTE Functions
- 233.7.6 CREATECDATASECTION Function
- 233.7.7 CREATECOMMENT Function
- 233.7.8 CREATEDOCUMENT Function
- 233.7.9 CREATEDOCUMENTFRAGMENT Function
- 233.7.10 CREATEELEMENT Functions
- 233.7.11 CREATEENTITYREFERENCE Function
- 233.7.12 CREATEPROCESSINGINSTRUCTION Function
- 233.7.13 CREATETEXTNODE Function
- 233.7.14 DELETEDATA Procedure
- 233.7.15 FINDENTITY Function
- 233.7.16 FINDNOTATION Function
- 233.7.17 FREEDOCFRAG Procedure
- 233.7.18 FREEDOCUMENT Procedure
- 233.7.19 FREEELEMENT Procedure
- 233.7.20 FREENODE Procedure
- 233.7.21 FREENODELIST Procedure
- 233.7.22 GETATTRIBUTE Functions
- 233.7.23 GETATTRIBUTENODE Functions
- 233.7.24 GETATTRIBUTES Function
- 233.7.25 GETCHARSET Function
- 233.7.26 GETCHILDNODES Function
- 233.7.27 GETCHILDRENBYTAGNAME Functions
- 233.7.28 GETDATA Functions
- 233.7.29 GETDOCTYPE Function
- 233.7.30 GETDOCUMENTELEMENT Function
- 233.7.31 GETELEMENTSBYTAGNAME Functions
- 233.7.32 GETENTITIES Function
- 233.7.33 GETEXPANDEDNAME Procedure and Functions
- 233.7.34 GETFIRSTCHILD Function
- 233.7.35 GETIMPLEMENTATION Function
- 233.7.36 GETLASTCHILD Function
- 233.7.37 GETLENGTH Functions
- 233.7.38 GETLOCALNAME Procedure and Functions
- 233.7.39 GETNAME Functions
- 233.7.40 GETNAMEDITEM Function
- 233.7.41 GETNAMESPACE Procedure and Functions
- 233.7.42 GETNEXTSIBLING Function
- 233.7.43 GETNODETYPE Function
- 233.7.44 GETNODENAME Function
- 233.7.45 GETNODEVALUE Function
- 233.7.46 GETNODEVALUEASBINARYSTREAM Function & Procedure
- 233.7.47 GETNODEVALUEASCHARACTERSTREAM Function & Procedure
- 233.7.48 GETNOTATIONNAME Function
- 233.7.49 GETNOTATIONS Function
- 233.7.50 GETTARGET Function
- 233.7.51 GETOWNERDOCUMENT Function
- 233.7.52 GETOWNERELEMENT Function
- 233.7.53 GETPARENTNODE Function
- 233.7.54 GETPREFIX Function
- 233.7.55 GETPREVIOUSSIBLING Function
- 233.7.56 GETPUBLICID Functions
- 233.7.57 GETQUALIFIEDNAME Functions
- 233.7.58 GETSCHEMANODE Function
- 233.7.59 GETSPECIFIED Function
- 233.7.60 GETSTANDALONE Function
- 233.7.61 GETSYSTEMID Functions
- 233.7.62 GETTAGNAME Function
- 233.7.63 GETVALUE Function
- 233.7.64 GETVERSION Function
- 233.7.65 GETXMLTYPE Function
- 233.7.66 HASATTRIBUTE Functions
- 233.7.67 HASATTRIBUTES Function
- 233.7.68 HASCHILDNODES Function
- 233.7.69 HASFEATURE Function
- 233.7.70 IMPORTNODE Function
- 233.7.71 INSERTBEFORE Function
- 233.7.72 INSERTDATA Procedure
- 233.7.73 ISNULL Functions
- 233.7.74 ITEM Functions
- 233.7.75 MAKEATTR Function
- 233.7.76 MAKECDATASECTION Function
- 233.7.77 MAKECHARACTERDATA Function
- 233.7.78 MAKECOMMENT Function
- 233.7.79 MAKEDOCUMENT Function
- 233.7.80 MAKEDOCUMENTFRAGMENT Function
- 233.7.81 MAKEDOCUMENTTYPE Function
- 233.7.82 MAKEELEMENT Function
- 233.7.83 MAKEENTITY Function
- 233.7.84 MAKEENTITYREFERENCE Function
- 233.7.85 MAKENODE Functions
- 233.7.86 MAKENOTATION Function
- 233.7.87 MAKEPROCESSINGINSTRUCTION Function
- 233.7.88 MAKETEXT Function
- 233.7.89 NEWDOMDOCUMENT Functions
- 233.7.90 NORMALIZE Procedure
- 233.7.91 REMOVEATTRIBUTE Procedures
- 233.7.92 REMOVEATTRIBUTENODE Function
- 233.7.93 REMOVECHILD Function
- 233.7.94 REMOVENAMEDITEM Function
- 233.7.95 REPLACECHILD Function
- 233.7.96 REPLACEDATA Procedure
- 233.7.97 RESOLVENAMESPACEPREFIX Function
- 233.7.98 SETATTRIBUTE Procedures
- 233.7.99 SETATTRIBUTENODE Functions
- 233.7.100 SETCHARSET Procedure
- 233.7.101 SETDATA Procedures
- 233.7.102 SETDOCTYPE Procedure
- 233.7.103 SETNAMEDITEM Function
- 233.7.104 SETNODEVALUE Procedure
- 233.7.105 SETNODEVALUEASBINARYSTREAM Function & Procedure
- 233.7.106 SETNODEVALUEASCHARACTERSTREAM Function & Procedure
- 233.7.107 SETPREFIX Procedure
- 233.7.108 SETSTANDALONE Procedure
- 233.7.109 SETVALUE Procedure
- 233.7.110 SETVERSION Procedure
- 233.7.111 SPLITTEXT Function
- 233.7.112 SUBSTRINGDATA Function
- 233.7.113 USEBINARYSTREAM Function
- 233.7.114 WRITETOBUFFER Procedures
- 233.7.115 WRITETOCLOB Procedures
- 233.7.116 WRITETOFILE Procedures
-
234
DBMS_XMLGEN
- 234.1 DBMS_XMLGEN Security Model
-
234.2
Summary of DBMS_XMLGEN Subprograms
- 234.2.1 CLOSECONTEXT Procedure
- 234.2.2 CONVERT Functions
- 234.2.3 GETNUMROWSPROCESSED Function
- 234.2.4 GETXML Functions
- 234.2.5 GETXMLTYPE Functions
- 234.2.6 NEWCONTEXT Functions
- 234.2.7 NEWCONTEXTFROMHIERARCHY Function
- 234.2.8 RESTARTQUERY Procedure
- 234.2.9 SETCONVERTSPECIALCHARS Procedure
- 234.2.10 SETMAXROWS Procedure
- 234.2.11 SETNULLHANDLING Procedure
- 234.2.12 SETROWSETTAG Procedure
- 234.2.13 SETROWTAG Procedure
- 234.2.14 SETSKIPROWS Procedure
- 234.2.15 USEITEMTAGSFORCOLL Procedure
- 234.2.16 USENULLATTRIBUTEINDICATOR Procedure
- 235 DBMS_XMLINDEX
-
236
DBMS_XMLPARSER
- 236.1 DBMS_XMLPARSER Security Model
-
236.2
Summary of DBMS_XMLPARSER Subprograms
- 236.2.1 FREEPARSER
- 236.2.2 GETDOCTYPE
- 236.2.3 GETDOCUMENT
- 236.2.4 GETRELEASEVERSION
- 236.2.5 GETVALIDATIONMODE
- 236.2.6 NEWPARSER
- 236.2.7 PARSE
- 236.2.8 PARSEBUFFER
- 236.2.9 PARSECLOB
- 236.2.10 PARSEDTD
- 236.2.11 PARSEDTDBUFFER
- 236.2.12 PARSEDTDCLOB
- 236.2.13 SETBASEDIR
- 236.2.14 SETDOCTYPE Procedure
- 236.2.15 SETERRORLOG Procedure
- 236.2.16 SETPRESERVEWHITESPACE
- 236.2.17 SETVALIDATIONMODE
- 236.2.18 SHOWWARNINGS
- 237 DBMS_XMLSCHEMA
-
238
DBMS_XMLSCHEMA_ANNOTATE
- 238.1 DBMS_XMLSCHEMA_ANNOTATE Overview
- 238.2 DBMS_XMLSCHEMA_ANNOTATE Security Model
-
238.3
Summary of DBMS_XMLSCHEMA_ANNOTATE Subprograms
- 238.3.1 ADDXDBNAMESPACE Procedure
- 238.3.2 DISABLEDEFAULTTABLECREATION Procedure
- 238.3.3 DISABLEMAINTAINDOM Procedure
- 238.3.4 ENABLEDEFAULTTABLECREATION Procedure
- 238.3.5 ENABLEMAINTAINDOM Procedure
- 238.3.6 GETSCHEMAANNOTATIONS Function
- 238.3.7 GETSIDXDEFFROMVIEW Function
- 238.3.8 PRINTWARNINGS Procedure
- 238.3.9 REMOVEANYSTORAGE Procedure
- 238.3.10 REMOVEDEFAULTTABLE Procedure
- 238.3.11 REMOVEMAINTAINDOM Procedure
- 238.3.12 REMOVEOUTOFLINE Procedure
- 238.3.13 REMOVESQLCOLLTYPE Procedure
- 238.3.14 REMOVESQLNAME Procedure
- 238.3.15 REMOVESQLTYPE Procedure
- 238.3.16 REMOVESQLTYPEMAPPING Procedure
- 238.3.17 REMOVETABLEPROPS Procedure
- 238.3.18 REMOVETIMESTAMPWITHTIMEZONE Procedure
- 238.3.19 SETANYSTORAGE Procedure
- 238.3.20 SETDEFAULTTABLE Procedure
- 238.3.21 SETOUTOFLINE Procedure
- 238.3.22 SETSCHEMAANNOTATATIONS Procedure
- 238.3.23 SETSQLCOLLTYPE Procedure
- 238.3.24 SETSQLNAME Procedure
- 238.3.25 SETSQLTYPE Procedure
- 238.3.26 SETSQLTYPEMAPPING Procedure
- 238.3.27 SETTABLEPROPS Procedure
- 238.3.28 SETTIMESTAMPWITHTIMEZONE Procedure
- 239 DBMS_XMLSCHEMA_UTIL
-
240
DBMS_XMLSTORAGE_MANAGE
- 240.1 DBMS_XMLSTORAGE_MANAGE Overview
- 240.2 DBMS_XMLSTORAGE_MANAGE Security Model
-
240.3
Summary of DBMS_XMLSTORAGE_MANAGE Subprograms
- 240.3.1 DISABLEINDEXESANDCONSTRAINTS Procedure
- 240.3.2 ENABLEINDEXESANDCONSTRAINTS Procedure
- 240.3.3 EXCHANGEPOSTPROC Procedure
- 240.3.4 EXCHANGEPREPROC Procedure
- 240.3.5 INDEXXMLREFERENCES Procedure
- 240.3.6 REFPARTITIONEXCHANGEIN Procedure
- 240.3.7 REFPARTITIONEXCHANGEOUT Procedure
- 240.3.8 RENAMECOLLECTIONTABLE Procedure
- 240.3.9 SCOPEXMLREFERENCES Procedure
- 240.3.10 XPATH2TABCOLMAPPING Function
- 241 DBMS_XMLSTORE
- 242 DBMS_XPLAN
-
243
DBMS_XSLPROCESSOR
- 243.1 DBMS_XSLPROCESSOR Overview
- 243.2 DBMS_XSLPROCESSOR Security Model
-
243.3
Summary of DBMS_XSLPROCESSOR Subprograms
- 243.3.1 FREEPROCESSOR Procedure
- 243.3.2 FREESTYLESHEET Procedure
- 243.3.3 NEWPROCESSOR Function
- 243.3.4 NEWSTYLESHEET Functions
- 243.3.5 PROCESSXSL Functions and Procedures
- 243.3.6 REMOVEPARAM Procedure
- 243.3.7 RESETPARAMS Procedure
- 243.3.8 SELECTNODES Function
- 243.3.9 SELECTSINGLENODE Function
- 243.3.10 SETERRORLOG Procedure
- 243.3.11 SETPARAM Procedure
- 243.3.12 SHOWWARNINGS Procedure
- 243.3.13 TRANSFORMNODE Function
- 243.3.14 VALUEOF Function and Procedure
-
244
DBMS_XSTREAM_ADM
- 244.1 DBMS_XSTREAM_ADM Overview
- 244.2 DBMS_XSTREAM_ADM Security Model
- 244.3 DBMS_XSTREAM_ADM Operational Notes
-
244.4
Summary of DBMS_XSTREAM_ADM Subprograms
- 244.4.1 ADD_COLUMN Procedure
- 244.4.2 ADD_GLOBAL_PROPAGATION_RULES Procedure
- 244.4.3 ADD_GLOBAL_RULES Procedure
- 244.4.4 ADD_OUTBOUND Procedure
- 244.4.5 ADD_SCHEMA_PROPAGATION_RULES Procedure
- 244.4.6 ADD_SCHEMA_RULES Procedure
- 244.4.7 ADD_SUBSET_OUTBOUND_RULES Procedure
- 244.4.8 ADD_SUBSET_PROPAGATION_RULES Procedure
- 244.4.9 ADD_SUBSET_RULES Procedure
- 244.4.10 ADD_TABLE_PROPAGATION_RULES Procedure
- 244.4.11 ADD_TABLE_RULES Procedure
- 244.4.12 ALTER_INBOUND Procedure
- 244.4.13 ALTER_OUTBOUND Procedure
- 244.4.14 CREATE_INBOUND Procedure
- 244.4.15 CREATE_OUTBOUND Procedure
- 244.4.16 DELETE_COLUMN Procedure
- 244.4.17 DROP_INBOUND Procedure
- 244.4.18 DROP_OUTBOUND Procedure
- 244.4.19 ENABLE_GG_XSTREAM_FOR_STREAMS Procedure
- 244.4.20 GET_MESSAGE_TRACKING Function
- 244.4.21 GET_TAG Function
- 244.4.22 IS_GG_XSTREAM_FOR_STREAMS Function
- 244.4.23 KEEP_COLUMNS Procedure
- 244.4.24 MERGE_STREAMS Procedure
- 244.4.25 MERGE_STREAMS_JOB Procedure
- 244.4.26 PURGE_SOURCE_CATALOG Procedure
- 244.4.27 RECOVER_OPERATION Procedure
- 244.4.28 REMOVE_QUEUE Procedure
- 244.4.29 REMOVE_RULE Procedure
- 244.4.30 REMOVE_SUBSET_OUTBOUND_RULES Procedure
- 244.4.31 REMOVE_XSTREAM_CONFIGURATION Procedure
- 244.4.32 RENAME_COLUMN Procedure
- 244.4.33 RENAME_SCHEMA Procedure
- 244.4.34 RENAME_TABLE Procedure
- 244.4.35 SET_MESSAGE_TRACKING Procedure
- 244.4.36 SET_PARAMETER Procedure
- 244.4.37 SET_TAG Procedure
- 244.4.38 SET_UP_QUEUE Procedure
- 244.4.39 SPLIT_STREAMS Procedure
- 244.4.40 START_OUTBOUND Procedure
- 244.4.41 STOP_OUTBOUND Procedure
- 245 DEBUG_EXTPROC
-
246
HTF
- 246.1 HTF Deprecated Subprograms
- 246.2 HTF Operational Notes
- 246.3 Rules and Limits
- 246.4 HTF Examples
- 246.5 Summary of Tags
-
246.6
Summary of HTF Subprograms
- 246.6.1 ADDRESS Function
- 246.6.2 ANCHOR Function
- 246.6.3 ANCHOR2 Function
- 246.6.4 APPLETCLOSE Function
- 246.6.5 APPLETOPEN Function
- 246.6.6 AREA Function
- 246.6.7 BASE Function
- 246.6.8 BASEFONT Function
- 246.6.9 BGSOUND Function
- 246.6.10 BIG Function
- 246.6.11 BLOCKQUOTECLOSE Function
- 246.6.12 BLOCKQUOTEOPEN Function
- 246.6.13 BODYCLOSE Function
- 246.6.14 BODYOPEN Function
- 246.6.15 BOLD Function
- 246.6.16 BR Function
- 246.6.17 CENTER Function
- 246.6.18 CENTERCLOSE Function
- 246.6.19 CENTEROPEN Function
- 246.6.20 CITE Function
- 246.6.21 CODE Function
- 246.6.22 COMMENT Function
- 246.6.23 DFN Function
- 246.6.24 DIRLISTCLOSE Function
- 246.6.25 DIRLISTOPEN Function
- 246.6.26 DIV Function
- 246.6.27 DLISTCLOSE Function
- 246.6.28 DLISTDEF Function
- 246.6.29 DLISTOPEN Function
- 246.6.30 DLISTTERM Function
- 246.6.31 EM Function
- 246.6.32 EMPHASIS Function
- 246.6.33 ESCAPE_SC Function
- 246.6.34 ESCAPE_URL Function
- 246.6.35 FONTCLOSE Function
- 246.6.36 FONTOPEN Function
- 246.6.37 FORMAT_CELL Function
- 246.6.38 FORMCHECKBOX Function
- 246.6.39 FORMCLOSE Function
- 246.6.40 FORMFILE Function
- 246.6.41 FORMHIDDEN Function
- 246.6.42 FORMIMAGE Function
- 246.6.43 FORMOPEN Function
- 246.6.44 FORMPASSWORD Function
- 246.6.45 FORMRADIO Function
- 246.6.46 FORMRESET Function
- 246.6.47 FORMSELECTCLOSE Function
- 246.6.48 FORMSELECTOPEN Function
- 246.6.49 FORMSELECTOPTION Function
- 246.6.50 FORMSUBMIT Function
- 246.6.51 FORMTEXT Function
- 246.6.52 FORMTEXTAREA Function
- 246.6.53 FORMTEXTAREA2 Function
- 246.6.54 FORMTEXTAREACLOSE Function
- 246.6.55 FORMTEXTAREAOPEN Function
- 246.6.56 FORMTEXTAREAOPEN2 Function
- 246.6.57 FRAME Function
- 246.6.58 FRAMESETCLOSE Function
- 246.6.59 FRAMESETOPEN Function
- 246.6.60 HEADCLOSE Function
- 246.6.61 HEADER Function
- 246.6.62 HEADOPEN Function
- 246.6.63 HR Function
- 246.6.64 HTMLCLOSE Function
- 246.6.65 HTMLOPEN Function
- 246.6.66 IMG Function
- 246.6.67 IMG2 Function
- 246.6.68 ISINDEX Function
- 246.6.69 ITALIC Function
- 246.6.70 KBD Function
- 246.6.71 KEYBOARD Function
- 246.6.72 LINE Function
- 246.6.73 LINKREL Function
- 246.6.74 LINKREV Function
- 246.6.75 LISTHEADER Function
- 246.6.76 LISTINGCLOSE Function
- 246.6.77 LISTINGOPEN Function
- 246.6.78 LISTITEM Function
- 246.6.79 MAILTO Function
- 246.6.80 MAPCLOSE Function
- 246.6.81 MAPOPEN Function
- 246.6.82 MENULISTCLOSE Function
- 246.6.83 MENULISTOPEN Function
- 246.6.84 META Function
- 246.6.85 NL Function
- 246.6.86 NOBR Function
- 246.6.87 NOFRAMESCLOSE Function
- 246.6.88 NOFRAMESOPEN Function
- 246.6.89 OLISTCLOSE Function
- 246.6.90 OLISTOPEN Function
- 246.6.91 PARA Function
- 246.6.92 PARAGRAPH Function
- 246.6.93 PARAM Function
- 246.6.94 PLAINTEXT Function
- 246.6.95 PRECLOSE Function
- 246.6.96 PREOPEN Function
- 246.6.97 PRINT Functions
- 246.6.98 PRN Functions
- 246.6.99 S Function
- 246.6.100 SAMPLE Function
- 246.6.101 SCRIPT Function
- 246.6.102 SMALL Function
- 246.6.103 STRIKE Function
- 246.6.104 STRONG Function
- 246.6.105 STYLE Function
- 246.6.106 SUB Function
- 246.6.107 SUP Function
- 246.6.108 TABLECAPTION Function
- 246.6.109 TABLECLOSE Function
- 246.6.110 TABLEDATA Function
- 246.6.111 TABLEHEADER Function
- 246.6.112 TABLEOPEN Function
- 246.6.113 TABLEROWCLOSE Function
- 246.6.114 TABLEROWOPEN Function
- 246.6.115 TELETYPE Function
- 246.6.116 TITLE Function
- 246.6.117 ULISTCLOSE Function
- 246.6.118 ULISTOPEN Function
- 246.6.119 UNDERLINE Function
- 246.6.120 VARIABLE Function
- 246.6.121 WBR Function
-
247
HTP
- 247.1 HTP Operational Notes
- 247.2 HTP Rules and Limits
- 247.3 HTP Examples
- 247.4 HTP Summary of Tags
-
247.5
Summary of HTP Subprograms
- 247.5.1 ADDRESS Procedure
- 247.5.2 ANCHOR Procedure
- 247.5.3 ANCHOR2 Procedure
- 247.5.4 APPLETCLOSE Procedure
- 247.5.5 APPLETOPEN Procedure
- 247.5.6 AREA Procedure
- 247.5.7 BASE Procedure
- 247.5.8 BASEFONT Procedure
- 247.5.9 BGSOUND Procedure
- 247.5.10 BIG Procedure
- 247.5.11 BLOCKQUOTECLOSE Procedure
- 247.5.12 BLOCKQUOTEOPEN Procedure
- 247.5.13 BODYCLOSE Procedure
- 247.5.14 BODYOPEN Procedure
- 247.5.15 BOLD Procedure
- 247.5.16 BR Procedure
- 247.5.17 CENTER Procedure
- 247.5.18 CENTERCLOSE Procedure
- 247.5.19 CENTEROPEN Procedure
- 247.5.20 CITE Procedure
- 247.5.21 CODE Procedure
- 247.5.22 COMMENT Procedure
- 247.5.23 DFN Procedure
- 247.5.24 DIRLISTCLOSE Procedure
- 247.5.25 DIRLISTOPEN Procedure
- 247.5.26 DIV Procedure
- 247.5.27 DLISTCLOSE Procedure
- 247.5.28 DLISTDEF Procedure
- 247.5.29 DLISTOPEN Procedure
- 247.5.30 DLISTTERM Procedure
- 247.5.31 EM Procedure
- 247.5.32 EMPHASIS Procedure
- 247.5.33 ESCAPE_SC Procedure
- 247.5.34 FONTCLOSE Procedure
- 247.5.35 FONTOPEN Procedure
- 247.5.36 FORMCHECKBOX Procedure
- 247.5.37 FORMCLOSE Procedure
- 247.5.38 FORMOPEN Procedure
- 247.5.39 FORMFILE Procedure
- 247.5.40 FORMHIDDEN Procedure
- 247.5.41 FORMIMAGE Procedure
- 247.5.42 FORMPASSWORD Procedure
- 247.5.43 FORMRADIO Procedure
- 247.5.44 FORMRESET Procedure
- 247.5.45 FORMSELECTCLOSE Procedure
- 247.5.46 FORMSELECTOPEN Procedure
- 247.5.47 FORMSELECTOPTION Procedure
- 247.5.48 FORMSUBMIT Procedure
- 247.5.49 FORMTEXT Procedure
- 247.5.50 FORMTEXTAREA Procedure
- 247.5.51 FORMTEXTAREA2 Procedure
- 247.5.52 FORMTEXTAREACLOSE Procedure
- 247.5.53 FORMTEXTAREAOPEN Procedure
- 247.5.54 FORMTEXTAREAOPEN2 Procedure
- 247.5.55 FRAME Procedure
- 247.5.56 FRAMESETCLOSE Procedure
- 247.5.57 FRAMESETOPEN Procedure
- 247.5.58 HEADCLOSE Procedure
- 247.5.59 HEADER Procedure
- 247.5.60 HEADOPEN Procedure
- 247.5.61 HR Procedure
- 247.5.62 HTMLCLOSE Procedure
- 247.5.63 HTMLOPEN Procedure
- 247.5.64 IMG Procedure
- 247.5.65 IMG2 Procedure
- 247.5.66 ISINDEX Procedure
- 247.5.67 ITALIC Procedure
- 247.5.68 KBD Procedure
- 247.5.69 KEYBOARD Procedure
- 247.5.70 LINE Procedure
- 247.5.71 LINKREL Procedure
- 247.5.72 LINKREV Procedure
- 247.5.73 LISTHEADER Procedure
- 247.5.74 LISTINGCLOSE Procedure
- 247.5.75 LISTINGOPEN Procedure
- 247.5.76 LISTITEM Procedure
- 247.5.77 MAILTO Procedure
- 247.5.78 MAPCLOSE Procedure
- 247.5.79 MAPOPEN Procedure
- 247.5.80 MENULISTCLOSE Procedure
- 247.5.81 MENULISTOPEN Procedure
- 247.5.82 META Procedure
- 247.5.83 NL Procedure
- 247.5.84 NOBR Procedure
- 247.5.85 NOFRAMESCLOSE Procedure
- 247.5.86 NOFRAMESOPEN Procedure
- 247.5.87 OLISTCLOSE Procedure
- 247.5.88 OLISTOPEN Procedure
- 247.5.89 PARA Procedure
- 247.5.90 PARAGRAPH Procedure
- 247.5.91 PARAM Procedure
- 247.5.92 PLAINTEXT Procedure
- 247.5.93 PRECLOSE Procedure
- 247.5.94 PREOPEN Procedure
- 247.5.95 PRINT Procedures
- 247.5.96 PRINTS Procedure
- 247.5.97 PRN Procedures
- 247.5.98 PS Procedure
- 247.5.99 S Procedure
- 247.5.100 SAMPLE Procedure
- 247.5.101 SCRIPT Procedure
- 247.5.102 SMALL Procedure
- 247.5.103 STRIKE Procedure
- 247.5.104 STRONG Procedure
- 247.5.105 STYLE Procedure
- 247.5.106 SUB Procedure
- 247.5.107 SUP Procedure
- 247.5.108 TABLECAPTION Procedure
- 247.5.109 TABLECLOSE Procedure
- 247.5.110 TABLEDATA Procedure
- 247.5.111 TABLEHEADER Procedure
- 247.5.112 TABLEOPEN Procedure
- 247.5.113 TABLEROWCLOSE Procedure
- 247.5.114 TABLEROWOPEN Procedure
- 247.5.115 TELETYPE Procedure
- 247.5.116 TITLE Procedure
- 247.5.117 ULISTCLOSE Procedure
- 247.5.118 ULISTOPEN Procedure
- 247.5.119 UNDERLINE Procedure
- 247.5.120 VARIABLE Procedure
- 247.5.121 WBR Procedure
- 248 OWA_CACHE
- 249 OWA_COOKIE
- 250 OWA_CUSTOM
- 251 OWA_IMAGE
- 252 OWA_OPT_LOCK
- 253 OWA_PATTERN
- 254 OWA_SEC
- 255 OWA_TEXT
-
256
OWA_UTIL
- 256.1 OWA_UTIL Overview
- 256.2 OWA_UTIL Types
-
256.3
Summary of OWA_UTIL Subprograms
- 256.3.1 BIND_VARIABLES Function
- 256.3.2 CALENDARPRINT Procedures
- 256.3.3 CELLSPRINT Procedures
- 256.3.4 CHOOSE_DATE Procedure
- 256.3.5 GET_CGI_ENV Function
- 256.3.6 GET_OWA_SERVICE_PATH Function
- 256.3.7 GET_PROCEDURE Function
- 256.3.8 HTTP_HEADER_CLOSE Procedure
- 256.3.9 LISTPRINT Procedure
- 256.3.10 MIME_HEADER Procedure
- 256.3.11 PRINT_CGI_ENV Procedure
- 256.3.12 REDIRECT_URL Procedure
- 256.3.13 SHOWPAGE Procedure
- 256.3.14 SHOWSOURCE Procedure
- 256.3.15 SIGNATURE procedure
- 256.3.16 STATUS_LINE Procedure
- 256.3.17 TABLEPRINT Function
- 256.3.18 TODATE Function
- 256.3.19 WHO_CALLED_ME Procedure
- 257 SDO_CS
- 258 SDO_CSW_PROCESS
- 259 SDO_GCDR
- 260 SDO_GEOM
- 261 SDO_GEOR
- 262 SDO_GEOR_ADMIN
- 263 SDO_GEOR_AGGR
- 264 SDO_GEOR_RA
- 265 SDO_GEOR_UTL
- 266 SDO_LRS
- 267 SDO_MIGRATE
- 268 SDO_NET
- 269 SDO_NFE
- 270 SDO_OLS
- 271 SDO_PC_PKG
- 272 SDO_SAM
- 273 SDO_TIN_PKG
- 274 SDO_TOPO
- 275 SDO_TOPO_MAP
- 276 SDO_TUNE
- 277 SDO_UTIL
- 278 SDO_WFS_LOCK
- 279 SDO_WFS_PROCESS
- 280 SEM_APIS
- 281 SEM_OLS
- 282 SEM_PERF
- 283 SEM_RDFCTX
- 284 SEM_RDFSA
-
285
UTL_CALL_STACK
- 285.1 UTL_CALL_STACK Overview
- 285.2 UTL_CALL_STACK Security Model
- 285.3 UTL_CALL_STACK Operational Notes
- 285.4 UTL_CALL_STACK Exceptions
- 285.5 UTL_CALL_STACK Data Structures
-
285.6
Summary of UTL_CALL_STACK Subprograms
- 285.6.1 BACKTRACE_DEPTH Function
- 285.6.2 BACKTRACE_LINE Function
- 285.6.3 BACKTRACE_UNIT Function
- 285.6.4 CURRENT_EDITION Function
- 285.6.5 CONCATENATE_SUBPROGRAM Function
- 285.6.6 DYNAMIC_DEPTH Function
- 285.6.7 ERROR_DEPTH Function
- 285.6.8 ERROR_MSG Function
- 285.6.9 ERROR_NUMBER Function
- 285.6.10 LEXICAL_DEPTH Function
- 285.6.11 OWNER Function
- 285.6.12 UNIT_LINE Function
- 285.6.13 SUBPROGRAM Function
- 286 UTL_COLL
-
287
UTL_COMPRESS
- 287.1 UTL_COMPRESS Constants
- 287.2 UTL_COMPRESS Exceptions
- 287.3 UTL_COMPRESS Operational Notes
-
287.4
Summary of UTL_COMPRESS Subprograms
- 287.4.1 ISOPEN Function
- 287.4.2 LZ_COMPRESS Functions and Procedures
- 287.4.3 LZ_COMPRESS_ADD Procedure
- 287.4.4 LZ_COMPRESS_CLOSE
- 287.4.5 LZ_COMPRESS_OPEN
- 287.4.6 LZ_UNCOMPRESS Functions and Procedures
- 287.4.7 LZ_UNCOMPRESS_EXTRACT Procedure
- 287.4.8 LZ_UNCOMPRESS_OPEN Function
- 287.4.9 LZ_UNCOMPRESS_CLOSE Procedure
-
288
UTL_ENCODE
-
288.1
Summary of UTL_ENCODE Subprograms
- 288.1.1 BASE64_DECODE Function
- 288.1.2 BASE64_ENCODE Function
- 288.1.3 MIMEHEADER_DECODE Function
- 288.1.4 MIMEHEADER_ENCODE Function
- 288.1.5 QUOTED_PRINTABLE_DECODE Function
- 288.1.6 QUOTED_PRINTABLE_ENCODE Function
- 288.1.7 TEXT_DECODE Function
- 288.1.8 TEXT_ENCODE Function
- 288.1.9 UUDECODE Function
- 288.1.10 UUENCODE Function
-
288.1
Summary of UTL_ENCODE Subprograms
-
289
UTL_FILE
- 289.1 UTL_FILE Security Model
- 289.2 UTL_FILE Operational Notes
- 289.3 UTL_FILE Rules and Limits
- 289.4 UTL_FILE Exceptions
- 289.5 UTL_FILE Examples
- 289.6 UTL_FILE Data Structures
-
289.7
Summary of UTL_FILE Subprograms
- 289.7.1 FCLOSE Procedure
- 289.7.2 FCLOSE_ALL Procedure
- 289.7.3 FCOPY Procedure
- 289.7.4 FFLUSH Procedure
- 289.7.5 FGETATTR Procedure
- 289.7.6 FGETPOS Function
- 289.7.7 FOPEN Function
- 289.7.8 FOPEN_NCHAR Function
- 289.7.9 FREMOVE Procedure
- 289.7.10 FRENAME Procedure
- 289.7.11 FSEEK Procedure
- 289.7.12 GET_LINE Procedure
- 289.7.13 GET_LINE_NCHAR Procedure
- 289.7.14 GET_RAW Procedure
- 289.7.15 IS_OPEN Function
- 289.7.16 NEW_LINE Procedure
- 289.7.17 PUT Procedure
- 289.7.18 PUT_LINE Procedure
- 289.7.19 PUT_LINE_NCHAR Procedure
- 289.7.20 PUT_NCHAR Procedure
- 289.7.21 PUTF Procedure
- 289.7.22 PUTF_NCHAR Procedure
- 289.7.23 PUT_RAW Procedure
-
290
UTL_HTTP
- 290.1 UTL_HTTP Overview
- 290.2 UTL_HTTP Security Model
- 290.3 UTL_HTTP Constants
- 290.4 UTL_HTTP Exceptions
-
290.5
UTL_HTTP Examples
- 290.5.1 UTL_HTTP General Usage
- 290.5.2 UTL_HTTP Retrieving HTTP Response Headers
- 290.5.3 UTL_HTTP Handling HTTP Authentication
- 290.5.4 UTL_HTTP Handling HTTP Digest Authentication
- 290.5.5 UTL_HTTP Retrieving and Restoring Cookies
- 290.5.6 UTL_HTTP Making HTTP Request with Private Wallet and Cookie Table
- 290.5.7 UTL_HTTP Using a Proxy Server
- 290.6 UTL_HTTP Data Structures
-
290.7
UTL_HTTP Operations
- 290.7.1 UTL_HTTP Operational Flow
- 290.7.2 UTL_HTTP Simple HTTP Fetches
- 290.7.3 UTL_HTTP HTTP Requests
- 290.7.4 UTL_HTTP HTTP Responses
- 290.7.5 UTL_HTTP HTTP Cookies
- 290.7.6 UTL_HTTP HTTP Persistent Connections
- 290.7.7 UTL_HTTP Error Conditions
- 290.7.8 UTL_HTTP Session Settings
- 290.7.9 UTL_HTTP Request Context
- 290.7.10 UTL_HTTP External Password Store
-
290.8
UTL_HTTP Subprogram Groups
- 290.8.1 UTL_HTTP Simple HTTP Fetches in a Single Call Subprograms
- 290.8.2 UTL_HTTP Session Settings Subprograms
- 290.8.3 UTL_HTTP HTTP Requests Subprograms
- 290.8.4 UTL_HTTP HTTP Request Contexts Subprograms
- 290.8.5 UTL_HTTP HTTP Responses Subprograms
- 290.8.6 UTL_HTTP HTTP Cookies Subprograms
- 290.8.7 UTL_HTTP HTTP Persistent Connections Subprograms
- 290.8.8 UTL_HTTP Error Conditions Subprograms
-
290.9
Summary of UTL_HTTP Subprograms
- 290.9.1 ADD_COOKIES Procedure
- 290.9.2 BEGIN_REQUEST Function
- 290.9.3 CLEAR_COOKIES Procedure
- 290.9.4 CLOSE_PERSISTENT_CONN Procedure
- 290.9.5 CLOSE_PERSISTENT_CONNS Procedure
- 290.9.6 CREATE_REQUEST_CONTEXT Function
- 290.9.7 DESTROY_REQUEST_CONTEXT Procedure
- 290.9.8 END_REQUEST Procedure
- 290.9.9 END_RESPONSE Procedure
- 290.9.10 GET_AUTHENTICATION Procedure
- 290.9.11 GET_BODY_CHARSET Procedure
- 290.9.12 GET_COOKIE_COUNT Function
- 290.9.13 GET_COOKIE_SUPPORT Procedure
- 290.9.14 GET_COOKIES Function
- 290.9.15 GET_DETAILED_EXCP_SUPPORT Procedure
- 290.9.16 GET_DETAILED_SQLCODE Function
- 290.9.17 GET_DETAILED_SQLERRM Function
- 290.9.18 GET_FOLLOW_REDIRECT Procedure
- 290.9.19 GET_HEADER Procedure
- 290.9.20 GET_HEADER_BY_NAME Procedure
- 290.9.21 GET_HEADER_COUNT Function
- 290.9.22 GET_PERSISTENT_CONN_COUNT Function
- 290.9.23 GET_PERSISTENT_CONN_SUPPORT Procedure
- 290.9.24 GET_PERSISTENT_CONNS Procedure
- 290.9.25 GET_PROXY Procedure
- 290.9.26 GET_RESPONSE Function
- 290.9.27 GET_RESPONSE_ERROR_CHECK Procedure
- 290.9.28 GET_TRANSFER_TIMEOUT Procedure
- 290.9.29 READ_LINE Procedure
- 290.9.30 READ_RAW Procedure
- 290.9.31 READ_TEXT Procedure
- 290.9.32 REQUEST Function
- 290.9.33 REQUEST_PIECES Function
- 290.9.34 SET_AUTHENTICATION Procedure
- 290.9.35 SET_AUTHENTICATION_FROM_WALLET Procedure
- 290.9.36 SET_BODY_CHARSET Procedures
- 290.9.37 SET_COOKIE_SUPPORT Procedures
- 290.9.38 SET_DETAILED_EXCP_SUPPORT Procedure
- 290.9.39 SET_FOLLOW_REDIRECT Procedures
- 290.9.40 SET_HEADER Procedure
- 290.9.41 SET_PERSISTENT_CONN_SUPPORT Procedure
- 290.9.42 SET_PROXY Procedure
- 290.9.43 SET_RESPONSE_ERROR_CHECK Procedure
- 290.9.44 SET_TRANSFER_TIMEOUT Procedure
- 290.9.45 SET_WALLET Procedure
- 290.9.46 WRITE_LINE Procedure
- 290.9.47 WRITE_RAW Procedure
- 290.9.48 WRITE_TEXT Procedure
-
291
UTL_I18N
- 291.1 UTL_I18N Overview
- 291.2 UTL_I18N Security Model
- 291.3 UTL_I18N Constants
- 291.4 UTL_I18N Data Structures
-
291.5
Summary of UTL_I18N Subprograms
- 291.5.1 DETECT_CHARSET Procedure
- 291.5.2 DETECT_LANGUAGE Procedure
- 291.5.3 DETECT_LANGUAGE_CHARSET Procedure
- 291.5.4 ESCAPE_REFERENCE Function
- 291.5.5 GET_COMMON_TIME_ZONES Function
- 291.5.6 GET_DEFAULT_CHARSET Function
- 291.5.7 GET_DEFAULT_ISO_CURRENCY Function
- 291.5.8 GET_DEFAULT_LINGUISTIC_SORT Function
- 291.5.9 GET_LOCAL_LANGUAGES Function
- 291.5.10 GET_LOCAL_LINGUISTIC_SORTS Function
- 291.5.11 GET_LOCAL_TERRITORIES Function
- 291.5.12 GET_LOCAL_TIME_ZONES Function
- 291.5.13 GET_MAX_CHARACTER_SIZE Function
- 291.5.14 GET_TRANSLATION Function
- 291.5.15 MAP_CHARSET Function
- 291.5.16 MAP_FROM_SHORT_LANGUAGE Function
- 291.5.17 MAP_LANGUAGE_FROM_ISO Function
- 291.5.18 MAP_LOCALE_TO_ISO Function
- 291.5.19 MAP_TERRITORY_FROM_ISO Function
- 291.5.20 MAP_TO_SHORT_LANGUAGE Function
- 291.5.21 RAW_TO_CHAR Functions
- 291.5.22 RAW_TO_NCHAR Functions
- 291.5.23 STRING_TO_RAW Function
- 291.5.24 TRANSLITERATE Function
- 291.5.25 UNESCAPE_REFERENCE Function
- 291.5.26 VALIDATE_CHARACTER_ENCODING Functions
- 292 UTL_IDENT
- 293 UTL_INADDR
- 294 UTL_LMS
- 295 UTL_MAIL
- 296 UTL_MATCH
-
297
UTL_NLA
- 297.1 UTL_NLA Overview
- 297.2 UTL_NLA Rules and Limits
- 297.3 UTL_NLA Security Model
-
297.4
Subprogram Groups
- 297.4.1 UTL_NLA BLAS Level 1 (Vector-Vector Operations) Subprograms
- 297.4.2 UTL_NLA BLAS Level 2 (Matrix-Vector Operations) Subprograms
- 297.4.3 UTL_NLA BLAS Level 3 (Matrix-Matrix Operations) Subprograms
- 297.4.4 UTL_NLA LAPACK Driver Routines (Linear Equations) Subprograms
- 297.4.5 UTL_NLA LAPACK Driver Routines (LLS and Eigenvalue Problems) Subprograms
-
297.5
Summary of UTL_NLA Subprograms
- 297.5.1 BLAS_ASUM Functions
- 297.5.2 BLAS_AXPY Procedures
- 297.5.3 BLAS_COPY Procedures
- 297.5.4 BLAS_DOT Functions
- 297.5.5 BLAS_GBMV Procedures
- 297.5.6 BLAS_GEMM Procedures
- 297.5.7 BLAS_GEMV Procedures
- 297.5.8 BLAS_GER Procedures
- 297.5.9 BLAS_IAMAX Functions
- 297.5.10 BLAS_NRM2 Functions
- 297.5.11 BLAS_ROT Procedures
- 297.5.12 BLAS_ROTG Procedures
- 297.5.13 BLAS_SCAL Procedures
- 297.5.14 BLAS_SPMV Procedures
- 297.5.15 BLAS_SPR Procedures
- 297.5.16 BLAS_SPR2 Procedures
- 297.5.17 BLAS_SBMV Procedures
- 297.5.18 BLAS_SWAP Procedures
- 297.5.19 BLAS_SYMM Procedures
- 297.5.20 BLAS_SYMV Procedures
- 297.5.21 BLAS_SYR Procedures
- 297.5.22 BLAS_SYR2 Procedures
- 297.5.23 BLAS_SYR2K Procedures
- 297.5.24 BLAS_SYRK Procedures
- 297.5.25 BLAS_TBMV Procedures
- 297.5.26 BLAS_TBSV Procedures
- 297.5.27 BLAS_TPMV Procedures
- 297.5.28 BLAS_TPSV Procedures
- 297.5.29 BLAS_TRMM Procedures
- 297.5.30 BLAS_TRMV Procedures
- 297.5.31 BLAS_TRSM Procedures
- 297.5.32 BLAS_TRSV Procedures
- 297.5.33 LAPACK_GBSV Procedures
- 297.5.34 LAPACK_GEES Procedures
- 297.5.35 LAPACK_GELS Procedures
- 297.5.36 LAPACK_GESDD Procedures
- 297.5.37 LAPACK_GESV Procedure
- 297.5.38 LAPACK_GESVD Procedures
- 297.5.39 LAPACK_GEEV Procedures
- 297.5.40 LAPACK_GTSV Procedure
- 297.5.41 LAPACK_PBSV Procedures
- 297.5.42 LAPACK_POSV Procedures
- 297.5.43 LAPACK_PPSV Procedures
- 297.5.44 LAPACK_PTSV Procedures
- 297.5.45 LAPACK_SBEV Procedures
- 297.5.46 LAPACK_SBEVD Procedures
- 297.5.47 LAPACK_SPEV Procedures
- 297.5.48 LAPACK_SPEVD Procedures
- 297.5.49 LAPACK_SPSV Procedures
- 297.5.50 LAPACK_STEV Procedures
- 297.5.51 LAPACK_STEVD Procedures
- 297.5.52 LAPACK_SYEV Procedures
- 297.5.53 LAPACK_SYEVD Procedures
- 297.5.54 LAPACK_SYSV Procedures
-
298
UTL_RAW
- 298.1 UTL_RAW Overview
- 298.2 UTL_RAW Operational Notes
-
298.3
Summary of UTL_RAW Subprograms
- 298.3.1 BIT_AND Function
- 298.3.2 BIT_COMPLEMENT Function
- 298.3.3 BIT_OR Function
- 298.3.4 BIT_XOR Function
- 298.3.5 CAST_FROM_BINARY_DOUBLE Function
- 298.3.6 CAST_FROM_BINARY_FLOAT Function
- 298.3.7 CAST_FROM_BINARY_INTEGER Function
- 298.3.8 CAST_FROM_NUMBER Function
- 298.3.9 CAST_TO_BINARY_DOUBLE Function
- 298.3.10 CAST_TO_BINARY_FLOAT Function
- 298.3.11 CAST_TO_BINARY_INTEGER Function
- 298.3.12 CAST_TO_NUMBER Function
- 298.3.13 CAST_TO_NVARCHAR2 Function
- 298.3.14 CAST_TO_RAW Function
- 298.3.15 CAST_TO_VARCHAR2 Function
- 298.3.16 COMPARE Function
- 298.3.17 CONCAT Function
- 298.3.18 CONVERT Function
- 298.3.19 COPIES Function
- 298.3.20 LENGTH Function
- 298.3.21 OVERLAY Function
- 298.3.22 REVERSE Function
- 298.3.23 SUBSTR Function
- 298.3.24 TRANSLATE Function
- 298.3.25 TRANSLITERATE Function
- 298.3.26 XRANGE Function
- 299 UTL_RECOMP
- 300 UTL_REF
- 301 UTL_RPADV
-
302
UTL_SMTP
- 302.1 UTL_SMTP Overview
- 302.2 UTL_SMTP Security Model
- 302.3 UTL_SMTP Constants
- 302.4 UTL_SMTP Types
- 302.5 UTL_SMTP Reply Codes
- 302.6 UTL_SMTP Operational Notes
- 302.7 UTL_SMTP Exceptions
- 302.8 UTL_SMTP Rules and Limits
- 302.9 UTL_SMTP Examples
-
302.10
Summary of UTL_SMTP Subprograms
- 302.10.1 AUTH Function and Procedure
- 302.10.2 CLOSE_CONNECTION Procedure
- 302.10.3 CLOSE_DATA Function and Procedure
- 302.10.4 COMMAND Function and Procedure
- 302.10.5 COMMAND_REPLIES Function
- 302.10.6 DATA Function and Procedure
- 302.10.7 EHLO Function and Procedure
- 302.10.8 HELO Function and Procedure
- 302.10.9 HELP Function
- 302.10.10 MAIL Function and Procedure
- 302.10.11 NOOP Function and Procedure
- 302.10.12 OPEN_CONNECTION Functions
- 302.10.13 OPEN_DATA Function and Procedure
- 302.10.14 QUIT Function and Procedure
- 302.10.15 RCPT Function
- 302.10.16 RSET Function and Procedure
- 302.10.17 STARTTLS Function and Procedure
- 302.10.18 VRFY Function
- 302.10.19 WRITE_DATA Procedure
- 302.10.20 WRITE_RAW_DATA Procedure
-
303
UTL_TCP
- 303.1 UTL_TCP Overview
- 303.2 UTL_TCP Security Model
- 303.3 UTL_TCP Types
- 303.4 UTL_TCP Exceptions
- 303.5 UTL_TCP Rules and Limits
- 303.6 UTL_TCP Examples
-
303.7
Summary of UTL_TCP Subprograms
- 303.7.1 AVAILABLE Function
- 303.7.2 CLOSE_ALL_CONNECTIONS Procedure
- 303.7.3 CLOSE_CONNECTION Procedure
- 303.7.4 FLUSH Procedure
- 303.7.5 GET_LINE Function
- 303.7.6 GET_LINE_NCHAR Function
- 303.7.7 GET_RAW Function
- 303.7.8 GET_TEXT Function
- 303.7.9 GET_TEXT_NCHAR Function
- 303.7.10 OPEN_CONNECTION Function
- 303.7.11 READ_LINE Function
- 303.7.12 READ_RAW Function
- 303.7.13 READ_TEXT Function
- 303.7.14 SECURE_CONNECTION Procedure
- 303.7.15 WRITE_LINE Function
- 303.7.16 WRITE_RAW Function
- 303.7.17 WRITE_TEXT Function
- 304 UTL_URL
- 305 WPG_DOCLOAD
- 306 ANYDATA TYPE
-
307
ANYDATASET TYPE
- 307.1 ANYDATASET TYPE Construction
-
307.2
Summary of ANYDATASET TYPE Subprograms
- 307.2.1 ADDINSTANCE Member Procedure
- 307.2.2 BEGINCREATE Static Procedure
- 307.2.3 ENDCREATE Member Procedure
- 307.2.4 GET* Member Functions
- 307.2.5 GETCOUNT Member Function
- 307.2.6 GETINSTANCE Member Function
- 307.2.7 GETTYPE Member Function
- 307.2.8 GETTYPENAME Member Function
- 307.2.9 PIECEWISE Member Procedure
- 307.2.10 SET* Member Procedures
- 308 ANYTYPE TYPE
-
309
Oracle Database Advanced Queuing (AQ) Types
- 309.1 Advanced Queuing (AQ)Types Security Model
-
309.2
Oracle Database Advanced Queuing (AQ) Types —Summary of Types
- 309.2.1 AQ$_AGENT Type
- 309.2.2 AQ$_AGENT_LIST_T Type
- 309.2.3 AQ$_DESCRIPTOR Type
- 309.2.4 AQ$_NTFN_DESCRIPTOR Type
- 309.2.5 AQ$_NTFN_MSGID_ARRAY Type
- 309.2.6 AQ$_POST_INFO Type
- 309.2.7 AQ$_POST_INFO_LIST Type
- 309.2.8 AQ$_PURGE_OPTIONS_T Type
- 309.2.9 AQ$_RECIPIENT_LIST_T Type
- 309.2.10 AQ$_REG_INFO Type
- 309.2.11 AQ$_REG_INFO_LIST Type
- 309.2.12 AQ$_SUBSCRIBER_LIST_T Type
- 309.2.13 DEQUEUE_OPTIONS_T Type
- 309.2.14 ENQUEUE_OPTIONS_T Type
- 309.2.15 QUEUE_PROPS_T Type
- 309.2.16 SEEK_INPUT_T Type
- 309.2.17 SEEK_OUTPUT_T Type
- 309.2.18 SYS.MSG_PROP_T Type
- 309.2.19 MESSAGE_PROPERTIES_T Type
- 309.2.20 MESSAGE_PROPERTIES_ARRAY_T Type
- 309.2.21 MSGID_ARRAY_T Type
- 310 DBFS Content Interface Types
-
311
Database URI TYPEs
- 311.1 Summary of URITYPE Supertype Subprograms
-
311.2
Summary of HTTPURITYPE Subtype Subprograms
- 311.2.1 HttpUriType Subtype CREATEURI
- 311.2.2 HttpUriType Subtype GETBLOB
- 311.2.3 HttpUriType Subtype GETCLOB
- 311.2.4 HttpUriType Subtype GETCONTENTTYPE
- 311.2.5 HttpUriType Subtype GETEXTERNALURL
- 311.2.6 HttpUriType Subtype GETURL
- 311.2.7 HttpUriType Subtype GETXML
- 311.2.8 HttpUriType Subtype HTTPURITYPE
- 311.3 Summary of DBURITYPE Subtype Subprogams
- 311.4 Summary of XDBURITYPE Subtype Subprograms
- 311.5 Summary of URIFACTORY Package Subprograms
-
312
JMS Types
- 312.1 JMS Types Overview
- 312.2 JMS Types Security Model
- 312.3 Java Versus PL/SQL Datatypes
- 312.4 More on Bytes, Stream and Map Messages
- 312.5 Upcasting and Downcasting Between General and Specific Messages
- 312.6 JMS Types Error Reporting
- 312.7 Oracle JMS Type Constants
- 312.8 CONVERT_JMS_SELECTOR
-
312.9
Summary of JMS Types
- 312.9.1 SYS.AQ$_JMS_MESSAGE Type
- 312.9.2 SYS.AQ$_JMS_TEXT_MESSAGE Type
- 312.9.3 SYS.AQ$_JMS_BYTES_MESSAGE Type
- 312.9.4 SYS.AQ$_JMS_MAP_MESSAGE Type
- 312.9.5 SYS.AQ$_JMS_STREAM_MESSAGE Type
- 312.9.6 SYS.AQ$_JMS_OBJECT_MESSAGE Type
- 312.9.7 SYS.AQ$_JMS_NAMEARRAY Type
- 312.9.8 SYS.AQ$_JMS_VALUE Type
- 312.9.9 SYS.AQ$_JMS_EXCEPTION Type
- 313 JSON Data Structures
- 314 Logical Change Record TYPEs
- 315 MGD_ID Package Types
-
316
Rule TYPEs
- 316.1 Rule TYPEs Overview
- 316.2 Rule TYPEs Security Model
-
316.3
Summary of Rule Types
- 316.3.1 RE$ATTRIBUTE_VALUE Type
- 316.3.2 RE$ATTRIBUTE_VALUE_LIST Type
- 316.3.3 RE$COLUMN_VALUE Type
- 316.3.4 RE$COLUMN_VALUE_LIST Type
- 316.3.5 RE$NAME_ARRAY Type
- 316.3.6 RE$NV_ARRAY Type
- 316.3.7 RE$NV_LIST Type
- 316.3.8 RE$NV_NODE Type
- 316.3.9 RE$RULE_HIT Type
- 316.3.10 RE$RULE_HIT_LIST Type
- 316.3.11 RE$RULE_NAME Type
- 316.3.12 RE$RULE_NAME_LIST Type
- 316.3.13 RE$TABLE_ALIAS Type
- 316.3.14 RE$TABLE_ALIAS_LIST Type
- 316.3.15 RE$TABLE_VALUE Type
- 316.3.16 RE$TABLE_VALUE_LIST Type
- 316.3.17 RE$VALUE Type
- 316.3.18 RE$VALUE_LIST Type
- 316.3.19 RE$VARIABLE_TYPE Type
- 316.3.20 RE$VARIABLE_TYPE_LIST Type
- 316.3.21 RE$VARIABLE_VALUE Type
- 316.3.22 RE$VARIABLE_VALUE_LIST Type
-
317
SODA Types
- 317.1 SODA Types Overview
- 317.2 SODA Types Security Model
-
317.3
Summary of SODA Types
-
317.3.1
SODA_Collection_T Type
- 317.3.1.1 CREATE_INDEX Function
- 317.3.1.2 CREATE_VIEW_FROM_DG Function
- 317.3.1.3 DROP_INDEX Function
- 317.3.1.4 FIND Function
- 317.3.1.5 FIND_ONE Function
- 317.3.1.6 GET_DATA_GUIDE Function
- 317.3.1.7 GET_INDEX Function
- 317.3.1.8 GET_METADATA Function
- 317.3.1.9 GET_NAME Function
- 317.3.1.10 INSERT_ONE Function
- 317.3.1.11 INSERT_ONE_AND_GET Function
- 317.3.1.12 LIST_INDEXES Function
- 317.3.1.13 REMOVE_ONE Function
- 317.3.1.14 REPLACE_ONE Function
- 317.3.1.15 REPLACE_ONE_AND_GET Function
- 317.3.1.16 SAVE Function
- 317.3.1.17 SAVE_AND_GET Function
- 317.3.1.18 TRUNCATE Function
-
317.3.2
SODA_Document_T Type
- 317.3.2.1 GET_BLOB Function
- 317.3.2.2 GET_CLOB Function
- 317.3.2.3 GET_CREATED_ON Function
- 317.3.2.4 GET_DATA_TYPE Function
- 317.3.2.5 GET_JSON Function
- 317.3.2.6 GET_KEY Function
- 317.3.2.7 GET_LAST_MODIFIED Function
- 317.3.2.8 GET_MEDIA_TYPE Function
- 317.3.2.9 GET_VARCHAR2 Function
- 317.3.2.10 GET_VERSION Function
- 317.3.2.11 SODA_Document_T Function
-
317.3.3
SODA_OPERATION_T Type
- 317.3.3.1 ACQUIRE_LOCK Function
- 317.3.3.2 AS_OF_SCN Function
- 317.3.3.3 AS_OF_TIMESTAMP Function
- 317.3.3.4 COUNT Function
- 317.3.3.5 FILTER Function
- 317.3.3.6 GET_CURSOR Function
- 317.3.3.7 GET_DATA_GUIDE Function
- 317.3.3.8 GET_ONE Function
- 317.3.3.9 HINT Function
- 317.3.3.10 KEY Function
- 317.3.3.11 KEYS Function
- 317.3.3.12 LIMIT Function
- 317.3.3.13 REMOVE Function
- 317.3.3.14 REPLACE_ONE Function
- 317.3.3.15 REPLACE_ONE_AND_GET Function
- 317.3.3.16 SAMPLE Function
- 317.3.3.17 SKIP Function
- 317.3.3.18 VERSION Function
- 317.3.4 SODA_CURSOR_T Type
-
317.3.1
SODA_Collection_T Type
- 318 UTL Streams Types
-
319
XMLTYPE
-
319.1
Summary of XMLType Subprograms
- 319.1.1 CREATENONSCHEMABASEDXML
- 319.1.2 CREATESCHEMABASEDXML
- 319.1.3 CREATEXML
- 319.1.4 EXISTSNODE
- 319.1.5 EXTRACT
- 319.1.6 GETBLOBVAL
- 319.1.7 GETCLOBVAL
- 319.1.8 GETNAMESPACE
- 319.1.9 GETNUMBERVAL
- 319.1.10 GETROOTELEMENT
- 319.1.11 GETSCHEMAURL
- 319.1.12 GETSTRINGVAL
- 319.1.13 ISFRAGMENT
- 319.1.14 ISSCHEMABASED
- 319.1.15 ISSCHEMAVALID
- 319.1.16 ISSCHEMAVALIDATED
- 319.1.17 SCHEMAVALIDATE
- 319.1.18 SETSCHEMAVALIDATED
- 319.1.19 TOOBJECT
- 319.1.20 TRANSFORM
- 319.1.21 XMLTYPE
-
319.1
Summary of XMLType Subprograms
- Index