1/301

Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

Changes in This Release for Oracle Database PL/SQL Packages and Types Reference

• Changes in Oracle Database 12c Release 2 (12.2)
  • New Features
  • Deprecated Features
  • Desupported Features

1 Introduction to Oracle Supplied PL/SQL Packages & Types

• Package Overview
  • Package Components
  • Using Oracle Supplied Packages
  • Creating New Packages
    • Separating the Specification and Body
      • Creating a New Package: Example
  • Referencing Package Contents
• Summary of Oracle Supplied PL/SQL Packages and Types

2 Oracle Application Express Packages APEX_APPLICATION Through APEX_ZIP

3 CTX_ADM

4 CTX_ANL

5 CTX_CLS

6 CTX_DDL

7 CTX_DOC

8 CTX_ENTITY

9 CTX_OUTPUT

10 CTX_QUERY

11 CTX_REPORT

12 CTX_THES

13 CTX_ULEXER

14 DBMS_ADDM

• DBMS_ADDM Security Model
• Summary of DBMS_ADDM Subprograms
  • ANALYZE_DB Procedure
  • ANALYZE_INST Procedure
  • ANALYZE_PARTIAL Procedure
  • COMPARE_CAPTURE_REPLAY_REPORT Function
  • COMPARE_DATABASES Function
  • COMPARE_INSTANCES Function
  • COMPARE_REPLAY_REPLAY_REPORT Function
  • DELETE Procedure
  • DELETE_FINDING_DIRECTIVE Procedure
  • DELETE_PARAMETER_DIRECTIVE Procedure
  • DELETE_SEGMENT_DIRECTIVE Procedure
  • DELETE_SQL_DIRECTIVE Procedure
  • GET_ASH_QUERY Function
  • GET_REPORT Function
  • INSERT_FINDING_DIRECTIVE Procedure
  • INSERT_PARAMETER_DIRECTIVE Procedure
  • INSERT_SEGMENT_DIRECTIVE Procedure
  • INSERT_SQL_DIRECTIVE Procedure
  • REAL_TIME_ADDM_REPORT Function

15 DBMS_ADVANCED_REWRITE

• DBMS_ADVANCED_REWRITE Security Model
• Summary of DBMS_ADVANCED_REWRITE Subprograms
  • ALTER_REWRITE_EQUIVALENCE Procedure
  • BUILD_SAFE_REWRITE_EQUIVALENCE Procedure
  • DECLARE_REWRITE_EQUIVALENCE Procedures
  • DROP_REWRITE_EQUIVALENCE Procedure
  • VALIDATE_REWRITE_EQUIVALENCE Procedure

16 DBMS_ADVISOR

• DBMS_ADVISOR Deprecated Subprograms
• DBMS_ADVISOR Security Model
• Summary of DBMS_ADVISOR Subprograms
  • ADD_SQLWKLD_REF Procedure
  • ADD_SQLWKLD_STATEMENT Procedure
  • ADD_STS_REF Procedure
  • CANCEL_TASK Procedure
  • COPY_SQLWKLD_TO_STS Procedure
  • CREATE_FILE Procedure
  • CREATE_OBJECT Procedure
  • CREATE_SQLWKLD Procedure
  • CREATE_TASK Procedures
  • DELETE_SQLWKLD Procedure
  • DELETE_SQLWKLD_REF Procedure
  • DELETE_SQLWKLD_STATEMENT Procedure
  • DELETE_STS_REF Procedure
  • DELETE_TASK Procedure
  • EXECUTE_TASK Procedure
  • GET_REC_ATTRIBUTES Procedure
  • GET_TASK_REPORT Function
  • GET_TASK_SCRIPT Function
  • IMPLEMENT_TASK Procedure
  • IMPORT_SQLWKLD_SCHEMA Procedure
  • IMPORT_SQLWKLD_SQLCACHE Procedure
  • IMPORT_SQLWKLD_STS Procedure
  • IMPORT_SQLWKLD_SUMADV Procedure
  • IMPORT_SQLWKLD_USER Procedure
  • INTERRUPT_TASK Procedure
  • MARK_RECOMMENDATION Procedure
  • QUICK_TUNE Procedure
  • RESET_SQLWKLD Procedure
  • RESET_TASK Procedure
  • SET_DEFAULT_SQLWKLD_PARAMETER Procedure
  • SET_DEFAULT_TASK_PARAMETER Procedure
  • SET_SQLWKLD_PARAMETER Procedure
  • SET_TASK_PARAMETER Procedure
  • TUNE_MVIEW Procedure
  • UPDATE_OBJECT Procedure
  • UPDATE_REC_ATTRIBUTES Procedure
  • UPDATE_SQLWKLD_ATTRIBUTES Procedure
  • UPDATE_SQLWKLD_STATEMENT Procedure
  • UPDATE_TASK_ATTRIBUTES Procedure

17 DBMS_ALERT

• DBMS_ALERT Overview
• DBMS_ALERT Security Model
• DBMS_ALERT Constants
• DBMS_ALERT Restrictions
• DBMS_ALERT Exceptions
• DBMS_ALERT Operational Notes
• DBMS_ALERT Examples
• Summary of DBMS_ALERT Subprograms
  • REGISTER Procedure
  • REMOVE Procedure
  • REMOVEALL Procedure
  • SET_DEFAULTS Procedure
  • SIGNAL Procedure
  • WAITANY Procedure
  • WAITONE Procedure

18 DBMS_APP_CONT

• DBMS_APP_CONT Overview
• DBMS_APP_CONT Security Model
• Summary of DBMS_APP_CONT Subprograms
  • GET_LTXID_OUTCOME Procedure

19 DBMS_APPLICATION_INFO

• DBMS_APPLICATION_INFO Overview
• DBMS_APPLICATION_INFO Security Model
• DBMS_APPLICATION_INFO Operational Notes
• Summary of DBMS_APPLICATION_INFO Subprograms
  • READ_CLIENT_INFO Procedure
  • READ_MODULE Procedure
  • SET_ACTION Procedure
  • SET_CLIENT_INFO Procedure
  • SET_MODULE Procedure
  • SET_SESSION_LONGOPS Procedure

20 DBMS_APPLY_ADM

• DBMS_APPLY_ADM Overview
• DBMS_APPLY_ADM Security Model
• DBMS_APPLY_ADM Deprecated Subprograms
• Summary of DBMS_APPLY_ADM Subprograms
  • ADD_STMT_HANDLER Procedure
  • ALTER_APPLY Procedure
  • COMPARE_OLD_VALUES Procedure
  • CREATE_APPLY Procedure
  • CREATE_OBJECT_DEPENDENCY Procedure
  • DELETE_ALL_ERRORS Procedure
  • DELETE_ERROR Procedure
  • DROP_APPLY Procedure
  • DROP_OBJECT_DEPENDENCY Procedure
  • EXECUTE_ALL_ERRORS Procedure
  • EXECUTE_ERROR Procedure
  • GET_ERROR_MESSAGE Function
  • HANDLE_COLLISIONS
  • REMOVE_STMT_HANDLER
  • SET_CHANGE_HANDLER Procedure
  • SET_DML_CONFLICT_HANDLER Procedure
  • SET_DML_HANDLER Procedure
  • SET_ENQUEUE_DESTINATION Procedure
  • SET_EXECUTE Procedure
  • SET_GLOBAL_INSTANTIATION_SCN Procedure
  • SET_KEY_COLUMNS Procedures
  • SET_PARAMETER Procedure
  • SET_REPERROR_HANDLER Procedure
  • SET_SCHEMA_INSTANTIATION_SCN Procedure
  • SET_TABLE_INSTANTIATION_SCN Procedure
  • SET_UPDATE_CONFLICT_HANDLER Procedure
  • SET_VALUE_DEPENDENCY Procedure
  • START_APPLY Procedure
  • STOP_APPLY Procedure

21 DBMS_AQ

• DBMS_AQ Security Model
• DBMS_AQ Constants
• DBMS_AQ Data Types
• DBMS_AQ Operational Notes
• Summary of DBMS_AQ Subprograms
  • BIND_AGENT Procedure
  • DEQUEUE Procedure
  • DEQUEUE_ARRAY Function
  • ENQUEUE Procedure
  • ENQUEUE_ARRAY Function
  • LISTEN Procedures
  • POST Procedure
  • REGISTER Procedure
  • UNBIND_AGENT Procedure
  • UNREGISTER Procedure

22 DBMS_AQADM

• DBMS_AQADM Security Model
• DBMS_AQADM Constants
• DBMS_AQADM Subprogram Groups
  • DBMS_AQADM Queue Table Subprograms
  • DBMS_AQADM Privilege Subprograms
  • DBMS_AQADM Queue Subprograms
  • DBMS_AQADM Subscriber Subprograms
  • DBMS_AQADM Propagation Subprograms
  • DBMS_AQADM Miscellaneous Subprograms
  • DBMS_AQADM Agent Subprograms
  • DBMS_AQADM Alias Subprograms
• Summary of DBMS_AQADM Subprograms
  • ADD_ALIAS_TO_LDAP Procedure
  • ADD_SUBSCRIBER Procedure
  • ALTER_AQ_AGENT Procedure
  • ALTER_PROPAGATION_SCHEDULE Procedure
  • ALTER_QUEUE Procedure
  • ALTER_QUEUE_TABLE Procedure
  • ALTER_SHARDED_QUEUE Procedure
  • ALTER_SUBSCRIBER Procedure
  • CREATE_AQ_AGENT Procedure
  • CREATE_NP_QUEUE Procedure
  • CREATE_QUEUE Procedure
  • CREATE_QUEUE_TABLE Procedure
  • CREATE_SHARDED_QUEUE Procedure
  • CREATE_EXCEPTION_QUEUE Procedure
  • DEL_ALIAS_FROM_LDAP Procedure
  • DISABLE_DB_ACCESS Procedure
  • DISABLE_PROPAGATION_SCHEDULE Procedure
  • DROP_AQ_AGENT Procedure
  • DROP_QUEUE Procedure
  • DROP_QUEUE_TABLE Procedure
  • DROP_SHARDED_QUEUE Procedure
  • ENABLE_DB_ACCESS Procedure
  • ENABLE_JMS_TYPES Procedure
  • ENABLE_PROPAGATION_SCHEDULE Procedure
  • GET_MAX_STREAMS_POOL Procedure
  • GET_MIN_STREAMS_POOL Procedure
  • GET_QUEUE_PARAMETER Procedure
  • GET_WATERMARK Procedure
  • GRANT_QUEUE_PRIVILEGE Procedure
  • GRANT_SYSTEM_PRIVILEGE Procedure
  • MIGRATE_QUEUE_TABLE Procedure
  • PURGE_QUEUE_TABLE Procedure
  • QUEUE_SUBSCRIBERS Function
  • REMOVE_SUBSCRIBER Procedure
  • REVOKE_QUEUE_PRIVILEGE Procedure
  • REVOKE_SYSTEM_PRIVILEGE Procedure
  • SCHEDULE_PROPAGATION Procedure
  • SET_WATERMARK Procedure
  • SET_MAX_STREAMS_POOL Procedure
  • SET_MIN_STREAMS_POOL Procedure
  • SET_QUEUE_PARAMETER Procedure
  • START_QUEUE Procedure
  • STOP_QUEUE Procedure
  • UNSCHEDULE_PROPAGATION Procedure
  • UNSET_QUEUE_PARAMETER Procedure
  • VERIFY_QUEUE_TYPES Procedure

23 DBMS_AQELM

• DBMS_AQELM Security Model
• Summary of DBMS_AQELM Subprograms
  • SET_MAILHOST Procedure
  • SET_MAILPORT Procedure
  • SET_SENDFROM Procedure

24 DBMS_AQIN

• DBMS_AQIN Security Model

25 DBMS_ASSERT

• DBMS_ASSERT Operational Notes
• Summary of DBMS_ASSERT Subprograms
  • ENQUOTE_LITERAL Function
  • ENQUOTE_NAME Function
  • NOOP Functions
  • QUALIFIED_SQL_NAME Function
  • SCHEMA_NAME Function
  • SIMPLE_SQL_NAME Function
  • SQL_OBJECT_NAME Function

26 DBMS_AUDIT_MGMT

• DBMS_AUDIT_MGMT Overview
• DBMS_AUDIT_MGMT Deprecated Subprograms
• DBMS_AUDIT_MGMT Security Model
• DBMS_AUDIT_MGMT Constants
• DBMS_AUDIT_MGMT Views
• DBMS_AUDIT_MGMT Subprogram Groups
  • DBMS_AUDIT_MGMT Audit Trail Management Subprograms
  • DBMS_AUDIT_MGMT Audit Trail Cleanup Subprograms
• Summary of DBMS_AUDIT_MGMT Subprograms
  • ALTER_PARTITION_INTERVAL Procedure
  • CLEAN_AUDIT_TRAIL Procedure
  • CLEAR_AUDIT_TRAIL_PROPERTY Procedure
  • CLEAR_LAST_ARCHIVE_TIMESTAMP Procedure
  • CREATE_PURGE_JOB Procedure
  • DEINIT_CLEANUP Procedure
  • DROP_OLD_UNIFIED_AUDIT_TABLES Procedure
  • DROP_PURGE_JOB Procedure
  • FLUSH_UNIFIED_AUDIT_TRAIL Procedure
  • GET_AUDIT_COMMIT_DELAY Function
  • GET_ AUDIT_TRAIL_PROPERTY_VALUE Function
  • GET_LAST_ARCHIVE_TIMESTAMP Function
  • INIT_CLEANUP Procedure
  • IS_CLEANUP_INITIALIZED Function
  • LOAD_UNIFIED_AUDIT_FILES Procedure
  • SET_AUDIT_TRAIL_LOCATION Procedure
  • SET_AUDIT_TRAIL_PROPERTY Procedure
  • SET_LAST_ARCHIVE_TIMESTAMP Procedure
  • SET_PURGE_JOB_INTERVAL Procedure
  • SET_PURGE_JOB_STATUS Procedure
  • TRANSFER_UNIFIED_AUDIT_RECORDS Procedure

27 DBMS_AUDIT_UTIL

• DBMS_AUDIT_UTIL Overview
• DBMS_AUDIT_UTIL Security Model
• DBMS_AUDIT_UTIL Views
• Summary of DBMS_AUDIT_UTIL Subprograms
  • DECODE_RLS_INFO_ATRAIL_FGA Function
  • DECODE_RLS_INFO_ATRAIL_STD Function
  • DECODE_RLS_INFO_ATRAIL_UNI Function
  • DECODE_RLS_INFO_ATRAIL_XML Function

28 DBMS_AUTO_REPORT

• DBMS_AUTO_REPORT Overview
• DBMS_AUTO_REPORT Security Model
• Summary of DBMS_AUTO_REPORT Subprograms
  • FINISH_REPORT_CAPTURE Procedure
  • REPORT_REPOSITORY_DETAIL Function
  • REPORT_REPOSITORY_DETAIL_XML Function
  • REPORT_REPOSITORY_LIST_XML Function
  • START_REPORT_CAPTURE Procedure

29 DBMS_AUTO_SQLTUNE

• DBMS_AUTO_SQLTUNE Overview
• DBMS_AUTO_SQLTUNE Security Model
• Summary of DBMS_AUTO_SQLTUNE Subprograms
  • EXECUTE_AUTO_TUNING_TASK Function and Procedure
  • REPORT_AUTO_TUNING_TASK Function
  • SET_AUTO_TUNING_TASK_PARAMETER Procedures

30 DBMS_AUTO_TASK_ADMIN

• DBMS_AUTO_TASK_ADMIN Deprecated Subprograms
• DBMS_AUTO_TASK_ADMIN Security Model
• DBMS_AUTO_TASK_ADMIN Constants
• Summary of DBMS_AUTO_TASK_ADMIN Subprograms
  • DISABLE Procedures
  • ENABLE Procedures
  • GET_CLIENT_ATTRIBUTES Procedure
  • GET_P1_RESOURCES Procedure
  • OVERRIDE_PRIORITY Procedures
  • SET_CLIENT_SERVICE Procedure
  • SET_P1_RESOURCES Procedure

31 DBMS_AW_STATS

• Using DBMS_AW_STATS
• Summary of DBMS_AW_STATS Subprograms
  • ANALYZE Procedure
  • CLEAR Procedure

32 DBMS_CAPTURE_ADM

• DBMS_CAPTURE_ADM Overview
• DBMS_CAPTURE_ADM Security Model
• Summary of DBMS_CAPTURE_ADM Subprograms
  • ABORT_GLOBAL_INSTANTIATION Procedure
  • ABORT_SCHEMA_INSTANTIATION Procedure
  • ABORT_SYNC_INSTANTIATION Procedure
  • ABORT_TABLE_INSTANTIATION Procedure
  • ALTER_CAPTURE Procedure
  • ALTER_SYNC_CAPTURE Procedure
  • BUILD Procedure
  • CREATE_CAPTURE Procedure
  • CREATE_SYNC_CAPTURE Procedure
  • DROP_CAPTURE Procedure
  • INCLUDE_EXTRA_ATTRIBUTE Procedure
  • PREPARE_GLOBAL_INSTANTIATION Procedure
  • PREPARE_SCHEMA_INSTANTIATION Procedure
  • PREPARE_SYNC_INSTANTIATION Function
  • PREPARE_TABLE_INSTANTIATION Procedure
  • SET_PARAMETER Procedure
  • START_CAPTURE Procedure
  • STOP_CAPTURE Procedure

33 DBMS_COMPARISON

• DBMS_COMPARISON Overview
• DBMS_COMPARISON Security Model
• DBMS_COMPARISON Constants
• DBMS_COMPARISON Views
• DBMS_COMPARISON Operational Notes
• DBMS_COMPARISON Data Structures
  • COMPARISON_TYPE Record Type
• Summary of DBMS_COMPARISON Subprograms
  • COMPARE Function
  • CONVERGE Procedure
  • CREATE_COMPARISON Procedure
  • DROP_COMPARISON Procedure
  • PURGE_COMPARISON Procedure
  • RECHECK Function

34 DBMS_COMPRESSION

• DBMS_COMPRESSION Overview
• DBMS_COMPRESSION Security Model
• DBMS_COMPRESSION Constants
• DBMS_COMPRESSION Data Structures
  • COMPREC Record Type
  • COMPRECLIST Table Type
• Summary of DBMS_COMPRESSION Subprograms
  • GET_COMPRESSION_RATIO Procedure
  • GET_COMPRESSION_TYPE Function

35 DBMS_CONNECTION_POOL

• Summary of DBMS_CONNECTION_POOL Subprograms
  • ALTER_PARAM Procedure
  • CONFIGURE_POOL Procedure
  • START_POOL Procedure
  • STOP_POOL Procedure
  • RESTORE_DEFAULTS Procedure

36 DBMS_CQ_NOTIFICATION

• DBMS_CQ_NOTIFICATION Overview
• DBMS_CQ_NOTIFICATION Security Model
• DBMS_CQ_NOTIFICATION Constants
• DBMS_CQ_NOTIFICATION Operational Notes
• DBMS_CQ_NOTIFICATION Examples
• DBMS_CQ_NOTIFICATION Data Structures
  • CQ_NOTIFICATION$_DESCRIPTOR Object Type
  • CQ_NOTIFICATION$_QUERY Object Type
  • CQ_NOTIFICATION$_QUERY_ARRAY Object (Array) Type
  • CQ_NOTIFICATION$_TABLE Object Type
  • CQ_NOTIFICATION$_TABLE_ARRAY Object (Array) Type
  • CQ_NOTIFICATION$_ROW Object Type
  • CQ_NOTIFICATION$_ROW_ARRAY Object (Array) Type
  • CQ_NOTIFICATION$_REG_INFO Object Type
• Summary of DBMS_CQ_NOTIFICATION Subprograms
  • CQ_NOTIFICATION_QUERYID Function
  • DEREGISTER Procedure
  • ENABLE_REG Procedure
  • NEW_REG_START Function
  • REG_END Procedure
  • SET_ROWID_THRESHOLD Procedure

37 DBMS_CREDENTIAL

• DBMS_CREDENTIAL Overview
• DBMS_CREDENTIAL Security Model
• DBMS_CREDENTIAL Operational Notes
• Summary of DBMS_CREDENTIAL Subprograms
  • CREATE_CREDENTIAL Procedure
  • DISABLE_CREDENTIAL Procedure
  • DROP_CREDENTIAL Procedure
  • ENABLE_CREDENTIAL Procedure
  • UPDATE_CREDENTIAL Procedure

38 DBMS_CRYPTO

• DBMS_CRYPTO Overview
• DBMS_CRYPTO Security Model
• DBMS_CRYPTO Datatypes
• DBMS_CRYPTO Algorithms
• DBMS_CRYPTO Restrictions
• DBMS_CRYPTO Exceptions
• DBMS_CRYPTO Operational Notes
• DBMS_CRYPTO Examples
• Summary of DBMS_CRYPTO Subprograms
  • DECRYPT Function
  • DECRYPT Procedures
  • ENCRYPT Function
  • ENCRYPT Procedures
  • HASH Function
  • MAC Function
  • RANDOMBYTES Function
  • RANDOMINTEGER Function
  • RANDOMNUMBER Function

39 DBMS_CSX_ADMIN

• DBMS_CSX_ADMIN Overview
• DBMS_CSX_ADMIN Security Model
• DBMS_CSX_ADMIN Constants
• Summary of DBMS_CSX_ADMIN Subprograms
  • GETTOKENTABLEINFO Procedure & Function
  • GETTOKENTABLEINFOBYTABLESPACE Procedure
  • NAMESPACEIDTABLE Function
  • PATHIDTABLE Function
  • QNAMEIDTABLE Function

40 DBMS_CUBE

• Using DBMS_CUBE
  • DBMS_CUBE Security Model
• Using SQL Aggregation Management
  • Subprograms in SQL Aggregation Management
  • Requirements for the Relational Materialized View
  • Permissions for Managing and Querying Cube Materialized Views
  • Example of SQL Aggregation Management
• Upgrading 10g Analytic Workspaces
• Summary of DBMS_CUBE Subprograms
  • BUILD Procedure
  • CREATE_EXPORT_OPTIONS Procedure
  • CREATE_IMPORT_OPTIONS Procedure
  • CREATE_MVIEW Function
  • DERIVE_FROM_MVIEW Function
  • DROP_MVIEW Procedure
  • EXPORT_XML Procedure
  • EXPORT_XML_TO_FILE Procedure
  • IMPORT_XML Procedure
  • INITIALIZE_CUBE_UPGRADE Procedure
  • REFRESH_MVIEW Procedure
  • UPGRADE_AW Procedure
  • VALIDATE_XML Procedure

41 DBMS_CUBE_ADVISE

• DBMS_CUBE_ADVISE Security Model
• Summary of DBMS_CUBE_ADVISE Subprograms
  • MV_CUBE_ADVICE Function
  • SET_CNS_EXCEPTION_LOG Procedure
  • TRACE Procedure

42 DBMS_CUBE_LOG

• Using DBMS_CUBE_LOG
  • DBMS_CUBE_LOG — Logging Types
  • DBMS_CUBE_LOG — Logging Targets
  • DBMS_CUBE_LOG — Verbosity Levels
  • DBMS_CUBE_LOG Security Model
  • DBMS_CUBE_LOG — Creating Cube Logs
  • DBMS_CUBE_LOG — Cube Build Log
  • DBMS_CUBE_LOG — Cube Dimension Compile Log
  • DBMS_CUBE_LOG — Cube Operations Log
  • DBMS_CUBE_LOG — Cube Rejected Records Log
• Summary of DBMS_CUBE_LOG Subprograms
  • DEFAULT_NAME Function
  • DISABLE Procedure
  • ENABLE Procedure
  • FLUSH Procedure
  • GET_LOG Procedure
  • GET_LOG_SPEC Function
  • GET_PARAMETER Function
  • LEVEL_HIGH Function
  • LEVEL_HIGHEST Function
  • LEVEL_LOW Function
  • LEVEL_LOWEST Function
  • LEVEL_MEDIUM Function
  • SET_LOG_SPEC Procedure
  • SET_PARAMETER Procedure
  • TABLE_CREATE Procedure
  • TARGET_FILE Function
  • TARGET_LOB Function
  • TARGET_TABLE Function
  • TARGET_TRACE Function
  • TYPE_BUILD Function
  • TYPE_DIMENSION_COMPILE Function
  • TYPE_OPERATIONS Function
  • TYPE_REJECTED_RECORDS Function
  • VERSION Function

43 DBMS_DATA_MINING

• DBMS_DATA_MINING Overview
• DBMS_DATA_MINING Security Model
• DBMS_DATA_MINING — Mining Functions
• DBMS_DATA_MINING — Model Settings
  • DBMS_DATA_MINING — Algorithm Names
  • DBMS_DATA_MINING — Automatic Data Preparation
  • DBMS_DATA_MINING — Mining Function Settings
  • DBMS_DATA_MINING — Global Settings
  • DBMS_DATA_MINING — Algorithm Settings: ALGO_EXTENSIBLE_LANG
  • DBMS_DATA_MINING — Algorithm Settings: Decision Tree
  • DBMS_DATA_MINING — Algorithm Settings: Expectation Maximization
  • DBMS_DATA_MINING — Algorithm Settings: Explicit Semantic Analysis
  • DBMS_DATA_MINING — Algorithm Settings: Generalized Linear Models
  • DBMS_DATA_MINING — Algorithm Settings: k-Means
  • DBMS_DATA_MINING — Algorithm Settings: Naive Bayes
  • DBMS_DATA_MINING — Algorithm Settings: Non-Negative Matrix Factorization
  • DBMS_DATA_MINING — Algorithm Settings: O-Cluster
  • DBMS_DATA_MINING — Algorithm Constants and Settings: Singular Value Decomposition
  • DBMS_DATA_MINING — Algorithm Settings: Support Vector Machine
• DBMS_DATA_MINING Datatypes
• Summary of DBMS_DATA_MINING Subprograms
  • ADD_COST_MATRIX Procedure
  • ADD_PARTITION Procedure
  • ALTER_REVERSE_EXPRESSION Procedure
  • APPLY Procedure
  • COMPUTE_CONFUSION_MATRIX Procedure
  • COMPUTE_CONFUSION_MATRIX_PART Procedure
  • COMPUTE_LIFT Procedure
  • COMPUTE_LIFT_PART Procedure
  • COMPUTE_ROC Procedure
  • COMPUTE_ROC_PART Procedure
  • CREATE_MODEL Procedure
  • CREATE_MODEL2 Procedure
  • DROP_PARTITION Procedure
  • DROP_MODEL Procedure
  • EXPORT_MODEL Procedure
  • GET_ASSOCIATION_RULES Function
  • GET_FREQUENT_ITEMSETS Function
  • GET_MODEL_COST_MATRIX Function
  • GET_MODEL_DETAILS_AI Function
  • GET_MODEL_DETAILS_EM Function
  • GET_MODEL_DETAILS_EM_COMP Function
  • GET_MODEL_DETAILS_EM_PROJ Function
  • GET_MODEL_DETAILS_GLM Function
  • GET_MODEL_DETAILS_GLOBAL Function
  • GET_MODEL_DETAILS_KM Function
  • GET_MODEL_DETAILS_NB Function
  • GET_MODEL_DETAILS_NMF Function
  • GET_MODEL_DETAILS_OC Function
  • GET_MODEL_SETTINGS Function
  • GET_MODEL_SIGNATURE Function
  • GET_MODEL_DETAILS_SVD Function
  • GET_MODEL_DETAILS_SVM Function
  • GET_MODEL_DETAILS_XML Function
  • GET_MODEL_TRANSFORMATIONS Function
  • GET_TRANSFORM_LIST Procedure
  • IMPORT_MODEL Procedure
  • RANK_APPLY Procedure
  • REMOVE_COST_MATRIX Procedure
  • RENAME_MODEL Procedure

44 DBMS_DATA_MINING_TRANSFORM

• DBMS_DATA_MINING_TRANSFORM Overview
• DBMS_DATA_MINING_TRANSFORM Operational Notes
  • DBMS_DATA_MINING_TRANSFORM — About Transformation Lists
  • DBMS_DATA_MINING_TRANSFORM — About Stacking and Stack Procedures
  • DBMS_DATA_MINING_TRANSFORM — Nested Data Transformations
• DBMS_DATA_MINING_TRANSFORM Security Model
• DBMS_DATA_MINING_TRANSFORM Datatypes
• DBMS_DATA_MINING_TRANSFORM Constants
• Summary of DBMS_DATA_MINING_TRANSFORM Subprograms
  • CREATE_BIN_CAT Procedure
  • CREATE_BIN_NUM Procedure
  • CREATE_CLIP Procedure
  • CREATE_COL_REM Procedure
  • CREATE_MISS_CAT Procedure
  • CREATE_MISS_NUM Procedure
  • CREATE_NORM_LIN Procedure
  • DESCRIBE_STACK Procedure
  • GET_EXPRESSION Function
  • INSERT_AUTOBIN_NUM_EQWIDTH Procedure
  • INSERT_BIN_CAT_FREQ Procedure
  • INSERT_BIN_NUM_EQWIDTH Procedure
  • INSERT_BIN_NUM_QTILE Procedure
  • INSERT_BIN_SUPER Procedure
  • INSERT_CLIP_TRIM_TAIL Procedure
  • INSERT_CLIP_WINSOR_TAIL Procedure
  • INSERT_MISS_CAT_MODE Procedure
  • INSERT_MISS_NUM_MEAN Procedure
  • INSERT_NORM_LIN_MINMAX Procedure
  • INSERT_NORM_LIN_SCALE Procedure
  • INSERT_NORM_LIN_ZSCORE Procedure
  • SET_EXPRESSION Procedure
  • SET_TRANSFORM Procedure
  • STACK_BIN_CAT Procedure
  • STACK_BIN_NUM Procedure
  • STACK_CLIP Procedure
  • STACK_COL_REM Procedure
  • STACK_MISS_CAT Procedure
  • STACK_MISS_NUM Procedure
  • STACK_NORM_LIN Procedure
  • XFORM_BIN_CAT Procedure
  • XFORM_BIN_NUM Procedure
  • XFORM_CLIP Procedure
  • XFORM_COL_REM Procedure
  • XFORM_EXPR_NUM Procedure
  • XFORM_EXPR_STR Procedure
  • XFORM_MISS_CAT Procedure
  • XFORM_MISS_NUM Procedure
  • XFORM_NORM_LIN Procedure
  • XFORM_STACK Procedure

45 DBMS_DATAPUMP

• DBMS_DATAPUMP Overview
• DBMS_DATAPUMP Security Model
• DBMS_DATAPUMP Constants
• DBMS_DATAPUMP Data Structures
• Summary of DBMS_DATAPUMP Subprograms
  • ADD_FILE Procedure
  • ATTACH Function
  • DATA_FILTER Procedures
  • DATA_REMAP Procedure
  • DETACH Procedure
  • GET_DUMPFILE_INFO Procedure
  • GET_STATUS Procedure
  • LOG_ENTRY Procedure
  • METADATA_FILTER Procedure
  • METADATA_REMAP Procedure
  • METADATA_TRANSFORM Procedure
  • OPEN Function
  • SET_PARALLEL Procedure
  • SET_PARAMETER Procedures
  • START_JOB Procedure
  • STOP_JOB Procedure
  • WAIT_FOR_JOB Procedure

46 DBMS_DB_VERSION

• DBMS_DB_VERSION Overview
• DBMS_DB_VERSION Constants
• DBMS_DB_VERSION Examples

47 DBMS_DBCOMP

• Using DBMS_DBCOMP
• DBMS_DBCOMP Security Model
• Summary of the DBMS_DBCOMP Subprogram
  • DBCOMP Procedure

48 DBMS_DBFS_CONTENT

• DBMS_DBFS_CONTENT Overview
• DBMS_DBFS_CONTENT Security Model
• DBMS_DBFS_CONTENT Constants
• Exceptions
• DBMS_DBFS_CONTENT Operational Notes
• DBMS_DBFS_CONTENT Data Structures
  • DBMS_DBFS_CONTENT FEATURE_T Record Type
  • DBMS_DBFS_CONTENT MOUNT_T Record Type
  • DBMS_DBFS_CONTENT PATH_ITEM_T Record Type
  • DBMS_DBFS_CONTENT PROP_ITEM_T Record Type
  • PROPERTY_T Record Type
  • DBMS_DBFS_CONTENT STORE_T Record Type
  • DBMS_DBFS_CONTENT FEATURES_T Table Type
  • MOUNTS_T Table Type
  • DBMS_DBFS_CONTENT PATH_ITEMS_T Table Type
  • DBMS_DBFS_CONTENT PROP_ITEMS_T Table Type
  • DBMS_DBFS_CONTENT PROPERTIES_T Table Type
  • STORES_T Table Type
• Summary of DBMS_DBFS_CONTENT Subprograms
  • CHECKACCESS Function
  • CHECKSPI Functions and Procedures
  • CREATEDIRECTORY Procedures
  • CREATEFILE Procedures
  • CREATELINK Procedures
  • CREATEREFERENCE Procedures
  • DECODEFEATURES Function
  • DELETECONTENT Procedure
  • DELETEDIRECTORY Procedure
  • DELETEFILE Procedure
  • FEATURENAME Function
  • FLUSHSTATS Function
  • GETDEFAULTACL Procedure
  • GETDEFAULTASOF Procedure
  • GETDEFAULTCONTEXT Procedure
  • GETDEFAULTOWNER Procedure
  • GETDEFAULTPRINCIPAL Procedure
  • GETFEATURESBYMOUNT Function
  • GETFEATURESBYNAME Function
  • GETFEATURESBYPATH Function
  • GETPATH Procedures
  • GETPATHBYMOUNTID Function
  • GETPATHBYSTOREID Function
  • GETPATHNOWAIT Procedures
  • GETSTOREBYMOUNT Function
  • GETSTOREBYNAME Function
  • GETSTOREBYPATH Function
  • GETSTATS Procedure
  • GETTRACE Function
  • GETVERSION Function
  • ISPATHLOCKED Procedure
  • LIST Function
  • LISTALLPROPERTIES Function
  • LISTALLCONTENT Function
  • LISTMOUNTS Function
  • LISTSTORES Function
  • LOCKPATH Procedure
  • MOUNTSTORE Procedure
  • NORMALIZEPATH Functions
  • PROPANY Functions
  • PROPERTIESH2T Function
  • PROPERTIEST2H Function
  • PROPNUMBER Function
  • PROPRAW Function
  • PROPTIMESTAMP Function
  • PROPVARCHAR2 Function
  • PURGEALL Procedure
  • PURGEPATH Procedure
  • PUTPATH Procedures
  • REGISTERSTORE Procedure
  • RENAMEPATH Procedures
  • RESTOREALL Procedure
  • RESTOREPATH Procedure
  • SETDEFAULTACL Procedure
  • SETDEFAULTASOF Procedure
  • SETDEFAULTCONTEXT Procedure
  • SETDEFAULTOWNER Procedure
  • SETDEFAULTPRINCIPAL Procedure
  • SETPATH Procedures
  • SETSTATS Procedure
  • SETTRACE Procedure
  • SPACEUSAGE Procedure
  • TRACE Procedure
  • TRACEENABLED Function
  • UNLOCKPATH Procedure
  • UNMOUNTSTORE Procedure
  • UNREGISTERSTORE Procedure

49 DBMS_DBFS_CONTENT_SPI

• ODBMS_DBFS_CONTENT_SPI Overview
• DBMS_DBFS_CONTENT_SPI Security Model
• DBMS_DBFS_CONTENT_SPI Operational Notes
• Summary of DBMS_DBFS_CONTENT_SPI Subprograms
  • CHECKACCESS Function
  • CREATEDIRECTORY Procedure
  • CREATEFILE Procedure
  • CREATELINK Procedure
  • CREATEREFERENCE Procedure
  • DELETECONTENT Procedure
  • DELETEDIRECTORY Procedure
  • DELETEFILE Procedure
  • GETFEATURES Function
  • GETPATH Procedures
  • GETPATHBYSTOREID Function
  • GETPATHNOWAIT Procedure
  • GETSTOREID Function
  • GETVERSION Function
  • ISPATHLOCKED Procedure
  • LIST Function
  • LOCKPATH Procedure
  • PURGEALL Procedure
  • PURGEPATH Procedure
  • PUTPATH Procedures
  • RENAMEPATH Procedure
  • RESTOREALL Procedure
  • RESTOREPATH Procedure
  • SEARCH Function
  • SETPATH Procedure
  • SPACEUSAGE Procedure
  • UNLOCKPATH Procedure

50 DBMS_DBFS_HS

• DBMS_DBFS_HS Overview
• DBMS_DBFS_HS Security Model
• DBMS_DBFS_HS Constants
• DBMS_DBFS_HS Operational Notes
• Summary of DBMS_DBFS_HS Subprograms
  • CLEANUPUNUSEDBACKUPFILES Procedure
  • CREATEBUCKET Procedure
  • CREATESTORE Procedure
  • DEREGSTORECOMMAND Function
  • DROPSTORE Procedure
  • FLUSHCACHE Procedure
  • GETSTOREPROPERTY Function
  • RECONFIGCACHE Procedure
  • REGISTERSTORECOMMAND Procedure
  • SENDCOMMAND Procedure
  • SETSTOREPROPERTY Procedure
  • STOREPUSH Procedure

51 DBMS_DBFS_SFS

• DBMS_DBFS_SFS Overview
• DBMS_DBFS_SFS Security Model
• DBMS_DBFS_SFS Constants
• Summary of DBMS_DBFS_SFS Subprograms
  • CREATEFILESYSTEM Procedure
  • CREATESTORE Procedure
  • DROPFILESYSTEM Procedures
  • INITFS Procedure

52 DBMS_DDL

• DBMS_DDL Deprecated Subprograms
• DBMS_DDL Security Model
• DBMS_DDL Operational Notes
• Summary of DBMS_DDL Subprograms
  • ALTER_COMPILE Procedure
  • ALTER_TABLE_NOT_REFERENCEABLE Procedure
  • ALTER_TABLE_REFERENCEABLE Procedure
  • CREATE_WRAPPED Procedures
  • IS_TRIGGER_FIRE_ONCE Function
  • SET_TRIGGER_FIRING_PROPERTY Procedures
  • WRAP Functions

53 DBMS_DEBUG

• DBMS_DEBUG Overview
• DBMS_DEBUG Constants
• DBMS_DEBUG Variables
• DBMS_DEBUG Exceptions
• DBMS_DEBUG Operational Notes
• DBMS_DEBUG Data Structures
  • BREAKPOINT_INFO Record Type
  • PROGRAM_INFO Record Type
  • RUNTIME_INFO Record Type
  • BACKTRACE_TABLE Table Type
  • BREAKPOINT_TABLE Table Type
  • INDEX_TABLE Table Type
  • VC2_TABLE Table Type
• Summary of DBMS_DEBUG Subprograms
  • ATTACH_SESSION Procedure
  • CONTINUE Function
  • DEBUG_OFF Procedure
  • DEBUG_ON Procedure
  • DELETE_BREAKPOINT Function
  • DELETE_OER_BREAKPOINT Function
  • DETACH_SESSION Procedure
  • DISABLE_BREAKPOINT Function
  • ENABLE_BREAKPOINT Function
  • EXECUTE Procedure
  • GET_INDEXES Function
  • GET_MORE_SOURCE Procedure
  • GET_LINE_MAP Function
  • GET_RUNTIME_INFO Function
  • GET_TIMEOUT_BEHAVIOUR Function
  • GET_VALUE Function
  • INITIALIZE Function
  • PING Procedure
  • PRINT_BACKTRACE Procedure
  • PRINT_INSTANTIATIONS Procedure
  • PROBE_VERSION Procedure
  • SELF_CHECK Procedure
  • SET_BREAKPOINT Function
  • SET_OER_BREAKPOINT Function
  • SET_TIMEOUT Function
  • SET_TIMEOUT_BEHAVIOUR Procedure
  • SET_VALUE Function
  • SHOW_BREAKPOINTS Procedures
  • SHOW_FRAME_SOURCE Procedure
  • SHOW_SOURCE Procedures
  • SYNCHRONIZE Function
  • TARGET_PROGRAM_RUNNING Procedure

54 DBMS_DEBUG_JDWP

• DBMS_DEBUG_JDWP Overview
• DBMS_DEBUG_JDWP Security Model
• Summary DBMS_DEBUG_JDWP Subprograms
  • CONNECT_TCP Procedure
  • CURRENT_SESSION_ID Function
  • CURRENT_SESSION_SERIAL Function
  • DISCONNECT Procedure
  • GET_NLS_PARAMETER Function
  • PROCESS_CONNECT_STRING Procedure
  • SET_NLS_PARAMETER Procedure

55 DBMS_DEBUG_JDWP_CUSTOM

• DBMS_DEBUG_JDWP_CUSTOM Overview
• DBMS_DEBUG_JDWP_CUSTOM Security Model
• Summary DBMS_DEBUG_JDWP_CUSTOM Subprograms
  • CONNECT_DEBUGGER Procedure

56 DBMS_DESCRIBE

• DBMS_DESCRIBE Overview
• DBMS_DESCRIBE Security Model
• DBMS_DESCRIBE Types
• DBMS_DESCRIBE Exceptions
• DBMS_DESCRIBE Examples
• Summary of DBMS_DESCRIBE Subprograms
  • DESCRIBE_PROCEDURE Procedure

57 DBMS_DG

• Using DBMS_DG
• DBMS_DG Security Model
• Summary of the DBMS_DG Subprogram
  • INITIATE_FS_FAILOVER Procedure

58 DBMS_DIMENSION

• DBMS_DIMENSION Security Model
• Summary of DBMS_DIMENSION Subprograms
  • DESCRIBE_DIMENSION Procedure
  • VALIDATE_DIMENSION Procedure

59 DBMS_DISTRIBUTED_TRUST_ADMIN

• DBMS_DISTRIBUTED_TRUST_ADMIN Overview
• DBMS_DISTRIBUTED_TRUST_ADMIN Security Model
• DBMS_DISTRIBUTED_TRUST_ADMIN Examples
• Summary of DBMS_DISTRIBUTED_TRUST_ADMIN Subprograms
  • ALLOW_ALL Procedure
  • ALLOW_SERVER Procedure
  • DENY_ALL Procedure
  • DENY_SERVER Procedure

60 DBMS_DNFS

• DBMS_DNFS Security Model
• Summary of DBMS_DNFS Subprograms
  • CLONEDB_RENAMEFILE Procedure

61 DBMS_DST

• DBMS_DST Overview
• DBMS_DST Security Model
• DBMS_DST Views
• Summary of DBMS_DST Subprograms
  • BEGIN_PREPARE Procedure
  • BEGIN_UPGRADE Procedure
  • CREATE_AFFECTED_TABLE Procedure
  • CREATE_ERROR_TABLE Procedure
  • CREATE_TRIGGER_TABLE Procedure
  • END_PREPARE Procedure
  • END_UPGRADE Procedure
  • FIND_AFFECTED_TABLES Procedure
  • UPGRADE_DATABASE Procedure
  • UPGRADE_SCHEMA Procedure
  • UPGRADE_TABLE Procedure

62 DBMS_EDITIONS_UTILITIES

• DBMS_EDITIONS_UTILITIES Overview
• DBMS_EDITIONS_UTILITIES Security Model
• DBMS_EDITIONS_UTILITIES Exceptions
• Summary of DBMS_EDITIONS_UTILITIES Subprograms
  • SET_EDITIONING_VIEWS_READ_ONLY Procedure
  • SET_NULL_COLUMN_VALUES_TO_EXPR Procedure

63 DBMS_EPG

• DBMS_EPG Overview
• DBMS_EPG Security Model
• DBMS_EPG Exceptions
• DBMS_EPG Data Structures
• DBMS_EPG Subprogram Groups
  • DBMS_EPG Configuration Subprograms
  • DBMS_EPG Authorization Subprograms
• Summary of DBMS_EPG Subprograms
  • AUTHORIZE_DAD Procedure
  • CREATE_DAD Procedure
  • DEAUTHORIZE_DAD Procedure
  • DELETE_DAD_ATTRIBUTE Procedure
  • DELETE_GLOBAL_ATTRIBUTE Procedure
  • DROP_DAD Procedure
  • GET_ALL_DAD_ATTRIBUTES Procedure
  • GET_ALL_DAD_MAPPINGS Procedure
  • GET_ALL_GLOBAL_ATTRIBUTES Procedure
  • GET_DAD_ATTRIBUTE Function
  • GET_DAD_LIST Procedure
  • GET_GLOBAL_ATTRIBUTE Function
  • MAP_DAD Procedure
  • SET_DAD_ATTRIBUTE Procedure
  • SET_GLOBAL_ATTRIBUTE Procedure
  • UNMAP_DAD Procedure

64 DBMS_ERRLOG

• DBMS_DIMENSION Security Model
• Summary of DBMS_ERRLOG Subprograms
  • CREATE_ERROR_LOG Procedure

65 DBMS_FGA

• DBMS_FGA Security Model
• DBMS_FGA Operational Notes
• Summary of DBMS_FGA Subprograms
  • ADD_POLICY Procedure
  • DISABLE_POLICY Procedure
  • DROP_POLICY Procedure
  • ENABLE_POLICY Procedure

66 DBMS_FILE_GROUP

• DBMS_FILE_GROUP Overview
• DBMS_FILE_GROUP Security Model
• DBMS_FILE_GROUP Constants
• DBMS_FILE_GROUP Examples
• Summary of DBMS_FILE_GROUP Subprograms
  • ADD_FILE Procedure
  • ALTER_FILE Procedure
  • ALTER_FILE_GROUP Procedure
  • ALTER_VERSION Procedure
  • CREATE_FILE_GROUP Procedure
  • CREATE_VERSION Procedure
  • DROP_FILE_GROUP Procedure
  • DROP_VERSION Procedure
  • GRANT_OBJECT_PRIVILEGE Procedure
  • GRANT_SYSTEM_PRIVILEGE Procedure
  • PURGE_FILE_GROUP Procedure
  • REMOVE_FILE Procedure
  • REVOKE_OBJECT_PRIVILEGE Procedure
  • REVOKE_SYSTEM_PRIVILEGE Procedure

67 DBMS_FILE_TRANSFER

• DBMS_FILE_TRANSFER Overview
• DBMS_FILE_TRANSFER Security Model
• DBMS_FILE_TRANSFER Operational Notes
• Summary of DBMS_FILE_TRANSFER Subprograms
  • COPY_FILE Procedure
  • GET_FILE Procedure
  • PUT_FILE Procedure

68 DBMS_FLASHBACK

• DBMS_FLASHBACK Overview
• DBMS_FLASHBACK Security Model
• DBMS_FLASHBACK Types
• DBMS_FLASHBACK Exceptions
• DBMS_FLASHBACK Operational Notes
• DBMS_FLASHBACK Examples
• Summary of DBMS_FLASHBACK Subprograms
  • DISABLE Procedure
  • ENABLE_AT_SYSTEM_CHANGE_NUMBER Procedure
  • ENABLE_AT_TIME Procedure
  • GET_SYSTEM_CHANGE_NUMBER Function
  • TRANSACTION_BACKOUT Procedures

69 DBMS_FLASHBACK_ARCHIVE

• DBMS_FLASHBACK_ARCHIVE Overview
• DBMS_FLASHBACK_ARCHIVE Security Model
• DBMS_FLASHBACK_ARCHIVE Constants
• Summary of DBMS_FLASHBACK_ARCHIVE Subprograms
  • ADD_TABLE_TO_APPLICATION Procedure
  • CREATE_TEMP_HISTORY_TABLE Procedure
  • DISABLE_APPLICATION Procedure
  • DISABLE_ASOF_VALID_TIME Procedure
  • DISASSOCIATE_FBA Procedure
  • DROP_APPLICATION Procedure
  • ENABLE_APPLICATION Procedure
  • ENABLE_AT_VALID_TIME Procedure
  • EXTEND_MAPPINGS Procedure
  • GET_SYS_CONTEXT Function
  • IMPORT_HISTORY Procedure
  • LOCK_DOWN_APPLICATION Procedure
  • PURGE_CONTEXT Procedure
  • REASSOCIATE_FBA Procedure
  • REGISTER_APPLICATION Procedure
  • REMOVE_TABLE_FROM_APPLICATION Procedure
  • SET_CONTEXT_LEVEL Procedure

70 DBMS_FREQUENT_ITEMSET

• Summary of DBMS_FREQUENT_ITEMSET Subprograms
  • FI_HORIZONTAL Function
  • FI_TRANSACTIONAL Function

71 DBMS_FS

• DBMS_FS Overview
• DBMS_FS Security Model
• Summary of DBMS_FS Subprograms
  • DESTROY_ORACLE_FS Procedure
  • MAKE_ORACLE_FS Procedure
  • MOUNT_ORACLE_FS Procedure
  • UNMOUNT_ORACLE_FS Procedure

72 DBMS_GOLDENGATE_ADM

• Using DBMS_GOLDENGATE_ADM
  • DBMS_GOLDENGATE_ADM Overview
  • DBMS_GOLDENGATE_ADM Security Model
• Summary of DBMS_GOLDENGATE_ADM Subprograms
  • ADD_AUTO_CDR Procedure
  • ADD_AUTO_CDR_COLUMN_GROUP Procedure
  • ADD_AUTO_CDR_DELTA_RES Procedure
  • ALTER_AUTO_CDR Procedure
  • ALTER_AUTO_CDR_COLUMN_GROUP Procedure
  • DELETE_PROCREP_EXCLUSION_OBJ Procedure
  • GG_PROCEDURE_REPLICATION_ON Function
  • INSERT_PROCREP_EXCLUSION_OBJ Procedure
  • PURGE_TOMBSTONES Procedure
  • REMOVE_AUTO_CDR Procedure
  • REMOVE_AUTO_CDR_COLUMN_GROUP Procedure
  • REMOVE_AUTO_CDR_DELTA_RES Procedure

73 DBMS_GOLDENGATE_AUTH

• DBMS_GOLDENGATE_AUTH Overview
• DBMS_GOLDENGATE_AUTH Security Model
• Summary of DBMS_GOLDENGATE_AUTH Subprograms
  • GRANT_ADMIN_PRIVILEGE Procedure
  • REVOKE_ADMIN_PRIVILEGE Procedure

74 DBMS_HADOOP

• DBMS_HADOOP Overview
• DBMS_HADOOP Security Model
• Summary of DBMS_HADOOP Subprograms
  • CREATE_EXTDDL_FOR_HIVE Procedure
  • SYNCHRONIZE_PARTITIONS_FOR_HIVE Procedure

75 DBMS_HANG_MANAGER

• DBMS_HANG_MANAGER Overview
• DBMS_HANG_MANAGER Security Model
• DBMS_HANG_MANAGER Constants
• DBMS_HANG_MANAGER Exceptions
• Summary of DBMS_HANG_MANAGER Subprograms
  • SET Procedure

76 DBMS_HEAT_MAP

• DBMS_HEAT_MAP Overview
• DBMS_HEAT_MAP Security Model
• Summary of DBMS_HEAT_MAP Subprograms
  • BLOCK_HEAT_MAP Function
  • EXTENT_HEAT_MAP Function
  • OBJECT_HEAT_MAP Function
  • SEGMENT_HEAT_MAP Procedure
  • TABLESPACE_HEAT_MAP Function

77 DBMS_HIERARCHY

• DBMS_HIERARCHY Overview
• DBMS_HIERARCHY Security Model
• Summary of DBMS_HIERARCHY Subprograms
  • CREATE_VALIDATE_LOG_TABLE Procedure
  • VALIDATE_ANALYTIC_VIEW Function
  • VALIDATE_CHECK_SUCCESS Function
  • VALIDATE_HIERARCHY Function

78 DBMS_HM

• DBMS_HM Security Model
• Summary of DBMS_HM Subprograms
  • GET_RUN_REPORT Function
  • RUN_CHECK Procedure

79 DBMS_HPROF

• Summary of DBMS_HPROF Subprograms
  • ANALYZE Function
  • START_PROFILING Procedure
  • STOP_PROFILING Procedure

80 DBMS_HS_PARALLEL

• Using the DBMS_HS_PARALLEL Subprogram
• Summary of DBMS_HS_PARALLEL Subprograms
  • CREATE_OR_REPLACE_VIEW Procedure
  • CREATE_TABLE_TEMPLATE Procedure
  • DROP_VIEW Procedure
  • LOAD_TABLE Procedure

81 DBMS_HS_PASSTHROUGH

• DBMS_HS_PASSTHROUGH Overview
• DBMS_HS_PASSTHROUGH Operational Notes
• Summary of DBMS_HS_PASSTHROUGH Subprograms
  • BIND_INOUT_VARIABLE Procedure
  • BIND_INOUT_VARIABLE_RAW Procedure
  • BIND_OUT_VARIABLE Procedure
  • BIND_OUT_VARIABLE_RAW Procedure
  • BIND_VARIABLE Procedure
  • BIND_VARIABLE_RAW Procedure
  • CLOSE_CURSOR Procedure
  • EXECUTE_IMMEDIATE Procedure
  • EXECUTE_NON_QUERY Function
  • FETCH_ROW Function
  • GET_VALUE Procedure
  • GET_VALUE_RAW Procedure
  • OPEN_CURSOR Function
  • PARSE Procedure

82 DBMS_ILM

• DBMS_ILM Overview
• DBMS_ILM Security Model
• DBMS_ILM Constants
• DBMS_ILM Exceptions
• Summary of DBMS_ILM Subprograms
  • ADD_TO_ILM Procedure
  • ARCHIVESTATENAME Function
  • EXECUTE_ILM Procedure
  • EXECUTE_ILM_TASK Procedure
  • PREVIEW_ILM Procedure
  • REMOVE_FROM_ILM Procedure
  • STOP_ILM Procedure

83 DBMS_ILM_ADMIN

• DBMS_ILM_ADMIN Overview
• DBMS_ILM_ADMIN Security Model
• DBMS_ILM_ADMIN Constants
• Summary of DBMS_ILM_ADMIN Subprograms
  • CLEAR_HEAT_MAP_ALL Procedure
  • CLEAR_HEAT_MAP_TABLE Procedure
  • CUSTOMIZE_ILM Procedure
  • DISABLE_ILM Procedure
  • ENABLE_ILM Procedure
  • SET_HEAT_MAP_ALL Procedure
  • SET_HEAT_MAP_START Procedure
  • SET_HEAT_MAP_TABLE Procedure

84 DBMS_INMEMORY

• DBMS_INMEMORY Overview
• DBMS_INMEMORY Security Model
• Summary of DBMS_INMEMORY Subprograms
  • IME_DROP_EXPRESSIONS Procedure
  • POPULATE Procedure
  • REPOPULATE Procedure
  • SEGMENT_DEALLOCATE_VERSIONS Procedure

85 DBMS_INMEMORY_ADMIN

• DBMS_INMEMORY_ADMIN Overview
• DBMS_INMEMORY_ADMIN Security Model
• DBMS_INMEMORY_ADMIN Operational Notes
• Summary of DBMS_INMEMORY_ADMIN Subprograms
  • FASTSTART_DISABLE Procedure
  • FASTSTART_ENABLE Procedure
  • FASTSTART_MIGRATE_STORAGE Procedure
  • GET_FASTSTART_TABLESPACE Function
  • IME_CAPTURE_EXPRESSIONS Procedure
  • IME_DROP_ALL_EXPRESSIONS Procedure
  • IME_POPULATE_EXPRESSIONS Procedure

86 DBMS_IOT

• Summary of DBMS_IOT Subprograms
  • BUILD_CHAIN_ROWS_TABLE Procedure
  • BUILD_EXCEPTIONS_TABLE Procedure

87 DBMS_JAVA

88 DBMS_JOB

• DBMS_JOB Security Model
• DBMS_JOB Operational Notes
• Summary of DBMS_JOB Subprograms
  • BROKEN Procedure
  • CHANGE Procedure
  • INSTANCE Procedure
  • INTERVAL Procedure
  • NEXT_DATE Procedure
  • REMOVE Procedure
  • RUN Procedure
  • SUBMIT Procedure
  • USER_EXPORT Procedures
  • WHAT Procedure

89 DBMS_JSON

• DBMS_JSON Overview
• DBMS_JSON Security Model
• DBMS_JSON Constants
• Summary of DBMS_JSON Subprograms
  • ADD_VIRTUAL_COLUMNS Procedure
  • CREATE_VIEW Procedure
  • CREATE_VIEW_ON_PATH Procedure
  • DROP_VIRTUAL_COLUMNS Procedure
  • GET_INDEX_DATAGUIDE Function
  • RENAME_COLUMN Procedure

90 DBMS_LDAP

91 DBMS_LDAP_UTL

92 DBMS_LIBCACHE

• DBMS_LIBCACHE Overview
• DBMS_LIBCACHE Security Model
• Summary of DBMS_LIBCACHE Subprograms
  • COMPILE_FROM_REMOTE Procedure

93 DBMS_LOB

• DBMS_LOB Overview
• DBMS_LOB Deprecated Subprograms
• DBMS_LOB Security Model
• DBMS_LOB Constants
• DBMS_LOB Datatypes
• DBMS_LOB Operational Notes
• DBMS_LOB Rules and Limits
• DBMS_LOB Exceptions
• Summary of DBMS_LOB Subprograms
  • APPEND Procedures
  • CLOB2FILE Procedure
  • CLOSE Procedure
  • COMPARE Functions
  • CONVERTTOBLOB Procedure
  • CONVERTTOCLOB Procedure
  • COPY Procedures
  • COPY_DBFS_LINK Procedures
  • COPY_FROM_DBFS_LINK
  • CREATETEMPORARY Procedures
  • DBFS_LINK_GENERATE_PATH Functions
  • ERASE Procedures
  • FILECLOSE Procedure
  • FILECLOSEALL Procedure
  • FILEEXISTS Function
  • FILEGETNAME Procedure
  • FILEISOPEN Function
  • FILEOPEN Procedure
  • FRAGMENT_DELETE Procedure
  • FRAGMENT_INSERT Procedures
  • FRAGMENT_MOVE Procedure
  • FRAGMENT_REPLACE Procedures
  • FREETEMPORARY Procedures
  • GET_DBFS_LINK Functions
  • GET_DBFS_LINK_STATE Procedures
  • GETCONTENTTYPE Functions
  • GET_STORAGE_LIMIT Function
  • GETCHUNKSIZE Functions
  • GETLENGTH Functions
  • GETOPTIONS Functions
  • INSTR Functions
  • ISOPEN Functions
  • ISREMOTE Function
  • ISSECUREFILE Function
  • ISTEMPORARY Functions
  • LOADBLOBFROMFILE Procedure
  • LOADCLOBFROMFILE Procedure
  • LOADFROMFILE Procedure
  • MOVE_TO_DBFS_LINK Procedures
  • OPEN Procedures
  • READ Procedures
  • SET_DBFS_LINK Procedures
  • SETCONTENTTYPE Procedure
  • SETOPTIONS Procedures
  • SUBSTR Functions
  • TRIM Procedures
  • WRITE Procedures
  • WRITEAPPEND Procedures

94 DBMS_LOCK

• DBMS_LOCK Overview
• DBMS_LOCK Security Model
• DBMS_LOCK Constants
• DBMS_LOCK. Rules and Limits
• DBMS_LOCK Operational Notes
• Summary of DBMS_LOCK Subprograms
  • ALLOCATE_UNIQUE Procedure
  • CONVERT Function
  • RELEASE Function
  • REQUEST Function
  • SLEEP Procedure

95 DBMS_LOGMNR

• DBMS_LOGMNR Overview
• DBMS_LOGMNR Security Model
• DBMS_LOGMNR Constants
• DBMS_LOGMNR Views
• DBMS_LOGMNR Operational Notes
• Summary of DBMS_LOGMNR Subprograms
  • ADD_LOGFILE Procedure
  • COLUMN_PRESENT Function
  • END_LOGMNR Procedure
  • MINE_VALUE Function
  • REMOVE_LOGFILE Procedure
  • START_LOGMNR Procedure

96 DBMS_LOGMNR_D

• DBMS_LOGMNR_D Overview
• DBMS_LOGMNR_D Security Model
• Summary of DBMS_LOGMNR_D Subprograms
  • BUILD Procedure
  • SET_TABLESPACE Procedure

97 DBMS_LOGSTDBY

• DBMS_LOGSTDBY Overview
• DBMS_LOGSTDBY Security Model
• DBMS_LOGSTDBY Constants
• Summary of DBMS_LOGSTDBY Subprograms
  • APPLY_SET Procedure
  • APPLY_UNSET Procedure
  • BUILD Procedure
  • EDS_ADD_TABLE
  • EDS_EVOLVE_AUTOMATIC
  • EDS_EVOLVE_MANUAL
  • EDS_REMOVE_TABLE
  • INSTANTIATE_TABLE Procedure
  • IS_APPLY_SERVER Function
  • MAP_PRIMARY_SCN Function
  • PREPARE_FOR_NEW_PRIMARY Procedure
  • PURGE_SESSION Procedure
  • REBUILD Procedure
  • SET_TABLESPACE Procedure
  • SKIP Procedure
  • SKIP_ERROR Procedure
  • SKIP_TRANSACTION Procedure
  • UNSKIP Procedure
  • UNSKIP_ERROR Procedure
  • UNSKIP_TRANSACTION Procedure

98 DBMS_LOGSTDBY_CONTEXT

• DBMS_LOGSTDBY_CONTEXT Overview
• DBMS_LOGSTDBY_CONTEXT Security Model
• Summary of DBMS_LOGSTDBY_CONTEXT Subprograms
  • CLEAR_ALL_CONTEXT Procedure
  • CLEAR_CONTEXT Procedure
  • GET_CONTEXT Procedure
  • SET_CONTEXT Procedure

99 DBMS_METADATA

• DBMS_METADATA Overview
• DBMS_METADATA Security Model
• Rules and Limits
• DBMS_METADATA Data Structures - Object and Table Types
• DBMS_METADATA Subprogram Groupings
  • DBMS_METADATA Subprograms for Retrieving Multiple Objects From the Database
  • DBMS_METADATA Subprograms for Submitting XML to the Database
• Summary of All DBMS_METADATA Subprograms
  • ADD_TRANSFORM Function
  • CLOSE Procedure
  • CONVERT Functions and Procedures
  • FETCH_xxx Functions and Procedures
  • GET_xxx Functions
  • GET_QUERY Function
  • OPEN Function
  • OPENW Function
  • PUT Function
  • SET_COUNT Procedure
  • SET_FILTER Procedure
  • SET_PARSE_ITEM Procedure
  • SET_TRANSFORM_PARAM and SET_REMAP_PARAM Procedures

100 DBMS_METADATA_DIFF

• DBMS_METADATA_DIFF Overview
• DBMS_METADATA_DIFF Security Model
• DBMS_METADATA_DIFF — Browsing APIs for Fetching and Comparing Objects
• Summary of DBMS_METADATA_DIFF Subprograms
  • OPENC Function
  • ADD_DOCUMENT Procedure
  • FETCH_CLOB Functions and Procedures
  • CLOSE Procedure

101 DBMS_MGD_ID_UTL

• DBMS_MGD_ID_UTL Security Model
• DBMS_MGD_ID_UTL Constants
• DBMS_MGD_ID_UTL Exceptions
• Summary of DBMS_MGD_ID_UTL Subprograms
  • ADD_SCHEME Procedure
  • CREATE_CATEGORY Function
  • EPC_TO_ORACLE_SCHEME Function
  • GET_CATEGORY_ID Function
  • GET_COMPONENTS Function
  • GET_ENCODINGS Function
  • GET_JAVA_LOGGING_LEVEL Function
  • GET_PLSQL_LOGGING_LEVEL Function
  • GET_SCHEME_NAMES Function
  • GET_TDT_XML Function
  • GET_VALIDATOR Function
  • REFRESH_CATEGORY Function
  • REMOVE_CATEGORY Procedure
  • REMOVE_PROXY Procedure
  • REMOVE_SCHEME Procedure
  • SET_JAVA_LOGGING_LEVEL Procedure
  • SET_PLSQL_LOGGING_LEVEL Procedure
  • SET_PROXY Procedure
  • VALIDATE_SCHEME Function

102 DBMS_MGWADM

• DBMS_MGWADM Security Model
• DBMS_MGWADM Deprecated Subprograms
• DBMS_MGWADM Constants
• DBMS_MGWADM Data Structures
  • DBMS_MGWADM SYS.MGW_MQSERIES_PROPERTIES Object Type
  • DBMS_MGWADM SYS.MGW_PROPERTIES Object Type
  • DBMS_MGWADM SYS.MGW_PROPERTY Object Type
  • SYS.MGW_TIBRV_PROPERTIES Object Type
• Summary of DBMS_MGWADM Subprograms
  • ADD_SUBSCRIBER Procedure
  • ALTER_AGENT Procedures
  • ALTER_JOB Procedure
  • ALTER_MSGSYSTEM_LINK Procedure for TIB/Rendezvous
  • ALTER_MSGSYSTEM_LINK Procedure for WebSphere MQ
  • ALTER_PROPAGATION_SCHEDULE Procedure
  • ALTER_SUBSCRIBER Procedure
  • CLEANUP_GATEWAY Procedures
  • CREATE_AGENT Procedure
  • CREATE_JOB Procedure
  • CREATE_MSGSYSTEM_LINK Procedures for TIB/Rendezvous
  • CREATE_MSGSYSTEM_LINK Procedures for WebSphere MQ
  • DB_CONNECT_INFO Procedure
  • DISABLE_JOB Procedure
  • DISABLE_PROPAGATION_SCHEDULE Procedure
  • ENABLE_JOB Procedure
  • ENABLE_PROPAGATION_SCHEDULE Procedure
  • REGISTER_FOREIGN_QUEUE Procedure
  • REMOVE_AGENT Procedure
  • REMOVE_JOB Procedure
  • REMOVE_MSGSYSTEM_LINK Procedure
  • REMOVE_OPTION Procedure
  • REMOVE_SUBSCRIBER Procedure
  • RESET_JOB Procedure
  • RESET_SUBSCRIBER Procedure
  • SCHEDULE_PROPAGATION Procedure
  • SET_LOG_LEVEL Procedures
  • SET_OPTION Procedure
  • SHUTDOWN Procedures
  • STARTUP Procedures
  • UNREGISTER_FOREIGN_QUEUE Procedure
  • UNSCHEDULE_PROPAGATION Procedure

103 DBMS_MGWMSG

• DBMS_MGWMSG Security Model
• DBMS_MGWMSG Constants
• DBMS_MGWMSG Types
  • DBMS_MGWMSG SYS.MGW_NAME_VALUE_T Type
  • DBMS_MGWMSG SYS.MGW_NAME_TYPE_ARRAY_T Type
  • DBMS_MGWMSG SYS.MGW_TEXT_VALUE_T Type
  • DBMS_MGWMSG SYS.MGW_RAW_VALUE_T Type
  • DBMS_MGWMSG SYS.MGW_BASIC_MSG_T Type
  • DBMS_MGWMSG SYS.MGW_NUMBER_ARRAY_T Type
  • DBMS_MGWMSG SYS.MGW_TIBRV_FIELD_T Type
  • DBMS_MGWMSG SYS.MGW_TIBRV_MSG_T Type
• Summary of DBMS_MGWMSG Subprograms
  • LCR_TO_XML Function
  • NVARRAY_ADD Procedure
  • NVARRAY_FIND_NAME Function
  • NVARRAY_FIND_NAME_TYPE Function
  • NVARRAY_GET Function
  • NVARRAY_GET_BOOLEAN Function
  • NVARRAY_GET_BYTE Function
  • NVARRAY_GET_DATE Function
  • NVARRAY_GET_DOUBLE Function
  • NVARRAY_GET_FLOAT Function
  • NVARRAY_GET_INTEGER Function
  • NVARRAY_GET_LONG Function
  • NVARRAY_GET_RAW Function
  • NVARRAY_GET_SHORT Function
  • NVARRAY_GET_TEXT Function
  • XML_TO_LCR Function

104 DBMS_MONITOR

• Summary of DBMS_MONITOR Subprograms
  • CLIENT_ID_STAT_DISABLE Procedure
  • CLIENT_ID_STAT_ENABLE Procedure
  • CLIENT_ID_TRACE_DISABLE Procedure
  • CLIENT_ID_TRACE_ENABLE Procedure
  • DATABASE_TRACE_DISABLE Procedure
  • DATABASE_TRACE_ENABLE Procedure
  • SERV_MOD_ACT_STAT_DISABLE Procedure
  • SERV_MOD_ACT_STAT_ENABLE Procedure
  • SERV_MOD_ACT_TRACE_DISABLE Procedure
  • SERV_MOD_ACT_TRACE_ENABLE Procedure
  • SESSION_TRACE_DISABLE Procedure
  • SESSION_TRACE_ENABLE Procedure

105 DBMS_MVIEW

• DBMS_MVIEW Operational Notes
• DBMS_MVIEW Security Model
• DBMS_MVIEW Rules and Limits
• Summary of DBMS_MVIEW Subprograms
  • BEGIN_TABLE_REORGANIZATION Procedure
  • END_TABLE_REORGANIZATION Procedure
  • ESTIMATE_MVIEW_SIZE Procedure
  • EXPLAIN_MVIEW Procedure
  • EXPLAIN_REWRITE Procedure
  • I_AM_A_REFRESH Function
  • PMARKER Function
  • PURGE_DIRECT_LOAD_LOG Procedure
  • PURGE_LOG Procedure
  • PURGE_MVIEW_FROM_LOG Procedure
  • REFRESH Procedures
  • REFRESH_ALL_MVIEWS Procedure
  • REFRESH_DEPENDENT Procedures
  • REGISTER_MVIEW Procedure
  • UNREGISTER_MVIEW Procedure

106 DBMS_MVIEW_STATS

• DBMS_MVIEW_STATS Overview
• DBMS_MVIEW_STATS Security Model
• Summary of DBMS_MVIEW_STATS Subprograms
  • PURGE_REFRESH_STATS Procedure
  • SET_MVREF_STATS_PARAMS Procedure
  • SET_SYSTEM_DEFAULT Procedure

107 DBMS_NETWORK_ACL_ADMIN

• DBMS_NETWORK_ACL_ADMIN Overview
• DBMS_NETWORK_ACL_ADMIN Deprecated Subprograms
• DBMS_NETWORK_ACL_ADMIN Security Model
• DBMS_NETWORK_ACL_ADMIN Constants
• DBMS_NETWORK_ACL_ADMIN Exceptions
• DBMS_NETWORK_ACL_ADMIN Examples
• Summary of DBMS_NETWORK_ACL_ADMIN Subprograms
  • ADD_PRIVILEGE Procedure
  • APPEND_HOST_ACE Procedure
  • APPEND_HOST_ACL Procedure
  • APPEND_WALLET_ACE Procedure
  • APPEND_WALLET_ACL Procedure
  • ASSIGN_ACL Procedure
  • ASSIGN_WALLET_ACL Procedure
  • CHECK_PRIVILEGE Function
  • CHECK_PRIVILEGE_ACLID Function
  • CREATE_ACL Procedure
  • DELETE_PRIVILEGE Procedure
  • DROP_ACL Procedure
  • REMOVE_HOST_ACE Procedure
  • REMOVE_WALLET_ACE Procedure
  • SET_HOST_ACL Procedure
  • SET_WALLET_ACL Procedure
  • UNASSIGN_ACL Procedure
  • UNASSIGN_WALLET_ACL Procedure

108 DBMS_NETWORK_ACL_UTILITY

• DBMS_NETWORK_ACL_UTILITY Security Model
• DBMS_NETWORK_ACL_UTILITY Examples
• Summary of DBMS_NETWORK_ACL_UTILITY Subprograms
  • CONTAINS_HOST Function
  • DOMAIN_LEVEL Function
  • DOMAINS Function
  • EQUALS_HOST Function

109 DBMS_ODCI

• Summary of DBMS_ODCI Subprograms
  • ESTIMATE_CPU_UNITS Function

110 DBMS_OUTLN

• DBMS_OUTLN Overview
• DBMS_OUTLN Security Model
• Summary of DBMS_OUTLN Subprograms
  • CLEAR_USED Procedure
  • CREATE_OUTLINE Procedure
  • DROP_BY_CAT Procedure
  • DROP_UNUSED Procedure
  • EXACT_TEXT_SIGNATURES Procedure
  • UPDATE_BY_CAT Procedure
  • UPDATE_SIGNATURES Procedure

111 DBMS_OUTPUT

• DBMS_OUTPUT Overview
• DBMS_OUTPUT Security Model
• DBMS_OUTPUT Operational Notes
• DBMS_OUTPUT Exceptions
• DBMS_OUTPUT Rules and Limits
• DBMS_OUTPUT Examples
• DBMS_OUTPUT Data Structures
  • CHARARR Table Type
  • DBMS_OUTPUT DBMSOUTPUT_LINESARRAY Object Type
• Summary of DBMS_OUTPUT Subprograms
  • DISABLE Procedure
  • ENABLE Procedure
  • GET_LINE Procedure
  • GET_LINES Procedure
  • NEW_LINE Procedure
  • PUT Procedure
  • PUT_LINE Procedure

112 DBMS_PARALLEL_EXECUTE

• DBMS_PARALLEL_EXECUTE Overview
• DBMS_PARALLEL_EXECUTE Security Model
• DBMS_PARALLEL_EXECUTE Constants
• DBMS_PARALLEL_EXECUTE Views
• DBMS_PARALLEL_EXECUTE Exceptions
• DBMS_PARALLEL_EXECUTE Examples
• Summary of DBMS_PARALLEL_EXECUTE Subprograms
  • ADM_DROP_CHUNKS Procedure
  • ADM_DROP_TASK Procedure
  • ADM_TASK_STATUS Function
  • ADM_STOP_TASK Procedure
  • CREATE_TASK Procedure
  • CREATE_CHUNKS_BY_NUMBER_COL Procedure
  • CREATE_CHUNKS_BY_ROWID Procedure
  • CREATE_CHUNKS_BY_SQL Procedure
  • DROP_TASK Procedure
  • DROP_CHUNKS Procedure
  • GENERATE_TASK_NAME Function
  • GET_NUMBER_COL_CHUNK Procedure
  • GET_ROWID_CHUNK Procedure
  • PURGE_PROCESSED_CHUNKS Procedure
  • RESUME_TASK Procedures
  • RUN_TASK Procedure
  • SET_CHUNK_STATUS Procedure
  • STOP_TASK Procedure
  • TASK_STATUS Procedure

113 DBMS_PART

• DBMS_PART Security Model
• DBMS_PART Operational Notes
• Summary of DBMS_PART Subprograms
  • CLEANUP_GIDX Procedure
  • CLEANUP_ONLINE_OP Procedure

114 DBMS_PCLXUTIL

• DBMS_PCLXUTIL Overview
• DBMS_PCLXUTIL Security Model
• DBMS_PCLXUTIL Operational Notes
• DBMS_PCLXUTIL Rules and Limits
• Summary of DBMS_PCLXUTIL Subprograms
  • BUILD_PART_INDEX Procedure

115 DBMS_PDB

• DBMS_PDB Overview
• DBMS_PDB Security Model
• Summary of DBMS_PDB Subprograms
  • CHECK_PLUG_COMPATIBILITY Function
  • DESCRIBE Procedure
  • RECOVER Procedure
  • REMOVE_LINK Procedure
  • SET_DATA_LINKED Procedure
  • SET_EXT_DATA_LINKED Procedure
  • SET_METADATA_LINKED Procedure
  • SET_PROFILE_EXPLICIT Procedure
  • SET_ROLE_EXPLICIT Procedure
  • SET_USER_EXPLICIT Procedure

116 DBMS_PDB_ALTER_SHARING

• DBMS_PDB_ALTER_SHARING Overview
• DBMS_PDB_ALTER_SHARING Security Model
• Summary of DBMS_PDB_ALTER_SHARING Subprograms
  • REMOVE_LINK Procedure
  • SET_DATA_LINKED Procedure
  • SET_EXT_DATA_LINKED Procedure
  • SET_METADATA_LINKED Procedure
  • SET_PROFILE_EXPLICIT Procedure
  • SET_ROLE_EXPLICIT Procedure
  • SET_USER_EXPLICIT Procedure

117 DBMS_PERF

• DBMS_PERF Overview
• DBMS_PERF Security Model
• Summary of DBMS_PERF Subprograms
  • REPORT_PERFHUB Function
  • REPORT_SESSION Function
  • REPORT_SQL Function

118 DBMS_PIPE

• DBMS_PIPE Overview
• DBMS_PIPE Security Model
• DBMS_PIPE Constants
• DBMS_PIPE Operational Notes
• DBMS_PIPE Exceptions
• DBMS_PIPE Examples
• Summary of DBMS_PIPE Subprograms
  • CREATE_PIPE Function
  • NEXT_ITEM_TYPE Function
  • PACK_MESSAGE Procedures
  • PURGE Procedure
  • RECEIVE_MESSAGE Function
  • RESET_BUFFER Procedure
  • REMOVE_PIPE Function
  • SEND_MESSAGE Function
  • UNIQUE_SESSION_NAME Function
  • UNPACK_MESSAGE Procedures

119 DBMS_PLSQL_CODE_COVERAGE

• DBMS_PLSQL_CODE_COVERAGE Overview
• DBMS_PLSQL_CODE_COVERAGE Security Model
• Summary of DBMS_PLSQL_CODE_COVERAGE Subprograms
  • CREATE_COVERAGE_TABLES Procedure
  • START_COVERAGE Function
  • STOP_COVERAGE Procedure

120 DBMS_PREDICTIVE_ANALYTICS

• DBMS_PREDICTIVE_ANALYTICS Overview
• DBMS_PREDICTIVE_ANALYTICS Security Model
• Summary of DBMS_PREDICTIVE_ANALYTICS Subprograms
  • EXPLAIN Procedure
  • PREDICT Procedure
  • PROFILE Procedure

121 DBMS_PREPROCESSOR

• DBMS_PREPROCESSOR Overview
• DBMS_PREPROCESSOR Operating Notes
• DBMS_PREPROCESSOR Data Structures
  • DBMS_PREPROCESSOR SOURCE_LINES_T Table Type
• Summary of DBMS_PREPROCESSOR Subprograms
  • GET_POST_PROCESSED_SOURCE Functions
  • PRINT_POST_PROCESSED_SOURCE Procedures

122 DBMS_PRIVILEGE_CAPTURE

• DBMS_PRIVILEGE_CAPTURE Overview
• DBMS_PRIVILEGE_CAPTURE Security Model
• DBMS_PRIVILEGE_CAPTURE Constants
• DBMS_PRIVILEGE_CAPTURE Examples
• Summary of DBMS_PRIVILEGE_CAPTURE Subprograms
  • CAPTURE_DEPENDENCY_PRIVS Procedure
  • CREATE_CAPTURE Procedure
  • DELETE_RUN Procedure
  • DISABLE_CAPTURE Procedure
  • DROP_CAPTURE Procedure
  • ENABLE_CAPTURE Procedure
  • GENERATE_RESULT Procedure

123 DBMS_PROCESS

• DBMS_PROCESS Overview
• DBMS_PROCESS Security Model
• Summary of DBMS_PROCESS Subprograms
  • CONFIGURE_POOL Procedure
  • START_POOL Procedure
  • STOP_POOL Procedure

124 DBMS_PROFILER

• DBMS_PROFILER Overview
• DBMS_PROFILER Security Model
• DBMS_PROFILER Operational Notes
• DBMS_PROFILER Exceptions
• Summary of DBMS_PROFILER Subprograms
  • FLUSH_DATA Function and Procedure
  • GET_VERSION Procedure
  • INTERNAL_VERSION_CHECK Function
  • PAUSE_PROFILER Function and Procedure
  • RESUME_PROFILER Function and Procedure
  • START_PROFILER Functions and Procedures
  • STOP_PROFILER Function and Procedure

125 DBMS_PROPAGATION_ADM

• DBMS_PROPAGATION_ADM Overview
• DBMS_PROPAGATION_ADM Security Model
• Summary of DBMS_PROPAGATION_ADM Subprograms
  • ALTER_PROPAGATION Procedure
  • CREATE_PROPAGATION Procedure
  • DROP_PROPAGATION Procedure
  • START_PROPAGATION Procedure
  • STOP_PROPAGATION Procedure

126 DBMS_QOPATCH

• DBMS_QOPATCH Overview
• DBMS_QOPATCH Security Model
• DBMS_QOPATCH Operational Notes
• DBMS_QOPATCH Exceptions
• Summary of DBMS_QOPATCH Subprograms
  • GET_OPATCH_BUGS Function
  • GET_OPATCH_COUNT Function
  • GET_OPATCH_DATA Function
  • GET_OPATCH_FILES Function
  • GET_OPATCH_INSTALL_INFO Function
  • GET_OPATCH_LIST Function
  • GET_OPATCH_LSINVENTORY
  • GET_OPATCH_OLAYS Function
  • GET_OPATCH_PREQS Function
  • GET_OPATCH_XSLT
  • GET_SQLPATCH_STATUS Procedure
  • IS_PATCH_INSTALLED Function
  • SET_CURRENT_OPINST Procedure

127 DBMS_RANDOM

• DBMS_RANDOM Deprecated Subprograms
• DBMS_RANDOM Security Model
• DBMS_RANDOM Operational Notes
• Summary of DBMS_RANDOM Subprograms
  • INITIALIZE Procedure
  • NORMAL Function
  • RANDOM Function
  • SEED Procedures
  • STRING Function
  • TERMINATE Procedure
  • VALUE Functions

128 DBMS_REDACT

• DBMS_REDACT Overview
• DBMS_REDACT Security Model
• DBMS_REDACT Constants
• DBMS_REDACT Operating Procedures
• Summary of DBMS_REDACT Subprograms
  • ADD_POLICY Procedure
  • ALTER_POLICY Procedure
  • APPLY_POLICY_EXPR_TO_COL Procedure
  • CREATE_POLICY_EXPRESSION Procedure
  • DISABLE_POLICY Procedure
  • DROP_POLICY Procedure
  • DROP_POLICY_EXPRESSION Procedure
  • ENABLE_POLICY Procedure
  • UPDATE_FULL_REDACTION_VALUES Procedure
  • UPDATE_POLICY_EXPRESSION Procedure

129 DBMS_REDEFINITION

• DBMS_REDEFINITION Overview
• DBMS_REDEFINITION Security Model
• DBMS_REDEFINITION Constants
• DBMS_REDEFINITION Operational Notes
• DBMS_REDEFINITION Rules and Limits
• DBMS_REDEFINITION Examples
• Summary of DBMS_REDEFINITION Subprograms
  • ABORT_REDEF_TABLE Procedure
  • ABORT_ROLLBACK Procedure
  • ABORT_UPDATE Procedure
  • CAN_REDEF_TABLE Procedure
  • COPY_TABLE_DEPENDENTS Procedure
  • EXECUTE_UPDATE Procedure
  • FINISH_REDEF_TABLE Procedure
  • REDEF_TABLE Procedure
  • REGISTER_DEPENDENT_OBJECT Procedure
  • ROLLBACK Procedure
  • SET_PARAM Procedure
  • START_REDEF_TABLE Procedure
  • SYNC_INTERIM_TABLE Procedure
  • UNREGISTER_DEPENDENT_OBJECT Procedure

130 DBMS_REFRESH

• DBMS_REFRESH Overview
• DBMS_REFRESH Security Model
• Summary of DBMS_REFRESH Subprograms
  • ADD Procedure
  • CHANGE Procedure
  • DESTROY Procedure
  • MAKE Procedure
  • REFRESH Procedure
  • SUBTRACT Procedure

131 DBMS_REPAIR

• DBMS_REPAIR Overview
• DBMS_REPAIR Security Model
• DBMS_REPAIR Constants
• DBMS_REPAIR Operating Notes
• DBMS_REPAIR Exceptions
• DBMS_REPAIR Examples
• Summary of DBMS_REPAIR Subprograms
  • ADMIN_TABLES Procedure
  • CHECK_OBJECT Procedure
  • DUMP_ORPHAN_KEYS Procedure
  • FIX_CORRUPT_BLOCKS Procedure
  • ONLINE_INDEX_CLEAN Function
  • REBUILD_FREELISTS Procedure
  • SEGMENT_FIX_STATUS Procedure
  • SKIP_CORRUPT_BLOCKS Procedure

132 DBMS_RESCONFIG

• DBMS_RESCONFIG Overview
• Summary of DBMS_RESCONFIG Subprograms
  • ADDREPOSITORYRESCONFIG Procedure
  • ADDRESCONFIG Procedure
  • APPENDRESCONFIG Procedure
  • DELETEREPOSITORYRESCONFIG Procedure
  • DELETERESCONFIG Procedures
  • GETLISTENERS Function
  • GETREPOSITORYRESCONFIG Function
  • GETREPOSITORYRESCONFIGPATHS Function
  • GETRESCONFIG Function
  • GETRESCONFIGPATHS Function
  • PATCHREPOSITORYRESCONFIGLIST Procedure

133 DBMS_RESOURCE_MANAGER

• DBMS_RESOURCE_MANAGER Deprecated Subprograms
• DBMS_RESOURCE_MANAGER Security Model
• DBMS_RESOURCE_MANAGER Constants
• Summary of DBMS_RESOURCE_MANAGER Subprograms
  • BEGIN_SQL_BLOCK Procedure
  • CALIBRATE_IO Procedure
  • CLEAR_PENDING_AREA Procedure
  • CREATE_CATEGORY Procedure
  • CREATE_CDB_PLAN Procedure
  • CREATE_CDB_PLAN_DIRECTIVE Procedure
  • CREATE_CDB_PROFILE_DIRECTIVE Procedure
  • CREATE_CONSUMER_GROUP Procedure
  • CREATE_PENDING_AREA Procedure
  • CREATE_PLAN Procedure
  • CREATE_PLAN_DIRECTIVE Procedure
  • CREATE_SIMPLE_PLAN Procedure
  • DELETE_CATEGORY Procedure
  • DELETE_CDB_PLAN Procedure
  • DELETE_CDB_PLAN_DIRECTIVE Procedure
  • DELETE_CDB_PROFILE_DIRECTIVE Procedure
  • DELETE_CONSUMER_GROUP Procedure
  • DELETE_PLAN Procedure
  • DELETE_PLAN_CASCADE Procedure
  • DELETE_PLAN_DIRECTIVE Procedure
  • DEQUEUE_PARALLEL_STATEMENT Procedure
  • END_SQL_BLOCK Procedure
  • SET_CONSUMER_GROUP_MAPPING Procedure
  • SET_CONSUMER_GROUP_MAPPING_PRI Procedure
  • SET_INITIAL_CONSUMER_GROUP Procedure
  • SUBMIT_PENDING_AREA Procedure
  • SWITCH_CONSUMER_GROUP_FOR_SESS Procedure
  • SWITCH_CONSUMER_GROUP_FOR_USER Procedure
  • SWITCH_PLAN Procedure
  • UPDATE_CATEGORY Procedure
  • UPDATE_CDB_AUTOTASK_DIRECTIVE Procedure
  • UPDATE_CDB_DEFAULT_DIRECTIVE Procedure
  • UPDATE_CDB_PLAN Procedure
  • UPDATE_CDB_PLAN_DIRECTIVE Procedure
  • UPDATE_CDB_PROFILE_DIRECTIVE Procedure
  • UPDATE_CONSUMER_GROUP Procedure
  • UPDATE_PLAN Procedure
  • UPDATE_PLAN_DIRECTIVE Procedure
  • VALIDATE_PENDING_AREA Procedure

134 DBMS_RESOURCE_MANAGER_PRIVS

• Summary of DBMS_RESOURCE_MANAGER_PRIVS Subprograms
  • GRANT_SWITCH_CONSUMER_GROUP Procedure
  • GRANT_SYSTEM_PRIVILEGE Procedure
  • REVOKE_SWITCH_CONSUMER_GROUP Procedure
  • REVOKE_SYSTEM_PRIVILEGE Procedure

135 DBMS_RESULT_CACHE

• DBMS_RESULT_CACHE Security Model
• DBMS_RESULT_CACHE Constants
• Summary of DBMS_RESULT_CACHE Subprograms
  • BLACK_LIST Function
  • BLACK_LIST_ADD Procedure
  • BLACK_LIST_CLEAR Procedure
  • BLACK_LIST_REMOVE Procedure
  • BYPASS Procedure
  • FLUSH Function & Procedure
  • INVALIDATE Functions & Procedures
  • INVALIDATE_OBJECT Functions & Procedures
  • MEMORY_REPORT Procedure
  • STATUS Function

136 DBMS_RESUMABLE

• DBMS_RESUMABLE Operational Notes
• Summary of DBMS_RESUMABLE Subprograms
  • ABORT Procedure
  • GET_SESSION_TIMEOUT Function
  • GET_TIMEOUT Function
  • SET_SESSION_TIMEOUT Procedure
  • SET_TIMEOUT Procedure
  • SPACE_ERROR_INFO Function

137 DBMS_RLS

• DBMS_RLS Overview
• DBMS_RLS Security Model
• DBMS_RLS Constants
• DBMS_RLS Operational Notes
• DBMS_RLS Rules and Limits
• Summary of DBMS_RLS Subprograms
  • ADD_GROUPED_POLICY Procedure
  • ADD_POLICY Procedure
  • ADD_POLICY_CONTEXT Procedure
  • ALTER_POLICY Procedure
  • ALTER_GROUPED_POLICY Procedure
  • CREATE_POLICY_GROUP Procedure
  • DELETE_POLICY_GROUP Procedure
  • DISABLE_GROUPED_POLICY Procedure
  • DROP_GROUPED_POLICY Procedure
  • DROP_POLICY Procedure
  • DROP_POLICY_CONTEXT Procedure
  • ENABLE_GROUPED_POLICY Procedure
  • ENABLE_POLICY Procedure
  • REFRESH_GROUPED_POLICY Procedure
  • REFRESH_POLICY Procedure

138 DBMS_ROLLING

• DBMS_ROLLING Overview
• DBMS_ROLLING Security Model
• Summary of DBMS_ROLLING Subprograms
  • INIT_PLAN Procedure
  • DESTROY_PLAN Procedure
  • BUILD_PLAN Procedure
  • SET_PARAMETER Procedure
  • START_PLAN Procedure
  • SWITCHOVER Procedure
  • FINISH_PLAN Procedure
  • ROLLBACK_PLAN Procedure

139 DBMS_ROWID

• DBMS_ROWID Security Model
• DBMS_ROWID Types
• DBMS_ROWID Exceptions
• DBMS_ROWID Operational Notes
• DBMS_ROWID Examples
• Summary of DBMS_ROWID Subprograms
  • ROWID_BLOCK_NUMBER Function
  • ROWID_CREATE Function
  • ROWID_INFO Procedure
  • ROWID_OBJECT Function
  • ROWID_RELATIVE_FNO Function
  • ROWID_ROW_NUMBER Function
  • ROWID_TO_ABSOLUTE_FNO Function
  • ROWID_TO_EXTENDED Function
  • ROWID_TO_RESTRICTED Function
  • ROWID_TYPE Function
  • ROWID_VERIFY Function

140 DBMS_RULE

• DBMS_RULE Overview
• DBMS_RULE Security Model
• Summary of DBMS_RULE Subprograms
  • CLOSE_ITERATOR Procedure
  • EVALUATE Procedure
  • EVALUATE_EXPRESSION Procedure
  • EVALUATE_EXPRESSION_ITERATOR Procedure
  • EVALUATE_RULE Procedure
  • EVALUATE_RULE_ITERATOR Procedure
  • GET_NEXT_HIT Function
  • GET_NEXT_RESULT Function
  • IS_FAST Procedure

141 DBMS_RULE_ADM

• DBMS_RULE_ADM Overview
• DBMS_RULE_ADM Security Model
• Summary of DBMS_RULE_ADM Subprograms
  • ADD_RULE Procedure
  • ALTER_EVALUATION_CONTEXT Procedure
  • ALTER_RULE Procedure
  • CREATE_EVALUATION_CONTEXT Procedure
  • CREATE_RULE Procedure
  • CREATE_RULE_SET Procedure
  • DROP_EVALUATION_CONTEXT Procedure
  • DROP_RULE Procedure
  • DROP_RULE_SET Procedure
  • GRANT_OBJECT_PRIVILEGE Procedure
  • GRANT_SYSTEM_PRIVILEGE Procedure
  • REMOVE_RULE Procedure
  • REVOKE_OBJECT_PRIVILEGE Procedure
  • REVOKE_SYSTEM_PRIVILEGE Procedure

142 DBMS_SCHEDULER

• DBMS_SCHEDULER Deprecated Subprograms
• DBMS_SCHEDULER Security Model
• DBMS_SCHEDULER Rules and Limits
• DBMS_SCHEDULER Operational Notes
• DBMS_SCHEDULER Data Structures
  • DBMS_SCHEDULER JOBARG Object Type
  • JOBARG_ARRAY Table Type
  • DBMS_SCHEDULER JOB_DEFINITION Object Type
  • JOB_DEFINITION_ARRAY Table Type
  • JOBATTR Object Type
  • JOBATTR_ARRAY Table Type
  • SCHEDULER$_STEP_TYPE Object Type
  • SCHEDULER$_STEP_TYPE_LIST Table Type
  • SCHEDULER$_EVENT_INFO Object Type
  • SCHEDULER_FILEWATCHER_RESULT Object Type
  • SCHEDULER_FILEWATCHER_REQUEST Object Type
• Summary of DBMS_SCHEDULER Subprograms
  • ADD_EVENT_QUEUE_SUBSCRIBER Procedure
  • ADD_GROUP_MEMBER Procedure
  • ADD_JOB_EMAIL_NOTIFICATION Procedure
  • ADD_TO_INCOMPATIBILITY Procedure
  • ALTER_CHAIN Procedure
  • ALTER_RUNNING_CHAIN Procedure
  • CLOSE_WINDOW Procedure
  • COPY_JOB Procedure
  • CREATE_CHAIN Procedure
  • CREATE_CREDENTIAL Procedure
  • CREATE_DATABASE_DESTINATION Procedure
  • CREATE_EVENT_SCHEDULE Procedure
  • CREATE_FILE_WATCHER Procedure
  • CREATE_GROUP Procedure
  • CREATE_INCOMPATIBILITY Procedure
  • CREATE_JOB Procedure
  • CREATE_JOB_CLASS Procedure
  • CREATE_JOBS Procedure
  • CREATE_PROGRAM Procedure
  • CREATE_RESOURCE Procedure
  • CREATE_SCHEDULE Procedure
  • CREATE_WINDOW Procedure
  • DEFINE_ANYDATA_ARGUMENT Procedure
  • DEFINE_CHAIN_EVENT_STEP Procedure
  • DEFINE_CHAIN_RULE Procedure
  • DEFINE_CHAIN_STEP Procedure
  • DEFINE_METADATA_ARGUMENT Procedure
  • DEFINE_PROGRAM_ARGUMENT Procedure
  • DISABLE Procedure
  • DROP_AGENT_DESTINATION Procedure
  • DROP_CHAIN Procedure
  • DROP_CHAIN_RULE Procedure
  • DROP_CHAIN_STEP Procedure
  • DROP_CREDENTIAL Procedure
  • DROP_DATABASE_DESTINATION Procedure
  • DROP_FILE_WATCHER Procedure
  • DROP_GROUP Procedure
  • DROP_INCOMPATIBILITY Procedure
  • DROP_JOB Procedure
  • DROP_JOB_CLASS Procedure
  • DROP_PROGRAM Procedure
  • DROP_PROGRAM_ARGUMENT Procedure
  • DROP_RESOURCE Procedure
  • DROP_SCHEDULE Procedure
  • DROP_WINDOW Procedure
  • ENABLE Procedure
  • END_DETACHED_JOB_RUN Procedure
  • EVALUATE_CALENDAR_STRING Procedure
  • EVALUATE_RUNNING_CHAIN Procedure
  • GENERATE_JOB_NAME Function
  • GET_AGENT_INFO Function
  • GET_AGENT_VERSION Function
  • GET_ATTRIBUTE Procedure
  • GET_FILE Procedure
  • GET_SCHEDULER_ATTRIBUTE Procedure
  • OPEN_WINDOW Procedure
  • PURGE_LOG Procedure
  • PUT_FILE Procedure
  • REMOVE_EVENT_QUEUE_SUBSCRIBER Procedure
  • REMOVE_FROM_INCOMPATIBILITY Procedure
  • REMOVE_GROUP_MEMBER Procedure
  • REMOVE_JOB_EMAIL_NOTIFICATION Procedure
  • RESET_JOB_ARGUMENT_VALUE Procedure
  • RUN_CHAIN Procedure
  • RUN_JOB Procedure
  • SET_AGENT_REGISTRATION_PASS Procedure
  • SET_ATTRIBUTE Procedure
  • SET_ATTRIBUTE_NULL Procedure
  • SET_JOB_ANYDATA_VALUE Procedure
  • SET_JOB_ARGUMENT_VALUE Procedure
  • SET_JOB_ATTRIBUTES Procedure
  • SET_RESOURCE_CONSTRAINT Procedure
  • SET_SCHEDULER_ATTRIBUTE Procedure
  • STOP_JOB Procedure

143 DBMS_SERVER_ALERT

• DBMS_SERVER_ALERT Security Model
• DBMS_SERVER_ALERT Object Types
• DBMS_SERVER_ALERT Relational Operators
• DBMS_SERVER_ALERT Supported Metrics
• Summary of DBMS_SERVER_ALERT Subprograms
  • EXPAND_MESSAGE Function
  • GET_THRESHOLD Procedure
  • SET_THRESHOLD Procedure

144 DBMS_SERVICE

• DBMS_SERVICE Overview
• DBMS_SERVICE Security Model
• DBMS_SERVICE Constants
• DBMS_SERVICE Operating Procedures
• DBMS_SERVICE Exceptions
• Summary of DBMS_SERVICE Subprograms
  • CREATE_SERVICE Procedure
  • DELETE_SERVICE Procedure
  • DISCONNECT_SESSION Procedure
  • MODIFY_SERVICE Procedure
  • START_SERVICE Procedure
  • STOP_SERVICE Procedure

145 DBMS_SESSION

• DBMS_SESSION Security Model
• DBMS_SESSION Operational Notes
• DBMS_SESSION Data Structures
  • DBMS_SERVICE INTEGER_ARRAY Table Type
  • DBMS_SERVICE LNAME_ARRAY Table Type
• Summary of DBMS_SESSION Subprograms
  • CLEAR_ALL_CONTEXT Procedure
  • CLEAR_CONTEXT Procedure
  • CLEAR_IDENTIFIER Procedure
  • CLOSE_DATABASE_LINK Procedure
  • FREE_UNUSED_USER_MEMORY Procedure
  • GET_PACKAGE_MEMORY_UTILIZATION Procedure
  • IS_ROLE_ENABLED Function
  • IS_SESSION_ALIVE Function
  • LIST_CONTEXT Procedures
  • MODIFY_PACKAGE_STATE Procedure
  • SESSION_TRACE_DISABLE Procedure
  • SESSION _TRACE_ENABLE Procedure
  • RESET_PACKAGE Procedure
  • SET_CONTEXT Procedure
  • SET_EDITION_DEFERRED Procedure
  • SET_IDENTIFIER Procedure
  • SET_NLS Procedure
  • SET_ROLE Procedure
  • SET_SQL_TRACE Procedure
  • SWITCH_CURRENT_CONSUMER_GROUP Procedure
  • UNIQUE_SESSION_ID Function

146 DBMS_SFW_ACL_ADMIN

• DBMS_SFW_ACL_ADMIN Security Model
• DBMS_SFW_ACL_ADMIN Operational Notes
• DBMS_SFW_ACL_ADMIN Examples
• Summary of DBMS_SFW_ACL_ADMIN Subprograms
  • COMMIT_ACL Procedure
  • IP_ADD_ACE Procedure
  • IP_ADD_PDB_ACE Procedure
  • IP_REMOVE_ACE Procedure
  • IP_REMOVE_ACL Procedure
  • IP_REMOVE_PDB_ACE Procedure
  • IP_REMOVE_PDB_ACL Procedure

147 DBMS_SHARED_POOL

• DBMS_SHARED_POOL Overview
• DBMS_SHARED_POOL Operational Notes
• Summary of DBMS_SHARED_POOL Subprograms
  • ABORTED_REQUEST_THRESHOLD Procedure
  • KEEP Procedure
  • MARKHOT Procedure
  • PURGE Procedure
  • SIZES Procedure
  • UNKEEP Procedure
  • UNMARKHOT Procedure

148 DBMS_SPACE

• DBMS_SPACE Security Model
• DBMS_SPACE Data Structures
  • DBMS_SPACE CREATE_TABLE_COST_COLINFO Object Type
  • DBMS_SPACE ASA_RECO_ROW Record Type
  • DBMS_SPACE ASA_RECO_ROW_TB Table Type
• Summary of DBMS_SPACE Subprograms
  • DBMS_SPACE ASA_RECOMMENDATIONS Function
  • CREATE_INDEX_COST Procedure
  • CREATE_TABLE_COST Procedures
  • FREE_BLOCKS Procedure
  • ISDATAFILEDROPPABLE_NAME Procedure
  • OBJECT_DEPENDENT_SEGMENTS Function
  • OBJECT_GROWTH_TREND Function
  • SPACE_USAGE Procedures
  • UNUSED_SPACE Procedure

149 DBMS_SPACE_ADMIN

• DBMS_SPACE_ADMIN Security Model
• DBMS_SPACE_ADMIN Constants
• DBMS_SPACE_ADMIN Operational Notes
• Summary of DBMS_SPACE_ADMIN Subprograms
  • ASSM_SEGMENT_VERIFY Procedure
  • ASSM_TABLESPACE_VERIFY Procedure
  • DROP_EMPTY_SEGMENTS Procedure
  • GET_SEGADV_ATTRIB Procedure
  • MATERIALIZE_DEFERRED_SEGMENTS Procedure
  • SEGMENT_CORRUPT Procedure
  • SEGMENT_DROP_CORRUPT Procedure
  • SEGMENT_DUMP Procedure
  • SEGMENT_VERIFY Procedure
  • SET_SEGADV_ATTRIB Procedure
  • TABLESPACE_FIX_BITMAPS Procedure
  • TABLESPACE_FIX_SEGMENT_STATES Procedure
  • TABLESPACE_MIGRATE_FROM_LOCAL Procedure
  • TABLESPACE_MIGRATE_TO_LOCAL Procedure
  • TABLESPACE_REBUILD_BITMAPS Procedure
  • TABLESPACE_REBUILD_QUOTAS Procedure
  • TABLESPACE_RELOCATE_BITMAPS Procedure
  • TABLESPACE_VERIFY Procedure

150 DBMS_SPD

• DBMS_SPD Overview
• DBMS_SPD Security Model
• DBMS_SPD Views
• Summary of DBMS_SPD Subprograms
  • ALTER_SQL_PLAN_DIRECTIVE Procedure
  • CREATE_STGTAB_DIRECTIVE Procedure
  • DROP_SQL_PLAN_DIRECTIVE Procedure
  • FLUSH_SQL_PLAN_DIRECTIVE Procedure
  • GET_PREFS Function
  • PACK_STGTAB_DIRECTIVE Function
  • SET_PREFS Procedure
  • UNPACK_STGTAB_DIRECTIVE Function

151 DBMS_SPM

• DBMS_SPM Overview
• DBMS_SPM Security Model
• DBMS_SPM Constants
• DBMS_SPM Examples
• DBMS_SPM Data Structures
  • DBMS_SPM NAMELIST Table Type
• Summary of DBMS_SPM Subprograms
  • ACCEPT_SQL_PLAN_BASELINE Procedure
  • ALTER_SQL_PLAN_BASELINE Function
  • CANCEL_EVOLVE_TASK Procedure
  • CONFIGURE Procedure
  • CREATE_EVOLVE_TASK Function
  • CREATE_STGTAB_BASELINE Procedure
  • DROP_EVOLVE_TASK Procedure
  • DROP_SQL_PLAN_BASELINE Function
  • EVOLVE_SQL_PLAN_BASELINE Function
  • EXECUTE_EVOLVE_TASK Function
  • IMPLEMENT_EVOLVE_TASK Function
  • INTERRUPT_EVOLVE_TASK Procedure
  • LOAD_PLANS_FROM_AWR Function
  • LOAD_PLANS_FROM_CURSOR_CACHE Functions
  • LOAD_PLANS_FROM_SQLSET Function
  • MIGRATE_STORED_OUTLINE Functions
  • PACK_STGTAB_BASELINE Function
  • RESET_EVOLVE_TASK Procedure
  • RESUME_EVOLVE_TASK Procedure
  • REPORT_AUTO_EVOLVE_TASK Function
  • REPORT_EVOLVE_TASK Function
  • SET_EVOLVE_TASK_PARAMETER Procedure
  • UNPACK_STGTAB_BASELINE Function

152 DBMS_SQL

• DBMS_SQL Overview
• DBMS_SQL Security Model
• DBMS_SQL Constants
• DBMS_SQL Operational Notes
• DBMS_SQL Execution Flow
  • OPEN_CURSOR
  • PARSE
  • BIND_VARIABLE, BIND_VARIABLE_PKG or BIND_ARRAY
  • DEFINE_COLUMN, DEFINE_COLUMN_LONG, or DEFINE_ARRAY
  • EXECUTE
  • FETCH_ROWS or EXECUTE_AND_FETCH
  • VARIABLE_VALUE, VARIABLE_VALUE_PKG, COLUMN_VALUE, or COLUMN_VALUE_LONG
  • CLOSE_CURSOR
• DBMS_SQL Exceptions
• DBMS_SQL Examples
• DBMS_SQL Data Structures
  • DBMS_SQL DESC_REC Record Type
  • DBMS_SQL DESC_REC2 Record Type
  • DBMS_SQL DESC_REC3 Record Type
  • DBMS_SQL DESC_REC4 Record Type
  • DBMS_SQL BFILE_TABLE Table Type
  • DBMS_SQL BINARY_DOUBLE_TABLE Table Type
  • DBMS_SQL BINARY_FLOAT_TABLE Table Type
  • DBMS_SQL BLOB_TABLE Table Type
  • DBMS_SQL CLOB_TABLE Table Type
  • DBMS_SQL DATE_TABLE Table Type
  • DBMS_SQL DESC_TAB Table Type
  • DBMS_SQL DESC_TAB2 Table Type
  • DBMS_SQL DESC_TAB3 Table Type
  • DBMS_SQL DESC_TAB4 Table Type
  • DBMS_SQL INTERVAL_DAY_TO_SECOND_TABLE Table Type
  • DBMS_SQL INTERVAL_YEAR_TO_MONTH_TABLE Table Type
  • DBMS_SQL NUMBER_TABLE Table Type
  • DBMS_SQL TIME_TABLE Table Type
  • DBMS_SQL TIME_WITH_TIME_ZONE_TABLE Table Type
  • DBMS_SQL TIMESTAMP_TABLE Table Type
  • DBMS_SQL TIMESTAMP_WITH_LTZ_TABLE Table Type
  • DBMS_SQL TIMESTAMP_WITH_TIME_ZONE_TABLE Table Type
  • DBMS_SQL UROWID_TABLE Table Type
  • DBMS_SQL VARCHAR2_TABLE Table Type
  • DBMS_SQL VARCHAR2A Table Type
  • DBMS_SQL VARCHAR2S Table Type
• Summary of DBMS_SQL Subprograms
  • BIND_ARRAY Procedures
  • BIND_VARIABLE Procedures
  • BIND_VARIABLE_PKG Procedure
  • CLOSE_CURSOR Procedure
  • COLUMN_VALUE Procedure
  • COLUMN_VALUE_LONG Procedure
  • DEFINE_ARRAY Procedure
  • DEFINE_COLUMN Procedures
  • DEFINE_COLUMN_CHAR Procedure
  • DEFINE_COLUMN_LONG Procedure
  • DEFINE_COLUMN_RAW Procedure
  • DEFINE_COLUMN_ROWID Procedure
  • DESCRIBE_COLUMNS Procedure
  • DESCRIBE_COLUMNS2 Procedure
  • DESCRIBE_COLUMNS3 Procedure
  • EXECUTE Function
  • EXECUTE_AND_FETCH Function
  • FETCH_ROWS Function
  • GET_NEXT_RESULT Procedures
  • IS_OPEN Function
  • LAST_ERROR_POSITION Function
  • LAST_ROW_COUNT Function
  • LAST_ROW_ID Function
  • LAST_SQL_FUNCTION_CODE Function
  • OPEN_CURSOR Functions
  • PARSE Procedures
  • RETURN_RESULT Procedures
  • TO_CURSOR_NUMBER Function
  • TO_REFCURSOR Function
  • VARIABLE_VALUE Procedures
  • VARIABLE_VALUE_PKG Procedure

153 DBMS_SQL_MONITOR

• DBMS_SQL_MONITOR Overview
• DBMS_SQL_MONITOR Security Model
• DBMS_SQL_MONITOR Constants
• Summary of DBMS_SQL_MONITOR Subprograms
  • BEGIN_OPERATION Function
  • END_OPERATION Procedure
  • REPORT_SQL_MONITOR Function
  • REPORT_SQL_MONITOR_XML Function
  • REPORT_SQL_MONITOR_LIST Function
  • REPORT_SQL_MONITOR_LIST_XML Function

154 DBMS_SQL_TRANSLATOR

• DBMS_SQL_TRANSLATOR Security Model
• DBMS_SQL_TRANSLATOR Constants
• DBMS_SQL_TRANSLATOR Operational Notes
• DBMS_SQL_TRANSLATOR Exceptions
• DBMS_SQL_TRANSLATOR Examples
• Summary of DBMS_SQL_TRANSLATOR Subprograms
  • CREATE_PROFILE Procedure
  • DEREGISTER_SQL_TRANSLATION Procedure
  • DEREGISTER_ERROR_TRANSLATION Procedure
  • DROP_PROFILE Procedure
  • ENABLE_ERROR_TRANSLATION Procedure
  • ENABLE_SQL_TRANSLATION Procedure
  • EXPORT_PROFILE Procedure
  • IMPORT_PROFILE Procedure
  • REGISTER_ERROR_TRANSLATION Procedure
  • REGISTER_SQL_TRANSLATION Procedure
  • SET_ATTRIBUTE Procedure
  • SQL_HASH Function
  • SQL_ID Function
  • TRANSLATE_ERROR Procedure
  • TRANSLATE_SQL Procedure

155 DBMS_SQLDIAG

• DBMS_SQLDIAG Overview
• DBMS_SQLDIAG Security Model
• DBMS_SQLDIAG Constants
• DBMS_SQLDIAG Examples
• Summary of DBMS_SQLDIAG Subprograms
  • ACCEPT_SQL_PATCH Function & Procedure
  • ALTER_SQL_PATCH Procedure
  • CANCEL_DIAGNOSIS_TASK Procedure
  • CREATE_DIAGNOSIS_TASK Functions
  • CREATE_SQL_PATCH Function
  • CREATE_STGTAB_SQLPATCH Procedure
  • DROP_DIAGNOSIS_TASK Procedure
  • DROP_SQL_PATCH Procedure
  • EXECUTE_DIAGNOSIS_TASK Procedure
  • EXPLAIN_SQL_TESTCASE Function
  • EXPORT_SQL_TESTCASE Procedures
  • EXPORT_SQL_TESTCASE_DIR_BY_INC Function
  • EXPORT_SQL_TESTCASE_DIR_BY_TXT Function
  • GET_FIX_CONTROL Function
  • GET_SQL Function
  • IMPORT_SQL_TESTCASE Procedures
  • INCIDENTID_2_SQL Procedure
  • INTERRUPT_DIAGNOSIS_TASK Procedure
  • LOAD_SQLSET_FROM_TCB Function
  • PACK_STGTAB_SQLPATCH Procedure
  • REPLAY_SQL_TESTCASE Function
  • REPORT_DIAGNOSIS_TASK Function
  • RESET_DIAGNOSIS_TASK Procedure
  • RESUME_DIAGNOSIS_TASK Procedure
  • SET_DIAGNOSIS_TASK_PARAMETER Procedure
  • UNPACK_STGTAB_SQLPATCH Procedure

156 DBMS_SQLPA

• DBMS_SQLPA Overview
• DBMS_SQLPA Security Model
• Summary of DBMS_SQLPA Subprograms
  • CANCEL_ANALYSIS_TASK Procedure
  • CREATE_ANALYSIS_TASK Functions
  • DROP_ANALYSIS_TASK Procedure
  • EXECUTE_ANALYSIS_TASK Function & Procedure
  • INTERRUPT_ANALYSIS_TASK Procedure
  • REPORT_ANALYSIS_TASK Function
  • RESET_ANALYSIS_TASK Procedure
  • RESUME_ANALYSIS_TASK Procedure
  • SET_ANALYSIS_TASK_PARAMETER Procedures
  • SET_ANALYSIS_DEFAULT_PARAMETER Procedures

157 DBMS_SQLTUNE

• DBMS_SQLTUNE Overview
• DBMS_SQLTUNE Security Model
• DBMS_SQLTUNE Data Structures
  • SQLSET_ROW Object Type
• DBMS_SQLTUNE Subprogram Groups
  • DBMS_SQLTUNE SQL Tuning Advisor Subprograms
  • DBMS_SQLTUNE SQL Profile Subprograms
  • DBMS_SQLTUNE SQL Tuning Set Subprograms
  • DBMS_SQLTUNE Real-Time SQL Monitoring Subprograms
  • DBMS_SQLTUNE SQL Performance Reporting Subprograms
• Summary of DBMS_SQLTUNE Subprograms
  • ACCEPT_ALL_SQL_PROFILES Procedure
  • ACCEPT_SQL_PROFILE Procedure and Function
  • ADD_SQLSET_REFERENCE Function
  • ALTER_SQL_PROFILE Procedure
  • CANCEL_TUNING_TASK Procedure
  • CAPTURE_CURSOR_CACHE_SQLSET Procedure
  • CREATE_SQL_PLAN_BASELINE Procedure
  • CREATE_SQLSET Procedure and Function
  • CREATE_STGTAB_SQLPROF Procedure
  • CREATE_STGTAB_SQLSET Procedure
  • CREATE_TUNING_TASK Functions
  • DELETE_SQLSET Procedure
  • DROP_SQL_PROFILE Procedure
  • DROP_SQLSET Procedure
  • DROP_TUNING_TASK Procedure
  • EXECUTE_TUNING_TASK Function and Procedure
  • IMPLEMENT_TUNING_TASK Procedure
  • INTERRUPT_TUNING_TASK Procedure
  • LOAD_SQLSET Procedure
  • PACK_STGTAB_SQLPROF Procedure
  • PACK_STGTAB_SQLSET Procedure
  • REMAP_STGTAB_SQLPROF Procedure
  • REMAP_STGTAB_SQLSET Procedure
  • REMOVE_SQLSET_REFERENCE Procedure
  • REPORT_AUTO_TUNING_TASK Function
  • REPORT_SQL_DETAIL Function
  • REPORT_SQL_MONITOR Function
  • REPORT_SQL_MONITOR_LIST Function
  • REPORT_SQL_MONITOR_LIST_XML Function
  • REPORT_TUNING_TASK Function
  • REPORT_TUNING_TASK_XML Function
  • RESET_TUNING_TASK Procedure
  • RESUME_TUNING_TASK Procedure
  • SCHEDULE_TUNING_TASK Function
  • SCRIPT_TUNING_TASK Function
  • SELECT_CURSOR_CACHE Function
  • SELECT_SQL_TRACE Function
  • SELECT_SQLPA_TASK Function
  • SELECT_SQLSET Function
  • SELECT_WORKLOAD_REPOSITORY Function
  • SET_TUNING_TASK_PARAMETER Procedures
  • SQLTEXT_TO_SIGNATURE Function
  • UNPACK_STGTAB_SQLPROF Procedure
  • UNPACK_STGTAB_SQLSET Procedure
  • UPDATE_SQLSET Procedures

158 DBMS_STAT_FUNCS

• Summary of DBMS_STAT_FUNCS Subprograms
  • EXPONENTIAL_DIST_FIT Procedure
  • NORMAL_DIST_FIT Procedure
  • POISSON_DIST_FIT Procedure
  • SUMMARY Procedure
  • UNIFORM_DIST_FIT Procedure
  • WEIBULL_DIST_FIT Procedure

159 DBMS_STATS

• DBMS_STATS Overview
• DBMS_STATS Deprecated Subprograms
• DBMS_STATS Types
• DBMS_STATS Constants
• DBMS_STATS Operational Notes
• DBMS_STATS Data Structures
  • DBMS_STATS STAT_REC Record Type
• Summary of DBMS_STATS Subprograms
  • ALTER_STATS_HISTORY_RETENTION Procedure
  • CANCEL_ADVISOR_TASK Procedure
  • CONFIGURE_ADVISOR_FILTER Function
  • CONFIGURE_ADVISOR_OBJ_FILTER Function
  • CONFIGURE_ADVISOR_OPR_FILTER Functions
  • CONFIGURE_ADVISOR_RULE_FILTER Function
  • CONVERT_RAW_VALUE Procedures
  • CONVERT_RAW_VALUE_NVARCHAR Procedure
  • CONVERT_RAW_VALUE_ROWID Procedure
  • COPY_TABLE_STATS Procedure
  • CREATE_ADVISOR_TASK Function
  • CREATE_EXTENDED_STATS Function
  • CREATE_STAT_TABLE Procedure
  • DELETE_COLUMN_STATS Procedure
  • DELETE_DATABASE_PREFS Procedure
  • DELETE_DATABASE_STATS Procedure
  • DELETE_DICTIONARY_STATS Procedure
  • DELETE_FIXED_OBJECTS_STATS Procedure
  • DELETE_INDEX_STATS Procedure
  • DELETE_PENDING_STATS Procedure
  • DELETE_PROCESSING_RATE Procedure
  • DELETE_SCHEMA_PREFS Procedure
  • DELETE_SCHEMA_STATS Procedure
  • DELETE_SYSTEM_STATS Procedure
  • DELETE_TABLE_PREFS Procedure
  • DELETE_TABLE_STATS Procedure
  • DIFF_TABLE_STATS_IN_HISTORY Function
  • DIFF_TABLE_STATS_IN_PENDING Function
  • DIFF_TABLE_STATS_IN_STATTAB Function
  • DROP_ADVISOR_TASK Procedure
  • DROP_EXTENDED_STATS Procedure
  • DROP_STAT_TABLE Procedure
  • EXECUTE_ADVISOR_TASK Function
  • EXPORT_COLUMN_STATS Procedure
  • EXPORT_DATABASE_PREFS Procedure
  • EXPORT_DATABASE_STATS Procedure
  • EXPORT_DICTIONARY_STATS Procedure
  • EXPORT_FIXED_OBJECTS_STATS Procedure
  • EXPORT_INDEX_STATS Procedure
  • EXPORT_PENDING_STATS Procedure
  • EXPORT_SCHEMA_PREFS Procedure
  • EXPORT_SCHEMA_STATS Procedure
  • EXPORT_SYSTEM_STATS Procedure
  • EXPORT_TABLE_PREFS Procedure
  • EXPORT_TABLE_STATS Procedure
  • FLUSH_DATABASE_MONITORING_INFO Procedure
  • GATHER_DATABASE_STATS Procedures
  • GATHER_DICTIONARY_STATS Procedure
  • GATHER_FIXED_OBJECTS_STATS Procedure
  • GATHER_INDEX_STATS Procedure
  • GATHER_PROCESSING_RATE Procedure
  • GATHER_SCHEMA_STATS Procedures
  • GATHER_SYSTEM_STATS Procedure
  • GATHER_TABLE_STATS Procedure
  • GENERATE_STATS Procedure
  • GET_ADVISOR_OPR_FILTER Procedure
  • GET_ADVISOR_RECS Function
  • GET_COLUMN_STATS Procedures
  • GET_INDEX_STATS Procedures
  • GET_PARAM Function
  • GET_PREFS Function
  • GET_STATS_HISTORY_AVAILABILITY Function
  • GET_STATS_HISTORY_RETENTION Function
  • GET_SYSTEM_STATS Procedure
  • GET_TABLE_STATS Procedure
  • IMPLEMENT_ADVISOR_TASK Function
  • IMPORT_COLUMN_STATS Procedure
  • IMPORT_DATABASE_PREFS Procedure
  • IMPORT_DATABASE_STATS Procedure
  • IMPORT_DICTIONARY_STATS Procedure
  • IMPORT_FIXED_OBJECTS_STATS Procedure
  • IMPORT_INDEX_STATS Procedure
  • IMPORT_SCHEMA_PREFS Procedure
  • IMPORT_SCHEMA_STATS Procedure
  • IMPORT_SYSTEM_STATS Procedure
  • IMPORT_TABLE_PREFS Procedure
  • IMPORT_TABLE_STATS Procedure
  • INTERRUPT_ADVISOR_TASK Procedure
  • LOCK_PARTITION_STATS Procedure
  • LOCK_SCHEMA_STATS Procedure
  • LOCK_TABLE_STATS Procedure
  • MERGE_COL_USAGE Procedure
  • PREPARE_COLUMN_VALUES Procedures
  • PREPARE_COLUMN_VALUES_NVARCHAR Procedure
  • PREPARE_COLUMN_VALUES_ROWID Procedure
  • PUBLISH_PENDING_STATS Procedure
  • PURGE_STATS Procedure
  • REMAP_STAT_TABLE Procedure
  • REPORT_ADVISOR_TASK Function
  • REPORT_COL_USAGE Function
  • REPORT_GATHER_AUTO_STATS Function
  • REPORT_GATHER_DATABASE_STATS Functions
  • REPORT_GATHER_DICTIONARY_STATS Functions
  • REPORT_GATHER_FIXED_OBJ_STATS Function
  • REPORT_GATHER_SCHEMA_STATS Functions
  • REPORT_GATHER_TABLE_STATS Function
  • REPORT_SINGLE_STATS_OPERATION Function
  • REPORT_STATS_OPERATIONS Function
  • RESET_ADVISOR_TASK Procedure
  • RESET_COL_USAGE Procedure
  • RESET_GLOBAL_PREF_DEFAULTS Procedure
  • RESET_PARAM_DEFAULTS Procedure
  • RESTORE_DATABASE_STATS Procedure
  • RESTORE_DICTIONARY_STATS Procedure
  • RESTORE_FIXED_OBJECTS_STATS Procedure
  • RESTORE_SCHEMA_STATS Procedure
  • RESTORE_SYSTEM_STATS Procedure
  • RESTORE_TABLE_STATS Procedure
  • RESUME_ADVISOR_TASK Procedure
  • SCRIPT_ADVISOR_TASK Function
  • SEED_COL_USAGE Procedure
  • SET_ADVISOR_TASK_PARAMETER Procedure
  • SET_COLUMN_STATS Procedures
  • SET_DATABASE_PREFS Procedure
  • SET_GLOBAL_PREFS Procedure
  • SET_INDEX_STATS Procedures
  • SET_PARAM Procedure
  • SET_PROCESSING_RATE Procedure
  • SET_SCHEMA_PREFS Procedure
  • SET_SYSTEM_STATS Procedure
  • SET_TABLE_PREFS Procedure
  • SET_TABLE_STATS Procedure
  • SHOW_EXTENDED_STATS_NAME Function
  • TRANSFER_STATS Procedure
  • UNLOCK_PARTITION_STATS Procedure
  • UNLOCK_SCHEMA_STATS Procedure
  • UNLOCK_TABLE_STATS Procedure
  • UPGRADE_STAT_TABLE Procedure

160 DBMS_STORAGE_MAP

• DBMS_STORAGE_MAP Overview
• DBMS_STORAGE_MAP Operational Notes
• Summary of DBMS_STORAGE_MAP Subprograms
  • DROP_ALL Function
  • DROP_ELEMENT Function
  • DROP_FILE Function
  • LOCK_MAP Procedure
  • MAP_ALL Function
  • MAP_ELEMENT Function
  • MAP_FILE Function
  • MAP_OBJECT Function
  • RESTORE Function
  • SAVE Function
  • UNLOCK_MAP Procedure

161 DBMS_STREAMS

• DBMS_STREAMS Overview
• DBMS_STREAMS Security Model
• Summary of DBMS_STREAMS Subprograms
  • COMPATIBLE_12_2 Function
  • COMPATIBLE_12_1 Function
  • COMPATIBLE_11_2 Function
  • COMPATIBLE_11_1 Function
  • COMPATIBLE_10_2 Function
  • COMPATIBLE_10_1 Function
  • COMPATIBLE_9_2 Function
  • CONVERT_ANYDATA_TO_LCR_DDL Function
  • CONVERT_ANYDATA_TO_LCR_ROW Function
  • CONVERT_LCR_TO_XML Function
  • CONVERT_XML_TO_LCR Function
  • GET_INFORMATION Function
  • GET_STREAMS_NAME Function
  • GET_STREAMS_TYPE Function
  • GET_TAG Function
  • MAX_COMPATIBLE Function
  • SET_TAG Procedure

162 DBMS_STREAMS_ADM

• DBMS_STREAMS_ADM Overview
• DBMS_STREAMS_ADM Deprecated Subprograms
• DBMS_STREAMS_ADM Security Model
• Procedures That Create Rules for Oracle Streams Clients and XStream Clients
• Procedures That Configure an Oracle Streams Environment
• Summary of DBMS_STREAMS_ADM Subprograms
  • ADD_COLUMN Procedure
  • ADD_GLOBAL_PROPAGATION_RULES Procedure
  • ADD_GLOBAL_RULES Procedure
  • ADD_MESSAGE_PROPAGATION_RULE Procedure
  • ADD_MESSAGE_RULE Procedure
  • ADD_SCHEMA_PROPAGATION_RULES Procedure
  • ADD_SCHEMA_RULES Procedure
  • ADD_SUBSET_PROPAGATION_RULES Procedure
  • ADD_SUBSET_RULES Procedure
  • ADD_TABLE_PROPAGATION_RULES Procedure
  • ADD_TABLE_RULES Procedure
  • CLEANUP_INSTANTIATION_SETUP Procedure
  • DELETE_COLUMN Procedure
  • GET_MESSAGE_TRACKING Function
  • GET_SCN_MAPPING Procedure
  • GET_TAG Function
  • KEEP_COLUMNS Procedure
  • MAINTAIN_CHANGE_TABLE Procedure
  • MAINTAIN_GLOBAL Procedure
  • MAINTAIN_SCHEMAS Procedure
  • MAINTAIN_SIMPLE_TABLESPACE Procedure
  • MAINTAIN_SIMPLE_TTS Procedure
  • MAINTAIN_TABLES Procedure
  • MAINTAIN_TABLESPACES Procedure
  • MAINTAIN_TTS Procedure
  • MERGE_STREAMS Procedure
  • MERGE_STREAMS_JOB Procedure
  • POST_INSTANTIATION_SETUP Procedure
  • PRE_INSTANTIATION_SETUP Procedure
  • PURGE_SOURCE_CATALOG Procedure
  • RECOVER_OPERATION Procedure
  • REMOVE_QUEUE Procedure
  • REMOVE_RULE Procedure
  • REMOVE_STREAMS_CONFIGURATION Procedure
  • RENAME_COLUMN Procedure
  • RENAME_SCHEMA Procedure
  • RENAME_TABLE Procedure
  • SET_MESSAGE_NOTIFICATION Procedure
  • SET_MESSAGE_TRACKING Procedure
  • SET_RULE_TRANSFORM_FUNCTION Procedure
  • SET_TAG Procedure
  • SET_UP_QUEUE Procedure
  • SPLIT_STREAMS Procedure

163 DBMS_STREAMS_ADVISOR_ADM

• DBMS_STREAMS_ADVISOR_ADM Overview
• DBMS_STREAMS_ADVISOR_ADM Security Model
• DBMS_STREAMS_ADVISOR_ADM Constants
• DBMS_STREAMS_ADVISOR_ADM Views
• DBMS_STREAMS_ADVISOR_ADM Operational Notes
• Summary of DBMS_STREAMS_ADVISOR_ADM Subprograms
  • ANALYZE_CURRENT_PERFORMANCE Procedure

164 DBMS_STREAMS_AUTH

• DBMS_STREAMS_AUTH Overview
• DBMS_STREAMS_AUTH Security Model
• Summary of DBMS_STREAMS_AUTH Subprograms
  • GRANT_ADMIN_PRIVILEGE Procedure
  • GRANT_REMOTE_ADMIN_ACCESS Procedure
  • REVOKE_ADMIN_PRIVILEGE Procedure
  • REVOKE_REMOTE_ADMIN_ACCESS Procedure

165 DBMS_STREAMS_HANDLER_ADM

• DBMS_STREAMS_HANDLER_ADM Overview
• DBMS_STREAMS_HANDLER_ADM Security Model
• DBMS_STREAMS_HANDLER_ADM Views
• DBMS_STREAMS_HANDLER_ADM Operational Notes
• Summary of DBMS_STREAMS_HANDLER_ADM Subprograms
  • ADD_STMT_TO_HANDLER Procedure
  • CREATE_STMT_HANDLER Procedure
  • DROP_STMT_HANDLER Procedure
  • REMOVE_STMT_FROM_HANDLER Procedure

166 DBMS_STREAMS_MESSAGING

• DBMS_STREAMS_MESSAGING Overview
• DBMS_STREAMS_MESSAGING Security Model
• Summary of DBMS_STREAMS_MESSAGING Subprograms
  • DEQUEUE Procedure
  • ENQUEUE Procedure

167 DBMS_STREAMS_TABLESPACE_ADM

• DBMS_STREAMS_TABLESPACE_ADM Overview
• DBMS_STREAMS_TABLESPACE_ADM Security Model
• DBMS_STREAMS_TABLESPACE_ADM Data Structures
  • DIRECTORY_OBJECT_SET Table Type
  • FILE Record Type
  • FILE_SET Table Type
  • TABLESPACE_SET Table Type
• Summary of DBMS_STREAMS_TABLESPACE_ADM Subprograms
  • ATTACH_SIMPLE_TABLESPACE Procedure
  • ATTACH_TABLESPACES Procedure
  • CLONE_SIMPLE_TABLESPACE Procedure
  • CLONE_TABLESPACES Procedure
  • DETACH_SIMPLE_TABLESPACE Procedure
  • DETACH_TABLESPACES Procedure
  • PULL_SIMPLE_TABLESPACE Procedure
  • PULL_TABLESPACES Procedure

168 DBMS_SYNC_REFRESH

• DBMS_SYNC_REFRESH Overview
• DBMS_SYNC_REFRESH Security Model
• Summary of DBMS_SYNC_REFRESH Subprograms
  • ABORT_REFRESH Procedure
  • ALTER_REFRESH_STATS_RETENTION Procedure
  • CAN_SYNCREF_TABLE Procedure
  • EXECUTE_REFRESH Procedure
  • GET_ALL_GROUP_IDS Function
  • GET_GROUP_ID Function
  • GET_GROUP_ID_LIST Function
  • PREPARE_REFRESH Procedure
  • PREPARE_STAGING_LOG Procedure
  • PURGE_REFRESH_STATS Procedure
  • REGISTER_MVIEWS
  • REGISTER_PARTITION_OPERATION Procedure
  • UNREGISTER_MVIEWS
  • UNREGISTER_PARTITION_OPERATION Procedure

169 DBMS_TDB

• DBMS_TDB Overview
• DBMS_TDB Security Model
• DBMS_TDB Constants
• DBMS_TDB Views
• DBMS_TDB Operational Notes
• Summary of DBMS_TDB Subprograms
  • CHECK_DB Function
  • CHECK_EXTERNAL Function

170 DBMS_TNS

• DBMS_TNS Overview
• DBMS_TNS Security Model
• Summary of DBMS_TNS Subprograms
  • RESOLVE_TNSNAME Function

171 DBMS_TRACE

• DBMS_TRACE Overview
• DBMS_TRACE Security Model
• DBMS_TRACE Constants
• DBMS_TRACE Restrictions
• DBMS_TRACE Operational Notes
• Summary of DBMS_TRACE Subprograms
  • CLEAR_PLSQL_TRACE Procedure
  • GET_PLSQL_TRACE_LEVEL Function
  • PLSQL_TRACE_VERSION Procedure
  • SET_PLSQL_TRACE Procedure

172 DBMS_TRANSACTION

• DBMS_TRANSACTION Security Model
• Summary of DBMS_TRANSACTION Subprograms
  • ADVISE_COMMIT Procedure
  • ADVISE_NOTHING Procedure
  • ADVISE_ROLLBACK Procedure
  • COMMIT Procedure
  • COMMIT_COMMENT Procedure
  • COMMIT_FORCE Procedure
  • LOCAL_TRANSACTION_ID Function
  • PURGE_LOST_DB_ENTRY Procedure
  • PURGE_MIXED Procedure
  • READ_ONLY Procedure
  • READ_WRITE Procedure
  • ROLLBACK Procedure
  • ROLLBACK_FORCE Procedure
  • ROLLBACK_SAVEPOINT Procedure
  • SAVEPOINT Procedure
  • STEP_ID Function
  • USE_ROLLBACK_SEGMENT Procedure

173 DBMS_TRANSFORM

• Summary of DBMS_TRANSFORM Subprograms
  • CREATE_TRANSFORMATION Procedure
  • DROP_TRANSFORMATION Procedure
  • MODIFY_TRANSFORMATION Procedure

174 DBMS_TSDP_MANAGE

• DBMS_TSDP_MANAGE Overview
• DBMS_TSDP_MANAGE Security Model
• Summary of DBMS_TSDP_MANAGE Subprograms
  • ADD_SENSITIVE_COLUMN Procedure
  • ALTER_SENSITIVE_COLUMN Procedure
  • ADD_SENSITIVE_TYPE Procedure
  • DROP_SENSITIVE_COLUMN Procedure
  • DROP_SENSITIVE_TYPE Procedure
  • DROP_SENSITIVE_TYPE_SOURCE Procedure
  • IMPORT_DISCOVERY_RESULT Procedure
  • IMPORT_SENSITIVE_TYPES Procedure
  • REMOVE_DISCOVERY_RESULT Procedure

175 DBMS_TSDP_PROTECT

• DBMS_TSDP_PROTECT Overview
• DBMS_TSDP_PROTECT Security Model
• DBMS_TSDP_PROTECT Constants
• DBMS_TSDP_PROTECT Data Structures
  • FEATURE_OPTIONS Table Type
  • POLICY_CONDITIONS Table Type
• Summary of DBMS_TSDP_PROTECT Subprograms
  • ADD_POLICY Procedure
  • ALTER_POLICY Procedure
  • ASSOCIATE_POLICY Procedure
  • DISABLE_PROTECTION_COLUMN Procedure
  • DISABLE_PROTECTION_SOURCE Procedure
  • DISABLE_PROTECTION_TYPE Procedure
  • DROP_POLICY Procedure
  • ENABLE_PROTECTION_COLUMN Procedure
  • ENABLE_PROTECTION_SOURCE Procedure
  • ENABLE_PROTECTION_TYPE Procedure

176 DBMS_TTS

• DBMS_TTS Security Model
• DBMS_TTS Exceptions
• DBMS_TTS Operational Notes
• Summary of DBMS_TTS Subprograms
  • DOWNGRADE Procedure
  • TRANSPORT_SET_CHECK Procedure

177 DBMS_TYPES

• DBMS_TYPES Constants
• DBMS_TYPES Exceptions

178 DBMS_UMF

• Summary of DBMS_UMF Subprograms
  • CONFIGURE_NODE Procedure
  • CREATE_LINK Procedure
  • CREATE_TOPOLOGY Procedure
  • DROP_LINK Procedure
  • DROP_TOPOLOGY Procedure
  • ENABLE_SERVICE Procedure
  • GET_NODE_ID_LOCAL Function
  • GET_NODE_NAME_LOCAL Function
  • GET_TARGET_ID Function
  • GET_TOPOLOGY_NAME_LOCAL Function
  • QUERY_LINK_INFO Procedure
  • QUERY_NODE_INFO Procedures
  • REGISTER_NODE Function and Procedure
  • SWITCH_DESTINATION Procedure
  • UNCONFIGURE_NODE Procedure
  • UNREGISTER_NODE Procedure

179 DBMS_UTILITY

• DBMS_UTILITY Deprecated Subprograms
• DBMS_UTILITY Security Model
• DBMS_UTILITY Constants
• DBMS_UTILITY Exceptions
• DBMS_UTILITY Data Structures
  • DBMS_UTILITY INSTANCE_RECORD Record Type
  • DBMS_UTILITY DBLINK_ARRAY TABLE Type
  • DBMS_UTILITY INDEX_TABLE_TYPE Table Type
  • DBMS_UTILITY INSTANCE_TABLE Table Type
  • DBMS_UTILITY LNAME_ARRAY Table Type
  • DBMS_UTILITY NAME_ARRAY Table Type
  • DBMS_UTILITY NUMBER_ARRAY Table Type
  • DBMS_UTILITY UNCL_ARRAY Table Type
• Summary of DBMS_UTILITY Subprograms
  • ACTIVE_INSTANCES Procedure
  • ANALYZE_DATABASE Procedure
  • ANALYZE_PART_OBJECT Procedure
  • ANALYZE_SCHEMA Procedure
  • CANONICALIZE Procedure
  • COMMA_TO_TABLE Procedures
  • COMPILE_SCHEMA Procedure
  • CREATE_ALTER_TYPE_ERROR_TABLE Procedure
  • CURRENT_INSTANCE Function
  • DATA_BLOCK_ADDRESS_BLOCK Function
  • DATA_BLOCK_ADDRESS_FILE Function
  • DB_VERSION Procedure
  • EXEC_DDL_STATEMENT Procedure
  • EXPAND_SQL_TEXT Procedure
  • FORMAT_CALL_STACK Function
  • FORMAT_ERROR_BACKTRACE Function
  • FORMAT_ERROR_STACK Function
  • GET_CPU_TIME Function
  • GET_DEPENDENCY Procedure
  • GET_ENDIANNESS Function
  • GET_HASH_VALUE Function
  • GET_PARAMETER_VALUE Function
  • GET_SQL_HASH Function
  • GET_TIME Function
  • GET_TZ_TRANSITIONS Procedure
  • INVALIDATE Procedure
  • IS_BIT_SET Function
  • IS_CLUSTER_DATABASE Function
  • MAKE_DATA_BLOCK_ADDRESS Function
  • NAME_RESOLVE Procedure
  • NAME_TOKENIZE Procedure
  • OLD_CURRENT_SCHEMA Function
  • OLD_CURRENT_USER Function
  • PORT_STRING Function
  • SQLID_TO_SQLHASH Function
  • TABLE_TO_COMMA Procedures
  • VALIDATE Procedure
  • WAIT_ON_PENDING_DML Function

180 DBMS_WARNING

• DBMS_WARNING Security Model
• Summary of DBMS_WARNING Subprograms
  • ADD_WARNING_SETTING_CAT Procedure
  • ADD_WARNING_SETTING_NUM Procedure
  • GET_CATEGORY Function
  • GET_WARNING_SETTING_CAT Function
  • GET_WARNING_SETTING_NUM Function
  • GET_WARNING_SETTING_STRING Function
  • SET_WARNING_SETTING_STRING Procedure

181 DBMS_WM

182 DBMS_WORKLOAD_CAPTURE

• DBMS_WORKLOAD_CAPTURE Overview
• DBMS_WORKLOAD_CAPTURE Security Model
• Summary of DBMS_WORKLOAD_CAPTURE Subprograms
  • ADD_FILTER Procedures
  • DELETE_CAPTURE_INFO Procedure
  • DELETE_FILTER Procedure
  • EXPORT_AWR Procedure
  • FINISH_CAPTURE Procedure
  • GET_CAPTURE_INFO Function
  • IMPORT_AWR Function
  • REPORT Function
  • START_CAPTURE Procedure

183 DBMS_WORKLOAD_REPLAY

• DBMS_WORKLOAD_REPLAY Overview
• DBMS_WORKLOAD_REPLAY Security Model
• Summary of DBMS_WORKLOAD_REPLAY Subprograms
  • ADD_CAPTURE Function
  • ADD_FILTER Procedure
  • ADD_SCHEDULE_ORDERING Function
  • ASSIGN_GROUP_TO_INSTANCE Procedure
  • BEGIN_REPLAY_SCHEDULE Procedure
  • CALIBRATE Function
  • CANCEL_REPLAY Procedure
  • COMPARE_PERIOD_REPORT Procedure
  • COMPARE_SQLSET_REPORT Function
  • CREATE_FILTER_SET Procedure
  • DELETE_FILTER Procedure
  • DELETE_REPLAY_INFO Procedure
  • END_REPLAY_SCHEDULE Procedure
  • EXPORT_AWR Procedure
  • GENERATE_CAPTURE_SUBSET Procedure
  • GET_DIVERGING_STATEMENT Function
  • GET_REPLAY_DIRECTORY Function
  • GET_REPLAY_INFO Function
  • GET_REPLAY_TIMEOUT Procedure
  • IMPORT_AWR Function
  • INITIALIZE_CONSOLIDATED_REPLAY Procedure
  • INITIALIZE_REPLAY Procedure
  • IS_REPLAY_PAUSED Function
  • PAUSE_REPLAY Procedure
  • POPULATE_DIVERGENCE Procedure
  • PREPARE_CONSOLIDATED_REPLAY Procedure
  • PREPARE_REPLAY Procedure
  • PROCESS_CAPTURE Procedure
  • REMAP_CONNECTION Procedure
  • REMOVE_CAPTURE Procedure
  • REMOVE_SCHEDULE_ORDERING Procedure
  • REPORT Function
  • RESUME_REPLAY Procedure
  • REUSE_REPLAY_FILTER_SET Procedure
  • SET_ADVANCED_PARAMETER Procedure
  • SET_REPLAY_DIRECTORY Procedure
  • SET_REPLAY_TIMEOUT Procedure
  • SET_SQL_MAPPING Procedure
  • SET_USER_MAPPING Procedure
  • START_CONSOLIDATED_REPLAY Procedure
  • START_REPLAY Procedure
  • USE_FILTER_SET Procedure

184 DBMS_WORKLOAD_REPOSITORY

• DBMS_WORKLOAD_REPOSITORY Examples
• DBMS_WORKLOAD_REPOSITORY Data Structures
  • DBMS_WORKLOAD_REPOSITORY AWR_BASELINE_METRIC_TYPE Object Type
  • DBMS_WORKLOAD_REPOSITORY AWR_BASELINE_METRIC_TYPE_TABLE Table Type
  • DBMS_WORKLOAD_REPOSITORY AWRRPT_INSTANCE_LIST_TYPE Table Type
• Summary of DBMS_WORKLOAD_REPOSITORY Subprograms
  • ADD_COLORED_SQL Procedure
  • ASH_GLOBAL_REPORT_HTML Function
  • ASH_GLOBAL_REPORT_TEXT Function
  • ASH_REPORT_ANALYTICS Function
  • ASH_REPORT_HTML Function
  • ASH_REPORT_TEXT Function
  • AWR_DIFF_REPORT_HTML Function
  • AWR_DIFF_REPORT_TEXT Function
  • AWR_GLOBAL_DIFF_REPORT_HTML Functions
  • AWR_GLOBAL_DIFF_REPORT_TEXT Functions
  • AWR_GLOBAL_REPORT_HTML Functions
  • AWR_GLOBAL_REPORT_TEXT Functions
  • AWR_REPORT_HTML Function
  • AWR_REPORT_TEXT Function
  • AWR_SET_REPORT_THRESHOLDS Procedure
  • AWR_SQL_REPORT_HTML Function
  • AWR_SQL_REPORT_TEXT Function
  • CONTROL_RESTRICTED_SNAPSHOT Procedure
  • CREATE_BASELINE Functions and Procedures
  • CREATE_BASELINE_TEMPLATE Procedures
  • CREATE_REMOTE_SNAPSHOT Function and Procedure
  • CREATE_SNAPSHOT Function and Procedure
  • DROP_BASELINE Procedure
  • DROP_BASELINE_TEMPLATE Procedure
  • DROP_SNAPSHOT_RANGE Procedure
  • LOCAL_AWR_DBID Function
  • MODIFY_BASELINE_WINDOW_SIZE Procedure
  • MODIFY_SNAPSHOT_SETTINGS Procedures
  • PURGE_SQL_DETAILS Procedure
  • REGISTER_REMOTE_DATABASE Procedures
  • REMOVE_COLORED_SQL Procedure
  • RENAME_BASELINE Procedure
  • SELECT_BASELINE_DETAILS Function
  • SELECT_BASELINE_METRIC Function
  • UNREGISTER_REMOTE_DATABASE Procedures
  • UPDATE_DATAFILE_INFO Procedure
  • UPDATE_OBJECT_INFO Procedure

185 DBMS_XA

• DBMS_XA Overview
• DBMS_XA Security Model
• DBMS_XA Constants
• DBMS_XA Operational Notes
• DBMS_XA Data Structures
  • DBMS_XA DBMS_XA_XID Object Type
  • DBMS_XA DBMS_XA_XID_ARRAY Table Type
• Summary of DBMS_XA Subprograms
  • DIST_TXN_SYNC Procedure
  • XA_COMMIT Function
  • XA_END Function
  • XA_FORGET Function
  • XA_GETLASTOER Function
  • XA_PREPARE Function
  • XA_RECOVER Function
  • XA_ROLLBACK Function
  • XA_SETTIMEOUT Function
  • XA_START Function

186 DBMS_XDB

• DBMS_XDB Overview
• DBMS_XDB Deprecated Subprograms
• DBMS_XDB Security Model
• DBMS_XDB Constants
• Summary of DBMS_XDB Subprograms
  • ACLCHECKPRIVILEGES Function
  • ADDHTTPEXPIREMAPPING Procedure
  • ADDMIMEMAPPING Procedure
  • ADDSCHEMALOCMAPPING Procedure
  • ADDSERVLET Procedure
  • ADDSERVLETMAPPING Procedure
  • ADDSERVLETSECROLE Procedure
  • ADDXMLEXTENSION Procedure
  • APPENDRESOURCEMETADATA Procedure
  • CFG_GET Function
  • CFG_REFRESH Procedure
  • CFG_UPDATE Procedure
  • CHANGEOWNER Procedure
  • CHANGEPRIVILEGES Function
  • CHECKPRIVILEGES Function
  • CREATEFOLDER Function
  • CREATEOIDPATH Function
  • CREATERESOURCE Functions
  • DELETEHTTPEXPIREMAPPING Procedure
  • DELETEMIMEMAPPING Procedure
  • DELETERESOURCE Procedure
  • DELETERESOURCEMETADATA Procedures
  • DELETESCHEMALOCMAPPING Procedure
  • DELETESERVLET Procedure
  • DELETESERVLETMAPPING Procedure
  • DELETESERVLETSECROLE Procedure
  • DELETEXMLEXTENSION Procedure
  • ENABLEDIGESTAUTHENTICATION Procedure
  • EXISTSRESOURCE Function
  • GETACLDOCUMENT Function
  • GETCONTENTBLOB Function
  • GETCONTENTCLOB Function
  • GETCONTENTVARCHAR2 Function
  • GETCONTENTXMLREF Function
  • GETCONTENTXMLTYPE Function
  • GETFTPPORT Function
  • GETHTTPPORT Function
  • GETHTTPREQUESTHEADER Function
  • GETLISTENERENDPOINT Procedure
  • GETLOCKTOKEN Procedure
  • GETPRIVILEGES Function
  • GETRESOID Function
  • GETXDB_TABLESPACE Function
  • HASBLOBCONTENT Function
  • HASCHARCONTENT Function
  • HASXMLCONTENT Function
  • HASXMLREFERENCE Function
  • ISFOLDER Function
  • LINK Procedures
  • LOCKRESOURCE Function
  • PROCESSLINKS Procedure
  • PURGERESOURCEMETADATA Procedure
  • RENAMERESOURCE Procedure
  • SETACL Procedure
  • SETFTPPORT Procedure
  • SETHTTPPORT Procedure
  • SETLISTENERENDPOINT Procedure
  • SETLISTENERLOCALACCESS Procedure
  • SPLITPATH Procedure
  • TOUCHRESOURCE Procedure
  • UNLOCKRESOURCE Function
  • UPDATERESOURCEMETADATA Procedures

187 DBMS_XDB_ADMIN

• DBMS_XDB_ADMIN Security Model
• Summary of DBMS_XDB_ADMIN Subprograms
  • CREATENONCEKEY Procedure
  • INSTALLDEFAULTWALLET Procedure
  • MOVEXDB_TABLESPACE Procedure
  • REBUILDHIERARCHICALINDEX Procedure

188 DBMS_XDB_CONFIG

• DBMS_XDB_CONFIG Overview
• DBMS_XDB_CONFIG Security Model
• DBMS_XDB_CONFIG Constants
• Summary of DBMS_XDB_CONFIG Subprograms
  • ADDHTTPEXPIREMAPPING Procedure
  • ADDMIMEMAPPING Procedure
  • ADDSCHEMALOCMAPPING Procedure
  • ADDSERVLET Procedure
  • ADDSERVLETMAPPING Procedure
  • ADDSERVLETSECROLE Procedure
  • ADDXMLEXTENSION Procedure
  • CFG_GET Function
  • CFG_REFRESH Procedure
  • CFG_UPDATE Procedure
  • DELETEHTTPEXPIREMAPPING Procedure
  • DELETEMIMEMAPPING Procedure
  • DELETESCHEMALOCMAPPING Procedure
  • DELETESERVLET Procedure
  • DELETESERVLETMAPPING Procedure
  • DELETESERVLETSECROLE Procedure
  • DELETEXMLEXTENSION Procedure
  • ENABLEDIGESTAUTHENTICATION Procedure
  • GETFTPPORT Function
  • GETHTTPCONFIGREALM Function
  • GETHTTPPORT Function
  • GETHTTPSPORT Function
  • GETLISTENERENDPOINT Procedure
  • GETREMOTEHTTPPORT Function
  • GETREMOTEHTTPSPORT Function
  • ISGLOBALPORTENABLED Function
  • SETFTPPORT Procedure
  • SETGLOBALPORTENABLED Procedure
  • SETHTTPPORT Procedure
  • SETHTTPCONFIGREALM Procedure
  • SETHTTPSPORT Procedure
  • SETLISTENERENDPOINT Procedure
  • SETLISTENERLOCALACCESS Procedure
  • SETREMOTEHTTPPORT Procedure
  • SETREMOTEHTTPSPORT Procedure
  • USEDPORT Function

189 DBMS_XDB_CONSTANTS

• DBMS_XDB_CONSTANTS Security Model
• Summary of DBMS_XDB_CONSTANTS Subprograms
  • ENCODING_DEFAULT Function
  • ENCODING_ISOLATIN1 Function
  • ENCODING_UTF8 Function
  • ENCODING_WIN1252 Function
  • NAMESPACE_ACL Function
  • NAMESPACE_METADATA Function
  • NAMESPACE_ORACLE Function
  • NAMESPACE_ORACLE_XDB Function
  • NAMESPACE_RESOURCE Function
  • NAMESPACE_RESOURCE_EVENT Function
  • NAMESPACE_RESOURCE_CONFIG Function
  • NAMESPACE_XDBSCHEMA Function
  • NAMESPACE_XMLDIFF Function
  • NAMESPACE_XMLINSTANCE Function
  • NAMESPACE_XMLSCHEMA Function
  • NSPREFIX_ACL_ACL Function
  • NSPREFIX_RESCONFIG_RC Function
  • NSPREFIX_RESOURCE_R Function
  • NSPREFIX_XDB_XDB Function
  • NSPREFIX_XMLINSTANCE_XSI Function
  • NSPREFIX_XMLDIFF_XD Function
  • NSPREFIX_XMLSCHEMA_XSD Function
  • SCHEMAURL_ACL Function
  • SCHEMAELEM_RES_ACL Function
  • SCHEMAELEM_RESCONTENT_BINARY Function
  • SCHEMAELEM_RESCONTENT_TEXT Function
  • SCHEMAURL_RESOURCE Function
  • SCHEMAURL_XDBSCHEMA Function
  • XDBSCHEMA_PREFIXES Function
  • XSD_ATTRIBUTE Function
  • XSD_COMPLEX_TYPE Function
  • XSD_ELEMENT Function
  • XSD_GROUP Function

190 DBMS_XDB_REPOS

• DBMS_XDB_REPOS Overview
• DBMS_XDB_REPOS Security Model
• DBMS_XDB_REPOS Constants
• Summary of DBMS_XDB_REPOS Subprograms
  • ACLCHECKPRIVILEGES Function
  • APPENDRESOURCEMETADATA Procedure
  • CHANGEOWNER Procedure
  • CHANGEPRIVILEGES Function
  • CHECKPRIVILEGES Function
  • CREATEFOLDER Function
  • CREATEOIDPATH Function
  • CREATERESOURCE Functions
  • DELETERESOURCE Procedure
  • DELETERESOURCEMETADATA Procedures
  • EXISTSRESOURCE Function
  • GETACLDOCUMENT Function
  • GETCONTENTBLOB Function
  • GETCONTENTCLOB Function
  • GETCONTENTVARCHAR2 Function
  • GETCONTENTXMLREF Function
  • GETCONTENTXMLTYPE Function
  • GETLOCKTOKEN Procedure
  • GETPRIVILEGES Function
  • GETRESOID Function
  • GETXDB_TABLESPACE Function
  • HASBLOBCONTENT Function
  • HASCHARCONTENT Function
  • HASXMLCONTENT Function
  • HASXMLREFERENCE Function
  • ISFOLDER Function
  • LINK Procedures
  • LOCKRESOURCE Function
  • PROCESSLINKS Procedure
  • PURGERESOURCEMETADATA Procedure
  • RENAMERESOURCE Procedure
  • SETACL Procedure
  • SPLITPATH Procedure
  • TOUCHRESOURCE Procedure
  • UNLOCKRESOURCE Function
  • UPDATERESOURCEMETADATA Procedures

191 DBMS_XDB_VERSION

• DBMS_XDB_VERSION Security Model
• Summary of DBMS_XDB_VERSION Subprograms
  • CHECKIN Function
  • CHECKOUT Procedure
  • GETCONTENTSBLOBBYRESID Function
  • GETCONTENTSCLOBBYRESID Function
  • GETCONTENTSXMLBYRESID Function
  • GETPREDECESSORS Function
  • GETPREDSBYRESID Function
  • GETRESOURCEBYRESID Function
  • GETSUCCESSORS Function
  • GETSUCCSBYRESID Function
  • MAKEVERSIONED Function
  • UNCHECKOUT Function

192 DBMS_XDBRESOURCE

• DBMS_XDBRESOURCE Overview
• DBMS_XDBRESOURCE Security Model
• Summary of DBMS_XDBRESOURCE Subprograms
  • FREERESOURCE Procedure
  • GETACL Function
  • GETACLDOCFROMRES Function
  • GETAUTHOR Function
  • GETCHARACTERSET Function
  • GETCOMMENT Function
  • GETCONTENTBLOB Function
  • GETCONTENTCLOB Function
  • GETCONTENTREF Function
  • GETCONTENTTYPE Function
  • GETCONTENTXML Function
  • GETCONTENTVARCHAR2 Function
  • GETCREATIONDATE Function
  • GETCREATOR Function
  • GETCUSTOMMETADATA Function
  • GETDISPLAYNAME Function
  • GETLANGUAGE Function
  • GETLASTMODIFIER Function
  • GETMODIFICATIONDATE Function
  • GETOWNER Function
  • GETREFCOUNT Function
  • GETVERSIONID Function
  • HASACLCHANGED Function
  • HASAUTHORCHANGED Function
  • HASCHANGED Function
  • HASCHARACTERSETCHANGED Function
  • HASCOMMENTCHANGED Function
  • HASCONTENTCHANGED Function
  • HASCONTENTTYPECHANGED Function
  • HASCREATIONDATECHANGED Function
  • HASCREATORCHANGED Function
  • HASCUSTOMMETADATACHANGED Function
  • HASDISPLAYNAMECHANGED Function
  • HASLANGUAGECHANGED Function
  • HASLASTMODIFIERCHANGED Function
  • HASMODIFICATIONDATECHANGED Function
  • HASOWNERCHANGED Function
  • HASREFCOUNTCHANGED Function
  • HASVERSIONIDCHANGED Function
  • ISFOLDER Function
  • ISNULL Function
  • MAKEDOCUMENT Function
  • SAVE Procedure
  • SETACL Procedure
  • SETAUTHOR Procedure
  • SETCHARACTERSET Procedure
  • SETCOMMENT Procedure
  • SETCONTENT Procedures
  • SETCONTENTTYPE Procedure
  • SETCUSTOMMETADATA Procedure
  • SETDISPLAYNAME Procedure
  • SETLANGUAGE Procedure
  • SETOWNER Procedure

193 DBMS_XDBT

• DBMS_XDBT Overview
• DBMS_XDBT Security Model
• DBMS_XDBT Operational Notes
• Summary of DBMS_XDBT Subprograms
  • CONFIGUREAUTOSYNC Procedure
  • CREATEDATASTOREPREF Procedure
  • CREATEFILTERPREF Procedure
  • CREATEINDEX Procedure
  • CREATELEXERPREF Procedure
  • CREATEPREFERENCES Procedure
  • CREATESECTIONGROUPPREF Procedure
  • CREATESTOPLISTPREF Procedure
  • CREATESTORAGEPREF Procedure
  • CREATEWORLDLISTPREF Procedure
  • DROPPREFERENCES Procedure

194 DBMS_XDBZ

• DBMS_XDBZ Security Model
• DBMS_XDBZ Constants
• Summary of DBMS_XDBZ Subprograms
  • CREATENONCEKEY Procedure
  • DISABLE_HIERARCHY Procedure
  • ENABLE_HIERARCHY Procedure
  • GET_ACLOID Function
  • GET_USERID Function
  • IS_HIERARCHY_ENABLED Function
  • PURGELDAPCACHE Function

195 DBMS_XEVENT

• DBMS_XEVENT Security Model
• DBMS_XEVENT Constants
• Subprogram Groups
  • DBMS_XEVENT XDBEvent Type Subprograms
  • DBMS_XEVENT XDBRepositoryEvent Type Subprograms
  • DBMS_XEVENT XDBHandlerList Type Subprograms
  • DBMS_XEVENT XDBHandler Type Subprograms
  • DBMS_XEVENT XDBPath Type Subprograms
  • DBMS_XEVENT XDBLink Type Subprograms
• Summary of DBMS_XEVENT Subprograms
  • CLEAR Procedure
  • GETAPPLICATIONDATA Function
  • GETCHILDOID Function
  • GETCURRENTUSER Function
  • GETEVENT Function
  • GETFIRST Function
  • GETHANDLERLIST Function
  • GETINTERFACE Function
  • GETLANGUAGE Function
  • GETLINK Function
  • GETLINKNAME Function
  • GETLOCK Function
  • GETLANGUAGE Function
  • GETNAME Function
  • GETNEXT Function
  • GETOLDRESOURCE Function
  • GETOPENACCESSMODE Function
  • GETOPENDENYMODE Function
  • GETOUTPUTSTREAM Function
  • GETPARAMETER Function
  • GETPARENT Function
  • GETPARENTNAME Function
  • GETPARENTOID Function
  • GETPARENTPATH Function
  • GETPATH Function
  • GETRESOURCE Function
  • GETSCHEMA Function
  • GETSOURCE Function
  • GETUPDATEBYTECOUNT Function
  • GETUPDATEBYTEOFFSET Function
  • GETXDBEVENT Function
  • ISNULL Functions
  • REMOVE Procedure
  • SETRENDERPATH Procedure
  • SETRENDERSTREAM Procedure

196 DBMS_XMLDOM

• DBMS_XMLDOM Overview
• DBMS_XMLDOM Security Model
• DBMS_XMLDOM Constants
• DBMS_XMLDOM Types
• DBMS_XMLDOM Exceptions
• DBMS_XMLDOM Subprogram Groups
  • DBMS_XMLDOM DOMNode Subprograms
  • DBMS_XMLDOM DOMAttr Subprograms
  • DBMS_XMLDOM DOMCDataSection Subprograms
  • DBMS_XMLDOM DOMCharacterData Subprograms
  • DBMS_XMLDOM DOMComment Subprograms
  • DBMS_XMLDOM DOMDocument Subprograms
  • DBMS_XMLDOM DOMDocumentFragment Subprograms
  • DBMS_XMLDOM DOMDocumentType Subprograms
  • DBMS_XMLDOM DOMElement Subprograms
  • DBMS_XMLDOM DOMEntity Subprograms
  • DBMS_XMLDOM DOMEntityReference Subprograms
  • DBMS_XMLDOM DOMImplementation Subprograms
  • DBMS_XMLDOM DOMNamedNodeMap Subprograms
  • DBMS_XMLDOM DOMNodeList Subprograms
  • DBMS_XMLDOM DOMNotation Subprograms
  • DBMS_XMLDOM DOMProcessingInstruction Subprograms
  • DBMS_XMLDOM DOMText Subprograms
• Summary of DBMS_XMLDOM Subprograms
  • ADOPTNODE Function
  • APPENDCHILD Function
  • APPENDDATA Procedure
  • CLONENODE Function
  • CREATEATTRIBUTE Functions
  • CREATECDATASECTION Function
  • CREATECOMMENT Function
  • CREATEDOCUMENT Function
  • CREATEDOCUMENTFRAGMENT Function
  • CREATEELEMENT Functions
  • CREATEENTITYREFERENCE Function
  • CREATEPROCESSINGINSTRUCTION Function
  • CREATETEXTNODE Function
  • DELETEDATA Procedure
  • FINDENTITY Function
  • FINDNOTATION Function
  • FREEDOCFRAG Procedure
  • FREEDOCUMENT Procedure
  • FREEELEMENT Procedure
  • FREENODE Procedure
  • FREENODELIST Procedure
  • GETATTRIBUTE Functions
  • GETATTRIBUTENODE Functions
  • GETATTRIBUTES Function
  • GETCHARSET Function
  • GETCHILDNODES Function
  • GETCHILDRENBYTAGNAME Functions
  • GETDATA Functions
  • GETDOCTYPE Function
  • GETDOCUMENTELEMENT Function
  • GETELEMENTSBYTAGNAME Functions
  • GETENTITIES Function
  • GETEXPANDEDNAME Procedure and Functions
  • GETFIRSTCHILD Function
  • GETIMPLEMENTATION Function
  • GETLASTCHILD Function
  • GETLENGTH Functions
  • GETLOCALNAME Procedure and Functions
  • GETNAME Functions
  • GETNAMEDITEM Function
  • GETNAMESPACE Procedure and Functions
  • GETNEXTSIBLING Function
  • GETNODETYPE Function
  • GETNODENAME Function
  • GETNODEVALUE Function
  • GETNODEVALUEASBINARYSTREAM Function & Procedure
  • GETNODEVALUEASCHARACTERSTREAM Function & Procedure
  • GETNOTATIONNAME Function
  • GETNOTATIONS Function
  • GETTARGET Function
  • GETOWNERDOCUMENT Function
  • GETOWNERELEMENT Function
  • GETPARENTNODE Function
  • GETPREFIX Function
  • GETPREVIOUSSIBLING Function
  • GETPUBLICID Functions
  • GETQUALIFIEDNAME Functions
  • GETSCHEMANODE Function
  • GETSPECIFIED Function
  • GETSTANDALONE Function
  • GETSYSTEMID Functions
  • GETTAGNAME Function
  • GETVALUE Function
  • GETVERSION Function
  • GETXMLTYPE Function
  • HASATTRIBUTE Functions
  • HASATTRIBUTES Function
  • HASCHILDNODES Function
  • HASFEATURE Function
  • IMPORTNODE Function
  • INSERTBEFORE Function
  • INSERTDATA Procedure
  • ISNULL Functions
  • ITEM Functions
  • MAKEATTR Function
  • MAKECDATASECTION Function
  • MAKECHARACTERDATA Function
  • MAKECOMMENT Function
  • MAKEDOCUMENT Function
  • MAKEDOCUMENTFRAGMENT Function
  • MAKEDOCUMENTTYPE Function
  • MAKEELEMENT Function
  • MAKEENTITY Function
  • MAKEENTITYREFERENCE Function
  • MAKENODE Functions
  • MAKENOTATION Function
  • MAKEPROCESSINGINSTRUCTION Function
  • MAKETEXT Function
  • NEWDOMDOCUMENT Functions
  • NORMALIZE Procedure
  • REMOVEATTRIBUTE Procedures
  • REMOVEATTRIBUTENODE Function
  • REMOVECHILD Function
  • REMOVENAMEDITEM Function
  • REPLACECHILD Function
  • REPLACEDATA Procedure
  • RESOLVENAMESPACEPREFIX Function
  • SETATTRIBUTE Procedures
  • SETATTRIBUTENODE Functions
  • SETCHARSET Procedure
  • SETDATA Procedures
  • SETDOCTYPE Procedure
  • SETNAMEDITEM Function
  • SETNODEVALUE Procedure
  • SETNODEVALUEASBINARYSTREAM Function & Procedure
  • SETNODEVALUEASCHARACTERSTREAM Function & Procedure
  • SETPREFIX Procedure
  • SETSTANDALONE Procedure
  • SETVALUE Procedure
  • SETVERSION Procedure
  • SPLITTEXT Function
  • SUBSTRINGDATA Function
  • USEBINARYSTREAM Function
  • WRITETOBUFFER Procedures
  • WRITETOCLOB Procedures
  • WRITETOFILE Procedures

197 DBMS_XMLGEN

• DBMS_XMLGEN Security Model
• Summary of DBMS_XMLGEN Subprograms
  • CLOSECONTEXT Procedure
  • CONVERT Functions
  • GETNUMROWSPROCESSED Function
  • GETXML Functions
  • GETXMLTYPE Functions
  • NEWCONTEXT Functions
  • NEWCONTEXTFROMHIERARCHY Function
  • RESTARTQUERY Procedure
  • SETCONVERTSPECIALCHARS Procedure
  • SETMAXROWS Procedure
  • SETNULLHANDLING Procedure
  • SETROWSETTAG Procedure
  • SETROWTAG Procedure
  • SETSKIPROWS Procedure
  • USEITEMTAGSFORCOLL Procedure
  • USENULLATTRIBUTEINDICATOR Procedure

198 DBMS_XMLINDEX

• DBMS_XMLINDEX Overview
• DBMS_XMLINDEX Security Model
• Summary of DBMS_XMLINDEX Subprograms
  • CREATEDATEINDEX Procedure
  • CREATENUMBERINDEX Procedure
  • DROPPARAMETER Procedure
  • MODIFYPARAMETER Procedure
  • PROCESS_PENDING Procedure
  • REGISTERPARAMETER Procedure
  • SYNCINDEX Procedure

199 DBMS_XMLPARSER

• DBMS_XMLPARSER Security Model
• Summary of DBMS_XMLPARSER Subprograms
  • FREEPARSER
  • GETDOCTYPE
  • GETDOCUMENT
  • GETRELEASEVERSION
  • GETVALIDATIONMODE
  • NEWPARSER
  • PARSE
  • PARSEBUFFER
  • PARSECLOB
  • PARSEDTD
  • PARSEDTDBUFFER
  • PARSEDTDCLOB
  • SETBASEDIR
  • SETDOCTYPE Procedure
  • SETERRORLOG Procedure
  • SETPRESERVEWHITESPACE
  • SETVALIDATIONMODE
  • SHOWWARNINGS

200 DBMS_XMLQUERY

• DBMS_XMLQUERY Security Model
• DBMS_XMLQUERY Constants
• Types
• Summary of DBMS_XMLQUERY Subprograms
  • CLOSECONTEXT
  • GETDTD
  • GETEXCEPTIONCONTENT
  • GETNUMROWSPROCESSED
  • GETVERSION
  • GETXML
  • NEWCONTEXT
  • PROPAGATEORIGINALEXCEPTION
  • REMOVEXSLTPARAM
  • SETBINDVALUE
  • SETCOLLIDATTRNAME
  • SETDATAHEADER
  • SETDATEFORMAT
  • SETENCODINGTAG Procedure
  • SETERRORTAG Procedure
  • SETMAXROWS Procedure
  • SETMETAHEADER Procedure
  • SETRAISEEXCEPTION
  • SETRAISENOROWSEXCEPTION
  • SETROWIDATTRNAME
  • SETROWIDATTRVALUE
  • SETROWSETTAG
  • SETROWTAG
  • SETSKIPROWS
  • SETSQLTOXMLNAMEESCAPING
  • SETSTYLESHEETHEADER
  • SETTAGCASE
  • SETXSLT
  • SETXSLTPARAM
  • USENULLATTRIBUTEINDICATOR
  • USETYPEFORCOLLELEMTAG

201 DBMS_XMLSAVE

• DBMS_XMLSAVE Security Model
• DBMS_XMLSAVE Constants
• Types
• Summary of DBMS_XMLSAVE Subprograms
  • CLEARKEYCOLUMNLIST
  • CLEARUPDATECOLUMNLIST
  • CLOSECONTEXT
  • DELETEXML
  • GETEXCEPTIONCONTENT
  • INSERTXML
  • NEWCONTEXT
  • PROPAGATEORIGINALEXCEPTION
  • REMOVEXSLTPARAM
  • SETBATCHSIZE
  • SETCOMMITBATCH
  • SETDATEFORMAT
  • SETIGNORECASE
  • SETKEYCOLUMN
  • SETPRESERVEWHITESPACE
  • SETROWTAG
  • SETSQLTOXMLNAMEESCAPING
  • SETUPDATECOLUMN
  • SETXSLT
  • SETXSLTPARAM
  • UPDATEXML

202 DBMS_XMLSCHEMA

• DBMS_XMLSCHEMA Overview
• DBMS_XMLSCHEMA Deprecated Subprograms
• DBMS_XMLSCHEMA Security Model
• DBMS_XMLSCHEMA Constants
• Views
• DBMS_XMLSCHEMA Operational Notes
• Summary of DBMS_XMLSCHEMA Subprograms
  • COMPILESCHEMA Procedure
  • COPYEVOLVE Procedure
  • DELETESCHEMA Procedure
  • GENERATESCHEMA Function
  • GENERATESCHEMAS Function
  • INPLACEEVOLVE Procedure
  • PURGESCHEMA Procedure
  • REGISTERSCHEMA Procedures
  • REGISTERURI Procedure

203 DBMS_XMLSCHEMA_ANNOTATE

• DBMS_XMLSCHEMA_ANNOTATE Overview
• DBMS_XMLSCHEMA_ANNOTATE Security Model
• Summary of DBMS_XMLSCHEMA_ANNOTATE Subprograms
  • ADDXDBNAMESPACE Procedure
  • DISABLEDEFAULTTABLECREATION Procedure
  • DISABLEMAINTAINDOM Procedure
  • ENABLEDEFAULTTABLECREATION Procedure
  • ENABLEMAINTAINDOM Procedure
  • GETSCHEMAANNOTATIONS Function
  • GETSIDXDEFFROMVIEW Function
  • PRINTWARNINGS Procedure
  • REMOVEANYSTORAGE Procedure
  • REMOVEDEFAULTTABLE Procedure
  • REMOVEMAINTAINDOM Procedure
  • REMOVEOUTOFLINE Procedure
  • REMOVESQLCOLLTYPE Procedure
  • REMOVESQLNAME Procedure
  • REMOVESQLTYPE Procedure
  • REMOVESQLTYPEMAPPING Procedure
  • REMOVETABLEPROPS Procedure
  • REMOVETIMESTAMPWITHTIMEZONE Procedure
  • SETANYSTORAGE Procedure
  • SETDEFAULTTABLE Procedure
  • SETOUTOFLINE Procedure
  • SETSCHEMAANNOTATATIONS Procedure
  • SETSQLCOLLTYPE Procedure
  • SETSQLNAME Procedure
  • SETSQLTYPE Procedure
  • SETSQLTYPEMAPPING Procedure
  • SETTABLEPROPS Procedure
  • SETTIMESTAMPWITHTIMEZONE Procedure

204 DBMS_XMLSTORAGE_MANAGE

• DBMS_XMLSTORAGE_MANAGE Overview
• DBMS_XMLSTORAGE_MANAGE Security Model
• Summary of DBMS_XMLSTORAGE_MANAGE Subprograms
  • DISABLEINDEXESANDCONSTRAINTS Procedure
  • ENABLEINDEXESANDCONSTRAINTS Procedure
  • EXCHANGEPOSTPROC Procedure
  • EXCHANGEPREPROC Procedure
  • INDEXXMLREFERENCES Procedure
  • REFPARTITIONEXCHANGEIN Procedure
  • REFPARTITIONEXCHANGEOUT Procedure
  • RENAMECOLLECTIONTABLE Procedure
  • SCOPEXMLREFERENCES Procedure
  • XPATH2TABCOLMAPPING Function

205 DBMS_XMLSTORE

• DBMS_XMLSTORE Security Model
• Types
• Summary of DBMS_XMLSTORE Subprograms
  • CLEARKEYCOLUMNLIST
  • CLEARUPDATECOLUMNLIST
  • CLOSECONTEXT
  • DELETEXML
  • INSERTXML
  • NEWCONTEXT
  • SETKEYCOLUMN
  • SETROWTAG
  • SETUPDATECOLUMN
  • UPDATEXML

206 DBMS_XMLTRANSLATIONS

• DBMS_XMLTRANSLATIONS Security Model
• Summary of DBMS_XMLTRANSLATIONS Subprograms
  • DISABLETRANSLATION Procedure
  • ENABLETRANSLATION Procedure
  • EXTRACTXLIFF Function & Procedure
  • GETBASEDOCUMENT Function
  • MERGEXLIFF Functions
  • SETSOURCELANG Function
  • TRANSLATEXML Function
  • UPDATETRANSLATION Function

207 DBMS_XPLAN

• DBMS_XPLAN Overview
• DBMS_XPLAN Security Model
• Examples
• Summary of DBMS_XPLAN Subprograms
  • DIFF_PLAN Function
  • DISPLAY Function
  • DISPLAY_AWR Function
  • DISPLAY_CURSOR Function
  • DISPLAY_PLAN Function
  • DISPLAY_SQL_PLAN_BASELINE Function
  • DISPLAY_SQLSET Function

208 DBMS_XSLPROCESSOR

• DBMS_XSLPROCESSOR Overview
• DBMS_XSLPROCESSOR Deprecated Subprograms
• DBMS_XSLPROCESSOR Security Model
• Summary of DBMS_XSLPROCESSOR Subprograms
  • CLOB2FILE Procedure
  • FREEPROCESSOR Procedure
  • FREESTYLESHEET Procedure
  • NEWPROCESSOR Function
  • NEWSTYLESHEET Functions
  • PROCESSXSL Functions and Procedures
  • READ2CLOB Function
  • REMOVEPARAM Procedure
  • RESETPARAMS Procedure
  • SELECTNODES Function
  • SELECTSINGLENODE Function
  • SETERRORLOG Procedure
  • SETPARAM Procedure
  • SHOWWARNINGS Procedure
  • TRANSFORMNODE Function
  • VALUEOF Function and Procedure

209 DBMS_XSTREAM_ADM

• DBMS_XSTREAM_ADM Overview
• DBMS_XSTREAM_ADM Security Model
• DBMS_XSTREAM_ADM Operational Notes
• Summary of DBMS_XSTREAM_ADM Subprograms
  • ADD_COLUMN Procedure
  • ADD_GLOBAL_PROPAGATION_RULES Procedure
  • ADD_GLOBAL_RULES Procedure
  • ADD_OUTBOUND Procedure
  • ADD_SCHEMA_PROPAGATION_RULES Procedure
  • ADD_SCHEMA_RULES Procedure
  • ADD_SUBSET_OUTBOUND_RULES Procedure
  • ADD_SUBSET_PROPAGATION_RULES Procedure
  • ADD_SUBSET_RULES Procedure
  • ADD_TABLE_PROPAGATION_RULES Procedure
  • ADD_TABLE_RULES Procedure
  • ALTER_INBOUND Procedure
  • ALTER_OUTBOUND Procedure
  • CREATE_INBOUND Procedure
  • CREATE_OUTBOUND Procedure
  • DELETE_COLUMN Procedure
  • DROP_INBOUND Procedure
  • DROP_OUTBOUND Procedure
  • ENABLE_GG_XSTREAM_FOR_STREAMS Procedure
  • GET_MESSAGE_TRACKING Function
  • GET_TAG Function
  • IS_GG_XSTREAM_FOR_STREAMS Function
  • KEEP_COLUMNS Procedure
  • MERGE_STREAMS Procedure
  • MERGE_STREAMS_JOB Procedure
  • PURGE_SOURCE_CATALOG Procedure
  • RECOVER_OPERATION Procedure
  • REMOVE_QUEUE Procedure
  • REMOVE_RULE Procedure
  • REMOVE_SUBSET_OUTBOUND_RULES Procedure
  • REMOVE_XSTREAM_CONFIGURATION Procedure
  • RENAME_COLUMN Procedure
  • RENAME_SCHEMA Procedure
  • RENAME_TABLE Procedure
  • SET_MESSAGE_TRACKING Procedure
  • SET_PARAMETER Procedure
  • SET_TAG Procedure
  • SET_UP_QUEUE Procedure
  • SPLIT_STREAMS Procedure
  • START_OUTBOUND Procedure
  • STOP_OUTBOUND Procedure

210 DBMS_XSTREAM_AUTH

• DBMS_XSTREAM_AUTH Overview
• DBMS_XSTREAM_AUTH Security Model
• Summary of DBMS_XSTREAM_AUTH Subprograms
  • GRANT_ADMIN_PRIVILEGE Procedure
  • GRANT_REMOTE_ADMIN_ACCESS Procedure
  • REVOKE_ADMIN_PRIVILEGE Procedure
  • REVOKE_REMOTE_ADMIN_ACCESS Procedure

211 DEBUG_EXTPROC

• DEBUG_EXTPROC Security Model
• DEBUG_EXTPROC Operational Notes
• Rules and Limits
• Summary of DEBUG_EXTPROC Subprograms
  • STARTUP_EXTPROC_AGENT Procedure

212 HTF

• HTF Deprecated Subprograms
• HTF Operational Notes
• Rules and Limits
• HTF Examples
• Summary of Tags
• Summary of HTF Subprograms
  • ADDRESS Function
  • ANCHOR Function
  • ANCHOR2 Function
  • APPLETCLOSE Function
  • APPLETOPEN Function
  • AREA Function
  • BASE Function
  • BASEFONT Function
  • BGSOUND Function
  • BIG Function
  • BLOCKQUOTECLOSE Function
  • BLOCKQUOTEOPEN Function
  • BODYCLOSE Function
  • BODYOPEN Function
  • BOLD Function
  • BR Function
  • CENTER Function
  • CENTERCLOSE Function
  • CENTEROPEN Function
  • CITE Function
  • CODE Function
  • COMMENT Function
  • DFN Function
  • DIRLISTCLOSE Function
  • DIRLISTOPEN Function
  • DIV Function
  • DLISTCLOSE Function
  • DLISTDEF Function
  • DLISTOPEN Function
  • DLISTTERM Function
  • EM Function
  • EMPHASIS Function
  • ESCAPE_SC Function
  • ESCAPE_URL Function
  • FONTCLOSE Function
  • FONTOPEN Function
  • FORMAT_CELL Function
  • FORMCHECKBOX Function
  • FORMCLOSE Function
  • FORMFILE Function
  • FORMHIDDEN Function
  • FORMIMAGE Function
  • FORMOPEN Function
  • FORMPASSWORD Function
  • FORMRADIO Function
  • FORMRESET Function
  • FORMSELECTCLOSE Function
  • FORMSELECTOPEN Function
  • FORMSELECTOPTION Function
  • FORMSUBMIT Function
  • FORMTEXT Function
  • FORMTEXTAREA Function
  • FORMTEXTAREA2 Function
  • FORMTEXTAREACLOSE Function
  • FORMTEXTAREAOPEN Function
  • FORMTEXTAREAOPEN2 Function
  • FRAME Function
  • FRAMESETCLOSE Function
  • FRAMESETOPEN Function
  • HEADCLOSE Function
  • HEADER Function
  • HEADOPEN Function
  • HR Function
  • HTMLCLOSE Function
  • HTMLOPEN Function
  • IMG Function
  • IMG2 Function
  • ISINDEX Function
  • ITALIC Function
  • KBD Function
  • KEYBOARD Function
  • LINE Function
  • LINKREL Function
  • LINKREV Function
  • LISTHEADER Function
  • LISTINGCLOSE Function
  • LISTINGOPEN Function
  • LISTITEM Function
  • MAILTO Function
  • MAPCLOSE Function
  • MAPOPEN Function
  • MENULISTCLOSE Function
  • MENULISTOPEN Function
  • META Function
  • NL Function
  • NOBR Function
  • NOFRAMESCLOSE Function
  • NOFRAMESOPEN Function
  • OLISTCLOSE Function
  • OLISTOPEN Function
  • PARA Function
  • PARAGRAPH Function
  • PARAM Function
  • PLAINTEXT Function
  • PRECLOSE Function
  • PREOPEN Function
  • PRINT Functions
  • PRN Functions
  • S Function
  • SAMPLE Function
  • SCRIPT Function
  • SMALL Function
  • STRIKE Function
  • STRONG Function
  • STYLE Function
  • SUB Function
  • SUP Function
  • TABLECAPTION Function
  • TABLECLOSE Function
  • TABLEDATA Function
  • TABLEHEADER Function
  • TABLEOPEN Function
  • TABLEROWCLOSE Function
  • TABLEROWOPEN Function
  • TELETYPE Function
  • TITLE Function
  • ULISTCLOSE Function
  • ULISTOPEN Function
  • UNDERLINE Function
  • VARIABLE Function
  • WBR Function

213 HTP

• HTP Operational Notes
• HTP Rules and Limits
• HTP Examples
• HTP Summary of Tags
• Summary of HTP Subprograms
  • ADDRESS Procedure
  • ANCHOR Procedure
  • ANCHOR2 Procedure
  • APPLETCLOSE Procedure
  • APPLETOPEN Procedure
  • AREA Procedure
  • BASE Procedure
  • BASEFONT Procedure
  • BGSOUND Procedure
  • BIG Procedure
  • BLOCKQUOTECLOSE Procedure
  • BLOCKQUOTEOPEN Procedure
  • BODYCLOSE Procedure
  • BODYOPEN Procedure
  • BOLD Procedure
  • BR Procedure
  • CENTER Procedure
  • CENTERCLOSE Procedure
  • CENTEROPEN Procedure
  • CITE Procedure
  • CODE Procedure
  • COMMENT Procedure
  • DFN Procedure
  • DIRLISTCLOSE Procedure
  • DIRLISTOPEN Procedure
  • DIV Procedure
  • DLISTCLOSE Procedure
  • DLISTDEF Procedure
  • DLISTOPEN Procedure
  • DLISTTERM Procedure
  • EM Procedure
  • EMPHASIS Procedure
  • ESCAPE_SC Procedure
  • FONTCLOSE Procedure
  • FONTOPEN Procedure
  • FORMCHECKBOX Procedure
  • FORMCLOSE Procedure
  • FORMOPEN Procedure
  • FORMFILE Procedure
  • FORMHIDDEN Procedure
  • FORMIMAGE Procedure
  • FORMPASSWORD Procedure
  • FORMRADIO Procedure
  • FORMRESET Procedure
  • FORMSELECTCLOSE Procedure
  • FORMSELECTOPEN Procedure
  • FORMSELECTOPTION Procedure
  • FORMSUBMIT Procedure
  • FORMTEXT Procedure
  • FORMTEXTAREA Procedure
  • FORMTEXTAREA2 Procedure
  • FORMTEXTAREACLOSE Procedure
  • FORMTEXTAREAOPEN Procedure
  • FORMTEXTAREAOPEN2 Procedure
  • FRAME Procedure
  • FRAMESETCLOSE Procedure
  • FRAMESETOPEN Procedure
  • HEADCLOSE Procedure
  • HEADER Procedure
  • HEADOPEN Procedure
  • HR Procedure
  • HTMLCLOSE Procedure
  • HTMLOPEN Procedure
  • IMG Procedure
  • IMG2 Procedure
  • ISINDEX Procedure
  • ITALIC Procedure
  • KBD Procedure
  • KEYBOARD Procedure
  • LINE Procedure
  • LINKREL Procedure
  • LINKREV Procedure
  • LISTHEADER Procedure
  • LISTINGCLOSE Procedure
  • LISTINGOPEN Procedure
  • LISTITEM Procedure
  • MAILTO Procedure
  • MAPCLOSE Procedure
  • MAPOPEN Procedure
  • MENULISTCLOSE Procedure
  • MENULISTOPEN Procedure
  • META Procedure
  • NL Procedure
  • NOBR Procedure
  • NOFRAMESCLOSE Procedure
  • NOFRAMESOPEN Procedure
  • OLISTCLOSE Procedure
  • OLISTOPEN Procedure
  • PARA Procedure
  • PARAGRAPH Procedure
  • PARAM Procedure
  • PLAINTEXT Procedure
  • PRECLOSE Procedure
  • PREOPEN Procedure
  • PRINT Procedures
  • PRINTS Procedure
  • PRN Procedures
  • PS Procedure
  • S Procedure
  • SAMPLE Procedure
  • SCRIPT Procedure
  • SMALL Procedure
  • STRIKE Procedure
  • STRONG Procedure
  • STYLE Procedure
  • SUB Procedure
  • SUP Procedure
  • TABLECAPTION Procedure
  • TABLECLOSE Procedure
  • TABLEDATA Procedure
  • TABLEHEADER Procedure
  • TABLEOPEN Procedure
  • TABLEROWCLOSE Procedure
  • TABLEROWOPEN Procedure
  • TELETYPE Procedure
  • TITLE Procedure
  • ULISTCLOSE Procedure
  • ULISTOPEN Procedure
  • UNDERLINE Procedure
  • VARIABLE Procedure
  • WBR Procedure

214 ORD_AUDIO

215 ORD_DICOM

216 ORD_DICOM_ADMIN

217 ORD_DOC

218 ORD_IMAGE

219 ORD_VIDEO

220 OWA_CACHE

• OWA_CACHE Constants
• Summary of OWA_CACHE Subprograms
  • DISABLE Procedure
  • GET_ETAG Function
  • GET_LEVEL Function
  • SET_CACHE Procedure
  • SET_EXPIRES Procedure
  • SET_NOT_MODIFIED Procedure
  • SET_SURROGATE_CONTROL Procedure

221 OWA_COOKIE

• OWA_CUSTOM Overview
• OWA_COOKIE Types
• OWA_COOKIE Rules and Limits
• Summary of OWA_COOKIE Subprograms
  • GET Function
  • GET_ALL Procedure
  • REMOVE Procedure
  • SEND procedure

222 OWA_CUSTOM

• OWA_CUSTOM Constants
• Summary of OWA_CUSTOM Subprograms
  • AUTHORIZE Function

223 OWA_IMAGE

• OWA_IMAGE Overview
• OWA_IMAGE Types
• OWA_IMAGE Variables
• OWA_IMAGE Examples
• Summary of OWA_IMAGE Subprograms
  • GET_X Function
  • GET_Y Function

224 OWA_OPT_LOCK

• OWA_OPT_LOCK Overview
• OWA_TEXT Types
• Summary of OWA_OPT_LOCK Subprograms
  • CHECKSUM Functions
  • GET_ROWID Function
  • STORE_VALUES Procedure
  • VERIFY_VALUES Function

225 OWA_PATTERN

• OWA_PATTERN Types
• OWA_PATTERN Operational Notes
  • OWA_PATTERN Wildcards
  • OWA_PATTERN Quantifiers
  • OWA_PATTERN Flags
• Summary of OWA_PATTERN Subprograms
  • AMATCH Function
  • CHANGE Functions and Procedures
  • GETPAT Procedure
  • MATCH Function

226 OWA_SEC

• OWA_SEC Operational Notes
• Summary of OWA_SEC Subprograms
  • GET_CLIENT_HOSTNAME Function
  • GET_CLIENT_IP Function
  • GET_PASSWORD Function
  • GET_USER_ID Function
  • SET_AUTHORIZATION Procedure
  • SET_PROTECTION_REALM Procedure

227 OWA_TEXT

• OWA_OPT_LOCK Types
  • MULTI_LINE DATA TYPE
  • ROW_LIST DATA TYPE
  • VC_ARR DATA TYPE
• Summary of OWA_TEXT Subprograms
  • ADD2MULTI Procedure
  • NEW_ROW_LIST Function and Procedure
  • PRINT_MULTI Procedure
  • PRINT_ROW_LIST Procedure
  • STREAM2MULTI Procedure

228 OWA_UTIL

• OWA_UTIL Overview
• OWA_UTIL Types
  • DATETYPE Datatype
  • IDENT_ARR Datatype
  • IP_ADDRESS Datatype
• Summary of OWA_UTIL Subprograms
  • BIND_VARIABLES Function
  • CALENDARPRINT Procedures
  • CELLSPRINT Procedures
  • CHOOSE_DATE Procedure
  • GET_CGI_ENV Function
  • GET_OWA_SERVICE_PATH Function
  • GET_PROCEDURE Function
  • HTTP_HEADER_CLOSE Procedure
  • LISTPRINT Procedure
  • MIME_HEADER Procedure
  • PRINT_CGI_ENV Procedure
  • REDIRECT_URL Procedure
  • SHOWPAGE Procedure
  • SHOWSOURCE Procedure
  • SIGNATURE procedure
  • STATUS_LINE Procedure
  • TABLEPRINT Function
  • TODATE Function
  • 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

• UTL_CALL_STACK Overview
• UTL_CALL_STACK Security Model
• UTL_CALL_STACK Operational Notes
• UTL_CALL_STACK Exceptions
• UTL_CALL_STACK Data Structures
  • UNIT_QUALIFIED_NAME
• Summary of UTL_CALL_STACK Subprograms
  • BACKTRACE_DEPTH Function
  • BACKTRACE_LINE Function
  • BACKTRACE_UNIT Function
  • CURRENT_EDITION Function
  • CONCATENATE_SUBPROGRAM Function
  • DYNAMIC_DEPTH Function
  • ERROR_DEPTH Function
  • ERROR_MSG Function
  • ERROR_NUMBER Function
  • LEXICAL_DEPTH Function
  • OWNER Function
  • UNIT_LINE Function
  • SUBPROGRAM Function

258 UTL_COLL

• Summary of UTL_COLL Subprograms
  • IS_LOCATOR Function

259 UTL_COMPRESS

• UTL_COMPRESS Constants
• UTL_COMPRESS Exceptions
• UTL_COMPRESS Operational Notes
• Summary of UTL_COMPRESS Subprograms
  • ISOPEN Function
  • LZ_COMPRESS Functions and Procedures
  • LZ_COMPRESS_ADD Procedure
  • LZ_COMPRESS_CLOSE
  • LZ_COMPRESS_OPEN
  • LZ_UNCOMPRESS Functions and Procedures
  • LZ_UNCOMPRESS_EXTRACT Procedure
  • LZ_UNCOMPRESS_OPEN Function
  • LZ_UNCOMPRESS_CLOSE Procedure

260 UTL_ENCODE

• Summary of UTL_ENCODE Subprograms
  • BASE64_DECODE Function
  • BASE64_ENCODE Function
  • MIMEHEADER_DECODE Function
  • MIMEHEADER_ENCODE Function
  • QUOTED_PRINTABLE_DECODE Function
  • QUOTED_PRINTABLE_ENCODE Function
  • TEXT_DECODE Function
  • TEXT_ENCODE Function
  • UUDECODE Function
  • UUENCODE Function

261 UTL_FILE

• UTL_FILE Deprecated Subprograms
• UTL_FILE Security Model
• UTL_FILE Operational Notes
• UTL_FILE Rules and Limits
• UTL_FILE Exceptions
• UTL_FILE Examples
• UTL_FILE Data Structures
  • FILETYPE Record Type
• Summary of UTL_FILE Subprograms
  • FCLOSE Procedure
  • FCLOSE_ALL Procedure
  • FCOPY Procedure
  • FFLUSH Procedure
  • FGETATTR Procedure
  • FGETPOS Function
  • FOPEN Function
  • FOPEN_NCHAR Function
  • FREMOVE Procedure
  • FRENAME Procedure
  • FSEEK Procedure
  • GET_LINE Procedure
  • GET_LINE_NCHAR Procedure
  • GET_RAW Procedure
  • IS_OPEN Function
  • NEW_LINE Procedure
  • PUT Procedure
  • PUT_LINE Procedure
  • PUT_LINE_NCHAR Procedure
  • PUT_NCHAR Procedure
  • PUTF Procedure
  • PUTF_NCHAR Procedure
  • PUT_RAW Procedure

262 UTL_HTTP

• UTL_HTTP Overview
• UTL_HTTP Security Model
• UTL_HTTP Constants
• UTL_HTTP Exceptions
• UTL_HTTP Examples
  • UTL_HTTP General Usage
  • UTL_HTTP Retrieving HTTP Response Headers
  • UTL_HTTP Handling HTTP Authentication
  • UTL_HTTP Retrieving and Restoring Cookies
  • UTL_HTTP Making HTTP Request with Private Wallet and Cookie Table
• UTL_HTTP Data Structures
  • REQ Type
  • REQUEST_CONTEXT_KEY Type
  • RESP Type
  • COOKIE and COOKIE_TABLE Types
  • CONNECTION Type
• UTL_HTTP Operations
  • UTL_HTTP Operational Flow
  • UTL_HTTP Simple HTTP Fetches
  • UTL_HTTP HTTP Requests
  • UTL_HTTP HTTP Responses
  • UTL_HTTP HTTP Cookies
  • UTL_HTTP HTTP Persistent Connections
  • UTL_HTTP Error Conditions
  • UTL_HTTP Session Settings
  • UTL_HTTP Request Context
  • UTL_HTTP External Password Store
• UTL_HTTP Subprogram Groups
  • UTL_HTTP Simple HTTP Fetches in a Single Call Subprograms
  • UTL_HTTP Session Settings Subprograms
  • UTL_HTTP HTTP Requests Subprograms
  • UTL_HTTP HTTP Request Contexts Subprograms
  • UTL_HTTP HTTP Responses Subprograms
  • UTL_HTTP HTTP Cookies Subprograms
  • UTL_HTTP HTTP Persistent Connections Subprograms
  • UTL_HTTP Error Conditions Subprograms
• Summary of UTL_HTTP Subprograms
  • ADD_COOKIES Procedure
  • BEGIN_REQUEST Function
  • CLEAR_COOKIES Procedure
  • CLOSE_PERSISTENT_CONN Procedure
  • CLOSE_PERSISTENT_CONNS Procedure
  • CREATE_REQUEST_CONTEXT Function
  • DESTROY_REQUEST_CONTEXT Procedure
  • END_REQUEST Procedure
  • END_RESPONSE Procedure
  • GET_AUTHENTICATION Procedure
  • GET_BODY_CHARSET Procedure
  • GET_COOKIE_COUNT Function
  • GET_COOKIE_SUPPORT Procedure
  • GET_COOKIES Function
  • GET_DETAILED_EXCP_SUPPORT Procedure
  • GET_DETAILED_SQLCODE Function
  • GET_DETAILED_SQLERRM Function
  • GET_FOLLOW_REDIRECT Procedure
  • GET_HEADER Procedure
  • GET_HEADER_BY_NAME Procedure
  • GET_HEADER_COUNT Function
  • GET_PERSISTENT_CONN_COUNT Function
  • GET_PERSISTENT_CONN_SUPPORT Procedure
  • GET_PERSISTENT_CONNS Procedure
  • GET_PROXY Procedure
  • GET_RESPONSE Function
  • GET_RESPONSE_ERROR_CHECK Procedure
  • GET_TRANSFER_TIMEOUT Procedure
  • READ_LINE Procedure
  • READ_RAW Procedure
  • READ_TEXT Procedure
  • REQUEST Function
  • REQUEST_PIECES Function
  • SET_AUTHENTICATION Procedure
  • SET_AUTHENTICATION_FROM_WALLET Procedure
  • SET_BODY_CHARSET Procedures
  • SET_COOKIE_SUPPORT Procedures
  • SET_DETAILED_EXCP_SUPPORT Procedure
  • SET_FOLLOW_REDIRECT Procedures
  • SET_HEADER Procedure
  • SET_PERSISTENT_CONN_SUPPORT Procedure
  • SET_PROXY Procedure
  • SET_RESPONSE_ERROR_CHECK Procedure
  • SET_TRANSFER_TIMEOUT Procedure
  • SET_WALLET Procedure
  • WRITE_LINE Procedure
  • WRITE_RAW Procedure
  • WRITE_TEXT Procedure

263 UTL_I18N

• UTL_I18N Overview
• UTL_I18N Security Model
• UTL_I18N Constants
• Summary of UTL_I18N Subprograms
  • ESCAPE_REFERENCE Function
  • GET_COMMON_TIME_ZONES Function
  • GET_DEFAULT_CHARSET Function
  • GET_DEFAULT_ISO_CURRENCY Function
  • GET_DEFAULT_LINGUISTIC_SORT Function
  • GET_LOCAL_LANGUAGES Function
  • GET_LOCAL_LINGUISTIC_SORTS Function
  • GET_LOCAL_TERRITORIES Function
  • GET_LOCAL_TIME_ZONES Function
  • GET_MAX_CHARACTER_SIZE Function
  • GET_TRANSLATION Function
  • MAP_CHARSET Function
  • MAP_FROM_SHORT_LANGUAGE Function
  • MAP_LANGUAGE_FROM_ISO Function
  • MAP_LOCALE_TO_ISO Function
  • MAP_TERRITORY_FROM_ISO Function
  • MAP_TO_SHORT_LANGUAGE Function
  • RAW_TO_CHAR Functions
  • RAW_TO_NCHAR Functions
  • STRING_TO_RAW Function
  • TRANSLITERATE Function
  • UNESCAPE_REFERENCE Function

264 UTL_IDENT

• UTL_IDENT Overview
• UTL_IDENT Security Model
• UTL_IDENT Constants

265 UTL_INADDR

• UTL_INADDR Security Model
• UTL_INADDR Exceptions
• UTL_INADDR Examples
• Summary of UTL_INADDR Subprograms
  • GET_HOST_ADDRESS Function
  • GET_HOST_NAME Function

266 UTL_LMS

• UTL_LMS Security Model
• Summary of UTL_LMS Subprograms
  • FORMAT_MESSAGE Function
  • GET_MESSAGE Function

267 UTL_MAIL

• UTL_MAIL Security Model
• UTL_MAIL Operational Notes
• UTL_MAIL Rules and Limits
• Summary of UTL_MAIL Subprograms
  • SEND Procedure
  • SEND_ATTACH_RAW Procedure
  • SEND_ATTACH_VARCHAR2 Procedure

268 UTL_MATCH

• UTL_MATCH Overview
• UTL_MATCH Security Model
• Summary of UTL_MATCH Subprograms
  • EDIT_DISTANCE Function
  • EDIT_DISTANCE_SIMILARITY Function
  • JARO_WINKLER Function
  • JARO_WINKLER_SIMILARITY Function

269 UTL_NLA

• UTL_NLA Overview
• UTL_NLA Rules and Limits
• UTL_NLA Security Model
• Subprogram Groups
  • UTL_NLA BLAS Level 1 (Vector-Vector Operations) Subprograms
  • UTL_NLA BLAS Level 2 (Matrix-Vector Operations) Subprograms
  • UTL_NLA BLAS Level 3 (Matrix-Matrix Operations) Subprograms
  • UTL_NLA LAPACK Driver Routines (Linear Equations) Subprograms
  • UTL_NLA LAPACK Driver Routines (LLS and Eigenvalue Problems) Subprograms
• Summary of UTL_NLA Subprograms
  • BLAS_ASUM Functions
  • BLAS_AXPY Procedures
  • BLAS_COPY Procedures
  • BLAS_DOT Functions
  • BLAS_GBMV Procedures
  • BLAS_GEMM Procedures
  • BLAS_GEMV Procedures
  • BLAS_GER Procedures
  • BLAS_IAMAX Functions
  • BLAS_NRM2 Functions
  • BLAS_ROT Procedures
  • BLAS_ROTG Procedures
  • BLAS_SCAL Procedures
  • BLAS_SPMV Procedures
  • BLAS_SPR Procedures
  • BLAS_SPR2 Procedures
  • BLAS_SBMV Procedures
  • BLAS_SWAP Procedures
  • BLAS_SYMM Procedures
  • BLAS_SYMV Procedures
  • BLAS_SYR Procedures
  • BLAS_SYR2 Procedures
  • BLAS_SYR2K Procedures
  • BLAS_SYRK Procedures
  • BLAS_TBMV Procedures
  • BLAS_TBSV Procedures
  • BLAS_TPMV Procedures
  • BLAS_TPSV Procedures
  • BLAS_TRMM Procedures
  • BLAS_TRMV Procedures
  • BLAS_TRSM Procedures
  • BLAS_TRSV Procedures
  • LAPACK_GBSV Procedures
  • LAPACK_GEES Procedures
  • LAPACK_GELS Procedures
  • LAPACK_GESDD Procedures
  • LAPACK_GESV Procedure
  • LAPACK_GESVD Procedures
  • LAPACK_GEEV Procedures
  • LAPACK_GTSV Procedure
  • LAPACK_PBSV Procedures
  • LAPACK_POSV Procedures
  • LAPACK_PPSV Procedures
  • LAPACK_PTSV Procedures
  • LAPACK_SBEV Procedures
  • LAPACK_SBEVD Procedures
  • LAPACK_SPEV Procedures
  • LAPACK_SPEVD Procedures
  • LAPACK_SPSV Procedures
  • LAPACK_STEV Procedures
  • LAPACK_STEVD Procedures
  • LAPACK_SYEV Procedures
  • LAPACK_SYEVD Procedures
  • LAPACK_SYSV Procedures

270 UTL_RAW

• UTL_RAW Overview
• UTL_RAW Operational Notes
• Summary of UTL_RAW Subprograms
  • BIT_AND Function
  • BIT_COMPLEMENT Function
  • BIT_OR Function
  • BIT_XOR Function
  • CAST_FROM_BINARY_DOUBLE Function
  • CAST_FROM_BINARY_FLOAT Function
  • CAST_FROM_BINARY_INTEGER Function
  • CAST_FROM_NUMBER Function
  • CAST_TO_BINARY_DOUBLE Function
  • CAST_TO_BINARY_FLOAT Function
  • CAST_TO_BINARY_INTEGER Function
  • CAST_TO_NUMBER Function
  • CAST_TO_NVARCHAR2 Function
  • CAST_TO_RAW Function
  • CAST_TO_VARCHAR2 Function
  • COMPARE Function
  • CONCAT Function
  • CONVERT Function
  • COPIES Function
  • LENGTH Function
  • OVERLAY Function
  • REVERSE Function
  • SUBSTR Function
  • TRANSLATE Function
  • TRANSLITERATE Function
  • XRANGE Function

271 UTL_RECOMP

• UTL_RECOMP Overview
• UTL_RECOMP Operational Notes
• UTL_RECOMP Examples
• Summary of UTL_RECOMP Subprograms
  • RECOMP_PARALLEL Procedure
  • RECOMP_SERIAL Procedure

272 UTL_REF

• UTL_REF Overview
• UTL_REF Security Model
• UTL_REF Types
• UTL_REF Exceptions
• Summary of UTL_REF Subprograms
  • DELETE_OBJECT Procedure
  • LOCK_OBJECT Procedure
  • SELECT_OBJECT Procedure
  • UPDATE_OBJECT Procedure

273 UTL_SMTP

• UTL_SMTP Overview
• UTL_SMTP Security Model
• UTL_SMTP Constants
• UTL_SMTP Types
• UTL_SMTP Reply Codes
• UTL_SMTP Operational Notes
• UTL_SMTP Exceptions
• UTL_SMTP Rules and Limits
• UTL_SMTP Examples
• Summary of UTL_SMTP Subprograms
  • AUTH Function and Procedure
  • CLOSE_CONNECTION Procedure
  • CLOSE_DATA Function and Procedure
  • COMMAND Function and Procedure
  • COMMAND_REPLIES Function
  • DATA Function and Procedure
  • EHLO Function and Procedure
  • HELO Function and Procedure
  • HELP Function
  • MAIL Function and Procedure
  • NOOP Function and Procedure
  • OPEN_CONNECTION Functions
  • OPEN_DATA Function and Procedure
  • QUIT Function and Procedure
  • RCPT Function
  • RSET Function and Procedure
  • STARTTLS Function and Procedure
  • VRFY Function
  • WRITE_DATA Procedure
  • WRITE_RAW_DATA Procedure

274 UTL_SPADV

• UTL_SPADV Overview
• DBMS_COMPARISON Security Model
• UTL_SPADV Operational Notes
• Summary of UTL_SPADV Subprograms
  • ALTER_MONITORING Procedure
  • COLLECT_STATS Procedure
  • IS_MONITORING Function
  • SHOW_STATS Procedure
  • SHOW_STATS_HTML Procedure
  • START_MONITORING Procedure
  • STOP_MONITORING Procedure

275 UTL_TCP

• UTL_TCP Overview
• UTL_TCP Security Model
• UTL_TCP Types
• UTL_TCP Exceptions
• UTL_TCP Rules and Limits
• UTL_TCP Examples
• Summary of UTL_TCP Subprograms
  • AVAILABLE Function
  • CLOSE_ALL_CONNECTIONS Procedure
  • CLOSE_CONNECTION Procedure
  • FLUSH Procedure
  • GET_LINE Function
  • GET_LINE_NCHAR Function
  • GET_RAW Function
  • GET_TEXT Function
  • GET_TEXT_NCHAR Function
  • OPEN_CONNECTION Function
  • READ_LINE Function
  • READ_RAW Function
  • READ_TEXT Function
  • SECURE_CONNECTION Procedure
  • WRITE_LINE Function
  • WRITE_RAW Function
  • WRITE_TEXT Function

276 UTL_URL

• UTL_URL Overview
• UTL_URL Exceptions
• UTL_URL Examples
• Summary of UTL_URL Subprograms
  • ESCAPE Function
  • UNESCAPE Function

277 WPG_DOCLOAD

• WPG_DOCLOAD Constants
• Summary of WPG_DOCLOAD Subprograms
  • DOWNLOAD_FILE Procedures

278 ANYDATA TYPE

• ANYDATA TYPE Restrictions
• ANYDATA TYPE Operational Notes
• Summary of ANYDATA Subprograms
  • BEGINCREATE Static Procedure
  • ENDCREATE Member Procedure
  • GET* Member Functions
  • GETTYPE Member Function
  • GETTYPENAME Member Function
  • PIECEWISE Member Procedure
  • SET* Member Procedures

279 ANYDATASET TYPE

• ANYDATASET TYPE Construction
• Summary of ANYDATASET TYPE Subprograms
  • ADDINSTANCE Member Procedure
  • BEGINCREATE Static Procedure
  • ENDCREATE Member Procedure
  • GET* Member Functions
  • GETCOUNT Member Function
  • GETINSTANCE Member Function
  • GETTYPE Member Function
  • GETTYPENAME Member Function
  • PIECEWISE Member Procedure
  • SET* Member Procedures

280 ANYTYPE TYPE

• Summary of ANYTYPE Subprograms
  • BEGINCREATE Static Procedure
  • SETINFO Member Procedure
  • ADDATTR Member Procedure
  • ENDCREATE Member Procedure
  • GETPERSISTENT Static Function
  • GETINFO Member Function
  • GETATTRELEMINFO Member Function

281 Oracle Database Advanced Queuing (AQ) Types

• Advanced Queuing (AQ)Types Security Model
• Oracle Database Advanced Queuing (AQ) Types —Summary of Types
  • AQ$_AGENT Type
  • AQ$_AGENT_LIST_T Type
  • AQ$_DESCRIPTOR Type
  • AQ$_NTFN_DESCRIPTOR Type
  • AQ$_NTFN_MSGID_ARRAY Type
  • AQ$_POST_INFO Type
  • AQ$_POST_INFO_LIST Type
  • AQ$_PURGE_OPTIONS_T Type
  • AQ$_RECIPIENT_LIST_T Type
  • AQ$_REG_INFO Type
  • AQ$_REG_INFO_LIST Type
  • AQ$_SUBSCRIBER_LIST_T Type
  • DEQUEUE_OPTIONS_T Type
  • ENQUEUE_OPTIONS_T Type
  • QUEUE_PROPS_T Type
  • SYS.MSG_PROP_T Type
  • MESSAGE_PROPERTIES_T Type
  • MESSAGE_PROPERTIES_ARRAY_T Type
  • MSGID_ARRAY_T Type

282 DBFS Content Interface Types

• DDBFS Content Interface Types Overview
• DBFS Content Interface Types Security Model
• DBFS Content Interface Types —Data Structures
  • DBMS_DBFS_CONTENT_CONTEXT_T Object Type
  • DBMS_DBFS_CONTENT_LIST_ITEM_T Object Type
  • DBMS_DBFS_CONTENT_PROPERTY_T Object Type
  • DBMS_DBFS_CONTENT_LIST_ITEMS_T Table Type
  • DBMS_DBFS_CONTENT_PROPERTIES_T Table Type
  • DBMS_DBFS_CONTENT_RAW_T Table Type

283 Database URI TYPEs

• Summary of URITYPE Supertype Subprograms
  • UriType Supertype GETBLOB
  • UriType Supertype GETCLOB
  • UriType Supertype GETCONTENTTYPE
  • UriType Supertype GETEXTERNALURL
  • UriType Supertype GETURL
  • UriType Supertype GETXML
• Summary of HTTPURITYPE Subtype Subprograms
  • HttpUriType Subtype CREATEURI
  • HttpUriType Subtype GETBLOB
  • HttpUriType Subtype GETCLOB
  • HttpUriType Subtype GETCONTENTTYPE
  • HttpUriType Subtype GETEXTERNALURL
  • HttpUriType Subtype GETURL
  • HttpUriType Subtype GETXML
  • HttpUriType Subtype HTTPURITYPE
• Summary of DBURITYPE Subtype Subprogams
  • DBUriType Subtype CREATEURI
  • DBUriType Subtype DBURITYPE
  • DBUriType Subtype GETBLOB
  • DBUriType Subtype GETCLOB
  • DBUriType Subtype GETCONTENTTYPE
  • DBUriType Subtype GETEXTERNALURL
  • DBUriType Subtype GETURL
  • DBUriType Subtype GETXML
• Summary of XDBURITYPE Subtype Subprograms
  • XDBUriType Subtype CREATEURI
  • XDBUriType Subtype GETBLOB
  • XDBUriType Subtype GETCLOB
  • XDBUriType Subtype GETCONTENTTYPE
  • XDBUriType Subtype GETEXTERNALURL
  • XDBUriType Subtype GETURL
  • XDBUriType Subtype GETXML
  • XDBUriType subtype XDBURITYPE
• Summary of URIFACTORY Package Subprograms
  • UriFactory Package GETURI
  • UriFactory Package ESCAPEURI
  • UriFactory Package UNESCAPEURI
  • UriFactory Package REGISTERURLHANDLER
  • UriFactory Package UNREGISTERURLHANDLER

284 JMS Types

• JMS Types Overview
• JMS Types Security Model
• Java Versus PL/SQL Datatypes
• More on Bytes, Stream and Map Messages
• Upcasting and Downcasting Between General and Specific Messages
• JMS Types Error Reporting
• Oracle JMS Type Constants
• CONVERT_JMS_SELECTOR
• Summary of JMS Types
  • SYS.AQ$_JMS_MESSAGE Type
  • SYS.AQ$_JMS_TEXT_MESSAGE Type
  • SYS.AQ$_JMS_BYTES_MESSAGE Type
  • SYS.AQ$_JMS_MAP_MESSAGE Type
  • SYS.AQ$_JMS_STREAM_MESSAGE Type
  • SYS.AQ$_JMS_OBJECT_MESSAGE Type
  • SYS.AQ$_JMS_NAMEARRAY Type
  • SYS.AQ$_JMS_VALUE Type
  • SYS.AQ$_JMS_EXCEPTION Type

285 JSON Data Structures

• JSON_ELEMENT_T Object Type
• JSON_OBJECT_T Object Type
• JSON_ARRAY_T Object Type
• JSON_SCALAR_T Object Type
• JSON_KEY_LIST Type

286 Logical Change Record TYPEs

• Logical Change Record TYPEs Overview
• Logical Change Record Types Security Model
• Summary of Logical Change Record Types
  • LCR$_DDL_RECORD Type
  • LCR$_ROW_RECORD Type
  • Common Subprograms for LCR$_DDL_RECORD and LCR$_ROW_RECORD
  • LCR$_ROW_LIST Type
  • LCR$_ROW_UNIT Type

287 Oracle Multimedia ORDAudio TYPE

288 Oracle Multimedia ORDDicom TYPE

289 Oracle Multimedia ORDDoc TYPE

290 Oracle Multimedia ORDImage TYPE

291 Oracle Multimedia SQL/MM Still Image TYPES

292 Oracle Multimedia ORDVideo TYPE

293 MGD_ID Package Types

• MGD_ID Package Types Security Model
• Summary of Types
  • MGD_ID_COMPONENT Object Type
  • MGD_ID_COMPONENT_VARRAY Object Type
  • MGD_ID Object Type
• Summary of MGD_ID Subprograms
  • MGD_ID Constructor Function
  • FORMAT Function
  • GET_COMPONENT Function
  • TO_STRING Function
  • TRANSLATE Function

294 Rule TYPEs

• Rule TYPEs Overview
• Rule TYPEs Security Model
• Summary of Rule Types
  • RE$ATTRIBUTE_VALUE Type
  • RE$ATTRIBUTE_VALUE_LIST Type
  • RE$COLUMN_VALUE Type
  • RE$COLUMN_VALUE_LIST Type
  • RE$NAME_ARRAY Type
  • RE$NV_ARRAY Type
  • RE$NV_LIST Type
  • RE$NV_NODE Type
  • RE$RULE_HIT Type
  • RE$RULE_HIT_LIST Type
  • RE$RULE_NAME Type
  • RE$RULE_NAME_LIST Type
  • RE$TABLE_ALIAS Type
  • RE$TABLE_ALIAS_LIST Type
  • RE$TABLE_VALUE Type
  • RE$TABLE_VALUE_LIST Type
  • RE$VALUE Type
  • RE$VALUE_LIST Type
  • RE$VARIABLE_TYPE Type
  • RE$VARIABLE_TYPE_LIST Type
  • RE$VARIABLE_VALUE Type
  • RE$VARIABLE_VALUE_LIST Type

295 UTL Streams Types

• UTL Streams Types Security Model
• Summary of UTL Binary Streams Types
  • UTL_BINARYINPUTSTREAM Type
  • UTL_BINARYOUTPUTSTREAM Type
  • UTL_CHARACTERINPUTSTREAM Type
  • UTL_CHARACTEROUTPUTSTREAM Type

296 XMLTYPE

• Summary of XMLType Subprograms
  • CREATENONSCHEMABASEDXML
  • CREATESCHEMABASEDXML
  • CREATEXML
  • EXISTSNODE
  • EXTRACT
  • GETBLOBVAL
  • GETCLOBVAL
  • GETNAMESPACE
  • GETNUMBERVAL
  • GETROOTELEMENT
  • GETSCHEMAURL
  • GETSTRINGVAL
  • ISFRAGMENT
  • ISSCHEMABASED
  • ISSCHEMAVALID
  • ISSCHEMAVALIDATED
  • SCHEMAVALIDATE
  • SETSCHEMAVALIDATED
  • TOOBJECT
  • TRANSFORM
  • XMLTYPE

Index