Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

What's New in PL/SQL Packages and Types Reference?

• New Packages
• Updated Packages
• New Types
• Updated Types

1 Introduction to Oracle Supplied PL/SQL Packages & Types

• Package Overview
  • Package Components
  • Using Oracle Supplied Packages
  • Creating New Packages
  • Referencing Package Contents
• Summary of Oracle Supplied PL/SQL Packages and Types

2 APEX_CUSTOM_AUTH

• Documentation of APEX_CUSTOM_AUTH

3 APEX_APPLICATION

• Documentation of APEX_APPLICATION

4 APEX_ITEM

• Documentation of APEX_ITEM

5 APEX_UTIL

• Documentation of APEX_UTIL

6 CTX_ADM

• Documentation of CTX_ADM

7 CTX_CLS

• Documentation of CTX_CLS

8 CTX_DDL

• Documentation of CTX_DDL

9 CTX_DOC

• Documentation of CTX_DOC

10 CTX_OUTPUT

• Documentation of CTX_OUTPUT

11 CTX_QUERY

• Documentation of CTX_QUERY

12 CTX_REPORT

• Documentation of CTX_REPORT

13 CTX_THES

• Documentation of CTX_THES

14 CTX_ULEXER

• Documentation of CTX_ULEXER

15 DBMS_ADDM

• Using DBMS_ADDM
  • Security Model
• Summary of DBMS_ADDM Subprograms
  • ANALYZE_DB Procedure
  • ANALYZE_INST Procedure
  • ANALYZE_PARTIAL Procedure
  • 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

16 DBMS_ADVANCED_REWRITE

• Using 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

17 DBMS_ADVISOR

• Using DBMS_ADVISOR
  • Deprecated Subprograms
  • 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 Procedures
  • 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 Procedures
  • SET_DEFAULT_TASK_PARAMETER Procedures
  • SET_SQLWKLD_PARAMETER Procedures
  • 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

18 DBMS_ALERT

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

19 DBMS_APPLICATION_INFO

• Using DBMS_APPLICATION_INFO
  • Overview
  • Security Model
  • 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

• Using DBMS_APPLY_ADM
  • Overview
  • Operational Notes
• 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
  • REMOVE_STMT_HANDLER
  • SET_CHANGE_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_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

• Using DBMS_AQ
  • Constants
  • Data Structures
  • 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

• Using DBMS_AQADM
  • Constants
• Subprogram Groups
  • Queue Table Subprograms
  • Privilege Subprograms
  • Queue Subprograms
  • Subscriber Subprograms
  • Notification Subprograms
  • Propagation Subprograms
  • Oracle Streams AQ Agent Subprograms
  • 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_SUBSCRIBER Procedure
  • CREATE_AQ_AGENT Procedure
  • CREATE_NP_QUEUE Procedure
  • CREATE_QUEUE Procedure
  • CREATE_QUEUE_TABLE 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
  • ENABLE_DB_ACCESS Procedure
  • ENABLE_JMS_TYPES Procedure
  • ENABLE_PROPAGATION_SCHEDULE 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
  • START_QUEUE Procedure
  • STOP_QUEUE Procedure
  • UNSCHEDULE_PROPAGATION Procedure
  • VERIFY_QUEUE_TYPES Procedure

23 DBMS_AQELM

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

24 DBMS_AQIN

• Using DBMS_AQIN
  • Overview

25 DBMS_ASSERT

• Using 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

• Using DBMS_AUDIT_MGMT
  • Overview
  • Security Model
  • Constants
  • Views
• Subprogram Groups
  • Audit Trail Management Subprograms
  • Audit Trail Cleanup Subprograms
• Summary of DBMS_AUDIT_MGMT Subprograms
  • CLEAN_AUDIT_TRAIL Procedure
  • CLEAR_AUDIT_TRAIL_PROPERTY Procedure
  • CLEAR_LAST_ARCHIVE_TIMESTAMP Procedure
  • CREATE_PURGE_JOB Procedure
  • DEINIT_CLEANUP Procedure
  • DROP_PURGE_JOB Procedure
  • GET_AUDIT_COMMIT_DELAY Function
  • INIT_CLEANUP Procedure
  • IS_CLEANUP_INITIALIZED Function
  • 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

27 DBMS_AUTO_TASK_ADMIN

• Using 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

28 DBMS_AUTO_TASK_IMMEDIATE

• Summary of DBMS_AUTO_TASK_IMMEDIATE Subprograms
  • GATHER_OPTIMIZER_STATS Procedure

29 DBMS_AW_STATS

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

30 DBMS_CAPTURE_ADM

• 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

31 DBMS_CDC_PUBLISH

• Using DBMS_CDC_PUBLISH
  • Overview
  • Deprecated Subprograms
  • Security Model
  • Views
• Summary of DBMS_CDC_PUBLISH Subprograms
  • ALTER_AUTOLOG_CHANGE_SOURCE Procedure
  • ALTER_CHANGE_SET Procedure
  • ALTER_CHANGE_TABLE Procedure
  • ALTER_HOTLOG_CHANGE_SOURCE Procedure
  • CREATE_AUTOLOG_CHANGE_SOURCE Procedure
  • CREATE_CHANGE_SET Procedure
  • CREATE_CHANGE_TABLE Procedure
  • CREATE_HOTLOG_CHANGE_SOURCE Procedure
  • DROP_CHANGE_SET Procedure
  • DROP_CHANGE_SOURCE Procedure
  • DROP_CHANGE_TABLE Procedure
  • DROP_SUBSCRIPTION Procedure
  • GET_DDLOPER Function
  • PURGE Procedure
  • PURGE_CHANGE_SET Procedure
  • PURGE_CHANGE_TABLE Procedure

32 DBMS_CDC_SUBSCRIBE

• Using DBMS_CDC_SUBSCRIBE
  • Overview
  • Deprecated Subprograms
  • Security Model
  • Views
• Summary of DBMS_CDC_SUBSCRIBE Subprograms
  • ACTIVATE_SUBSCRIPTION Procedure
  • CREATE_SUBSCRIPTION Procedure
  • DROP_SUBSCRIPTION Procedure
  • EXTEND_WINDOW Procedure
  • PURGE_WINDOW Procedure
  • SUBSCRIBE Procedure

33 DBMS_COMPARISON

• Using DBMS_COMPARISON
  • Overview
  • Security Model
  • Constants
  • Views
  • Operational Notes
• 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

• Using DBMS_COMPRESSION
  • Overview
  • Security Model
  • Constants
  • Views
• 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

• Using DBMS_CQ_NOTIFICATION
  • Overview
  • Security Model
  • Constants
  • Operational Notes
  • Examples
• 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

37 DBMS_CRYPTO

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

38 DBMS_CSX_ADMIN

• Using DBMS_CSX_ADMIN
  • Overview
  • Constants
  • Examples
• Summary of DBMS_CSX_ADMIN
  • COPYDEFAULTTOKENTABLESET Procedure
  • GETTOKENTABLEINFO Procedure & Function
  • GETTOKENTABLEINFOBYTABLESPACE Procedure
  • NAMESPACEIDTABLE Function
  • PATHIDTABLE Function
  • QNAMEIDTABLE Function
  • REGISTERTOKENTABLESET Procedure

39 DBMS_CUBE

• Using DBMS_CUBE
• 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 Metadata From OLAP 10g to OLAP 11g
• Summary of DBMS_CUBE Subprograms
  • BUILD 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
  • VALIDATE_XML Procedure

40 DBMS_CUBE_ADVISE

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

41 DBMS_CUBE_LOG

• Using DBMS_CUBE_LOG
  • Creating Cube Logs
  • Cube Build Log
  • Cube Dimension Compile Log
  • Cube Operations 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

42 DBMS_DATA_MINING

• Using DBMS_DATA_MINING
  • Overview
  • Mining Model Objects
  • Deprecated Subprograms
  • Mining Functions
  • Model Settings
  • Data Types
• Summary of DBMS_DATA_MINING Subprograms
  • ADD_COST_MATRIX Procedure
  • ALTER_REVERSE_EXPRESSION Procedure
  • APPLY Procedure
  • COMPUTE_CONFUSION_MATRIX Procedure
  • COMPUTE_LIFT Procedure
  • COMPUTE_ROC Procedure
  • CREATE_MODEL Procedure
  • DROP_MODEL Procedure
  • EXPORT_MODEL Procedure
  • GET_ASSOCIATION_RULES Function
  • GET_DEFAULT_SETTINGS Function
  • GET_FREQUENT_ITEMSETS Function
  • GET_MODEL_COST_MATRIX Function
  • GET_MODEL_DETAILS_ABN Function
  • GET_MODEL_DETAILS_AI 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_DETAILS_SVM Function
  • GET_MODEL_DETAILS_XML Function
  • GET_MODEL_SETTINGS Function
  • GET_MODEL_SIGNATURE Function
  • GET_MODEL_TRANSFORMATIONS Function
  • GET_TRANSFORM_LIST Procedure
  • IMPORT_MODEL Procedure
  • RANK_APPLY Procedure
  • REMOVE_COST_MATRIX Procedure
  • RENAME_MODEL Procedure

43 DBMS_DATA_MINING_TRANSFORM

• Using DBMS_DATA_MINING_TRANSFORM
  • Data Transformation with Oracle Data Mining
  • Types of Transformations
  • The DBMS_DATA_MINING_TRANSFORM Framework
  • Data Types
• 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

44 DBMS_DATAPUMP

• Using DBMS_DATAPUMP
  • Overview
  • Security Model
  • Constants
• Data Structures
  • Data Structures - Object Types
• 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

45 DBMS_DBFS_CONTENT

• Using DBMS_DBFS_CONTENT
  • Overview
  • Security Model
  • Constants
  • Exceptions
  • Operational Notes
• Data Structures
  • FEATURE_T Record Type
  • MOUNT_T Record Type
  • PATH_ITEM_T Record Type
  • PROP_ITEM_T Record Type
  • PROPERTY_T Record Type
  • STORE_T Record Type
  • FEATURES_T Table Type
  • MOUNTS_T Table Type
  • PATH_ITEMS_T Table Type
  • PROP_ITEMS_T Table Type
  • 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
  • GETTDEFAULTCONTEXT 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
  • 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
  • SEARCH Function
  • 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

46 DBMS_DBFS_CONTENT_SPI

• Using DBMS_DBFS_CONTENT_SPI
  • Overview
  • Security Model
  • 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
  • LIST Function
  • LOCKPATH Procedure
  • PURGEALL Procedure
  • PURGEPATH Procedure
  • PUTPATH Procedures
  • RENAMEPATH Procedure
  • RESTOREALL Procedure
  • RESTOREPATH Procedure
  • SEARCH Function
  • SETPATH Procedure
  • SPACEUSAGE Procedure
  • UNLOCKPATH Procedure

47 DBMS_DBFS_HS

• Using DBMS_DBFS_HS
  • Overview
  • Security Model
  • Constants
  • 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 Procedures
  • SETSTOREPROPERTY Procedure
  • STOREPUSH Procedure

48 DBMS_DBFS_SFS

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

49 DBMS_DB_VERSION

• Using DBMS_DB_VERSION
  • Overview
  • Constants
  • Examples

50 DBMS_DDL

• Using DBMS_DDL
  • Deprecated Subprograms
  • Security Model
  • 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

51 DBMS_DEBUG

• Using DBMS_DEBUG
  • Overview
  • Constants
  • Variables
  • Exceptions
  • Operational Notes
• 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

52 DBMS_DEFER

• Documentation of DBMS_DEFER

53 DBMS_DEFER_QUERY

• Documentation of DBMS_DEFER_QUERY

54 DBMS_DEFER_SYS

• Documentation of DBMS_DEFER_SYS

55 DBMS_DESCRIBE

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

56 DBMS_DG

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

57 DBMS_DIMENSION

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

58 DBMS_DST

• Using DBMS_DST
  • Overview
  • Security Model
  • 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

59 DBMS_DISTRIBUTED_TRUST_ADMIN

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

60 DBMS_EPG

• Using DBMS_EPG
  • Overview
  • Security Model
  • Exceptions
• Data Structures
• Subprogram Groups
  • Configuration Subprograms
  • 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

61 DBMS_ERRLOG

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

62 DBMS_EXPFIL

• Summary of Expression Filter Subprograms
  • ADD_ELEMENTARY_ATTRIBUTE Procedures
  • ADD_FUNCTIONS Procedure
  • ASSIGN_ATTRIBUTE_SET Procedure
  • BUILD_EXCEPTIONS_TABLE Procedure
  • CLEAR_EXPRSET_STATS Procedure
  • COPY_ATTRIBUTE_SET Procedure
  • CREATE_ATTRIBUTE_SET Procedure
  • DEFAULT_INDEX_PARAMETERS Procedure
  • DEFAULT_XPINDEX_PARAMETERS Procedure
  • DEFRAG_INDEX Procedure
  • DROP_ATTRIBUTE_SET Procedure
  • GET_EXPRSET_STATS Procedure
  • GRANT_PRIVILEGE Procedure
  • INDEX_PARAMETERS Procedure
  • MODIFY_OPERATOR_LIST Procedure
  • REVOKE_PRIVILEGE Procedure
  • SYNC_TEXT_INDEXES Procedure
  • UNASSIGN_ATTRIBUTE_SET Procedure
  • VALIDATE_EXPRESSIONS Procedure
  • XPINDEX_PARAMETERS Procedure

63 DBMS_FGA

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

64 DBMS_FILE_GROUP

• Using DBMS_FILE_GROUP
  • Overview
  • Constants
• 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

65 DBMS_FILE_TRANSFER

• Using DBMS_FILE_TRANSFER
  • Operating Notes
• Summary of DBMS_FILE_TRANSFER Subprograms
  • COPY_FILE Procedure
  • GET_FILE Procedure
  • PUT_FILE Procedure

66 DBMS_FLASHBACK

• Using DBMS_FLASHBACK
  • Overview
  • Security Model
  • Types
  • Exceptions
  • Operational Notes
  • 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

67 DBMS_FLASHBACK_ARCHIVE

• Using DBMS_FLASHBACK_ARCHIVE
  • Overview
  • Security Model
  • Examples
• Summary of DBMS_FLASHBACK_ARCHIVE Subprograms
  • DISASSOCIATE_FBA Procedure
  • REASSOCIATE_FBA Procedure

68 DBMS_FREQUENT_ITEMSET

• Summary of DBMS_FREQUENT_ITEMSET Subprograms
  • FI_HORIZONTAL Function
  • FI_TRANSACTIONAL Function

69 DBMS_HM

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

70 DBMS_HPROF

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

71 DBMS_HS_PARALLEL

• Using DBMS_HS_PARALLEL
• Summary of DBMS_HS_PARALLEL Subprograms
  • CREATE_OR_REPLACE_VIEW
  • CREATE_TABLE_TEMPLATE
  • DROP_VIEW
  • LOAD_TABLE

72 DBMS_HS_PASSTHROUGH

• Using DBMS_HS_PASSTHROUGH
  • Overview
  • 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

73 DBMS_IOT

• Summary of DBMS_IOT Subprograms
  • BUILD_CHAIN_ROWS_TABLE Procedure
  • BUILD_EXCEPTIONS_TABLE Procedure

74 DBMS_JAVA

• Documentation of DBMS_JAVA

75 DBMS_JOB

• Using DBMS_JOB
  • Security Model
  • 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

76 DBMS_LDAP

• Documentation of DBMS_LDAP

77 DBMS_LDAP_UTL

• Documentation of DBMS_LDAP_UTL

78 DBMS_LIBCACHE

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

79 DBMS_LOB

• Using DBMS_LOB
  • Overview
  • Security Model
  • Constants
  • Datatypes
  • Rules and Limits
  • Operational Notes
  • Exceptions
• Summary of DBMS_LOB Subprograms
  • APPEND Procedures
  • CLOSE Procedure
  • COMPARE Functions
  • CONVERTTOBLOB Procedure
  • CONVERTTOCLOB Procedure
  • COPY Procedures
  • COPY_FROM_DBFS_LINK
  • COPY_DBFS_LINK Procedures
  • CREATETEMPORARY Procedures
  • 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
  • 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

80 DBMS_LOCK

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

81 DBMS_LOGMNR

• Using DBMS_LOGMNR
  • Overview
  • Security Model
  • Constants
  • Views
  • 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

82 DBMS_LOGMNR_D

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

83 DBMS_LOGSTDBY

• Using DBMS_LOGSTDBY
  • Overview
  • Operational Notes
• Summary of DBMS_LOGSTDBY Subprograms
  • APPLY_SET Procedure
  • APPLY_UNSET Procedure
  • BUILD Procedure
  • 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

84 DBMS_METADATA

• Using DBMS_METADATA
  • Overview
  • Security Model
  • Rules and Limits
• Data Structures - Object and Table Types
• Subprogram Groupings
  • Subprograms for Retrieving Multiple Objects From the Database
  • 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

85 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

86 DBMS_MGD_ID_UTL

• Using DBMS_MGD_ID_UTL
  • Constants
  • 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

87 DBMS_MGWADM

• Using DBMS_MGWADM
  • Deprecated Subprograms
  • Constants
• Data Structures
  • SYS.MGW_MQSERIES_PROPERTIES Object Type
  • SYS.MGW_PROPERTIES Object Type
  • 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

88 DBMS_MGWMSG

• Using DBMS_MGWMSG
  • Security Model
  • Constants
  • Types
• 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

89 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

90 DBMS_MVIEW

• Using DBMS_MVIEW
  • Operational Notes
  • 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

91 DBMS_NETWORK_ACL_ADMIN

• Using DBMS_NETWORK_ACL_ADMIN
  • Examples
• Summary of DBMS_NETWORK_ACL_ADMIN Subprograms
  • ADD_PRIVILEGE Procedure
  • ASSIGN_ACL Procedure
  • ASSIGN_WALLET_ACL Procedure
  • CHECK_PRIVILEGE Function
  • CHECK_PRIVILEGE_ACLID Function
  • CREATE_ACL Procedure
  • DELETE_PRIVILEGE Procedure
  • DROP_ACL Procedure
  • UNASSIGN_ACL Procedure
  • UNASSIGN_WALLET_ACL Procedure

92 DBMS_NETWORK_ACL_UTILITY

• Using DBMS_NETWORK_ACL_UTILITY
  • Examples
• Summary of DBMS_NETWORK_ACL_UTILITY Subprograms
  • CONTAINS_HOST Function
  • DOMAIN_LEVEL Function
  • DOMAINS Function
  • EQUALS_HOST Function

93 DBMS_OBFUSCATION_TOOLKIT

• Using DBMS_OBFUSCATION_TOOLKIT
  • Overview
  • Security Model
  • Operational Notes
• Summary of DBMS_OBFUSCATION Subprograms
  • DES3DECRYPT Procedures and Functions
  • DES3ENCRYPT Procedures and Functions
  • DES3GETKEY Procedures and Functions
  • DESDECRYPT Procedures and Functions
  • DESENCRYPT Procedures and Functions
  • DESGETKEY Procedures and Functions
  • MD5 Procedures and Functions

94 DBMS_ODCI

• Summary of DBMS_ODCI Subprograms
  • ESTIMATE_CPU_UNITS Function

95 DBMS_OFFLINE_OG

• Documentation of DBMS_OFFLINE_OG

96 DBMS_OUTLN

• Using DBMS_OUTLN
  • Overview
  • 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

97 DBMS_OUTPUT

• Using DBMS_OUTPUT
  • Overview
  • Security Model
  • Operational Notes
  • Exceptions
  • Rules and Limits
  • Examples
• Data Structures
  • CHARARR Table Type
  • 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

98 DBMS_PARALLEL_EXECUTE

• Using DBMS_PARALLEL_EXECUTE
  • Overview
  • Security Model
  • Constants
  • Views
  • Exceptions
  • Examples
• Summary of DBMS_PARALLEL_EXECUTE Subprograms
  • ADM_DROP_CHUNKS Procedure
  • ADM_DROP_TASK Procedure
  • ADM_TASK_STATUS Procedure
  • 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

99 DBMS_PCLXUTIL

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

100 DBMS_PIPE

• Using DBMS_PIPE
  • Overview
  • Security Model
  • Constants
  • Operational Notes
  • Exceptions
  • 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

101 DBMS_PREDICTIVE_ANALYTICS

• Using DBMS_PREDICTIVE_ANALYTICS
  • Overview
• Summary of DBMS_PREDICTIVE_ANALYTICS Subprograms
  • EXPLAIN Procedure
  • PREDICT Procedure
  • PROFILE Procedure

102 DBMS_PREPROCESSOR

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

103 DBMS_PROFILER

• Using DBMS_PROFILER
  • Overview
  • Security Model
  • Operational Notes
  • 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

104 DBMS_PROPAGATION_ADM

• Summary of DBMS_PROPAGATION_ADM Subprograms
  • ALTER_PROPAGATION Procedure
  • CREATE_PROPAGATION Procedure
  • DROP_PROPAGATION Procedure
  • START_PROPAGATION Procedure
  • STOP_PROPAGATION Procedure

105 DBMS_RANDOM

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

106 DBMS_RECTIFIER_DIFF

• Documentation of DBMS_RECTIFIER_DIFF

107 DBMS_REDEFINITION

• Using DBMS_REDEFINITION
  • Overview
  • Constants
  • Operational Notes
  • Rules and Limits
• Summary of DBMS_REDEFINITION Subprograms
  • ABORT_REDEF_TABLE Procedure
  • CAN_REDEF_TABLE Procedure
  • COPY_TABLE_DEPENDENTS Procedure
  • FINISH_REDEF_TABLE Procedure
  • REGISTER_DEPENDENT_OBJECT Procedure
  • START_REDEF_TABLE Procedure
  • SYNC_INTERIM_TABLE Procedure
  • UNREGISTER_DEPENDENT_OBJECT Procedure

108 DBMS_REFRESH

• Documentation of DBMS_REFRESH

109 DBMS_REPAIR

• Using DBMS_REPAIR
  • Overview
  • Security Model
  • Constants
  • Operating Notes
  • Exceptions
  • 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

110 DBMS_REPCAT

• Documentation of DBMS_REPCAT

111 DBMS_REPCAT_ADMIN

• Documentation of DBMS_REPCAT_ADMIN

112 DBMS_REPCAT_INSTANTIATE

• Documentation of DBMS_REPCAT_INSTANTIATE

113 DBMS_REPCAT_RGT

• Documentation of DBMS_REPCAT_RGT

114 DBMS_REPUTIL

• Documentation of DBMS_REPUTIL

115 DBMS_RESCONFIG

• Using 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

116 DBMS_RESOURCE_MANAGER

• Using DBMS_RESOURCE_MANAGER
  • Deprecated Subprograms
  • Security Model
  • Constants
• Summary of DBMS_RESOURCE_MANAGER Subprograms
  • CALIBRATE_IO Procedure
  • CLEAR_PENDING_AREA Procedure
  • CREATE_CATEGORY Procedure
  • CREATE_CONSUMER_GROUP Procedure
  • CREATE_PENDING_AREA Procedure
  • CREATE_PLAN Procedure
  • CREATE_PLAN_DIRECTIVE Procedure
  • CREATE_SIMPLE_PLAN Procedure
  • DELETE_CATEGORY Procedure
  • DELETE_CONSUMER_GROUP Procedure
  • DELETE_PLAN Procedure
  • DELETE_PLAN_CASCADE Procedure
  • DELETE_PLAN_DIRECTIVE 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_CONSUMER_GROUP Procedure
  • UPDATE_PLAN Procedure
  • UPDATE_PLAN_DIRECTIVE Procedure
  • VALIDATE_PENDING_AREA Procedure

117 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

118 DBMS_RESULT_CACHE

• Using DBMS_RESULT_CACHE
  • Constants
• Summary of DBMS_RESULT_CACHE Subprograms
  • BYPASS Procedure
  • FLUSH Function & Procedure
  • INVALIDATE Functions & Procedures
  • INVALIDATE_OBJECT Functions & Procedures
  • MEMORY_REPORT Procedure
  • STATUS Function

119 DBMS_RESUMABLE

• Using 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

120 DBMS_RLMGR

• Summary of Rules Manager Subprograms
  • ADD_ELEMENTARY_ATTRIBUTE Procedures
  • ADD_EVENT Procedure
  • ADD_FUNCTIONS Procedure
  • ADD_RULE Procedure
  • CONDITION_REF Function
  • CONSUME_EVENT Function
  • CONSUME_PRIM_EVENTS Function
  • CREATE_CONDITIONS_TABLE Procedure
  • CREATE_EVENT_STRUCT Procedure
  • CREATE_EXPFIL_INDEXES Procedure
  • CREATE_INTERFACE Procedure
  • CREATE_RULE_CLASS Procedure
  • DELETE_RULE Procedure
  • DROP_CONDITIONS_TABLE Procedure
  • DROP_EVENT_STRUCT Procedure
  • DROP_EXPFIL_INDEXES Procedure
  • DROP_INTERFACE Procedure
  • DROP_RULE_CLASS Procedure
  • EXTEND_EVENT_STRUCT Procedure
  • GET_AGGREGATE_VALUE Function
  • GRANT_PRIVILEGE Procedure
  • PROCESS_RULES Procedure
  • PURGE_EVENTS Procedure
  • RESET_SESSION Procedure
  • REVOKE_PRIVILEGE Procedure
  • SYNC_TEXT_INDEXES Procedure

121 DBMS_RLS

• Using DBMS_RLS
  • Overview
  • Security Model
  • Operational Notes
• Summary of DBMS_RLS Subprograms
  • ADD_GROUPED_POLICY Procedure
  • ADD_POLICY Procedure
  • ADD_POLICY_CONTEXT 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

122 DBMS_ROWID

• Using DBMS_ROWID
  • Security Model
  • Types
  • Exceptions
  • Operational Notes
  • 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

123 DBMS_RULE

• Using DBMS_RULE
  • Security Model
• Summary of DBMS_RULE Subprograms
  • CLOSE_ITERATOR Procedure
  • EVALUATE Procedures
  • GET_NEXT_HIT Function

124 DBMS_RULE_ADM

• Using 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

125 DBMS_SCHEDULER

• Data Structures
  • JOBARG Object Type
  • JOBARG_ARRAY Table Type
  • JOB Object Type
  • JOB_ARRAY Table Type
  • 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
• Using DBMS_SCHEDULER
  • Rules and Limits
  • Operational Notes
• Summary of DBMS_SCHEDULER Subprograms
  • ADD_EVENT_QUEUE_SUBSCRIBER Procedure
  • ADD_GROUP_MEMBER Procedure
  • ADD_JOB_EMAIL_NOTIFICATION Procedure
  • ADD_WINDOW_GROUP_MEMBER 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_JOB Procedure
  • CREATE_JOB_CLASS Procedure
  • CREATE_JOBS Procedure
  • CREATE_PROGRAM Procedure
  • CREATE_SCHEDULE Procedure
  • CREATE_WINDOW Procedure
  • CREATE_WINDOW_GROUP 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_JOB Procedure
  • DROP_JOB_CLASS Procedure
  • DROP_PROGRAM Procedure
  • DROP_PROGRAM_ARGUMENT Procedure
  • DROP_SCHEDULE Procedure
  • DROP_WINDOW Procedure
  • DROP_WINDOW_GROUP Procedure
  • ENABLE Procedure
  • END_DETACHED_JOB_RUN Procedure
  • EVALUATE_CALENDAR_STRING Procedure
  • EVALUATE_RUNNING_CHAIN Procedure
  • GENERATE_JOB_NAME 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_GROUP_MEMBER Procedure
  • REMOVE_JOB_EMAIL_NOTIFICATION Procedure
  • REMOVE_WINDOW_GROUP_MEMBER 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_SCHEDULER_ATTRIBUTE Procedure
  • STOP_JOB Procedure

126 DBMS_SERVER_ALERT

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

127 DBMS_SERVICE

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

128 DBMS_SESSION

• Using DBMS_SESSION
  • Security Model
  • Operational Notes
• Data Structures
  • INTEGER_ARRAY Table Type
  • 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

129 DBMS_SHARED_POOL

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

130 DBMS_SPACE

• Using DBMS_SPACE
  • Security Model
• Data Structures
  • CREATE_TABLE_COST_COLINFO Object Type
  • ASA_RECO_ROW Record Type
  • ASA_RECO_ROW_TB Table Type
• Summary of DBMS_SPACE Subprograms
  • 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

131 DBMS_SPACE_ADMIN

• Using DBMS_SPACE_ADMIN
  • Security Model
  • Constants
  • Operational Notes
• Summary of DBMS_SPACE_ADMIN Subprograms
  • ASSM_SEGMENT_VERIFY Procedure
  • ASSM_TABLESPACE_VERIFY Procedure
  • SEGMENT_CORRUPT Procedure
  • SEGMENT_DROP_CORRUPT Procedure
  • SEGMENT_DUMP Procedure
  • SEGMENT_VERIFY 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

132 DBMS_SPM

• Using DBMS_SPM
  • Overview
  • Security Model
  • Constants
  • Examples
• Data Structures
  • NAMELIST Table Type
• Summary of DBMS_SPM Subprograms
  • ALTER_SQL_PLAN_BASELINE Function
  • CONFIGURE Procedure
  • CREATE_STGTAB_BASELINE Procedure
  • DROP_SQL_PLAN_BASELINE Function
  • EVOLVE_SQL_PLAN_BASELINE Function
  • LOAD_PLANS_FROM_CURSOR_CACHE Functions
  • LOAD_PLANS_FROM_SQLSET Function
  • MIGRATE_STORED_OUTLINE Functions
  • PACK_STGTAB_BASELINE Function
  • UNPACK_STGTAB_BASELINE Function

133 DBMS_SQL

• Using DBMS_SQL
  • Overview
  • Security Model
  • Constants
  • Exceptions
  • Operational Notes
  • Examples
• Data Structures
  • DESC_REC Record Type
  • DESC_REC2 Record Type
  • DESC_REC3 Record Type
  • BFILE_TABLE Table Type
  • BINARY_DOUBLE_TABLE Table Type
  • BINARY_FLOAT_TABLE Table Type
  • BLOB_TABLE Table Type
  • CLOB_TABLE Table Type
  • DATE_TABLE Table Type
  • DESC_TAB Table Type
  • DESC_TAB2 Table Type
  • DESC_TAB3 Table Type
  • INTERVAL_DAY_TO_SECOND_TABLE Table Type
  • INTERVAL_YEAR_TO_MONTH_TABLE Table Type
  • NUMBER_TABLE Table Type
  • TIME_TABLE Table Type
  • TIME_WITH_TIME_ZONE_TABLE Table Type
  • TIMESTAMP_TABLE Table Type
  • TIMESTAMP_WITH_LTZ_TABLE Table Type
  • TIMESTAMP_WITH_TIME_ZONE_TABLE Table Type
  • UROWID_TABLE Table Type
  • VARCHAR2_TABLE Table Type
  • VARCHAR2A Table Type
  • VARCHAR2S Table Type
• Summary of DBMS_SQL Subprograms
  • BIND_ARRAY Procedures
  • BIND_VARIABLE Procedures
  • 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
  • IS_OPEN Function
  • LAST_ERROR_POSITION Function
  • LAST_ROW_COUNT Function
  • LAST_ROW_ID Function
  • LAST_SQL_FUNCTION_CODE Function
  • OPEN_CURSOR Function
  • PARSE Procedures
  • TO_CURSOR_NUMBER Function
  • TO_REFCURSOR Function
  • VARIABLE_VALUE Procedures

134 DBMS_SQLDIAG

• Using DBMS_SQLDIAG
  • Overview
  • Constants
  • Examples
• Summary of DBMS_SQLDIAG Subprograms
  • ACCEPT_SQL_PATCH Function & Procedure
  • ALTER_SQL_PATCH Procedure
  • CANCEL_DIAGNOSIS_TASK Procedure
  • CREATE_DIAGNOSIS_TASK Functions
  • 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
  • REPORT_DIAGNOSIS_TASK Function
  • RESET_DIAGNOSIS_TASK Procedure
  • RESUME_DIAGNOSIS_TASK Procedure
  • SET_DIAGNOSIS_TASK_PARAMETER Procedure
  • UNPACK_STGTAB_SQLPATCH Procedure

135 DBMS_SQLPA

• Using DBMS_SQLPA
  • Overview
  • 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

136 DBMS_SQLTUNE

• Using DBMS_SQLTUNE
  • Overview
  • Security Model
• Data Structures
  • SQLSET_ROW Object Type
• Subprogram Groups
  • SQL Tuning Advisor Subprograms
  • SQL Profile Subprograms
  • SQL Tuning Set Subprograms
  • Real-time SQL Monitoring Subprograms
  • SQL Performance Reporting Subprograms
• Summary of DBMS_SQLTUNE Subprograms
  • 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 & Procedure
  • IMPLEMENT_TUNING_TASK Function
  • 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_TUNING_TASK Function
  • RESET_TUNING_TASK Procedure
  • RESUME_TUNING_TASK Procedure
  • SCRIPT_TUNING_TASK Function
  • SELECT_CURSOR_CACHE Function
  • SELECT_SQL_TRACE Function
  • SELECT_SQLSET Function
  • SELECT_WORKLOAD_REPOSITORY Functions
  • SET_AUTO_TUNING_TASK_PARAMETER Procedures
  • SET_TUNING_TASK_PARAMETER Procedures
  • SQLTEXT_TO_SIGNATURE Function
  • UNPACK_STGTAB_SQLPROF Procedure
  • UNPACK_STGTAB_SQLSET Procedure
  • UPDATE_SQLSET Procedures

137 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

138 DBMS_STATS

• Using DBMS_STATS
  • Overview
  • Types
  • Constants
  • Operational Notes
  • Deprecated Subprograms
  • Examples
• Summary of DBMS_STATS Subprograms
  • ALTER_STATS_HISTORY_RETENTION Procedure
  • CONVERT_RAW_VALUE Procedures
  • CONVERT_RAW_VALUE_NVARCHAR Procedure
  • CONVERT_RAW_VALUE_ROWID Procedure
  • COPY_TABLE_STATS Procedure
  • 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_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_EXTENDED_STATS Procedure
  • DROP_STAT_TABLE Procedure
  • 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_SCHEMA_STATS Procedures
  • GATHER_SYSTEM_STATS Procedure
  • GATHER_TABLE_STATS Procedure
  • GENERATE_STATS Procedure
  • 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
  • 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
  • LOCK_PARTITION_STATS Procedure
  • LOCK_SCHEMA_STATS Procedure
  • LOCK_TABLE_STATS Procedure
  • PREPARE_COLUMN_VALUES Procedures
  • PREPARE_COLUMN_VALUES_NVARCHAR2 Procedure
  • PREPARE_COLUMN_VALUES_ROWID Procedure
  • PUBLISH_PENDING_STATS Procedure
  • PURGE_STATS 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
  • SET_COLUMN_STATS Procedures
  • SET_DATABASE_PREFS Procedure
  • SET_GLOBAL_PREFS Procedure
  • SET_INDEX_STATS Procedures
  • SET_PARAM Procedure
  • SET_SCHEMA_PREFS Procedure
  • SET_SYSTEM_STATS Procedure
  • SET_TABLE_PREFS Procedure
  • SET_TABLE_STATS Procedure
  • SHOW_EXTENDED_STATS_NAME Function
  • UNLOCK_PARTITION_STATS Procedure
  • UNLOCK_SCHEMA_STATS Procedure
  • UNLOCK_TABLE_STATS Procedure
  • UPGRADE_STAT_TABLE Procedure

139 DBMS_STORAGE_MAP

• Using DBMS_STORAGE_MAP
  • Overview
  • 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

140 DBMS_STREAMS

• Using DBMS_STREAMS
  • Security Model
• Summary of DBMS_STREAMS Subprograms
  • 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

141 DBMS_STREAMS_ADM

• Using DBMS_STREAMS_ADM
  • Overview
  • Deprecated Subprograms
  • Security Model
  • Operational Notes
• 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

142 DBMS_STREAMS_ADVISOR_ADM

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

143 DBMS_STREAMS_AUTH

• Summary of DBMS_STREAMS_AUTH Subprograms
  • GRANT_ADMIN_PRIVILEGE Procedure
  • GRANT_REMOTE_ADMIN_ACCESS Procedure
  • REVOKE_ADMIN_PRIVILEGE Procedure
  • REVOKE_REMOTE_ADMIN_ACCESS Procedure

144 DBMS_STREAMS_HANDLER_ADM

• Using DBMS_STREAMS_HANDLER_ADM
  • Overview
  • Views
  • 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

145 DBMS_STREAMS_MESSAGING

• Summary of DBMS_STREAMS_MESSAGING Subprograms
  • DEQUEUE Procedure
  • ENQUEUE Procedure

146 DBMS_STREAMS_TABLESPACE_ADM

• Using DBMS_STREAMS_TABLESPACE_ADM
  • Overview
• 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

147 DBMS_TDB

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

148 DBMS_TRACE

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

149 DBMS_TRANSACTION

• Using DBMS_TRANSACTION
  • Security Model
• Summary of DBMS_TRANSACTION Subprograms
  • ADVISE_COMMIT Procedure
  • ADVISE_NOTHING Procedure
  • ADVISE_ROLLBACK Procedure
  • BEGIN_DISCRETE_TRANSACTION 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

150 DBMS_TRANSFORM

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

151 DBMS_TTS

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

152 DBMS_TYPES

• Using DBMS_TYPES
  • Constants
  • Exceptions

153 DBMS_UTILITY

• Using DBMS_UTILITY
  • Security Model
  • Constants
  • Exceptions
• Data Structures
  • INSTANCE_RECORD Record Type
  • DBLINK_ARRAY Table Type
  • INDEX_TABLE_TYPE Table Type
  • INSTANCE_TABLE Table Type
  • LNAME_ARRAY Table Type
  • NAME_ARRAY Table Type
  • NUMBER_ARRAY Table Type
  • 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
  • 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
  • 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 Procedure

154 DBMS_WARNING

• Using 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

155 DBMS_WM

• Documentation of DBMS_WM

156 DBMS_WORKLOAD_CAPTURE

• Using DBMS_WORKLOAD_CAPTURE
  • Overview
  • 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
  • PROCESS_CAPTURE Procedure
  • REPORT Function
  • START_CAPTURE Procedure

157 DBMS_WORKLOAD_REPLAY

• Using DBMS_WORKLOAD_REPLAY
  • Security Model
• Summary of DBMS_WORKLOAD_REPLAY Subprograms
  • ADD_FILTER Procedure
  • CALIBRATE Function
  • CANCEL_REPLAY Procedure
  • COMPARE_PERIOD_REPORT Procedure
  • CREATE_FILTER_SET Procedure
  • DELETE_FILTER Procedure
  • DELETE_REPLAY_INFO Procedure
  • EXPORT_AWR Procedure
  • GET_DIVERGING_STATEMENT Function
  • GET_REPLAY_INFO Function
  • IMPORT_AWR Function
  • INITIALIZE_REPLAY Procedure
  • IS_REPLAY_PAUSED Function
  • PAUSE_REPLAY Procedure
  • POPULATE_DIVERGENCE Procedure
  • PREPARE_REPLAY Procedure
  • PROCESS_CAPTURE Procedure
  • REMAP_CONNECTION Procedure
  • REPORT Function
  • RESUME_REPLAY Procedure
  • SET_ADVANCED_PARAMETER Procedure
  • START_REPLAY Procedure
  • USE_FILTER_SET Procedure

158 DBMS_WORKLOAD_REPOSITORY

• Using DBMS_WORKLOAD_REPOSITORY
  • Examples
• Data Structures
  • AWR_BASELINE_METRIC_TYPE Object Type
  • AWR_BASELINE_METRIC_TYPE_TABLE Table Type
  • 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_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_SQL_REPORT_HTML Function
  • AWR_SQL_REPORT_TEXT Function
  • CREATE_BASELINE Functions & Procedures
  • CREATE_BASELINE_TEMPLATE Procedures
  • CREATE_SNAPSHOT Function and Procedure
  • DROP_BASELINE Procedure
  • DROP_BASELINE_TEMPLATE Procedure
  • DROP_SNAPSHOT_RANGE Procedure
  • MODIFY_SNAPSHOT_SETTINGS Procedures
  • MODIFY_BASELINE_WINDOW_SIZE Procedure
  • REMOVE_COLORED_SQL Procedure
  • RENAME_BASELINE Procedure
  • SELECT_BASELINE_METRICS Function

159 DBMS_XA

• Using DBMS_XA
  • Overview
  • Security Model
  • Constants
  • Operational Notes
• Data Structures
  • DBMS_XA_XID Object Type
  • 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

160 DBMS_XDB

• Using DBMS_XDB
  • Overview
  • Constants
• Summary of DBMS_XDB Subprograms
  • ACLCHECKPRIVILEGES Function
  • ADDMIMEMAPPING Procedure
  • ADDSCHEMALOCMAPPING Procedure
  • ADDSERVLET Procedure
  • ADDSERVLETMAPPING Procedure
  • ADDSERVLETSECROLE Procedure
  • ADDXMLEXTENSION Procedure
  • APPENDPATH Procedure
  • APPENDRESOURCEMETADATA Procedure
  • CFG_GET Function
  • CFG_REFRESH Procedure
  • CFG_UPDATE Procedure
  • CHANGEOWNER Procedure
  • CHANGEPRIVILEGES Function
  • CHECKPRIVILEGES Function
  • CREATEFOLDER Function
  • CREATEOIDPATH Function
  • CREATERESOURCE Functions
  • DELETEMIMEMAPPING Procedure
  • DELETERESOURCE Procedure
  • DELETERESOURCEMETADATA Procedures
  • DELETESCHEMALOCMAPPING Procedure
  • DELETESERVLET Procedure
  • DELETESERVLETMAPPING Procedure
  • DELETESERVLETSECROLE Procedure
  • DELETEXMLEXTENSION Procedure
  • EXISTSRESOURCE Function
  • GETACLDOCUMENT Function
  • GETCHILDRESPATHS Function
  • GETCONTENTBLOB Function
  • GETCONTENTCLOB Function
  • GETCONTENTVARCHAR2 Function
  • GETCONTENTXMLREF Function
  • GETCONTENTXMLTYPE Function
  • GETFTPPORT Function
  • GETHTTPPORT 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
  • MOVEXDB_TABLESPACE Procedure
  • PROCESSLINKS Procedure
  • PURGERESOURCEMETADATA Procedure
  • REBUILDHIERARCHICALINDEX Procedure
  • RENAMERESOURCE Procedure
  • SETACL Procedure
  • SETCONTENT Procedures
  • SETFTPPORT Procedure
  • SETHTTPPORT Procedure
  • SETLISTENERENDPOINT Procedure
  • SETLISTENERLOCALACCESS Procedure
  • SPLITPATH Procedure
  • TOUCHRESOURCE Procedure
  • UPDATERESOURCEMETADATA Procedures
  • UNLOCKRESOURCE Function

161 DBMS_XDB_ADMIN

• Summary of DBMS_XDB_ADMIN Subprograms
  • CREATEREPOSITORYXMLINDEX Procedure
  • DROPREPOSITORYXMLINDEX Procedure
  • XMLINDEXADDPATH Procedure
  • XMLINDEXREMOVEPATH Procedure

162 DBMS_XDB_VERSION

• 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

163 DBMS_XDBRESOURCE

• Using DBMS_XDBRESOURCE
  • Overview
• 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

164 DBMS_XDBT

• Using DBMS_XDBT
  • Overview
  • 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

165 DBMS_XDBZ

• Using DBMS_XDBZ
  • Constants
• Summary of DBMS_XDBZ Subprograms
  • DISABLE_HIERARCHY Procedure
  • ENABLE_HIERARCHY Procedure
  • GET_ACLOID Function
  • GET_USERID Function
  • IS_HIERARCHY_ENABLED Function
  • PURGELDAPCACHE Function

166 DBMS_XEVENT

• Using DBMS_XEVENT
  • Constants
• Subprogram Groups
  • XDBEvent Type Subprograms
  • XDBRepositoryEvent Type Subprograms
  • XDBHandlerList Type Subprograms
  • XDBHandler Type Subprograms
  • XDBPath Type Subprograms
  • 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

167 DBMS_XMLDOM

• Using DBMS_XMLDOM
  • Overview
  • Constants
  • Types
  • Exceptions
• Subprogram Groups
  • DOMNode Subprograms
  • DOMAttr Subprograms
  • DOMCDataSection Subprograms
  • DOMCharacterData Subprograms
  • DOMComment Subprograms
  • DOMDocument Subprograms
  • DOMDocumentFragment Subprograms
  • DOMDocumentType Subprograms
  • DOMElement Subprograms
  • DOMEntity Subprograms
  • DOMEntityReference Subprograms
  • DOMImplementation Subprograms
  • DOMNamedNodeMap Subprograms
  • DOMNodeList Subprograms
  • DOMNotation Subprograms
  • DOMProcessingInstruction Subprograms
  • 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
  • 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
  • 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

168 DBMS_XMLGEN

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

169 DBMS_XMLINDEX

• Using DBMS_XMLINDEX
  • Overview
• Summary of DBMS_XMLINDEX Subprograms
  • CREATEDATEINDEX Procedure
  • CREATENUMBERINDEX Procedure
  • DROPPARAMETER Procedure
  • MODIFYPARAMETER Procedure
  • REGISTERPARAMETER Procedure
  • SYNCINDEX Procedure

170 DBMS_XMLPARSER

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

171 DBMS_XMLQUERY

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

172 DBMS_XMLSAVE

• Using 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

173 DBMS_XMLSCHEMA

• Using DBMS_XMLSCHEMA
  • Overview
  • Constants
  • Views
  • 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

174 DBMS_XMLSTORE

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

175 DBMS_XMLTRANSLATIONS

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

176 DBMS_XPLAN

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

177 DBMS_XSLPROCESSOR

• Using DBMS_XSLPROCESSOR
  • Overview
• 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

178 DEBUG_EXTPROC

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

179 HTF

• Using HTF
  • Operational Notes
  • Rules and Limits
  • 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

180 HTP

• Using HTP
  • Operational Notes
  • Rules and Limits
  • Examples
• 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

181 ORD_DICOM

• Documentation of ORD_DICOM

182 ORD_DICOM_ADMIN

• Documentation of ORD_DICOM_ADMIN

183 OWA_CACHE

• Using 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

184 OWA_COOKIE

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

185 OWA_CUSTOM

• Using OWA_CUSTOM
  • Constants
• Summary of OWA_CUSTOM Subprograms
  • AUTHORIZE Function

186 OWA_IMAGE

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

187 OWA_OPT_LOCK

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

188 OWA_PATTERN

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

189 OWA_SEC

• Using 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

190 OWA_TEXT

• Using OWA_TEXT
  • Types
• Summary of OWA_TEXT Subprograms
  • ADD2MULTI Procedure
  • NEW_ROW_LIST Function and Procedure
  • PRINT_MULTI Procedure
  • PRINT_ROW_LIST Procedure
  • STREAM2MULTI Procedure

191 OWA_UTIL

• Using OWA_UTIL
  • Overview
  • Types
• 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

192 SDO_CS

• Documentation of SDO_CS

193 SDO_CSW_PROCESS

• Documentation of SDO_CSW_PROCESS

194 SDO_GCDR

• Documentation of SDO_GCDR

195 SDO_GEOM

• Documentation of SDO_GEOM

196 SDO_GEOR

• Documentation of SDO_GEOR

197 SDO_GEOR_ADMIN

• Documentation of SDO_GEOR_ADMIN

198 SDO_GEOR_UTL

• Documentation of SDO_GEOR_UTL

199 SDO_LRS

• Documentation of SDO_LRS

200 SDO_MIGRATE

• Documentation of SDO_MIGRATE

201 SDO_NET

• Documentation of SDO_NET

202 SDO_NET_MEM

• Documentation of SDO_NET_MEM

203 SDO_OLS

• Documentation of SDO_OLS

204 SDO_PC_PKG

• Documentation of SDO_PC_PKG

205 SDO_SAM

• Documentation of SDO_SAM

206 SDO_TIN_PKG

• Documentation of SDO_TIN_PKG

207 SDO_TOPO

• Documentation of SDO_TOPO

208 SDO_TOPO_MAP

• Documentation of SDO_TOPO_MAP

209 SDO_TUNE

• Documentation of SDO_TUNE

210 SDO_UTIL

• Documentation of SDO_UTIL

211 SDO_WFS_LOCK

• Documentation of SDO_WFS_LOCK

212 SDO_WFS_PROCESS

• Documentation of SDO_WFS_PROCESS

213 SEM_APIS

• Documentation of SEM_APIS

214 SEM_PERF

• Documentation of SEM_PERF

215 SEM_RDFCTX

• Documentation of SEM_RDFCTX

216 SEM_RDFSA

• Documentation of SEM_RDFSA

217 UTL_COLL

• Summary of UTL_COLL Subprograms
  • IS_LOCATOR Function

218 UTL_COMPRESS

• Using UTL_COMPRESS
  • Constants
  • Exceptions
  • 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

219 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

220 UTL_FILE

• Using UTL_FILE
  • Security Model
  • Operational Notes
  • Rules and Limits
  • Exceptions
  • Examples
• 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 Function
  • 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 Function

221 UTL_HTTP

• Using UTL_HTTP
  • Overview
  • Security Model
  • Constants
  • Datatypes
  • Operational Notes
  • Exceptions
  • Examples
• Subprogram Groups
  • Simple HTTP Fetches in a Single Call Subprograms
  • Session Settings Subprograms
  • HTTP Requests Subprograms
  • HTTP Request Contexts Subprograms
  • HTTP Responses Subprograms
  • HTTP Cookies Subprograms
  • HTTP Persistent Connections Subprograms
  • 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

222 UTL_I18N

• Using UTL_I18N
  • Overview
  • 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_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

223 UTL_INADDR

• Using UTL_INADDR
  • Exceptions
  • Examples
• Summary of UTL_INADDR Subprograms
  • GET_HOST_ADDRESS Function
  • GET_HOST_NAME Function

224 UTL_IDENT

• Using UTL_IDENT
  • Overview
  • Security Model
  • Constants

225 UTL_LMS

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

226 UTL_MAIL

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

227 UTL_MATCH

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

228 UTL_NLA

• Using UTL_NLA
  • Overview
  • Rules and Limits
• Subprogram Groups
  • BLAS Level 1 (Vector-Vector Operations) Subprograms
  • BLAS Level 2 (Matrix-Vector Operations) Subprograms
  • BLAS Level 3 (Matrix-Matrix Operations) Subprograms
  • LAPACK Driver Routines (Linear Equations) Subprograms
  • 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 Procedures
  • LAPACK_GESVD Procedures
  • LAPACK_GEEV Procedures
  • LAPACK_GTSV Procedures
  • 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

229 UTL_RAW

• Using UTL_RAW
  • Overview
  • 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_RAW Function
  • CAST_TO_VARCHAR2 Function
  • CAST_TO_NVARCHAR2 Function
  • COMPARE Function
  • CONCAT Function
  • CONVERT Function
  • COPIES Function
  • LENGTH Function
  • OVERLAY Function
  • REVERSE Function
  • SUBSTR Function
  • TRANSLATE Function
  • TRANSLITERATE Function
  • XRANGE Function

230 UTL_RECOMP

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

231 UTL_REF

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

232 UTL_SMTP

• Using UTL_SMTP
  • Overview
  • Security Model
  • Types
  • Reply Codes
  • Exceptions
  • Rules and Limits
  • Examples
• Summary of UTL_SMTP Subprograms
  • 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
  • VRFY Function
  • WRITE_DATA Procedure
  • WRITE_RAW_DATA Procedure

233 UTL_SPADV

• Using UTL_SPADV
  • Overview
  • Operational Notes
• Summary of UTL_SPADV Subprograms
  • ALTER_MONITORING Procedure
  • COLLECT_STATS Procedure
  • IS_MONITORING Function
  • SHOW_STATS Procedure
  • START_MONITORING Procedure
  • STOP_MONITORING Procedure

234 UTL_TCP

• Using UTL_TCP
  • Overview
  • Security Model
  • Types
  • Exceptions
  • Rules and Limits
  • 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
  • WRITE_LINE Function
  • WRITE_RAW Function
  • WRITE_TEXT Function

235 UTL_URL

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

236 WPG_DOCLOAD

• Using WPG_DOCLOAD
  • Constants
• Summary of WPG_DOCLOAD Subprograms
  • DOWNLOAD_FILE Procedures

237 ANYDATA TYPE

• Using ANYDATA TYPE
  • Restrictions
  • 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

238 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

239 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

240 Oracle Streams 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
  • SYS.MSG_PROP_T Type
  • MESSAGE_PROPERTIES_T Type
  • MESSAGE_PROPERTIES_ARRAY_T Type
  • MSGID_ARRAY_T Type

241 DBFS Content Interface Types

• Using Content Types
  • Overview
  • Security Model
• 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

242 Database URI TYPEs

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

243 JMS Types

• Using JMS Types
  • Overview
  • Java Versus PL/SQL Data Types
  • 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_NAMESARRAY Type
  • SYS.AQ$_JMS_VALUE Type
  • SYS.AQ$_JMS_EXCEPTION Type

244 Expression Filter Types

• Summary of Expression Filter Types
  • EXF$ATTRIBUTE
  • EXF$ATTRIBUTE_LIST
  • EXF$INDEXOPER
  • EXF$TABLE_ALIAS
  • EXF$TEXT
  • EXF$XPATH_TAG
  • EXF$XPATH_TAGS

245 Logical Change Record TYPEs

• 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

246 Oracle Multimedia ORDAudio TYPE

• Documentation of ORDAudio

247 Oracle Multimedia ORDDicom TYPE

• Documentation of ORDDicom

248 Oracle Multimedia ORDDoc TYPE

• Documentation of ORDDoc

249 Oracle Multimedia ORDImage TYPE

• Documentation of ORDImage

250 Oracle Multimedia SQL/MM Still Image TYPES

• Documentation of SQL/MM Still Image

251 Oracle Multimedia ORDVideo TYPE

• Documentation of ORDVideo

252 MGD_ID Package Types

• 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

253 Rule TYPEs

• 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$TABLE_ALIAS Type
  • RE$TABLE_ALIAS_LIST Type
  • RE$TABLE_VALUE Type
  • RE$TABLE_VALUE_LIST Type
  • RE$VARIABLE_TYPE Type
  • RE$VARIABLE_TYPE_LIST Type
  • RE$VARIABLE_VALUE Type
  • RE$VARIABLE_VALUE_LIST Type

254 Rules Manager Types

• Summary of Rule Manager Types
  • RLM$EVENTIDS Object Type

255 UTL Streams Types

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

256 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