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 CTX_QUERY
- 11 CTX_REPORT
- 12 CTX_THES
- 13 CTX_ULEXER
- 14 DBMS_ACTIVITY
-
15
DBMS_ADDM
- 15.1 DBMS_ADDM Security Model
-
15.2
Summary of DBMS_ADDM Subprograms
- 15.2.1 ANALYZE_DB Procedure
- 15.2.2 ANALYZE_INST Procedure
- 15.2.3 ANALYZE_PARTIAL Procedure
- 15.2.4 COMPARE_CAPTURE_REPLAY_REPORT Function
- 15.2.5 COMPARE_DATABASES Function
- 15.2.6 COMPARE_INSTANCES Function
- 15.2.7 COMPARE_REPLAY_REPLAY_REPORT Function
- 15.2.8 DELETE Procedure
- 15.2.9 DELETE_FINDING_DIRECTIVE Procedure
- 15.2.10 DELETE_PARAMETER_DIRECTIVE Procedure
- 15.2.11 DELETE_SEGMENT_DIRECTIVE Procedure
- 15.2.12 DELETE_SQL_DIRECTIVE Procedure
- 15.2.13 FAILED_AUTO_TASKS_REPORT Function
- 15.2.14 GET_ASH_QUERY Function
- 15.2.15 GET_REPORT Function
- 15.2.16 INSERT_FINDING_DIRECTIVE Procedure
- 15.2.17 INSERT_PARAMETER_DIRECTIVE Procedure
- 15.2.18 INSERT_SEGMENT_DIRECTIVE Procedure
- 15.2.19 INSERT_SQL_DIRECTIVE Procedure
- 15.2.20 REAL_TIME_ADDM_REPORT Function
- 15.2.21 REEXECUTE_FAILED_AUTO_TASKS Procedure
- 16 DBMS_ADVANCED_REWRITE
-
17
DBMS_ADVISOR
- 17.1 DBMS_ADVISOR Deprecated Subprograms
- 17.2 DBMS_ADVISOR Security Model
-
17.3
Summary of DBMS_ADVISOR Subprograms
- 17.3.1 ADD_SQLWKLD_REF Procedure
- 17.3.2 ADD_SQLWKLD_STATEMENT Procedure
- 17.3.3 ADD_STS_REF Procedure
- 17.3.4 CANCEL_TASK Procedure
- 17.3.5 COPY_SQLWKLD_TO_STS Procedure
- 17.3.6 CREATE_FILE Procedure
- 17.3.7 CREATE_OBJECT Procedure
- 17.3.8 CREATE_SQLWKLD Procedure
- 17.3.9 CREATE_TASK Procedures
- 17.3.10 DELETE_SQLWKLD Procedure
- 17.3.11 DELETE_SQLWKLD_REF Procedure
- 17.3.12 DELETE_SQLWKLD_STATEMENT Procedure
- 17.3.13 DELETE_STS_REF Procedure
- 17.3.14 DELETE_TASK Procedure
- 17.3.15 EXECUTE_TASK Procedure
- 17.3.16 GET_REC_ATTRIBUTES Procedure
- 17.3.17 GET_TASK_REPORT Function
- 17.3.18 GET_TASK_SCRIPT Function
- 17.3.19 IMPLEMENT_TASK Procedure
- 17.3.20 IMPORT_SQLWKLD_SCHEMA Procedure
- 17.3.21 IMPORT_SQLWKLD_SQLCACHE Procedure
- 17.3.22 IMPORT_SQLWKLD_STS Procedure
- 17.3.23 IMPORT_SQLWKLD_SUMADV Procedure
- 17.3.24 IMPORT_SQLWKLD_USER Procedure
- 17.3.25 INTERRUPT_TASK Procedure
- 17.3.26 MARK_RECOMMENDATION Procedure
- 17.3.27 QUICK_TUNE Procedure
- 17.3.28 RESET_SQLWKLD Procedure
- 17.3.29 RESET_TASK Procedure
- 17.3.30 SET_DEFAULT_SQLWKLD_PARAMETER Procedure
- 17.3.31 SET_DEFAULT_TASK_PARAMETER Procedure
- 17.3.32 SET_SQLWKLD_PARAMETER Procedure
- 17.3.33 SET_TASK_PARAMETER Procedure
- 17.3.34 TUNE_MVIEW Procedure
- 17.3.35 UPDATE_OBJECT Procedure
- 17.3.36 UPDATE_REC_ATTRIBUTES Procedure
- 17.3.37 UPDATE_SQLWKLD_ATTRIBUTES Procedure
- 17.3.38 UPDATE_SQLWKLD_STATEMENT Procedure
- 17.3.39 UPDATE_TASK_ATTRIBUTES Procedure
- 18 DBMS_AUTOIM
- 19 DBMS_ALERT
- 20 DBMS_APP_CONT
-
21
DBMS_APP_CONT_ADMIN
- 21.1 DBMS_APP_CONT_ADMIN Security Model
-
21.2
Summary of DBMS_APP_CONT_ADMIN Subprograms
- 21.2.1 ACCHK_CLEAR_FILTER Procedure
- 21.2.2 ACCHK_PURGE Procedure
- 21.2.3 ACCHK_SET Procedure
- 21.2.4 ACCHK_SET_FILTER Procedure
- 21.2.5 ACCHK_SHOW_FILTERS Procedure
- 21.2.6 ADD_SQL_CONNECTION_TEST Procedure
- 21.2.7 CHECK_REPLAY_RULES Procedure
- 21.2.8 CREATE_CHILD_SERVICE Procedure
- 21.2.9 DELETE_CHILD_SERVICE Procedure
- 21.2.10 DELETE_SQL_CONNECTION_TEST Procedure
- 21.2.11 DISABLE_CONNECTION_TEST Procedure
- 21.2.12 DISABLE_FAILOVER Procedure
- 21.2.13 DISABLE_SMART_CONNECTION Procedure
- 21.2.14 ENABLE_AC Procedure
- 21.2.15 ENABLE_CONNECTION_TEST Procedure
- 21.2.16 ENABLE_RESET_STATE Procedure
- 21.2.17 ENABLE_SMART_CONNECTION Procedure
- 21.2.18 ENABLE_TAC Procedure
- 21.2.19 ENABLE_TAF Procedure
- 21.2.20 ENABLE_TG Procedure
- 21.2.21 MODIFY_SERVICE Procedure
- 21.2.22 RESET_REPLAY_RULES Procedure
- 21.2.23 SET_DRAINING Procedure
- 21.2.24 SET_LOAD_BALANCING_GOAL Procedure
- 21.2.25 SET_REPLAY_RULES Procedure
- 22 DBMS_APP_CONT_REPORT
- 23 DBMS_APPLICATION_INFO
-
24
DBMS_APPLY_ADM
- 24.1 DBMS_APPLY_ADM Overview
- 24.2 DBMS_APPLY_ADM Security Model
- 24.3 DBMS_APPLY_ADM Deprecated Subprograms
-
24.4
Summary of DBMS_APPLY_ADM Subprograms
- 24.4.1 ALTER_APPLY Procedure
- 24.4.2 CLEAR_KEY_COLUMNS Procedure
- 24.4.3 COMPARE_OLD_VALUES Procedure
- 24.4.4 CREATE_APPLY Procedure
- 24.4.5 CREATE_OBJECT_DEPENDENCY Procedure
- 24.4.6 DELETE_ALL_ERRORS Procedure
- 24.4.7 DELETE_ERROR Procedure
- 24.4.8 DROP_APPLY Procedure
- 24.4.9 DROP_OBJECT_DEPENDENCY Procedure
- 24.4.10 EXECUTE_ALL_ERRORS Procedure
- 24.4.11 EXECUTE_ERROR Procedure
- 24.4.12 GET_ERROR_MESSAGE Function
- 24.4.13 HANDLE_COLLISIONS
- 24.4.14 SET_DML_CONFLICT_HANDLER Procedure
- 24.4.15 SET_DML_HANDLER Procedure
- 24.4.16 SET_ENQUEUE_DESTINATION Procedure
- 24.4.17 SET_EXECUTE Procedure
- 24.4.18 SET_GLOBAL_INSTANTIATION_SCN Procedure
- 24.4.19 SET_KEY_COLUMNS Procedures
- 24.4.20 SET_PARAMETER Procedure
- 24.4.21 SET_REPERROR_HANDLER Procedure
- 24.4.22 SET_SCHEMA_INSTANTIATION_SCN Procedure
- 24.4.23 SET_TABLE_INSTANTIATION_SCN Procedure
- 24.4.24 SET_UPDATE_CONFLICT_HANDLER Procedure
- 24.4.25 SET_VALUE_DEPENDENCY Procedure
- 24.4.26 START_APPLY Procedure
- 24.4.27 STOP_APPLY Procedure
- 25 DBMS_AQ
-
26
DBMS_AQADM
- 26.1 DBMS_AQADM Security Model
- 26.2 DBMS_AQADM Constants
-
26.3
DBMS_AQADM Subprogram Groups
- 26.3.1 DBMS_AQADM Queue Table Subprograms
- 26.3.2 DBMS_AQADM Privilege Subprograms
- 26.3.3 DBMS_AQADM Queue Subprograms
- 26.3.4 DBMS_AQADM Subscriber Subprograms
- 26.3.5 DBMS_AQADM OKafka Subprograms
- 26.3.6 DBMS_AQADM Propagation Subprograms
- 26.3.7 DBMS_AQADM Miscellaneous Subprograms
- 26.3.8 DBMS_AQADM Agent Subprograms
- 26.3.9 DBMS_AQADM Alias Subprograms
-
26.4
Summary of DBMS_AQADM Subprograms
- 26.4.1 ADD_ALIAS_TO_LDAP Procedure
- 26.4.2 ADD_SUBSCRIBER Procedure
- 26.4.3 ALTER_AQ_AGENT Procedure
- 26.4.4 ALTER_PROPAGATION_SCHEDULE Procedure
- 26.4.5 ALTER_QUEUE Procedure
- 26.4.6 ALTER_QUEUE_TABLE Procedure
- 26.4.7 ALTER_SHARDED_QUEUE Procedure
- 26.4.8 ALTER_SUBSCRIBER Procedure
- 26.4.9 ALTER_TRANSACTIONAL_EVENT_QUEUE Procedure
- 26.4.10 CREATE_AQ_AGENT Procedure
- 26.4.11 CREATE_DATABASE_KAFKA_TOPIC Procedure
- 26.4.12 CREATE_NP_QUEUE Procedure
- 26.4.13 CREATE_QUEUE Procedure
- 26.4.14 CREATE_QUEUE_TABLE Procedure
- 26.4.15 CREATE_SHARDED_QUEUE Procedure
- 26.4.16 CREATE_EXCEPTION_QUEUE Procedure
- 26.4.17 CREATE_EQ EXCEPTION_QUEUE Procedure
- 26.4.18 CREATE_TRANSACTIONAL_EVENT_QUEUE Procedure
- 26.4.19 DEL_ALIAS_FROM_LDAP Procedure
- 26.4.20 DISABLE_DB_ACCESS Procedure
- 26.4.21 DISABLE_PROPAGATION_SCHEDULE Procedure
- 26.4.22 DROP_AQ_AGENT Procedure
- 26.4.23 DROP_DATABASE_KAFKA_TOPIC Procedure
- 26.4.24 DROP_QUEUE Procedure
- 26.4.25 DROP_QUEUE_TABLE Procedure
- 26.4.26 DROP_SHARDED_QUEUE Procedure
- 26.4.27 DROP_TRANSACTIONAL_EVENT_QUEUE Procedure
- 26.4.28 ENABLE_DB_ACCESS Procedure
- 26.4.29 ENABLE_JMS_TYPES Procedure
- 26.4.30 ENABLE_PROPAGATION_SCHEDULE Procedure
- 26.4.31 GET_MAX_STREAMS_POOL Procedure
- 26.4.32 GET_MIN_STREAMS_POOL Procedure
- 26.4.33 GET_QUEUE_PARAMETER Procedure
- 26.4.34 GET_WATERMARK Procedure
- 26.4.35 GRANT_QUEUE_PRIVILEGE Procedure
- 26.4.36 GRANT_SYSTEM_PRIVILEGE Procedure
- 26.4.37 MIGRATE_QUEUE_TABLE Procedure
- 26.4.38 MOVE_QUEUE_TABLE Procedure
- 26.4.39 PURGE_QUEUE_TABLE Procedure
- 26.4.40 QUEUE_SUBSCRIBERS Function
- 26.4.41 REMOVE_SUBSCRIBER Procedure
- 26.4.42 REVOKE_QUEUE_PRIVILEGE Procedure
- 26.4.43 REVOKE_SYSTEM_PRIVILEGE Procedure
- 26.4.44 SCHEDULE_PROPAGATION Procedure
- 26.4.45 SET_QUEUE_PARAMETER Procedure
- 26.4.46 SET_MAX_STREAMS_POOL Procedure
- 26.4.47 SET_MIN_STREAMS_POOL Procedure
- 26.4.48 SET_WATERMARK Procedure
- 26.4.49 START_QUEUE Procedure
- 26.4.50 STOP_QUEUE Procedure
- 26.4.51 UNSCHEDULE_PROPAGATION Procedure
- 26.4.52 UNSET_QUEUE_PARAMETER Procedure
- 26.4.53 VERIFY_QUEUE_TYPES Procedure
- 27 DBMS_AQELM
- 28 DBMS_AQIN
-
29
DBMS_AQMIGTOOL
- 29.1 DBMS_AQMIGTOOL Security Model
- 29.2 DBMS_AQMIGTOOL Constants
-
29.3
Summary of DBMS_AQMIGTOOL Subprograms
- 29.3.1 CANCEL_MIGRATION Procedure
- 29.3.2 CHECK_MIGRATED_MESSAGES Procedure
- 29.3.3 CHECK_MIGRATION_TO_TXEVENTQ Procedure
- 29.3.4 CHECK_STATUS Procedure
- 29.3.5 CLEAR_UNSUPPORTED_FEATURE_TABLE Procedure
- 29.3.6 COMMIT_MIGRATION Procedure
- 29.3.7 DISABLE_MIGRATION_CHECK Procedure
- 29.3.8 INIT_MIGRATION Procedure
- 29.3.9 PURGE_QUEUE_MESSAGES Procedure
- 29.3.10 RECOVER_MIGRATION Procedure
- 29.3.11 RENAME_QUEUE Procedure
- 30 DBMS_ASSERT
-
31
DBMS_AUDIT_MGMT
- 31.1 DBMS_AUDIT_MGMT Overview
- 31.2 DBMS_AUDIT_MGMT Deprecated and Desupported Subprograms
- 31.3 DBMS_AUDIT_MGMT Security Model
- 31.4 DBMS_AUDIT_MGMT Constants
- 31.5 DBMS_AUDIT_MGMT Views
- 31.6 DBMS_AUDIT_MGMT Subprogram Groups
-
31.7
Summary of DBMS_AUDIT_MGMT Subprograms
- 31.7.1 ALTER_PARTITION_INTERVAL Procedure
- 31.7.2 CLEAN_AUDIT_TRAIL Procedure
- 31.7.3 CLEAR_AUDIT_TRAIL_PROPERTY Procedure
- 31.7.4 CLEAR_LAST_ARCHIVE_TIMESTAMP Procedure
- 31.7.5 CREATE_PURGE_JOB Procedure
- 31.7.6 DEINIT_CLEANUP Procedure
- 31.7.7 DROP_OLD_UNIFIED_AUDIT_TABLES Procedure
- 31.7.8 DROP_PURGE_JOB Procedure
- 31.7.9 GET_AUDIT_COMMIT_DELAY Function
- 31.7.10 GET_ AUDIT_TRAIL_PROPERTY_VALUE Function
- 31.7.11 GET_LAST_ARCHIVE_TIMESTAMP Function
- 31.7.12 INIT_CLEANUP Procedure
- 31.7.13 IS_CLEANUP_INITIALIZED Function
- 31.7.14 LOAD_UNIFIED_AUDIT_FILES Procedure
- 31.7.15 SET_AUDIT_TRAIL_LOCATION Procedure
- 31.7.16 SET_AUDIT_TRAIL_PROPERTY Procedure
- 31.7.17 SET_LAST_ARCHIVE_TIMESTAMP Procedure
- 31.7.18 SET_PURGE_JOB_INTERVAL Procedure
- 31.7.19 SET_PURGE_JOB_STATUS Procedure
- 31.7.20 TRANSFER_UNIFIED_AUDIT_RECORDS Procedure
- 32 DBMS_AUDIT_UTIL
- 33 DBMS_AUTO_CLUSTERING
- 34 DBMS_AUTO_SQLTUNE
- 35 DBMS_AUTO_INDEX
- 36 DBMS_AUTO_MV
- 37 DBMS_AUTO_REPORT
- 38 DBMS_AUTO_TASK_ADMIN
- 39 DBMS_AUTO_ZONEMAP
-
40
DBMS_AVTUNE
- 40.1 DBMS_AVTUNE Overview
- 40.2 DBMS_AVTUNE Security Model
-
40.3
Summary of DBMS_AVTUNE Subprograms
- 40.3.1 AUTO_CACHE_CREATE Procedure
- 40.3.2 AUTO_CACHE_DISABLE Procedure
- 40.3.3 AUTO_CACHE_ENABLE Procedure
- 40.3.4 AUTO_CACHE_MODIFY Procedure
- 40.3.5 AUTO_CACHE_REFRESH Procedure
- 40.3.6 AUTO_CACHE_REMOVE Procedure
- 40.3.7 AUTO_CACHE_TUNE Procedure
- 40.3.8 AUTO_CACHE_STAR_DISABLE Procedure
- 40.3.9 AUTO_CACHE_STAR_ENABLE Procedure
- 40.3.10 AUTO_CACHE_STAR_MODIFY Procedure
- 40.3.11 AUTO_CACHE_STAR_REFRESH Procedure
- 41 DBMS_AW_STATS
-
42
DBMS_BLOCKCHAIN_TABLE
- 42.1 DBMS_BLOCKCHAIN_TABLE Overview
- 42.2 DBMS_BLOCKCHAIN_TABLE Security Model
-
42.3
Summary of DBMS_BLOCKCHAIN_TABLE Subprograms
- 42.3.1 ADD_INTERVAL_PARTITIONING Procedure
- 42.3.2 COUNTERSIGN_ROW Procedure
- 42.3.3 COUNTERSIGN_ROW_SPECIFIED_BY_KEY_COLUMNS Procedure
- 42.3.4 DELETE_EXPIRED_ROWS Procedure
- 42.3.5 GET_BLOCKCHAIN_DIGEST Function
- 42.3.6 GET_BLOCKCHAIN_DIGEST_FOR_SELECTED_ROWS Function
- 42.3.7 GET_BYTES_FOR_ROW_HASH Procedure
- 42.3.8 GET_BYTES_FOR_ROW_HASH_SPECIFIED_BY_KEY_COLUMNS Procedure
- 42.3.9 GET_BYTES_FOR_ROW_SIGNATURE Procedure
- 42.3.10 GET_BYTES_FOR_ROW_SIGNATURE_SPECIFIED_BY_KEY_COLUMNS Procedure
- 42.3.11 GET_SIGNED_BLOCKCHAIN_DIGEST Function
- 42.3.12 GET_SIGNED_BLOCKCHAIN_DIGEST_FOR_SELECTED_ROWS Function
- 42.3.13 SIGN_ROW Procedure
- 42.3.14 SIGN_ROW_SPECIFIED_BY_KEY_COLUMNS Procedure
- 42.3.15 SIGN_ROW_SPECIFIED_BY_KEY_COLUMNS_WITH_COUNTERSIGNATURE Procedure
- 42.3.16 SIGN_ROW_WITH_COUNTERSIGNATURE Procedure
- 42.3.17 VERIFY_ROWS Procedure
- 42.3.18 VERIFY_TABLE_BLOCKCHAIN Procedure
- 42.3.19 VERIFY_USER_BLOCKCHAIN_ROWS Procedure
- 43 DBMS_BLOCKER_RESOLVER
-
44
DBMS_CAPTURE_ADM
- 44.1 DBMS_CAPTURE_ADM Overview
- 44.2 DBMS_CAPTURE_ADM Security Model
-
44.3
Summary of DBMS_CAPTURE_ADM Subprograms
- 44.3.1 ABORT_GLOBAL_INSTANTIATION Procedure
- 44.3.2 ABORT_SCHEMA_INSTANTIATION Procedure
- 44.3.3 ABORT_SYNC_INSTANTIATION Procedure
- 44.3.4 ABORT_TABLE_INSTANTIATION Procedure
- 44.3.5 ALTER_CAPTURE Procedure
- 44.3.6 ALTER_SYNC_CAPTURE Procedure
- 44.3.7 BUILD Procedure
- 44.3.8 CREATE_CAPTURE Procedure
- 44.3.9 CREATE_SYNC_CAPTURE Procedure
- 44.3.10 DROP_CAPTURE Procedure
- 44.3.11 INCLUDE_EXTRA_ATTRIBUTE Procedure
- 44.3.12 PREPARE_GLOBAL_INSTANTIATION Procedure
- 44.3.13 PREPARE_SCHEMA_INSTANTIATION Procedure
- 44.3.14 PREPARE_SYNC_INSTANTIATION Function
- 44.3.15 PREPARE_TABLE_INSTANTIATION Procedure
- 44.3.16 SET_PARAMETER Procedure
- 44.3.17 START_CAPTURE Procedure
- 44.3.18 STOP_CAPTURE Procedure
- 45 DBMS_CACHEUTIL
-
46
DBMS_CLOUD
- 46.1 Installing DBMS_CLOUD
- 46.2 DBMS_CLOUD Endpoint Management
-
46.3
DBMS_CLOUD Subprograms and REST APIs
- 46.3.1 DBMS_CLOUD for Access Management
-
46.3.2
DBMS_CLOUD for Objects and Files
- 46.3.2.1 COPY_COLLECTION Procedure
- 46.3.2.2 COPY_DATA Procedure
- 46.3.2.3 COPY_DATA Procedure for Avro or Parquet Files
- 46.3.2.4 COPY_OBJECT Procedure
- 46.3.2.5 CREATE_EXTERNAL_PART_TABLE Procedure
- 46.3.2.6 CREATE_EXTERNAL_TABLE Procedure
- 46.3.2.7 CREATE_EXTERNAL_TABLE Procedure for Apache Iceberg
- 46.3.2.8 CREATE_EXTERNAL_TABLE Procedure for Avro or Parquet Files
- 46.3.2.9 CREATE_HYBRID_PART_TABLE Procedure
- 46.3.2.10 DELETE_ALL_OPERATIONS Procedure
- 46.3.2.11 DELETE_FILE Procedure
- 46.3.2.12 DELETE_OBJECT Procedure
- 46.3.2.13 DELETE_OPERATION Procedure
- 46.3.2.14 EXPORT_DATA Procedure
- 46.3.2.15 GET_OBJECT Procedure and Function
- 46.3.2.16 LIST_FILES Function
- 46.3.2.17 LIST_OBJECTS Function
- 46.3.2.18 MOVE_OBJECT Procedure
- 46.3.2.19 PUT_OBJECT Procedure
- 46.3.2.20 SYNC_EXTERNAL_PART_TABLE Procedure
- 46.3.2.21 VALIDATE_EXTERNAL_PART_TABLE Procedure
- 46.3.2.22 VALIDATE_EXTERNAL_TABLE Procedure
- 46.3.2.23 VALIDATE_HYBRID_PART_TABLE Procedure
- 46.3.3 DBMS_CLOUD for Bulk File Management
-
46.3.4
DBMS_CLOUD REST APIs
- 46.3.4.1 DBMS_CLOUD REST API Overview
- 46.3.4.2 DBMS_CLOUD REST API Constants
- 46.3.4.3 DBMS_CLOUD REST API Results Cache
- 46.3.4.4 GET_RESPONSE_HEADERS Function
- 46.3.4.5 GET_RESPONSE_RAW Function
- 46.3.4.6 GET_RESPONSE_STATUS_CODE Function
- 46.3.4.7 GET_RESPONSE_TEXT Function
- 46.3.4.8 GET_API_RESULT_CACHE_SIZE Function
- 46.3.4.9 SEND_REQUEST Function and Procedure
- 46.3.4.10 SET_API_RESULT_CACHE_SIZE Procedure
- 46.3.4.11 DBMS_CLOUD REST API Examples
-
46.4
DBMS_CLOUD URI Formats
- 46.4.1 Oracle Cloud Infrastructure Object Storage Native URI Format
- 46.4.2 Oracle Cloud Infrastructure Object Storage Swift URI Format
- 46.4.3 Oracle Cloud Infrastructure Object Storage URI Format Using Pre-Authenticated Request URL
- 46.4.4 URI Format Using Public URL
- 46.4.5 Oracle Cloud Infrastructure Object Storage Classic URI Format
- 46.4.6 Amazon S3 URI Format
- 46.4.7 Amazon S3 Compatible URI Format
- 46.4.8 GitHub Raw URL Format
- 46.4.9 Additional Customer-Managed URI Formats
- 46.5 DBMS_CLOUD Package Format Options
- 46.6 DBMS_CLOUD Package Format Options for EXPORT_DATA
-
46.7
DBMS_CLOUD Avro and Parquet Support
- 46.7.1 DBMS_CLOUD Package Format Options for Avro or Parquet
- 46.7.2 DBMS_CLOUD Package Avro to Oracle Data Type Mapping
- 46.7.3 DBMS_CLOUD Package ORC to Oracle Data Type Mapping
- 46.7.4 DBMS_CLOUD Package Parquet to Oracle Data Type Mapping
- 46.7.5 DBMS_CLOUD Package Oracle Data Type to Parquet Mapping
- 46.7.6 DBMS_CLOUD Package Avro and Parquet Complex Types
- 46.7.7 DBMS_CLOUD Package Avro and Parquet to Oracle Column Name Mapping
- 46.8 DBMS_CLOUD Exceptions
- 47 DBMS_CLOUD_AI
- 48 DBMS_CLOUD_NOTIFICATION
- 49 DBMS_CLOUD_PIPELINE
-
50
DBMS_CLOUD_REPO
- 50.1 DBMS_CLOUD_REPO Overview
- 50.2 DBMS_CLOUD_REPO Data Structures
- 50.3 DBMS_CLOUD_REPO Subprogram Groups
-
50.4
Summary of DBMS_CLOUD_REPO
Subprograms
- 50.4.1 CREATE_BRANCH Procedure
- 50.4.2 CREATE_REPOSITORY Procedure
- 50.4.3 DELETE_BRANCH Procedure
- 50.4.4 DELETE_FILE Procedure
- 50.4.5 DELETE_REPOSITORY Procedure
- 50.4.6 EXPORT_OBJECT Procedure
- 50.4.7 EXPORT_SCHEMA Procedure
- 50.4.8 GET_FILE Procedure and Function
- 50.4.9 INIT_AWS_REPO Function
- 50.4.10 INIT_AZURE_REPO Function
- 50.4.11 INIT_GITHUB_REPO Function
- 50.4.12 INIT_REPO Function
- 50.4.13 INSTALL_FILE Procedure
- 50.4.14 INSTALL_SQL Procedure
- 50.4.15 LIST_BRANCHES Function
- 50.4.16 LIST_COMMITS Function
- 50.4.17 LIST_FILES Function
- 50.4.18 LIST_REPOSITORIES Function
- 50.4.19 MERGE_BRANCH Procedure
- 50.4.20 PUT_FILE Procedure
- 50.4.21 UPDATE_REPOSITORY Procedure
- 51 DBMS_COMPARISON
- 52 DBMS_COMPRESSION
- 53 DBMS_CONNECTION_POOL
-
54
DBMS_CQ_NOTIFICATION
- 54.1 DBMS_CQ_NOTIFICATION Overview
- 54.2 DBMS_CQ_NOTIFICATION Security Model
- 54.3 DBMS_CQ_NOTIFICATION Constants
- 54.4 DBMS_CQ_NOTIFICATION Operational Notes
- 54.5 DBMS_CQ_NOTIFICATION Examples
-
54.6
DBMS_CQ_NOTIFICATION Data Structures
- 54.6.1 CQ_NOTIFICATION$_DESCRIPTOR Object Type
- 54.6.2 CQ_NOTIFICATION$_QUERY Object Type
- 54.6.3 CQ_NOTIFICATION$_QUERY_ARRAY Object (Array) Type
- 54.6.4 CQ_NOTIFICATION$_TABLE Object Type
- 54.6.5 CQ_NOTIFICATION$_TABLE_ARRAY Object (Array) Type
- 54.6.6 CQ_NOTIFICATION$_ROW Object Type
- 54.6.7 CQ_NOTIFICATION$_ROW_ARRAY Object (Array) Type
- 54.6.8 CQ_NOTIFICATION$_REG_INFO Object Type
- 54.7 Summary of DBMS_CQ_NOTIFICATION Subprograms
- 55 DBMS_CREDENTIAL
-
56
DBMS_CRYPTO
- 56.1 DBMS_CRYPTO Overview
- 56.2 DBMS_CRYPTO Security Model
- 56.3 DBMS_CRYPTO Constants
- 56.4 DBMS_CRYPTO Datatypes
- 56.5 DBMS_CRYPTO Algorithms
- 56.6 DBMS_CRYPTO Restrictions
- 56.7 DBMS_CRYPTO Exceptions
- 56.8 DBMS_CRYPTO Operational Notes
- 56.9 DBMS_CRYPTO Examples
-
56.10
Summary of DBMS_CRYPTO Subprograms
- 56.10.1 DECRYPT Functions
- 56.10.2 DECRYPT Procedures
- 56.10.3 ECDHDERIVE_SHAREDSECRET Function
- 56.10.4 ECDH_GENKEYPAIR Function
- 56.10.5 ENCRYPT Functions
- 56.10.6 ENCRYPT Procedures
- 56.10.7 HASH Function
- 56.10.8 HASH_LEN Function
- 56.10.9 MAC Function
- 56.10.10 KMACXOF Function
- 56.10.11 PKDECRYPT Function
- 56.10.12 PKENCRYPT Function
- 56.10.13 RANDOMBYTES Function
- 56.10.14 RANDOMINTEGER Function
- 56.10.15 RANDOMNUMBER Function
- 56.10.16 SIGN Function
- 56.10.17 VERIFY Function
- 57 DBMS_CSX_ADMIN
-
58
DBMS_CUBE
- 58.1 Using DBMS_CUBE
- 58.2 Using SQL Aggregation Management
- 58.3 Upgrading 10g Analytic Workspaces
-
58.4
Summary of DBMS_CUBE Subprograms
- 58.4.1 BUILD Procedure
- 58.4.2 CREATE_EXPORT_OPTIONS Procedure
- 58.4.3 CREATE_IMPORT_OPTIONS Procedure
- 58.4.4 CREATE_MVIEW Function
- 58.4.5 DERIVE_FROM_MVIEW Function
- 58.4.6 DROP_MVIEW Procedure
- 58.4.7 EXPORT_XML Procedure
- 58.4.8 EXPORT_XML_TO_FILE Procedure
- 58.4.9 IMPORT_XML Procedure
- 58.4.10 INITIALIZE_CUBE_UPGRADE Procedure
- 58.4.11 REFRESH_MVIEW Procedure
- 58.4.12 UPGRADE_AW Procedure
- 58.4.13 VALIDATE_XML Procedure
- 59 DBMS_CUBE_ADVISE
-
60
DBMS_CUBE_LOG
-
60.1
Using DBMS_CUBE_LOG
- 60.1.1 DBMS_CUBE_LOG — Logging Types
- 60.1.2 DBMS_CUBE_LOG — Logging Targets
- 60.1.3 DBMS_CUBE_LOG — Verbosity Levels
- 60.1.4 DBMS_CUBE_LOG Security Model
- 60.1.5 DBMS_CUBE_LOG — Creating Cube Logs
- 60.1.6 DBMS_CUBE_LOG — Cube Build Log
- 60.1.7 DBMS_CUBE_LOG — Cube Dimension Compile Log
- 60.1.8 DBMS_CUBE_LOG — Cube Operations Log
- 60.1.9 DBMS_CUBE_LOG — Cube Rejected Records Log
-
60.2
Summary of DBMS_CUBE_LOG Subprograms
- 60.2.1 DEFAULT_NAME Function
- 60.2.2 DISABLE Procedure
- 60.2.3 ENABLE Procedure
- 60.2.4 FLUSH Procedure
- 60.2.5 GET_LOG Procedure
- 60.2.6 GET_LOG_SPEC Function
- 60.2.7 GET_PARAMETER Function
- 60.2.8 LEVEL_HIGH Function
- 60.2.9 LEVEL_HIGHEST Function
- 60.2.10 LEVEL_LOW Function
- 60.2.11 LEVEL_LOWEST Function
- 60.2.12 LEVEL_MEDIUM Function
- 60.2.13 SET_LOG_SPEC Procedure
- 60.2.14 SET_PARAMETER Procedure
- 60.2.15 TABLE_CREATE Procedure
- 60.2.16 TARGET_FILE Function
- 60.2.17 TARGET_LOB Function
- 60.2.18 TARGET_TABLE Function
- 60.2.19 TARGET_TRACE Function
- 60.2.20 TYPE_BUILD Function
- 60.2.21 TYPE_DIMENSION_COMPILE Function
- 60.2.22 TYPE_OPERATIONS Function
- 60.2.23 TYPE_REJECTED_RECORDS Function
- 60.2.24 VERSION Function
-
60.1
Using DBMS_CUBE_LOG
-
61
DBMS_DATA_MINING
- 61.1 DBMS_DATA_MINING Overview
- 61.2 DBMS_DATA_MINING Security Model
- 61.3 DBMS_DATA_MINING — Machine Learning Functions
- 61.4 DBMS_DATA_MINING — Model Settings
-
61.5
DBMS_DATA_MINING — Algorithm Specific Model Settings
- 61.5.1 DBMS_DATA_MINING — Algorithm Settings: ALGO_EXTENSIBLE_LANG
- 61.5.2 DBMS_DATA_MINING — Algorithm Settings: CUR Matrix Decomposition
- 61.5.3 DBMS_DATA_MINING — Algorithm Settings: Decision Tree
- 61.5.4 DBMS_DATA_MINING — Algorithm Settings: Expectation Maximization
- 61.5.5 DBMS_DATA_MINING — Algorithm Settings: Explicit Semantic Analysis
- 61.5.6 DBMS_DATA_MINING — Algorithm Settings: Exponential Smoothing
- 61.5.7 DBMS_DATA_MINING — Algorithm Settings: Generalized Linear Model
- 61.5.8 DBMS_DATA_MINING — Algorithm Settings: k-Means
- 61.5.9 DBMS_DATA_MINING - Algorithm Settings: Multivariate State Estimation Technique - Sequential Probability Ratio Test
- 61.5.10 DBMS_DATA_MINING — Algorithm Settings: Naive Bayes
- 61.5.11 DBMS_DATA_MINING — Algorithm Settings: Neural Network
- 61.5.12 DBMS_DATA_MINING — Algorithm Settings: Non-Negative Matrix Factorization
- 61.5.13 DBMS_DATA_MINING — Algorithm Settings: O-Cluster
- 61.5.14 DBMS_DATA_MINING — Algorithm Settings: Random Forest
- 61.5.15 DBMS_DATA_MINING — Algorithm Constants and Settings: Singular Value Decomposition
- 61.5.16 DBMS_DATA_MINING — Algorithm Settings: Support Vector Machine
- 61.5.17 DBMS_DATA_MINING — Algorithm Settings: XGBoost
- 61.6 DBMS_DATA_MINING — Solver Settings
- 61.7 DBMS_DATA_MINING Datatypes
-
61.8
Summary of DBMS_DATA_MINING
Subprograms
- 61.8.1 ADD_COST_MATRIX Procedure
- 61.8.2 ADD_PARTITION Procedure
- 61.8.3 ALTER_REVERSE_EXPRESSION Procedure
- 61.8.4 APPLY Procedure
- 61.8.5 COMPUTE_CONFUSION_MATRIX Procedure
- 61.8.6 COMPUTE_CONFUSION_MATRIX_PART Procedure
- 61.8.7 COMPUTE_LIFT Procedure
- 61.8.8 COMPUTE_LIFT_PART Procedure
- 61.8.9 COMPUTE_ROC Procedure
- 61.8.10 COMPUTE_ROC_PART Procedure
- 61.8.11 CREATE_MODEL Procedure
- 61.8.12 CREATE_MODEL2 Procedure
- 61.8.13 Create Model Using Registration Information
- 61.8.14 DROP_ALGORITHM Procedure
- 61.8.15 DROP_PARTITION Procedure
- 61.8.16 DROP_MODEL Procedure
- 61.8.17 EXPORT_MODEL Procedure
- 61.8.18 EXPORT_SERMODEL Procedure
- 61.8.19 FETCH_JSON_SCHEMA Procedure
- 61.8.20 GET_ASSOCIATION_RULES Function
- 61.8.21 GET_FREQUENT_ITEMSETS Function
- 61.8.22 GET_MODEL_COST_MATRIX Function
- 61.8.23 GET_MODEL_DETAILS_AI Function
- 61.8.24 GET_MODEL_DETAILS_EM Function
- 61.8.25 GET_MODEL_DETAILS_EM_COMP Function
- 61.8.26 GET_MODEL_DETAILS_EM_PROJ Function
- 61.8.27 GET_MODEL_DETAILS_GLM Function
- 61.8.28 GET_MODEL_DETAILS_GLOBAL Function
- 61.8.29 GET_MODEL_DETAILS_KM Function
- 61.8.30 GET_MODEL_DETAILS_NB Function
- 61.8.31 GET_MODEL_DETAILS_NMF Function
- 61.8.32 GET_MODEL_DETAILS_OC Function
- 61.8.33 GET_MODEL_SETTINGS Function
- 61.8.34 GET_MODEL_SIGNATURE Function
- 61.8.35 GET_MODEL_DETAILS_SVD Function
- 61.8.36 GET_MODEL_DETAILS_SVM Function
- 61.8.37 GET_MODEL_DETAILS_XML Function
- 61.8.38 GET_MODEL_TRANSFORMATIONS Function
- 61.8.39 GET_TRANSFORM_LIST Procedure
- 61.8.40 IMPORT_MODEL Procedure
- 61.8.41 IMPORT_ONNX_MODEL Procedure
- 61.8.42 IMPORT_SERMODEL Procedure
- 61.8.43 JSON Schema for R Extensible Algorithm
- 61.8.44 REGISTER_ALGORITHM Procedure
- 61.8.45 RANK_APPLY Procedure
- 61.8.46 REMOVE_COST_MATRIX Procedure
- 61.8.47 RENAME_MODEL Procedure
-
62
DBMS_DATA_MINING_TRANSFORM
- 62.1 DBMS_DATA_MINING_TRANSFORM Overview
- 62.2 DBMS_DATA_MINING_TRANSFORM Operational Notes
- 62.3 DBMS_DATA_MINING_TRANSFORM Security Model
- 62.4 DBMS_DATA_MINING_TRANSFORM Datatypes
- 62.5 DBMS_DATA_MINING_TRANSFORM Constants
-
62.6
Summary of DBMS_DATA_MINING_TRANSFORM Subprograms
- 62.6.1 CREATE_BIN_CAT Procedure
- 62.6.2 CREATE_BIN_NUM Procedure
- 62.6.3 CREATE_CLIP Procedure
- 62.6.4 CREATE_COL_REM Procedure
- 62.6.5 CREATE_MISS_CAT Procedure
- 62.6.6 CREATE_MISS_NUM Procedure
- 62.6.7 CREATE_NORM_LIN Procedure
- 62.6.8 DESCRIBE_STACK Procedure
- 62.6.9 GET_EXPRESSION Function
- 62.6.10 INSERT_AUTOBIN_NUM_EQWIDTH Procedure
- 62.6.11 INSERT_BIN_CAT_FREQ Procedure
- 62.6.12 INSERT_BIN_NUM_EQWIDTH Procedure
- 62.6.13 INSERT_BIN_NUM_QTILE Procedure
- 62.6.14 INSERT_BIN_SUPER Procedure
- 62.6.15 INSERT_CLIP_TRIM_TAIL Procedure
- 62.6.16 INSERT_CLIP_WINSOR_TAIL Procedure
- 62.6.17 INSERT_MISS_CAT_MODE Procedure
- 62.6.18 INSERT_MISS_NUM_MEAN Procedure
- 62.6.19 INSERT_NORM_LIN_MINMAX Procedure
- 62.6.20 INSERT_NORM_LIN_SCALE Procedure
- 62.6.21 INSERT_NORM_LIN_ZSCORE Procedure
- 62.6.22 SET_EXPRESSION Procedure
- 62.6.23 SET_TRANSFORM Procedure
- 62.6.24 STACK_BIN_CAT Procedure
- 62.6.25 STACK_BIN_NUM Procedure
- 62.6.26 STACK_CLIP Procedure
- 62.6.27 STACK_COL_REM Procedure
- 62.6.28 STACK_MISS_CAT Procedure
- 62.6.29 STACK_MISS_NUM Procedure
- 62.6.30 STACK_NORM_LIN Procedure
- 62.6.31 XFORM_BIN_CAT Procedure
- 62.6.32 XFORM_BIN_NUM Procedure
- 62.6.33 XFORM_CLIP Procedure
- 62.6.34 XFORM_COL_REM Procedure
- 62.6.35 XFORM_EXPR_NUM Procedure
- 62.6.36 XFORM_EXPR_STR Procedure
- 62.6.37 XFORM_MISS_CAT Procedure
- 62.6.38 XFORM_MISS_NUM Procedure
- 62.6.39 XFORM_NORM_LIN Procedure
- 62.6.40 XFORM_STACK Procedure
-
63
DBMS_DATAPUMP
- 63.1 DBMS_DATAPUMP Overview
- 63.2 DBMS_DATAPUMP Security Model
- 63.3 DBMS_DATAPUMP Constants
- 63.4 DBMS_DATAPUMP Data Structures
-
63.5
Summary of DBMS_DATAPUMP Subprograms
- 63.5.1 ADD_FILE Procedure
- 63.5.2 ATTACH Function
- 63.5.3 DATA_FILTER Procedures
- 63.5.4 DATA_REMAP Procedure
- 63.5.5 DETACH Procedure
- 63.5.6 GET_DUMPFILE_INFO Procedure
- 63.5.7 GET_STATUS Procedure
- 63.5.8 LOG_ENTRY Procedure
- 63.5.9 METADATA_FILTER Procedure
- 63.5.10 METADATA_REMAP Procedure
- 63.5.11 METADATA_TRANSFORM Procedure
- 63.5.12 OPEN Function
- 63.5.13 SET_PARALLEL Procedure
- 63.5.14 SET_PARAMETER Procedures
- 63.5.15 START_JOB Procedure
- 63.5.16 STOP_JOB Procedure
- 63.5.17 WAIT_FOR_JOB Procedure
- 64 DBMS_DB_VERSION
- 65 DBMS_DBCOMP
-
66
DBMS_DBFS_CONTENT
- 66.1 DBMS_DBFS_CONTENT Overview
- 66.2 DBMS_DBFS_CONTENT Security Model
- 66.3 DBMS_DBFS_CONTENT Constants
- 66.4 Exceptions
- 66.5 DBMS_DBFS_CONTENT Operational Notes
-
66.6
DBMS_DBFS_CONTENT Data Structures
- 66.6.1 DBMS_DBFS_CONTENT FEATURE_T Record Type
- 66.6.2 DBMS_DBFS_CONTENT MOUNT_T Record Type
- 66.6.3 DBMS_DBFS_CONTENT PATH_ITEM_T Record Type
- 66.6.4 DBMS_DBFS_CONTENT PROP_ITEM_T Record Type
- 66.6.5 PROPERTY_T Record Type
- 66.6.6 DBMS_DBFS_CONTENT STORE_T Record Type
- 66.6.7 DBMS_DBFS_CONTENT FEATURES_T Table Type
- 66.6.8 MOUNTS_T Table Type
- 66.6.9 DBMS_DBFS_CONTENT PATH_ITEMS_T Table Type
- 66.6.10 DBMS_DBFS_CONTENT PROP_ITEMS_T Table Type
- 66.6.11 DBMS_DBFS_CONTENT PROPERTIES_T Table Type
- 66.6.12 STORES_T Table Type
-
66.7
Summary of DBMS_DBFS_CONTENT Subprograms
- 66.7.1 CHECKACCESS Function
- 66.7.2 CHECKSPI Functions and Procedures
- 66.7.3 CREATEDIRECTORY Procedures
- 66.7.4 CREATEFILE Procedures
- 66.7.5 CREATELINK Procedures
- 66.7.6 CREATEREFERENCE Procedures
- 66.7.7 DECODEFEATURES Function
- 66.7.8 DELETECONTENT Procedure
- 66.7.9 DELETEDIRECTORY Procedure
- 66.7.10 DELETEFILE Procedure
- 66.7.11 FEATURENAME Function
- 66.7.12 FLUSHSTATS Function
- 66.7.13 GETDEFAULTACL Procedure
- 66.7.14 GETDEFAULTASOF Procedure
- 66.7.15 GETDEFAULTCONTEXT Procedure
- 66.7.16 GETDEFAULTOWNER Procedure
- 66.7.17 GETDEFAULTPRINCIPAL Procedure
- 66.7.18 GETFEATURESBYMOUNT Function
- 66.7.19 GETFEATURESBYNAME Function
- 66.7.20 GETFEATURESBYPATH Function
- 66.7.21 GETPATH Procedures
- 66.7.22 GETPATHBYMOUNTID Function
- 66.7.23 GETPATHBYSTOREID Function
- 66.7.24 GETPATHNOWAIT Procedures
- 66.7.25 GETSTOREBYMOUNT Function
- 66.7.26 GETSTOREBYNAME Function
- 66.7.27 GETSTOREBYPATH Function
- 66.7.28 GETSTATS Procedure
- 66.7.29 GETTRACE Function
- 66.7.30 GETVERSION Function
- 66.7.31 ISPATHLOCKED Procedure
- 66.7.32 LIST Function
- 66.7.33 LISTALLPROPERTIES Function
- 66.7.34 LISTALLCONTENT Function
- 66.7.35 LISTMOUNTS Function
- 66.7.36 LISTSTORES Function
- 66.7.37 LOCKPATH Procedure
- 66.7.38 MOUNTSTORE Procedure
- 66.7.39 NORMALIZEPATH Functions
- 66.7.40 PROPANY Functions
- 66.7.41 PROPERTIESH2T Function
- 66.7.42 PROPERTIEST2H Function
- 66.7.43 PROPNUMBER Function
- 66.7.44 PROPRAW Function
- 66.7.45 PROPTIMESTAMP Function
- 66.7.46 PROPVARCHAR2 Function
- 66.7.47 PURGEALL Procedure
- 66.7.48 PURGEPATH Procedure
- 66.7.49 PUTPATH Procedures
- 66.7.50 REGISTERSTORE Procedure
- 66.7.51 RENAMEPATH Procedures
- 66.7.52 RESTOREALL Procedure
- 66.7.53 RESTOREPATH Procedure
- 66.7.54 SETDEFAULTACL Procedure
- 66.7.55 SETDEFAULTASOF Procedure
- 66.7.56 SETDEFAULTCONTEXT Procedure
- 66.7.57 SETDEFAULTOWNER Procedure
- 66.7.58 SETDEFAULTPRINCIPAL Procedure
- 66.7.59 SETPATH Procedures
- 66.7.60 SETSTATS Procedure
- 66.7.61 SETTRACE Procedure
- 66.7.62 SPACEUSAGE Procedure
- 66.7.63 TRACE Procedure
- 66.7.64 TRACEENABLED Function
- 66.7.65 UNLOCKPATH Procedure
- 66.7.66 UNMOUNTSTORE Procedure
- 66.7.67 UNREGISTERSTORE Procedure
-
67
DBMS_DBFS_CONTENT_SPI
- 67.1 ODBMS_DBFS_CONTENT_SPI Overview
- 67.2 DBMS_DBFS_CONTENT_SPI Security Model
- 67.3 DBMS_DBFS_CONTENT_SPI Operational Notes
-
67.4
Summary of DBMS_DBFS_CONTENT_SPI Subprograms
- 67.4.1 CHECKACCESS Function
- 67.4.2 CREATEDIRECTORY Procedure
- 67.4.3 CREATEFILE Procedure
- 67.4.4 CREATELINK Procedure
- 67.4.5 CREATEREFERENCE Procedure
- 67.4.6 DELETECONTENT Procedure
- 67.4.7 DELETEDIRECTORY Procedure
- 67.4.8 DELETEFILE Procedure
- 67.4.9 GETFEATURES Function
- 67.4.10 GETPATH Procedures
- 67.4.11 GETPATHBYSTOREID Function
- 67.4.12 GETPATHNOWAIT Procedure
- 67.4.13 GETSTOREID Function
- 67.4.14 GETVERSION Function
- 67.4.15 ISPATHLOCKED Procedure
- 67.4.16 LIST Function
- 67.4.17 LOCKPATH Procedure
- 67.4.18 PURGEALL Procedure
- 67.4.19 PURGEPATH Procedure
- 67.4.20 PUTPATH Procedures
- 67.4.21 RENAMEPATH Procedure
- 67.4.22 RESTOREALL Procedure
- 67.4.23 RESTOREPATH Procedure
- 67.4.24 SEARCH Function
- 67.4.25 SETPATH Procedure
- 67.4.26 SPACEUSAGE Procedure
- 67.4.27 UNLOCKPATH Procedure
-
68
DBMS_DBFS_HS
- 68.1 DBMS_DBFS_HS Overview
- 68.2 DBMS_DBFS_HS Security Model
- 68.3 DBMS_DBFS_HS Constants
- 68.4 DBMS_DBFS_HS Operational Notes
-
68.5
Summary of DBMS_DBFS_HS Subprograms
- 68.5.1 CLEANUPUNUSEDBACKUPFILES Procedure
- 68.5.2 CREATEBUCKET Procedure
- 68.5.3 CREATESTORE Procedure
- 68.5.4 DEREGSTORECOMMAND Function
- 68.5.5 DROPSTORE Procedure
- 68.5.6 FLUSHCACHE Procedure
- 68.5.7 GETSTOREPROPERTY Function
- 68.5.8 RECONFIGCACHE Procedure
- 68.5.9 REGISTERSTORECOMMAND Procedure
- 68.5.10 SENDCOMMAND Procedure
- 68.5.11 SETSTOREPROPERTY Procedure
- 68.5.12 STOREPUSH Procedure
- 69 DBMS_DBFS_SFS
- 70 DBMS_DDL
-
71
DBMS_DEBUG
- 71.1 DBMS_DEBUG Overview
- 71.2 DBMS_DEBUG Constants
- 71.3 DBMS_DEBUG Variables
- 71.4 DBMS_DEBUG Exceptions
- 71.5 DBMS_DEBUG Operational Notes
- 71.6 DBMS_DEBUG Data Structures
-
71.7
Summary of DBMS_DEBUG Subprograms
- 71.7.1 ATTACH_SESSION Procedure
- 71.7.2 CONTINUE Function
- 71.7.3 DEBUG_OFF Procedure
- 71.7.4 DEBUG_ON Procedure
- 71.7.5 DELETE_BREAKPOINT Function
- 71.7.6 DELETE_OER_BREAKPOINT Function
- 71.7.7 DETACH_SESSION Procedure
- 71.7.8 DISABLE_BREAKPOINT Function
- 71.7.9 ENABLE_BREAKPOINT Function
- 71.7.10 EXECUTE Procedure
- 71.7.11 GET_INDEXES Function
- 71.7.12 GET_MORE_SOURCE Procedure
- 71.7.13 GET_LINE_MAP Function
- 71.7.14 GET_RUNTIME_INFO Function
- 71.7.15 GET_TIMEOUT_BEHAVIOUR Function
- 71.7.16 GET_VALUE Function
- 71.7.17 INITIALIZE Function
- 71.7.18 PING Procedure
- 71.7.19 PRINT_BACKTRACE Procedure
- 71.7.20 PRINT_INSTANTIATIONS Procedure
- 71.7.21 PROBE_VERSION Procedure
- 71.7.22 SELF_CHECK Procedure
- 71.7.23 SET_BREAKPOINT Function
- 71.7.24 SET_OER_BREAKPOINT Function
- 71.7.25 SET_TIMEOUT Function
- 71.7.26 SET_TIMEOUT_BEHAVIOUR Procedure
- 71.7.27 SET_VALUE Function
- 71.7.28 SHOW_BREAKPOINTS Procedures
- 71.7.29 SHOW_FRAME_SOURCE Procedure
- 71.7.30 SHOW_SOURCE Procedures
- 71.7.31 SYNCHRONIZE Function
- 71.7.32 TARGET_PROGRAM_RUNNING Procedure
- 72 DBMS_DEBUG_JDWP
- 73 DBMS_DEBUG_JDWP_CUSTOM
- 74 DBMS_DESCRIBE
- 75 DBMS_DEVELOPER
- 76 DBMS_DG
- 77 DBMS_DICTIONARY_CHECK
- 78 DBMS_DIMENSION
- 79 DBMS_DISTRIBUTED_TRUST_ADMIN
- 80 DBMS_DNFS
-
81
DBMS_DST
- 81.1 DBMS_DST Overview
- 81.2 DBMS_DST Security Model
- 81.3 DBMS_DST Views
-
81.4
Summary of DBMS_DST Subprograms
- 81.4.1 BEGIN_PREPARE Procedure
- 81.4.2 BEGIN_UPGRADE Procedure
- 81.4.3 CREATE_AFFECTED_TABLE Procedure
- 81.4.4 CREATE_ERROR_TABLE Procedure
- 81.4.5 CREATE_TRIGGER_TABLE Procedure
- 81.4.6 END_PREPARE Procedure
- 81.4.7 END_UPGRADE Procedure
- 81.4.8 FIND_AFFECTED_TABLES Procedure
- 81.4.9 UPGRADE_DATABASE Procedure
- 81.4.10 UPGRADE_SCHEMA Procedure
- 81.4.11 UPGRADE_TABLE Procedure
- 82 DBMS_EDITIONS_UTILITIES
-
83
DBMS_EPG
- 83.1 DBMS_EPG Overview
- 83.2 DBMS_EPG Security Model
- 83.3 DBMS_EPG Exceptions
- 83.4 DBMS_EPG Data Structures
- 83.5 DBMS_EPG Subprogram Groups
-
83.6
Summary of DBMS_EPG Subprograms
- 83.6.1 AUTHORIZE_DAD Procedure
- 83.6.2 CREATE_DAD Procedure
- 83.6.3 DEAUTHORIZE_DAD Procedure
- 83.6.4 DELETE_DAD_ATTRIBUTE Procedure
- 83.6.5 DELETE_GLOBAL_ATTRIBUTE Procedure
- 83.6.6 DROP_DAD Procedure
- 83.6.7 GET_ALL_DAD_ATTRIBUTES Procedure
- 83.6.8 GET_ALL_DAD_MAPPINGS Procedure
- 83.6.9 GET_ALL_GLOBAL_ATTRIBUTES Procedure
- 83.6.10 GET_DAD_ATTRIBUTE Function
- 83.6.11 GET_DAD_LIST Procedure
- 83.6.12 GET_GLOBAL_ATTRIBUTE Function
- 83.6.13 MAP_DAD Procedure
- 83.6.14 SET_DAD_ATTRIBUTE Procedure
- 83.6.15 SET_GLOBAL_ATTRIBUTE Procedure
- 83.6.16 UNMAP_DAD Procedure
- 84 DBMS_ERRLOG
- 85 DBMS_FGA
- 86 DBMS_FILE_TRANSFER
- 87 DBMS_FLASHBACK
-
88
DBMS_FLASHBACK_ARCHIVE
- 88.1 DBMS_FLASHBACK_ARCHIVE Overview
- 88.2 DBMS_FLASHBACK_ARCHIVE Security Model
- 88.3 DBMS_FLASHBACK_ARCHIVE Constants
-
88.4
Summary of DBMS_FLASHBACK_ARCHIVE Subprograms
- 88.4.1 ADD_TABLE_TO_APPLICATION Procedure
- 88.4.2 CREATE_TEMP_HISTORY_TABLE Procedure
- 88.4.3 DISABLE_APPLICATION Procedure
- 88.4.4 DISABLE_ASOF_VALID_TIME Procedure
- 88.4.5 DISASSOCIATE_FBA Procedure
- 88.4.6 DROP_APPLICATION Procedure
- 88.4.7 ENABLE_APPLICATION Procedure
- 88.4.8 ENABLE_AT_VALID_TIME Procedure
- 88.4.9 EXTEND_MAPPINGS Procedure
- 88.4.10 GET_CURRENT_LIFESPAN_DIGEST Function
- 88.4.11 GET_SYS_CONTEXT Function
- 88.4.12 IMPORT_HISTORY Procedure
- 88.4.13 LOCK_DOWN_APPLICATION Procedure
- 88.4.14 PURGE_CONTEXT Procedure
- 88.4.15 REASSOCIATE_FBA Procedure
- 88.4.16 REGISTER_APPLICATION Procedure
- 88.4.17 REMOVE_TABLE_FROM_APPLICATION Procedure
- 88.4.18 SET_CONTEXT_LEVEL Procedure
- 88.4.19 VERIFY_BLOCKCHAIN_LIFESPAN Procedure
- 89 DBMS_FLASHBACK_ARCHIVE_MIGRATE
- 90 DBMS_FREQUENT_ITEMSET
- 91 DBMS_FS
-
92
DBMS_GOLDENGATE_ADM
- 92.1 Using DBMS_GOLDENGATE_ADM
-
92.2
Summary of DBMS_GOLDENGATE_ADM Subprograms
- 92.2.1 ADD_AUTO_CDR Procedure
- 92.2.2 ADD_AUTO_CDR_COLUMN_GROUP Procedure
- 92.2.3 ADD_AUTO_CDR_DELTA_RES Procedure
- 92.2.4 ALTER_AUTO_CDR Procedure
- 92.2.5 ALTER_AUTO_CDR_COLUMN_GROUP Procedure
- 92.2.6 DELETE_PROCREP_EXCLUSION_OBJ Procedure
- 92.2.7 GG_PROCEDURE_REPLICATION_ON Function
- 92.2.8 INSERT_PROCREP_EXCLUSION_OBJ Procedure
- 92.2.9 PURGE_TOMBSTONES Procedure
- 92.2.10 REMOVE_AUTO_CDR Procedure
- 92.2.11 REMOVE_AUTO_CDR_COLUMN_GROUP Procedure
- 92.2.12 REMOVE_AUTO_CDR_DELTA_RES Procedure
- 93 DBMS_GOLDENGATE_AUTH
- 94 DBMS_HADOOP
- 95 DBMS_HEAT_MAP
-
96
DBMS_HIERARCHY
- 96.1 DBMS_HIERARCHY Overview
- 96.2 DBMS_HIERARCHY Security Model
-
96.3
Summary of DBMS_HIERARCHY Subprograms
- 96.3.1 CREATE_VALIDATE_LOG_TABLE Procedure
- 96.3.2 CREATE_VIEW_FOR_FACT_ROWS Procedure
- 96.3.3 CREATE_VIEW_FOR_STAR_ROWS Procedure
- 96.3.4 GET_MV_SQL_FOR_AV_CACHE Function
- 96.3.5 GET_MV_SQL_FOR_STAR_CACHE Function
- 96.3.6 UPGRADE_VALIDATE_LOG_TABLE Procedure
- 96.3.7 VALIDATE_ANALYTIC_VIEW Function
- 96.3.8 VALIDATE_CHECK_SUCCESS Function
- 96.3.9 VALIDATE_HIERARCHY Function
- 97 DBMS_HM
- 98 DBMS_HPROF
- 99 DBMS_HS_PARALLEL
-
100
DBMS_HS_PASSTHROUGH
- 100.1 DBMS_HS_PASSTHROUGH Overview
- 100.2 DBMS_HS_PASSTHROUGH Operational Notes
-
100.3
Summary of DBMS_HS_PASSTHROUGH Subprograms
- 100.3.1 BIND_INOUT_VARIABLE Procedure
- 100.3.2 BIND_INOUT_VARIABLE_RAW Procedure
- 100.3.3 BIND_OUT_VARIABLE Procedure
- 100.3.4 BIND_OUT_VARIABLE_RAW Procedure
- 100.3.5 BIND_VARIABLE Procedure
- 100.3.6 BIND_VARIABLE_RAW Procedure
- 100.3.7 CLOSE_CURSOR Procedure
- 100.3.8 EXECUTE_IMMEDIATE Procedure
- 100.3.9 EXECUTE_NON_QUERY Function
- 100.3.10 FETCH_ROW Function
- 100.3.11 GET_VALUE Procedure
- 100.3.12 GET_VALUE_RAW Procedure
- 100.3.13 OPEN_CURSOR Function
- 100.3.14 PARSE Procedure
- 101 DBMS_HYBRID_VECTOR
- 102 DBMS_ILM
-
103
DBMS_ILM_ADMIN
- 103.1 DBMS_ILM_ADMIN Overview
- 103.2 DBMS_ILM_ADMIN Security Model
- 103.3 DBMS_ILM_ADMIN Constants
-
103.4
Summary of DBMS_ILM_ADMIN Subprograms
- 103.4.1 CLEAR_HEAT_MAP_ALL Procedure
- 103.4.2 CLEAR_HEAT_MAP_TABLE Procedure
- 103.4.3 CUSTOMIZE_ILM Procedure
- 103.4.4 DISABLE_AUTO_OPTIMIZE Procedure
- 103.4.5 DISABLE_ILM Procedure
- 103.4.6 ENABLE_AUTO_OPTIMIZE Procedure
- 103.4.7 ENABLE_ILM Procedure
- 103.4.8 IGNORE_AUTO_OPTIMIZE_CRITERIA Procedure
- 103.4.9 SET_HEAT_MAP_ALL Procedure
- 103.4.10 SET_HEAT_MAP_START Procedure
- 103.4.11 SET_HEAT_MAP_TABLE Procedure
- 104 DBMS_IMMUTABLE_TABLE
- 105 DBMS_INMEMORY
-
106
DBMS_INMEMORY_ADMIN
- 106.1 DBMS_INMEMORY_ADMIN Overview
- 106.2 DBMS_INMEMORY_ADMIN Security Model
- 106.3 DBMS_INMEMORY_ADMIN Operational Notes
-
106.4
Summary of DBMS_INMEMORY_ADMIN Subprograms
- 106.4.1 AIM_GET_PARAMETER Procedure
- 106.4.2 AIM_SET_PARAMETER Procedure
- 106.4.3 FASTSTART_DISABLE Procedure
- 106.4.4 FASTSTART_ENABLE Procedure
- 106.4.5 FASTSTART_MIGRATE_STORAGE Procedure
- 106.4.6 GET_FASTSTART_TABLESPACE Function
- 106.4.7 IME_CAPTURE_EXPRESSIONS Procedure
- 106.4.8 IME_CLOSE_CAPTURE_WINDOW Procedure
- 106.4.9 IME_DROP_ALL_EXPRESSIONS Procedure
- 106.4.10 IME_GET_CAPTURE_STATE Procedure
- 106.4.11 IME_OPEN_CAPTURE_WINDOW Procedure
- 106.4.12 IME_POPULATE_EXPRESSIONS Procedure
- 106.4.13 POPULATE_WAIT Function
- 107 DBMS_INMEMORY_ADVISE
- 108 DBMS_IOT
- 109 DBMS_JAVA
- 110 DBMS_JOB
-
111
DBMS_JSON_DUALITY
- 111.1 DBMS_JSON_DUALITY Overview
- 111.2 DBMS_JSON_DUALITY Security
-
111.3
Summary of DBMS_JSON_Duality
Subprograms
- 111.3.1 INFER_SCHEMA Function
- 111.3.2 GENERATE_SCHEMA Function
- 111.3.3 INFER_AND_GENERATE_SCHEMA Function
- 111.3.4 VALIDATE_SCHEMA_REPORT Function
- 111.3.5 IMPORT Procedure
- 111.3.6 IMPORT_ALL Procedure
- 111.3.7 VALIDATE_IMPORT_REPORT Function
- 111.3.8 BEGIN_TRANSACTION Procedure
- 111.3.9 COMMIT_TRANSACTION Procedure
- 111.3.10 REGISTER Procedure
- 112 DBMS_JSON
- 113 DBMS_JSON_SCHEMA
- 114 DBMS_KAFKA
- 115 DBMS_KAFKA_ADM
- 116 DBMS_LDAP
- 117 DBMS_LDAP_UTL
- 118 DBMS_LIBCACHE
-
119
DBMS_LOB
- 119.1 DBMS_LOB Overview
- 119.2 DBMS_LOB Security Model
- 119.3 DBMS_LOB Constants
- 119.4 DBMS_LOB Datatypes
- 119.5 DBMS_LOB Operational Notes
- 119.6 DBMS_LOB Rules and Limits
- 119.7 DBMS_LOB Exceptions
-
119.8
Summary of DBMS_LOB Subprograms
- 119.8.1 APPEND Procedures
- 119.8.2 CLOB2FILE Procedure
- 119.8.3 CLOSE Procedure
- 119.8.4 COMPARE Functions
- 119.8.5 CONVERTTOBLOB Procedure
- 119.8.6 CONVERTTOCLOB Procedure
- 119.8.7 COPY Procedures
- 119.8.8 COPY_DBFS_LINK Procedures
- 119.8.9 COPY_FROM_DBFS_LINK
- 119.8.10 CREATETEMPORARY Procedures
- 119.8.11 DBFS_LINK_GENERATE_PATH Functions
- 119.8.12 ERASE Procedures
- 119.8.13 FILECLOSE Procedure
- 119.8.14 FILECLOSEALL Procedure
- 119.8.15 FILEEXISTS Function
- 119.8.16 FILEGETNAME Procedure
- 119.8.17 FILEISOPEN Function
- 119.8.18 FILEOPEN Procedure
- 119.8.19 FRAGMENT_DELETE Procedure
- 119.8.20 FRAGMENT_INSERT Procedures
- 119.8.21 FRAGMENT_MOVE Procedure
- 119.8.22 FRAGMENT_REPLACE Procedures
- 119.8.23 FREETEMPORARY Procedures
- 119.8.24 GET_DBFS_LINK Functions
- 119.8.25 GET_DBFS_LINK_STATE Procedures
- 119.8.26 GET_LOB_DEDUPLICATION_RATIO Function
- 119.8.27 GETCONTENTTYPE Functions
- 119.8.28 GET_STORAGE_LIMIT Function
- 119.8.29 GETCHUNKSIZE Functions
- 119.8.30 GETLENGTH Functions
- 119.8.31 GETOPTIONS Functions
- 119.8.32 INSTR Functions
- 119.8.33 ISOPEN Functions
- 119.8.34 ISREMOTE Function
- 119.8.35 ISSECUREFILE Function
- 119.8.36 ISTEMPORARY Functions
- 119.8.37 LOADBLOBFROMFILE Procedure
- 119.8.38 LOADCLOBFROMFILE Procedure
- 119.8.39 MOVE_TO_DBFS_LINK Procedures
- 119.8.40 OPEN Procedures
- 119.8.41 READ Procedures
- 119.8.42 SET_DBFS_LINK Procedures
- 119.8.43 SETCONTENTTYPE Procedure
- 119.8.44 SETOPTIONS Procedures
- 119.8.45 SUBSTR Functions
- 119.8.46 TRIM Procedures
- 119.8.47 WRITE Procedures
- 119.8.48 WRITEAPPEND Procedures
- 120 DBMS_LOCK
- 121 DBMS_LOGMNR
-
122
DBMS_LOGSTDBY
- 122.1 DBMS_LOGSTDBY Overview
- 122.2 DBMS_LOGSTDBY Security Model
- 122.3 DBMS_LOGSTDBY Constants
-
122.4
Summary of DBMS_LOGSTDBY Subprograms
- 122.4.1 APPLY_SET Procedure
- 122.4.2 APPLY_UNSET Procedure
- 122.4.3 BUILD Procedure
- 122.4.4 INSTANTIATE_TABLE Procedure
- 122.4.5 IS_APPLY_SERVER Function
- 122.4.6 MAP_PRIMARY_SCN Function
- 122.4.7 PREPARE_FOR_NEW_PRIMARY Procedure
- 122.4.8 PURGE_SESSION Procedure
- 122.4.9 REBUILD Procedure
- 122.4.10 SET_TABLESPACE Procedure
- 122.4.11 SKIP Procedure
- 122.4.12 SKIP_ERROR Procedure
- 122.4.13 SKIP_TRANSACTION Procedure
- 122.4.14 UNSKIP Procedure
- 122.4.15 UNSKIP_ERROR Procedure
- 122.4.16 UNSKIP_TRANSACTION Procedure
- 123 DBMS_LOGMNR_D
- 124 DBMS_LOGSTDBY_CONTEXT
- 125 DBMS_MEMOPTIMIZE
- 126 DBMS_MEMOPTIMIZE_ADMIN
-
127
DBMS_METADATA
- 127.1 DBMS_METADATA Overview
- 127.2 DBMS_METADATA Security Model
- 127.3 Rules and Limits
- 127.4 DBMS_METADATA Data Structures - Object and Table Types
- 127.5 DBMS_METADATA Subprogram Groupings
-
127.6
Summary of All DBMS_METADATA Subprograms
- 127.6.1 ADD_TRANSFORM Function
- 127.6.2 CLOSE Procedure
- 127.6.3 CONVERT Functions and Procedures
- 127.6.4 FETCH_xxx Functions and Procedures
- 127.6.5 GET_xxx Functions
- 127.6.6 GET_QUERY Function
- 127.6.7 OPEN Function
- 127.6.8 OPENW Function
- 127.6.9 PUT Function
- 127.6.10 SET_COUNT Procedure
- 127.6.11 SET_FILTER Procedure
- 127.6.12 SET_PARSE_ITEM Procedure
- 127.6.13 SET_TRANSFORM_PARAM and SET_REMAP_PARAM Procedures
- 128 DBMS_METADATA_DIFF
-
129
DBMS_MGD_ID_UTL
- 129.1 DBMS_MGD_ID_UTL Security Model
- 129.2 DBMS_MGD_ID_UTL Constants
- 129.3 DBMS_MGD_ID_UTL Exceptions
-
129.4
Summary of DBMS_MGD_ID_UTL Subprograms
- 129.4.1 ADD_SCHEME Procedure
- 129.4.2 CREATE_CATEGORY Function
- 129.4.3 EPC_TO_ORACLE_SCHEME Function
- 129.4.4 GET_CATEGORY_ID Function
- 129.4.5 GET_COMPONENTS Function
- 129.4.6 GET_ENCODINGS Function
- 129.4.7 GET_JAVA_LOGGING_LEVEL Function
- 129.4.8 GET_PLSQL_LOGGING_LEVEL Function
- 129.4.9 GET_SCHEME_NAMES Function
- 129.4.10 GET_TDT_XML Function
- 129.4.11 GET_VALIDATOR Function
- 129.4.12 REFRESH_CATEGORY Function
- 129.4.13 REMOVE_CATEGORY Procedure
- 129.4.14 REMOVE_PROXY Procedure
- 129.4.15 REMOVE_SCHEME Procedure
- 129.4.16 SET_JAVA_LOGGING_LEVEL Procedure
- 129.4.17 SET_PLSQL_LOGGING_LEVEL Procedure
- 129.4.18 SET_PROXY Procedure
- 129.4.19 VALIDATE_SCHEME Function
-
130
DBMS_MGWADM
- 130.1 DBMS_MGWADM Security Model
- 130.2 DBMS_MGWADM Deprecated Subprograms
- 130.3 DBMS_MGWADM Constants
- 130.4 DBMS_MGWADM Data Structures
-
130.5
Summary of DBMS_MGWADM Subprograms
- 130.5.1 ADD_SUBSCRIBER Procedure
- 130.5.2 ALTER_AGENT Procedures
- 130.5.3 ALTER_JOB Procedure
- 130.5.4 ALTER_MSGSYSTEM_LINK Procedure for TIB/Rendezvous
- 130.5.5 ALTER_MSGSYSTEM_LINK Procedure for WebSphere MQ
- 130.5.6 ALTER_PROPAGATION_SCHEDULE Procedure
- 130.5.7 ALTER_SUBSCRIBER Procedure
- 130.5.8 CLEANUP_GATEWAY Procedures
- 130.5.9 CREATE_AGENT Procedure
- 130.5.10 CREATE_JOB Procedure
- 130.5.11 CREATE_MSGSYSTEM_LINK Procedures for TIB/Rendezvous
- 130.5.12 CREATE_MSGSYSTEM_LINK Procedures for WebSphere MQ
- 130.5.13 DB_CONNECT_INFO Procedure
- 130.5.14 DISABLE_JOB Procedure
- 130.5.15 DISABLE_PROPAGATION_SCHEDULE Procedure
- 130.5.16 ENABLE_JOB Procedure
- 130.5.17 ENABLE_PROPAGATION_SCHEDULE Procedure
- 130.5.18 REGISTER_FOREIGN_QUEUE Procedure
- 130.5.19 REMOVE_AGENT Procedure
- 130.5.20 REMOVE_JOB Procedure
- 130.5.21 REMOVE_MSGSYSTEM_LINK Procedure
- 130.5.22 REMOVE_OPTION Procedure
- 130.5.23 REMOVE_SUBSCRIBER Procedure
- 130.5.24 RESET_JOB Procedure
- 130.5.25 RESET_SUBSCRIBER Procedure
- 130.5.26 SCHEDULE_PROPAGATION Procedure
- 130.5.27 SET_LOG_LEVEL Procedures
- 130.5.28 SET_OPTION Procedure
- 130.5.29 SHUTDOWN Procedures
- 130.5.30 STARTUP Procedures
- 130.5.31 UNREGISTER_FOREIGN_QUEUE Procedure
- 130.5.32 UNSCHEDULE_PROPAGATION Procedure
-
131
DBMS_MGWMSG
- 131.1 DBMS_MGWMSG Security Model
- 131.2 DBMS_MGWMSG Constants
-
131.3
DBMS_MGWMSG Types
- 131.3.1 DBMS_MGWMSG SYS.MGW_NAME_VALUE_T Type
- 131.3.2 DBMS_MGWMSG SYS.MGW_NAME_TYPE_ARRAY_T Type
- 131.3.3 DBMS_MGWMSG SYS.MGW_TEXT_VALUE_T Type
- 131.3.4 DBMS_MGWMSG SYS.MGW_RAW_VALUE_T Type
- 131.3.5 DBMS_MGWMSG SYS.MGW_BASIC_MSG_T Type
- 131.3.6 DBMS_MGWMSG SYS.MGW_NUMBER_ARRAY_T Type
- 131.3.7 DBMS_MGWMSG SYS.MGW_TIBRV_FIELD_T Type
- 131.3.8 DBMS_MGWMSG SYS.MGW_TIBRV_MSG_T Type
-
131.4
Summary of DBMS_MGWMSG Subprograms
- 131.4.1 LCR_TO_XML Function
- 131.4.2 NVARRAY_ADD Procedure
- 131.4.3 NVARRAY_FIND_NAME Function
- 131.4.4 NVARRAY_FIND_NAME_TYPE Function
- 131.4.5 NVARRAY_GET Function
- 131.4.6 NVARRAY_GET_BOOLEAN Function
- 131.4.7 NVARRAY_GET_BYTE Function
- 131.4.8 NVARRAY_GET_DATE Function
- 131.4.9 NVARRAY_GET_DOUBLE Function
- 131.4.10 NVARRAY_GET_FLOAT Function
- 131.4.11 NVARRAY_GET_INTEGER Function
- 131.4.12 NVARRAY_GET_LONG Function
- 131.4.13 NVARRAY_GET_RAW Function
- 131.4.14 NVARRAY_GET_SHORT Function
- 131.4.15 NVARRAY_GET_TEXT Function
- 131.4.16 XML_TO_LCR Function
-
132
DBMS_MLE
- 132.1 DBMS_MLE Overview
- 132.2 DBMS_MLE Security Model
-
132.3
Summary of DBMS_MLE Subprograms
- 132.3.1 CREATE_CONTEXT Function
- 132.3.2 DISABLE_CTX_STDERR Procedure
- 132.3.3 DISABLE_CTX_STDOUT Procedure
- 132.3.4 DISABLE_DEBUGGING Procedure
- 132.3.5 DISABLE_ICS_STDERR Procedure
- 132.3.6 DISABLE_ICS_STDOUT Procedure
- 132.3.7 DISABLE_STDERR Procedure
- 132.3.8 DISABLE_STDOUT Procedure
- 132.3.9 DROP_CONTEXT Procedure
- 132.3.10 ENABLE_DEBUGGING Procedure
- 132.3.11 EVAL Procedure
- 132.3.12 EXPORT_TO_MLE Procedure
- 132.3.13 GET_AVAILABLE_LANGUAGES Function
- 132.3.14 GET_CTX_ERROR_STACK Function
- 132.3.15 GET_ERROR_STACK Function
- 132.3.16 IMPORT_FROM_MLE Procedure
- 132.3.17 PARSE_DEBUG_OUTPUT Function
- 132.3.18 SET_CTX_STDERR Procedure
- 132.3.19 SET_CTX_STDERR_TO_DBMS_OUTPUT Procedure
- 132.3.20 SET_CTX_STDOUT Procedure
- 132.3.21 SET_CTX_STDOUT_TO_DBMS_OUTPUT Procedure
- 132.3.22 SET_ICS_STDERR Procedure
- 132.3.23 SET_ICS_STDERR_TO_DBMS_OUTPUT Procedure
- 132.3.24 SET_ICS_STDOUT Procedure
- 132.3.25 SET_ICS_STDOUT_TO_DBMS_OUTPUT Procedure
- 132.3.26 SET_STDERR Procedure
- 132.3.27 SET_STDERR_TO_DBMS_OUTPUT Procedure
- 132.3.28 SET_STDOUT Procedure
- 132.3.29 SET_STDOUT_TO_DBMS_OUTPUT Procedure
-
133
DBMS_MONITOR
-
133.1
Summary of DBMS_MONITOR Subprograms
- 133.1.1 CLIENT_ID_STAT_DISABLE Procedure
- 133.1.2 CLIENT_ID_STAT_ENABLE Procedure
- 133.1.3 CLIENT_ID_TRACE_DISABLE Procedure
- 133.1.4 CLIENT_ID_TRACE_ENABLE Procedure
- 133.1.5 DATABASE_TRACE_DISABLE Procedure
- 133.1.6 DATABASE_TRACE_ENABLE Procedure
- 133.1.7 SERV_MOD_ACT_STAT_DISABLE Procedure
- 133.1.8 SERV_MOD_ACT_STAT_ENABLE Procedure
- 133.1.9 SERV_MOD_ACT_TRACE_DISABLE Procedure
- 133.1.10 SERV_MOD_ACT_TRACE_ENABLE Procedure
- 133.1.11 SESSION_TRACE_DISABLE Procedure
- 133.1.12 SESSION_TRACE_ENABLE Procedure
-
133.1
Summary of DBMS_MONITOR Subprograms
-
134
DBMS_MVIEW
- 134.1 DBMS_MVIEW Operational Notes
- 134.2 DBMS_MVIEW Security Model
- 134.3 DBMS_MVIEW Rules and Limits
-
134.4
Summary of DBMS_MVIEW Subprograms
- 134.4.1 BEGIN_TABLE_REORGANIZATION Procedure
- 134.4.2 END_TABLE_REORGANIZATION Procedure
- 134.4.3 ESTIMATE_MVIEW_SIZE Procedure
- 134.4.4 EXPLAIN_MVIEW Procedure
- 134.4.5 EXPLAIN_REWRITE Procedure
- 134.4.6 I_AM_A_REFRESH Function
- 134.4.7 PMARKER Function
- 134.4.8 PURGE_DIRECT_LOAD_LOG Procedure
- 134.4.9 PURGE_LOG Procedure
- 134.4.10 PURGE_MVIEW_FROM_LOG Procedure
- 134.4.11 REFRESH Procedures
- 134.4.12 REFRESH_ALL_MVIEWS Procedure
- 134.4.13 REFRESH_DEPENDENT Procedures
- 134.4.14 REGISTER_MVIEW Procedure
- 134.4.15 UNREGISTER_MVIEW Procedure
- 135 DBMS_MVIEW_STATS
-
136
DBMS_NETWORK_ACL_ADMIN
- 136.1 DBMS_NETWORK_ACL_ADMIN Overview
- 136.2 DBMS_NETWORK_ACL_ADMIN Deprecated Subprograms
- 136.3 DBMS_NETWORK_ACL_ADMIN Security Model
- 136.4 DBMS_NETWORK_ACL_ADMIN Constants
- 136.5 DBMS_NETWORK_ACL_ADMIN Exceptions
- 136.6 DBMS_NETWORK_ACL_ADMIN Examples
-
136.7
Summary of DBMS_NETWORK_ACL_ADMIN Subprograms
- 136.7.1 ADD_PRIVILEGE Procedure
- 136.7.2 APPEND_HOST_ACE Procedure
- 136.7.3 APPEND_HOST_ACL Procedure
- 136.7.4 APPEND_WALLET_ACE Procedure
- 136.7.5 APPEND_WALLET_ACL Procedure
- 136.7.6 ASSIGN_ACL Procedure
- 136.7.7 ASSIGN_WALLET_ACL Procedure
- 136.7.8 CHECK_PRIVILEGE Function
- 136.7.9 CHECK_PRIVILEGE_ACLID Function
- 136.7.10 CREATE_ACL Procedure
- 136.7.11 DELETE_PRIVILEGE Procedure
- 136.7.12 DROP_ACL Procedure
- 136.7.13 REMOVE_HOST_ACE Procedure
- 136.7.14 REMOVE_WALLET_ACE Procedure
- 136.7.15 SET_HOST_ACL Procedure
- 136.7.16 SET_WALLET_ACL Procedure
- 136.7.17 UNASSIGN_ACL Procedure
- 136.7.18 UNASSIGN_WALLET_ACL Procedure
- 137 DBMS_NETWORK_ACL_UTILITY
- 138 DBMS_ODCI
- 139 DBMS_OPTIM_BUNDLE
- 140 DBMS_OUTLN
- 141 DBMS_OUTPUT
-
142
DBMS_PARALLEL_EXECUTE
- 142.1 DBMS_PARALLEL_EXECUTE Overview
- 142.2 DBMS_PARALLEL_EXECUTE Security Model
- 142.3 DBMS_PARALLEL_EXECUTE Constants
- 142.4 DBMS_PARALLEL_EXECUTE Views
- 142.5 DBMS_PARALLEL_EXECUTE Exceptions
- 142.6 DBMS_PARALLEL_EXECUTE Examples
-
142.7
Summary of DBMS_PARALLEL_EXECUTE Subprograms
- 142.7.1 ADM_DROP_CHUNKS Procedure
- 142.7.2 ADM_DROP_TASK Procedure
- 142.7.3 ADM_TASK_STATUS Function
- 142.7.4 ADM_STOP_TASK Procedure
- 142.7.5 CREATE_TASK Procedure
- 142.7.6 CREATE_CHUNKS_BY_NUMBER_COL Procedure
- 142.7.7 CREATE_CHUNKS_BY_ROWID Procedure
- 142.7.8 CREATE_CHUNKS_BY_SQL Procedure
- 142.7.9 DROP_TASK Procedure
- 142.7.10 DROP_CHUNKS Procedure
- 142.7.11 GENERATE_TASK_NAME Function
- 142.7.12 GET_NUMBER_COL_CHUNK Procedure
- 142.7.13 GET_ROWID_CHUNK Procedure
- 142.7.14 PURGE_PROCESSED_CHUNKS Procedure
- 142.7.15 RESUME_TASK Procedures
- 142.7.16 RUN_TASK Procedure
- 142.7.17 SET_CHUNK_STATUS Procedure
- 142.7.18 STOP_TASK Procedure
- 142.7.19 TASK_STATUS Procedure
- 143 DBMS_PART
- 144 DBMS_PCLXUTIL
-
145
DBMS_PDB
- 145.1 DBMS_PDB Overview
- 145.2 DBMS_PDB Security Model
-
145.3
Summary of DBMS_PDB Subprograms
- 145.3.1 CHECK_PLUG_COMPATIBILITY Function
- 145.3.2 DESCRIBE Procedure
- 145.3.3 EXPORTRMANBACKUP Procedure
- 145.3.4 RECOVER Procedure
- 145.3.5 REMOVE_LINK Procedure
- 145.3.6 SET_DATA_LINKED Procedure
- 145.3.7 SET_EXT_DATA_LINKED Procedure
- 145.3.8 SET_METADATA_LINKED Procedure
- 145.3.9 SET_PROFILE_EXPLICIT Procedure
- 145.3.10 SET_ROLE_EXPLICIT Procedure
- 145.3.11 SET_USER_EXPLICIT Procedure
- 146 DBMS_PDB_ALTER_SHARING
- 147 DBMS_PERF
-
148
DBMS_PIPE
- 148.1 DBMS_PIPE Overview
- 148.2 DBMS_PIPE Security Model
- 148.3 DBMS_PIPE Constants
- 148.4 DBMS_PIPE Operational Notes
- 148.5 DBMS_PIPE Exceptions
- 148.6 DBMS_PIPE Examples
-
148.7
Summary of DBMS_PIPE Subprograms
- 148.7.1 CREATE_PIPE Function
- 148.7.2 GET_CREDENTIAL_NAME Function
- 148.7.3 GET_LOCATION_URI Function
- 148.7.4 NEXT_ITEM_TYPE Function
- 148.7.5 PACK_MESSAGE Procedures
- 148.7.6 PURGE Procedure
- 148.7.7 RECEIVE_MESSAGE Function
- 148.7.8 RESET_BUFFER Procedure
- 148.7.9 REMOVE_PIPE Function
- 148.7.10 SEND_MESSAGE Function
- 148.7.11 SET_CREDENTIAL_NAME Procedure
- 148.7.12 SET_LOCATION_URI Procedure
- 148.7.13 UNIQUE_SESSION_NAME Function
- 148.7.14 UNPACK_MESSAGE Procedures
- 149 DBMS_PLSQL_CODE_COVERAGE
- 150 DBMS_PREDICTIVE_ANALYTICS
- 151 DBMS_PREPROCESSOR
- 152 DBMS_PRIVILEGE_CAPTURE
- 153 DBMS_PROCESS
- 154 DBMS_PROFILER
- 155 DBMS_PROPAGATION_ADM
-
156
DBMS_QOPATCH
- 156.1 DBMS_QOPATCH Overview
- 156.2 DBMS_QOPATCH Security Model
- 156.3 DBMS_QOPATCH Operational Notes
- 156.4 DBMS_QOPATCH Exceptions
-
156.5
Summary of DBMS_QOPATCH Subprograms
- 156.5.1 CHECK_PATCH_INSTALLED Function
- 156.5.2 GET_OPATCH_BUGS Function
- 156.5.3 GET_OPATCH_COUNT Function
- 156.5.4 GET_OPATCH_DATA Function
- 156.5.5 GET_OPATCH_FILES Function
- 156.5.6 GET_OPATCH_INSTALL_INFO Function
- 156.5.7 GET_OPATCH_LIST Function
- 156.5.8 GET_OPATCH_LSINVENTORY
- 156.5.9 GET_OPATCH_OLAYS Function
- 156.5.10 GET_OPATCH_PREQS Function
- 156.5.11 GET_OPATCH_XSLT
- 156.5.12 GET_PATCH_DETAILS Function
- 156.5.13 GET_SQLPATCH_STATUS Procedure
- 156.5.14 IS_PATCH_INSTALLED Function
- 156.5.15 OPATCH_COMPARE_CURRENT Function
- 156.5.16 OPATCH_COMPARE_NODES Function
- 156.5.17 SET_CURRENT_OPINST Procedure
- 157 DBMS_RANDOM
-
158
DBMS_REDACT
- 158.1 DBMS_REDACT Overview
- 158.2 DBMS_REDACT Security Model
- 158.3 DBMS_REDACT Constants
- 158.4 DBMS_REDACT Operating Procedures
-
158.5
Summary of DBMS_REDACT Subprograms
- 158.5.1 ADD_POLICY Procedure
- 158.5.2 ALTER_POLICY Procedure
- 158.5.3 APPLY_POLICY_EXPR_TO_COL Procedure
- 158.5.4 CREATE_POLICY_EXPRESSION Procedure
- 158.5.5 DISABLE_POLICY Procedure
- 158.5.6 DROP_POLICY Procedure
- 158.5.7 DROP_POLICY_EXPRESSION Procedure
- 158.5.8 ENABLE_POLICY Procedure
- 158.5.9 UPDATE_FULL_REDACTION_VALUES Procedure
- 158.5.10 UPDATE_POLICY_EXPRESSION Procedure
-
159
DBMS_REDEFINITION
- 159.1 DBMS_REDEFINITION Overview
- 159.2 DBMS_REDEFINITION Security Model
- 159.3 DBMS_REDEFINITION Constants
- 159.4 DBMS_REDEFINITION Operational Notes
- 159.5 DBMS_REDEFINITION Rules and Limits
- 159.6 DBMS_REDEFINITION Examples
-
159.7
Summary of DBMS_REDEFINITION Subprograms
- 159.7.1 ABORT_REDEF_TABLE Procedure
- 159.7.2 ABORT_ROLLBACK Procedure
- 159.7.3 ABORT_UPDATE Procedure
- 159.7.4 CAN_REDEF_TABLE Procedure
- 159.7.5 COPY_TABLE_DEPENDENTS Procedure
- 159.7.6 EXECUTE_UPDATE Procedure
- 159.7.7 FINISH_REDEF_TABLE Procedure
- 159.7.8 REDEF_TABLE Procedure
- 159.7.9 REGISTER_DEPENDENT_OBJECT Procedure
- 159.7.10 ROLLBACK Procedure
- 159.7.11 SET_PARAM Procedure
- 159.7.12 START_REDEF_TABLE Procedure
- 159.7.13 SYNC_INTERIM_TABLE Procedure
- 159.7.14 UNREGISTER_DEPENDENT_OBJECT Procedure
- 160 DBMS_REFRESH
- 161 DBMS_REPAIR
-
162
DBMS_RESCONFIG
- 162.1 DBMS_RESCONFIG Overview
-
162.2
Summary of DBMS_RESCONFIG Subprograms
- 162.2.1 ADDREPOSITORYRESCONFIG Procedure
- 162.2.2 ADDRESCONFIG Procedure
- 162.2.3 APPENDRESCONFIG Procedure
- 162.2.4 DELETEREPOSITORYRESCONFIG Procedure
- 162.2.5 DELETERESCONFIG Procedures
- 162.2.6 GETLISTENERS Function
- 162.2.7 GETREPOSITORYRESCONFIG Function
- 162.2.8 GETREPOSITORYRESCONFIGPATHS Function
- 162.2.9 GETRESCONFIG Function
- 162.2.10 GETRESCONFIGPATHS Function
- 162.2.11 PATCHREPOSITORYRESCONFIGLIST Procedure
-
163
DBMS_RESOURCE_MANAGER
- 163.1 DBMS_RESOURCE_MANAGER Deprecated Subprograms
- 163.2 DBMS_RESOURCE_MANAGER Security Model
- 163.3 DBMS_RESOURCE_MANAGER Constants
-
163.4
Summary of DBMS_RESOURCE_MANAGER Subprograms
- 163.4.1 BEGIN_SQL_BLOCK Procedure
- 163.4.2 CALIBRATE_IO Procedure
- 163.4.3 CLEAR_PENDING_AREA Procedure
- 163.4.4 CREATE_CATEGORY Procedure
- 163.4.5 CREATE_CDB_PLAN Procedure
- 163.4.6 CREATE_CDB_PLAN_DIRECTIVE Procedure
- 163.4.7 CREATE_CDB_PROFILE_DIRECTIVE Procedure
- 163.4.8 CREATE_CONSUMER_GROUP Procedure
- 163.4.9 CREATE_PENDING_AREA Procedure
- 163.4.10 CREATE_PLAN Procedure
- 163.4.11 CREATE_PLAN_DIRECTIVE Procedure
- 163.4.12 CREATE_SIMPLE_PLAN Procedure
- 163.4.13 DELETE_CATEGORY Procedure
- 163.4.14 DELETE_CDB_PLAN Procedure
- 163.4.15 DELETE_CDB_PLAN_DIRECTIVE Procedure
- 163.4.16 DELETE_CDB_PROFILE_DIRECTIVE Procedure
- 163.4.17 DELETE_CONSUMER_GROUP Procedure
- 163.4.18 DELETE_PLAN Procedure
- 163.4.19 DELETE_PLAN_CASCADE Procedure
- 163.4.20 DELETE_PLAN_DIRECTIVE Procedure
- 163.4.21 DEQUEUE_PARALLEL_STATEMENT Procedure
- 163.4.22 END_SQL_BLOCK Procedure
- 163.4.23 SET_CONSUMER_GROUP_MAPPING Procedure
- 163.4.24 SET_CONSUMER_GROUP_MAPPING_PRI Procedure
- 163.4.25 SET_INITIAL_CONSUMER_GROUP Procedure
- 163.4.26 SUBMIT_PENDING_AREA Procedure
- 163.4.27 SWITCH_CONSUMER_GROUP_FOR_SESS Procedure
- 163.4.28 SWITCH_CONSUMER_GROUP_FOR_USER Procedure
- 163.4.29 SWITCH_PLAN Procedure
- 163.4.30 UPDATE_CATEGORY Procedure
- 163.4.31 UPDATE_CDB_AUTOTASK_DIRECTIVE Procedure
- 163.4.32 UPDATE_CDB_DEFAULT_DIRECTIVE Procedure
- 163.4.33 UPDATE_CDB_PLAN Procedure
- 163.4.34 UPDATE_CDB_PLAN_DIRECTIVE Procedure
- 163.4.35 UPDATE_CDB_PROFILE_DIRECTIVE Procedure
- 163.4.36 UPDATE_CONSUMER_GROUP Procedure
- 163.4.37 UPDATE_PLAN Procedure
- 163.4.38 UPDATE_PLAN_DIRECTIVE Procedure
- 163.4.39 VALIDATE_PENDING_AREA Procedure
- 164 DBMS_RESOURCE_MANAGER_PRIVS
-
165
DBMS_RESULT_CACHE
- 165.1 DBMS_RESULT_CACHE Security Model
- 165.2 DBMS_RESULT_CACHE Constants
-
165.3
Summary of DBMS_RESULT_CACHE Subprograms
- 165.3.1 BLACK_LIST Function
- 165.3.2 BLACK_LIST_ADD Procedure
- 165.3.3 BLACK_LIST_CLEAR Procedure
- 165.3.4 BLACK_LIST_REMOVE Procedure
- 165.3.5 BYPASS Procedure
- 165.3.6 FLUSH Function & Procedure
- 165.3.7 IGNORE_LIST Function
- 165.3.8 IGNORE_LIST_ADD Procedure
- 165.3.9 IGNORE_LIST_CLEAR Procedure
- 165.3.10 IGNORE_LIST_REMOVE Procedure
- 165.3.11 INVALIDATE Functions & Procedures
- 165.3.12 INVALIDATE_OBJECT Functions & Procedures
- 165.3.13 MEMORY_REPORT Procedure
- 165.3.14 OBJECT_BLACK_LIST Function
- 165.3.15 OBJECT_BLACK_LIST_ADD Procedure
- 165.3.16 OBJECT_BLACK_LIST_CLEAR Procedure
- 165.3.17 OBJECT_BLACK_LIST_REMOVE Procedure
- 165.3.18 STATUS Function
- 165.3.19 BLOCK_LIST Function
- 165.3.20 BLOCK_LIST_ADD Procedure
- 165.3.21 BLOCK_LIST_CLEAR Procedure
- 165.3.22 BLOCK_LIST_REMOVE Procedure
- 165.3.23 OBJECT_BLOCK_LIST Function
- 165.3.24 OBJECT_BLOCK_LIST_ADD Procedure
- 165.3.25 OBJECT_BLOCK_LIST_CLEAR Procedure
- 165.3.26 OBJECT_BLOCK_LIST_REMOVE Procedure
- 166 DBMS_RESUMABLE
-
167
DBMS_RLS
- 167.1 DBMS_RLS Overview
- 167.2 DBMS_RLS Security Model
- 167.3 DBMS_RLS Constants
- 167.4 DBMS_RLS Operational Notes
- 167.5 DBMS_RLS Rules and Limits
-
167.6
Summary of DBMS_RLS Subprograms
- 167.6.1 ADD_GROUPED_POLICY Procedure
- 167.6.2 ADD_POLICY Procedure
- 167.6.3 ADD_POLICY_CONTEXT Procedure
- 167.6.4 ALTER_POLICY Procedure
- 167.6.5 ALTER_GROUPED_POLICY Procedure
- 167.6.6 CREATE_POLICY_GROUP Procedure
- 167.6.7 DELETE_POLICY_GROUP Procedure
- 167.6.8 DISABLE_GROUPED_POLICY Procedure
- 167.6.9 DROP_GROUPED_POLICY Procedure
- 167.6.10 DROP_POLICY Procedure
- 167.6.11 DROP_POLICY_CONTEXT Procedure
- 167.6.12 ENABLE_GROUPED_POLICY Procedure
- 167.6.13 ENABLE_POLICY Procedure
- 167.6.14 REFRESH_GROUPED_POLICY Procedure
- 167.6.15 REFRESH_POLICY Procedure
- 168 DBMS_ROLLING
-
169
DBMS_ROWID
- 169.1 DBMS_ROWID Security Model
- 169.2 DBMS_ROWID Types
- 169.3 DBMS_ROWID Exceptions
- 169.4 DBMS_ROWID Operational Notes
- 169.5 DBMS_ROWID Examples
-
169.6
Summary of DBMS_ROWID Subprograms
- 169.6.1 ROWID_BLOCK_NUMBER Function
- 169.6.2 ROWID_CREATE Function
- 169.6.3 ROWID_INFO Procedure
- 169.6.4 ROWID_OBJECT Function
- 169.6.5 ROWID_RELATIVE_FNO Function
- 169.6.6 ROWID_ROW_NUMBER Function
- 169.6.7 ROWID_TO_ABSOLUTE_FNO Function
- 169.6.8 ROWID_TO_EXTENDED Function
- 169.6.9 ROWID_TO_RESTRICTED Function
- 169.6.10 ROWID_TYPE Function
- 169.6.11 ROWID_VERIFY Function
-
170
DBMS_RULE
- 170.1 DBMS_RULE Overview
- 170.2 DBMS_RULE Security Model
-
170.3
Summary of DBMS_RULE Subprograms
- 170.3.1 CLOSE_ITERATOR Procedure
- 170.3.2 EVALUATE Procedure
- 170.3.3 EVALUATE_EXPRESSION Procedure
- 170.3.4 EVALUATE_EXPRESSION_ITERATOR Procedure
- 170.3.5 EVALUATE_RULE Procedure
- 170.3.6 EVALUATE_RULE_ITERATOR Procedure
- 170.3.7 GET_NEXT_HIT Function
- 170.3.8 GET_NEXT_RESULT Function
- 170.3.9 IS_FAST Procedure
-
171
DBMS_RULE_ADM
- 171.1 DBMS_RULE_ADM Overview
- 171.2 DBMS_RULE_ADM Security Model
-
171.3
Summary of DBMS_RULE_ADM Subprograms
- 171.3.1 ADD_RULE Procedure
- 171.3.2 ALTER_EVALUATION_CONTEXT Procedure
- 171.3.3 ALTER_RULE Procedure
- 171.3.4 CREATE_EVALUATION_CONTEXT Procedure
- 171.3.5 CREATE_RULE Procedure
- 171.3.6 CREATE_RULE_SET Procedure
- 171.3.7 DROP_EVALUATION_CONTEXT Procedure
- 171.3.8 DROP_RULE Procedure
- 171.3.9 DROP_RULE_SET Procedure
- 171.3.10 GRANT_OBJECT_PRIVILEGE Procedure
- 171.3.11 GRANT_SCHEMA_PRIVILEGE Procedure
- 171.3.12 GRANT_SYSTEM_PRIVILEGE Procedure
- 171.3.13 REMOVE_RULE Procedure
- 171.3.14 REVOKE_OBJECT_PRIVILEGE Procedure
- 171.3.15 REVOKE_SCHEMA_PRIVILEGE Procedure
- 171.3.16 REVOKE_SYSTEM_PRIVILEGE Procedure
- 172 DBMS_SAGA_ADM
- 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_SQL_PLAN_BASELINE Function
- 186.6.10 EVOLVE_SQL_PLAN_BASELINE Function
- 186.6.11 EXECUTE_EVOLVE_TASK Function
- 186.6.12 IMPLEMENT_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_HISTORY Function
- 195.5.28 REPORT_SQL_HISTORY_LIST Function
- 195.5.29 REPORT_SQL_MONITOR Function
- 195.5.30 REPORT_SQL_MONITOR_LIST Function
- 195.5.31 REPORT_TUNING_TASK Function
- 195.5.32 REPORT_TUNING_TASK_XML Function
- 195.5.33 RESET_TUNING_TASK Procedure
- 195.5.34 RESUME_TUNING_TASK Procedure
- 195.5.35 SCHEDULE_TUNING_TASK Function
- 195.5.36 SCRIPT_TUNING_TASK Function
- 195.5.37 SELECT_CURSOR_CACHE Function
- 195.5.38 SELECT_SQL_TRACE Function
- 195.5.39 SELECT_SQLPA_TASK Function
- 195.5.40 SELECT_SQLSET Function
- 195.5.41 SELECT_WORKLOAD_REPOSITORY Function
- 195.5.42 SET_TUNING_TASK_PARAMETER Procedures
- 195.5.43 SQLTEXT_TO_SIGNATURE Function
- 195.5.44 UNPACK_STGTAB_SQLPROF Procedure
- 195.5.45 UNPACK_STGTAB_SQLSET Procedure
- 195.5.46 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_PROCESSING_RATE Procedure
- 197.7.22 DELETE_SCHEMA_PREFS Procedure
- 197.7.23 DELETE_SCHEMA_STATS Procedure
- 197.7.24 DELETE_SYSTEM_STATS Procedure
- 197.7.25 DELETE_TABLE_PREFS Procedure
- 197.7.26 DELETE_TABLE_STATS Procedure
- 197.7.27 DIFF_TABLE_STATS_IN_HISTORY Function
- 197.7.28 DIFF_TABLE_STATS_IN_PENDING Function
- 197.7.29 DIFF_TABLE_STATS_IN_STATTAB Function
- 197.7.30 DROP_ADVISOR_TASK Procedure
- 197.7.31 DROP_EXTENDED_STATS Procedure
- 197.7.32 DROP_STAT_TABLE Procedure
- 197.7.33 EXECUTE_ADVISOR_TASK Function
- 197.7.34 EXPORT_COLUMN_STATS Procedure
- 197.7.35 EXPORT_DATABASE_PREFS Procedure
- 197.7.36 EXPORT_DATABASE_STATS Procedure
- 197.7.37 EXPORT_DICTIONARY_STATS Procedure
- 197.7.38 EXPORT_FIXED_OBJECTS_STATS Procedure
- 197.7.39 EXPORT_INDEX_STATS Procedure
- 197.7.40 EXPORT_PENDING_STATS Procedure
- 197.7.41 EXPORT_SCHEMA_PREFS Procedure
- 197.7.42 EXPORT_SCHEMA_STATS Procedure
- 197.7.43 EXPORT_SYSTEM_STATS Procedure
- 197.7.44 EXPORT_TABLE_PREFS Procedure
- 197.7.45 EXPORT_TABLE_STATS Procedure
- 197.7.46 FLUSH_DATABASE_MONITORING_INFO Procedure
- 197.7.47 GATHER_DATABASE_STATS Procedures
- 197.7.48 GATHER_DICTIONARY_STATS Procedure
- 197.7.49 GATHER_FIXED_OBJECTS_STATS Procedure
- 197.7.50 GATHER_INDEX_STATS Procedure
- 197.7.51 GATHER_PROCESSING_RATE Procedure
- 197.7.52 GATHER_SCHEMA_STATS Procedures
- 197.7.53 GATHER_SYSTEM_STATS Procedure
- 197.7.54 GATHER_TABLE_STATS Procedure
- 197.7.55 GENERATE_STATS Procedure
- 197.7.56 GET_ADVISOR_OPR_FILTER Procedure
- 197.7.57 GET_ADVISOR_RECS Function
- 197.7.58 GET_COLUMN_STATS Procedures
- 197.7.59 GET_INDEX_STATS Procedures
- 197.7.60 GET_PARAM Function
- 197.7.61 GET_PREFS Function
- 197.7.62 GET_STATS_HISTORY_AVAILABILITY Function
- 197.7.63 GET_STATS_HISTORY_RETENTION Function
- 197.7.64 GET_SYSTEM_STATS Procedure
- 197.7.65 GET_TABLE_STATS Procedure
- 197.7.66 IMPLEMENT_ADVISOR_TASK Function
- 197.7.67 IMPORT_COLUMN_STATS Procedure
- 197.7.68 IMPORT_DATABASE_PREFS Procedure
- 197.7.69 IMPORT_DATABASE_STATS Procedure
- 197.7.70 IMPORT_DICTIONARY_STATS Procedure
- 197.7.71 IMPORT_FIXED_OBJECTS_STATS Procedure
- 197.7.72 IMPORT_INDEX_STATS Procedure
- 197.7.73 IMPORT_SCHEMA_PREFS Procedure
- 197.7.74 IMPORT_SCHEMA_STATS Procedure
- 197.7.75 IMPORT_SYSTEM_STATS Procedure
- 197.7.76 IMPORT_TABLE_PREFS Procedure
- 197.7.77 IMPORT_TABLE_STATS Procedure
- 197.7.78 INTERRUPT_ADVISOR_TASK Procedure
- 197.7.79 LOCK_PARTITION_STATS Procedure
- 197.7.80 LOCK_SCHEMA_STATS Procedure
- 197.7.81 LOCK_TABLE_STATS Procedure
- 197.7.82 MERGE_COL_USAGE Procedure
- 197.7.83 PREPARE_COLUMN_VALUES Procedures
- 197.7.84 PREPARE_COLUMN_VALUES_NVARCHAR Procedure
- 197.7.85 PREPARE_COLUMN_VALUES_ROWID Procedure
- 197.7.86 PUBLISH_PENDING_STATS Procedure
- 197.7.87 PURGE_STATS Procedure
- 197.7.88 REMAP_STAT_TABLE Procedure
- 197.7.89 REPORT_ADVISOR_TASK Function
- 197.7.90 REPORT_COL_USAGE Function
- 197.7.91 REPORT_GATHER_AUTO_STATS Function
- 197.7.92 REPORT_GATHER_DATABASE_STATS Functions
- 197.7.93 REPORT_GATHER_DICTIONARY_STATS Functions
- 197.7.94 REPORT_GATHER_FIXED_OBJ_STATS Function
- 197.7.95 REPORT_GATHER_SCHEMA_STATS Functions
- 197.7.96 REPORT_GATHER_TABLE_STATS Function
- 197.7.97 REPORT_SINGLE_STATS_OPERATION Function
- 197.7.98 REPORT_STATS_OPERATIONS Function
- 197.7.99 RESET_ADVISOR_TASK Procedure
- 197.7.100 RESET_COL_USAGE Procedure
- 197.7.101 RESET_PARAM_DEFAULTS Procedure
- 197.7.102 RESTORE_DATABASE_STATS Procedure
- 197.7.103 RESTORE_DICTIONARY_STATS Procedure
- 197.7.104 RESTORE_FIXED_OBJECTS_STATS Procedure
- 197.7.105 RESTORE_SCHEMA_STATS Procedure
- 197.7.106 RESTORE_SYSTEM_STATS Procedure
- 197.7.107 RESTORE_TABLE_STATS Procedure
- 197.7.108 RESUME_ADVISOR_TASK Procedure
- 197.7.109 SCRIPT_ADVISOR_TASK Function
- 197.7.110 SEED_COL_USAGE Procedure
- 197.7.111 SET_ADVISOR_TASK_PARAMETER Procedure
- 197.7.112 SET_COLUMN_STATS Procedures
- 197.7.113 SET_DATABASE_PREFS Procedure
- 197.7.114 SET_GLOBAL_PREFS Procedure
- 197.7.115 SET_INDEX_STATS Procedures
- 197.7.116 SET_PARAM Procedure
- 197.7.117 SET_PROCESSING_RATE Procedure
- 197.7.118 SET_SCHEMA_PREFS Procedure
- 197.7.119 SET_SYSTEM_STATS Procedure
- 197.7.120 SET_TABLE_PREFS Procedure
- 197.7.121 SET_TABLE_STATS Procedure
- 197.7.122 SHOW_EXTENDED_STATS_NAME Function
- 197.7.123 TRANSFER_STATS Procedure
- 197.7.124 UNLOCK_PARTITION_STATS Procedure
- 197.7.125 UNLOCK_SCHEMA_STATS Procedure
- 197.7.126 UNLOCK_TABLE_STATS Procedure
- 197.7.127 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 XSTREAM_CAPTURE
- 246 DEBUG_EXTPROC
-
247
HTF
- 247.1 HTF Deprecated Subprograms
- 247.2 HTF Operational Notes
- 247.3 Rules and Limits
- 247.4 HTF Examples
- 247.5 Summary of Tags
-
247.6
Summary of HTF Subprograms
- 247.6.1 ADDRESS Function
- 247.6.2 ANCHOR Function
- 247.6.3 ANCHOR2 Function
- 247.6.4 APPLETCLOSE Function
- 247.6.5 APPLETOPEN Function
- 247.6.6 AREA Function
- 247.6.7 BASE Function
- 247.6.8 BASEFONT Function
- 247.6.9 BGSOUND Function
- 247.6.10 BIG Function
- 247.6.11 BLOCKQUOTECLOSE Function
- 247.6.12 BLOCKQUOTEOPEN Function
- 247.6.13 BODYCLOSE Function
- 247.6.14 BODYOPEN Function
- 247.6.15 BOLD Function
- 247.6.16 BR Function
- 247.6.17 CENTER Function
- 247.6.18 CENTERCLOSE Function
- 247.6.19 CENTEROPEN Function
- 247.6.20 CITE Function
- 247.6.21 CODE Function
- 247.6.22 COMMENT Function
- 247.6.23 DFN Function
- 247.6.24 DIRLISTCLOSE Function
- 247.6.25 DIRLISTOPEN Function
- 247.6.26 DIV Function
- 247.6.27 DLISTCLOSE Function
- 247.6.28 DLISTDEF Function
- 247.6.29 DLISTOPEN Function
- 247.6.30 DLISTTERM Function
- 247.6.31 EM Function
- 247.6.32 EMPHASIS Function
- 247.6.33 ESCAPE_SC Function
- 247.6.34 ESCAPE_URL Function
- 247.6.35 FONTCLOSE Function
- 247.6.36 FONTOPEN Function
- 247.6.37 FORMAT_CELL Function
- 247.6.38 FORMCHECKBOX Function
- 247.6.39 FORMCLOSE Function
- 247.6.40 FORMFILE Function
- 247.6.41 FORMHIDDEN Function
- 247.6.42 FORMIMAGE Function
- 247.6.43 FORMOPEN Function
- 247.6.44 FORMPASSWORD Function
- 247.6.45 FORMRADIO Function
- 247.6.46 FORMRESET Function
- 247.6.47 FORMSELECTCLOSE Function
- 247.6.48 FORMSELECTOPEN Function
- 247.6.49 FORMSELECTOPTION Function
- 247.6.50 FORMSUBMIT Function
- 247.6.51 FORMTEXT Function
- 247.6.52 FORMTEXTAREA Function
- 247.6.53 FORMTEXTAREA2 Function
- 247.6.54 FORMTEXTAREACLOSE Function
- 247.6.55 FORMTEXTAREAOPEN Function
- 247.6.56 FORMTEXTAREAOPEN2 Function
- 247.6.57 FRAME Function
- 247.6.58 FRAMESETCLOSE Function
- 247.6.59 FRAMESETOPEN Function
- 247.6.60 HEADCLOSE Function
- 247.6.61 HEADER Function
- 247.6.62 HEADOPEN Function
- 247.6.63 HR Function
- 247.6.64 HTMLCLOSE Function
- 247.6.65 HTMLOPEN Function
- 247.6.66 IMG Function
- 247.6.67 IMG2 Function
- 247.6.68 ISINDEX Function
- 247.6.69 ITALIC Function
- 247.6.70 KBD Function
- 247.6.71 KEYBOARD Function
- 247.6.72 LINE Function
- 247.6.73 LINKREL Function
- 247.6.74 LINKREV Function
- 247.6.75 LISTHEADER Function
- 247.6.76 LISTINGCLOSE Function
- 247.6.77 LISTINGOPEN Function
- 247.6.78 LISTITEM Function
- 247.6.79 MAILTO Function
- 247.6.80 MAPCLOSE Function
- 247.6.81 MAPOPEN Function
- 247.6.82 MENULISTCLOSE Function
- 247.6.83 MENULISTOPEN Function
- 247.6.84 META Function
- 247.6.85 NL Function
- 247.6.86 NOBR Function
- 247.6.87 NOFRAMESCLOSE Function
- 247.6.88 NOFRAMESOPEN Function
- 247.6.89 OLISTCLOSE Function
- 247.6.90 OLISTOPEN Function
- 247.6.91 PARA Function
- 247.6.92 PARAGRAPH Function
- 247.6.93 PARAM Function
- 247.6.94 PLAINTEXT Function
- 247.6.95 PRECLOSE Function
- 247.6.96 PREOPEN Function
- 247.6.97 PRINT Functions
- 247.6.98 PRN Functions
- 247.6.99 S Function
- 247.6.100 SAMPLE Function
- 247.6.101 SCRIPT Function
- 247.6.102 SMALL Function
- 247.6.103 STRIKE Function
- 247.6.104 STRONG Function
- 247.6.105 STYLE Function
- 247.6.106 SUB Function
- 247.6.107 SUP Function
- 247.6.108 TABLECAPTION Function
- 247.6.109 TABLECLOSE Function
- 247.6.110 TABLEDATA Function
- 247.6.111 TABLEHEADER Function
- 247.6.112 TABLEOPEN Function
- 247.6.113 TABLEROWCLOSE Function
- 247.6.114 TABLEROWOPEN Function
- 247.6.115 TELETYPE Function
- 247.6.116 TITLE Function
- 247.6.117 ULISTCLOSE Function
- 247.6.118 ULISTOPEN Function
- 247.6.119 UNDERLINE Function
- 247.6.120 VARIABLE Function
- 247.6.121 WBR Function
-
248
HTP
- 248.1 HTP Operational Notes
- 248.2 HTP Rules and Limits
- 248.3 HTP Examples
- 248.4 HTP Summary of Tags
-
248.5
Summary of HTP Subprograms
- 248.5.1 ADDRESS Procedure
- 248.5.2 ANCHOR Procedure
- 248.5.3 ANCHOR2 Procedure
- 248.5.4 APPLETCLOSE Procedure
- 248.5.5 APPLETOPEN Procedure
- 248.5.6 AREA Procedure
- 248.5.7 BASE Procedure
- 248.5.8 BASEFONT Procedure
- 248.5.9 BGSOUND Procedure
- 248.5.10 BIG Procedure
- 248.5.11 BLOCKQUOTECLOSE Procedure
- 248.5.12 BLOCKQUOTEOPEN Procedure
- 248.5.13 BODYCLOSE Procedure
- 248.5.14 BODYOPEN Procedure
- 248.5.15 BOLD Procedure
- 248.5.16 BR Procedure
- 248.5.17 CENTER Procedure
- 248.5.18 CENTERCLOSE Procedure
- 248.5.19 CENTEROPEN Procedure
- 248.5.20 CITE Procedure
- 248.5.21 CODE Procedure
- 248.5.22 COMMENT Procedure
- 248.5.23 DFN Procedure
- 248.5.24 DIRLISTCLOSE Procedure
- 248.5.25 DIRLISTOPEN Procedure
- 248.5.26 DIV Procedure
- 248.5.27 DLISTCLOSE Procedure
- 248.5.28 DLISTDEF Procedure
- 248.5.29 DLISTOPEN Procedure
- 248.5.30 DLISTTERM Procedure
- 248.5.31 EM Procedure
- 248.5.32 EMPHASIS Procedure
- 248.5.33 ESCAPE_SC Procedure
- 248.5.34 FONTCLOSE Procedure
- 248.5.35 FONTOPEN Procedure
- 248.5.36 FORMCHECKBOX Procedure
- 248.5.37 FORMCLOSE Procedure
- 248.5.38 FORMOPEN Procedure
- 248.5.39 FORMFILE Procedure
- 248.5.40 FORMHIDDEN Procedure
- 248.5.41 FORMIMAGE Procedure
- 248.5.42 FORMPASSWORD Procedure
- 248.5.43 FORMRADIO Procedure
- 248.5.44 FORMRESET Procedure
- 248.5.45 FORMSELECTCLOSE Procedure
- 248.5.46 FORMSELECTOPEN Procedure
- 248.5.47 FORMSELECTOPTION Procedure
- 248.5.48 FORMSUBMIT Procedure
- 248.5.49 FORMTEXT Procedure
- 248.5.50 FORMTEXTAREA Procedure
- 248.5.51 FORMTEXTAREA2 Procedure
- 248.5.52 FORMTEXTAREACLOSE Procedure
- 248.5.53 FORMTEXTAREAOPEN Procedure
- 248.5.54 FORMTEXTAREAOPEN2 Procedure
- 248.5.55 FRAME Procedure
- 248.5.56 FRAMESETCLOSE Procedure
- 248.5.57 FRAMESETOPEN Procedure
- 248.5.58 HEADCLOSE Procedure
- 248.5.59 HEADER Procedure
- 248.5.60 HEADOPEN Procedure
- 248.5.61 HR Procedure
- 248.5.62 HTMLCLOSE Procedure
- 248.5.63 HTMLOPEN Procedure
- 248.5.64 IMG Procedure
- 248.5.65 IMG2 Procedure
- 248.5.66 ISINDEX Procedure
- 248.5.67 ITALIC Procedure
- 248.5.68 KBD Procedure
- 248.5.69 KEYBOARD Procedure
- 248.5.70 LINE Procedure
- 248.5.71 LINKREL Procedure
- 248.5.72 LINKREV Procedure
- 248.5.73 LISTHEADER Procedure
- 248.5.74 LISTINGCLOSE Procedure
- 248.5.75 LISTINGOPEN Procedure
- 248.5.76 LISTITEM Procedure
- 248.5.77 MAILTO Procedure
- 248.5.78 MAPCLOSE Procedure
- 248.5.79 MAPOPEN Procedure
- 248.5.80 MENULISTCLOSE Procedure
- 248.5.81 MENULISTOPEN Procedure
- 248.5.82 META Procedure
- 248.5.83 NL Procedure
- 248.5.84 NOBR Procedure
- 248.5.85 NOFRAMESCLOSE Procedure
- 248.5.86 NOFRAMESOPEN Procedure
- 248.5.87 OLISTCLOSE Procedure
- 248.5.88 OLISTOPEN Procedure
- 248.5.89 PARA Procedure
- 248.5.90 PARAGRAPH Procedure
- 248.5.91 PARAM Procedure
- 248.5.92 PLAINTEXT Procedure
- 248.5.93 PRECLOSE Procedure
- 248.5.94 PREOPEN Procedure
- 248.5.95 PRINT Procedures
- 248.5.96 PRINTS Procedure
- 248.5.97 PRN Procedures
- 248.5.98 PS Procedure
- 248.5.99 S Procedure
- 248.5.100 SAMPLE Procedure
- 248.5.101 SCRIPT Procedure
- 248.5.102 SMALL Procedure
- 248.5.103 STRIKE Procedure
- 248.5.104 STRONG Procedure
- 248.5.105 STYLE Procedure
- 248.5.106 SUB Procedure
- 248.5.107 SUP Procedure
- 248.5.108 TABLECAPTION Procedure
- 248.5.109 TABLECLOSE Procedure
- 248.5.110 TABLEDATA Procedure
- 248.5.111 TABLEHEADER Procedure
- 248.5.112 TABLEOPEN Procedure
- 248.5.113 TABLEROWCLOSE Procedure
- 248.5.114 TABLEROWOPEN Procedure
- 248.5.115 TELETYPE Procedure
- 248.5.116 TITLE Procedure
- 248.5.117 ULISTCLOSE Procedure
- 248.5.118 ULISTOPEN Procedure
- 248.5.119 UNDERLINE Procedure
- 248.5.120 VARIABLE Procedure
- 248.5.121 WBR Procedure
- 249 OWA_CACHE
- 250 OWA_COOKIE
- 251 OWA_CUSTOM
- 252 OWA_IMAGE
- 253 OWA_OPT_LOCK
- 254 OWA_PATTERN
- 255 OWA_SEC
- 256 OWA_TEXT
-
257
OWA_UTIL
- 257.1 OWA_UTIL Overview
- 257.2 OWA_UTIL Types
-
257.3
Summary of OWA_UTIL Subprograms
- 257.3.1 BIND_VARIABLES Function
- 257.3.2 CALENDARPRINT Procedures
- 257.3.3 CELLSPRINT Procedures
- 257.3.4 CHOOSE_DATE Procedure
- 257.3.5 GET_CGI_ENV Function
- 257.3.6 GET_OWA_SERVICE_PATH Function
- 257.3.7 GET_PROCEDURE Function
- 257.3.8 HTTP_HEADER_CLOSE Procedure
- 257.3.9 LISTPRINT Procedure
- 257.3.10 MIME_HEADER Procedure
- 257.3.11 PRINT_CGI_ENV Procedure
- 257.3.12 REDIRECT_URL Procedure
- 257.3.13 SHOWPAGE Procedure
- 257.3.14 SHOWSOURCE Procedure
- 257.3.15 SIGNATURE procedure
- 257.3.16 STATUS_LINE Procedure
- 257.3.17 TABLEPRINT Function
- 257.3.18 TODATE Function
- 257.3.19 WHO_CALLED_ME Procedure
- 258 SDO_CS
- 259 SDO_CSW_PROCESS
- 260 SDO_GCDR
- 261 SDO_GEOM
- 262 SDO_GEOR
- 263 SDO_GEOR_ADMIN
- 264 SDO_GEOR_AGGR
- 265 SDO_GEOR_RA
- 266 SDO_GEOR_UTL
- 267 SDO_LRS
- 268 SDO_MIGRATE
- 269 SDO_NET
- 270 SDO_NFE
- 271 SDO_OLS
- 272 SDO_PC_PKG
- 273 SDO_SAM
- 274 SDO_TIN_PKG
- 275 SDO_TOPO
- 276 SDO_TOPO_MAP
- 277 SDO_TUNE
- 278 SDO_UTIL
- 279 SDO_WFS_LOCK
- 280 SDO_WFS_PROCESS
- 281 SEM_APIS
- 282 SEM_OLS
- 283 SEM_PERF
- 284 SEM_RDFCTX
- 285 SEM_RDFSA
-
286
UTL_CALL_STACK
- 286.1 UTL_CALL_STACK Overview
- 286.2 UTL_CALL_STACK Security Model
- 286.3 UTL_CALL_STACK Operational Notes
- 286.4 UTL_CALL_STACK Exceptions
- 286.5 UTL_CALL_STACK Data Structures
-
286.6
Summary of UTL_CALL_STACK Subprograms
- 286.6.1 BACKTRACE_DEPTH Function
- 286.6.2 BACKTRACE_LINE Function
- 286.6.3 BACKTRACE_UNIT Function
- 286.6.4 CURRENT_EDITION Function
- 286.6.5 CONCATENATE_SUBPROGRAM Function
- 286.6.6 DYNAMIC_DEPTH Function
- 286.6.7 ERROR_DEPTH Function
- 286.6.8 ERROR_MSG Function
- 286.6.9 ERROR_NUMBER Function
- 286.6.10 LEXICAL_DEPTH Function
- 286.6.11 OWNER Function
- 286.6.12 UNIT_LINE Function
- 286.6.13 SUBPROGRAM Function
- 287 UTL_COLL
-
288
UTL_COMPRESS
- 288.1 UTL_COMPRESS Constants
- 288.2 UTL_COMPRESS Exceptions
- 288.3 UTL_COMPRESS Operational Notes
-
288.4
Summary of UTL_COMPRESS Subprograms
- 288.4.1 ISOPEN Function
- 288.4.2 LZ_COMPRESS Functions and Procedures
- 288.4.3 LZ_COMPRESS_ADD Procedure
- 288.4.4 LZ_COMPRESS_CLOSE
- 288.4.5 LZ_COMPRESS_OPEN
- 288.4.6 LZ_UNCOMPRESS Functions and Procedures
- 288.4.7 LZ_UNCOMPRESS_EXTRACT Procedure
- 288.4.8 LZ_UNCOMPRESS_OPEN Function
- 288.4.9 LZ_UNCOMPRESS_CLOSE Procedure
-
289
UTL_ENCODE
-
289.1
Summary of UTL_ENCODE Subprograms
- 289.1.1 BASE64_DECODE Function
- 289.1.2 BASE64_ENCODE Function
- 289.1.3 MIMEHEADER_DECODE Function
- 289.1.4 MIMEHEADER_ENCODE Function
- 289.1.5 QUOTED_PRINTABLE_DECODE Function
- 289.1.6 QUOTED_PRINTABLE_ENCODE Function
- 289.1.7 TEXT_DECODE Function
- 289.1.8 TEXT_ENCODE Function
- 289.1.9 UUDECODE Function
- 289.1.10 UUENCODE Function
-
289.1
Summary of UTL_ENCODE Subprograms
-
290
UTL_FILE
- 290.1 UTL_FILE Security Model
- 290.2 UTL_FILE Operational Notes
- 290.3 UTL_FILE Rules and Limits
- 290.4 UTL_FILE Exceptions
- 290.5 UTL_FILE Examples
- 290.6 UTL_FILE Data Structures
-
290.7
Summary of UTL_FILE Subprograms
- 290.7.1 FCLOSE Procedure
- 290.7.2 FCLOSE_ALL Procedure
- 290.7.3 FCOPY Procedure
- 290.7.4 FFLUSH Procedure
- 290.7.5 FGETATTR Procedure
- 290.7.6 FGETPOS Function
- 290.7.7 FOPEN Function
- 290.7.8 FOPEN_NCHAR Function
- 290.7.9 FREMOVE Procedure
- 290.7.10 FRENAME Procedure
- 290.7.11 FSEEK Procedure
- 290.7.12 GET_LINE Procedure
- 290.7.13 GET_LINE_NCHAR Procedure
- 290.7.14 GET_RAW Procedure
- 290.7.15 IS_OPEN Function
- 290.7.16 NEW_LINE Procedure
- 290.7.17 PUT Procedure
- 290.7.18 PUT_LINE Procedure
- 290.7.19 PUT_LINE_NCHAR Procedure
- 290.7.20 PUT_NCHAR Procedure
- 290.7.21 PUTF Procedure
- 290.7.22 PUTF_NCHAR Procedure
- 290.7.23 PUT_RAW Procedure
-
291
UTL_HTTP
- 291.1 UTL_HTTP Overview
- 291.2 UTL_HTTP Security Model
- 291.3 UTL_HTTP Constants
- 291.4 UTL_HTTP Exceptions
-
291.5
UTL_HTTP Examples
- 291.5.1 UTL_HTTP General Usage
- 291.5.2 UTL_HTTP Retrieving HTTP Response Headers
- 291.5.3 UTL_HTTP Handling HTTP Authentication
- 291.5.4 UTL_HTTP Handling HTTP Digest Authentication
- 291.5.5 UTL_HTTP Retrieving and Restoring Cookies
- 291.5.6 UTL_HTTP Making HTTP Request with Private Wallet and Cookie Table
- 291.5.7 UTL_HTTP Using a Proxy Server
- 291.6 UTL_HTTP Data Structures
-
291.7
UTL_HTTP Operations
- 291.7.1 UTL_HTTP Operational Flow
- 291.7.2 UTL_HTTP Simple HTTP Fetches
- 291.7.3 UTL_HTTP HTTP Requests
- 291.7.4 UTL_HTTP HTTP Responses
- 291.7.5 UTL_HTTP HTTP Cookies
- 291.7.6 UTL_HTTP HTTP Persistent Connections
- 291.7.7 UTL_HTTP Error Conditions
- 291.7.8 UTL_HTTP Session Settings
- 291.7.9 UTL_HTTP Request Context
- 291.7.10 UTL_HTTP External Password Store
-
291.8
UTL_HTTP Subprogram Groups
- 291.8.1 UTL_HTTP Simple HTTP Fetches in a Single Call Subprograms
- 291.8.2 UTL_HTTP Session Settings Subprograms
- 291.8.3 UTL_HTTP HTTP Requests Subprograms
- 291.8.4 UTL_HTTP HTTP Request Contexts Subprograms
- 291.8.5 UTL_HTTP HTTP Responses Subprograms
- 291.8.6 UTL_HTTP HTTP Cookies Subprograms
- 291.8.7 UTL_HTTP HTTP Persistent Connections Subprograms
- 291.8.8 UTL_HTTP Error Conditions Subprograms
-
291.9
Summary of UTL_HTTP Subprograms
- 291.9.1 ADD_COOKIES Procedure
- 291.9.2 BEGIN_REQUEST Function
- 291.9.3 CLEAR_COOKIES Procedure
- 291.9.4 CLOSE_PERSISTENT_CONN Procedure
- 291.9.5 CLOSE_PERSISTENT_CONNS Procedure
- 291.9.6 CREATE_REQUEST_CONTEXT Function
- 291.9.7 DESTROY_REQUEST_CONTEXT Procedure
- 291.9.8 END_REQUEST Procedure
- 291.9.9 END_RESPONSE Procedure
- 291.9.10 GET_AUTHENTICATION Procedure
- 291.9.11 GET_BODY_CHARSET Procedure
- 291.9.12 GET_COOKIE_COUNT Function
- 291.9.13 GET_COOKIE_SUPPORT Procedure
- 291.9.14 GET_COOKIES Function
- 291.9.15 GET_DETAILED_EXCP_SUPPORT Procedure
- 291.9.16 GET_DETAILED_SQLCODE Function
- 291.9.17 GET_DETAILED_SQLERRM Function
- 291.9.18 GET_FOLLOW_REDIRECT Procedure
- 291.9.19 GET_HEADER Procedure
- 291.9.20 GET_HEADER_BY_NAME Procedure
- 291.9.21 GET_HEADER_COUNT Function
- 291.9.22 GET_PERSISTENT_CONN_COUNT Function
- 291.9.23 GET_PERSISTENT_CONN_SUPPORT Procedure
- 291.9.24 GET_PERSISTENT_CONNS Procedure
- 291.9.25 GET_PROXY Procedure
- 291.9.26 GET_RESPONSE Function
- 291.9.27 GET_RESPONSE_ERROR_CHECK Procedure
- 291.9.28 GET_TRANSFER_TIMEOUT Procedure
- 291.9.29 READ_LINE Procedure
- 291.9.30 READ_RAW Procedure
- 291.9.31 READ_TEXT Procedure
- 291.9.32 REQUEST Function
- 291.9.33 REQUEST_PIECES Function
- 291.9.34 SET_AUTHENTICATION Procedure
- 291.9.35 SET_AUTHENTICATION_FROM_WALLET Procedure
- 291.9.36 SET_BODY_CHARSET Procedures
- 291.9.37 SET_COOKIE_SUPPORT Procedures
- 291.9.38 SET_DETAILED_EXCP_SUPPORT Procedure
- 291.9.39 SET_FOLLOW_REDIRECT Procedures
- 291.9.40 SET_HEADER Procedure
- 291.9.41 SET_PERSISTENT_CONN_SUPPORT Procedure
- 291.9.42 SET_PROXY Procedure
- 291.9.43 SET_RESPONSE_ERROR_CHECK Procedure
- 291.9.44 SET_TRANSFER_TIMEOUT Procedure
- 291.9.45 SET_WALLET Procedure
- 291.9.46 WRITE_LINE Procedure
- 291.9.47 WRITE_RAW Procedure
- 291.9.48 WRITE_TEXT Procedure
-
292
UTL_I18N
- 292.1 UTL_I18N Overview
- 292.2 UTL_I18N Security Model
- 292.3 UTL_I18N Constants
- 292.4 UTL_I18N Data Structures
-
292.5
Summary of UTL_I18N Subprograms
- 292.5.1 DETECT_CHARSET Procedure
- 292.5.2 DETECT_LANGUAGE Procedure
- 292.5.3 DETECT_LANGUAGE_CHARSET Procedure
- 292.5.4 ESCAPE_REFERENCE Function
- 292.5.5 GET_COMMON_TIME_ZONES Function
- 292.5.6 GET_DEFAULT_CHARSET Function
- 292.5.7 GET_DEFAULT_ISO_CURRENCY Function
- 292.5.8 GET_DEFAULT_LINGUISTIC_SORT Function
- 292.5.9 GET_LOCAL_LANGUAGES Function
- 292.5.10 GET_LOCAL_LINGUISTIC_SORTS Function
- 292.5.11 GET_LOCAL_TERRITORIES Function
- 292.5.12 GET_LOCAL_TIME_ZONES Function
- 292.5.13 GET_MAX_CHARACTER_SIZE Function
- 292.5.14 GET_TRANSLATION Function
- 292.5.15 MAP_CHARSET Function
- 292.5.16 MAP_FROM_SHORT_LANGUAGE Function
- 292.5.17 MAP_LANGUAGE_FROM_ISO Function
- 292.5.18 MAP_LOCALE_TO_ISO Function
- 292.5.19 MAP_TERRITORY_FROM_ISO Function
- 292.5.20 MAP_TO_SHORT_LANGUAGE Function
- 292.5.21 RAW_TO_CHAR Functions
- 292.5.22 RAW_TO_NCHAR Functions
- 292.5.23 STRING_TO_RAW Function
- 292.5.24 TRANSLITERATE Function
- 292.5.25 UNESCAPE_REFERENCE Function
- 292.5.26 VALIDATE_CHARACTER_ENCODING Functions
- 293 UTL_IDENT
- 294 UTL_INADDR
- 295 UTL_LMS
- 296 UTL_MAIL
- 297 UTL_MATCH
-
298
UTL_NLA
- 298.1 UTL_NLA Overview
- 298.2 UTL_NLA Rules and Limits
- 298.3 UTL_NLA Security Model
-
298.4
Subprogram Groups
- 298.4.1 UTL_NLA BLAS Level 1 (Vector-Vector Operations) Subprograms
- 298.4.2 UTL_NLA BLAS Level 2 (Matrix-Vector Operations) Subprograms
- 298.4.3 UTL_NLA BLAS Level 3 (Matrix-Matrix Operations) Subprograms
- 298.4.4 UTL_NLA LAPACK Driver Routines (Linear Equations) Subprograms
- 298.4.5 UTL_NLA LAPACK Driver Routines (LLS and Eigenvalue Problems) Subprograms
-
298.5
Summary of UTL_NLA Subprograms
- 298.5.1 BLAS_ASUM Functions
- 298.5.2 BLAS_AXPY Procedures
- 298.5.3 BLAS_COPY Procedures
- 298.5.4 BLAS_DOT Functions
- 298.5.5 BLAS_GBMV Procedures
- 298.5.6 BLAS_GEMM Procedures
- 298.5.7 BLAS_GEMV Procedures
- 298.5.8 BLAS_GER Procedures
- 298.5.9 BLAS_IAMAX Functions
- 298.5.10 BLAS_NRM2 Functions
- 298.5.11 BLAS_ROT Procedures
- 298.5.12 BLAS_ROTG Procedures
- 298.5.13 BLAS_SCAL Procedures
- 298.5.14 BLAS_SPMV Procedures
- 298.5.15 BLAS_SPR Procedures
- 298.5.16 BLAS_SPR2 Procedures
- 298.5.17 BLAS_SBMV Procedures
- 298.5.18 BLAS_SWAP Procedures
- 298.5.19 BLAS_SYMM Procedures
- 298.5.20 BLAS_SYMV Procedures
- 298.5.21 BLAS_SYR Procedures
- 298.5.22 BLAS_SYR2 Procedures
- 298.5.23 BLAS_SYR2K Procedures
- 298.5.24 BLAS_SYRK Procedures
- 298.5.25 BLAS_TBMV Procedures
- 298.5.26 BLAS_TBSV Procedures
- 298.5.27 BLAS_TPMV Procedures
- 298.5.28 BLAS_TPSV Procedures
- 298.5.29 BLAS_TRMM Procedures
- 298.5.30 BLAS_TRMV Procedures
- 298.5.31 BLAS_TRSM Procedures
- 298.5.32 BLAS_TRSV Procedures
- 298.5.33 LAPACK_GBSV Procedures
- 298.5.34 LAPACK_GEES Procedures
- 298.5.35 LAPACK_GELS Procedures
- 298.5.36 LAPACK_GESDD Procedures
- 298.5.37 LAPACK_GESV Procedure
- 298.5.38 LAPACK_GESVD Procedures
- 298.5.39 LAPACK_GEEV Procedures
- 298.5.40 LAPACK_GTSV Procedure
- 298.5.41 LAPACK_PBSV Procedures
- 298.5.42 LAPACK_POSV Procedures
- 298.5.43 LAPACK_PPSV Procedures
- 298.5.44 LAPACK_PTSV Procedures
- 298.5.45 LAPACK_SBEV Procedures
- 298.5.46 LAPACK_SBEVD Procedures
- 298.5.47 LAPACK_SPEV Procedures
- 298.5.48 LAPACK_SPEVD Procedures
- 298.5.49 LAPACK_SPSV Procedures
- 298.5.50 LAPACK_STEV Procedures
- 298.5.51 LAPACK_STEVD Procedures
- 298.5.52 LAPACK_SYEV Procedures
- 298.5.53 LAPACK_SYEVD Procedures
- 298.5.54 LAPACK_SYSV Procedures
-
299
UTL_RAW
- 299.1 UTL_RAW Overview
- 299.2 UTL_RAW Operational Notes
-
299.3
Summary of UTL_RAW Subprograms
- 299.3.1 BIT_AND Function
- 299.3.2 BIT_COMPLEMENT Function
- 299.3.3 BIT_OR Function
- 299.3.4 BIT_XOR Function
- 299.3.5 CAST_FROM_BINARY_DOUBLE Function
- 299.3.6 CAST_FROM_BINARY_FLOAT Function
- 299.3.7 CAST_FROM_BINARY_INTEGER Function
- 299.3.8 CAST_FROM_NUMBER Function
- 299.3.9 CAST_TO_BINARY_DOUBLE Function
- 299.3.10 CAST_TO_BINARY_FLOAT Function
- 299.3.11 CAST_TO_BINARY_INTEGER Function
- 299.3.12 CAST_TO_NUMBER Function
- 299.3.13 CAST_TO_NVARCHAR2 Function
- 299.3.14 CAST_TO_RAW Function
- 299.3.15 CAST_TO_VARCHAR2 Function
- 299.3.16 COMPARE Function
- 299.3.17 CONCAT Function
- 299.3.18 CONVERT Function
- 299.3.19 COPIES Function
- 299.3.20 LENGTH Function
- 299.3.21 OVERLAY Function
- 299.3.22 REVERSE Function
- 299.3.23 SUBSTR Function
- 299.3.24 TRANSLATE Function
- 299.3.25 TRANSLITERATE Function
- 299.3.26 XRANGE Function
- 300 UTL_RECOMP
- 301 UTL_REF
- 302 UTL_RPADV
-
303
UTL_SMTP
- 303.1 UTL_SMTP Overview
- 303.2 UTL_SMTP Security Model
- 303.3 UTL_SMTP Constants
- 303.4 UTL_SMTP Types
- 303.5 UTL_SMTP Reply Codes
- 303.6 UTL_SMTP Operational Notes
- 303.7 UTL_SMTP Exceptions
- 303.8 UTL_SMTP Rules and Limits
- 303.9 UTL_SMTP Examples
-
303.10
Summary of UTL_SMTP Subprograms
- 303.10.1 AUTH Function and Procedure
- 303.10.2 CLOSE_CONNECTION Procedure
- 303.10.3 CLOSE_DATA Function and Procedure
- 303.10.4 COMMAND Function and Procedure
- 303.10.5 COMMAND_REPLIES Function
- 303.10.6 DATA Function and Procedure
- 303.10.7 EHLO Function and Procedure
- 303.10.8 HELO Function and Procedure
- 303.10.9 HELP Function
- 303.10.10 MAIL Function and Procedure
- 303.10.11 NOOP Function and Procedure
- 303.10.12 OPEN_CONNECTION Functions
- 303.10.13 OPEN_DATA Function and Procedure
- 303.10.14 QUIT Function and Procedure
- 303.10.15 RCPT Function
- 303.10.16 RSET Function and Procedure
- 303.10.17 STARTTLS Function and Procedure
- 303.10.18 VRFY Function
- 303.10.19 WRITE_DATA Procedure
- 303.10.20 WRITE_RAW_DATA Procedure
-
304
UTL_TCP
- 304.1 UTL_TCP Overview
- 304.2 UTL_TCP Security Model
- 304.3 UTL_TCP Types
- 304.4 UTL_TCP Exceptions
- 304.5 UTL_TCP Rules and Limits
- 304.6 UTL_TCP Examples
-
304.7
Summary of UTL_TCP Subprograms
- 304.7.1 AVAILABLE Function
- 304.7.2 CLOSE_ALL_CONNECTIONS Procedure
- 304.7.3 CLOSE_CONNECTION Procedure
- 304.7.4 FLUSH Procedure
- 304.7.5 GET_LINE Function
- 304.7.6 GET_LINE_NCHAR Function
- 304.7.7 GET_RAW Function
- 304.7.8 GET_TEXT Function
- 304.7.9 GET_TEXT_NCHAR Function
- 304.7.10 OPEN_CONNECTION Function
- 304.7.11 READ_LINE Function
- 304.7.12 READ_RAW Function
- 304.7.13 READ_TEXT Function
- 304.7.14 SECURE_CONNECTION Procedure
- 304.7.15 WRITE_LINE Function
- 304.7.16 WRITE_RAW Function
- 304.7.17 WRITE_TEXT Function
- 305 UTL_URL
- 306 WPG_DOCLOAD
- 307 ANYDATA TYPE
-
308
ANYDATASET TYPE
- 308.1 ANYDATASET TYPE Construction
-
308.2
Summary of ANYDATASET TYPE Subprograms
- 308.2.1 ADDINSTANCE Member Procedure
- 308.2.2 BEGINCREATE Static Procedure
- 308.2.3 ENDCREATE Member Procedure
- 308.2.4 GET* Member Functions
- 308.2.5 GETCOUNT Member Function
- 308.2.6 GETINSTANCE Member Function
- 308.2.7 GETTYPE Member Function
- 308.2.8 GETTYPENAME Member Function
- 308.2.9 PIECEWISE Member Procedure
- 308.2.10 SET* Member Procedures
- 309 ANYTYPE TYPE
-
310
Oracle Database Advanced Queuing (AQ) Types
- 310.1 Advanced Queuing (AQ)Types Security Model
-
310.2
Oracle Database Advanced Queuing (AQ) Types —Summary of Types
- 310.2.1 AQ$_AGENT Type
- 310.2.2 AQ$_AGENT_LIST_T Type
- 310.2.3 AQ$_DESCRIPTOR Type
- 310.2.4 AQ$_NTFN_DESCRIPTOR Type
- 310.2.5 AQ$_NTFN_MSGID_ARRAY Type
- 310.2.6 AQ$_POST_INFO Type
- 310.2.7 AQ$_POST_INFO_LIST Type
- 310.2.8 AQ$_PURGE_OPTIONS_T Type
- 310.2.9 AQ$_RECIPIENT_LIST_T Type
- 310.2.10 AQ$_REG_INFO Type
- 310.2.11 AQ$_REG_INFO_LIST Type
- 310.2.12 AQ$_SUBSCRIBER_LIST_T Type
- 310.2.13 DEQUEUE_OPTIONS_T Type
- 310.2.14 ENQUEUE_OPTIONS_T Type
- 310.2.15 QUEUE_PROPS_T Type
- 310.2.16 SEEK_INPUT_T Type
- 310.2.17 SEEK_OUTPUT_T Type
- 310.2.18 SYS.MSG_PROP_T Type
- 310.2.19 MESSAGE_PROPERTIES_T Type
- 310.2.20 MESSAGE_PROPERTIES_ARRAY_T Type
- 310.2.21 MSGID_ARRAY_T Type
- 311 DBFS Content Interface Types
-
312
Database URI TYPEs
- 312.1 Summary of URITYPE Supertype Subprograms
-
312.2
Summary of HTTPURITYPE Subtype Subprograms
- 312.2.1 HttpUriType Subtype CREATEURI
- 312.2.2 HttpUriType Subtype GETBLOB
- 312.2.3 HttpUriType Subtype GETCLOB
- 312.2.4 HttpUriType Subtype GETCONTENTTYPE
- 312.2.5 HttpUriType Subtype GETEXTERNALURL
- 312.2.6 HttpUriType Subtype GETURL
- 312.2.7 HttpUriType Subtype GETXML
- 312.2.8 HttpUriType Subtype HTTPURITYPE
- 312.3 Summary of DBURITYPE Subtype Subprogams
- 312.4 Summary of XDBURITYPE Subtype Subprograms
- 312.5 Summary of URIFACTORY Package Subprograms
-
313
JMS Types
- 313.1 JMS Types Overview
- 313.2 JMS Types Security Model
- 313.3 Java Versus PL/SQL Datatypes
- 313.4 More on Bytes, Stream and Map Messages
- 313.5 Upcasting and Downcasting Between General and Specific Messages
- 313.6 JMS Types Error Reporting
- 313.7 Oracle JMS Type Constants
- 313.8 CONVERT_JMS_SELECTOR
-
313.9
Summary of JMS Types
- 313.9.1 SYS.AQ$_JMS_MESSAGE Type
- 313.9.2 SYS.AQ$_JMS_TEXT_MESSAGE Type
- 313.9.3 SYS.AQ$_JMS_BYTES_MESSAGE Type
- 313.9.4 SYS.AQ$_JMS_MAP_MESSAGE Type
- 313.9.5 SYS.AQ$_JMS_STREAM_MESSAGE Type
- 313.9.6 SYS.AQ$_JMS_OBJECT_MESSAGE Type
- 313.9.7 SYS.AQ$_JMS_NAMEARRAY Type
- 313.9.8 SYS.AQ$_JMS_VALUE Type
- 313.9.9 SYS.AQ$_JMS_EXCEPTION Type
- 314 JSON Data Structures
- 315 Logical Change Record TYPEs
- 316 MGD_ID Package Types
-
317
Rule TYPEs
- 317.1 Rule TYPEs Overview
- 317.2 Rule TYPEs Security Model
-
317.3
Summary of Rule Types
- 317.3.1 RE$ATTRIBUTE_VALUE Type
- 317.3.2 RE$ATTRIBUTE_VALUE_LIST Type
- 317.3.3 RE$COLUMN_VALUE Type
- 317.3.4 RE$COLUMN_VALUE_LIST Type
- 317.3.5 RE$NAME_ARRAY Type
- 317.3.6 RE$NV_ARRAY Type
- 317.3.7 RE$NV_LIST Type
- 317.3.8 RE$NV_NODE Type
- 317.3.9 RE$RULE_HIT Type
- 317.3.10 RE$RULE_HIT_LIST Type
- 317.3.11 RE$RULE_NAME Type
- 317.3.12 RE$RULE_NAME_LIST Type
- 317.3.13 RE$TABLE_ALIAS Type
- 317.3.14 RE$TABLE_ALIAS_LIST Type
- 317.3.15 RE$TABLE_VALUE Type
- 317.3.16 RE$TABLE_VALUE_LIST Type
- 317.3.17 RE$VALUE Type
- 317.3.18 RE$VALUE_LIST Type
- 317.3.19 RE$VARIABLE_TYPE Type
- 317.3.20 RE$VARIABLE_TYPE_LIST Type
- 317.3.21 RE$VARIABLE_VALUE Type
- 317.3.22 RE$VARIABLE_VALUE_LIST Type
-
318
SODA Types
- 318.1 SODA Types Overview
- 318.2 SODA Types Security Model
-
318.3
Summary of SODA Types
-
318.3.1
SODA_Collection_T Type
- 318.3.1.1 CREATE_INDEX Function
- 318.3.1.2 CREATE_VIEW_FROM_DG Function
- 318.3.1.3 DROP_INDEX Function
- 318.3.1.4 FIND Function
- 318.3.1.5 FIND_ONE Function
- 318.3.1.6 GET_DATA_GUIDE Function
- 318.3.1.7 GET_INDEX Function
- 318.3.1.8 GET_METADATA Function
- 318.3.1.9 GET_NAME Function
- 318.3.1.10 INSERT_ONE Function
- 318.3.1.11 INSERT_ONE_AND_GET Function
- 318.3.1.12 LIST_INDEXES Function
- 318.3.1.13 REMOVE_ONE Function
- 318.3.1.14 REPLACE_ONE Function
- 318.3.1.15 REPLACE_ONE_AND_GET Function
- 318.3.1.16 SAVE Function
- 318.3.1.17 SAVE_AND_GET Function
- 318.3.1.18 TRUNCATE Function
-
318.3.2
SODA_Document_T Type
- 318.3.2.1 GET_BLOB Function
- 318.3.2.2 GET_CLOB Function
- 318.3.2.3 GET_CREATED_ON Function
- 318.3.2.4 GET_DATA_TYPE Function
- 318.3.2.5 GET_JSON Function
- 318.3.2.6 GET_KEY Function
- 318.3.2.7 GET_LAST_MODIFIED Function
- 318.3.2.8 GET_MEDIA_TYPE Function
- 318.3.2.9 GET_VARCHAR2 Function
- 318.3.2.10 GET_VERSION Function
- 318.3.2.11 SODA_Document_T Function
-
318.3.3
SODA_OPERATION_T Type
- 318.3.3.1 ACQUIRE_LOCK Function
- 318.3.3.2 AS_OF_SCN Function
- 318.3.3.3 AS_OF_TIMESTAMP Function
- 318.3.3.4 COUNT Function
- 318.3.3.5 FILTER Function
- 318.3.3.6 GET_CURSOR Function
- 318.3.3.7 GET_DATA_GUIDE Function
- 318.3.3.8 GET_ONE Function
- 318.3.3.9 HINT Function
- 318.3.3.10 KEY Function
- 318.3.3.11 KEYS Function
- 318.3.3.12 LIMIT Function
- 318.3.3.13 REMOVE Function
- 318.3.3.14 REPLACE_ONE Function
- 318.3.3.15 REPLACE_ONE_AND_GET Function
- 318.3.3.16 SAMPLE Function
- 318.3.3.17 SKIP Function
- 318.3.3.18 VERSION Function
- 318.3.4 SODA_CURSOR_T Type
-
318.3.1
SODA_Collection_T Type
- 319 UTL Streams Types
-
320
XMLTYPE
-
320.1
Summary of XMLType Subprograms
- 320.1.1 CREATENONSCHEMABASEDXML
- 320.1.2 CREATESCHEMABASEDXML
- 320.1.3 CREATEXML
- 320.1.4 EXISTSNODE
- 320.1.5 EXTRACT
- 320.1.6 GETBLOBVAL
- 320.1.7 GETCLOBVAL
- 320.1.8 GETNAMESPACE
- 320.1.9 GETNUMBERVAL
- 320.1.10 GETROOTELEMENT
- 320.1.11 GETSCHEMAURL
- 320.1.12 GETSTRINGVAL
- 320.1.13 ISFRAGMENT
- 320.1.14 ISSCHEMABASED
- 320.1.15 ISSCHEMAVALID
- 320.1.16 ISSCHEMAVALIDATED
- 320.1.17 SCHEMAVALIDATE
- 320.1.18 SETSCHEMAVALIDATED
- 320.1.19 TOOBJECT
- 320.1.20 TRANSFORM
- 320.1.21 XMLTYPE
-
320.1
Summary of XMLType Subprograms
- Index