Contents

Title and Copyright Information

Preface

Documentation Accessibility

Related Documents

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

Oracle Database 11g Release 1 (11.1)

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

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_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

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

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

Operational Notes

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

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

Summary of DBMS_APPLY_ADM Subprograms

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

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

Data Structures

Operational Notes

Summary of DBMS_AQ Subprograms

BIND_AGENT Procedure

DEQUEUE Procedure

DEQUEUE_ARRAY Function

ENQUEUE Procedure

ENQUEUE_ARRAY Function

LISTEN Procedures

REGISTER Procedure

UNBIND_AGENT Procedure

UNREGISTER Procedure

22 DBMS_AQADM

Using DBMS_AQADM

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

25 DBMS_ASSERT

Using DBMS_ASSERT

Operational Notes

Summary of DBMS_ASSERT Subprograms

ENQUOTE_LITERAL Function

ENQUOTE_NAME Function

QUALIFIED_SQL_NAME Function

SCHEMA_NAME Function

SIMPLE_SQL_NAME Function

SQL_OBJECT_NAME Function

26 DBMS_AUTO_TASK_ADMIN

Using DBMS_AUTO_TASK_ADMIN

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

27 DBMS_AW_STATS

Using DBMS_AW_STATS

Summary of DBMS_AW_STATS Subprograms

ANALYZE Procedure

28 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

29 DBMS_CDC_PUBLISH

Using DBMS_CDC_PUBLISH

Deprecated Subprograms

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

30 DBMS_CDC_SUBSCRIBE

Using DBMS_CDC_SUBSCRIBE

Deprecated Subprograms

Summary of DBMS_CDC_SUBSCRIBE Subprograms

ACTIVATE_SUBSCRIPTION Procedure

CREATE_SUBSCRIPTION Procedure

DROP_SUBSCRIPTION Procedure

EXTEND_WINDOW Procedure

PURGE_WINDOW Procedure

SUBSCRIBE Procedure

31 DBMS_COMPARISON

Using DBMS_COMPARISON

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

32 DBMS_CONNECTION_POOL

Summary of DBMS_CONNECTION_POOL Subprograms

ALTER_PARAM Procedure

CONFIGURE_POOL Procedure

START_POOL Procedure

STOP_POOL Procedure

RESTORE_DEFAULTS Procedure

33 DBMS_CQ_NOTIFICATION

Using DBMS_CQ_NOTIFICATION

Operational Notes

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

34 DBMS_CRYPTO

Using the DBMS_CRYPTO Subprograms

Operational Notes

Summary of DBMS_CRYPTO Subprograms

DECRYPT Function

DECRYPT Procedures

ENCRYPT Function

ENCRYPT Procedures

RANDOMBYTES Function

RANDOMINTEGER Function

RANDOMNUMBER Function

35 DBMS_CSX_ADMIN

Using DBMS_CSX_ADMIN

Summary of DBMS_CSX_ADMIN

COPYDEFAULTTOKENTABLESET Procedure

GETTOKENTABLEINFO Procedure & Function

GETTOKENTABLEINFOBYTABLESPACE Procedure

NAMESPACEIDTABLE Function

PATHIDTABLE Function

QNAMEIDTABLE Function

REGISTERTOKENTABLESET Procedure

36 DBMS_CUBE

Using DBMS_CUBE

Summary of DBMS_CUBE Subprograms

BUILD Procedure

IMPORT_XML Procedure

VALIDATE_XML Procedure

37 DBMS_CUBE_ADVISE

Summary of DBMS_CUBE_ADVISE Subprograms

MV_CUBE_ADVICE Function

SET_CNS_EXCEPTION_LOG Procedure

TRACE Procedure

38 DBMS_DATA_MINING

Using DBMS_DATA_MINING

Mining Model Objects

Deprecated Subprograms

Mining Function Constants

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

39 DBMS_DATA_MINING_TRANSFORM

Using DBMS_DATA_MINING_TRANSFORM

Data Transformation with Oracle Data Mining

Types of Transformations

The DBMS_DATA_MINING_TRANSFORM Framework

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

40 DBMS_DATAPUMP

Using DBMS_DATAPUMP

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

SET_PARALLEL Procedure

SET_PARAMETER Procedures

START_JOB Procedure

STOP_JOB Procedure

WAIT_FOR_JOB Procedure

41 DBMS_DB_VERSION

Using DBMS_DB_VERSION

42 DBMS_DDL

Deprecated Subprograms

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 Procedure

43 DBMS_DEBUG

Using DBMS_DEBUG

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

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

44 DBMS_DEFER

Documentation of DBMS_DEFER

45 DBMS_DEFER_QUERY

Documentation of DBMS_DEFER_QUERY

46 DBMS_DEFER_SYS

Documentation of DBMS_DEFER_SYS

47 DBMS_DESCRIBE

Using DBMS_DESCRIBE

Summary of DBMS_DESCRIBE Subprograms

DESCRIBE_PROCEDURE Procedure

48 DBMS_DG

Summary of the DBMS_DG Subprogram

INITIATE_FS_FAILOVER Procedure

49 DBMS_DIMENSION

Using DBMS_DIMENSION

Summary of DBMS_DIMENSION Subprograms

DESCRIBE_DIMENSION Procedure

VALIDATE_DIMENSION Procedure

50 DBMS_DISTRIBUTED_TRUST_ADMIN

Using DBMS_DISTRIBUTED_TRUST_ADMIN

Summary of DBMS_DISTRIBUTED_TRUST_ADMIN Subprograms

ALLOW_ALL Procedure

ALLOW_SERVER Procedure

DENY_ALL Procedure

DENY_SERVER Procedure

51 DBMS_EPG

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

52 DBMS_ERRLOG

Using DBMS_ERRLOG

Summary of DBMS_ERRLOG Subprograms

CREATE_ERROR_LOG Procedure

53 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

54 DBMS_FGA

Operational Notes

Summary of DBMS_FGA Subprograms

ADD_POLICY Procedure

DISABLE_POLICY Procedure

DROP_POLICY Procedure

ENABLE_POLICY Procedure

55 DBMS_FILE_GROUP

Using DBMS_FILE_GROUP

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

56 DBMS_FILE_TRANSFER

Using DBMS_FILE_TRANSFER

Operating Notes

Summary of DBMS_FILE_TRANSFER Subprograms

COPY_FILE Procedure

GET_FILE Procedure

PUT_FILE Procedure

57 DBMS_FLASHBACK

Using DBMS_FLASHBACK

Operational Notes

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

58 DBMS_FREQUENT_ITEMSET

Summary of DBMS_FREQUENT_ITEMSET Subprograms

FI_HORIZONTAL Function

FI_TRANSACTIONAL Function

59 DBMS_HM

Summary of DBMS_HM Subprograms

GET_RUN_REPORT Function

RUN_CHECK Procedure

60 DBMS_HPROF

Summary of DBMS_HPROF Subprograms

ANALYZE Function

START_PROFILING Procedure

STOP_PROFILING Procedure

61 DBMS_HS_PARALLEL

Using LOAD_TABLE

CREATE_TABLE_TEMPLATE

CREATE_OR_REPLACE_VIEW

Using CREATE_OR_REPLACE_VIEW

62 DBMS_HS_PASSTHROUGH

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

63 DBMS_JAVA

Documentation of DBMS_JAVA

64 DBMS_IOT

Summary of DBMS_IOT Subprograms

BUILD_CHAIN_ROWS_TABLE Procedure

BUILD_EXCEPTIONS_TABLE Procedure

65 DBMS_JOB

Operational Notes

Summary of DBMS_JOB Subprograms

BROKEN Procedure

CHANGE Procedure

INSTANCE Procedure

INTERVAL Procedure

NEXT_DATE Procedure

REMOVE Procedure

SUBMIT Procedure

USER_EXPORT Procedures

66 DBMS_LDAP

Documentation of DBMS_LDAP

67 DBMS_LDAP_UTL

Documentation of DBMS_LDAP_UTL

68 DBMS_LIBCACHE

Using DBMS_LIBCACHE

Summary of DBMS_LIBCACHE Subprograms

COMPILE_FROM_REMOTE Procedure

69 DBMS_LOB

Rules and Limits

Operational Notes

Summary of DBMS_LOB Subprograms

APPEND Procedures

CLOSE Procedure

COMPARE Functions

CONVERTTOBLOB Procedure

CONVERTTOCLOB Procedure

COPY 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_STORAGE_LIMIT Function

GETCHUNKSIZE Functions

GETLENGTH Functions

GETOPTIONS Functions

INSTR Functions

ISOPEN Functions

ISTEMPORARY Functions

LOADBLOBFROMFILE Procedure

LOADCLOBFROMFILE Procedure

LOADFROMFILE Procedure

OPEN Procedures

READ Procedures

SETOPTIONS Procedures

SUBSTR Functions

TRIM Procedures

WRITE Procedures

WRITEAPPEND Procedures

70 DBMS_LOCK

Using DBMS_LOCK

Rules and Limits

Operational Notes

Summary of DBMS_LOCK Subprograms

ALLOCATE_UNIQUE Procedure

CONVERT Function

RELEASE Function

REQUEST Function

SLEEP Procedure

71 DBMS_LOGMNR

Using DBMS_LOGMNR

Operational Notes

Summary of DBMS_LOGMNR Subprograms

ADD_LOGFILE Procedure

COLUMN_PRESENT Function

END_LOGMNR Procedure

MINE_VALUE Function

REMOVE_LOGFILE Procedure

START_LOGMNR Procedure

72 DBMS_LOGMNR_D

Using DBMS_LOGMNR_D

Summary of DBMS_LOGMNR_D Subprograms

BUILD Procedure

SET_TABLESPACE Procedure

73 DBMS_LOGSTDBY

Using DBMS_LOGSTDBY

Operational Notes

Summary of DBMS_LOGSTDBY Subprograms

APPLY_SET Procedure

APPLY_UNSET Procedure

BUILD Procedure

INSTANTIATE_TABLE Procedure

MAP_PRIMARY_SCN Function

PREPARE_FOR_NEW_PRIMARY Procedure

PURGE_SESSION Procedure

REBUILD Procedure

SET_TABLESPACE Procedure

SKIP_ERROR Procedure

SKIP_TRANSACTION Procedure

UNSKIP Procedure

UNSKIP_ERROR Procedure

UNSKIP_TRANSACTION Procedure

74 DBMS_METADATA

Using DBMS_METADATA

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

SET_COUNT Procedure

SET_FILTER Procedure

SET_PARSE_ITEM Procedure

SET_TRANSFORM_PARAM and SET_REMAP_PARAM Procedures

75 DBMS_MGD_ID_UTL

Using DBMS_MGD_ID_UTL

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

76 DBMS_MGWADM

Using DBMS_MGWADM

Deprecated Subprograms

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

77 DBMS_MGWMSG

Using DBMS_MGWMSG

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

78 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

79 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

80 DBMS_NETWORK_ACL_ADMIN

Using DBMS_NETWORK_ACL_ADMIN

Summary of DBMS_NETWORK_ACL_ADMIN Subprograms

ADD_PRIVILEGE Procedure

ASSIGN_ACL Procedure

CHECK_PRIVILEGE Function

CHECK_PRIVILEGE_ACLID Function

CREATE_ACL Procedure

DELETE_PRIVILEGE Procedure

DROP_ACL Procedure

UNASSIGN_ACL Procedure

81 DBMS_NETWORK_ACL_UTILITY

Using DBMS_NETWORK_ACL_UTILITY

Summary of DBMS_NETWORK_ACL_UTILITY Subprograms

DOMAIN_LEVEL Function

DOMAINS Function

82 DBMS_OBFUSCATION_TOOLKIT

Using DBMS_OBFUSCATION_TOOLKIT

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

83 DBMS_ODCI

Summary of DBMS_ODCI Subprograms

ESTIMATE_CPU_UNITS Function

84 DBMS_OFFLINE_OG

Documentation of DBMS_OFFLINE_OG

85 DBMS_OUTLN

Using DBMS_OUTLN

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

86 DBMS_OUTLN_EDIT

Summary of DBMS_OUTLN_EDIT Subprograms

CHANGE_JOIN_POS Procedure

CREATE_EDIT_TABLES Procedure

DROP_EDIT_TABLES Procedure

GENERATE_SIGNATURE Procedure

REFRESH_PRIVATE_OUTLINE Procedure

87 DBMS_OUTPUT

Using DBMS_OUTPUT

Operational Notes

Rules and Limits

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_LINE Procedure

88 DBMS_PCLXUTIL

Using DBMS_PCLXUTIL

Operational Notes

Rules and Limits

Summary of DBMS_PCLXUTIL Subprograms

BUILD_PART_INDEX Procedure

89 DBMS_PIPE

Using DBMS_PIPE

Operational Notes

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

90 DBMS_PREDICTIVE_ANALYTICS

Using DBMS_PREDICTIVE_ANALYTICS

Summary of DBMS_PREDICTIVE_ANALYTICS Subprograms

EXPLAIN Procedure

PREDICT Procedure

PROFILE Procedure

91 DBMS_PREPROCESSOR

Using DBMS_PREPROCESSOR

Operating Notes

Data Structures

SOURCE_LINES_T Table Type

Summary of DBMS_PREPROCESSOR Subprograms

GET_POST_PROCESSED_SOURCE Functions

PRINT_POST_PROCESSED_SOURCE Procedures

92 DBMS_PROFILER

Using DBMS_PROFILER

Operational Notes

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

93 DBMS_PROPAGATION_ADM

Summary of DBMS_PROPAGATION_ADM Subprograms

ALTER_PROPAGATION Procedure

CREATE_PROPAGATION Procedure

DROP_PROPAGATION Procedure

START_PROPAGATION Procedure

STOP_PROPAGATION Procedure

94 DBMS_RANDOM

Using DBMS_RANDOM

Operational Notes

Summary of DBMS_RANDOM Subprograms

INITIALIZE Procedure

NORMAL Function

RANDOM Procedure

SEED Procedures

STRING Function

TERMINATE Procedure

VALUE Functions

95 DBMS_RECTIFIER_DIFF

Documentation of DBMS_RECTIFIER_DIFF

96 DBMS_REDEFINITION

Using DBMS_REDEFINITION

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

97 DBMS_REFRESH

Documentation of DBMS_REFRESH

98 DBMS_REPAIR

Using DBMS_REPAIR

Operating Notes

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

99 DBMS_REPCAT

Documentation of DBMS_REPCAT

100 DBMS_REPCAT_ADMIN

Documentation of DBMS_REPCAT_ADMIN

101 DBMS_REPCAT_INSTANTIATE

Documentation of DBMS_REPCAT_INSTANTIATE

102 DBMS_REPCAT_RGT

Documentation of DBMS_REPCAT_RGT

103 DBMS_REPUTIL

Documentation of DBMS_REPUTIL

104 DBMS_RESCONFIG

Using DBMS_RESCONFIG

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

105 DBMS_RESOURCE_MANAGER

Using DBMS_RESOURCE_MANAGER

Deprecated Subprograms

Summary of DBMS_RESOURCE_MANAGER Subprograms

CALIBRATE_IO Procedure

CLEAR_PENDING_AREA Procedure

CREATE_CONSUMER_GROUP Procedure

CREATE_PENDING_AREA Procedure

CREATE_PLAN Procedure

CREATE_PLAN_DIRECTIVE Procedure

CREATE_SIMPLE_PLAN 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_CONSUMER_GROUP Procedure

UPDATE_PLAN Procedure

UPDATE_PLAN_DIRECTIVE Procedure

VALIDATE_PENDING_AREA Procedure

106 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

107 DBMS_RESULT_CACHE

Using DBMS_RESULT_CACHE

Summary of DBMS_RESULT_CACHE Subprograms

BYPASS Procedure

FLUSH Function & Procedure

INVALIDATE Functions & Procedures

INVALIDATE_OBJECT Functions & Procedures

MEMORY_REPORT Procedure

STATUS Function

108 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

109 DBMS_RLMGR

Summary of Rules Manager Subprograms

ADD_ELEMENTARY_ATTRIBUTE Procedures

ADD_EVENT Procedures

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

110 DBMS_RLS

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

111 DBMS_ROWID

Using DBMS_ROWID

Operational Notes

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

112 DBMS_RULE

Using DBMS_RULE

Summary of DBMS_RULE Subprograms

CLOSE_ITERATOR Procedure

EVALUATE Procedures

GET_NEXT_HIT Function

113 DBMS_RULE_ADM

Using DBMS_RULE_ADM

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

114 DBMS_SCHEDULER

Data Structures

JOBARG Object Type

JOBARG_ARRAY Table Type

JOB Object Type

JOB_ARRAY Table Type

JOBATTR Object Type

JOBATTR_ARRAY Table Type

SCHEDULER$_STEP_TYPE Object Type

SCHEDULER$_STEP_TYPE_LIST Table Type

Using DBMS_SCHEDULER

Rules and Limits

Operational Notes

Summary of DBMS_SCHEDULER Subprograms

ADD_EVENT_QUEUE_SUBSCRIBER 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_EVENT_SCHEDULE Procedure

CREATE_JOB Procedures

CREATE_JOB_CLASS Procedure

CREATE_JOBS Procedure

CREATE_PROGRAM Procedure

CREATE_SCHEDULE Procedure

CREATE_WINDOW Procedures

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 Procedures

DISABLE Procedure

DROP_CHAIN Procedure

DROP_CHAIN_RULE Procedure

DROP_CHAIN_STEP Procedure

DROP_CREDENTIAL Procedure

DROP_JOB Procedure

DROP_JOB_CLASS Procedure

DROP_PROGRAM Procedure

DROP_PROGRAM_ARGUMENT Procedures

DROP_SCHEDULE Procedure

DROP_WINDOW Procedure

DROP_WINDOW_GROUP Procedure

ENABLE 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_WINDOW_GROUP_MEMBER Procedure

RESET_JOB_ARGUMENT_VALUE Procedures

RUN_CHAIN Procedures

RUN_JOB Procedure

SET_AGENT_REGISTRATION_PASS Procedure

SET_ATTRIBUTE Procedure

SET_ATTRIBUTE_NULL Procedure

SET_JOB_ANYDATA_VALUE Procedures

SET_JOB_ARGUMENT_VALUE Procedures

SET_JOB_ATTRIBUTES Procedure

SET_SCHEDULER_ATTRIBUTE Procedure

STOP_JOB Procedure

115 DBMS_SERVER_ALERT

Using DBMS_SERVER_ALERT

Relational Operators

Supported Metrics

Summary of DBMS_SERVER_ALERT Subprograms

EXPAND_MESSAGE Function

GET_THRESHOLD Procedure

SET_THRESHOLD Procedure

116 DBMS_SERVICE

Using DBMS_SERVICE

Summary of DBMS_SERVICE Subprograms

CREATE_SERVICE Procedure

DELETE_SERVICE Procedure

DISCONNECT_SESSION Procedure

MODIFY_SERVICE Procedure

START_SERVICE Procedure

STOP_SERVICE Procedure

117 DBMS_SESSION

Using DBMS_SESSION

Operational Notes

Summary of DBMS_SESSION Subprograms

CLEAR_ALL_CONTEXT Procedure

CLEAR_CONTEXT Procedure

CLEAR_IDENTIFIER Procedure

CLOSE_DATABASE_LINK Procedure

FREE_UNUSED_USER_MEMORY 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_NLS Procedure

SET_ROLE Procedure

SET_SQL_TRACE Procedure

SWITCH_CURRENT_CONSUMER_GROUP Procedure

UNIQUE_SESSION_ID Function

118 DBMS_SHARED_POOL

Using DBMS_SHARED_POOL

Operational Notes

Summary of DBMS_SHARED_POOL Subprograms

ABORTED_REQUEST_THRESHOLD Procedure

SIZES Procedure

UNKEEP Procedure

119 DBMS_SPACE

Using DBMS_SPACE

Data Structures

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

OBJECT_DEPENDENT_SEGMENTS Function

OBJECT_GROWTH_TREND Function

SPACE_USAGE Procedures

UNUSED_SPACE Procedure

120 DBMS_SPACE_ADMIN

Using DBMS_SPACE_ADMIN

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

121 DBMS_SPM

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

PACK_STGTAB_BASELINE Function

UNPACK_STGTAB_BASELINE Function

122 DBMS_SQL

Operational Notes

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

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 Procedure

DEFINE_COLUMN_LONG 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

123 DBMS_SQLDIAG

Using DBMS_SQLDIAG

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_SQL Function

INCIDENTID_2_SQL Procedure

INTERRUPT_DIAGNOSIS_TASK Procedure

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

124 DBMS_SQLPA

Using DBMS_SQLPA

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

125 DBMS_SQLTUNE

Using DBMS_SQLTUNE

Data Structures

SQLSET_ROW Object Type

Subprogram Groups

SQL Tuning Advisor Subprograms

SQL Profile Subprograms

SQL Tuning Set Subprograms

Real-time SQL Monitoring 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_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_MONITOR Function

REPORT_TUNING_TASK Function

RESET_TUNING_TASK Procedure

RESUME_TUNING_TASK Procedure

SCRIPT_TUNING_TASK Function

SELECT_CURSOR_CACHE Function

SELECT_SQLSET Function

SELECT_WORKLOAD_REPOSITORY Functions

SET_TUNING_TASK_PARAMETER Procedures

SQLTEXT_TO_SIGNATURE Function

UNPACK_STGTAB_SQLPROF Procedure

UNPACK_STGTAB_SQLSET Procedure

UPDATE_SQLSET Procedures

126 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

127 DBMS_STATS

Using DBMS_STATS

Operational Notes

Deprecated Subprograms

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_PREFS_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

128 DBMS_STORAGE_MAP

Using DBMS_STORAGE_MAP

Operational Notes

Summary of DBMS_STORAGE_MAP Subprograms

DROP_ALL Function

DROP_ELEMENT Function

DROP_FILE Function

LOCK_MAP Procedure

MAP_ALL Function

MAP_ELEMENT Function

MAP_FILE Function

MAP_OBJECT Function

RESTORE Function

UNLOCK_MAP Procedure

129 DBMS_STREAMS

Using DBMS_STREAMS

Summary of DBMS_STREAMS Subprograms

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

SET_TAG Procedure

130 DBMS_STREAMS_ADM

Using DBMS_STREAMS_ADM

Deprecated Subprograms

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

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_UP_QUEUE Procedure

SPLIT_STREAMS Procedure

131 DBMS_STREAMS_ADVISOR_ADM

Using DBMS_STREAMS_ADVISOR_ADM

Operational Notes

Summary of DBMS_STREAMS_ADVISOR_ADM Subprograms

ANALYZE_CURRENT_PERFORMANCE Procedure

132 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

133 DBMS_STREAMS_MESSAGING

Summary of DBMS_STREAMS_MESSAGING Subprograms

DEQUEUE Procedure

ENQUEUE Procedure

134 DBMS_STREAMS_TABLESPACE_ADM

Using DBMS_STREAMS_TABLESPACE_ADM

Data Structures

DIRECTORY_OBJECT_SET Table Type

FILE Record Type

FILE_SET Table Type

TABLESPACE_SET Table Type

Summary of DBMS_STREAMS_TABLESPACE_ADM Subprograms

ATTACH_SIMPLE_TABLESPACE Procedure

ATTACH_TABLESPACES Procedure

CLONE_SIMPLE_TABLESPACE Procedure

CLONE_TABLESPACES Procedure

DETACH_SIMPLE_TABLESPACE Procedure

DETACH_TABLESPACES Procedure

PULL_SIMPLE_TABLESPACE Procedure

PULL_TABLESPACES Procedure

135 DBMS_TDB

Operational Notes

Summary of DBMS_TDB Subprograms

CHECK_DB Function

CHECK_EXTERNAL Function

136 DBMS_TRACE

Using DBMS_TRACE

Operational Notes

Summary of DBMS_TRACE Subprograms

CLEAR_PLSQL_TRACE Procedure

GET_PLSQL_TRACE_LEVEL Function

PLSQL_TRACE_VERSION Procedure

SET_PLSQL_TRACE Procedure

137 DBMS_TRANSACTION

Using DBMS_TRANSACTION

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

138 DBMS_TRANSFORM

Summary of DBMS_TRANSFORM Subprograms

CREATE_TRANSFORMATION Procedure

DROP_TRANSFORMATION Procedure

MODIFY_TRANSFORMATION Procedure

139 DBMS_TTS

Operational Notes

Summary of DBMS_TTS Subprograms

DOWNGRADE Procedure

TRANSPORT_SET_CHECK Procedure

140 DBMS_TYPES

Using DBMS_TYPES

141 DBMS_UTILITY

Using DBMS_UTILITY

Summary of DBMS_UTILITY Subprograms

ACTIVE_INSTANCES Procedure

ANALYZE_PART_OBJECT 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_HASH_VALUE Function

GET_PARAMETER_VALUE Function

GET_TIME Function

INVALIDATE Procedure

IS_CLUSTER_DATABASE Function

MAKE_DATA_BLOCK_ADDRESS Function

NAME_RESOLVE Procedure

NAME_TOKENIZE Procedure

PORT_STRING Function

TABLE_TO_COMMA Procedures

VALIDATE Procedure

142 DBMS_WARNING

Using DBMS_WARNING

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

143 DBMS_WM

Documentation of DBMS_WM

144 DBMS_WORKLOAD_CAPTURE

Using DBMS_WORKLOAD_CAPTURE

Summary of DBMS_WORKLOAD_CAPTURE Subprograms

ADD_FILTER Procedures

DELETE_CAPTURE_INFO Procedure

DELETE_FILTER Procedure

EXPORT_AWR Procedure

FINISH_CAPTURE Procedure

GET_CAPTURE_INFO Function

IMPORT_AWR Function

REPORT Function

START_CAPTURE Procedure

145 DBMS_WORKLOAD_REPLAY

Using DBMS_WORKLOAD_REPLAY

Summary of DBMS_WORKLOAD_REPLAY Subprograms

CALIBRATE Function

CANCEL_REPLAY Procedure

DELETE_REPLAY_INFO Procedure

EXPORT_AWR Procedure

GET_REPLAY_INFO Function

IMPORT_AWR Function

INITIALIZE_REPLAY Procedure

PREPARE_REPLAY Procedure

PROCESS_CAPTURE Procedure

REMAP_CONNECTION Procedure

REPORT Function

START_REPLAY Procedure

146 DBMS_WORKLOAD_REPOSITORY

Using DBMS_WORKLOAD_REPOSITORY

Data Structures

AWR_BASELINE_METRIC_TYPE Object Type

AWR_BASELINE_METRIC_TYPE_TABLE Table Type

Summary of DBMS_WORKLOAD_REPOSITORY Subprograms

ADD_COLORED_SQL Procedure

ASH_REPORT_HTML Function

ASH_REPORT_TEXT Function

AWR_DIFF_REPORT_HTML Function

AWR_DIFF_REPORT_TEXT Function

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

147 DBMS_XA

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

148 DBMS_XDB

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

COPYRESOURCE Procedure

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

149 DBMS_XDB_ADMIN

Summary of DBMS_XDB_ADMIN Subprograms

CREATEREPOSITORYXMLINDEX Procedure

DROPREPOSITORYXMLINDEX Procedure

XMLINDEXADDPATH Procedure

XMLINDEXREMOVEPATH Procedure

150 DBMS_XDBRESOURCE

Using DBMS_XDBRESOURCE

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

SETACL Procedure

SETAUTHOR Procedure

SETCHARACTERSET Procedure

SETCOMMENT Procedure

SETCONTENT Procedures

SETCONTENTTYPE Procedure

SETCUSTOMMETADATA Procedure

SETDISPLAYNAME Procedure

SETLANGUAGE Procedure

SETOWNER Procedure

151 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

152 DBMS_XDBT

Using DBMS_XDBT

Operational Notes

Summary of DBMS_XDBT Subprograms

CONFIGUREAUTOSYNC Procedure

CREATEDATASTOREPREF Procedure

CREATEFILTERPREF Procedure

CREATEINDEX Procedure

CREATELEXERPREF Procedure

CREATEPREFERENCES Procedure

CREATESECTIONGROUPPREF Procedure

CREATESTOPLISTPREF Procedure

CREATESTORAGEPREF Procedure

CREATEWORLDLISTPREF Procedure

DROPPREFERENCES Procedure

153 DBMS_XDBZ

Using DBMS_XDBZ

Summary of DBMS_XDBZ Subprograms

DISABLE_HIERARCHY Procedure

ENABLE_HIERARCHY Procedure

GET_ACLOID Function

GET_USERID Function

IS_HIERARCHY_ENABLED Function

PURGELDAPCACHE Function

154 DBMS_XEVENT

Using DBMS_XEVENT

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

155 DBMS_XMLDOM

Using DBMS_XMLDOM

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

FREENODE 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

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

156 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

157 DBMS_XMLINDEX

Using DBMS_XMLINDEX

Summary of DBMS_XMLINDEX Subprograms

CREATEDATEINDEX Procedure

CREATENUMBERINDEX Procedure

SYNCINDEX Procedure

158 DBMS_XMLPARSER

Summary of DBMS_XMLPARSER Subprograms

GETRELEASEVERSION

GETVALIDATIONMODE

SETPRESERVEWHITESPACE

SETVALIDATIONMODE

159 DBMS_XMLQUERY

Using DBMS_XMLQUERY

Summary of DBMS_XMLQUERY Subprograms

GETEXCEPTIONCONTENT

GETNUMROWSPROCESSED

PROPAGATEORIGINALEXCEPTION

REMOVEXSLTPARAM

SETCOLLIDATTRNAME

SETRAISEEXCEPTION

SETRAISENOROWSEXCEPTION

SETROWIDATTRNAME

SETROWIDATTRVALUE

SETSQLTOXMLNAMEESCAPING

SETSTYLESHEETHEADER

USENULLATTRIBUTEINDICATOR

USETYPEFORCOLLELEMTAG

160 DBMS_XMLSAVE

Using DBMS_XMLSAVE

Summary of DBMS_XMLSAVE Subprograms

CLEARKEYCOLUMNLIST

CLEARUPDATECOLUMNLIST

GETEXCEPTIONCONTENT

PROPAGATEORIGINALEXCEPTION

REMOVEXSLTPARAM

SETPRESERVEWHITESPACE

SETSQLTOXMLNAMEESCAPING

SETUPDATECOLUMN

161 DBMS_XMLSCHEMA

Using DBMS_XMLSCHEMA

Operational Notes

Summary of DBMS_XMLSCHEMA Subprograms

COMPILESCHEMA Procedure

COPYEVOLVE Procedure

DELETESCHEMA Procedure

GENERATEBEAN Procedure

GENERATESCHEMA Function

GENERATESCHEMAS Function

INPLACEEVOLVE Procedure

PURGESCHEMA Procedure

REGISTERSCHEMA Procedures

REGISTERURI Procedure

162 DBMS_XMLSTORE

Using DBMS_XMLSTORE

Summary of DBMS_XMLSTORE Subprograms

CLEARKEYCOLUMNLIST

CLEARUPDATECOLUMNLIST

SETUPDATECOLUMN

163 DBMS_XMLTRANSLATIONS

Summary of DBMS_XMLTRANSLATIONS Subprograms

DISABLETRANSLATION Procedure

ENABLETRANSLATION Procedure

EXTRACTXLIFF Function & Procedure

GETBASEDOCUMENT Function

MERGEXLIFF Functions

SETSOURCELANG Function

TRANSLATEXML Function

UPDATETRANSLATION Function

164 DBMS_XPLAN

Using DBMS_XPLAN

Summary of DBMS_XPLAN Subprograms

DISPLAY Function

DISPLAY_AWR Function

DISPLAY_CURSOR Function

DISPLAY_SQL_PLAN_BASELINE Function

DISPLAY_SQLSET Function

165 DBMS_XSLPROCESSOR

Using DBMS_XSLPROCESSOR

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

166 DEBUG_EXTPROC

Using DEBUG_EXTPROC

Operational Notes

Rules and Limits

Summary of DEBUG_EXTPROC Subprograms

STARTUP_EXTPROC_AGENT Procedure

167 HTF

Operational Notes

Rules and Limits

Summary of Tags

Summary of HTF Subprograms

ADDRESS Function

ANCHOR Function

ANCHOR2 Function

APPLETCLOSE Function

APPLETOPEN Function

BASEFONT Function

BGSOUND Function

BLOCKQUOTECLOSE Function

BLOCKQUOTEOPEN Function

BODYCLOSE Function

BODYOPEN Function

CENTER Function

CENTERCLOSE Function

CENTEROPEN Function

COMMENT Function

DIRLISTCLOSE Function

DIRLISTOPEN Function

DLISTCLOSE Function

DLISTDEF Function

DLISTOPEN Function

DLISTTERM 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

FRAMESETCLOSE Function

FRAMESETOPEN Function

HEADCLOSE Function

HEADER Function

HEADOPEN Function

HTMLCLOSE Function

HTMLOPEN Function

ISINDEX Function

ITALIC Function

KEYBOARD Function

LINKREL Function

LINKREV Function

LISTHEADER Function

LISTINGCLOSE Function

LISTINGOPEN Function

LISTITEM Function

MAILTO Function

MAPCLOSE Function

MAPOPEN Function

MENULISTCLOSE Function

MENULISTOPEN Function

NOFRAMESCLOSE Function

NOFRAMESOPEN Function

OLISTCLOSE Function

OLISTOPEN Function

PARAGRAPH Function

PLAINTEXT Function

PRECLOSE Function

PREOPEN Function

PRINT Functions

SAMPLE Function

SCRIPT Function

STRIKE Function

STRONG Function

TABLECAPTION Function

TABLECLOSE Function

TABLEDATA Function

TABLEHEADER Function

TABLEOPEN Function

TABLEROWCLOSE Function

TABLEROWOPEN Function

TELETYPE Function

ULISTCLOSE Function

ULISTOPEN Function

UNDERLINE Function

VARIABLE Function

168 HTP

Operational Notes

Rules and Limits

Summary of Tags

Summary of HTP Subprograms

ADDRESS Procedure

ANCHOR Procedure

ANCHOR2 Procedure

APPLETCLOSE Procedure

APPLETOPEN Procedure

BASEFONT Procedure

BGSOUND Procedure

BLOCKQUOTECLOSE Procedure

BLOCKQUOTEOPEN Procedure

BODYCLOSE Procedure

BODYOPEN Procedure

CENTER Procedure

CENTERCLOSE Procedure

CENTEROPEN Procedure

COMMENT Procedure

DIRLISTCLOSE Procedure

DIRLISTOPEN Procedure

DLISTCLOSE Procedure

DLISTDEF Procedure

DLISTOPEN Procedure

DLISTTERM 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

HTMLCLOSE Procedure

HTMLOPEN Procedure

ISINDEX Procedure

ITALIC Procedure

KEYBOARD Procedure

LINKREL Procedure

LINKREV Procedure

LISTHEADER Procedure

LISTINGCLOSE Procedure

LISTINGOPEN Procedure

LISTITEM Procedure

MAILTO Procedure

MAPCLOSE Procedure

MAPOPEN Procedure

MENULISTCLOSE Procedure

MENULISTOPEN Procedure

NOFRAMESCLOSE Procedure

NOFRAMESOPEN Procedure

OLISTCLOSE Procedure

OLISTOPEN Procedure

PARAGRAPH Procedure

PARAM Procedure

PLAINTEXT Procedure

PRECLOSE Procedure

PREOPEN Procedure

PRINT Procedures

PRINTS Procedure

SAMPLE Procedure

SCRIPT Procedure

SMALL Procedure

STRIKE Procedure

STRONG Procedure

STYLE 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

169 ORD_DICOM

Documentation of ORD_DICOM

170 ORD_DICOM_ADMIN

Documentation of ORD_DICOM_ADMIN

171 OWA_CACHE

Using OWA_CACHE

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

172 OWA_COOKIE

Using OWA_COOKIE

Rules and Limits

Summary of OWA_COOKIE Subprograms

GET_ALL Procedure

REMOVE Procedure

173 OWA_CUSTOM

Using OWA_CUSTOM

Summary of OWA_CUSTOM Subprograms

AUTHORIZE Function

174 OWA_IMAGE

Using OWA_IMAGE

Summary of OWA_IMAGE Subprograms

175 OWA_OPT_LOCK

Using OWA_OPT_LOCK

Summary of OWA_OPT_LOCK Subprograms

CHECKSUM Functions

GET_ROWID Function

STORE_VALUES Procedure

VERIFY_VALUES Function

176 OWA_PATTERN

Using OWA_PATTERN

Operational Notes

Summary of OWA_PATTERN Subprograms

AMATCH Function

CHANGE Functions and Procedures

GETPAT Procedure

177 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

178 OWA_TEXT

Summary of OWA_TEXT Subprograms

ADD2MULTI Procedure

NEW_ROW_LIST Function and Procedure

PRINT_MULTI Procedure

PRINT_ROW_LIST Procedure

STREAM2MULTI Procedure

179 OWA_UTIL

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

180 SDO_CS

Documentation of SDO_CS

181 SDO_CSW_PROCESS

Documentation of SDO_CSW_PROCESS

182 SDO_GCDR

Documentation of SDO_GCDR

183 SDO_GEOM

Documentation of SDO_GEOM

184 SDO_GEOR

Documentation of SDO_GEOR

185 SDO_GEOR_ADMIN

Documentation of SDO_GEOR_ADMIN

186 SDO_GEOR_UTL

Documentation of SDO_GEOR_UTL

187 SDO_LRS

Documentation of SDO_LRS

188 SDO_MIGRATE

Documentation of SDO_MIGRATE

189 SDO_NET

Documentation of SDO_NET

190 SDO_NET_MEM

Documentation of SDO_NET_MEM

191 SDO_OLS

Documentation of SDO_OLS

192 SDO_PC_PKG

Documentation of SDO_PC_PKG

193 SDO_SAM

Documentation of SDO_SAM

194 SDO_TIN_PKG

Documentation of SDO_TIN_PKG

195 SDO_TOPO

Documentation of SDO_TOPO

196 SDO_TOPO_MAP

Documentation of SDO_TOPO_MAP

197 SDO_TUNE

Documentation of SDO_TUNE

198 SDO_UTIL

Documentation of SDO_UTIL

199 SDO_WFS_LOCK

Documentation of SDO_WFS_LOCK

200 SDO_WFS_PROCESS

Documentation of SDO_WFS_PROCESS

201 SEM_APIS

Documentation of SEM_APIS

202 SEM_PERF

Documentation of SEM_PERF

203 UTL_COLL

Summary of UTL_COLL Subprograms

IS_LOCATOR Function

204 UTL_COMPRESS

Using UTL_COMPRESS

Operational Notes

Summary of UTL_COMPRESS Subprograms

ISOPEN Function

LZ_COMPRESS Functions and Procedures

LZ_COMPRESS_ADD Procedure

LZ_COMPRESS_CLOSE

LZ_COMPRESS_OPEN

LZ_UNCOMPRESS Functions and Procedures

LZ_UNCOMPRESS_EXTRACT Procedure

LZ_UNCOMPRESS_OPEN Function

LZ_UNCOMPRESS_CLOSE Procedure

205 UTL_DBWS

Supported Keys and Default Settings for Standard Call Properties

Summary of UTL_DBWS Subprograms

CREATE_CALL Function

CREATE_SERVICE Function

GET_IN_PARAMETER_TYPES Function

GET_OUT_PARAMETER_TYPES Function

GET_OUTPUT_VALUES Function

GET_PORTS Function

GET_PROPERTY Function

GET_RETURN_TYPE Function

GET_SERVICES Function

INVOKE Function

RELEASE_ALL_SERVICES Procedure

RELEASE_CALL Procedure

RELEASE_SERVICE Procedure

REMOVE_PROPERTY Procedure

SET_PROPERTY Procedure

206 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

207 UTL_FILE

Operational Notes

Rules and Limits

Summary of UTL_FILE Subprograms

FCLOSE Procedure

FCLOSE_ALL Procedure

FCOPY Procedure

FFLUSH Procedure

FGETATTR Procedure

FGETPOS 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_LINE Procedure

PUT_LINE_NCHAR Procedure

PUT_NCHAR Procedure

PUTF_NCHAR Procedure

PUT_RAW Function

208 UTL_HTTP

Operational Notes

Subprogram Groups

Simple HTTP Fetches in a Single Call Subprograms

Session Settings Subprograms

HTTP Requests 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

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_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

209 UTL_I18N

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

210 UTL_INADDR

Using UTL_INADDR

Summary of UTL_INADDR Subprograms

GET_HOST_ADDRESS Function

GET_HOST_NAME Function

211 UTL_LMS

Summary of UTL_LMS Subprograms

FORMAT_MESSAGE Function

GET_MESSAGE Function

212 UTL_MAIL

Operational Notes

Rules and Limits

Summary of UTL_MAIL Subprograms

SEND_ATTACH_RAW Procedure

SEND_ATTACH_VARCHAR2 Procedure

213 UTL_NLA

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

214 UTL_RAW

Operational Notes

Summary of UTL_RAW Subprograms

BIT_AND Function

BIT_COMPLEMENT Function

BIT_OR Function

BIT_XOR Function

CAST_FROM_BINARY_DOUBLE Function

CAST_FROM_BINARY_FLOAT Function

CAST_FROM_BINARY_INTEGER Function

CAST_FROM_NUMBER Function

CAST_TO_BINARY_DOUBLE Function

CAST_TO_BINARY_FLOAT Function

CAST_TO_BINARY_INTEGER Function

CAST_TO_NUMBER Function

CAST_TO_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

215 UTL_RECOMP

Using UTL_RECOMP

Operational Notes

Summary of UTL_RECOMP Subprograms

RECOMP_PARALLEL Procedure

RECOMP_SERIAL Procedure

216 UTL_REF

Summary of UTL_REF Subprograms

DELETE_OBJECT Procedure

LOCK_OBJECT Procedure

SELECT_OBJECT Procedure

UPDATE_OBJECT Procedure

217 UTL_SMTP

Rules and Limits

Summary of UTL_SMTP Subprograms

CLOSE_DATA Function and Procedure

COMMAND Function and Procedure

COMMAND_REPLIES Function

DATA Function and Procedure

EHLO Function and Procedure

HELO Function and Procedure

MAIL Function and Procedure

NOOP Function and Procedure

OPEN_CONNECTION Functions

OPEN_DATA Function and Procedure

QUIT Function and Procedure

RSET Function and Procedure

WRITE_DATA Procedure

WRITE_RAW_DATA Procedure

218 UTL_SPADV

Summary of UTL_SPADV Subprograms

COLLECT_STATS Procedure

SHOW_STATS Procedure

219 UTL_TCP

Rules and Limits

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

220 UTL_URL

Summary of UTL_URL Subprograms

ESCAPE Function

UNESCAPE Function

221 WPG_DOCLOAD

Using WPG_DOCLOAD

Summary of WPG_DOCLOAD Subprograms

DOWNLOAD_FILE Procedures

222 ANYDATA TYPE

Using ANYDATA TYPE

Operational Notes

Summary of ANYDATA Subprograms

BEGINCREATE Static Procedure

ENDCREATE Member Procedure

GET* Member Functions

GETTYPE Member Function

GETTYPENAME Member Function

PIECEWISE Member Procedure

SET* Member Procedures

223 ANYDATASET TYPE

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

224 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

225 Oracle Streams AQ TYPEs

Summary of Types

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

226 Database URI TYPEs

Summary of URITYPE Supertype Subprograms

Summary of HTTPURITYPE Subtype Subprograms

Summary of DBURITYPE Subtype Subprogams

Summary of XDBURITYPE Subtype Subprograms

Summary of URIFACTORY Package Subprograms

REGISTERURLHANDLER

UNREGISTERURLHANDLER

227 Expression Filter Types

Summary of Expression Filter Types

EXF$ATTRIBUTE_LIST

EXF$TABLE_ALIAS

228 JMS Types

Using JMS Types

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

229 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

230 Oracle Multimedia ORDAudio TYPE

Documentation of ORDAudio

231 Oracle Multimedia ORDDicom TYPE

Documentation of ORDDicom

232 Oracle Multimedia ORDDoc TYPE

Documentation of ORDDoc

233 Oracle Multimedia ORDImage TYPE

Documentation of ORDImage

234 Oracle Multimedia SQL/MM Still Image TYPE

Documentation of SQL/MM Still Image

235 Oracle Multimedia ORDVideo TYPE

Documentation of ORDVideo

236 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

237 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

238 Rules Manager Types

Summary of Rule Manager Types

RLM$EVENTIDS Object Type

239 UTL Streams Types

Summary of UTL Binary Streams Types

UTL_BINARYINPUTSTREAM Type

UTL_BINARYOUTPUTSTREAM Type

UTL_CHARACTERINPUTSTREAM Type

UTL_CHARACTEROUTPUTSTREAM Type

240 XMLTYPE

Summary of XMLType Subprograms

CREATENONSCHEMABASEDXML

CREATESCHEMABASEDXML

ISSCHEMAVALIDATED

SETSCHEMAVALIDATED

Index