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_CLS
- 6 CTX_DDL
- 7 CTX_DOC
- 8 CTX_ENTITY
- 9 CTX_OUTPUT
- 10 CTX_QUERY
- 11 CTX_REPORT
- 12 CTX_THES
- 13 CTX_ULEXER
-
14
DBMS_ADDM
- 14.1 DBMS_ADDM Security Model
-
14.2
Summary of DBMS_ADDM Subprograms
- 14.2.1 ANALYZE_DB Procedure
- 14.2.2 ANALYZE_INST Procedure
- 14.2.3 ANALYZE_PARTIAL Procedure
- 14.2.4 COMPARE_CAPTURE_REPLAY_REPORT Function
- 14.2.5 COMPARE_DATABASES Function
- 14.2.6 COMPARE_INSTANCES Function
- 14.2.7 COMPARE_REPLAY_REPLAY_REPORT Function
- 14.2.8 DELETE Procedure
- 14.2.9 DELETE_FINDING_DIRECTIVE Procedure
- 14.2.10 DELETE_PARAMETER_DIRECTIVE Procedure
- 14.2.11 DELETE_SEGMENT_DIRECTIVE Procedure
- 14.2.12 DELETE_SQL_DIRECTIVE Procedure
- 14.2.13 GET_ASH_QUERY Function
- 14.2.14 GET_REPORT Function
- 14.2.15 INSERT_FINDING_DIRECTIVE Procedure
- 14.2.16 INSERT_PARAMETER_DIRECTIVE Procedure
- 14.2.17 INSERT_SEGMENT_DIRECTIVE Procedure
- 14.2.18 INSERT_SQL_DIRECTIVE Procedure
- 14.2.19 REAL_TIME_ADDM_REPORT Function
- 15 DBMS_ADVANCED_REWRITE
-
16
DBMS_ADVISOR
- 16.1 DBMS_ADVISOR Deprecated Subprograms
- 16.2 DBMS_ADVISOR Security Model
-
16.3
Summary of DBMS_ADVISOR Subprograms
- 16.3.1 ADD_SQLWKLD_REF Procedure
- 16.3.2 ADD_SQLWKLD_STATEMENT Procedure
- 16.3.3 ADD_STS_REF Procedure
- 16.3.4 CANCEL_TASK Procedure
- 16.3.5 COPY_SQLWKLD_TO_STS Procedure
- 16.3.6 CREATE_FILE Procedure
- 16.3.7 CREATE_OBJECT Procedure
- 16.3.8 CREATE_SQLWKLD Procedure
- 16.3.9 CREATE_TASK Procedures
- 16.3.10 DELETE_SQLWKLD Procedure
- 16.3.11 DELETE_SQLWKLD_REF Procedure
- 16.3.12 DELETE_SQLWKLD_STATEMENT Procedure
- 16.3.13 DELETE_STS_REF Procedure
- 16.3.14 DELETE_TASK Procedure
- 16.3.15 EXECUTE_TASK Procedure
- 16.3.16 GET_REC_ATTRIBUTES Procedure
- 16.3.17 GET_TASK_REPORT Function
- 16.3.18 GET_TASK_SCRIPT Function
- 16.3.19 IMPLEMENT_TASK Procedure
- 16.3.20 IMPORT_SQLWKLD_SCHEMA Procedure
- 16.3.21 IMPORT_SQLWKLD_SQLCACHE Procedure
- 16.3.22 IMPORT_SQLWKLD_STS Procedure
- 16.3.23 IMPORT_SQLWKLD_SUMADV Procedure
- 16.3.24 IMPORT_SQLWKLD_USER Procedure
- 16.3.25 INTERRUPT_TASK Procedure
- 16.3.26 MARK_RECOMMENDATION Procedure
- 16.3.27 QUICK_TUNE Procedure
- 16.3.28 RESET_SQLWKLD Procedure
- 16.3.29 RESET_TASK Procedure
- 16.3.30 SET_DEFAULT_SQLWKLD_PARAMETER Procedure
- 16.3.31 SET_DEFAULT_TASK_PARAMETER Procedure
- 16.3.32 SET_SQLWKLD_PARAMETER Procedure
- 16.3.33 SET_TASK_PARAMETER Procedure
- 16.3.34 TUNE_MVIEW Procedure
- 16.3.35 UPDATE_OBJECT Procedure
- 16.3.36 UPDATE_REC_ATTRIBUTES Procedure
- 16.3.37 UPDATE_SQLWKLD_ATTRIBUTES Procedure
- 16.3.38 UPDATE_SQLWKLD_STATEMENT Procedure
- 16.3.39 UPDATE_TASK_ATTRIBUTES Procedure
- 17 DBMS_ALERT
- 18 DBMS_APP_CONT
- 19 DBMS_APP_CONT_ADMIN
- 20 DBMS_APPLICATION_INFO
-
21
DBMS_APPLY_ADM
- 21.1 DBMS_APPLY_ADM Overview
- 21.2 DBMS_APPLY_ADM Security Model
- 21.3 DBMS_APPLY_ADM Deprecated Subprograms
-
21.4
Summary of DBMS_APPLY_ADM Subprograms
- 21.4.1 ALTER_APPLY Procedure
- 21.4.2 CLEAR_KEY_COLUMNS Procedure
- 21.4.3 COMPARE_OLD_VALUES Procedure
- 21.4.4 CREATE_APPLY Procedure
- 21.4.5 CREATE_OBJECT_DEPENDENCY Procedure
- 21.4.6 DELETE_ALL_ERRORS Procedure
- 21.4.7 DELETE_ERROR Procedure
- 21.4.8 DROP_APPLY Procedure
- 21.4.9 DROP_OBJECT_DEPENDENCY Procedure
- 21.4.10 EXECUTE_ALL_ERRORS Procedure
- 21.4.11 EXECUTE_ERROR Procedure
- 21.4.12 GET_ERROR_MESSAGE Function
- 21.4.13 HANDLE_COLLISIONS
- 21.4.14 SET_DML_CONFLICT_HANDLER Procedure
- 21.4.15 SET_DML_HANDLER Procedure
- 21.4.16 SET_ENQUEUE_DESTINATION Procedure
- 21.4.17 SET_EXECUTE Procedure
- 21.4.18 SET_GLOBAL_INSTANTIATION_SCN Procedure
- 21.4.19 SET_KEY_COLUMNS Procedures
- 21.4.20 SET_PARAMETER Procedure
- 21.4.21 SET_REPERROR_HANDLER Procedure
- 21.4.22 SET_SCHEMA_INSTANTIATION_SCN Procedure
- 21.4.23 SET_TABLE_INSTANTIATION_SCN Procedure
- 21.4.24 SET_UPDATE_CONFLICT_HANDLER Procedure
- 21.4.25 SET_VALUE_DEPENDENCY Procedure
- 21.4.26 START_APPLY Procedure
- 21.4.27 STOP_APPLY Procedure
- 22 DBMS_AQ
-
23
DBMS_AQADM
- 23.1 DBMS_AQADM Security Model
- 23.2 DBMS_AQADM Constants
-
23.3
DBMS_AQADM Subprogram Groups
- 23.3.1 DBMS_AQADM Queue Table Subprograms
- 23.3.2 DBMS_AQADM Privilege Subprograms
- 23.3.3 DBMS_AQADM Queue Subprograms
- 23.3.4 DBMS_AQADM Subscriber Subprograms
- 23.3.5 DBMS_AQADM Propagation Subprograms
- 23.3.6 DBMS_AQADM Miscellaneous Subprograms
- 23.3.7 DBMS_AQADM Agent Subprograms
- 23.3.8 DBMS_AQADM Alias Subprograms
-
23.4
Summary of DBMS_AQADM Subprograms
- 23.4.1 ADD_ALIAS_TO_LDAP Procedure
- 23.4.2 ADD_SUBSCRIBER Procedure
- 23.4.3 ALTER_AQ_AGENT Procedure
- 23.4.4 ALTER_PROPAGATION_SCHEDULE Procedure
- 23.4.5 ALTER_QUEUE Procedure
- 23.4.6 ALTER_QUEUE_TABLE Procedure
- 23.4.7 ALTER_SHARDED_QUEUE Procedure
- 23.4.8 ALTER_SUBSCRIBER Procedure
- 23.4.9 CREATE_AQ_AGENT Procedure
- 23.4.10 CREATE_NP_QUEUE Procedure
- 23.4.11 CREATE_QUEUE Procedure
- 23.4.12 CREATE_QUEUE_TABLE Procedure
- 23.4.13 CREATE_SHARDED_QUEUE Procedure
- 23.4.14 CREATE_EXCEPTION_QUEUE Procedure
- 23.4.15 DEL_ALIAS_FROM_LDAP Procedure
- 23.4.16 DISABLE_DB_ACCESS Procedure
- 23.4.17 DISABLE_PROPAGATION_SCHEDULE Procedure
- 23.4.18 DROP_AQ_AGENT Procedure
- 23.4.19 DROP_QUEUE Procedure
- 23.4.20 DROP_QUEUE_TABLE Procedure
- 23.4.21 DROP_SHARDED_QUEUE Procedure
- 23.4.22 ENABLE_DB_ACCESS Procedure
- 23.4.23 ENABLE_JMS_TYPES Procedure
- 23.4.24 ENABLE_PROPAGATION_SCHEDULE Procedure
- 23.4.25 GET_MAX_STREAMS_POOL Procedure
- 23.4.26 GET_MIN_STREAMS_POOL Procedure
- 23.4.27 GET_QUEUE_PARAMETER Procedure
- 23.4.28 GET_WATERMARK Procedure
- 23.4.29 GRANT_QUEUE_PRIVILEGE Procedure
- 23.4.30 GRANT_SYSTEM_PRIVILEGE Procedure
- 23.4.31 MIGRATE_QUEUE_TABLE Procedure
- 23.4.32 PURGE_QUEUE_TABLE Procedure
- 23.4.33 QUEUE_SUBSCRIBERS Function
- 23.4.34 REMOVE_SUBSCRIBER Procedure
- 23.4.35 REVOKE_QUEUE_PRIVILEGE Procedure
- 23.4.36 REVOKE_SYSTEM_PRIVILEGE Procedure
- 23.4.37 SCHEDULE_PROPAGATION Procedure
- 23.4.38 SET_QUEUE_PARAMETER Procedure
- 23.4.39 SET_MAX_STREAMS_POOL Procedure
- 23.4.40 SET_MIN_STREAMS_POOL Procedure
- 23.4.41 SET_WATERMARK Procedure
- 23.4.42 START_QUEUE Procedure
- 23.4.43 STOP_QUEUE Procedure
- 23.4.44 UNSCHEDULE_PROPAGATION Procedure
- 23.4.45 UNSET_QUEUE_PARAMETER Procedure
- 23.4.46 VERIFY_QUEUE_TYPES Procedure
- 24 DBMS_AQELM
- 25 DBMS_AQIN
- 26 DBMS_ASSERT
-
27
DBMS_AUDIT_MGMT
- 27.1 DBMS_AUDIT_MGMT Overview
- 27.2 DBMS_AUDIT_MGMT Deprecated Subprograms
- 27.3 DBMS_AUDIT_MGMT Security Model
- 27.4 DBMS_AUDIT_MGMT Constants
- 27.5 DBMS_AUDIT_MGMT Views
- 27.6 DBMS_AUDIT_MGMT Subprogram Groups
-
27.7
Summary of DBMS_AUDIT_MGMT Subprograms
- 27.7.1 ALTER_PARTITION_INTERVAL Procedure
- 27.7.2 CLEAN_AUDIT_TRAIL Procedure
- 27.7.3 CLEAR_AUDIT_TRAIL_PROPERTY Procedure
- 27.7.4 CLEAR_LAST_ARCHIVE_TIMESTAMP Procedure
- 27.7.5 CREATE_PURGE_JOB Procedure
- 27.7.6 DEINIT_CLEANUP Procedure
- 27.7.7 DROP_OLD_UNIFIED_AUDIT_TABLES Procedure
- 27.7.8 DROP_PURGE_JOB Procedure
- 27.7.9 FLUSH_UNIFIED_AUDIT_TRAIL Procedure
- 27.7.10 GET_AUDIT_COMMIT_DELAY Function
- 27.7.11 GET_ AUDIT_TRAIL_PROPERTY_VALUE Function
- 27.7.12 GET_LAST_ARCHIVE_TIMESTAMP Function
- 27.7.13 INIT_CLEANUP Procedure
- 27.7.14 IS_CLEANUP_INITIALIZED Function
- 27.7.15 LOAD_UNIFIED_AUDIT_FILES Procedure
- 27.7.16 SET_AUDIT_TRAIL_LOCATION Procedure
- 27.7.17 SET_AUDIT_TRAIL_PROPERTY Procedure
- 27.7.18 SET_LAST_ARCHIVE_TIMESTAMP Procedure
- 27.7.19 SET_PURGE_JOB_INTERVAL Procedure
- 27.7.20 SET_PURGE_JOB_STATUS Procedure
- 27.7.21 TRANSFER_UNIFIED_AUDIT_RECORDS Procedure
- 28 DBMS_AUDIT_UTIL
- 29 DBMS_AUTO_SQLTUNE
- 30 DBMS_AUTO_INDEX
- 31 DBMS_AUTO_REPORT
- 32 DBMS_AUTO_TASK_ADMIN
- 33 DBMS_AW_STATS
- 34 DBMS_BLOCKCHAIN_TABLE
-
35
DBMS_CAPTURE_ADM
- 35.1 DBMS_CAPTURE_ADM Overview
- 35.2 DBMS_CAPTURE_ADM Security Model
-
35.3
Summary of DBMS_CAPTURE_ADM Subprograms
- 35.3.1 ABORT_GLOBAL_INSTANTIATION Procedure
- 35.3.2 ABORT_SCHEMA_INSTANTIATION Procedure
- 35.3.3 ABORT_SYNC_INSTANTIATION Procedure
- 35.3.4 ABORT_TABLE_INSTANTIATION Procedure
- 35.3.5 ALTER_CAPTURE Procedure
- 35.3.6 ALTER_SYNC_CAPTURE Procedure
- 35.3.7 BUILD Procedure
- 35.3.8 CREATE_CAPTURE Procedure
- 35.3.9 CREATE_SYNC_CAPTURE Procedure
- 35.3.10 DROP_CAPTURE Procedure
- 35.3.11 INCLUDE_EXTRA_ATTRIBUTE Procedure
- 35.3.12 PREPARE_GLOBAL_INSTANTIATION Procedure
- 35.3.13 PREPARE_SCHEMA_INSTANTIATION Procedure
- 35.3.14 PREPARE_SYNC_INSTANTIATION Function
- 35.3.15 PREPARE_TABLE_INSTANTIATION Procedure
- 35.3.16 SET_PARAMETER Procedure
- 35.3.17 START_CAPTURE Procedure
- 35.3.18 STOP_CAPTURE Procedure
-
36
DBMS_CLOUD
- 36.1 DBMS_CLOUD Overview
- 36.2 Installing the DBMS_CLOUD Package
- 36.3 DBMS_CLOUD Security Model
- 36.4 DBMS_CLOUD Exceptions
-
36.5
Summary of DBMS_CLOUD
Subprograms
- 36.5.1 COPY_DATA Procedure
- 36.5.2 COPY_DATA Procedure for Avro or Parquet Files
- 36.5.3 CREATE_CREDENTIAL Procedure
- 36.5.4 CREATE_EXTERNAL_TABLE Procedure
- 36.5.5 CREATE_EXTERNAL_TABLE Procedure for Avro or Parquet Files
- 36.5.6 CREATE_EXTERNAL_PART_TABLE Procedure
- 36.5.7 CREATE_HYBRID_PART_TABLE Procedure
- 36.5.8 DELETE_ALL_OPERATIONS Procedure
- 36.5.9 DELETE_FILE Procedure
- 36.5.10 DELETE_OBJECT Procedure
- 36.5.11 DROP_CREDENTIAL Procedure
- 36.5.12 GET_OBJECT Procedure and Function
- 36.5.13 LIST_FILES Function
- 36.5.14 LIST_OBJECTS Function
- 36.5.15 PUT_OBJECT Procedure
- 36.5.16 UPDATE_CREDENTIAL Procedure
- 36.5.17 VALIDATE_EXTERNAL_TABLE Procedure
- 36.5.18 VALIDATE_EXTERNAL_PART_TABLE Procedure
- 36.5.19 VALIDATE_HYBRID_PART_TABLE Procedure
-
36.6
DBMS_CLOUD Package File URI Formats
- 36.6.1 Oracle Cloud Infrastructure Object Storage Native URI Format
- 36.6.2 Oracle Cloud Infrastructure Object Storage Swift URI Format
- 36.6.3 Oracle Cloud Infrastructure Object Storage URI Format Using Pre-Authenticated Request URL
- 36.6.4 URI Format Using Public URL
- 36.6.5 Oracle Cloud Infrastructure Object Storage Classic URI Format
- 36.6.6 Amazon S3 URI Format
- 36.6.7 Azure Blob Storage URI Format
- 36.7 DBMS_CLOUD Package Format Options
-
36.8
DBMS_CLOUD Avro and Parquet Support
- 36.8.1 DBMS_CLOUD Package Format Options for Avro or Parquet
- 36.8.2 DBMS_CLOUD Package Avro to Oracle Data Type Mapping
- 36.8.3 DBMS_CLOUD Package Parquet to Oracle Data Type Mapping
- 36.8.4 DBMS_CLOUD Package Avro and Parquet Complex Types
- 36.8.5 DBMS_CLOUD Package Avro and Parquet to Oracle Column Name Mapping
- 37 DBMS_COMPARISON
- 38 DBMS_COMPRESSION
- 39 DBMS_CONNECTION_POOL
-
40
DBMS_CQ_NOTIFICATION
- 40.1 DBMS_CQ_NOTIFICATION Overview
- 40.2 DBMS_CQ_NOTIFICATION Security Model
- 40.3 DBMS_CQ_NOTIFICATION Constants
- 40.4 DBMS_CQ_NOTIFICATION Operational Notes
- 40.5 DBMS_CQ_NOTIFICATION Examples
-
40.6
DBMS_CQ_NOTIFICATION Data Structures
- 40.6.1 CQ_NOTIFICATION$_DESCRIPTOR Object Type
- 40.6.2 CQ_NOTIFICATION$_QUERY Object Type
- 40.6.3 CQ_NOTIFICATION$_QUERY_ARRAY Object (Array) Type
- 40.6.4 CQ_NOTIFICATION$_TABLE Object Type
- 40.6.5 CQ_NOTIFICATION$_TABLE_ARRAY Object (Array) Type
- 40.6.6 CQ_NOTIFICATION$_ROW Object Type
- 40.6.7 CQ_NOTIFICATION$_ROW_ARRAY Object (Array) Type
- 40.6.8 CQ_NOTIFICATION$_REG_INFO Object Type
- 40.7 Summary of DBMS_CQ_NOTIFICATION Subprograms
- 41 DBMS_CREDENTIAL
-
42
DBMS_CRYPTO
- 42.1 DBMS_CRYPTO Overview
- 42.2 DBMS_CRYPTO Security Model
- 42.3 DBMS_CRYPTO Datatypes
- 42.4 DBMS_CRYPTO Algorithms
- 42.5 DBMS_CRYPTO Restrictions
- 42.6 DBMS_CRYPTO Exceptions
- 42.7 DBMS_CRYPTO Operational Notes
- 42.8 DBMS_CRYPTO Examples
-
42.9
Summary of DBMS_CRYPTO Subprograms
- 42.9.1 DECRYPT Function
- 42.9.2 DECRYPT Procedures
- 42.9.3 ENCRYPT Function
- 42.9.4 ENCRYPT Procedures
- 42.9.5 HASH Function
- 42.9.6 MAC Function
- 42.9.7 PKDECRYPT Function
- 42.9.8 PKENCRYPT Function
- 42.9.9 RANDOMBYTES Function
- 42.9.10 RANDOMINTEGER Function
- 42.9.11 RANDOMNUMBER Function
- 42.9.12 SIGN Function
- 42.9.13 VERIFY Function
- 43 DBMS_CSX_ADMIN
-
44
DBMS_CUBE
- 44.1 Using DBMS_CUBE
- 44.2 Using SQL Aggregation Management
- 44.3 Upgrading 10g Analytic Workspaces
-
44.4
Summary of DBMS_CUBE Subprograms
- 44.4.1 BUILD Procedure
- 44.4.2 CREATE_EXPORT_OPTIONS Procedure
- 44.4.3 CREATE_IMPORT_OPTIONS Procedure
- 44.4.4 CREATE_MVIEW Function
- 44.4.5 DERIVE_FROM_MVIEW Function
- 44.4.6 DROP_MVIEW Procedure
- 44.4.7 EXPORT_XML Procedure
- 44.4.8 EXPORT_XML_TO_FILE Procedure
- 44.4.9 IMPORT_XML Procedure
- 44.4.10 INITIALIZE_CUBE_UPGRADE Procedure
- 44.4.11 REFRESH_MVIEW Procedure
- 44.4.12 UPGRADE_AW Procedure
- 44.4.13 VALIDATE_XML Procedure
- 45 DBMS_CUBE_ADVISE
-
46
DBMS_CUBE_LOG
-
46.1
Using DBMS_CUBE_LOG
- 46.1.1 DBMS_CUBE_LOG — Logging Types
- 46.1.2 DBMS_CUBE_LOG — Logging Targets
- 46.1.3 DBMS_CUBE_LOG — Verbosity Levels
- 46.1.4 DBMS_CUBE_LOG Security Model
- 46.1.5 DBMS_CUBE_LOG — Creating Cube Logs
- 46.1.6 DBMS_CUBE_LOG — Cube Build Log
- 46.1.7 DBMS_CUBE_LOG — Cube Dimension Compile Log
- 46.1.8 DBMS_CUBE_LOG — Cube Operations Log
- 46.1.9 DBMS_CUBE_LOG — Cube Rejected Records Log
-
46.2
Summary of DBMS_CUBE_LOG Subprograms
- 46.2.1 DEFAULT_NAME Function
- 46.2.2 DISABLE Procedure
- 46.2.3 ENABLE Procedure
- 46.2.4 FLUSH Procedure
- 46.2.5 GET_LOG Procedure
- 46.2.6 GET_LOG_SPEC Function
- 46.2.7 GET_PARAMETER Function
- 46.2.8 LEVEL_HIGH Function
- 46.2.9 LEVEL_HIGHEST Function
- 46.2.10 LEVEL_LOW Function
- 46.2.11 LEVEL_LOWEST Function
- 46.2.12 LEVEL_MEDIUM Function
- 46.2.13 SET_LOG_SPEC Procedure
- 46.2.14 SET_PARAMETER Procedure
- 46.2.15 TABLE_CREATE Procedure
- 46.2.16 TARGET_FILE Function
- 46.2.17 TARGET_LOB Function
- 46.2.18 TARGET_TABLE Function
- 46.2.19 TARGET_TRACE Function
- 46.2.20 TYPE_BUILD Function
- 46.2.21 TYPE_DIMENSION_COMPILE Function
- 46.2.22 TYPE_OPERATIONS Function
- 46.2.23 TYPE_REJECTED_RECORDS Function
- 46.2.24 VERSION Function
-
46.1
Using DBMS_CUBE_LOG
-
47
DBMS_DATA_MINING
- 47.1 DBMS_DATA_MINING Overview
- 47.2 DBMS_DATA_MINING Security Model
- 47.3 DBMS_DATA_MINING — Mining Functions
-
47.4
DBMS_DATA_MINING — Model Settings
- 47.4.1 DBMS_DATA_MINING — Algorithm Names
- 47.4.2 DBMS_DATA_MINING — Automatic Data Preparation
- 47.4.3 DBMS_DATA_MINING — Mining Function Settings
- 47.4.4 DBMS_DATA_MINING — Global Settings
- 47.4.5 DBMS_DATA_MINING — Algorithm Settings: ALGO_EXTENSIBLE_LANG
- 47.4.6 DBMS_DATA_MINING — Algorithm Settings: CUR Matrix Decomposition
- 47.4.7 DBMS_DATA_MINING — Algorithm Settings: Decision Tree
- 47.4.8 DBMS_DATA_MINING — Algorithm Settings: Expectation Maximization
- 47.4.9 DBMS_DATA_MINING — Algorithm Settings: Explicit Semantic Analysis
- 47.4.10 DBMS_DATA_MINING — Algorithm Settings: Exponential Smoothing
- 47.4.11 DBMS_DATA_MINING — Algorithm Settings: Generalized Linear Models
- 47.4.12 DBMS_DATA_MINING — Algorithm Settings: k-Means
- 47.4.13 DBMS_DATA_MINING — Algorithm Settings: Naive Bayes
- 47.4.14 DBMS_DATA_MINING — Algorithm Settings: Neural Network
- 47.4.15 DBMS_DATA_MINING — Algorithm Settings: Non-Negative Matrix Factorization
- 47.4.16 DBMS_DATA_MINING — Algorithm Settings: O-Cluster
- 47.4.17 DBMS_DATA_MINING — Algorithm Settings: Random Forest
- 47.4.18 DBMS_DATA_MINING — Algorithm Constants and Settings: Singular Value Decomposition
- 47.4.19 DBMS_DATA_MINING — Algorithm Settings: Support Vector Machine
- 47.5 DBMS_DATA_MINING — Solver Settings
- 47.6 DBMS_DATA_MINING Datatypes
-
47.7
Summary of DBMS_DATA_MINING Subprograms
- 47.7.1 ADD_COST_MATRIX Procedure
- 47.7.2 ADD_PARTITION Procedure
- 47.7.3 ALTER_REVERSE_EXPRESSION Procedure
- 47.7.4 APPLY Procedure
- 47.7.5 COMPUTE_CONFUSION_MATRIX Procedure
- 47.7.6 COMPUTE_CONFUSION_MATRIX_PART Procedure
- 47.7.7 COMPUTE_LIFT Procedure
- 47.7.8 COMPUTE_LIFT_PART Procedure
- 47.7.9 COMPUTE_ROC Procedure
- 47.7.10 COMPUTE_ROC_PART Procedure
- 47.7.11 CREATE_MODEL Procedure
- 47.7.12 CREATE_MODEL2 Procedure
- 47.7.13 Create Model Using Registration Information
- 47.7.14 DROP_ALGORITHM Procedure
- 47.7.15 DROP_PARTITION Procedure
- 47.7.16 DROP_MODEL Procedure
- 47.7.17 EXPORT_MODEL Procedure
- 47.7.18 EXPORT_SERMODEL Procedure
- 47.7.19 FETCH_JSON_SCHEMA Procedure
- 47.7.20 GET_ASSOCIATION_RULES Function
- 47.7.21 GET_FREQUENT_ITEMSETS Function
- 47.7.22 GET_MODEL_COST_MATRIX Function
- 47.7.23 GET_MODEL_DETAILS_AI Function
- 47.7.24 GET_MODEL_DETAILS_EM Function
- 47.7.25 GET_MODEL_DETAILS_EM_COMP Function
- 47.7.26 GET_MODEL_DETAILS_EM_PROJ Function
- 47.7.27 GET_MODEL_DETAILS_GLM Function
- 47.7.28 GET_MODEL_DETAILS_GLOBAL Function
- 47.7.29 GET_MODEL_DETAILS_KM Function
- 47.7.30 GET_MODEL_DETAILS_NB Function
- 47.7.31 GET_MODEL_DETAILS_NMF Function
- 47.7.32 GET_MODEL_DETAILS_OC Function
- 47.7.33 GET_MODEL_SETTINGS Function
- 47.7.34 GET_MODEL_SIGNATURE Function
- 47.7.35 GET_MODEL_DETAILS_SVD Function
- 47.7.36 GET_MODEL_DETAILS_SVM Function
- 47.7.37 GET_MODEL_DETAILS_XML Function
- 47.7.38 GET_MODEL_TRANSFORMATIONS Function
- 47.7.39 GET_TRANSFORM_LIST Procedure
- 47.7.40 IMPORT_MODEL Procedure
- 47.7.41 IMPORT_SERMODEL Procedure
- 47.7.42 JSON Schema for R Extensible Algorithm
- 47.7.43 REGISTER_ALGORITHM Procedure
- 47.7.44 RANK_APPLY Procedure
- 47.7.45 REMOVE_COST_MATRIX Procedure
- 47.7.46 RENAME_MODEL Procedure
-
48
DBMS_DATA_MINING_TRANSFORM
- 48.1 DBMS_DATA_MINING_TRANSFORM Overview
- 48.2 DBMS_DATA_MINING_TRANSFORM Operational Notes
- 48.3 DBMS_DATA_MINING_TRANSFORM Security Model
- 48.4 DBMS_DATA_MINING_TRANSFORM Datatypes
- 48.5 DBMS_DATA_MINING_TRANSFORM Constants
-
48.6
Summary of DBMS_DATA_MINING_TRANSFORM Subprograms
- 48.6.1 CREATE_BIN_CAT Procedure
- 48.6.2 CREATE_BIN_NUM Procedure
- 48.6.3 CREATE_CLIP Procedure
- 48.6.4 CREATE_COL_REM Procedure
- 48.6.5 CREATE_MISS_CAT Procedure
- 48.6.6 CREATE_MISS_NUM Procedure
- 48.6.7 CREATE_NORM_LIN Procedure
- 48.6.8 DESCRIBE_STACK Procedure
- 48.6.9 GET_EXPRESSION Function
- 48.6.10 INSERT_AUTOBIN_NUM_EQWIDTH Procedure
- 48.6.11 INSERT_BIN_CAT_FREQ Procedure
- 48.6.12 INSERT_BIN_NUM_EQWIDTH Procedure
- 48.6.13 INSERT_BIN_NUM_QTILE Procedure
- 48.6.14 INSERT_BIN_SUPER Procedure
- 48.6.15 INSERT_CLIP_TRIM_TAIL Procedure
- 48.6.16 INSERT_CLIP_WINSOR_TAIL Procedure
- 48.6.17 INSERT_MISS_CAT_MODE Procedure
- 48.6.18 INSERT_MISS_NUM_MEAN Procedure
- 48.6.19 INSERT_NORM_LIN_MINMAX Procedure
- 48.6.20 INSERT_NORM_LIN_SCALE Procedure
- 48.6.21 INSERT_NORM_LIN_ZSCORE Procedure
- 48.6.22 SET_EXPRESSION Procedure
- 48.6.23 SET_TRANSFORM Procedure
- 48.6.24 STACK_BIN_CAT Procedure
- 48.6.25 STACK_BIN_NUM Procedure
- 48.6.26 STACK_CLIP Procedure
- 48.6.27 STACK_COL_REM Procedure
- 48.6.28 STACK_MISS_CAT Procedure
- 48.6.29 STACK_MISS_NUM Procedure
- 48.6.30 STACK_NORM_LIN Procedure
- 48.6.31 XFORM_BIN_CAT Procedure
- 48.6.32 XFORM_BIN_NUM Procedure
- 48.6.33 XFORM_CLIP Procedure
- 48.6.34 XFORM_COL_REM Procedure
- 48.6.35 XFORM_EXPR_NUM Procedure
- 48.6.36 XFORM_EXPR_STR Procedure
- 48.6.37 XFORM_MISS_CAT Procedure
- 48.6.38 XFORM_MISS_NUM Procedure
- 48.6.39 XFORM_NORM_LIN Procedure
- 48.6.40 XFORM_STACK Procedure
-
49
DBMS_DATAPUMP
- 49.1 DBMS_DATAPUMP Overview
- 49.2 DBMS_DATAPUMP Security Model
- 49.3 DBMS_DATAPUMP Constants
- 49.4 DBMS_DATAPUMP Data Structures
-
49.5
Summary of DBMS_DATAPUMP Subprograms
- 49.5.1 ADD_FILE Procedure
- 49.5.2 ATTACH Function
- 49.5.3 DATA_FILTER Procedures
- 49.5.4 DATA_REMAP Procedure
- 49.5.5 DETACH Procedure
- 49.5.6 GET_DUMPFILE_INFO Procedure
- 49.5.7 GET_STATUS Procedure
- 49.5.8 LOG_ENTRY Procedure
- 49.5.9 METADATA_FILTER Procedure
- 49.5.10 METADATA_REMAP Procedure
- 49.5.11 METADATA_TRANSFORM Procedure
- 49.5.12 OPEN Function
- 49.5.13 SET_PARALLEL Procedure
- 49.5.14 SET_PARAMETER Procedures
- 49.5.15 START_JOB Procedure
- 49.5.16 STOP_JOB Procedure
- 49.5.17 WAIT_FOR_JOB Procedure
- 50 DBMS_DB_VERSION
- 51 DBMS_DBCOMP
-
52
DBMS_DBFS_CONTENT
- 52.1 DBMS_DBFS_CONTENT Overview
- 52.2 DBMS_DBFS_CONTENT Security Model
- 52.3 DBMS_DBFS_CONTENT Constants
- 52.4 Exceptions
- 52.5 DBMS_DBFS_CONTENT Operational Notes
-
52.6
DBMS_DBFS_CONTENT Data Structures
- 52.6.1 DBMS_DBFS_CONTENT FEATURE_T Record Type
- 52.6.2 DBMS_DBFS_CONTENT MOUNT_T Record Type
- 52.6.3 DBMS_DBFS_CONTENT PATH_ITEM_T Record Type
- 52.6.4 DBMS_DBFS_CONTENT PROP_ITEM_T Record Type
- 52.6.5 PROPERTY_T Record Type
- 52.6.6 DBMS_DBFS_CONTENT STORE_T Record Type
- 52.6.7 DBMS_DBFS_CONTENT FEATURES_T Table Type
- 52.6.8 MOUNTS_T Table Type
- 52.6.9 DBMS_DBFS_CONTENT PATH_ITEMS_T Table Type
- 52.6.10 DBMS_DBFS_CONTENT PROP_ITEMS_T Table Type
- 52.6.11 DBMS_DBFS_CONTENT PROPERTIES_T Table Type
- 52.6.12 STORES_T Table Type
-
52.7
Summary of DBMS_DBFS_CONTENT Subprograms
- 52.7.1 CHECKACCESS Function
- 52.7.2 CHECKSPI Functions and Procedures
- 52.7.3 CREATEDIRECTORY Procedures
- 52.7.4 CREATEFILE Procedures
- 52.7.5 CREATELINK Procedures
- 52.7.6 CREATEREFERENCE Procedures
- 52.7.7 DECODEFEATURES Function
- 52.7.8 DELETECONTENT Procedure
- 52.7.9 DELETEDIRECTORY Procedure
- 52.7.10 DELETEFILE Procedure
- 52.7.11 FEATURENAME Function
- 52.7.12 FLUSHSTATS Function
- 52.7.13 GETDEFAULTACL Procedure
- 52.7.14 GETDEFAULTASOF Procedure
- 52.7.15 GETDEFAULTCONTEXT Procedure
- 52.7.16 GETDEFAULTOWNER Procedure
- 52.7.17 GETDEFAULTPRINCIPAL Procedure
- 52.7.18 GETFEATURESBYMOUNT Function
- 52.7.19 GETFEATURESBYNAME Function
- 52.7.20 GETFEATURESBYPATH Function
- 52.7.21 GETPATH Procedures
- 52.7.22 GETPATHBYMOUNTID Function
- 52.7.23 GETPATHBYSTOREID Function
- 52.7.24 GETPATHNOWAIT Procedures
- 52.7.25 GETSTOREBYMOUNT Function
- 52.7.26 GETSTOREBYNAME Function
- 52.7.27 GETSTOREBYPATH Function
- 52.7.28 GETSTATS Procedure
- 52.7.29 GETTRACE Function
- 52.7.30 GETVERSION Function
- 52.7.31 ISPATHLOCKED Procedure
- 52.7.32 LIST Function
- 52.7.33 LISTALLPROPERTIES Function
- 52.7.34 LISTALLCONTENT Function
- 52.7.35 LISTMOUNTS Function
- 52.7.36 LISTSTORES Function
- 52.7.37 LOCKPATH Procedure
- 52.7.38 MOUNTSTORE Procedure
- 52.7.39 NORMALIZEPATH Functions
- 52.7.40 PROPANY Functions
- 52.7.41 PROPERTIESH2T Function
- 52.7.42 PROPERTIEST2H Function
- 52.7.43 PROPNUMBER Function
- 52.7.44 PROPRAW Function
- 52.7.45 PROPTIMESTAMP Function
- 52.7.46 PROPVARCHAR2 Function
- 52.7.47 PURGEALL Procedure
- 52.7.48 PURGEPATH Procedure
- 52.7.49 PUTPATH Procedures
- 52.7.50 REGISTERSTORE Procedure
- 52.7.51 RENAMEPATH Procedures
- 52.7.52 RESTOREALL Procedure
- 52.7.53 RESTOREPATH Procedure
- 52.7.54 SETDEFAULTACL Procedure
- 52.7.55 SETDEFAULTASOF Procedure
- 52.7.56 SETDEFAULTCONTEXT Procedure
- 52.7.57 SETDEFAULTOWNER Procedure
- 52.7.58 SETDEFAULTPRINCIPAL Procedure
- 52.7.59 SETPATH Procedures
- 52.7.60 SETSTATS Procedure
- 52.7.61 SETTRACE Procedure
- 52.7.62 SPACEUSAGE Procedure
- 52.7.63 TRACE Procedure
- 52.7.64 TRACEENABLED Function
- 52.7.65 UNLOCKPATH Procedure
- 52.7.66 UNMOUNTSTORE Procedure
- 52.7.67 UNREGISTERSTORE Procedure
-
53
DBMS_DBFS_CONTENT_SPI
- 53.1 ODBMS_DBFS_CONTENT_SPI Overview
- 53.2 DBMS_DBFS_CONTENT_SPI Security Model
- 53.3 DBMS_DBFS_CONTENT_SPI Operational Notes
-
53.4
Summary of DBMS_DBFS_CONTENT_SPI Subprograms
- 53.4.1 CHECKACCESS Function
- 53.4.2 CREATEDIRECTORY Procedure
- 53.4.3 CREATEFILE Procedure
- 53.4.4 CREATELINK Procedure
- 53.4.5 CREATEREFERENCE Procedure
- 53.4.6 DELETECONTENT Procedure
- 53.4.7 DELETEDIRECTORY Procedure
- 53.4.8 DELETEFILE Procedure
- 53.4.9 GETFEATURES Function
- 53.4.10 GETPATH Procedures
- 53.4.11 GETPATHBYSTOREID Function
- 53.4.12 GETPATHNOWAIT Procedure
- 53.4.13 GETSTOREID Function
- 53.4.14 GETVERSION Function
- 53.4.15 ISPATHLOCKED Procedure
- 53.4.16 LIST Function
- 53.4.17 LOCKPATH Procedure
- 53.4.18 PURGEALL Procedure
- 53.4.19 PURGEPATH Procedure
- 53.4.20 PUTPATH Procedures
- 53.4.21 RENAMEPATH Procedure
- 53.4.22 RESTOREALL Procedure
- 53.4.23 RESTOREPATH Procedure
- 53.4.24 SEARCH Function
- 53.4.25 SETPATH Procedure
- 53.4.26 SPACEUSAGE Procedure
- 53.4.27 UNLOCKPATH Procedure
-
54
DBMS_DBFS_HS
- 54.1 DBMS_DBFS_HS Overview
- 54.2 DBMS_DBFS_HS Security Model
- 54.3 DBMS_DBFS_HS Constants
- 54.4 DBMS_DBFS_HS Operational Notes
-
54.5
Summary of DBMS_DBFS_HS Subprograms
- 54.5.1 CLEANUPUNUSEDBACKUPFILES Procedure
- 54.5.2 CREATEBUCKET Procedure
- 54.5.3 CREATESTORE Procedure
- 54.5.4 DEREGSTORECOMMAND Function
- 54.5.5 DROPSTORE Procedure
- 54.5.6 FLUSHCACHE Procedure
- 54.5.7 GETSTOREPROPERTY Function
- 54.5.8 RECONFIGCACHE Procedure
- 54.5.9 REGISTERSTORECOMMAND Procedure
- 54.5.10 SENDCOMMAND Procedure
- 54.5.11 SETSTOREPROPERTY Procedure
- 54.5.12 STOREPUSH Procedure
- 55 DBMS_DBFS_SFS
- 56 DBMS_DDL
-
57
DBMS_DEBUG
- 57.1 DBMS_DEBUG Overview
- 57.2 DBMS_DEBUG Constants
- 57.3 DBMS_DEBUG Variables
- 57.4 DBMS_DEBUG Exceptions
- 57.5 DBMS_DEBUG Operational Notes
- 57.6 DBMS_DEBUG Data Structures
-
57.7
Summary of DBMS_DEBUG Subprograms
- 57.7.1 ATTACH_SESSION Procedure
- 57.7.2 CONTINUE Function
- 57.7.3 DEBUG_OFF Procedure
- 57.7.4 DEBUG_ON Procedure
- 57.7.5 DELETE_BREAKPOINT Function
- 57.7.6 DELETE_OER_BREAKPOINT Function
- 57.7.7 DETACH_SESSION Procedure
- 57.7.8 DISABLE_BREAKPOINT Function
- 57.7.9 ENABLE_BREAKPOINT Function
- 57.7.10 EXECUTE Procedure
- 57.7.11 GET_INDEXES Function
- 57.7.12 GET_MORE_SOURCE Procedure
- 57.7.13 GET_LINE_MAP Function
- 57.7.14 GET_RUNTIME_INFO Function
- 57.7.15 GET_TIMEOUT_BEHAVIOUR Function
- 57.7.16 GET_VALUE Function
- 57.7.17 INITIALIZE Function
- 57.7.18 PING Procedure
- 57.7.19 PRINT_BACKTRACE Procedure
- 57.7.20 PRINT_INSTANTIATIONS Procedure
- 57.7.21 PROBE_VERSION Procedure
- 57.7.22 SELF_CHECK Procedure
- 57.7.23 SET_BREAKPOINT Function
- 57.7.24 SET_OER_BREAKPOINT Function
- 57.7.25 SET_TIMEOUT Function
- 57.7.26 SET_TIMEOUT_BEHAVIOUR Procedure
- 57.7.27 SET_VALUE Function
- 57.7.28 SHOW_BREAKPOINTS Procedures
- 57.7.29 SHOW_FRAME_SOURCE Procedure
- 57.7.30 SHOW_SOURCE Procedures
- 57.7.31 SYNCHRONIZE Function
- 57.7.32 TARGET_PROGRAM_RUNNING Procedure
- 58 DBMS_DEBUG_JDWP
- 59 DBMS_DEBUG_JDWP_CUSTOM
- 60 DBMS_DESCRIBE
- 61 DBMS_DG
- 62 DBMS_DIMENSION
- 63 DBMS_DISTRIBUTED_TRUST_ADMIN
- 64 DBMS_DNFS
-
65
DBMS_DST
- 65.1 DBMS_DST Overview
- 65.2 DBMS_DST Security Model
- 65.3 DBMS_DST Views
-
65.4
Summary of DBMS_DST Subprograms
- 65.4.1 BEGIN_PREPARE Procedure
- 65.4.2 BEGIN_UPGRADE Procedure
- 65.4.3 CREATE_AFFECTED_TABLE Procedure
- 65.4.4 CREATE_ERROR_TABLE Procedure
- 65.4.5 CREATE_TRIGGER_TABLE Procedure
- 65.4.6 END_PREPARE Procedure
- 65.4.7 END_UPGRADE Procedure
- 65.4.8 FIND_AFFECTED_TABLES Procedure
- 65.4.9 UPGRADE_DATABASE Procedure
- 65.4.10 UPGRADE_SCHEMA Procedure
- 65.4.11 UPGRADE_TABLE Procedure
- 66 DBMS_EDITIONS_UTILITIES
-
67
DBMS_EPG
- 67.1 DBMS_EPG Overview
- 67.2 DBMS_EPG Security Model
- 67.3 DBMS_EPG Exceptions
- 67.4 DBMS_EPG Data Structures
- 67.5 DBMS_EPG Subprogram Groups
-
67.6
Summary of DBMS_EPG Subprograms
- 67.6.1 AUTHORIZE_DAD Procedure
- 67.6.2 CREATE_DAD Procedure
- 67.6.3 DEAUTHORIZE_DAD Procedure
- 67.6.4 DELETE_DAD_ATTRIBUTE Procedure
- 67.6.5 DELETE_GLOBAL_ATTRIBUTE Procedure
- 67.6.6 DROP_DAD Procedure
- 67.6.7 GET_ALL_DAD_ATTRIBUTES Procedure
- 67.6.8 GET_ALL_DAD_MAPPINGS Procedure
- 67.6.9 GET_ALL_GLOBAL_ATTRIBUTES Procedure
- 67.6.10 GET_DAD_ATTRIBUTE Function
- 67.6.11 GET_DAD_LIST Procedure
- 67.6.12 GET_GLOBAL_ATTRIBUTE Function
- 67.6.13 MAP_DAD Procedure
- 67.6.14 SET_DAD_ATTRIBUTE Procedure
- 67.6.15 SET_GLOBAL_ATTRIBUTE Procedure
- 67.6.16 UNMAP_DAD Procedure
- 68 DBMS_ERRLOG
- 69 DBMS_FGA
-
70
DBMS_FILE_GROUP
- 70.1 DBMS_FILE_GROUP Overview
- 70.2 DBMS_FILE_GROUP Security Model
- 70.3 DBMS_FILE_GROUP Constants
-
70.4
Summary of DBMS_FILE_GROUP Subprograms
- 70.4.1 ADD_FILE Procedure
- 70.4.2 ALTER_FILE Procedure
- 70.4.3 ALTER_FILE_GROUP Procedure
- 70.4.4 ALTER_VERSION Procedure
- 70.4.5 CREATE_FILE_GROUP Procedure
- 70.4.6 CREATE_VERSION Procedure
- 70.4.7 DROP_FILE_GROUP Procedure
- 70.4.8 DROP_VERSION Procedure
- 70.4.9 GRANT_OBJECT_PRIVILEGE Procedure
- 70.4.10 GRANT_SYSTEM_PRIVILEGE Procedure
- 70.4.11 PURGE_FILE_GROUP Procedure
- 70.4.12 REMOVE_FILE Procedure
- 70.4.13 REVOKE_OBJECT_PRIVILEGE Procedure
- 70.4.14 REVOKE_SYSTEM_PRIVILEGE Procedure
- 71 DBMS_FILE_TRANSFER
- 72 DBMS_FLASHBACK
-
73
DBMS_FLASHBACK_ARCHIVE
- 73.1 DBMS_FLASHBACK_ARCHIVE Overview
- 73.2 DBMS_FLASHBACK_ARCHIVE Security Model
- 73.3 DBMS_FLASHBACK_ARCHIVE Constants
-
73.4
Summary of DBMS_FLASHBACK_ARCHIVE Subprograms
- 73.4.1 ADD_TABLE_TO_APPLICATION Procedure
- 73.4.2 CREATE_TEMP_HISTORY_TABLE Procedure
- 73.4.3 DISABLE_APPLICATION Procedure
- 73.4.4 DISABLE_ASOF_VALID_TIME Procedure
- 73.4.5 DISASSOCIATE_FBA Procedure
- 73.4.6 DROP_APPLICATION Procedure
- 73.4.7 ENABLE_APPLICATION Procedure
- 73.4.8 ENABLE_AT_VALID_TIME Procedure
- 73.4.9 EXTEND_MAPPINGS Procedure
- 73.4.10 GET_SYS_CONTEXT Function
- 73.4.11 IMPORT_HISTORY Procedure
- 73.4.12 LOCK_DOWN_APPLICATION Procedure
- 73.4.13 PURGE_CONTEXT Procedure
- 73.4.14 REASSOCIATE_FBA Procedure
- 73.4.15 REGISTER_APPLICATION Procedure
- 73.4.16 REMOVE_TABLE_FROM_APPLICATION Procedure
- 73.4.17 SET_CONTEXT_LEVEL Procedure
- 74 DBMS_FREQUENT_ITEMSET
- 75 DBMS_FS
-
76
DBMS_GOLDENGATE_ADM
- 76.1 Using DBMS_GOLDENGATE_ADM
-
76.2
Summary of DBMS_GOLDENGATE_ADM Subprograms
- 76.2.1 ADD_AUTO_CDR Procedure
- 76.2.2 ADD_AUTO_CDR_COLUMN_GROUP Procedure
- 76.2.3 ADD_AUTO_CDR_DELTA_RES Procedure
- 76.2.4 ALTER_AUTO_CDR Procedure
- 76.2.5 ALTER_AUTO_CDR_COLUMN_GROUP Procedure
- 76.2.6 DELETE_PROCREP_EXCLUSION_OBJ Procedure
- 76.2.7 GG_PROCEDURE_REPLICATION_ON Function
- 76.2.8 INSERT_PROCREP_EXCLUSION_OBJ Procedure
- 76.2.9 PURGE_TOMBSTONES Procedure
- 76.2.10 REMOVE_AUTO_CDR Procedure
- 76.2.11 REMOVE_AUTO_CDR_COLUMN_GROUP Procedure
- 76.2.12 REMOVE_AUTO_CDR_DELTA_RES Procedure
- 77 DBMS_GOLDENGATE_AUTH
- 78 DBMS_HADOOP
- 79 DBMS_HANG_MANAGER
- 80 DBMS_HEAT_MAP
- 81 DBMS_HIERARCHY
- 82 DBMS_HM
- 83 DBMS_HPROF
- 84 DBMS_HS_PARALLEL
-
85
DBMS_HS_PASSTHROUGH
- 85.1 DBMS_HS_PASSTHROUGH Overview
- 85.2 DBMS_HS_PASSTHROUGH Operational Notes
-
85.3
Summary of DBMS_HS_PASSTHROUGH Subprograms
- 85.3.1 BIND_INOUT_VARIABLE Procedure
- 85.3.2 BIND_INOUT_VARIABLE_RAW Procedure
- 85.3.3 BIND_OUT_VARIABLE Procedure
- 85.3.4 BIND_OUT_VARIABLE_RAW Procedure
- 85.3.5 BIND_VARIABLE Procedure
- 85.3.6 BIND_VARIABLE_RAW Procedure
- 85.3.7 CLOSE_CURSOR Procedure
- 85.3.8 EXECUTE_IMMEDIATE Procedure
- 85.3.9 EXECUTE_NON_QUERY Function
- 85.3.10 FETCH_ROW Function
- 85.3.11 GET_VALUE Procedure
- 85.3.12 GET_VALUE_RAW Procedure
- 85.3.13 OPEN_CURSOR Function
- 85.3.14 PARSE Procedure
- 86 DBMS_ILM
- 87 DBMS_ILM_ADMIN
- 88 DBMS_IMMUTABLE_TABLE
- 89 DBMS_INMEMORY
-
90
DBMS_INMEMORY_ADMIN
- 90.1 DBMS_INMEMORY_ADMIN Overview
- 90.2 DBMS_INMEMORY_ADMIN Security Model
- 90.3 DBMS_INMEMORY_ADMIN Operational Notes
-
90.4
Summary of DBMS_INMEMORY_ADMIN Subprograms
- 90.4.1 AIM_GET_PARAMETER Procedure
- 90.4.2 AIM_SET_PARAMETER Procedure
- 90.4.3 FASTSTART_DISABLE Procedure
- 90.4.4 FASTSTART_ENABLE Procedure
- 90.4.5 FASTSTART_MIGRATE_STORAGE Procedure
- 90.4.6 GET_FASTSTART_TABLESPACE Function
- 90.4.7 IME_CAPTURE_EXPRESSIONS Procedure
- 90.4.8 IME_CLOSE_CAPTURE_WINDOW Procedure
- 90.4.9 IME_DROP_ALL_EXPRESSIONS Procedure
- 90.4.10 IME_GET_CAPTURE_STATE Procedure
- 90.4.11 IME_OPEN_CAPTURE_WINDOW Procedure
- 90.4.12 IME_POPULATE_EXPRESSIONS Procedure
- 90.4.13 POPULATE_WAIT Function
- 91 DBMS_IOT
- 92 DBMS_JAVA
- 93 DBMS_JOB
- 94 DBMS_JSON
- 95 DBMS_LDAP
- 96 DBMS_LDAP_UTL
- 97 DBMS_LIBCACHE
-
98
DBMS_LOB
- 98.1 DBMS_LOB Overview
- 98.2 DBMS_LOB Deprecated Subprograms
- 98.3 DBMS_LOB Security Model
- 98.4 DBMS_LOB Constants
- 98.5 DBMS_LOB Datatypes
- 98.6 DBMS_LOB Operational Notes
- 98.7 DBMS_LOB Rules and Limits
- 98.8 DBMS_LOB Exceptions
-
98.9
Summary of DBMS_LOB Subprograms
- 98.9.1 APPEND Procedures
- 98.9.2 CLOB2FILE Procedure
- 98.9.3 CLOSE Procedure
- 98.9.4 COMPARE Functions
- 98.9.5 CONVERTTOBLOB Procedure
- 98.9.6 CONVERTTOCLOB Procedure
- 98.9.7 COPY Procedures
- 98.9.8 COPY_DBFS_LINK Procedures
- 98.9.9 COPY_FROM_DBFS_LINK
- 98.9.10 CREATETEMPORARY Procedures
- 98.9.11 DBFS_LINK_GENERATE_PATH Functions
- 98.9.12 ERASE Procedures
- 98.9.13 FILECLOSE Procedure
- 98.9.14 FILECLOSEALL Procedure
- 98.9.15 FILEEXISTS Function
- 98.9.16 FILEGETNAME Procedure
- 98.9.17 FILEISOPEN Function
- 98.9.18 FILEOPEN Procedure
- 98.9.19 FRAGMENT_DELETE Procedure
- 98.9.20 FRAGMENT_INSERT Procedures
- 98.9.21 FRAGMENT_MOVE Procedure
- 98.9.22 FRAGMENT_REPLACE Procedures
- 98.9.23 FREETEMPORARY Procedures
- 98.9.24 GET_DBFS_LINK Functions
- 98.9.25 GET_DBFS_LINK_STATE Procedures
- 98.9.26 GETCONTENTTYPE Functions
- 98.9.27 GET_STORAGE_LIMIT Function
- 98.9.28 GETCHUNKSIZE Functions
- 98.9.29 GETLENGTH Functions
- 98.9.30 GETOPTIONS Functions
- 98.9.31 INSTR Functions
- 98.9.32 ISOPEN Functions
- 98.9.33 ISREMOTE Function
- 98.9.34 ISSECUREFILE Function
- 98.9.35 ISTEMPORARY Functions
- 98.9.36 LOADBLOBFROMFILE Procedure
- 98.9.37 LOADCLOBFROMFILE Procedure
- 98.9.38 LOADFROMFILE Procedure
- 98.9.39 MOVE_TO_DBFS_LINK Procedures
- 98.9.40 OPEN Procedures
- 98.9.41 READ Procedures
- 98.9.42 SET_DBFS_LINK Procedures
- 98.9.43 SETCONTENTTYPE Procedure
- 98.9.44 SETOPTIONS Procedures
- 98.9.45 SUBSTR Functions
- 98.9.46 TRIM Procedures
- 98.9.47 WRITE Procedures
- 98.9.48 WRITEAPPEND Procedures
- 99 DBMS_LOCK
- 100 DBMS_LOGMNR
-
101
DBMS_LOGSTDBY
- 101.1 DBMS_LOGSTDBY Overview
- 101.2 DBMS_LOGSTDBY Security Model
- 101.3 DBMS_LOGSTDBY Constants
-
101.4
Summary of DBMS_LOGSTDBY Subprograms
- 101.4.1 APPLY_SET Procedure
- 101.4.2 APPLY_UNSET Procedure
- 101.4.3 BUILD Procedure
- 101.4.4 INSTANTIATE_TABLE Procedure
- 101.4.5 IS_APPLY_SERVER Function
- 101.4.6 MAP_PRIMARY_SCN Function
- 101.4.7 PREPARE_FOR_NEW_PRIMARY Procedure
- 101.4.8 PURGE_SESSION Procedure
- 101.4.9 REBUILD Procedure
- 101.4.10 SET_TABLESPACE Procedure
- 101.4.11 SKIP Procedure
- 101.4.12 SKIP_ERROR Procedure
- 101.4.13 SKIP_TRANSACTION Procedure
- 101.4.14 UNSKIP Procedure
- 101.4.15 UNSKIP_ERROR Procedure
- 101.4.16 UNSKIP_TRANSACTION Procedure
- 102 DBMS_LOGMNR_D
- 103 DBMS_LOGSTDBY_CONTEXT
- 104 DBMS_MEMOPTIMIZE
- 105 DBMS_MEMOPTIMIZE_ADMIN
-
106
DBMS_METADATA
- 106.1 DBMS_METADATA Overview
- 106.2 DBMS_METADATA Security Model
- 106.3 Rules and Limits
- 106.4 DBMS_METADATA Data Structures - Object and Table Types
- 106.5 DBMS_METADATA Subprogram Groupings
-
106.6
Summary of All DBMS_METADATA Subprograms
- 106.6.1 ADD_TRANSFORM Function
- 106.6.2 CLOSE Procedure
- 106.6.3 CONVERT Functions and Procedures
- 106.6.4 FETCH_xxx Functions and Procedures
- 106.6.5 GET_xxx Functions
- 106.6.6 GET_QUERY Function
- 106.6.7 OPEN Function
- 106.6.8 OPENW Function
- 106.6.9 PUT Function
- 106.6.10 SET_COUNT Procedure
- 106.6.11 SET_FILTER Procedure
- 106.6.12 SET_PARSE_ITEM Procedure
- 106.6.13 SET_TRANSFORM_PARAM and SET_REMAP_PARAM Procedures
- 107 DBMS_METADATA_DIFF
-
108
DBMS_MGD_ID_UTL
- 108.1 DBMS_MGD_ID_UTL Security Model
- 108.2 DBMS_MGD_ID_UTL Constants
- 108.3 DBMS_MGD_ID_UTL Exceptions
-
108.4
Summary of DBMS_MGD_ID_UTL Subprograms
- 108.4.1 ADD_SCHEME Procedure
- 108.4.2 CREATE_CATEGORY Function
- 108.4.3 EPC_TO_ORACLE_SCHEME Function
- 108.4.4 GET_CATEGORY_ID Function
- 108.4.5 GET_COMPONENTS Function
- 108.4.6 GET_ENCODINGS Function
- 108.4.7 GET_JAVA_LOGGING_LEVEL Function
- 108.4.8 GET_PLSQL_LOGGING_LEVEL Function
- 108.4.9 GET_SCHEME_NAMES Function
- 108.4.10 GET_TDT_XML Function
- 108.4.11 GET_VALIDATOR Function
- 108.4.12 REFRESH_CATEGORY Function
- 108.4.13 REMOVE_CATEGORY Procedure
- 108.4.14 REMOVE_PROXY Procedure
- 108.4.15 REMOVE_SCHEME Procedure
- 108.4.16 SET_JAVA_LOGGING_LEVEL Procedure
- 108.4.17 SET_PLSQL_LOGGING_LEVEL Procedure
- 108.4.18 SET_PROXY Procedure
- 108.4.19 VALIDATE_SCHEME Function
-
109
DBMS_MGWADM
- 109.1 DBMS_MGWADM Security Model
- 109.2 DBMS_MGWADM Deprecated Subprograms
- 109.3 DBMS_MGWADM Constants
- 109.4 DBMS_MGWADM Data Structures
-
109.5
Summary of DBMS_MGWADM Subprograms
- 109.5.1 ADD_SUBSCRIBER Procedure
- 109.5.2 ALTER_AGENT Procedures
- 109.5.3 ALTER_JOB Procedure
- 109.5.4 ALTER_MSGSYSTEM_LINK Procedure for TIB/Rendezvous
- 109.5.5 ALTER_MSGSYSTEM_LINK Procedure for WebSphere MQ
- 109.5.6 ALTER_PROPAGATION_SCHEDULE Procedure
- 109.5.7 ALTER_SUBSCRIBER Procedure
- 109.5.8 CLEANUP_GATEWAY Procedures
- 109.5.9 CREATE_AGENT Procedure
- 109.5.10 CREATE_JOB Procedure
- 109.5.11 CREATE_MSGSYSTEM_LINK Procedures for TIB/Rendezvous
- 109.5.12 CREATE_MSGSYSTEM_LINK Procedures for WebSphere MQ
- 109.5.13 DB_CONNECT_INFO Procedure
- 109.5.14 DISABLE_JOB Procedure
- 109.5.15 DISABLE_PROPAGATION_SCHEDULE Procedure
- 109.5.16 ENABLE_JOB Procedure
- 109.5.17 ENABLE_PROPAGATION_SCHEDULE Procedure
- 109.5.18 REGISTER_FOREIGN_QUEUE Procedure
- 109.5.19 REMOVE_AGENT Procedure
- 109.5.20 REMOVE_JOB Procedure
- 109.5.21 REMOVE_MSGSYSTEM_LINK Procedure
- 109.5.22 REMOVE_OPTION Procedure
- 109.5.23 REMOVE_SUBSCRIBER Procedure
- 109.5.24 RESET_JOB Procedure
- 109.5.25 RESET_SUBSCRIBER Procedure
- 109.5.26 SCHEDULE_PROPAGATION Procedure
- 109.5.27 SET_LOG_LEVEL Procedures
- 109.5.28 SET_OPTION Procedure
- 109.5.29 SHUTDOWN Procedures
- 109.5.30 STARTUP Procedures
- 109.5.31 UNREGISTER_FOREIGN_QUEUE Procedure
- 109.5.32 UNSCHEDULE_PROPAGATION Procedure
-
110
DBMS_MGWMSG
- 110.1 DBMS_MGWMSG Security Model
- 110.2 DBMS_MGWMSG Constants
-
110.3
DBMS_MGWMSG Types
- 110.3.1 DBMS_MGWMSG SYS.MGW_NAME_VALUE_T Type
- 110.3.2 DBMS_MGWMSG SYS.MGW_NAME_TYPE_ARRAY_T Type
- 110.3.3 DBMS_MGWMSG SYS.MGW_TEXT_VALUE_T Type
- 110.3.4 DBMS_MGWMSG SYS.MGW_RAW_VALUE_T Type
- 110.3.5 DBMS_MGWMSG SYS.MGW_BASIC_MSG_T Type
- 110.3.6 DBMS_MGWMSG SYS.MGW_NUMBER_ARRAY_T Type
- 110.3.7 DBMS_MGWMSG SYS.MGW_TIBRV_FIELD_T Type
- 110.3.8 DBMS_MGWMSG SYS.MGW_TIBRV_MSG_T Type
-
110.4
Summary of DBMS_MGWMSG Subprograms
- 110.4.1 LCR_TO_XML Function
- 110.4.2 NVARRAY_ADD Procedure
- 110.4.3 NVARRAY_FIND_NAME Function
- 110.4.4 NVARRAY_FIND_NAME_TYPE Function
- 110.4.5 NVARRAY_GET Function
- 110.4.6 NVARRAY_GET_BOOLEAN Function
- 110.4.7 NVARRAY_GET_BYTE Function
- 110.4.8 NVARRAY_GET_DATE Function
- 110.4.9 NVARRAY_GET_DOUBLE Function
- 110.4.10 NVARRAY_GET_FLOAT Function
- 110.4.11 NVARRAY_GET_INTEGER Function
- 110.4.12 NVARRAY_GET_LONG Function
- 110.4.13 NVARRAY_GET_RAW Function
- 110.4.14 NVARRAY_GET_SHORT Function
- 110.4.15 NVARRAY_GET_TEXT Function
- 110.4.16 XML_TO_LCR Function
-
111
DBMS_MONITOR
-
111.1
Summary of DBMS_MONITOR Subprograms
- 111.1.1 CLIENT_ID_STAT_DISABLE Procedure
- 111.1.2 CLIENT_ID_STAT_ENABLE Procedure
- 111.1.3 CLIENT_ID_TRACE_DISABLE Procedure
- 111.1.4 CLIENT_ID_TRACE_ENABLE Procedure
- 111.1.5 DATABASE_TRACE_DISABLE Procedure
- 111.1.6 DATABASE_TRACE_ENABLE Procedure
- 111.1.7 SERV_MOD_ACT_STAT_DISABLE Procedure
- 111.1.8 SERV_MOD_ACT_STAT_ENABLE Procedure
- 111.1.9 SERV_MOD_ACT_TRACE_DISABLE Procedure
- 111.1.10 SERV_MOD_ACT_TRACE_ENABLE Procedure
- 111.1.11 SESSION_TRACE_DISABLE Procedure
- 111.1.12 SESSION_TRACE_ENABLE Procedure
-
111.1
Summary of DBMS_MONITOR Subprograms
-
112
DBMS_MVIEW
- 112.1 DBMS_MVIEW Operational Notes
- 112.2 DBMS_MVIEW Security Model
- 112.3 DBMS_MVIEW Rules and Limits
-
112.4
Summary of DBMS_MVIEW Subprograms
- 112.4.1 BEGIN_TABLE_REORGANIZATION Procedure
- 112.4.2 END_TABLE_REORGANIZATION Procedure
- 112.4.3 ESTIMATE_MVIEW_SIZE Procedure
- 112.4.4 EXPLAIN_MVIEW Procedure
- 112.4.5 EXPLAIN_REWRITE Procedure
- 112.4.6 I_AM_A_REFRESH Function
- 112.4.7 PMARKER Function
- 112.4.8 PURGE_DIRECT_LOAD_LOG Procedure
- 112.4.9 PURGE_LOG Procedure
- 112.4.10 PURGE_MVIEW_FROM_LOG Procedure
- 112.4.11 REFRESH Procedures
- 112.4.12 REFRESH_ALL_MVIEWS Procedure
- 112.4.13 REFRESH_DEPENDENT Procedures
- 112.4.14 REGISTER_MVIEW Procedure
- 112.4.15 UNREGISTER_MVIEW Procedure
- 113 DBMS_MVIEW_STATS
-
114
DBMS_NETWORK_ACL_ADMIN
- 114.1 DBMS_NETWORK_ACL_ADMIN Overview
- 114.2 DBMS_NETWORK_ACL_ADMIN Deprecated Subprograms
- 114.3 DBMS_NETWORK_ACL_ADMIN Security Model
- 114.4 DBMS_NETWORK_ACL_ADMIN Constants
- 114.5 DBMS_NETWORK_ACL_ADMIN Exceptions
- 114.6 DBMS_NETWORK_ACL_ADMIN Examples
-
114.7
Summary of DBMS_NETWORK_ACL_ADMIN Subprograms
- 114.7.1 ADD_PRIVILEGE Procedure
- 114.7.2 APPEND_HOST_ACE Procedure
- 114.7.3 APPEND_HOST_ACL Procedure
- 114.7.4 APPEND_WALLET_ACE Procedure
- 114.7.5 APPEND_WALLET_ACL Procedure
- 114.7.6 ASSIGN_ACL Procedure
- 114.7.7 ASSIGN_WALLET_ACL Procedure
- 114.7.8 CHECK_PRIVILEGE Function
- 114.7.9 CHECK_PRIVILEGE_ACLID Function
- 114.7.10 CREATE_ACL Procedure
- 114.7.11 DELETE_PRIVILEGE Procedure
- 114.7.12 DROP_ACL Procedure
- 114.7.13 REMOVE_HOST_ACE Procedure
- 114.7.14 REMOVE_WALLET_ACE Procedure
- 114.7.15 SET_HOST_ACL Procedure
- 114.7.16 SET_WALLET_ACL Procedure
- 114.7.17 UNASSIGN_ACL Procedure
- 114.7.18 UNASSIGN_WALLET_ACL Procedure
- 115 DBMS_NETWORK_ACL_UTILITY
- 116 DBMS_ODCI
- 117 DBMS_OPTIM_BUNDLE
- 118 DBMS_OUTLN
- 119 DBMS_OUTPUT
-
120
DBMS_PARALLEL_EXECUTE
- 120.1 DBMS_PARALLEL_EXECUTE Overview
- 120.2 DBMS_PARALLEL_EXECUTE Security Model
- 120.3 DBMS_PARALLEL_EXECUTE Constants
- 120.4 DBMS_PARALLEL_EXECUTE Views
- 120.5 DBMS_PARALLEL_EXECUTE Exceptions
- 120.6 DBMS_PARALLEL_EXECUTE Examples
-
120.7
Summary of DBMS_PARALLEL_EXECUTE Subprograms
- 120.7.1 ADM_DROP_CHUNKS Procedure
- 120.7.2 ADM_DROP_TASK Procedure
- 120.7.3 ADM_TASK_STATUS Function
- 120.7.4 ADM_STOP_TASK Procedure
- 120.7.5 CREATE_TASK Procedure
- 120.7.6 CREATE_CHUNKS_BY_NUMBER_COL Procedure
- 120.7.7 CREATE_CHUNKS_BY_ROWID Procedure
- 120.7.8 CREATE_CHUNKS_BY_SQL Procedure
- 120.7.9 DROP_TASK Procedure
- 120.7.10 DROP_CHUNKS Procedure
- 120.7.11 GENERATE_TASK_NAME Function
- 120.7.12 GET_NUMBER_COL_CHUNK Procedure
- 120.7.13 GET_ROWID_CHUNK Procedure
- 120.7.14 PURGE_PROCESSED_CHUNKS Procedure
- 120.7.15 RESUME_TASK Procedures
- 120.7.16 RUN_TASK Procedure
- 120.7.17 SET_CHUNK_STATUS Procedure
- 120.7.18 STOP_TASK Procedure
- 120.7.19 TASK_STATUS Procedure
- 121 DBMS_PART
- 122 DBMS_PCLXUTIL
-
123
DBMS_PDB
- 123.1 DBMS_PDB Overview
- 123.2 DBMS_PDB Security Model
-
123.3
Summary of DBMS_PDB Subprograms
- 123.3.1 CHECK_PLUG_COMPATIBILITY Function
- 123.3.2 DESCRIBE Procedure
- 123.3.3 EXPORTRMANBACKUP Procedure
- 123.3.4 RECOVER Procedure
- 123.3.5 REMOVE_LINK Procedure
- 123.3.6 SET_DATA_LINKED Procedure
- 123.3.7 SET_EXT_DATA_LINKED Procedure
- 123.3.8 SET_METADATA_LINKED Procedure
- 123.3.9 SET_PROFILE_EXPLICIT Procedure
- 123.3.10 SET_ROLE_EXPLICIT Procedure
- 123.3.11 SET_USER_EXPLICIT Procedure
- 124 DBMS_PDB_ALTER_SHARING
- 125 DBMS_PERF
-
126
DBMS_PIPE
- 126.1 DBMS_PIPE Overview
- 126.2 DBMS_PIPE Security Model
- 126.3 DBMS_PIPE Constants
- 126.4 DBMS_PIPE Operational Notes
- 126.5 DBMS_PIPE Exceptions
- 126.6 DBMS_PIPE Examples
-
126.7
Summary of DBMS_PIPE Subprograms
- 126.7.1 CREATE_PIPE Function
- 126.7.2 NEXT_ITEM_TYPE Function
- 126.7.3 PACK_MESSAGE Procedures
- 126.7.4 PURGE Procedure
- 126.7.5 RECEIVE_MESSAGE Function
- 126.7.6 RESET_BUFFER Procedure
- 126.7.7 REMOVE_PIPE Function
- 126.7.8 SEND_MESSAGE Function
- 126.7.9 UNIQUE_SESSION_NAME Function
- 126.7.10 UNPACK_MESSAGE Procedures
- 127 DBMS_PLSQL_CODE_COVERAGE
- 128 DBMS_PREDICTIVE_ANALYTICS
- 129 DBMS_PREPROCESSOR
- 130 DBMS_PRIVILEGE_CAPTURE
- 131 DBMS_PROCESS
- 132 DBMS_PROFILER
- 133 DBMS_PROPAGATION_ADM
-
134
DBMS_QOPATCH
- 134.1 DBMS_QOPATCH Overview
- 134.2 DBMS_QOPATCH Security Model
- 134.3 DBMS_QOPATCH Operational Notes
- 134.4 DBMS_QOPATCH Exceptions
-
134.5
Summary of DBMS_QOPATCH Subprograms
- 134.5.1 CHECK_PATCH_INSTALLED Function
- 134.5.2 GET_OPATCH_BUGS Function
- 134.5.3 GET_OPATCH_COUNT Function
- 134.5.4 GET_OPATCH_DATA Function
- 134.5.5 GET_OPATCH_FILES Function
- 134.5.6 GET_OPATCH_INSTALL_INFO Function
- 134.5.7 GET_OPATCH_LIST Function
- 134.5.8 GET_OPATCH_LSINVENTORY
- 134.5.9 GET_OPATCH_OLAYS Function
- 134.5.10 GET_OPATCH_PREQS Function
- 134.5.11 GET_OPATCH_XSLT
- 134.5.12 GET_PATCH_DETAILS Function
- 134.5.13 GET_SQLPATCH_STATUS Procedure
- 134.5.14 IS_PATCH_INSTALLED Function
- 134.5.15 OPATCH_COMPARE_CURRENT Function
- 134.5.16 OPATCH_COMPARE_NODES Function
- 134.5.17 SET_CURRENT_OPINST Procedure
- 135 DBMS_RANDOM
-
136
DBMS_REDACT
- 136.1 DBMS_REDACT Overview
- 136.2 DBMS_REDACT Security Model
- 136.3 DBMS_REDACT Constants
- 136.4 DBMS_REDACT Operating Procedures
-
136.5
Summary of DBMS_REDACT Subprograms
- 136.5.1 ADD_POLICY Procedure
- 136.5.2 ALTER_POLICY Procedure
- 136.5.3 APPLY_POLICY_EXPR_TO_COL Procedure
- 136.5.4 CREATE_POLICY_EXPRESSION Procedure
- 136.5.5 DISABLE_POLICY Procedure
- 136.5.6 DROP_POLICY Procedure
- 136.5.7 DROP_POLICY_EXPRESSION Procedure
- 136.5.8 ENABLE_POLICY Procedure
- 136.5.9 UPDATE_FULL_REDACTION_VALUES Procedure
- 136.5.10 UPDATE_POLICY_EXPRESSION Procedure
-
137
DBMS_REDEFINITION
- 137.1 DBMS_REDEFINITION Overview
- 137.2 DBMS_REDEFINITION Security Model
- 137.3 DBMS_REDEFINITION Constants
- 137.4 DBMS_REDEFINITION Operational Notes
- 137.5 DBMS_REDEFINITION Rules and Limits
- 137.6 DBMS_REDEFINITION Examples
-
137.7
Summary of DBMS_REDEFINITION Subprograms
- 137.7.1 ABORT_REDEF_TABLE Procedure
- 137.7.2 ABORT_ROLLBACK Procedure
- 137.7.3 ABORT_UPDATE Procedure
- 137.7.4 CAN_REDEF_TABLE Procedure
- 137.7.5 COPY_TABLE_DEPENDENTS Procedure
- 137.7.6 EXECUTE_UPDATE Procedure
- 137.7.7 FINISH_REDEF_TABLE Procedure
- 137.7.8 REDEF_TABLE Procedure
- 137.7.9 REGISTER_DEPENDENT_OBJECT Procedure
- 137.7.10 ROLLBACK Procedure
- 137.7.11 SET_PARAM Procedure
- 137.7.12 START_REDEF_TABLE Procedure
- 137.7.13 SYNC_INTERIM_TABLE Procedure
- 137.7.14 UNREGISTER_DEPENDENT_OBJECT Procedure
- 138 DBMS_REFRESH
- 139 DBMS_REPAIR
-
140
DBMS_RESCONFIG
- 140.1 DBMS_RESCONFIG Overview
-
140.2
Summary of DBMS_RESCONFIG Subprograms
- 140.2.1 ADDREPOSITORYRESCONFIG Procedure
- 140.2.2 ADDRESCONFIG Procedure
- 140.2.3 APPENDRESCONFIG Procedure
- 140.2.4 DELETEREPOSITORYRESCONFIG Procedure
- 140.2.5 DELETERESCONFIG Procedures
- 140.2.6 GETLISTENERS Function
- 140.2.7 GETREPOSITORYRESCONFIG Function
- 140.2.8 GETREPOSITORYRESCONFIGPATHS Function
- 140.2.9 GETRESCONFIG Function
- 140.2.10 GETRESCONFIGPATHS Function
- 140.2.11 PATCHREPOSITORYRESCONFIGLIST Procedure
-
141
DBMS_RESOURCE_MANAGER
- 141.1 DBMS_RESOURCE_MANAGER Deprecated Subprograms
- 141.2 DBMS_RESOURCE_MANAGER Security Model
- 141.3 DBMS_RESOURCE_MANAGER Constants
-
141.4
Summary of DBMS_RESOURCE_MANAGER Subprograms
- 141.4.1 BEGIN_SQL_BLOCK Procedure
- 141.4.2 CALIBRATE_IO Procedure
- 141.4.3 CLEAR_PENDING_AREA Procedure
- 141.4.4 CREATE_CATEGORY Procedure
- 141.4.5 CREATE_CDB_PLAN Procedure
- 141.4.6 CREATE_CDB_PLAN_DIRECTIVE Procedure
- 141.4.7 CREATE_CDB_PROFILE_DIRECTIVE Procedure
- 141.4.8 CREATE_CONSUMER_GROUP Procedure
- 141.4.9 CREATE_PENDING_AREA Procedure
- 141.4.10 CREATE_PLAN Procedure
- 141.4.11 CREATE_PLAN_DIRECTIVE Procedure
- 141.4.12 CREATE_SIMPLE_PLAN Procedure
- 141.4.13 DELETE_CATEGORY Procedure
- 141.4.14 DELETE_CDB_PLAN Procedure
- 141.4.15 DELETE_CDB_PLAN_DIRECTIVE Procedure
- 141.4.16 DELETE_CDB_PROFILE_DIRECTIVE Procedure
- 141.4.17 DELETE_CONSUMER_GROUP Procedure
- 141.4.18 DELETE_PLAN Procedure
- 141.4.19 DELETE_PLAN_CASCADE Procedure
- 141.4.20 DELETE_PLAN_DIRECTIVE Procedure
- 141.4.21 DEQUEUE_PARALLEL_STATEMENT Procedure
- 141.4.22 END_SQL_BLOCK Procedure
- 141.4.23 SET_CONSUMER_GROUP_MAPPING Procedure
- 141.4.24 SET_CONSUMER_GROUP_MAPPING_PRI Procedure
- 141.4.25 SET_INITIAL_CONSUMER_GROUP Procedure
- 141.4.26 SUBMIT_PENDING_AREA Procedure
- 141.4.27 SWITCH_CONSUMER_GROUP_FOR_SESS Procedure
- 141.4.28 SWITCH_CONSUMER_GROUP_FOR_USER Procedure
- 141.4.29 SWITCH_PLAN Procedure
- 141.4.30 UPDATE_CATEGORY Procedure
- 141.4.31 UPDATE_CDB_AUTOTASK_DIRECTIVE Procedure
- 141.4.32 UPDATE_CDB_DEFAULT_DIRECTIVE Procedure
- 141.4.33 UPDATE_CDB_PLAN Procedure
- 141.4.34 UPDATE_CDB_PLAN_DIRECTIVE Procedure
- 141.4.35 UPDATE_CDB_PROFILE_DIRECTIVE Procedure
- 141.4.36 UPDATE_CONSUMER_GROUP Procedure
- 141.4.37 UPDATE_PLAN Procedure
- 141.4.38 UPDATE_PLAN_DIRECTIVE Procedure
- 141.4.39 VALIDATE_PENDING_AREA Procedure
- 142 DBMS_RESOURCE_MANAGER_PRIVS
-
143
DBMS_RESULT_CACHE
- 143.1 DBMS_RESULT_CACHE Security Model
- 143.2 DBMS_RESULT_CACHE Constants
-
143.3
Summary of DBMS_RESULT_CACHE Subprograms
- 143.3.1 BLACK_LIST Function
- 143.3.2 BLACK_LIST_ADD Procedure
- 143.3.3 BLACK_LIST_CLEAR Procedure
- 143.3.4 BLACK_LIST_REMOVE Procedure
- 143.3.5 BYPASS Procedure
- 143.3.6 FLUSH Function & Procedure
- 143.3.7 INVALIDATE Functions & Procedures
- 143.3.8 INVALIDATE_OBJECT Functions & Procedures
- 143.3.9 MEMORY_REPORT Procedure
- 143.3.10 STATUS Function
- 144 DBMS_RESUMABLE
-
145
DBMS_RLS
- 145.1 DBMS_RLS Overview
- 145.2 DBMS_RLS Security Model
- 145.3 DBMS_RLS Constants
- 145.4 DBMS_RLS Operational Notes
- 145.5 DBMS_RLS Rules and Limits
-
145.6
Summary of DBMS_RLS Subprograms
- 145.6.1 ADD_GROUPED_POLICY Procedure
- 145.6.2 ADD_POLICY Procedure
- 145.6.3 ADD_POLICY_CONTEXT Procedure
- 145.6.4 ALTER_POLICY Procedure
- 145.6.5 ALTER_GROUPED_POLICY Procedure
- 145.6.6 CREATE_POLICY_GROUP Procedure
- 145.6.7 DELETE_POLICY_GROUP Procedure
- 145.6.8 DISABLE_GROUPED_POLICY Procedure
- 145.6.9 DROP_GROUPED_POLICY Procedure
- 145.6.10 DROP_POLICY Procedure
- 145.6.11 DROP_POLICY_CONTEXT Procedure
- 145.6.12 ENABLE_GROUPED_POLICY Procedure
- 145.6.13 ENABLE_POLICY Procedure
- 145.6.14 REFRESH_GROUPED_POLICY Procedure
- 145.6.15 REFRESH_POLICY Procedure
- 146 DBMS_ROLLING
-
147
DBMS_ROWID
- 147.1 DBMS_ROWID Security Model
- 147.2 DBMS_ROWID Types
- 147.3 DBMS_ROWID Exceptions
- 147.4 DBMS_ROWID Operational Notes
- 147.5 DBMS_ROWID Examples
-
147.6
Summary of DBMS_ROWID Subprograms
- 147.6.1 ROWID_BLOCK_NUMBER Function
- 147.6.2 ROWID_CREATE Function
- 147.6.3 ROWID_INFO Procedure
- 147.6.4 ROWID_OBJECT Function
- 147.6.5 ROWID_RELATIVE_FNO Function
- 147.6.6 ROWID_ROW_NUMBER Function
- 147.6.7 ROWID_TO_ABSOLUTE_FNO Function
- 147.6.8 ROWID_TO_EXTENDED Function
- 147.6.9 ROWID_TO_RESTRICTED Function
- 147.6.10 ROWID_TYPE Function
- 147.6.11 ROWID_VERIFY Function
-
148
DBMS_RULE
- 148.1 DBMS_RULE Overview
- 148.2 DBMS_RULE Security Model
-
148.3
Summary of DBMS_RULE Subprograms
- 148.3.1 CLOSE_ITERATOR Procedure
- 148.3.2 EVALUATE Procedure
- 148.3.3 EVALUATE_EXPRESSION Procedure
- 148.3.4 EVALUATE_EXPRESSION_ITERATOR Procedure
- 148.3.5 EVALUATE_RULE Procedure
- 148.3.6 EVALUATE_RULE_ITERATOR Procedure
- 148.3.7 GET_NEXT_HIT Function
- 148.3.8 GET_NEXT_RESULT Function
- 148.3.9 IS_FAST Procedure
-
149
DBMS_RULE_ADM
- 149.1 DBMS_RULE_ADM Overview
- 149.2 DBMS_RULE_ADM Security Model
-
149.3
Summary of DBMS_RULE_ADM Subprograms
- 149.3.1 ADD_RULE Procedure
- 149.3.2 ALTER_EVALUATION_CONTEXT Procedure
- 149.3.3 ALTER_RULE Procedure
- 149.3.4 CREATE_EVALUATION_CONTEXT Procedure
- 149.3.5 CREATE_RULE Procedure
- 149.3.6 CREATE_RULE_SET Procedure
- 149.3.7 DROP_EVALUATION_CONTEXT Procedure
- 149.3.8 DROP_RULE Procedure
- 149.3.9 DROP_RULE_SET Procedure
- 149.3.10 GRANT_OBJECT_PRIVILEGE Procedure
- 149.3.11 GRANT_SYSTEM_PRIVILEGE Procedure
- 149.3.12 REMOVE_RULE Procedure
- 149.3.13 REVOKE_OBJECT_PRIVILEGE Procedure
- 149.3.14 REVOKE_SYSTEM_PRIVILEGE Procedure
-
150
DBMS_SCHEDULER
- 150.1 DBMS_SCHEDULER Deprecated Subprograms
- 150.2 DBMS_SCHEDULER Security Model
- 150.3 DBMS_SCHEDULER Rules and Limits
- 150.4 DBMS_SCHEDULER Operational Notes
-
150.5
DBMS_SCHEDULER Data Structures
- 150.5.1 DBMS_SCHEDULER JOBARG Object Type
- 150.5.2 JOBARG_ARRAY Table Type
- 150.5.3 DBMS_SCHEDULER JOB_DEFINITION Object Type
- 150.5.4 JOB_DEFINITION_ARRAY Table Type
- 150.5.5 JOBATTR Object Type
- 150.5.6 JOBATTR_ARRAY Table Type
- 150.5.7 SCHEDULER$_STEP_TYPE Object Type
- 150.5.8 SCHEDULER$_STEP_TYPE_LIST Table Type
- 150.5.9 SCHEDULER$_EVENT_INFO Object Type
- 150.5.10 SCHEDULER_FILEWATCHER_RESULT Object Type
- 150.5.11 SCHEDULER_FILEWATCHER_REQUEST Object Type
-
150.6
Summary of DBMS_SCHEDULER Subprograms
- 150.6.1 ADD_EVENT_QUEUE_SUBSCRIBER Procedure
- 150.6.2 ADD_GROUP_MEMBER Procedure
- 150.6.3 ADD_JOB_EMAIL_NOTIFICATION Procedure
- 150.6.4 ADD_TO_INCOMPATIBILITY Procedure
- 150.6.5 ALTER_CHAIN Procedure
- 150.6.6 ALTER_RUNNING_CHAIN Procedure
- 150.6.7 CLOSE_WINDOW Procedure
- 150.6.8 COPY_JOB Procedure
- 150.6.9 CREATE_CHAIN Procedure
- 150.6.10 CREATE_CREDENTIAL Procedure
- 150.6.11 CREATE_DATABASE_DESTINATION Procedure
- 150.6.12 CREATE_EVENT_SCHEDULE Procedure
- 150.6.13 CREATE_FILE_WATCHER Procedure
- 150.6.14 CREATE_GROUP Procedure
- 150.6.15 CREATE_INCOMPATIBILITY Procedure
- 150.6.16 CREATE_JOB Procedure
- 150.6.17 CREATE_JOB_CLASS Procedure
- 150.6.18 CREATE_JOBS Procedure
- 150.6.19 CREATE_PROGRAM Procedure
- 150.6.20 CREATE_RESOURCE Procedure
- 150.6.21 CREATE_SCHEDULE Procedure
- 150.6.22 CREATE_WINDOW Procedure
- 150.6.23 DEFINE_ANYDATA_ARGUMENT Procedure
- 150.6.24 DEFINE_CHAIN_EVENT_STEP Procedure
- 150.6.25 DEFINE_CHAIN_RULE Procedure
- 150.6.26 DEFINE_CHAIN_STEP Procedure
- 150.6.27 DEFINE_METADATA_ARGUMENT Procedure
- 150.6.28 DEFINE_PROGRAM_ARGUMENT Procedure
- 150.6.29 DISABLE Procedure
- 150.6.30 DROP_AGENT_DESTINATION Procedure
- 150.6.31 DROP_CHAIN Procedure
- 150.6.32 DROP_CHAIN_RULE Procedure
- 150.6.33 DROP_CHAIN_STEP Procedure
- 150.6.34 DROP_CREDENTIAL Procedure
- 150.6.35 DROP_DATABASE_DESTINATION Procedure
- 150.6.36 DROP_FILE_WATCHER Procedure
- 150.6.37 DROP_GROUP Procedure
- 150.6.38 DROP_INCOMPATIBILITY Procedure
- 150.6.39 DROP_JOB Procedure
- 150.6.40 DROP_JOB_CLASS Procedure
- 150.6.41 DROP_PROGRAM Procedure
- 150.6.42 DROP_PROGRAM_ARGUMENT Procedure
- 150.6.43 DROP_RESOURCE Procedure
- 150.6.44 DROP_SCHEDULE Procedure
- 150.6.45 DROP_WINDOW Procedure
- 150.6.46 ENABLE Procedure
- 150.6.47 END_DETACHED_JOB_RUN Procedure
- 150.6.48 EVALUATE_CALENDAR_STRING Procedure
- 150.6.49 EVALUATE_RUNNING_CHAIN Procedure
- 150.6.50 GENERATE_JOB_NAME Function
- 150.6.51 GET_AGENT_INFO Function
- 150.6.52 GET_AGENT_VERSION Function
- 150.6.53 GET_ATTRIBUTE Procedure
- 150.6.54 GET_FILE Procedure
- 150.6.55 GET_SCHEDULER_ATTRIBUTE Procedure
- 150.6.56 OPEN_WINDOW Procedure
- 150.6.57 PURGE_LOG Procedure
- 150.6.58 PUT_FILE Procedure
- 150.6.59 REMOVE_EVENT_QUEUE_SUBSCRIBER Procedure
- 150.6.60 REMOVE_FROM_INCOMPATIBILITY Procedure
- 150.6.61 REMOVE_GROUP_MEMBER Procedure
- 150.6.62 REMOVE_JOB_EMAIL_NOTIFICATION Procedure
- 150.6.63 RESET_JOB_ARGUMENT_VALUE Procedure
- 150.6.64 RUN_CHAIN Procedure
- 150.6.65 RUN_JOB Procedure
- 150.6.66 SET_AGENT_REGISTRATION_PASS Procedure
- 150.6.67 SET_ATTRIBUTE Procedure
- 150.6.68 SET_ATTRIBUTE_NULL Procedure
- 150.6.69 SET_JOB_ANYDATA_VALUE Procedure
- 150.6.70 SET_JOB_ARGUMENT_VALUE Procedure
- 150.6.71 SET_JOB_ATTRIBUTES Procedure
- 150.6.72 SET_RESOURCE_CONSTRAINT Procedure
- 150.6.73 SET_SCHEDULER_ATTRIBUTE Procedure
- 150.6.74 STOP_JOB Procedure
- 151 DBMS_SERVER_ALERT
- 152 DBMS_SERVICE
-
153
DBMS_SESSION
- 153.1 DBMS_SESSION Security Model
- 153.2 DBMS_SESSION Operational Notes
- 153.3 DBMS_SESSION Data Structures
-
153.4
Summary of DBMS_SESSION Subprograms
- 153.4.1 ADD_SQL_CONNECTION_TEST Procedure
- 153.4.2 CLEAR_ALL_CONTEXT Procedure
- 153.4.3 CLEAR_CONTEXT Procedure
- 153.4.4 CLEAR_IDENTIFIER Procedure
- 153.4.5 CLOSE_DATABASE_LINK Procedure
- 153.4.6 CURRENT_IS_ROLE_ENABLED Function
- 153.4.7 FREE_UNUSED_USER_MEMORY Procedure
- 153.4.8 GET_PACKAGE_MEMORY_UTILIZATION Procedure
- 153.4.9 IS_ROLE_ENABLED Function
- 153.4.10 IS_SESSION_ALIVE Function
- 153.4.11 LIST_CONTEXT Procedures
- 153.4.12 MODIFY_PACKAGE_STATE Procedure
- 153.4.13 RESET_PACKAGE Procedure
- 153.4.14 SESSION_IS_ROLE_ENABLED Function
- 153.4.15 SESSION_TRACE_DISABLE Procedure
- 153.4.16 SESSION _TRACE_ENABLE Procedure
- 153.4.17 SET_CONTEXT Procedure
- 153.4.18 SET_EDITION_DEFERRED Procedure
- 153.4.19 SET_IDENTIFIER Procedure
- 153.4.20 SET_NLS Procedure
- 153.4.21 SET_ROLE Procedure
- 153.4.22 SET_SQL_TRACE Procedure
- 153.4.23 SLEEP Procedure
- 153.4.24 SWITCH_CURRENT_CONSUMER_GROUP Procedure
- 153.4.25 UNIQUE_SESSION_ID Function
- 154 DBMS_SFW_ACL_ADMIN
- 155 DBMS_SODA
- 156 DBMS_SHARED_POOL
-
157
DBMS_SPACE
- 157.1 DBMS_SPACE Security Model
- 157.2 DBMS_SPACE Data Structures
-
157.3
Summary of DBMS_SPACE Subprograms
- 157.3.1 DBMS_SPACE ASA_RECOMMENDATIONS Function
- 157.3.2 CREATE_INDEX_COST Procedure
- 157.3.3 CREATE_TABLE_COST Procedures
- 157.3.4 FREE_BLOCKS Procedure
- 157.3.5 ISDATAFILEDROPPABLE_NAME Procedure
- 157.3.6 OBJECT_DEPENDENT_SEGMENTS Function
- 157.3.7 OBJECT_GROWTH_TREND Function
- 157.3.8 SPACE_USAGE Procedures
- 157.3.9 UNUSED_SPACE Procedure
-
158
DBMS_SPACE_ADMIN
- 158.1 DBMS_SPACE_ADMIN Security Model
- 158.2 DBMS_SPACE_ADMIN Constants
- 158.3 DBMS_SPACE_ADMIN Operational Notes
-
158.4
Summary of DBMS_SPACE_ADMIN Subprograms
- 158.4.1 ASSM_SEGMENT_VERIFY Procedure
- 158.4.2 ASSM_TABLESPACE_VERIFY Procedure
- 158.4.3 DROP_EMPTY_SEGMENTS Procedure
- 158.4.4 GET_SEGADV_ATTRIB Procedure
- 158.4.5 MATERIALIZE_DEFERRED_SEGMENTS Procedure
- 158.4.6 SEGMENT_CORRUPT Procedure
- 158.4.7 SEGMENT_DROP_CORRUPT Procedure
- 158.4.8 SEGMENT_DUMP Procedure
- 158.4.9 SEGMENT_VERIFY Procedure
- 158.4.10 SET_SEGADV_ATTRIB Procedure
- 158.4.11 TABLESPACE_FIX_BITMAPS Procedure
- 158.4.12 TABLESPACE_FIX_SEGMENT_STATES Procedure
- 158.4.13 TABLESPACE_MIGRATE_FROM_LOCAL Procedure
- 158.4.14 TABLESPACE_MIGRATE_TO_LOCAL Procedure
- 158.4.15 TABLESPACE_REBUILD_BITMAPS Procedure
- 158.4.16 TABLESPACE_REBUILD_QUOTAS Procedure
- 158.4.17 TABLESPACE_RELOCATE_BITMAPS Procedure
- 158.4.18 TABLESPACE_VERIFY Procedure
-
159
DBMS_SPD
- 159.1 DBMS_SPD Overview
- 159.2 DBMS_SPD Security Model
- 159.3 DBMS_SPD Views
-
159.4
Summary of DBMS_SPD Subprograms
- 159.4.1 ALTER_SQL_PLAN_DIRECTIVE Procedure
- 159.4.2 CREATE_STGTAB_DIRECTIVE Procedure
- 159.4.3 DROP_SQL_PLAN_DIRECTIVE Procedure
- 159.4.4 FLUSH_SQL_PLAN_DIRECTIVE Procedure
- 159.4.5 GET_PREFS Function
- 159.4.6 PACK_STGTAB_DIRECTIVE Function
- 159.4.7 SET_PREFS Procedure
- 159.4.8 UNPACK_STGTAB_DIRECTIVE Function
-
160
DBMS_SPM
- 160.1 DBMS_SPM Overview
- 160.2 DBMS_SPM Security Model
- 160.3 DBMS_SPM Constants
- 160.4 DBMS_SPM Examples
- 160.5 DBMS_SPM Data Structures
-
160.6
Summary of DBMS_SPM Subprograms
- 160.6.1 ACCEPT_SQL_PLAN_BASELINE Procedure
- 160.6.2 ALTER_SQL_PLAN_BASELINE Function
- 160.6.3 CANCEL_EVOLVE_TASK Procedure
- 160.6.4 CONFIGURE Procedure
- 160.6.5 CREATE_EVOLVE_TASK Function
- 160.6.6 CREATE_STGTAB_BASELINE Procedure
- 160.6.7 DROP_EVOLVE_TASK Procedure
- 160.6.8 DROP_SQL_PLAN_BASELINE Function
- 160.6.9 EVOLVE_SQL_PLAN_BASELINE Function
- 160.6.10 EXECUTE_EVOLVE_TASK Function
- 160.6.11 IMPLEMENT_EVOLVE_TASK Function
- 160.6.12 INTERRUPT_EVOLVE_TASK Procedure
- 160.6.13 LOAD_PLANS_FROM_AWR Function
- 160.6.14 LOAD_PLANS_FROM_CURSOR_CACHE Functions
- 160.6.15 LOAD_PLANS_FROM_SQLSET Function
- 160.6.16 MIGRATE_STORED_OUTLINE Functions
- 160.6.17 PACK_STGTAB_BASELINE Function
- 160.6.18 RESET_EVOLVE_TASK Procedure
- 160.6.19 RESUME_EVOLVE_TASK Procedure
- 160.6.20 REPORT_AUTO_EVOLVE_TASK Function
- 160.6.21 REPORT_EVOLVE_TASK Function
- 160.6.22 SET_EVOLVE_TASK_PARAMETER Procedure
- 160.6.23 UNPACK_STGTAB_BASELINE Function
-
161
DBMS_SQL
- 161.1 DBMS_SQL Overview
- 161.2 DBMS_SQL Security Model
- 161.3 DBMS_SQL Constants
- 161.4 DBMS_SQL Operational Notes
-
161.5
DBMS_SQL Execution Flow
- 161.5.1 OPEN_CURSOR
- 161.5.2 PARSE
- 161.5.3 BIND_VARIABLE, BIND_VARIABLE_PKG or BIND_ARRAY
- 161.5.4 DEFINE_COLUMN, DEFINE_COLUMN_LONG, or DEFINE_ARRAY
- 161.5.5 EXECUTE
- 161.5.6 FETCH_ROWS or EXECUTE_AND_FETCH
- 161.5.7 VARIABLE_VALUE, VARIABLE_VALUE_PKG, COLUMN_VALUE, or COLUMN_VALUE_LONG
- 161.5.8 CLOSE_CURSOR
- 161.6 DBMS_SQL Exceptions
- 161.7 DBMS_SQL Examples
-
161.8
DBMS_SQL Data Structures
- 161.8.1 DBMS_SQL DESC_REC Record Type
- 161.8.2 DBMS_SQL DESC_REC2 Record Type
- 161.8.3 DBMS_SQL DESC_REC3 Record Type
- 161.8.4 DBMS_SQL DESC_REC4 Record Type
- 161.8.5 DBMS_SQL BFILE_TABLE Table Type
- 161.8.6 DBMS_SQL BINARY_DOUBLE_TABLE Table Type
- 161.8.7 DBMS_SQL BINARY_FLOAT_TABLE Table Type
- 161.8.8 DBMS_SQL BLOB_TABLE Table Type
- 161.8.9 DBMS_SQL CLOB_TABLE Table Type
- 161.8.10 DBMS_SQL DATE_TABLE Table Type
- 161.8.11 DBMS_SQL DESC_TAB Table Type
- 161.8.12 DBMS_SQL DESC_TAB2 Table Type
- 161.8.13 DBMS_SQL DESC_TAB3 Table Type
- 161.8.14 DBMS_SQL DESC_TAB4 Table Type
- 161.8.15 DBMS_SQL INTERVAL_DAY_TO_SECOND_TABLE Table Type
- 161.8.16 DBMS_SQL INTERVAL_YEAR_TO_MONTH_TABLE Table Type
- 161.8.17 DBMS_SQL NUMBER_TABLE Table Type
- 161.8.18 DBMS_SQL TIME_TABLE Table Type
- 161.8.19 DBMS_SQL TIME_WITH_TIME_ZONE_TABLE Table Type
- 161.8.20 DBMS_SQL TIMESTAMP_TABLE Table Type
- 161.8.21 DBMS_SQL TIMESTAMP_WITH_LTZ_TABLE Table Type
- 161.8.22 DBMS_SQL TIMESTAMP_WITH_TIME_ZONE_TABLE Table Type
- 161.8.23 DBMS_SQL UROWID_TABLE Table Type
- 161.8.24 DBMS_SQL VARCHAR2_TABLE Table Type
- 161.8.25 DBMS_SQL VARCHAR2A Table Type
- 161.8.26 DBMS_SQL VARCHAR2S Table Type
-
161.9
Summary of DBMS_SQL Subprograms
- 161.9.1 BIND_ARRAY Procedures
- 161.9.2 BIND_VARIABLE Procedures
- 161.9.3 BIND_VARIABLE_PKG Procedure
- 161.9.4 CLOSE_CURSOR Procedure
- 161.9.5 COLUMN_VALUE Procedure
- 161.9.6 COLUMN_VALUE_LONG Procedure
- 161.9.7 DEFINE_ARRAY Procedure
- 161.9.8 DEFINE_COLUMN Procedures
- 161.9.9 DEFINE_COLUMN_CHAR Procedure
- 161.9.10 DEFINE_COLUMN_LONG Procedure
- 161.9.11 DEFINE_COLUMN_RAW Procedure
- 161.9.12 DEFINE_COLUMN_ROWID Procedure
- 161.9.13 DESCRIBE_COLUMNS Procedure
- 161.9.14 DESCRIBE_COLUMNS2 Procedure
- 161.9.15 DESCRIBE_COLUMNS3 Procedure
- 161.9.16 EXECUTE Function
- 161.9.17 EXECUTE_AND_FETCH Function
- 161.9.18 FETCH_ROWS Function
- 161.9.19 GET_NEXT_RESULT Procedures
- 161.9.20 IS_OPEN Function
- 161.9.21 LAST_ERROR_POSITION Function
- 161.9.22 LAST_ROW_COUNT Function
- 161.9.23 LAST_ROW_ID Function
- 161.9.24 LAST_SQL_FUNCTION_CODE Function
- 161.9.25 OPEN_CURSOR Functions
- 161.9.26 PARSE Procedures
- 161.9.27 RETURN_RESULT Procedures
- 161.9.28 TO_CURSOR_NUMBER Function
- 161.9.29 TO_REFCURSOR Function
- 161.9.30 VARIABLE_VALUE Procedures
- 161.9.31 VARIABLE_VALUE_PKG Procedure
- 162 DBMS_SQL_MONITOR
-
163
DBMS_SQL_TRANSLATOR
- 163.1 DBMS_SQL_TRANSLATOR Security Model
- 163.2 DBMS_SQL_TRANSLATOR Constants
- 163.3 DBMS_SQL_TRANSLATOR Operational Notes
- 163.4 DBMS_SQL_TRANSLATOR Exceptions
- 163.5 DBMS_SQL_TRANSLATOR Examples
-
163.6
Summary of DBMS_SQL_TRANSLATOR Subprograms
- 163.6.1 CREATE_PROFILE Procedure
- 163.6.2 DEREGISTER_SQL_TRANSLATION Procedure
- 163.6.3 DEREGISTER_ERROR_TRANSLATION Procedure
- 163.6.4 DROP_PROFILE Procedure
- 163.6.5 ENABLE_ERROR_TRANSLATION Procedure
- 163.6.6 ENABLE_SQL_TRANSLATION Procedure
- 163.6.7 EXPORT_PROFILE Procedure
- 163.6.8 IMPORT_PROFILE Procedure
- 163.6.9 REGISTER_ERROR_TRANSLATION Procedure
- 163.6.10 REGISTER_SQL_TRANSLATION Procedure
- 163.6.11 SET_ATTRIBUTE Procedure
- 163.6.12 SQL_HASH Function
- 163.6.13 SQL_ID Function
- 163.6.14 TRANSLATE_ERROR Procedure
- 163.6.15 TRANSLATE_SQL Procedure
-
164
DBMS_SQLDIAG
- 164.1 DBMS_SQLDIAG Overview
- 164.2 DBMS_SQLDIAG Security Model
- 164.3 DBMS_SQLDIAG Constants
-
164.4
Summary of DBMS_SQLDIAG Subprograms
- 164.4.1 ACCEPT_SQL_PATCH Function & Procedure
- 164.4.2 ALTER_SQL_PATCH Procedure
- 164.4.3 CANCEL_DIAGNOSIS_TASK Procedure
- 164.4.4 CREATE_DIAGNOSIS_TASK Functions
- 164.4.5 CREATE_SQL_PATCH Function
- 164.4.6 CREATE_STGTAB_SQLPATCH Procedure
- 164.4.7 DROP_DIAGNOSIS_TASK Procedure
- 164.4.8 DROP_SQL_PATCH Procedure
- 164.4.9 EXECUTE_DIAGNOSIS_TASK Procedure
- 164.4.10 EXPLAIN_SQL_TESTCASE Function
- 164.4.11 EXPORT_SQL_TESTCASE Procedures
- 164.4.12 EXPORT_SQL_TESTCASE_DIR_BY_INC Function
- 164.4.13 EXPORT_SQL_TESTCASE_DIR_BY_TXT Function
- 164.4.14 GET_FIX_CONTROL Function
- 164.4.15 GET_SQL Function
- 164.4.16 IMPORT_SQL_TESTCASE Procedures
- 164.4.17 INCIDENTID_2_SQL Procedure
- 164.4.18 INTERRUPT_DIAGNOSIS_TASK Procedure
- 164.4.19 LOAD_SQLSET_FROM_TCB Function
- 164.4.20 PACK_STGTAB_SQLPATCH Procedure
- 164.4.21 REPLAY_SQL_TESTCASE Function
- 164.4.22 REPORT_DIAGNOSIS_TASK Function
- 164.4.23 RESET_DIAGNOSIS_TASK Procedure
- 164.4.24 RESUME_DIAGNOSIS_TASK Procedure
- 164.4.25 SET_DIAGNOSIS_TASK_PARAMETER Procedure
- 164.4.26 SQL_DIAGNOSE_AND_REPAIR Function
- 164.4.27 UNPACK_STGTAB_SQLPATCH Procedure
-
165
DBMS_SQLPA
- 165.1 DBMS_SQLPA Overview
- 165.2 DBMS_SQLPA Security Model
-
165.3
Summary of DBMS_SQLPA Subprograms
- 165.3.1 CANCEL_ANALYSIS_TASK Procedure
- 165.3.2 CREATE_ANALYSIS_TASK Functions
- 165.3.3 DROP_ANALYSIS_TASK Procedure
- 165.3.4 EXECUTE_ANALYSIS_TASK Function & Procedure
- 165.3.5 INTERRUPT_ANALYSIS_TASK Procedure
- 165.3.6 REPORT_ANALYSIS_TASK Function
- 165.3.7 RESET_ANALYSIS_TASK Procedure
- 165.3.8 RESUME_ANALYSIS_TASK Procedure
- 165.3.9 SET_ANALYSIS_TASK_PARAMETER Procedures
- 165.3.10 SET_ANALYSIS_DEFAULT_PARAMETER Procedures
-
166
DBMS_SQLQ
- 166.1 DBMS_SQLQ Overview
-
166.2
Summary of DBMS_SQLQ Subprograms
- 166.2.1 ALTER_QUARANTINE Procedure
- 166.2.2 CREATE_QUARANTINE_BY_SQL_ID Function
- 166.2.3 CREATE_QUARANTINE_BY_SQL_TEXT Function
- 166.2.4 CREATE_STGTAB_QUARANTINE Procedure
- 166.2.5 DROP_QUARANTINE Procedure
- 166.2.6 GET_PARAM_VALUE_QUARANTINE Function
- 166.2.7 PACK_STGTAB_QUARANTINE Function
- 166.2.8 UNPACK_STGTAB_QUARANTINE Function
-
167
DBMS_SQLSET
- 167.1 DBMS_SQLSET Overview
- 167.2 DBMS_SQLSET Security Model
- 167.3 DBMS_SQLSET Data Structures
-
167.4
Summary of DBMS_SQLSET Subprograms
- 167.4.1 ADD_REFERENCE Function
- 167.4.2 CAPTURE_CURSOR_CACHE Procedure
- 167.4.3 CREATE_SQLSET Procedure and Function
- 167.4.4 CREATE_STGTAB Procedure
- 167.4.5 DELETE_SQLSET Procedure
- 167.4.6 DROP_SQLSET Procedure
- 167.4.7 LOAD_SQLSET Procedure
- 167.4.8 PACK_STGTAB Procedure
- 167.4.9 REMAP_STGTAB Procedure
- 167.4.10 REMOVE_REFERENCE Procedure
- 167.4.11 SELECT_CURSOR_CACHE Function
- 167.4.12 SELECT_SQL_TRACE Function
- 167.4.13 SELECT_SQLPA_TASK Function
- 167.4.14 SELECT_SQLSET Function
- 167.4.15 SELECT_WORKLOAD_REPOSITORY Function
- 167.4.16 UNPACK_STGTAB Procedure
- 167.4.17 UPDATE_SQLSET Procedures
-
168
DBMS_SQLTUNE
- 168.1 DBMS_SQLTUNE Overview
- 168.2 DBMS_SQLTUNE Security Model
- 168.3 DBMS_SQLTUNE Data Structures
- 168.4 DBMS_SQLTUNE Subprogram Groups
-
168.5
Summary of DBMS_SQLTUNE Subprograms
- 168.5.1 ACCEPT_ALL_SQL_PROFILES Procedure
- 168.5.2 ACCEPT_SQL_PROFILE Procedure and Function
- 168.5.3 ADD_SQLSET_REFERENCE Function
- 168.5.4 ALTER_SQL_PROFILE Procedure
- 168.5.5 CANCEL_TUNING_TASK Procedure
- 168.5.6 CAPTURE_CURSOR_CACHE_SQLSET Procedure
- 168.5.7 CREATE_SQL_PLAN_BASELINE Procedure
- 168.5.8 CREATE_SQLSET Procedure and Function
- 168.5.9 CREATE_STGTAB_SQLPROF Procedure
- 168.5.10 CREATE_STGTAB_SQLSET Procedure
- 168.5.11 CREATE_TUNING_TASK Functions
- 168.5.12 DELETE_SQLSET Procedure
- 168.5.13 DROP_SQL_PROFILE Procedure
- 168.5.14 DROP_SQLSET Procedure
- 168.5.15 DROP_TUNING_TASK Procedure
- 168.5.16 EXECUTE_TUNING_TASK Function and Procedure
- 168.5.17 IMPLEMENT_TUNING_TASK Procedure
- 168.5.18 INTERRUPT_TUNING_TASK Procedure
- 168.5.19 LOAD_SQLSET Procedure
- 168.5.20 PACK_STGTAB_SQLPROF Procedure
- 168.5.21 PACK_STGTAB_SQLSET Procedure
- 168.5.22 REMAP_STGTAB_SQLPROF Procedure
- 168.5.23 REMAP_STGTAB_SQLSET Procedure
- 168.5.24 REMOVE_SQLSET_REFERENCE Procedure
- 168.5.25 REPORT_AUTO_TUNING_TASK Function
- 168.5.26 REPORT_SQL_DETAIL Function
- 168.5.27 REPORT_SQL_MONITOR Function
- 168.5.28 REPORT_SQL_MONITOR_LIST Function
- 168.5.29 REPORT_TUNING_TASK Function
- 168.5.30 REPORT_TUNING_TASK_XML Function
- 168.5.31 RESET_TUNING_TASK Procedure
- 168.5.32 RESUME_TUNING_TASK Procedure
- 168.5.33 SCHEDULE_TUNING_TASK Function
- 168.5.34 SCRIPT_TUNING_TASK Function
- 168.5.35 SELECT_CURSOR_CACHE Function
- 168.5.36 SELECT_SQL_TRACE Function
- 168.5.37 SELECT_SQLPA_TASK Function
- 168.5.38 SELECT_SQLSET Function
- 168.5.39 SELECT_WORKLOAD_REPOSITORY Function
- 168.5.40 SET_TUNING_TASK_PARAMETER Procedures
- 168.5.41 SQLTEXT_TO_SIGNATURE Function
- 168.5.42 UNPACK_STGTAB_SQLPROF Procedure
- 168.5.43 UNPACK_STGTAB_SQLSET Procedure
- 168.5.44 UPDATE_SQLSET Procedures
- 169 DBMS_STAT_FUNCS
-
170
DBMS_STATS
- 170.1 DBMS_STATS Overview
- 170.2 DBMS_STATS Deprecated Subprograms
- 170.3 DBMS_STATS Types
- 170.4 DBMS_STATS Constants
- 170.5 DBMS_STATS Operational Notes
- 170.6 DBMS_STATS Data Structures
-
170.7
Summary of DBMS_STATS Subprograms
- 170.7.1 ALTER_STATS_HISTORY_RETENTION Procedure
- 170.7.2 CANCEL_ADVISOR_TASK Procedure
- 170.7.3 CONFIGURE_ADVISOR_FILTER Function
- 170.7.4 CONFIGURE_ADVISOR_OBJ_FILTER Function
- 170.7.5 CONFIGURE_ADVISOR_OPR_FILTER Functions
- 170.7.6 CONFIGURE_ADVISOR_RULE_FILTER Function
- 170.7.7 CONVERT_RAW_VALUE Procedures
- 170.7.8 CONVERT_RAW_VALUE_NVARCHAR Procedure
- 170.7.9 CONVERT_RAW_VALUE_ROWID Procedure
- 170.7.10 COPY_TABLE_STATS Procedure
- 170.7.11 CREATE_ADVISOR_TASK Function
- 170.7.12 CREATE_EXTENDED_STATS Function
- 170.7.13 CREATE_STAT_TABLE Procedure
- 170.7.14 DELETE_COLUMN_STATS Procedure
- 170.7.15 DELETE_DATABASE_PREFS Procedure
- 170.7.16 DELETE_DATABASE_STATS Procedure
- 170.7.17 DELETE_DICTIONARY_STATS Procedure
- 170.7.18 DELETE_FIXED_OBJECTS_STATS Procedure
- 170.7.19 DELETE_INDEX_STATS Procedure
- 170.7.20 DELETE_PENDING_STATS Procedure
- 170.7.21 DELETE_PROCESSING_RATE Procedure
- 170.7.22 DELETE_SCHEMA_PREFS Procedure
- 170.7.23 DELETE_SCHEMA_STATS Procedure
- 170.7.24 DELETE_SYSTEM_STATS Procedure
- 170.7.25 DELETE_TABLE_PREFS Procedure
- 170.7.26 DELETE_TABLE_STATS Procedure
- 170.7.27 DIFF_TABLE_STATS_IN_HISTORY Function
- 170.7.28 DIFF_TABLE_STATS_IN_PENDING Function
- 170.7.29 DIFF_TABLE_STATS_IN_STATTAB Function
- 170.7.30 DROP_ADVISOR_TASK Procedure
- 170.7.31 DROP_EXTENDED_STATS Procedure
- 170.7.32 DROP_STAT_TABLE Procedure
- 170.7.33 EXECUTE_ADVISOR_TASK Function
- 170.7.34 EXPORT_COLUMN_STATS Procedure
- 170.7.35 EXPORT_DATABASE_PREFS Procedure
- 170.7.36 EXPORT_DATABASE_STATS Procedure
- 170.7.37 EXPORT_DICTIONARY_STATS Procedure
- 170.7.38 EXPORT_FIXED_OBJECTS_STATS Procedure
- 170.7.39 EXPORT_INDEX_STATS Procedure
- 170.7.40 EXPORT_PENDING_STATS Procedure
- 170.7.41 EXPORT_SCHEMA_PREFS Procedure
- 170.7.42 EXPORT_SCHEMA_STATS Procedure
- 170.7.43 EXPORT_SYSTEM_STATS Procedure
- 170.7.44 EXPORT_TABLE_PREFS Procedure
- 170.7.45 EXPORT_TABLE_STATS Procedure
- 170.7.46 FLUSH_DATABASE_MONITORING_INFO Procedure
- 170.7.47 GATHER_DATABASE_STATS Procedures
- 170.7.48 GATHER_DICTIONARY_STATS Procedure
- 170.7.49 GATHER_FIXED_OBJECTS_STATS Procedure
- 170.7.50 GATHER_INDEX_STATS Procedure
- 170.7.51 GATHER_PROCESSING_RATE Procedure
- 170.7.52 GATHER_SCHEMA_STATS Procedures
- 170.7.53 GATHER_SYSTEM_STATS Procedure
- 170.7.54 GATHER_TABLE_STATS Procedure
- 170.7.55 GENERATE_STATS Procedure
- 170.7.56 GET_ADVISOR_OPR_FILTER Procedure
- 170.7.57 GET_ADVISOR_RECS Function
- 170.7.58 GET_COLUMN_STATS Procedures
- 170.7.59 GET_INDEX_STATS Procedures
- 170.7.60 GET_PARAM Function
- 170.7.61 GET_PREFS Function
- 170.7.62 GET_STATS_HISTORY_AVAILABILITY Function
- 170.7.63 GET_STATS_HISTORY_RETENTION Function
- 170.7.64 GET_SYSTEM_STATS Procedure
- 170.7.65 GET_TABLE_STATS Procedure
- 170.7.66 IMPLEMENT_ADVISOR_TASK Function
- 170.7.67 IMPORT_COLUMN_STATS Procedure
- 170.7.68 IMPORT_DATABASE_PREFS Procedure
- 170.7.69 IMPORT_DATABASE_STATS Procedure
- 170.7.70 IMPORT_DICTIONARY_STATS Procedure
- 170.7.71 IMPORT_FIXED_OBJECTS_STATS Procedure
- 170.7.72 IMPORT_INDEX_STATS Procedure
- 170.7.73 IMPORT_SCHEMA_PREFS Procedure
- 170.7.74 IMPORT_SCHEMA_STATS Procedure
- 170.7.75 IMPORT_SYSTEM_STATS Procedure
- 170.7.76 IMPORT_TABLE_PREFS Procedure
- 170.7.77 IMPORT_TABLE_STATS Procedure
- 170.7.78 INTERRUPT_ADVISOR_TASK Procedure
- 170.7.79 LOCK_PARTITION_STATS Procedure
- 170.7.80 LOCK_SCHEMA_STATS Procedure
- 170.7.81 LOCK_TABLE_STATS Procedure
- 170.7.82 MERGE_COL_USAGE Procedure
- 170.7.83 PREPARE_COLUMN_VALUES Procedures
- 170.7.84 PREPARE_COLUMN_VALUES_NVARCHAR Procedure
- 170.7.85 PREPARE_COLUMN_VALUES_ROWID Procedure
- 170.7.86 PUBLISH_PENDING_STATS Procedure
- 170.7.87 PURGE_STATS Procedure
- 170.7.88 REMAP_STAT_TABLE Procedure
- 170.7.89 REPORT_ADVISOR_TASK Function
- 170.7.90 REPORT_COL_USAGE Function
- 170.7.91 REPORT_GATHER_AUTO_STATS Function
- 170.7.92 REPORT_GATHER_DATABASE_STATS Functions
- 170.7.93 REPORT_GATHER_DICTIONARY_STATS Functions
- 170.7.94 REPORT_GATHER_FIXED_OBJ_STATS Function
- 170.7.95 REPORT_GATHER_SCHEMA_STATS Functions
- 170.7.96 REPORT_GATHER_TABLE_STATS Function
- 170.7.97 REPORT_SINGLE_STATS_OPERATION Function
- 170.7.98 REPORT_STATS_OPERATIONS Function
- 170.7.99 RESET_ADVISOR_TASK Procedure
- 170.7.100 RESET_COL_USAGE Procedure
- 170.7.101 RESET_GLOBAL_PREF_DEFAULTS Procedure
- 170.7.102 RESET_PARAM_DEFAULTS Procedure
- 170.7.103 RESTORE_DATABASE_STATS Procedure
- 170.7.104 RESTORE_DICTIONARY_STATS Procedure
- 170.7.105 RESTORE_FIXED_OBJECTS_STATS Procedure
- 170.7.106 RESTORE_SCHEMA_STATS Procedure
- 170.7.107 RESTORE_SYSTEM_STATS Procedure
- 170.7.108 RESTORE_TABLE_STATS Procedure
- 170.7.109 RESUME_ADVISOR_TASK Procedure
- 170.7.110 SCRIPT_ADVISOR_TASK Function
- 170.7.111 SEED_COL_USAGE Procedure
- 170.7.112 SET_ADVISOR_TASK_PARAMETER Procedure
- 170.7.113 SET_COLUMN_STATS Procedures
- 170.7.114 SET_DATABASE_PREFS Procedure
- 170.7.115 SET_GLOBAL_PREFS Procedure
- 170.7.116 SET_INDEX_STATS Procedures
- 170.7.117 SET_PARAM Procedure
- 170.7.118 SET_PROCESSING_RATE Procedure
- 170.7.119 SET_SCHEMA_PREFS Procedure
- 170.7.120 SET_SYSTEM_STATS Procedure
- 170.7.121 SET_TABLE_PREFS Procedure
- 170.7.122 SET_TABLE_STATS Procedure
- 170.7.123 SHOW_EXTENDED_STATS_NAME Function
- 170.7.124 TRANSFER_STATS Procedure
- 170.7.125 UNLOCK_PARTITION_STATS Procedure
- 170.7.126 UNLOCK_SCHEMA_STATS Procedure
- 170.7.127 UNLOCK_TABLE_STATS Procedure
- 170.7.128 UPGRADE_STAT_TABLE Procedure
- 171 DBMS_STORAGE_MAP
-
172
DBMS_SYNC_REFRESH
- 172.1 DBMS_SYNC_REFRESH Overview
- 172.2 DBMS_SYNC_REFRESH Security Model
-
172.3
Summary of DBMS_SYNC_REFRESH Subprograms
- 172.3.1 ABORT_REFRESH Procedure
- 172.3.2 ALTER_REFRESH_STATS_RETENTION Procedure
- 172.3.3 CAN_SYNCREF_TABLE Procedure
- 172.3.4 EXECUTE_REFRESH Procedure
- 172.3.5 GET_ALL_GROUP_IDS Function
- 172.3.6 GET_GROUP_ID Function
- 172.3.7 GET_GROUP_ID_LIST Function
- 172.3.8 PREPARE_REFRESH Procedure
- 172.3.9 PREPARE_STAGING_LOG Procedure
- 172.3.10 PURGE_REFRESH_STATS Procedure
- 172.3.11 REGISTER_MVIEWS
- 172.3.12 REGISTER_PARTITION_OPERATION Procedure
- 172.3.13 UNREGISTER_MVIEWS
- 172.3.14 UNREGISTER_PARTITION_OPERATION Procedure
- 173 DBMS_TABLE_DATA
- 174 DBMS_TDB
-
175
DBMS_TF
- 175.1 DBMS_TF Overview
- 175.2 DBMS_TF Security Model
- 175.3 DBMS_TF Constants
- 175.4 DBMS_TF Operational Notes
- 175.5 DBMS_TF Execution Flow
- 175.6 DBMS_TF Restrictions
- 175.7 DBMS_TF Examples
-
175.8
DBMS_TF Data Structures
- 175.8.1 Supported Types Collections
- 175.8.2 COLUMN_DATA_T Record Type
- 175.8.3 COLUMN_METADATA_T Record Type
- 175.8.4 COLUMN_T Record Type
- 175.8.5 DESCRIBE_T Record Type
- 175.8.6 ENV_T Record Type
- 175.8.7 PARALLEL_ENV_T Record Type
- 175.8.8 TABLE_T Record Type
- 175.8.9 COLUMNS_NEW_T Table Type
- 175.8.10 COLUMNS_T Table Type
- 175.8.11 COLUMNS_WITH_TYPE_T Table Type
- 175.8.12 TABLE_COLUMNS_T Table Type
- 175.8.13 ROW_SET_T Table Type
- 175.8.14 XID_T Subtype
-
175.9
Summary of DBMS_TF Subprograms
- 175.9.1 COLUMN_TYPE_NAME Function
- 175.9.2 COL_TO_CHAR Function
- 175.9.3 CSTORE_EXISTS Function
- 175.9.4 CSTORE_GET Procedure
- 175.9.5 GET_COL Procedure
- 175.9.6 GET_ENV Function
- 175.9.7 GET_ROW_SET Procedure
- 175.9.8 GET_XID Function
- 175.9.9 PUT_COL Procedure
- 175.9.10 PUT_ROW_SET Procedure
- 175.9.11 ROW_REPLICATION Procedure
- 175.9.12 ROW_TO_CHAR Function
- 175.9.13 SUPPORTED_TYPE Function
- 175.9.14 TRACE Procedure
- 175.9.15 XSTORE_CLEAR Procedure
- 175.9.16 XSTORE_EXISTS Function
- 175.9.17 XSTORE_GET Procedure
- 175.9.18 XSTORE_REMOVE Procedure
- 175.9.19 XSTORE_SET Procedure
- 176 DBMS_TNS
- 177 DBMS_TRACE
-
178
DBMS_TRANSACTION
- 178.1 DBMS_TRANSACTION Security Model
-
178.2
Summary of DBMS_TRANSACTION Subprograms
- 178.2.1 ADVISE_COMMIT Procedure
- 178.2.2 ADVISE_NOTHING Procedure
- 178.2.3 ADVISE_ROLLBACK Procedure
- 178.2.4 COMMIT Procedure
- 178.2.5 COMMIT_COMMENT Procedure
- 178.2.6 COMMIT_FORCE Procedure
- 178.2.7 LOCAL_TRANSACTION_ID Function
- 178.2.8 PURGE_LOST_DB_ENTRY Procedure
- 178.2.9 PURGE_MIXED Procedure
- 178.2.10 READ_ONLY Procedure
- 178.2.11 READ_WRITE Procedure
- 178.2.12 ROLLBACK Procedure
- 178.2.13 ROLLBACK_FORCE Procedure
- 178.2.14 ROLLBACK_SAVEPOINT Procedure
- 178.2.15 SAVEPOINT Procedure
- 178.2.16 STEP_ID Function
- 178.2.17 USE_ROLLBACK_SEGMENT Procedure
- 179 DBMS_TRANSFORM
-
180
DBMS_TSDP_MANAGE
- 180.1 DBMS_TSDP_MANAGE Overview
- 180.2 DBMS_TSDP_MANAGE Security Model
-
180.3
Summary of DBMS_TSDP_MANAGE Subprograms
- 180.3.1 ADD_SENSITIVE_COLUMN Procedure
- 180.3.2 ALTER_SENSITIVE_COLUMN Procedure
- 180.3.3 ADD_SENSITIVE_TYPE Procedure
- 180.3.4 DROP_SENSITIVE_COLUMN Procedure
- 180.3.5 DROP_SENSITIVE_TYPE Procedure
- 180.3.6 DROP_SENSITIVE_TYPE_SOURCE Procedure
- 180.3.7 IMPORT_DISCOVERY_RESULT Procedure
- 180.3.8 IMPORT_SENSITIVE_TYPES Procedure
- 180.3.9 REMOVE_DISCOVERY_RESULT Procedure
-
181
DBMS_TSDP_PROTECT
- 181.1 DBMS_TSDP_PROTECT Overview
- 181.2 DBMS_TSDP_PROTECT Security Model
- 181.3 DBMS_TSDP_PROTECT Constants
- 181.4 DBMS_TSDP_PROTECT Data Structures
-
181.5
Summary of DBMS_TSDP_PROTECT Subprograms
- 181.5.1 ADD_POLICY Procedure
- 181.5.2 ALTER_POLICY Procedure
- 181.5.3 ASSOCIATE_POLICY Procedure
- 181.5.4 DISABLE_PROTECTION_COLUMN Procedure
- 181.5.5 DISABLE_PROTECTION_SOURCE Procedure
- 181.5.6 DISABLE_PROTECTION_TYPE Procedure
- 181.5.7 DROP_POLICY Procedure
- 181.5.8 ENABLE_PROTECTION_COLUMN Procedure
- 181.5.9 ENABLE_PROTECTION_SOURCE Procedure
- 181.5.10 ENABLE_PROTECTION_TYPE Procedure
- 182 DBMS_TTS
- 183 DBMS_TYPES
-
184
DBMS_UMF
-
184.1
Summary of DBMS_UMF Subprograms
- 184.1.1 CONFIGURE_NODE Procedure
- 184.1.2 CREATE_LINK Procedure
- 184.1.3 CREATE_TOPOLOGY Procedure
- 184.1.4 DROP_LINK Procedure
- 184.1.5 DROP_TOPOLOGY Procedure
- 184.1.6 ENABLE_SERVICE Procedure
- 184.1.7 GET_NODE_ID_LOCAL Function
- 184.1.8 GET_NODE_NAME_LOCAL Function
- 184.1.9 GET_TARGET_ID Function
- 184.1.10 GET_TOPOLOGY_NAME_LOCAL Function
- 184.1.11 QUERY_LINK_INFO Procedure
- 184.1.12 QUERY_NODE_INFO Procedures
- 184.1.13 REGISTER_NODE Function and Procedure
- 184.1.14 SWITCH_DESTINATION Procedure
- 184.1.15 UNCONFIGURE_NODE Procedure
- 184.1.16 UNREGISTER_NODE Procedure
-
184.1
Summary of DBMS_UMF Subprograms
- 185 DBMS_USER_CERTS
-
186
DBMS_UTILITY
- 186.1 DBMS_UTILITY Deprecated Subprograms
- 186.2 DBMS_UTILITY Security Model
- 186.3 DBMS_UTILITY Constants
- 186.4 DBMS_UTILITY Exceptions
-
186.5
DBMS_UTILITY Data Structures
- 186.5.1 DBMS_UTILITY INSTANCE_RECORD Record Type
- 186.5.2 DBMS_UTILITY DBLINK_ARRAY TABLE Type
- 186.5.3 DBMS_UTILITY INDEX_TABLE_TYPE Table Type
- 186.5.4 DBMS_UTILITY INSTANCE_TABLE Table Type
- 186.5.5 DBMS_UTILITY LNAME_ARRAY Table Type
- 186.5.6 DBMS_UTILITY NAME_ARRAY Table Type
- 186.5.7 DBMS_UTILITY NUMBER_ARRAY Table Type
- 186.5.8 DBMS_UTILITY UNCL_ARRAY Table Type
-
186.6
Summary of DBMS_UTILITY Subprograms
- 186.6.1 ACTIVE_INSTANCES Procedure
- 186.6.2 ANALYZE_DATABASE Procedure
- 186.6.3 ANALYZE_PART_OBJECT Procedure
- 186.6.4 ANALYZE_SCHEMA Procedure
- 186.6.5 CANONICALIZE Procedure
- 186.6.6 COMMA_TO_TABLE Procedures
- 186.6.7 COMPILE_SCHEMA Procedure
- 186.6.8 CREATE_ALTER_TYPE_ERROR_TABLE Procedure
- 186.6.9 CURRENT_INSTANCE Function
- 186.6.10 DATA_BLOCK_ADDRESS_BLOCK Function
- 186.6.11 DATA_BLOCK_ADDRESS_FILE Function
- 186.6.12 DB_VERSION Procedure
- 186.6.13 EXEC_DDL_STATEMENT Procedure
- 186.6.14 EXPAND_SQL_TEXT Procedure
- 186.6.15 FORMAT_CALL_STACK Function
- 186.6.16 FORMAT_ERROR_BACKTRACE Function
- 186.6.17 FORMAT_ERROR_STACK Function
- 186.6.18 GET_CPU_TIME Function
- 186.6.19 GET_DEPENDENCY Procedure
- 186.6.20 GET_ENDIANNESS Function
- 186.6.21 GET_HASH_VALUE Function
- 186.6.22 GET_PARAMETER_VALUE Function
- 186.6.23 GET_SQL_HASH Function
- 186.6.24 GET_TIME Function
- 186.6.25 GET_TZ_TRANSITIONS Procedure
- 186.6.26 INVALIDATE Procedure
- 186.6.27 IS_BIT_SET Function
- 186.6.28 IS_CLUSTER_DATABASE Function
- 186.6.29 MAKE_DATA_BLOCK_ADDRESS Function
- 186.6.30 NAME_RESOLVE Procedure
- 186.6.31 NAME_TOKENIZE Procedure
- 186.6.32 OLD_CURRENT_SCHEMA Function
- 186.6.33 OLD_CURRENT_USER Function
- 186.6.34 PORT_STRING Function
- 186.6.35 SQLID_TO_SQLHASH Function
- 186.6.36 TABLE_TO_COMMA Procedures
- 186.6.37 VALIDATE Procedure
- 186.6.38 WAIT_ON_PENDING_DML Function
- 187 DBMS_WARNING
- 188 DBMS_WM
-
189
DBMS_WORKLOAD_CAPTURE
- 189.1 DBMS_WORKLOAD_CAPTURE Overview
- 189.2 DBMS_WORKLOAD_CAPTURE Security Model
-
189.3
Summary of DBMS_WORKLOAD_CAPTURE Subprograms
- 189.3.1 ADD_FILTER Procedures
- 189.3.2 DECRYPT_CAPTURE Procedure
- 189.3.3 DELETE_CAPTURE_INFO Procedure
- 189.3.4 DELETE_FILTER Procedure
- 189.3.5 ENCRYPT_CAPTURE Procedure
- 189.3.6 EXPORT_AWR Procedure
- 189.3.7 FINISH_CAPTURE Procedure
- 189.3.8 GET_CAPTURE_INFO Function
- 189.3.9 IMPORT_AWR Function
- 189.3.10 REPORT Function
- 189.3.11 START_CAPTURE Procedure
-
190
DBMS_WORKLOAD_REPLAY
- 190.1 DBMS_WORKLOAD_REPLAY Overview
- 190.2 DBMS_WORKLOAD_REPLAY Security Model
-
190.3
Summary of DBMS_WORKLOAD_REPLAY Subprograms
- 190.3.1 ADD_CAPTURE Function
- 190.3.2 ADD_FILTER Procedure
- 190.3.3 ADD_SCHEDULE_ORDERING Function
- 190.3.4 ASSIGN_GROUP_TO_INSTANCE Procedure
- 190.3.5 BEGIN_REPLAY_SCHEDULE Procedure
- 190.3.6 CALIBRATE Function
- 190.3.7 CANCEL_REPLAY Procedure
- 190.3.8 COMPARE_PERIOD_REPORT Procedure
- 190.3.9 COMPARE_SQLSET_REPORT Function
- 190.3.10 CREATE_FILTER_SET Procedure
- 190.3.11 DELETE_FILTER Procedure
- 190.3.12 DELETE_REPLAY_INFO Procedure
- 190.3.13 END_REPLAY_SCHEDULE Procedure
- 190.3.14 EXPORT_AWR Procedure
- 190.3.15 GENERATE_CAPTURE_SUBSET Procedure
- 190.3.16 GET_DIVERGING_STATEMENT Function
- 190.3.17 GET_REPLAY_DIRECTORY Function
- 190.3.18 GET_REPLAY_INFO Function
- 190.3.19 GET_REPLAY_TIMEOUT Procedure
- 190.3.20 IMPORT_AWR Function
- 190.3.21 INITIALIZE_CONSOLIDATED_REPLAY Procedure
- 190.3.22 INITIALIZE_REPLAY Procedure
- 190.3.23 IS_REPLAY_PAUSED Function
- 190.3.24 LOAD_LONG_SQLTEXT Procedure
- 190.3.25 PAUSE_REPLAY Procedure
- 190.3.26 POPULATE_DIVERGENCE Procedure
- 190.3.27 PREPARE_CONSOLIDATED_REPLAY Procedure
- 190.3.28 PREPARE_REPLAY Procedure
- 190.3.29 PROCESS_CAPTURE Procedure
- 190.3.30 REMAP_CONNECTION Procedure
- 190.3.31 REMOVE_CAPTURE Procedure
- 190.3.32 REMOVE_SCHEDULE_ORDERING Procedure
- 190.3.33 REPORT Function
- 190.3.34 RESUME_REPLAY Procedure
- 190.3.35 REUSE_REPLAY_FILTER_SET Procedure
- 190.3.36 SET_ADVANCED_PARAMETER Procedure
- 190.3.37 SET_REPLAY_DIRECTORY Procedure
- 190.3.38 SET_REPLAY_TIMEOUT Procedure
- 190.3.39 SET_SQL_MAPPING Procedure
- 190.3.40 SET_USER_MAPPING Procedure
- 190.3.41 START_CONSOLIDATED_REPLAY Procedure
- 190.3.42 START_REPLAY Procedure
- 190.3.43 USE_FILTER_SET Procedure
-
191
DBMS_WORKLOAD_REPOSITORY
- 191.1 DBMS_WORKLOAD_REPOSITORY Examples
- 191.2 DBMS_WORKLOAD_REPOSITORY Data Structures
-
191.3
Summary of DBMS_WORKLOAD_REPOSITORY Subprograms
- 191.3.1 ADD_COLORED_SQL Procedure
- 191.3.2 ASH_GLOBAL_REPORT_HTML Function
- 191.3.3 ASH_GLOBAL_REPORT_TEXT Function
- 191.3.4 ASH_REPORT_ANALYTICS Function
- 191.3.5 ASH_REPORT_HTML Function
- 191.3.6 ASH_REPORT_TEXT Function
- 191.3.7 AWR_DIFF_REPORT_HTML Function
- 191.3.8 AWR_DIFF_REPORT_TEXT Function
- 191.3.9 AWR_EXP Procedure
- 191.3.10 AWR_GLOBAL_DIFF_REPORT_HTML Functions
- 191.3.11 AWR_GLOBAL_DIFF_REPORT_TEXT Functions
- 191.3.12 AWR_GLOBAL_REPORT_HTML Functions
- 191.3.13 AWR_GLOBAL_REPORT_TEXT Functions
- 191.3.14 AWR_IMP Procedure
- 191.3.15 AWR_REPORT_HTML Function
- 191.3.16 AWR_REPORT_TEXT Function
- 191.3.17 AWR_SET_REPORT_THRESHOLDS Procedure
- 191.3.18 AWR_SQL_REPORT_HTML Function
- 191.3.19 AWR_SQL_REPORT_TEXT Function
- 191.3.20 CONTROL_RESTRICTED_SNAPSHOT Procedure
- 191.3.21 CREATE_BASELINE Functions and Procedures
- 191.3.22 CREATE_BASELINE_TEMPLATE Procedures
- 191.3.23 CREATE_REMOTE_SNAPSHOT Function and Procedure
- 191.3.24 CREATE_SNAPSHOT Function and Procedure
- 191.3.25 DROP_BASELINE Procedure
- 191.3.26 DROP_BASELINE_TEMPLATE Procedure
- 191.3.27 DROP_SNAPSHOT_RANGE Procedure
- 191.3.28 LOCAL_AWR_DBID Function
- 191.3.29 MODIFY_BASELINE_WINDOW_SIZE Procedure
- 191.3.30 MODIFY_SNAPSHOT_SETTINGS Procedures
- 191.3.31 PURGE_SQL_DETAILS Procedure
- 191.3.32 REGISTER_REMOTE_DATABASE Procedures
- 191.3.33 REMOVE_COLORED_SQL Procedure
- 191.3.34 RENAME_BASELINE Procedure
- 191.3.35 SELECT_BASELINE_DETAILS Function
- 191.3.36 SELECT_BASELINE_METRIC Function
- 191.3.37 UNREGISTER_REMOTE_DATABASE Procedures
- 191.3.38 UPDATE_DATAFILE_INFO Procedure
- 191.3.39 UPDATE_OBJECT_INFO Procedure
- 192 DBMS_XA
-
193
DBMS_XDB
- 193.1 DBMS_XDB Overview
- 193.2 DBMS_XDB Security Model
- 193.3 DBMS_XDB Constants
-
193.4
Summary of DBMS_XDB Subprograms
- 193.4.1 ACLCHECKPRIVILEGES Function
- 193.4.2 APPENDRESOURCEMETADATA Procedure
- 193.4.3 CHANGEOWNER Procedure
- 193.4.4 CHANGEPRIVILEGES Function
- 193.4.5 CHECKPRIVILEGES Function
- 193.4.6 CREATEFOLDER Function
- 193.4.7 CREATEOIDPATH Function
- 193.4.8 CREATERESOURCE Functions
- 193.4.9 DELETERESOURCE Procedure
- 193.4.10 DELETERESOURCEMETADATA Procedures
- 193.4.11 ENABLEDIGESTAUTHENTICATION Procedure
- 193.4.12 EXISTSRESOURCE Function
- 193.4.13 GETACLDOCUMENT Function
- 193.4.14 GETCONTENTBLOB Function
- 193.4.15 GETCONTENTCLOB Function
- 193.4.16 GETCONTENTVARCHAR2 Function
- 193.4.17 GETCONTENTXMLREF Function
- 193.4.18 GETCONTENTXMLTYPE Function
- 193.4.19 GETHTTPREQUESTHEADER Function
- 193.4.20 GETLOCKTOKEN Procedure
- 193.4.21 GETPRIVILEGES Function
- 193.4.22 GETRESOID Function
- 193.4.23 GETXDB_TABLESPACE Function
- 193.4.24 HASBLOBCONTENT Function
- 193.4.25 HASCHARCONTENT Function
- 193.4.26 HASXMLCONTENT Function
- 193.4.27 HASXMLREFERENCE Function
- 193.4.28 ISFOLDER Function
- 193.4.29 LINK Procedures
- 193.4.30 LOCKRESOURCE Function
- 193.4.31 PROCESSLINKS Procedure
- 193.4.32 PURGERESOURCEMETADATA Procedure
- 193.4.33 RENAMERESOURCE Procedure
- 193.4.34 SETACL Procedure
- 193.4.35 SPLITPATH Procedure
- 193.4.36 TOUCHRESOURCE Procedure
- 193.4.37 UNLOCKRESOURCE Function
- 193.4.38 UPDATERESOURCEMETADATA Procedures
- 194 DBMS_XDB_ADMIN
-
195
DBMS_XDB_CONFIG
- 195.1 DBMS_XDB_CONFIG Overview
- 195.2 DBMS_XDB_CONFIG Security Model
- 195.3 DBMS_XDB_CONFIG Constants
-
195.4
Summary of DBMS_XDB_CONFIG Subprograms
- 195.4.1 ADDHTTPEXPIREMAPPING Procedure
- 195.4.2 ADDMIMEMAPPING Procedure
- 195.4.3 ADDSCHEMALOCMAPPING Procedure
- 195.4.4 ADDSERVLET Procedure
- 195.4.5 ADDSERVLETMAPPING Procedure
- 195.4.6 ADDSERVLETSECROLE Procedure
- 195.4.7 ADDXMLEXTENSION Procedure
- 195.4.8 CFG_GET Function
- 195.4.9 CFG_REFRESH Procedure
- 195.4.10 CFG_UPDATE Procedure
- 195.4.11 DELETEHTTPEXPIREMAPPING Procedure
- 195.4.12 DELETEMIMEMAPPING Procedure
- 195.4.13 DELETESCHEMALOCMAPPING Procedure
- 195.4.14 DELETESERVLET Procedure
- 195.4.15 DELETESERVLETMAPPING Procedure
- 195.4.16 DELETESERVLETSECROLE Procedure
- 195.4.17 DELETEXMLEXTENSION Procedure
- 195.4.18 ENABLEDIGESTAUTHENTICATION Procedure
- 195.4.19 GETFTPPORT Function
- 195.4.20 GETHTTPCONFIGREALM Function
- 195.4.21 GETHTTPPORT Function
- 195.4.22 GETHTTPSPORT Function
- 195.4.23 GETLISTENERENDPOINT Procedure
- 195.4.24 GETREMOTEHTTPPORT Function
- 195.4.25 GETREMOTEHTTPSPORT Function
- 195.4.26 ISGLOBALPORTENABLED Function
- 195.4.27 SETFTPPORT Procedure
- 195.4.28 SETGLOBALPORTENABLED Procedure
- 195.4.29 SETHTTPPORT Procedure
- 195.4.30 SETHTTPCONFIGREALM Procedure
- 195.4.31 SETHTTPSPORT Procedure
- 195.4.32 SETLISTENERENDPOINT Procedure
- 195.4.33 SETLISTENERLOCALACCESS Procedure
- 195.4.34 SETREMOTEHTTPPORT Procedure
- 195.4.35 SETREMOTEHTTPSPORT Procedure
- 195.4.36 USEDPORT Function
-
196
DBMS_XDB_CONSTANTS
- 196.1 DBMS_XDB_CONSTANTS Security Model
-
196.2
Summary of DBMS_XDB_CONSTANTS Subprograms
- 196.2.1 ENCODING_DEFAULT Function
- 196.2.2 ENCODING_ISOLATIN1 Function
- 196.2.3 ENCODING_UTF8 Function
- 196.2.4 ENCODING_WIN1252 Function
- 196.2.5 NAMESPACE_ACL Function
- 196.2.6 NAMESPACE_METADATA Function
- 196.2.7 NAMESPACE_ORACLE Function
- 196.2.8 NAMESPACE_ORACLE_XDB Function
- 196.2.9 NAMESPACE_RESOURCE Function
- 196.2.10 NAMESPACE_RESOURCE_EVENT Function
- 196.2.11 NAMESPACE_RESOURCE_CONFIG Function
- 196.2.12 NAMESPACE_XDBSCHEMA Function
- 196.2.13 NAMESPACE_XMLDIFF Function
- 196.2.14 NAMESPACE_XMLINSTANCE Function
- 196.2.15 NAMESPACE_XMLSCHEMA Function
- 196.2.16 NSPREFIX_ACL_ACL Function
- 196.2.17 NSPREFIX_RESCONFIG_RC Function
- 196.2.18 NSPREFIX_RESOURCE_R Function
- 196.2.19 NSPREFIX_XDB_XDB Function
- 196.2.20 NSPREFIX_XMLINSTANCE_XSI Function
- 196.2.21 NSPREFIX_XMLDIFF_XD Function
- 196.2.22 NSPREFIX_XMLSCHEMA_XSD Function
- 196.2.23 SCHEMAURL_ACL Function
- 196.2.24 SCHEMAELEM_RES_ACL Function
- 196.2.25 SCHEMAELEM_RESCONTENT_BINARY Function
- 196.2.26 SCHEMAELEM_RESCONTENT_TEXT Function
- 196.2.27 SCHEMAURL_RESOURCE Function
- 196.2.28 SCHEMAURL_XDBSCHEMA Function
- 196.2.29 XDBSCHEMA_PREFIXES Function
- 196.2.30 XSD_ATTRIBUTE Function
- 196.2.31 XSD_COMPLEX_TYPE Function
- 196.2.32 XSD_ELEMENT Function
- 196.2.33 XSD_GROUP Function
-
197
DBMS_XDB_REPOS
- 197.1 DBMS_XDB_REPOS Overview
- 197.2 DBMS_XDB_REPOS Security Model
- 197.3 DBMS_XDB_REPOS Constants
-
197.4
Summary of DBMS_XDB_REPOS Subprograms
- 197.4.1 ACLCHECKPRIVILEGES Function
- 197.4.2 APPENDRESOURCEMETADATA Procedure
- 197.4.3 CHANGEOWNER Procedure
- 197.4.4 CHANGEPRIVILEGES Function
- 197.4.5 CHECKPRIVILEGES Function
- 197.4.6 CREATEFOLDER Function
- 197.4.7 CREATEOIDPATH Function
- 197.4.8 CREATERESOURCE Functions
- 197.4.9 DELETERESOURCE Procedure
- 197.4.10 DELETERESOURCEMETADATA Procedures
- 197.4.11 EXISTSRESOURCE Function
- 197.4.12 GETACLDOCUMENT Function
- 197.4.13 GETCONTENTBLOB Function
- 197.4.14 GETCONTENTCLOB Function
- 197.4.15 GETCONTENTVARCHAR2 Function
- 197.4.16 GETCONTENTXMLREF Function
- 197.4.17 GETCONTENTXMLTYPE Function
- 197.4.18 GETLOCKTOKEN Procedure
- 197.4.19 GETPRIVILEGES Function
- 197.4.20 GETRESOID Function
- 197.4.21 GETXDB_TABLESPACE Function
- 197.4.22 HASBLOBCONTENT Function
- 197.4.23 HASCHARCONTENT Function
- 197.4.24 HASXMLCONTENT Function
- 197.4.25 HASXMLREFERENCE Function
- 197.4.26 ISFOLDER Function
- 197.4.27 LINK Procedures
- 197.4.28 LOCKRESOURCE Function
- 197.4.29 PROCESSLINKS Procedure
- 197.4.30 PURGERESOURCEMETADATA Procedure
- 197.4.31 RENAMERESOURCE Procedure
- 197.4.32 SETACL Procedure
- 197.4.33 SPLITPATH Procedure
- 197.4.34 TOUCHRESOURCE Procedure
- 197.4.35 UNLOCKRESOURCE Function
- 197.4.36 UPDATERESOURCEMETADATA Procedures
-
198
DBMS_XDB_VERSION
- 198.1 DBMS_XDB_VERSION Security Model
-
198.2
Summary of DBMS_XDB_VERSION Subprograms
- 198.2.1 CHECKIN Function
- 198.2.2 CHECKOUT Procedure
- 198.2.3 GETCONTENTSBLOBBYRESID Function
- 198.2.4 GETCONTENTSCLOBBYRESID Function
- 198.2.5 GETCONTENTSXMLBYRESID Function
- 198.2.6 GETPREDECESSORS Function
- 198.2.7 GETPREDSBYRESID Function
- 198.2.8 GETRESOURCEBYRESID Function
- 198.2.9 GETSUCCESSORS Function
- 198.2.10 GETSUCCSBYRESID Function
- 198.2.11 MAKEVERSIONED Function
- 198.2.12 UNCHECKOUT Function
-
199
DBMS_XDBRESOURCE
- 199.1 DBMS_XDBRESOURCE Overview
- 199.2 DBMS_XDBRESOURCE Security Model
-
199.3
Summary of DBMS_XDBRESOURCE Subprograms
- 199.3.1 FREERESOURCE Procedure
- 199.3.2 GETACL Function
- 199.3.3 GETACLDOCFROMRES Function
- 199.3.4 GETAUTHOR Function
- 199.3.5 GETCHARACTERSET Function
- 199.3.6 GETCOMMENT Function
- 199.3.7 GETCONTENTBLOB Function
- 199.3.8 GETCONTENTCLOB Function
- 199.3.9 GETCONTENTREF Function
- 199.3.10 GETCONTENTTYPE Function
- 199.3.11 GETCONTENTXML Function
- 199.3.12 GETCONTENTVARCHAR2 Function
- 199.3.13 GETCREATIONDATE Function
- 199.3.14 GETCREATOR Function
- 199.3.15 GETCUSTOMMETADATA Function
- 199.3.16 GETDISPLAYNAME Function
- 199.3.17 GETLANGUAGE Function
- 199.3.18 GETLASTMODIFIER Function
- 199.3.19 GETMODIFICATIONDATE Function
- 199.3.20 GETOWNER Function
- 199.3.21 GETREFCOUNT Function
- 199.3.22 GETVERSIONID Function
- 199.3.23 HASACLCHANGED Function
- 199.3.24 HASAUTHORCHANGED Function
- 199.3.25 HASCHANGED Function
- 199.3.26 HASCHARACTERSETCHANGED Function
- 199.3.27 HASCOMMENTCHANGED Function
- 199.3.28 HASCONTENTCHANGED Function
- 199.3.29 HASCONTENTTYPECHANGED Function
- 199.3.30 HASCREATIONDATECHANGED Function
- 199.3.31 HASCREATORCHANGED Function
- 199.3.32 HASCUSTOMMETADATACHANGED Function
- 199.3.33 HASDISPLAYNAMECHANGED Function
- 199.3.34 HASLANGUAGECHANGED Function
- 199.3.35 HASLASTMODIFIERCHANGED Function
- 199.3.36 HASMODIFICATIONDATECHANGED Function
- 199.3.37 HASOWNERCHANGED Function
- 199.3.38 HASREFCOUNTCHANGED Function
- 199.3.39 HASVERSIONIDCHANGED Function
- 199.3.40 ISFOLDER Function
- 199.3.41 ISNULL Function
- 199.3.42 MAKEDOCUMENT Function
- 199.3.43 SAVE Procedure
- 199.3.44 SETACL Procedure
- 199.3.45 SETAUTHOR Procedure
- 199.3.46 SETCHARACTERSET Procedure
- 199.3.47 SETCOMMENT Procedure
- 199.3.48 SETCONTENT Procedures
- 199.3.49 SETCONTENTTYPE Procedure
- 199.3.50 SETCUSTOMMETADATA Procedure
- 199.3.51 SETDISPLAYNAME Procedure
- 199.3.52 SETLANGUAGE Procedure
- 199.3.53 SETOWNER Procedure
-
200
DBMS_XDBT
- 200.1 DBMS_XDBT Overview
- 200.2 DBMS_XDBT Security Model
- 200.3 DBMS_XDBT Operational Notes
-
200.4
Summary of DBMS_XDBT Subprograms
- 200.4.1 CONFIGUREAUTOSYNC Procedure
- 200.4.2 CREATEDATASTOREPREF Procedure
- 200.4.3 CREATEFILTERPREF Procedure
- 200.4.4 CREATEINDEX Procedure
- 200.4.5 CREATELEXERPREF Procedure
- 200.4.6 CREATEPREFERENCES Procedure
- 200.4.7 CREATESECTIONGROUPPREF Procedure
- 200.4.8 CREATESTOPLISTPREF Procedure
- 200.4.9 CREATESTORAGEPREF Procedure
- 200.4.10 CREATEWORLDLISTPREF Procedure
- 200.4.11 DROPPREFERENCES Procedure
- 201 DBMS_XDBZ
-
202
DBMS_XEVENT
- 202.1 DBMS_XEVENT Security Model
- 202.2 DBMS_XEVENT Constants
- 202.3 Subprogram Groups
-
202.4
Summary of DBMS_XEVENT Subprograms
- 202.4.1 CLEAR Procedure
- 202.4.2 GETAPPLICATIONDATA Function
- 202.4.3 GETCHILDOID Function
- 202.4.4 GETCURRENTUSER Function
- 202.4.5 GETEVENT Function
- 202.4.6 GETFIRST Function
- 202.4.7 GETHANDLERLIST Function
- 202.4.8 GETINTERFACE Function
- 202.4.9 GETLANGUAGE Function
- 202.4.10 GETLINK Function
- 202.4.11 GETLINKNAME Function
- 202.4.12 GETLOCK Function
- 202.4.13 GETLANGUAGE Function
- 202.4.14 GETNAME Function
- 202.4.15 GETNEXT Function
- 202.4.16 GETOLDRESOURCE Function
- 202.4.17 GETOPENACCESSMODE Function
- 202.4.18 GETOPENDENYMODE Function
- 202.4.19 GETOUTPUTSTREAM Function
- 202.4.20 GETPARAMETER Function
- 202.4.21 GETPARENT Function
- 202.4.22 GETPARENTNAME Function
- 202.4.23 GETPARENTOID Function
- 202.4.24 GETPARENTPATH Function
- 202.4.25 GETPATH Function
- 202.4.26 GETRESOURCE Function
- 202.4.27 GETSCHEMA Function
- 202.4.28 GETSOURCE Function
- 202.4.29 GETUPDATEBYTECOUNT Function
- 202.4.30 GETUPDATEBYTEOFFSET Function
- 202.4.31 GETXDBEVENT Function
- 202.4.32 ISNULL Functions
- 202.4.33 REMOVE Procedure
- 202.4.34 SETRENDERPATH Procedure
- 202.4.35 SETRENDERSTREAM Procedure
-
203
DBMS_XMLDOM
- 203.1 DBMS_XMLDOM Overview
- 203.2 DBMS_XMLDOM Security Model
- 203.3 DBMS_XMLDOM Constants
- 203.4 DBMS_XMLDOM Types
- 203.5 DBMS_XMLDOM Exceptions
-
203.6
DBMS_XMLDOM Subprogram Groups
- 203.6.1 DBMS_XMLDOM DOMNode Subprograms
- 203.6.2 DBMS_XMLDOM DOMAttr Subprograms
- 203.6.3 DBMS_XMLDOM DOMCDataSection Subprograms
- 203.6.4 DBMS_XMLDOM DOMCharacterData Subprograms
- 203.6.5 DBMS_XMLDOM DOMComment Subprograms
- 203.6.6 DBMS_XMLDOM DOMDocument Subprograms
- 203.6.7 DBMS_XMLDOM DOMDocumentFragment Subprograms
- 203.6.8 DBMS_XMLDOM DOMDocumentType Subprograms
- 203.6.9 DBMS_XMLDOM DOMElement Subprograms
- 203.6.10 DBMS_XMLDOM DOMEntity Subprograms
- 203.6.11 DBMS_XMLDOM DOMEntityReference Subprograms
- 203.6.12 DBMS_XMLDOM DOMImplementation Subprograms
- 203.6.13 DBMS_XMLDOM DOMNamedNodeMap Subprograms
- 203.6.14 DBMS_XMLDOM DOMNodeList Subprograms
- 203.6.15 DBMS_XMLDOM DOMNotation Subprograms
- 203.6.16 DBMS_XMLDOM DOMProcessingInstruction Subprograms
- 203.6.17 DBMS_XMLDOM DOMText Subprograms
-
203.7
Summary of DBMS_XMLDOM Subprograms
- 203.7.1 ADOPTNODE Function
- 203.7.2 APPENDCHILD Function
- 203.7.3 APPENDDATA Procedure
- 203.7.4 CLONENODE Function
- 203.7.5 CREATEATTRIBUTE Functions
- 203.7.6 CREATECDATASECTION Function
- 203.7.7 CREATECOMMENT Function
- 203.7.8 CREATEDOCUMENT Function
- 203.7.9 CREATEDOCUMENTFRAGMENT Function
- 203.7.10 CREATEELEMENT Functions
- 203.7.11 CREATEENTITYREFERENCE Function
- 203.7.12 CREATEPROCESSINGINSTRUCTION Function
- 203.7.13 CREATETEXTNODE Function
- 203.7.14 DELETEDATA Procedure
- 203.7.15 FINDENTITY Function
- 203.7.16 FINDNOTATION Function
- 203.7.17 FREEDOCFRAG Procedure
- 203.7.18 FREEDOCUMENT Procedure
- 203.7.19 FREEELEMENT Procedure
- 203.7.20 FREENODE Procedure
- 203.7.21 FREENODELIST Procedure
- 203.7.22 GETATTRIBUTE Functions
- 203.7.23 GETATTRIBUTENODE Functions
- 203.7.24 GETATTRIBUTES Function
- 203.7.25 GETCHARSET Function
- 203.7.26 GETCHILDNODES Function
- 203.7.27 GETCHILDRENBYTAGNAME Functions
- 203.7.28 GETDATA Functions
- 203.7.29 GETDOCTYPE Function
- 203.7.30 GETDOCUMENTELEMENT Function
- 203.7.31 GETELEMENTSBYTAGNAME Functions
- 203.7.32 GETENTITIES Function
- 203.7.33 GETEXPANDEDNAME Procedure and Functions
- 203.7.34 GETFIRSTCHILD Function
- 203.7.35 GETIMPLEMENTATION Function
- 203.7.36 GETLASTCHILD Function
- 203.7.37 GETLENGTH Functions
- 203.7.38 GETLOCALNAME Procedure and Functions
- 203.7.39 GETNAME Functions
- 203.7.40 GETNAMEDITEM Function
- 203.7.41 GETNAMESPACE Procedure and Functions
- 203.7.42 GETNEXTSIBLING Function
- 203.7.43 GETNODETYPE Function
- 203.7.44 GETNODENAME Function
- 203.7.45 GETNODEVALUE Function
- 203.7.46 GETNODEVALUEASBINARYSTREAM Function & Procedure
- 203.7.47 GETNODEVALUEASCHARACTERSTREAM Function & Procedure
- 203.7.48 GETNOTATIONNAME Function
- 203.7.49 GETNOTATIONS Function
- 203.7.50 GETTARGET Function
- 203.7.51 GETOWNERDOCUMENT Function
- 203.7.52 GETOWNERELEMENT Function
- 203.7.53 GETPARENTNODE Function
- 203.7.54 GETPREFIX Function
- 203.7.55 GETPREVIOUSSIBLING Function
- 203.7.56 GETPUBLICID Functions
- 203.7.57 GETQUALIFIEDNAME Functions
- 203.7.58 GETSCHEMANODE Function
- 203.7.59 GETSPECIFIED Function
- 203.7.60 GETSTANDALONE Function
- 203.7.61 GETSYSTEMID Functions
- 203.7.62 GETTAGNAME Function
- 203.7.63 GETVALUE Function
- 203.7.64 GETVERSION Function
- 203.7.65 GETXMLTYPE Function
- 203.7.66 HASATTRIBUTE Functions
- 203.7.67 HASATTRIBUTES Function
- 203.7.68 HASCHILDNODES Function
- 203.7.69 HASFEATURE Function
- 203.7.70 IMPORTNODE Function
- 203.7.71 INSERTBEFORE Function
- 203.7.72 INSERTDATA Procedure
- 203.7.73 ISNULL Functions
- 203.7.74 ITEM Functions
- 203.7.75 MAKEATTR Function
- 203.7.76 MAKECDATASECTION Function
- 203.7.77 MAKECHARACTERDATA Function
- 203.7.78 MAKECOMMENT Function
- 203.7.79 MAKEDOCUMENT Function
- 203.7.80 MAKEDOCUMENTFRAGMENT Function
- 203.7.81 MAKEDOCUMENTTYPE Function
- 203.7.82 MAKEELEMENT Function
- 203.7.83 MAKEENTITY Function
- 203.7.84 MAKEENTITYREFERENCE Function
- 203.7.85 MAKENODE Functions
- 203.7.86 MAKENOTATION Function
- 203.7.87 MAKEPROCESSINGINSTRUCTION Function
- 203.7.88 MAKETEXT Function
- 203.7.89 NEWDOMDOCUMENT Functions
- 203.7.90 NORMALIZE Procedure
- 203.7.91 REMOVEATTRIBUTE Procedures
- 203.7.92 REMOVEATTRIBUTENODE Function
- 203.7.93 REMOVECHILD Function
- 203.7.94 REMOVENAMEDITEM Function
- 203.7.95 REPLACECHILD Function
- 203.7.96 REPLACEDATA Procedure
- 203.7.97 RESOLVENAMESPACEPREFIX Function
- 203.7.98 SETATTRIBUTE Procedures
- 203.7.99 SETATTRIBUTENODE Functions
- 203.7.100 SETCHARSET Procedure
- 203.7.101 SETDATA Procedures
- 203.7.102 SETDOCTYPE Procedure
- 203.7.103 SETNAMEDITEM Function
- 203.7.104 SETNODEVALUE Procedure
- 203.7.105 SETNODEVALUEASBINARYSTREAM Function & Procedure
- 203.7.106 SETNODEVALUEASCHARACTERSTREAM Function & Procedure
- 203.7.107 SETPREFIX Procedure
- 203.7.108 SETSTANDALONE Procedure
- 203.7.109 SETVALUE Procedure
- 203.7.110 SETVERSION Procedure
- 203.7.111 SPLITTEXT Function
- 203.7.112 SUBSTRINGDATA Function
- 203.7.113 USEBINARYSTREAM Function
- 203.7.114 WRITETOBUFFER Procedures
- 203.7.115 WRITETOCLOB Procedures
- 203.7.116 WRITETOFILE Procedures
-
204
DBMS_XMLGEN
- 204.1 DBMS_XMLGEN Security Model
-
204.2
Summary of DBMS_XMLGEN Subprograms
- 204.2.1 CLOSECONTEXT Procedure
- 204.2.2 CONVERT Functions
- 204.2.3 GETNUMROWSPROCESSED Function
- 204.2.4 GETXML Functions
- 204.2.5 GETXMLTYPE Functions
- 204.2.6 NEWCONTEXT Functions
- 204.2.7 NEWCONTEXTFROMHIERARCHY Function
- 204.2.8 RESTARTQUERY Procedure
- 204.2.9 SETCONVERTSPECIALCHARS Procedure
- 204.2.10 SETMAXROWS Procedure
- 204.2.11 SETNULLHANDLING Procedure
- 204.2.12 SETROWSETTAG Procedure
- 204.2.13 SETROWTAG Procedure
- 204.2.14 SETSKIPROWS Procedure
- 204.2.15 USEITEMTAGSFORCOLL Procedure
- 204.2.16 USENULLATTRIBUTEINDICATOR Procedure
- 205 DBMS_XMLINDEX
-
206
DBMS_XMLPARSER
- 206.1 DBMS_XMLPARSER Security Model
-
206.2
Summary of DBMS_XMLPARSER Subprograms
- 206.2.1 FREEPARSER
- 206.2.2 GETDOCTYPE
- 206.2.3 GETDOCUMENT
- 206.2.4 GETRELEASEVERSION
- 206.2.5 GETVALIDATIONMODE
- 206.2.6 NEWPARSER
- 206.2.7 PARSE
- 206.2.8 PARSEBUFFER
- 206.2.9 PARSECLOB
- 206.2.10 PARSEDTD
- 206.2.11 PARSEDTDBUFFER
- 206.2.12 PARSEDTDCLOB
- 206.2.13 SETBASEDIR
- 206.2.14 SETDOCTYPE Procedure
- 206.2.15 SETERRORLOG Procedure
- 206.2.16 SETPRESERVEWHITESPACE
- 206.2.17 SETVALIDATIONMODE
- 206.2.18 SHOWWARNINGS
-
207
DBMS_XMLQUERY
- 207.1 DBMS_XMLQUERY Security Model
- 207.2 DBMS_XMLQUERY Constants
- 207.3 Types
-
207.4
Summary of DBMS_XMLQUERY Subprograms
- 207.4.1 CLOSECONTEXT
- 207.4.2 GETDTD
- 207.4.3 GETEXCEPTIONCONTENT
- 207.4.4 GETNUMROWSPROCESSED
- 207.4.5 GETVERSION
- 207.4.6 GETXML
- 207.4.7 NEWCONTEXT
- 207.4.8 PROPAGATEORIGINALEXCEPTION
- 207.4.9 REMOVEXSLTPARAM
- 207.4.10 SETBINDVALUE
- 207.4.11 SETCOLLIDATTRNAME
- 207.4.12 SETDATAHEADER
- 207.4.13 SETDATEFORMAT
- 207.4.14 SETENCODINGTAG Procedure
- 207.4.15 SETERRORTAG Procedure
- 207.4.16 SETMAXROWS Procedure
- 207.4.17 SETMETAHEADER Procedure
- 207.4.18 SETRAISEEXCEPTION
- 207.4.19 SETRAISENOROWSEXCEPTION
- 207.4.20 SETROWIDATTRNAME
- 207.4.21 SETROWIDATTRVALUE
- 207.4.22 SETROWSETTAG
- 207.4.23 SETROWTAG
- 207.4.24 SETSKIPROWS
- 207.4.25 SETSQLTOXMLNAMEESCAPING
- 207.4.26 SETSTYLESHEETHEADER
- 207.4.27 SETTAGCASE
- 207.4.28 SETXSLT
- 207.4.29 SETXSLTPARAM
- 207.4.30 USENULLATTRIBUTEINDICATOR
- 207.4.31 USETYPEFORCOLLELEMTAG
-
208
DBMS_XMLSAVE
- 208.1 DBMS_XMLSAVE Security Model
- 208.2 DBMS_XMLSAVE Constants
- 208.3 Types
-
208.4
Summary of DBMS_XMLSAVE Subprograms
- 208.4.1 CLEARKEYCOLUMNLIST
- 208.4.2 CLEARUPDATECOLUMNLIST
- 208.4.3 CLOSECONTEXT
- 208.4.4 DELETEXML
- 208.4.5 GETEXCEPTIONCONTENT
- 208.4.6 INSERTXML
- 208.4.7 NEWCONTEXT
- 208.4.8 PROPAGATEORIGINALEXCEPTION
- 208.4.9 REMOVEXSLTPARAM
- 208.4.10 SETBATCHSIZE
- 208.4.11 SETCOMMITBATCH
- 208.4.12 SETDATEFORMAT
- 208.4.13 SETIGNORECASE
- 208.4.14 SETKEYCOLUMN
- 208.4.15 SETPRESERVEWHITESPACE
- 208.4.16 SETROWTAG
- 208.4.17 SETSQLTOXMLNAMEESCAPING
- 208.4.18 SETUPDATECOLUMN
- 208.4.19 SETXSLT
- 208.4.20 SETXSLTPARAM
- 208.4.21 UPDATEXML
- 209 DBMS_XMLSCHEMA
-
210
DBMS_XMLSCHEMA_ANNOTATE
- 210.1 DBMS_XMLSCHEMA_ANNOTATE Overview
- 210.2 DBMS_XMLSCHEMA_ANNOTATE Security Model
-
210.3
Summary of DBMS_XMLSCHEMA_ANNOTATE Subprograms
- 210.3.1 ADDXDBNAMESPACE Procedure
- 210.3.2 DISABLEDEFAULTTABLECREATION Procedure
- 210.3.3 DISABLEMAINTAINDOM Procedure
- 210.3.4 ENABLEDEFAULTTABLECREATION Procedure
- 210.3.5 ENABLEMAINTAINDOM Procedure
- 210.3.6 GETSCHEMAANNOTATIONS Function
- 210.3.7 GETSIDXDEFFROMVIEW Function
- 210.3.8 PRINTWARNINGS Procedure
- 210.3.9 REMOVEANYSTORAGE Procedure
- 210.3.10 REMOVEDEFAULTTABLE Procedure
- 210.3.11 REMOVEMAINTAINDOM Procedure
- 210.3.12 REMOVEOUTOFLINE Procedure
- 210.3.13 REMOVESQLCOLLTYPE Procedure
- 210.3.14 REMOVESQLNAME Procedure
- 210.3.15 REMOVESQLTYPE Procedure
- 210.3.16 REMOVESQLTYPEMAPPING Procedure
- 210.3.17 REMOVETABLEPROPS Procedure
- 210.3.18 REMOVETIMESTAMPWITHTIMEZONE Procedure
- 210.3.19 SETANYSTORAGE Procedure
- 210.3.20 SETDEFAULTTABLE Procedure
- 210.3.21 SETOUTOFLINE Procedure
- 210.3.22 SETSCHEMAANNOTATATIONS Procedure
- 210.3.23 SETSQLCOLLTYPE Procedure
- 210.3.24 SETSQLNAME Procedure
- 210.3.25 SETSQLTYPE Procedure
- 210.3.26 SETSQLTYPEMAPPING Procedure
- 210.3.27 SETTABLEPROPS Procedure
- 210.3.28 SETTIMESTAMPWITHTIMEZONE Procedure
-
211
DBMS_XMLSTORAGE_MANAGE
- 211.1 DBMS_XMLSTORAGE_MANAGE Overview
- 211.2 DBMS_XMLSTORAGE_MANAGE Security Model
-
211.3
Summary of DBMS_XMLSTORAGE_MANAGE Subprograms
- 211.3.1 DISABLEINDEXESANDCONSTRAINTS Procedure
- 211.3.2 ENABLEINDEXESANDCONSTRAINTS Procedure
- 211.3.3 EXCHANGEPOSTPROC Procedure
- 211.3.4 EXCHANGEPREPROC Procedure
- 211.3.5 INDEXXMLREFERENCES Procedure
- 211.3.6 REFPARTITIONEXCHANGEIN Procedure
- 211.3.7 REFPARTITIONEXCHANGEOUT Procedure
- 211.3.8 RENAMECOLLECTIONTABLE Procedure
- 211.3.9 SCOPEXMLREFERENCES Procedure
- 211.3.10 XPATH2TABCOLMAPPING Function
- 212 DBMS_XMLSTORE
- 213 DBMS_XPLAN
-
214
DBMS_XSLPROCESSOR
- 214.1 DBMS_XSLPROCESSOR Overview
- 214.2 DBMS_XSLPROCESSOR Deprecated Subprograms
- 214.3 DBMS_XSLPROCESSOR Security Model
-
214.4
Summary of DBMS_XSLPROCESSOR Subprograms
- 214.4.1 CLOB2FILE Procedure
- 214.4.2 FREEPROCESSOR Procedure
- 214.4.3 FREESTYLESHEET Procedure
- 214.4.4 NEWPROCESSOR Function
- 214.4.5 NEWSTYLESHEET Functions
- 214.4.6 PROCESSXSL Functions and Procedures
- 214.4.7 READ2CLOB Function
- 214.4.8 REMOVEPARAM Procedure
- 214.4.9 RESETPARAMS Procedure
- 214.4.10 SELECTNODES Function
- 214.4.11 SELECTSINGLENODE Function
- 214.4.12 SETERRORLOG Procedure
- 214.4.13 SETPARAM Procedure
- 214.4.14 SHOWWARNINGS Procedure
- 214.4.15 TRANSFORMNODE Function
- 214.4.16 VALUEOF Function and Procedure
-
215
DBMS_XSTREAM_ADM
- 215.1 DBMS_XSTREAM_ADM Overview
- 215.2 DBMS_XSTREAM_ADM Security Model
- 215.3 DBMS_XSTREAM_ADM Operational Notes
-
215.4
Summary of DBMS_XSTREAM_ADM Subprograms
- 215.4.1 ADD_COLUMN Procedure
- 215.4.2 ADD_GLOBAL_PROPAGATION_RULES Procedure
- 215.4.3 ADD_GLOBAL_RULES Procedure
- 215.4.4 ADD_OUTBOUND Procedure
- 215.4.5 ADD_SCHEMA_PROPAGATION_RULES Procedure
- 215.4.6 ADD_SCHEMA_RULES Procedure
- 215.4.7 ADD_SUBSET_OUTBOUND_RULES Procedure
- 215.4.8 ADD_SUBSET_PROPAGATION_RULES Procedure
- 215.4.9 ADD_SUBSET_RULES Procedure
- 215.4.10 ADD_TABLE_PROPAGATION_RULES Procedure
- 215.4.11 ADD_TABLE_RULES Procedure
- 215.4.12 ALTER_INBOUND Procedure
- 215.4.13 ALTER_OUTBOUND Procedure
- 215.4.14 CREATE_INBOUND Procedure
- 215.4.15 CREATE_OUTBOUND Procedure
- 215.4.16 DELETE_COLUMN Procedure
- 215.4.17 DROP_INBOUND Procedure
- 215.4.18 DROP_OUTBOUND Procedure
- 215.4.19 ENABLE_GG_XSTREAM_FOR_STREAMS Procedure
- 215.4.20 GET_MESSAGE_TRACKING Function
- 215.4.21 GET_TAG Function
- 215.4.22 IS_GG_XSTREAM_FOR_STREAMS Function
- 215.4.23 KEEP_COLUMNS Procedure
- 215.4.24 MERGE_STREAMS Procedure
- 215.4.25 MERGE_STREAMS_JOB Procedure
- 215.4.26 PURGE_SOURCE_CATALOG Procedure
- 215.4.27 RECOVER_OPERATION Procedure
- 215.4.28 REMOVE_QUEUE Procedure
- 215.4.29 REMOVE_RULE Procedure
- 215.4.30 REMOVE_SUBSET_OUTBOUND_RULES Procedure
- 215.4.31 REMOVE_XSTREAM_CONFIGURATION Procedure
- 215.4.32 RENAME_COLUMN Procedure
- 215.4.33 RENAME_SCHEMA Procedure
- 215.4.34 RENAME_TABLE Procedure
- 215.4.35 SET_MESSAGE_TRACKING Procedure
- 215.4.36 SET_PARAMETER Procedure
- 215.4.37 SET_TAG Procedure
- 215.4.38 SET_UP_QUEUE Procedure
- 215.4.39 SPLIT_STREAMS Procedure
- 215.4.40 START_OUTBOUND Procedure
- 215.4.41 STOP_OUTBOUND Procedure
- 216 DBMS_XSTREAM_AUTH
- 217 DEBUG_EXTPROC
-
218
HTF
- 218.1 HTF Deprecated Subprograms
- 218.2 HTF Operational Notes
- 218.3 Rules and Limits
- 218.4 HTF Examples
- 218.5 Summary of Tags
-
218.6
Summary of HTF Subprograms
- 218.6.1 ADDRESS Function
- 218.6.2 ANCHOR Function
- 218.6.3 ANCHOR2 Function
- 218.6.4 APPLETCLOSE Function
- 218.6.5 APPLETOPEN Function
- 218.6.6 AREA Function
- 218.6.7 BASE Function
- 218.6.8 BASEFONT Function
- 218.6.9 BGSOUND Function
- 218.6.10 BIG Function
- 218.6.11 BLOCKQUOTECLOSE Function
- 218.6.12 BLOCKQUOTEOPEN Function
- 218.6.13 BODYCLOSE Function
- 218.6.14 BODYOPEN Function
- 218.6.15 BOLD Function
- 218.6.16 BR Function
- 218.6.17 CENTER Function
- 218.6.18 CENTERCLOSE Function
- 218.6.19 CENTEROPEN Function
- 218.6.20 CITE Function
- 218.6.21 CODE Function
- 218.6.22 COMMENT Function
- 218.6.23 DFN Function
- 218.6.24 DIRLISTCLOSE Function
- 218.6.25 DIRLISTOPEN Function
- 218.6.26 DIV Function
- 218.6.27 DLISTCLOSE Function
- 218.6.28 DLISTDEF Function
- 218.6.29 DLISTOPEN Function
- 218.6.30 DLISTTERM Function
- 218.6.31 EM Function
- 218.6.32 EMPHASIS Function
- 218.6.33 ESCAPE_SC Function
- 218.6.34 ESCAPE_URL Function
- 218.6.35 FONTCLOSE Function
- 218.6.36 FONTOPEN Function
- 218.6.37 FORMAT_CELL Function
- 218.6.38 FORMCHECKBOX Function
- 218.6.39 FORMCLOSE Function
- 218.6.40 FORMFILE Function
- 218.6.41 FORMHIDDEN Function
- 218.6.42 FORMIMAGE Function
- 218.6.43 FORMOPEN Function
- 218.6.44 FORMPASSWORD Function
- 218.6.45 FORMRADIO Function
- 218.6.46 FORMRESET Function
- 218.6.47 FORMSELECTCLOSE Function
- 218.6.48 FORMSELECTOPEN Function
- 218.6.49 FORMSELECTOPTION Function
- 218.6.50 FORMSUBMIT Function
- 218.6.51 FORMTEXT Function
- 218.6.52 FORMTEXTAREA Function
- 218.6.53 FORMTEXTAREA2 Function
- 218.6.54 FORMTEXTAREACLOSE Function
- 218.6.55 FORMTEXTAREAOPEN Function
- 218.6.56 FORMTEXTAREAOPEN2 Function
- 218.6.57 FRAME Function
- 218.6.58 FRAMESETCLOSE Function
- 218.6.59 FRAMESETOPEN Function
- 218.6.60 HEADCLOSE Function
- 218.6.61 HEADER Function
- 218.6.62 HEADOPEN Function
- 218.6.63 HR Function
- 218.6.64 HTMLCLOSE Function
- 218.6.65 HTMLOPEN Function
- 218.6.66 IMG Function
- 218.6.67 IMG2 Function
- 218.6.68 ISINDEX Function
- 218.6.69 ITALIC Function
- 218.6.70 KBD Function
- 218.6.71 KEYBOARD Function
- 218.6.72 LINE Function
- 218.6.73 LINKREL Function
- 218.6.74 LINKREV Function
- 218.6.75 LISTHEADER Function
- 218.6.76 LISTINGCLOSE Function
- 218.6.77 LISTINGOPEN Function
- 218.6.78 LISTITEM Function
- 218.6.79 MAILTO Function
- 218.6.80 MAPCLOSE Function
- 218.6.81 MAPOPEN Function
- 218.6.82 MENULISTCLOSE Function
- 218.6.83 MENULISTOPEN Function
- 218.6.84 META Function
- 218.6.85 NL Function
- 218.6.86 NOBR Function
- 218.6.87 NOFRAMESCLOSE Function
- 218.6.88 NOFRAMESOPEN Function
- 218.6.89 OLISTCLOSE Function
- 218.6.90 OLISTOPEN Function
- 218.6.91 PARA Function
- 218.6.92 PARAGRAPH Function
- 218.6.93 PARAM Function
- 218.6.94 PLAINTEXT Function
- 218.6.95 PRECLOSE Function
- 218.6.96 PREOPEN Function
- 218.6.97 PRINT Functions
- 218.6.98 PRN Functions
- 218.6.99 S Function
- 218.6.100 SAMPLE Function
- 218.6.101 SCRIPT Function
- 218.6.102 SMALL Function
- 218.6.103 STRIKE Function
- 218.6.104 STRONG Function
- 218.6.105 STYLE Function
- 218.6.106 SUB Function
- 218.6.107 SUP Function
- 218.6.108 TABLECAPTION Function
- 218.6.109 TABLECLOSE Function
- 218.6.110 TABLEDATA Function
- 218.6.111 TABLEHEADER Function
- 218.6.112 TABLEOPEN Function
- 218.6.113 TABLEROWCLOSE Function
- 218.6.114 TABLEROWOPEN Function
- 218.6.115 TELETYPE Function
- 218.6.116 TITLE Function
- 218.6.117 ULISTCLOSE Function
- 218.6.118 ULISTOPEN Function
- 218.6.119 UNDERLINE Function
- 218.6.120 VARIABLE Function
- 218.6.121 WBR Function
-
219
HTP
- 219.1 HTP Operational Notes
- 219.2 HTP Rules and Limits
- 219.3 HTP Examples
- 219.4 HTP Summary of Tags
-
219.5
Summary of HTP Subprograms
- 219.5.1 ADDRESS Procedure
- 219.5.2 ANCHOR Procedure
- 219.5.3 ANCHOR2 Procedure
- 219.5.4 APPLETCLOSE Procedure
- 219.5.5 APPLETOPEN Procedure
- 219.5.6 AREA Procedure
- 219.5.7 BASE Procedure
- 219.5.8 BASEFONT Procedure
- 219.5.9 BGSOUND Procedure
- 219.5.10 BIG Procedure
- 219.5.11 BLOCKQUOTECLOSE Procedure
- 219.5.12 BLOCKQUOTEOPEN Procedure
- 219.5.13 BODYCLOSE Procedure
- 219.5.14 BODYOPEN Procedure
- 219.5.15 BOLD Procedure
- 219.5.16 BR Procedure
- 219.5.17 CENTER Procedure
- 219.5.18 CENTERCLOSE Procedure
- 219.5.19 CENTEROPEN Procedure
- 219.5.20 CITE Procedure
- 219.5.21 CODE Procedure
- 219.5.22 COMMENT Procedure
- 219.5.23 DFN Procedure
- 219.5.24 DIRLISTCLOSE Procedure
- 219.5.25 DIRLISTOPEN Procedure
- 219.5.26 DIV Procedure
- 219.5.27 DLISTCLOSE Procedure
- 219.5.28 DLISTDEF Procedure
- 219.5.29 DLISTOPEN Procedure
- 219.5.30 DLISTTERM Procedure
- 219.5.31 EM Procedure
- 219.5.32 EMPHASIS Procedure
- 219.5.33 ESCAPE_SC Procedure
- 219.5.34 FONTCLOSE Procedure
- 219.5.35 FONTOPEN Procedure
- 219.5.36 FORMCHECKBOX Procedure
- 219.5.37 FORMCLOSE Procedure
- 219.5.38 FORMOPEN Procedure
- 219.5.39 FORMFILE Procedure
- 219.5.40 FORMHIDDEN Procedure
- 219.5.41 FORMIMAGE Procedure
- 219.5.42 FORMPASSWORD Procedure
- 219.5.43 FORMRADIO Procedure
- 219.5.44 FORMRESET Procedure
- 219.5.45 FORMSELECTCLOSE Procedure
- 219.5.46 FORMSELECTOPEN Procedure
- 219.5.47 FORMSELECTOPTION Procedure
- 219.5.48 FORMSUBMIT Procedure
- 219.5.49 FORMTEXT Procedure
- 219.5.50 FORMTEXTAREA Procedure
- 219.5.51 FORMTEXTAREA2 Procedure
- 219.5.52 FORMTEXTAREACLOSE Procedure
- 219.5.53 FORMTEXTAREAOPEN Procedure
- 219.5.54 FORMTEXTAREAOPEN2 Procedure
- 219.5.55 FRAME Procedure
- 219.5.56 FRAMESETCLOSE Procedure
- 219.5.57 FRAMESETOPEN Procedure
- 219.5.58 HEADCLOSE Procedure
- 219.5.59 HEADER Procedure
- 219.5.60 HEADOPEN Procedure
- 219.5.61 HR Procedure
- 219.5.62 HTMLCLOSE Procedure
- 219.5.63 HTMLOPEN Procedure
- 219.5.64 IMG Procedure
- 219.5.65 IMG2 Procedure
- 219.5.66 ISINDEX Procedure
- 219.5.67 ITALIC Procedure
- 219.5.68 KBD Procedure
- 219.5.69 KEYBOARD Procedure
- 219.5.70 LINE Procedure
- 219.5.71 LINKREL Procedure
- 219.5.72 LINKREV Procedure
- 219.5.73 LISTHEADER Procedure
- 219.5.74 LISTINGCLOSE Procedure
- 219.5.75 LISTINGOPEN Procedure
- 219.5.76 LISTITEM Procedure
- 219.5.77 MAILTO Procedure
- 219.5.78 MAPCLOSE Procedure
- 219.5.79 MAPOPEN Procedure
- 219.5.80 MENULISTCLOSE Procedure
- 219.5.81 MENULISTOPEN Procedure
- 219.5.82 META Procedure
- 219.5.83 NL Procedure
- 219.5.84 NOBR Procedure
- 219.5.85 NOFRAMESCLOSE Procedure
- 219.5.86 NOFRAMESOPEN Procedure
- 219.5.87 OLISTCLOSE Procedure
- 219.5.88 OLISTOPEN Procedure
- 219.5.89 PARA Procedure
- 219.5.90 PARAGRAPH Procedure
- 219.5.91 PARAM Procedure
- 219.5.92 PLAINTEXT Procedure
- 219.5.93 PRECLOSE Procedure
- 219.5.94 PREOPEN Procedure
- 219.5.95 PRINT Procedures
- 219.5.96 PRINTS Procedure
- 219.5.97 PRN Procedures
- 219.5.98 PS Procedure
- 219.5.99 S Procedure
- 219.5.100 SAMPLE Procedure
- 219.5.101 SCRIPT Procedure
- 219.5.102 SMALL Procedure
- 219.5.103 STRIKE Procedure
- 219.5.104 STRONG Procedure
- 219.5.105 STYLE Procedure
- 219.5.106 SUB Procedure
- 219.5.107 SUP Procedure
- 219.5.108 TABLECAPTION Procedure
- 219.5.109 TABLECLOSE Procedure
- 219.5.110 TABLEDATA Procedure
- 219.5.111 TABLEHEADER Procedure
- 219.5.112 TABLEOPEN Procedure
- 219.5.113 TABLEROWCLOSE Procedure
- 219.5.114 TABLEROWOPEN Procedure
- 219.5.115 TELETYPE Procedure
- 219.5.116 TITLE Procedure
- 219.5.117 ULISTCLOSE Procedure
- 219.5.118 ULISTOPEN Procedure
- 219.5.119 UNDERLINE Procedure
- 219.5.120 VARIABLE Procedure
- 219.5.121 WBR Procedure
- 220 OWA_CACHE
- 221 OWA_COOKIE
- 222 OWA_CUSTOM
- 223 OWA_IMAGE
- 224 OWA_OPT_LOCK
- 225 OWA_PATTERN
- 226 OWA_SEC
- 227 OWA_TEXT
-
228
OWA_UTIL
- 228.1 OWA_UTIL Overview
- 228.2 OWA_UTIL Types
-
228.3
Summary of OWA_UTIL Subprograms
- 228.3.1 BIND_VARIABLES Function
- 228.3.2 CALENDARPRINT Procedures
- 228.3.3 CELLSPRINT Procedures
- 228.3.4 CHOOSE_DATE Procedure
- 228.3.5 GET_CGI_ENV Function
- 228.3.6 GET_OWA_SERVICE_PATH Function
- 228.3.7 GET_PROCEDURE Function
- 228.3.8 HTTP_HEADER_CLOSE Procedure
- 228.3.9 LISTPRINT Procedure
- 228.3.10 MIME_HEADER Procedure
- 228.3.11 PRINT_CGI_ENV Procedure
- 228.3.12 REDIRECT_URL Procedure
- 228.3.13 SHOWPAGE Procedure
- 228.3.14 SHOWSOURCE Procedure
- 228.3.15 SIGNATURE procedure
- 228.3.16 STATUS_LINE Procedure
- 228.3.17 TABLEPRINT Function
- 228.3.18 TODATE Function
- 228.3.19 WHO_CALLED_ME Procedure
- 229 SDO_CS
- 230 SDO_CSW_PROCESS
- 231 SDO_GCDR
- 232 SDO_GEOM
- 233 SDO_GEOR
- 234 SDO_GEOR_ADMIN
- 235 SDO_GEOR_AGGR
- 236 SDO_GEOR_RA
- 237 SDO_GEOR_UTL
- 238 SDO_LRS
- 239 SDO_MIGRATE
- 240 SDO_NET
- 241 SDO_NFE
- 242 SDO_OLS
- 243 SDO_PC_PKG
- 244 SDO_SAM
- 245 SDO_TIN_PKG
- 246 SDO_TOPO
- 247 SDO_TOPO_MAP
- 248 SDO_TUNE
- 249 SDO_UTIL
- 250 SDO_WFS_LOCK
- 251 SDO_WFS_PROCESS
- 252 SEM_APIS
- 253 SEM_OLS
- 254 SEM_PERF
- 255 SEM_RDFCTX
- 256 SEM_RDFSA
-
257
UTL_CALL_STACK
- 257.1 UTL_CALL_STACK Overview
- 257.2 UTL_CALL_STACK Security Model
- 257.3 UTL_CALL_STACK Operational Notes
- 257.4 UTL_CALL_STACK Exceptions
- 257.5 UTL_CALL_STACK Data Structures
-
257.6
Summary of UTL_CALL_STACK Subprograms
- 257.6.1 BACKTRACE_DEPTH Function
- 257.6.2 BACKTRACE_LINE Function
- 257.6.3 BACKTRACE_UNIT Function
- 257.6.4 CURRENT_EDITION Function
- 257.6.5 CONCATENATE_SUBPROGRAM Function
- 257.6.6 DYNAMIC_DEPTH Function
- 257.6.7 ERROR_DEPTH Function
- 257.6.8 ERROR_MSG Function
- 257.6.9 ERROR_NUMBER Function
- 257.6.10 LEXICAL_DEPTH Function
- 257.6.11 OWNER Function
- 257.6.12 UNIT_LINE Function
- 257.6.13 SUBPROGRAM Function
- 258 UTL_COLL
-
259
UTL_COMPRESS
- 259.1 UTL_COMPRESS Constants
- 259.2 UTL_COMPRESS Exceptions
- 259.3 UTL_COMPRESS Operational Notes
-
259.4
Summary of UTL_COMPRESS Subprograms
- 259.4.1 ISOPEN Function
- 259.4.2 LZ_COMPRESS Functions and Procedures
- 259.4.3 LZ_COMPRESS_ADD Procedure
- 259.4.4 LZ_COMPRESS_CLOSE
- 259.4.5 LZ_COMPRESS_OPEN
- 259.4.6 LZ_UNCOMPRESS Functions and Procedures
- 259.4.7 LZ_UNCOMPRESS_EXTRACT Procedure
- 259.4.8 LZ_UNCOMPRESS_OPEN Function
- 259.4.9 LZ_UNCOMPRESS_CLOSE Procedure
-
260
UTL_ENCODE
-
260.1
Summary of UTL_ENCODE Subprograms
- 260.1.1 BASE64_DECODE Function
- 260.1.2 BASE64_ENCODE Function
- 260.1.3 MIMEHEADER_DECODE Function
- 260.1.4 MIMEHEADER_ENCODE Function
- 260.1.5 QUOTED_PRINTABLE_DECODE Function
- 260.1.6 QUOTED_PRINTABLE_ENCODE Function
- 260.1.7 TEXT_DECODE Function
- 260.1.8 TEXT_ENCODE Function
- 260.1.9 UUDECODE Function
- 260.1.10 UUENCODE Function
-
260.1
Summary of UTL_ENCODE Subprograms
-
261
UTL_FILE
- 261.1 UTL_FILE Security Model
- 261.2 UTL_FILE Operational Notes
- 261.3 UTL_FILE Rules and Limits
- 261.4 UTL_FILE Exceptions
- 261.5 UTL_FILE Examples
- 261.6 UTL_FILE Data Structures
-
261.7
Summary of UTL_FILE Subprograms
- 261.7.1 FCLOSE Procedure
- 261.7.2 FCLOSE_ALL Procedure
- 261.7.3 FCOPY Procedure
- 261.7.4 FFLUSH Procedure
- 261.7.5 FGETATTR Procedure
- 261.7.6 FGETPOS Function
- 261.7.7 FOPEN Function
- 261.7.8 FOPEN_NCHAR Function
- 261.7.9 FREMOVE Procedure
- 261.7.10 FRENAME Procedure
- 261.7.11 FSEEK Procedure
- 261.7.12 GET_LINE Procedure
- 261.7.13 GET_LINE_NCHAR Procedure
- 261.7.14 GET_RAW Procedure
- 261.7.15 IS_OPEN Function
- 261.7.16 NEW_LINE Procedure
- 261.7.17 PUT Procedure
- 261.7.18 PUT_LINE Procedure
- 261.7.19 PUT_LINE_NCHAR Procedure
- 261.7.20 PUT_NCHAR Procedure
- 261.7.21 PUTF Procedure
- 261.7.22 PUTF_NCHAR Procedure
- 261.7.23 PUT_RAW Procedure
-
262
UTL_HTTP
- 262.1 UTL_HTTP Overview
- 262.2 UTL_HTTP Security Model
- 262.3 UTL_HTTP Constants
- 262.4 UTL_HTTP Exceptions
- 262.5 UTL_HTTP Examples
- 262.6 UTL_HTTP Data Structures
-
262.7
UTL_HTTP Operations
- 262.7.1 UTL_HTTP Operational Flow
- 262.7.2 UTL_HTTP Simple HTTP Fetches
- 262.7.3 UTL_HTTP HTTP Requests
- 262.7.4 UTL_HTTP HTTP Responses
- 262.7.5 UTL_HTTP HTTP Cookies
- 262.7.6 UTL_HTTP HTTP Persistent Connections
- 262.7.7 UTL_HTTP Error Conditions
- 262.7.8 UTL_HTTP Session Settings
- 262.7.9 UTL_HTTP Request Context
- 262.7.10 UTL_HTTP External Password Store
-
262.8
UTL_HTTP Subprogram Groups
- 262.8.1 UTL_HTTP Simple HTTP Fetches in a Single Call Subprograms
- 262.8.2 UTL_HTTP Session Settings Subprograms
- 262.8.3 UTL_HTTP HTTP Requests Subprograms
- 262.8.4 UTL_HTTP HTTP Request Contexts Subprograms
- 262.8.5 UTL_HTTP HTTP Responses Subprograms
- 262.8.6 UTL_HTTP HTTP Cookies Subprograms
- 262.8.7 UTL_HTTP HTTP Persistent Connections Subprograms
- 262.8.8 UTL_HTTP Error Conditions Subprograms
-
262.9
Summary of UTL_HTTP Subprograms
- 262.9.1 ADD_COOKIES Procedure
- 262.9.2 BEGIN_REQUEST Function
- 262.9.3 CLEAR_COOKIES Procedure
- 262.9.4 CLOSE_PERSISTENT_CONN Procedure
- 262.9.5 CLOSE_PERSISTENT_CONNS Procedure
- 262.9.6 CREATE_REQUEST_CONTEXT Function
- 262.9.7 DESTROY_REQUEST_CONTEXT Procedure
- 262.9.8 END_REQUEST Procedure
- 262.9.9 END_RESPONSE Procedure
- 262.9.10 GET_AUTHENTICATION Procedure
- 262.9.11 GET_BODY_CHARSET Procedure
- 262.9.12 GET_COOKIE_COUNT Function
- 262.9.13 GET_COOKIE_SUPPORT Procedure
- 262.9.14 GET_COOKIES Function
- 262.9.15 GET_DETAILED_EXCP_SUPPORT Procedure
- 262.9.16 GET_DETAILED_SQLCODE Function
- 262.9.17 GET_DETAILED_SQLERRM Function
- 262.9.18 GET_FOLLOW_REDIRECT Procedure
- 262.9.19 GET_HEADER Procedure
- 262.9.20 GET_HEADER_BY_NAME Procedure
- 262.9.21 GET_HEADER_COUNT Function
- 262.9.22 GET_PERSISTENT_CONN_COUNT Function
- 262.9.23 GET_PERSISTENT_CONN_SUPPORT Procedure
- 262.9.24 GET_PERSISTENT_CONNS Procedure
- 262.9.25 GET_PROXY Procedure
- 262.9.26 GET_RESPONSE Function
- 262.9.27 GET_RESPONSE_ERROR_CHECK Procedure
- 262.9.28 GET_TRANSFER_TIMEOUT Procedure
- 262.9.29 READ_LINE Procedure
- 262.9.30 READ_RAW Procedure
- 262.9.31 READ_TEXT Procedure
- 262.9.32 REQUEST Function
- 262.9.33 REQUEST_PIECES Function
- 262.9.34 SET_AUTHENTICATION Procedure
- 262.9.35 SET_AUTHENTICATION_FROM_WALLET Procedure
- 262.9.36 SET_BODY_CHARSET Procedures
- 262.9.37 SET_COOKIE_SUPPORT Procedures
- 262.9.38 SET_DETAILED_EXCP_SUPPORT Procedure
- 262.9.39 SET_FOLLOW_REDIRECT Procedures
- 262.9.40 SET_HEADER Procedure
- 262.9.41 SET_PERSISTENT_CONN_SUPPORT Procedure
- 262.9.42 SET_PROXY Procedure
- 262.9.43 SET_RESPONSE_ERROR_CHECK Procedure
- 262.9.44 SET_TRANSFER_TIMEOUT Procedure
- 262.9.45 SET_WALLET Procedure
- 262.9.46 WRITE_LINE Procedure
- 262.9.47 WRITE_RAW Procedure
- 262.9.48 WRITE_TEXT Procedure
-
263
UTL_I18N
- 263.1 UTL_I18N Overview
- 263.2 UTL_I18N Security Model
- 263.3 UTL_I18N Constants
-
263.4
Summary of UTL_I18N Subprograms
- 263.4.1 ESCAPE_REFERENCE Function
- 263.4.2 GET_COMMON_TIME_ZONES Function
- 263.4.3 GET_DEFAULT_CHARSET Function
- 263.4.4 GET_DEFAULT_ISO_CURRENCY Function
- 263.4.5 GET_DEFAULT_LINGUISTIC_SORT Function
- 263.4.6 GET_LOCAL_LANGUAGES Function
- 263.4.7 GET_LOCAL_LINGUISTIC_SORTS Function
- 263.4.8 GET_LOCAL_TERRITORIES Function
- 263.4.9 GET_LOCAL_TIME_ZONES Function
- 263.4.10 GET_MAX_CHARACTER_SIZE Function
- 263.4.11 GET_TRANSLATION Function
- 263.4.12 MAP_CHARSET Function
- 263.4.13 MAP_FROM_SHORT_LANGUAGE Function
- 263.4.14 MAP_LANGUAGE_FROM_ISO Function
- 263.4.15 MAP_LOCALE_TO_ISO Function
- 263.4.16 MAP_TERRITORY_FROM_ISO Function
- 263.4.17 MAP_TO_SHORT_LANGUAGE Function
- 263.4.18 RAW_TO_CHAR Functions
- 263.4.19 RAW_TO_NCHAR Functions
- 263.4.20 STRING_TO_RAW Function
- 263.4.21 TRANSLITERATE Function
- 263.4.22 UNESCAPE_REFERENCE Function
- 263.4.23 VALIDATE_CHARACTER_ENCODING Functions
- 264 UTL_IDENT
- 265 UTL_INADDR
- 266 UTL_LMS
- 267 UTL_MAIL
- 268 UTL_MATCH
-
269
UTL_NLA
- 269.1 UTL_NLA Overview
- 269.2 UTL_NLA Rules and Limits
- 269.3 UTL_NLA Security Model
-
269.4
Subprogram Groups
- 269.4.1 UTL_NLA BLAS Level 1 (Vector-Vector Operations) Subprograms
- 269.4.2 UTL_NLA BLAS Level 2 (Matrix-Vector Operations) Subprograms
- 269.4.3 UTL_NLA BLAS Level 3 (Matrix-Matrix Operations) Subprograms
- 269.4.4 UTL_NLA LAPACK Driver Routines (Linear Equations) Subprograms
- 269.4.5 UTL_NLA LAPACK Driver Routines (LLS and Eigenvalue Problems) Subprograms
-
269.5
Summary of UTL_NLA Subprograms
- 269.5.1 BLAS_ASUM Functions
- 269.5.2 BLAS_AXPY Procedures
- 269.5.3 BLAS_COPY Procedures
- 269.5.4 BLAS_DOT Functions
- 269.5.5 BLAS_GBMV Procedures
- 269.5.6 BLAS_GEMM Procedures
- 269.5.7 BLAS_GEMV Procedures
- 269.5.8 BLAS_GER Procedures
- 269.5.9 BLAS_IAMAX Functions
- 269.5.10 BLAS_NRM2 Functions
- 269.5.11 BLAS_ROT Procedures
- 269.5.12 BLAS_ROTG Procedures
- 269.5.13 BLAS_SCAL Procedures
- 269.5.14 BLAS_SPMV Procedures
- 269.5.15 BLAS_SPR Procedures
- 269.5.16 BLAS_SPR2 Procedures
- 269.5.17 BLAS_SBMV Procedures
- 269.5.18 BLAS_SWAP Procedures
- 269.5.19 BLAS_SYMM Procedures
- 269.5.20 BLAS_SYMV Procedures
- 269.5.21 BLAS_SYR Procedures
- 269.5.22 BLAS_SYR2 Procedures
- 269.5.23 BLAS_SYR2K Procedures
- 269.5.24 BLAS_SYRK Procedures
- 269.5.25 BLAS_TBMV Procedures
- 269.5.26 BLAS_TBSV Procedures
- 269.5.27 BLAS_TPMV Procedures
- 269.5.28 BLAS_TPSV Procedures
- 269.5.29 BLAS_TRMM Procedures
- 269.5.30 BLAS_TRMV Procedures
- 269.5.31 BLAS_TRSM Procedures
- 269.5.32 BLAS_TRSV Procedures
- 269.5.33 LAPACK_GBSV Procedures
- 269.5.34 LAPACK_GEES Procedures
- 269.5.35 LAPACK_GELS Procedures
- 269.5.36 LAPACK_GESDD Procedures
- 269.5.37 LAPACK_GESV Procedure
- 269.5.38 LAPACK_GESVD Procedures
- 269.5.39 LAPACK_GEEV Procedures
- 269.5.40 LAPACK_GTSV Procedure
- 269.5.41 LAPACK_PBSV Procedures
- 269.5.42 LAPACK_POSV Procedures
- 269.5.43 LAPACK_PPSV Procedures
- 269.5.44 LAPACK_PTSV Procedures
- 269.5.45 LAPACK_SBEV Procedures
- 269.5.46 LAPACK_SBEVD Procedures
- 269.5.47 LAPACK_SPEV Procedures
- 269.5.48 LAPACK_SPEVD Procedures
- 269.5.49 LAPACK_SPSV Procedures
- 269.5.50 LAPACK_STEV Procedures
- 269.5.51 LAPACK_STEVD Procedures
- 269.5.52 LAPACK_SYEV Procedures
- 269.5.53 LAPACK_SYEVD Procedures
- 269.5.54 LAPACK_SYSV Procedures
-
270
UTL_RAW
- 270.1 UTL_RAW Overview
- 270.2 UTL_RAW Operational Notes
-
270.3
Summary of UTL_RAW Subprograms
- 270.3.1 BIT_AND Function
- 270.3.2 BIT_COMPLEMENT Function
- 270.3.3 BIT_OR Function
- 270.3.4 BIT_XOR Function
- 270.3.5 CAST_FROM_BINARY_DOUBLE Function
- 270.3.6 CAST_FROM_BINARY_FLOAT Function
- 270.3.7 CAST_FROM_BINARY_INTEGER Function
- 270.3.8 CAST_FROM_NUMBER Function
- 270.3.9 CAST_TO_BINARY_DOUBLE Function
- 270.3.10 CAST_TO_BINARY_FLOAT Function
- 270.3.11 CAST_TO_BINARY_INTEGER Function
- 270.3.12 CAST_TO_NUMBER Function
- 270.3.13 CAST_TO_NVARCHAR2 Function
- 270.3.14 CAST_TO_RAW Function
- 270.3.15 CAST_TO_VARCHAR2 Function
- 270.3.16 COMPARE Function
- 270.3.17 CONCAT Function
- 270.3.18 CONVERT Function
- 270.3.19 COPIES Function
- 270.3.20 LENGTH Function
- 270.3.21 OVERLAY Function
- 270.3.22 REVERSE Function
- 270.3.23 SUBSTR Function
- 270.3.24 TRANSLATE Function
- 270.3.25 TRANSLITERATE Function
- 270.3.26 XRANGE Function
- 271 UTL_RECOMP
- 272 UTL_REF
- 273 UTL_RPADV
-
274
UTL_SMTP
- 274.1 UTL_SMTP Overview
- 274.2 UTL_SMTP Security Model
- 274.3 UTL_SMTP Constants
- 274.4 UTL_SMTP Types
- 274.5 UTL_SMTP Reply Codes
- 274.6 UTL_SMTP Operational Notes
- 274.7 UTL_SMTP Exceptions
- 274.8 UTL_SMTP Rules and Limits
- 274.9 UTL_SMTP Examples
-
274.10
Summary of UTL_SMTP Subprograms
- 274.10.1 AUTH Function and Procedure
- 274.10.2 CLOSE_CONNECTION Procedure
- 274.10.3 CLOSE_DATA Function and Procedure
- 274.10.4 COMMAND Function and Procedure
- 274.10.5 COMMAND_REPLIES Function
- 274.10.6 DATA Function and Procedure
- 274.10.7 EHLO Function and Procedure
- 274.10.8 HELO Function and Procedure
- 274.10.9 HELP Function
- 274.10.10 MAIL Function and Procedure
- 274.10.11 NOOP Function and Procedure
- 274.10.12 OPEN_CONNECTION Functions
- 274.10.13 OPEN_DATA Function and Procedure
- 274.10.14 QUIT Function and Procedure
- 274.10.15 RCPT Function
- 274.10.16 RSET Function and Procedure
- 274.10.17 STARTTLS Function and Procedure
- 274.10.18 VRFY Function
- 274.10.19 WRITE_DATA Procedure
- 274.10.20 WRITE_RAW_DATA Procedure
-
275
UTL_TCP
- 275.1 UTL_TCP Overview
- 275.2 UTL_TCP Security Model
- 275.3 UTL_TCP Types
- 275.4 UTL_TCP Exceptions
- 275.5 UTL_TCP Rules and Limits
- 275.6 UTL_TCP Examples
-
275.7
Summary of UTL_TCP Subprograms
- 275.7.1 AVAILABLE Function
- 275.7.2 CLOSE_ALL_CONNECTIONS Procedure
- 275.7.3 CLOSE_CONNECTION Procedure
- 275.7.4 FLUSH Procedure
- 275.7.5 GET_LINE Function
- 275.7.6 GET_LINE_NCHAR Function
- 275.7.7 GET_RAW Function
- 275.7.8 GET_TEXT Function
- 275.7.9 GET_TEXT_NCHAR Function
- 275.7.10 OPEN_CONNECTION Function
- 275.7.11 READ_LINE Function
- 275.7.12 READ_RAW Function
- 275.7.13 READ_TEXT Function
- 275.7.14 SECURE_CONNECTION Procedure
- 275.7.15 WRITE_LINE Function
- 275.7.16 WRITE_RAW Function
- 275.7.17 WRITE_TEXT Function
- 276 UTL_URL
- 277 WPG_DOCLOAD
- 278 ANYDATA TYPE
-
279
ANYDATASET TYPE
- 279.1 ANYDATASET TYPE Construction
-
279.2
Summary of ANYDATASET TYPE Subprograms
- 279.2.1 ADDINSTANCE Member Procedure
- 279.2.2 BEGINCREATE Static Procedure
- 279.2.3 ENDCREATE Member Procedure
- 279.2.4 GET* Member Functions
- 279.2.5 GETCOUNT Member Function
- 279.2.6 GETINSTANCE Member Function
- 279.2.7 GETTYPE Member Function
- 279.2.8 GETTYPENAME Member Function
- 279.2.9 PIECEWISE Member Procedure
- 279.2.10 SET* Member Procedures
- 280 ANYTYPE TYPE
-
281
Oracle Database Advanced Queuing (AQ) Types
- 281.1 Advanced Queuing (AQ)Types Security Model
-
281.2
Oracle Database Advanced Queuing (AQ) Types —Summary of Types
- 281.2.1 AQ$_AGENT Type
- 281.2.2 AQ$_AGENT_LIST_T Type
- 281.2.3 AQ$_DESCRIPTOR Type
- 281.2.4 AQ$_NTFN_DESCRIPTOR Type
- 281.2.5 AQ$_NTFN_MSGID_ARRAY Type
- 281.2.6 AQ$_POST_INFO Type
- 281.2.7 AQ$_POST_INFO_LIST Type
- 281.2.8 AQ$_PURGE_OPTIONS_T Type
- 281.2.9 AQ$_RECIPIENT_LIST_T Type
- 281.2.10 AQ$_REG_INFO Type
- 281.2.11 AQ$_REG_INFO_LIST Type
- 281.2.12 AQ$_SUBSCRIBER_LIST_T Type
- 281.2.13 DEQUEUE_OPTIONS_T Type
- 281.2.14 ENQUEUE_OPTIONS_T Type
- 281.2.15 QUEUE_PROPS_T Type
- 281.2.16 SYS.MSG_PROP_T Type
- 281.2.17 MESSAGE_PROPERTIES_T Type
- 281.2.18 MESSAGE_PROPERTIES_ARRAY_T Type
- 281.2.19 MSGID_ARRAY_T Type
- 282 DBFS Content Interface Types
-
283
Database URI TYPEs
- 283.1 Summary of URITYPE Supertype Subprograms
-
283.2
Summary of HTTPURITYPE Subtype Subprograms
- 283.2.1 HttpUriType Subtype CREATEURI
- 283.2.2 HttpUriType Subtype GETBLOB
- 283.2.3 HttpUriType Subtype GETCLOB
- 283.2.4 HttpUriType Subtype GETCONTENTTYPE
- 283.2.5 HttpUriType Subtype GETEXTERNALURL
- 283.2.6 HttpUriType Subtype GETURL
- 283.2.7 HttpUriType Subtype GETXML
- 283.2.8 HttpUriType Subtype HTTPURITYPE
- 283.3 Summary of DBURITYPE Subtype Subprogams
- 283.4 Summary of XDBURITYPE Subtype Subprograms
- 283.5 Summary of URIFACTORY Package Subprograms
-
284
JMS Types
- 284.1 JMS Types Overview
- 284.2 JMS Types Security Model
- 284.3 Java Versus PL/SQL Datatypes
- 284.4 More on Bytes, Stream and Map Messages
- 284.5 Upcasting and Downcasting Between General and Specific Messages
- 284.6 JMS Types Error Reporting
- 284.7 Oracle JMS Type Constants
- 284.8 CONVERT_JMS_SELECTOR
-
284.9
Summary of JMS Types
- 284.9.1 SYS.AQ$_JMS_MESSAGE Type
- 284.9.2 SYS.AQ$_JMS_TEXT_MESSAGE Type
- 284.9.3 SYS.AQ$_JMS_BYTES_MESSAGE Type
- 284.9.4 SYS.AQ$_JMS_MAP_MESSAGE Type
- 284.9.5 SYS.AQ$_JMS_STREAM_MESSAGE Type
- 284.9.6 SYS.AQ$_JMS_OBJECT_MESSAGE Type
- 284.9.7 SYS.AQ$_JMS_NAMEARRAY Type
- 284.9.8 SYS.AQ$_JMS_VALUE Type
- 284.9.9 SYS.AQ$_JMS_EXCEPTION Type
- 285 JSON Data Structures
- 286 Logical Change Record TYPEs
- 287 MGD_ID Package Types
-
288
Rule TYPEs
- 288.1 Rule TYPEs Overview
- 288.2 Rule TYPEs Security Model
-
288.3
Summary of Rule Types
- 288.3.1 RE$ATTRIBUTE_VALUE Type
- 288.3.2 RE$ATTRIBUTE_VALUE_LIST Type
- 288.3.3 RE$COLUMN_VALUE Type
- 288.3.4 RE$COLUMN_VALUE_LIST Type
- 288.3.5 RE$NAME_ARRAY Type
- 288.3.6 RE$NV_ARRAY Type
- 288.3.7 RE$NV_LIST Type
- 288.3.8 RE$NV_NODE Type
- 288.3.9 RE$RULE_HIT Type
- 288.3.10 RE$RULE_HIT_LIST Type
- 288.3.11 RE$RULE_NAME Type
- 288.3.12 RE$RULE_NAME_LIST Type
- 288.3.13 RE$TABLE_ALIAS Type
- 288.3.14 RE$TABLE_ALIAS_LIST Type
- 288.3.15 RE$TABLE_VALUE Type
- 288.3.16 RE$TABLE_VALUE_LIST Type
- 288.3.17 RE$VALUE Type
- 288.3.18 RE$VALUE_LIST Type
- 288.3.19 RE$VARIABLE_TYPE Type
- 288.3.20 RE$VARIABLE_TYPE_LIST Type
- 288.3.21 RE$VARIABLE_VALUE Type
- 288.3.22 RE$VARIABLE_VALUE_LIST Type
-
289
SODA Types
- 289.1 SODA Types Overview
- 289.2 SODA Types Security Model
-
289.3
Summary of SODA Types
-
289.3.1
SODA_COLLECTION_T Type
- 289.3.1.1 CREATE_INDEX Function
- 289.3.1.2 CREATE_VIEW_FROM_DG Function
- 289.3.1.3 DROP_INDEX Function
- 289.3.1.4 FIND Function
- 289.3.1.5 FIND_ONE Function
- 289.3.1.6 GET_DATA_GUIDE Function
- 289.3.1.7 GET_METADATA Function
- 289.3.1.8 GET_NAME Function
- 289.3.1.9 INSERT_ONE Function
- 289.3.1.10 INSERT_ONE_AND_GET Function
- 289.3.1.11 REMOVE_ONE Function
- 289.3.1.12 REPLACE_ONE Function
- 289.3.1.13 REPLACE_ONE_AND_GET Function
- 289.3.1.14 SAVE Function
- 289.3.1.15 SAVE_AND_GET Function
- 289.3.1.16 TRUNCATE Function
- 289.3.2 SODA_DOCUMENT_T Type
-
289.3.3
SODA_OPERATION_T Type
- 289.3.3.1 ACQUIRE_LOCK Function
- 289.3.3.2 AS_OF_SCN Function
- 289.3.3.3 AS_OF_TIMESTAMP Function
- 289.3.3.4 COUNT Function
- 289.3.3.5 FILTER Function
- 289.3.3.6 GET_CURSOR Function
- 289.3.3.7 GET_DATA_GUIDE Function
- 289.3.3.8 GET_ONE Function
- 289.3.3.9 HINT Function
- 289.3.3.10 KEY Function
- 289.3.3.11 KEYS Function
- 289.3.3.12 LIMIT Function
- 289.3.3.13 REMOVE Function
- 289.3.3.14 REPLACE_ONE Function
- 289.3.3.15 REPLACE_ONE_AND_GET Function
- 289.3.3.16 SKIP Function
- 289.3.3.17 VERSION Function
- 289.3.4 SODA_CURSOR_T Type
-
289.3.1
SODA_COLLECTION_T Type
- 290 UTL Streams Types
-
291
XMLTYPE
-
291.1
Summary of XMLType Subprograms
- 291.1.1 CREATENONSCHEMABASEDXML
- 291.1.2 CREATESCHEMABASEDXML
- 291.1.3 CREATEXML
- 291.1.4 EXISTSNODE
- 291.1.5 EXTRACT
- 291.1.6 GETBLOBVAL
- 291.1.7 GETCLOBVAL
- 291.1.8 GETNAMESPACE
- 291.1.9 GETNUMBERVAL
- 291.1.10 GETROOTELEMENT
- 291.1.11 GETSCHEMAURL
- 291.1.12 GETSTRINGVAL
- 291.1.13 ISFRAGMENT
- 291.1.14 ISSCHEMABASED
- 291.1.15 ISSCHEMAVALID
- 291.1.16 ISSCHEMAVALIDATED
- 291.1.17 SCHEMAVALIDATE
- 291.1.18 SETSCHEMAVALIDATED
- 291.1.19 TOOBJECT
- 291.1.20 TRANSFORM
- 291.1.21 XMLTYPE
-
291.1
Summary of XMLType Subprograms
- Index