Skip Headers
Oracle® Database PL/SQL Packages and Types Reference
11g Release 2 (11.2)

Part Number E16760-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
View PDF

Index

A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X 

A

ABORT procedure, 121
ABORT_GLOBAL_INSTANTIATION procedure, 32
ABORT_REDEF_TABLE procedure, 109
ABORT_SCHEMA_INSTANTIATION procedure, 32
ABORT_TABLE_INSTANTIATION procedure, 32
ABORTED_REQUEST_THRESHOLD procedure, 131
ACCEPT_SQL_PATCH Procedure, 136
ACCEPT_SQL_PROFILE procedure, 138
ACLCHECKPRIVILEGES function, 162
ACTIVATE_SUBSCRIPTION Procedure, 34
ACTIVE_INSTANCES procedure, 155
ADD_COLORED_SQL Procedure, 160
ADD_COLUMN member procedure, 247
ADD_COLUMN procedure, 143
ADD_COOKIES procedure, 223
ADD_ELEMENTARY_ATTRIBUTE procedure, 64, 122
ADD_EVENT procedure, 122
ADD_FILE procedure, 66
ADD_FILTER Procedure, 158, 159
ADD_FUNCTIONS procedure, 64, 122
ADD_GLOBAL_PROPAGATION_RULES procedure, 143
ADD_GLOBAL_RULES procedure, 143
ADD_MESSAGE_PROPAGATION_RULE procedure, 143
ADD_MESSAGE_RULE procedure, 143
ADD_PAIR member procedure, 255
ADD_PRIVILEGE Procedure, 93
ADD_RULE procedure, 122, 126
ADD_SCHEMA_PROPAGATION_RULES procedure, 143
ADD_SCHEMA_RULES procedure, 143
ADD_SCHEME procedure, 88
ADD_SQLSET_REFERENCE function, 138
ADD_SQLWKLD_REF Procedure, 18
ADD_SQLWKLD_STATEMENT Procedure, 18
ADD_STMT_HANDLER procedure, 21
ADD_STMT_TO_HANDLER procedure, 146
ADD_SUBSCRIBER Procedure, 89
ADD_SUBSET_PROPAGATION_RULES procedure, 143
ADD_SUBSET_RULES procedure, 143
ADD_TABLE_PROPAGATION_RULES procedure, 143
ADD_TABLE_RULES procedure, 143
ADD_WARNING_SETTING_CAT procedure, 156
ADD_WARNING_SETTING_NUM procedure, 156
ADD2MULTI procedure, 192
ADDATTR member procedure
of ANYTYPE TYPE, 241
ADDHTTPEXPIREMAPPING Procedure, 162
ADDINSTANCE member procedure
of ANYDATASET TYPE, 240
ADDMIMEMAPPING Procedure, 162
ADDREPOSITORYRESCONFIG Procedure, 117
ADDRESCONFIG Function, 117
ADDRESS function
of HTF package, 181
ADDRESS procedure
of HTP package, 182
ADDSCHEMALOCMAPPING Procedure, 162
ADDSERVLET Procedure, 162
ADDSERVLETMAPPING Procedure, 162
ADDSERVLETSECROLE Procedure, 162
ADDXMLEXTENSION Procedure, 162
ADM_DROP_CHUNKS Procedure, 100
ADM_DROP_TASK Procedure, 100
ADM_GET_TASK_STATUS Procedure, 100
ADM_STOP_TASK Procedure, 100
ADMIN_TABLES procedure, 111
ADVISE_COMMIT procedure, 151
ADVISE_NOTHING procedure, 151
ADVISE_ROLLBACK procedure, 151
ADVISOR privilege, 41, 41
advisors
Oracle Streams, 144
aggregation management, 41
aggregation operators (OLAP), 41
ALLOCATE_UNIQUE procedure, 82
ALTER_AGENT Procedure, 89
ALTER_APPLY procedure, 21
ALTER_CAPTURE procedure, 32
ALTER_COMPILE procedure, 53
ALTER_EVALUATION_CONTEXT procedure, 126
ALTER_FILE procedure, 66
ALTER_FILE_GROUP procedure, 66
ALTER_JOB Procedure, 89
ALTER_MSGSYSTEM_LINK Procedure for TIB/Rendezvous, 89
ALTER_MSGSYSTEM_LINK Procedure for WebSphere MQ, 89
ALTER_PARAM Procedure, 37
ALTER_PROPAGATION procedure, 106
ALTER_PROPAGATION_SCHEDULE Procedure, 89
ALTER_REWRITE_EQUIVALENCE Procedure, 17
ALTER_RULE procedure, 126
ALTER_SQL_PATCH Procedure, 136
ALTER_SQL_PLAN_BASELINE Function, 134
ALTER_SQL_PROFILE procedure, 138
ALTER_STATS_HISTORY_RETENTION procedure, 140
ALTER_SUBSCRIBER Procedure, 89
ALTER_SYNC_CAPTURE procedure, 32
ALTER_TABLE_NOT_REFERENCEABLE procedure, 53
ALTER_TABLE_REFERENCEABLE procedure, 53
ALTER_VERSION procedure, 66
AMATCH function, 190
ANALYZE Function, 72
ANALYZE Procedure, 31
ANALYZE_CURRENT_PERFORMANCE procedure, 144
ANALYZE_DATABASE Procedure, 155
ANALYZE_DB Procedure, 16
ANALYZE_INST Procedure, 16
ANALYZE_PART_OBJECT procedure, 155
ANALYZE_PARTIAL Procedure, 16
ANALYZE_SCHEMA Procedure, 155
ANCHOR function
of HTF package, 181
ANCHOR procedure
of HTP package, 182
ANCHOR2 function
of HTF package, 181
ANCHOR2 procedure
of HTP package, 182
anonymous PL/SQL blocks
dynamic SQL and, 135
AnyData datatype
queues
creating, 143
removing, 143
ANYDATA TYPE, 239
ANYDATASET TYPE, 240
ANYTYPE TYPE, 241
APEX_APPLICATION package, 3
APEX_APPLICATION package documentation, 3
APEX_CUSTOM_AUTH package, 2
APEX_CUSTOM_AUTH package documentation, 2
APEX_ITEM package, 4
APEX_ITEM package documentation, 4
APEX_UTIL package, 5
APPEND Procedures, 81
APPENDCHILD function, 169
APPENDDATA procedure, 169
APPENDPATH Procedure, 162
APPENDRESCONFIG Procedure, 117
APPENDRESOURCEMETADATA Procedure, 162
APPLETCLOSE function
of HTF package, 181
APPLETCLOSE procedure
of HTP package, 182
APPLETOPEN function
of HTF package, 181
APPLETOPEN procedure
of HTP package, 182
apply process
altering, 21
apply user, 143
change handlers
setting, 21
conflict handlers
setting, 21
creating, 21, 143, 143, 143, 143, 143
DBMS_APPLY_ADM package, 21
DDL handler
setting, 21, 21
dropping, 21
enqueuing events, 21
error handlers
setting, 21
error queue
deleting errors, 21, 21
executing errors, 21, 21
getting error messages, 21
instantiation
global SCN, 21
schema SCN, 21
table SCN, 21
message handler
setting, 21, 21
parameters
allow_duplicate_rows, 21, 21, 32, 32
commit_serialization, 21
compare_key_only, 21
disable_on_error, 21
disable_on_limit, 21
grouptransops, 21
ignore_transaction, 21
max_sga_size, 21
maximum_scn, 21
parallelism, 21
preserve_encryption, 21
setting, 21
startup_seconds, 21, 21
time_limit, 21
trace_level, 21
transaction_limit, 21
txn_age_spill_threshold, 21
txn_lcr_spill_threshold, 21
precommit handler
setting, 21, 21
procedure DML handlers
setting, 21
rules
defining global, 143
defining message, 143
defining schema, 143
defining subset, 143
defining table, 143
for LCRs, 143
for user messages, 143
removing, 143
specifying execution, 21
starting, 21
statement DML handlers
setting, 21, 21
stopping, 21
substitute key columns
setting, 21
transparent data encryption, 21
apply user
DBMS_STREAMS_ADM package, 143
APPLY$_ENQUEUE, 21
APPLY$_EXECUTE, 21
AQ$_AGENT Type, 242
AQ$_AGENT_LIST_T Type, 242
AQ$_DESCRIPTOR Type, 242, 242
AQ$_NTFN_MSGID_ARRAY Type, 242
AQ$_POST_INFO Type, 242
AQ$_POST_INFO_LIST Type, 242
AQ$_PURGE_OPTIONS_T Type, 242
AQ$_RECIPIENT_LIST_T Type, 242
AQ$_REG_INFO Type, 242
AQ$_REG_INFO_LIST Type, 242
AQ$_SUBSCRIBER_LIST_T Type, 242
AREA function
of HTF package, 181
AREA procedure
of HTP package, 182
arrays
BIND_ARRAY procedure, 135
bulk DML using DBMS_SQL, 135
ASA_RECO_ROW Record Type, 132
ASA_RECO_ROW_TB Table Type, 132
ASA_RECOMMENDATIONS Function, 132
ASH_GLOBAL_REPORT_HTML Function, 160
ASH_GLOBAL_REPORT_TEXT Function, 160
ASH_REPORT_HTML Function, 160
ASH_REPORT_TEXT Function, 160
ASSIGN_ACL Procedure, 93
ASSIGN_ATTRIBUTE_SET procedure, 64
ASSIGN_WALLET_ACL Procedure, 93
ASSM_SEGMENT_VERIFY Procedure, 133
ASSM_TABLESPACE_VERIFY Procedure, 133
ATTACH_SESSION procedure, 52
ATTACH_SIMPLE_TABLESPACE procedure, 148
ATTACH_TABLESPACES procedure, 148
attribute sets
dropping, 64
AUTH Function and Procedure, 234
AUTHORIZE function, 187
AUTHORIZE_DAD Procedure, 62
AVAILABLE function, 236
AWR_BASELINE_METRIC_TYPE Object Type, 160
AWR_BASELINE_METRIC_TYPE_TABLE Table Type, 160
AWR_DIFF_REPORT_HTML Function, 160
AWR_DIFF_REPORT_TEXT Function, 160
AWR_GLOBAL_DIFF_REPORT_HTML Functions, 160
AWR_GLOBAL_DIFF_REPORT_TEXT Functions, 160, 160
AWR_GLOBAL_REPORT_HTML Functions, 160
AWR_GLOBAL_REPORT_TEXT Functions, 160
AWR_REPORT_HTML function, 160
AWR_REPORT_TEXT function, 160
AWR_SQL_REPORT_HTML Function, 160
AWR_SQL_REPORT_TEXT Function, 160

B

BASE function
of HTF package, 181
BASE procedure
of HTP package, 182
BASE64_DECODE function, 221
BASE64_ENCODE function, 221
BASEFONT function
of HTF package, 181
BASEFONT procedure
of HTP package, 182
BEGIN_PREPARE Procedure, 60
BEGIN_REQUEST function, 223
BEGIN_SQL_BLOCK Procedure, 118
BEGIN_UPGRADE Procedure, 60
BEGINCREATE static procedure
of ANYDATA TYPE, 239
of ANYDATASET TYPE, 240
of ANYTYPE TYPE, 241
BFILE_TABLE Table Type, 135
BGSOUND function
of HTF package, 181
BGSOUND procedure
of HTP package, 182
BIG function
of HTF package, 181
BIG procedure
of HTP package, 182
BINARY_DOUBLE_TABLE Table Type, 135
BINARY_FLOAT_TABLE Table Type, 135
BIND_ARRAY procedures, 135
BIND_INOUT_VARIABLE Procedure, 74
BIND_INOUT_VARIABLE_RAW Procedure, 74
BIND_OUT_VARIABLE Procedure, 74
BIND_OUT_VARIABLE_RAW Procedure, 74
BIND_VARIABLE Procedure, 74
BIND_VARIABLE procedures, 135
BIND_VARIABLE_RAW Procedure, 74
BIND_VARIABLES function, 193
BIT_AND function, 231
BIT_COMPLEMENT function, 231
BIT_OR function, 231
BIT_XOR function, 231
BLAS Level 1 (Vector-Vector Operations) Subprograms, 230
BLAS Level 2 (Matrix-Vector Operations) Subprograms, 230
BLAS Level 3 (Matrix-Matrix Operations) Subprograms, 230
BLAS_ASUM Functions, 230
BLAS_AXPY Procedures, 230
BLAS_COPY Procedures, 230
BLAS_DOT Functions, 230
BLAS_GBMV Procedures, 230
BLAS_GEMM Procedures, 230
BLAS_GEMV Procedures, 230
BLAS_GER Procedures, 230
BLAS_IAMAX Functions, 230
BLAS_NRM2 Functions, 230
BLAS_ROT Procedures, 230
BLAS_ROTG Procedures, 230
BLAS_SBMV Procedures, 230
BLAS_SCAL Procedure, 230
BLAS_SPMV Procedures, 230
BLAS_SPR Procedures, 230
BLAS_SPR2 Procedures, 230
BLAS_SWAP Procedure, 230
BLAS_SYMM Procedures, 230
BLAS_SYMV Procedures, 230
BLAS_SYR Procedures, 230
BLAS_SYR2 Procedures, 230
BLAS_SYRK Procedures, 230
BLAS_TBMV Procedures, 230
BLAS_TBSV Procedures, 230
BLAS_TPMV Procedures, 230
BLAS_TPSV Procedures, 230
BLAS_TRMM Procedures, 230
BLAS_TRMV Procedures, 230
BLAS_TRSM Procedures, 230
BLAS_TRSV Procedures, 230
BLOB_TABLE Table Type, 135
BLOCKQUOTECLOSE function
of HTF package, 181
BLOCKQUOTECLOSE procedure
of HTP package, 182, 182
BLOCKQUOTEOPEN function
of HTF package, 181
BLOCKQUOTEOPEN procedure
of HTP package, 182
BODYCLOSE function
of HTF package, 181
BODYCLOSE procedure
of HTP package, 182
BODYOPEN function
of HTF package, 181
BODYOPEN procedure
of HTP package, 182
BOLD function
of HTF package, 181
BOLD procedure
of HTP package, 182
BR function
of HTF package, 181
BR procedure
of HTP package, 182
BREAKPOINT_INFO Record Type, 52
BROKEN procedure, 77
BUILD procedure, 32, 41
BUILD_CHAIN_ROWS_TABLE procedure, 75
BUILD_EXCEPTIONS_TABLE procedure, 64, 75
BUILD_PART_INDEX procedure, 101
BUILD_SAFE_REWRITE_EQUIVALENCE Procedure, 17
BYPASS Procedure, 120

C

CALENDARPRINT procedures, 193
CALIBRATE Function, 159
CALIBRATE_IO Procedure, 118
CAN_REDEF_TABLE procedure, 109
CANCEL_ANALYSIS_TASK Procedure, 137
CANCEL_DIAGNOSIS_TASK Procedure, 136
CANCEL_REPLAY Procedure, 159
CANCEL_TASK Procedure, 18
CANCEL_TUNING_TASK procedure, 138
CANONICALIZE procedure, 155
capture process
altering, 32
building a Streams data dictionary, 32
capture user, 143
creating, 143, 143, 143, 143
DBMS_CAPTURE_ADM package, 32
instantiation
aborting database preparation, 32
aborting schema preparation, 32
aborting table preparation, 32
preparing a database for, 32
preparing a schema for, 32
preparing a table for, 32
parameters
disable_on_limit, 32
downstream_real_time_mine, 32
ignore_transaction, 32
ignore_unsupported_table, 32
max_sga_size, 32
maximum_scn, 32
message_limit, 32
message_tracking_frequency, 32
parallelism, 32
setting, 32
skip_autofiltered_table_ddl, 32
startup_seconds, 32
time_limit, 32
trace_level, 32
write_alert_log, 32
xout_client_exists, 32
rules, 143
defining global, 143
defining schema, 143
defining subset, 143
defining table, 143
removing, 143
starting, 32
stopping, 32
CAPTURE_CURSOR_CACHE_SQLSET Procedure, 138
CAST_FROM_BINARY_DOUBLE function, 231
CAST_FROM_BINARY_FLOAT function, 231
CAST_FROM_BINARY_INTEGER function, 231
CAST_FROM_NUMBER function, 231
CAST_TO_BINARY_DOUBLE function, 231
CAST_TO_BINARY_FLOAT function, 231
CAST_TO_BINARY_INTEGER function, 231
CAST_TO_NUMBER function, 231
CAST_TO_NVARCHAR2 function, 231
CAST_TO_RAW function, 231
CAST_TO_VARCHAR2 function, 231
CB$ table prefix, 41
CELLSPRINT procedures, 193
CENTER function
of HTF package, 181
CENTER procedure
of HTP package, 182
CENTERCLOSE function
of HTF package, 181
CENTERCLOSE procedure
of HTP package, 182
CENTEROPEN function
of HTF package, 181
CENTEROPEN procedure
of HTP package, 182
CFG_GET function, 162
CFG_REFRESH procedure, 162
CFG_UPDATE procedure, 162
Change Data Capture
DBMS_CDC_PUBLISH package, 33
change data capture
Oracle Streams
configuring, 143
CHANGE functions and procedures, 190
CHANGE procedure, 77
change tables
tablespaces created in, 33
CHANGEOWNER Procedure, 162
CHANGEPRIVILEGES Function, 162
CHARARR Table Type, 99
CHECK_OBJECT procedure, 111
CHECK_PRIVILEGE Function, 93
CHECK_PRIVILEGE_ACLID Function, 93
CHECKACCESS Function, 47, 48
CHECKIN function, 164
CHECKOUT procedure, 164
CHECKPRIVILEGES function, 162
CHECKSPI Functions and Procedures, 47
CHECKSUM functions, 189
CHOOSE_DATE procedure, 193
CITE function
of HTF package, 181
CITE procedure
of HTP package, 182
CLEAN_AUDIT_TRAIL procedure, 27
CLEANUP_GATEWAY Procedure, 89
CLEANUP_INSTANTIATION_SETUP procedure, 143
CLEANUPUNUSEDBACKUPFILES Procedure, 49
CLEAR Procedure, 168
CLEAR_ALL_CONTEXT Procedure, 130
CLEAR_AUDIT_TRAIL_PROPERTY procedure, 27
CLEAR_CONTEXT Procedure, 130
CLEAR_COOKIES procedure, 223
CLEAR_EXPRSET_STATS procedure, 64
CLEAR_IDENTIFIER Procedure, 130
CLEAR_LAST_ARCHIVE_TIMESTAMP procedure, 27
CLEAR_PENDING_AREA procedure, 118
CLEAR_PLSQL_TRACE procedure, 150
CLEAR_USED procedure, 98
CLEARKEYCOLUMNLIST procedure, 174, 176
CLEARUPDATECOLUMNLIST procedure, 174, 176
CLIENT_ID_STAT_DISABLE procedure, 91
CLIENT_ID_STAT_ENABLE procedure, 91
CLIENT_ID_TRACE_DISABLE procedure, 91
CLIENT_ID_TRACE_ENABLE procedure, 91
CLOB_TABLE Table Type, 135
CLOB2FILE procedure, 179
CLONE_SIMPLE_TABLESPACE procedure, 148
CLONE_TABLESPACES procedure, 148
CLONENODE function, 169
CLOSE Procedure, 81
CLOSE_ALL_CONNECTIONS procedure, 236
CLOSE_CONNECTION Procedure, 234
CLOSE_CONNECTION procedure, 236
CLOSE_CURSOR Procedure, 74
CLOSE_CURSOR procedure, 135
CLOSE_DATA Function and Procedure, 234
CLOSE_DATABASE_LINK Procedure, 130
CLOSE_ITERATOR procedure, 125
CLOSE_PERSISTENT_CONN procedure, 223
CLOSE_PERSISTENT_CONNS procedure, 223
CLOSECONTEXT procedure, 170, 173, 174, 176
COAD_ADVICE_REC type, 42
COAD_ADVICE_T type, 42
CODE function
of HTF package, 181
CODE procedure
of HTP package, 182
COLLECT_STATS procedure, 235
collections
table items, 135
column masking for VPD, 123
COLUMN_VALUE procedure, 135
COLUMN_VALUE_LONG procedure, 135
column-level VPD, 123
COMMA_TO_TABLE procedures, 155
COMMAND function and procedure, 234
COMMAND_REPLIES function, 234
COMMENT function
of HTF package, 181
COMMENT procedure
of HTP package, 182
COMMIT procedure, 151
COMMIT_COMMENT procedure, 151
COMMIT_FORCE procedure, 151
COMPARE Function, 35
COMPARE function, 231
COMPARE Functions, 81
COMPARE_OLD_VALUES procedure, 21
COMPARE_PERIOD_REPORT Procedure, 159
COMPARE_SQLSET_REPORT Function, 159
COMPARISON_TYPE type, 35
COMPATIBLE_10_1 function, 142, 247
COMPATIBLE_10_2 function, 142, 247
COMPATIBLE_11_1 function, 142
COMPATIBLE_11_2 function, 142
COMPATIBLE_9_2 function, 142, 247
COMPILE_FROM_REMOTE procedure, 80
COMPILE_SCHEMA procedure, 155
COMPILESCHEMA procedure, 175
CONCAT function, 231
CONDITION_REF function, 122
CONFIGURE Procedure, 134
CONFIGURE_POOL Procedure, 37
CONFIGUREAUTOSYNC procedure, 166
conflicts
detection
stopping, 21
CONNECTION record type, 234
constants
DBMS_MGWMSG package, 90
CONSUME_EVENT Function, 122
CONSUME_PRIM_EVENT Function, 122
CONTAINS_HOST Function, 94
CONTINUE function, 52
CONVERGE Procedure, 35
CONVERT function, 82, 170, 231
CONVERT_ANYDATA_TO_LCR_DDL function, 142
CONVERT_ANYDATA_TO_LCR_ROW function, 142
CONVERT_LCR_TO_XML function, 142
CONVERT_LONG_TO_LOB_CHUNK member procedure, 247
CONVERT_RAW_VALUE procedures, 140
CONVERT_RAW_VALUE_NVARCHAR procedure, 140
CONVERT_RAW_VALUE_ROWID procedure, 140
CONVERT_XML_TO_LCR function, 142
CONVERTTOBLOB procedure, 81
CONVERTTOCLOB Procedure, 81
COPIES function, 231
COPY Procedures, 81
COPY_ATTRIBUTE_SET procedure, 64
COPY_DBFS_LINK Procedures, 81
COPY_FILE procedure, 67
COPY_FROM_DBFS_LINK, 81
COPY_TABLE_DEPENDENTS procedure, 109
COPY_TABLE_STATS Procedure, 140
COPYDEFAULTTOKENTABLESET Procedure, 40
COPYEVOLVE procedure, 175
CQ_NOTIFICATION$_DESCRIPTOR Object Type, 38
CQ_NOTIFICATION$_QUERY Object Type, 38
CQ_NOTIFICATION$_QUERY_ARRAY Object (Array) Type, 38
CQ_NOTIFICATION$_REG_INFO Object Type, 38
CQ_NOTIFICATION$_ROW Object Type, 38
CQ_NOTIFICATION$_TABLE Object Type, 38
CQ_NOTIFICATION$_TABLE_ARRAY Object (Array) Type, 38
CQ_NOTIFICATION_QUERYID Function, 38
CREATE ANY DIMENSION privilege, 41
CREATE ANY MATERIALIZED VIEW privilege, 41
CREATE DIMENSION privilege, 41
CREATE MATERIALIZED VIEW privilege, 41
CREATE PACKAGE BODY command, 1
CREATE PACKAGE command, 1
CREATE SESSION privilege, 41, 41
CREATE_ACL Procedure, 93
CREATE_AFFECTED_TABLE Procedure, 60
CREATE_AGENT Procedure, 89
CREATE_ALTER_TYPE_ERROR_TABLE procedure, 155
CREATE_ANALYSIS_TASK Functions, 137
CREATE_APPLY procedure, 21
CREATE_ATTRIBUTE_SET procedure, 64
CREATE_BASELINE Function & Procedure, 160
CREATE_BASELINE_TEMPLATE Procedures, 160
CREATE_BIN_CAT procedure, 45
CREATE_BIN_NUM procedure, 45
CREATE_CAPTURE procedure
capture process
creating, 32
CREATE_CATEGORY function, 88
CREATE_CATEGORY Procedure, 118
CREATE_CHUNKS_BY_NUMBER_COL Procedure, 100
CREATE_CHUNKS_BY_ROWID Procedure, 100
CREATE_CHUNKS_BY_SQL Procedure, 100
CREATE_CLIP procedure, 45
CREATE_COL_REM procedure, 45
CREATE_COMPARISON Procedure, 35
CREATE_CONDITIONS_TABLE procedure, 122
CREATE_CONSUMER_GROUP procedure, 118
CREATE_DAD Procedure, 62
CREATE_DIAGNOSIS_TASK Functions, 136
CREATE_ERROR_LOG Procedure, 63
CREATE_ERROR_TABLE Procedure, 60
CREATE_EVALUATION_CONTEXT procedure, 126
CREATE_EVENT_STRUCT procedure, 122
CREATE_EXPFIL_INDEXES procedure, 122
CREATE_EXTENDED_STATS Function, 140
CREATE_FILE Procedure, 18
CREATE_FILE_GROUP procedure, 66
CREATE_FILTER_SET Procedure, 159
CREATE_INDEX_COST procedure, 132
CREATE_INTERFACE procedure, 122
CREATE_JOB Procedure, 89
CREATE_MISS_CAT procedure, 45
CREATE_MISS_NUM procedure, 45
CREATE_MSGSYSTEM_LINK Procedure for TIB/Rendezvous, 89
CREATE_MSGSYSTEM_LINK Procedure for WebSphere MQ, 89
CREATE_MVIEW function, 41, 41
CREATE_NORM_LIN procedure, 45
CREATE_OBJECT Procedure, 18
CREATE_OBJECT_DEPENDENCY procedure, 21
CREATE_OR_REPLACE_VIEW procedure
of DBMS_HS_PARALLEL package, 73
CREATE_OUTLINE procedure, 98
CREATE_PENDING_AREA procedure, 118
CREATE_PIPE function, 102
CREATE_PLAN procedure, 118
CREATE_PLAN_DIRECTIVE procedure, 118
CREATE_PROPAGATION procedure, 106
CREATE_PURGE_JOB procedure, 27
CREATE_REQUEST_CONTEXT Function, 223
CREATE_RULE procedure, 126
CREATE_RULE_CLASS procedure, 122
CREATE_RULE_SET procedure, 126
CREATE_SERVICE procedure, 129
CREATE_SIMPLE_PLAN procedure, 118
CREATE_SNAPSHOT function and procedure, 160
CREATE_SQL_PLAN_BASELINE Procedure, 138
CREATE_SQLSET procedure, 138
CREATE_SQLWKLD Procedure, 18
CREATE_STAT_TABLE procedure, 140
CREATE_STGTAB_BASELINE Procedure, 134
CREATE_STGTAB_SQLPATCH Procedure, 136
CREATE_STGTAB_SQLPROF Procedure, 138
CREATE_STGTAB_SQLSET Procedure, 138
CREATE_STMT_HANDLER procedure, 146
CREATE_SYNC_CAPTURE procedure
synchronous capture
creating, 32
CREATE_TABLE_COST procedures, 132
CREATE_TABLE_COST_COLINFO Object Type, 132
CREATE_TABLE_TEMPLAGE procedure
of DBMS_HS_PARALLEL package, 73
CREATE_TASK Procedure, 100
CREATE_TASK Procedures, 18
CREATE_TRANSFORMATION procedure, 152
CREATE_TRIGGER_TABLE Procedure, 60
CREATE_TUNING_TASK functions, 138
CREATE_VERSION procedure, 66
CREATE_WRAPPED Procedure, 53
CREATEATTRIBUTE function, 169
CREATEBUCKET Procedure, 49
CREATECDATASECTION function, 169
CREATECOMMENT function, 169
CREATEDATASTOREPREF procedure, 166
CREATEDATEINDEX Procedure, 171
CREATEDIRECTORY Procedures, 47, 48
CREATEDOCUMENT function, 169
CREATEDOCUMENTFRAGMENT function, 169
CREATEELEMENT function, 169
CREATEENTITYREFERENCE function, 169
CREATEFILE Procedures, 47, 48
CREATEFILESYSTEM Procedure, 50
CREATEFILTERPREF procedure, 166
CREATEFOLDER function, 162
CREATEINDEX procedure, 166
CREATELEXERPREF procedure, 166
CREATELINK Procedures, 47, 48
CREATENONSCHEMABASEDXML function, 258
CREATENUMBERINDEX Procedure, 171
CREATEOIDPATH function, 162
CREATEPREFERENCES procedure, 166
CREATEPROCESSINGINSTRUCTION function, 169
CREATEREFERENCE Procedures, 47, 48
CREATEREPOSITORYXMLINDEX Procedure, 163
CREATERESOURCE function, 162
CREATESCHEMABASEDXML function, 258
CREATESECTIONGROUPPREF procedure, 166
CREATESTOPLISTPREF procedure, 166
CREATESTORAGEPREF procedure, 166
CREATESTORE Procedure, 49, 50
CREATETEMPORARY Procedures, 81
CREATETEXTNODE function, 169
CREATEURI function, 244, 244, 244
CREATEWORLDLISTPREF procedure, 166
CREATEXML function, 258
creating
packages, 1
CTX_ADM package, 6
CTX_ADM package documentation, 6
CTX_CLS package, 7
CTX_CLS package documentation, 7
CTX_DDL package, 8
CTX_DDL package documentation, 8
CTX_DOC package documentation, 9
CTX_ENTITY package, 10
CTX_ENTITY package documentation, 10
CTX_OUTPUT package documentation, 11
CTX_QUERY package documentation, 12
CTX_REPORT package documentation, 13
CTX_THES package documentation, 14
CTX_ULEXER package documentation, 15
cube aggregation, 41
Cube Build log, 43
Cube Dimension Compile log, 43
cube log verbosity levels, 43
cube logging targets, 43
cube logging types, 43
cube maintenance, 41
cube materialized views, 41
optimizing, 42
Cube Operations log, 43
cube refresh, 41
Cube Rejected Records Log, 43
CUBE_BUILD_LATEST view, 41
CUBE_BUILD_REPORT view, 41
CUBE_BUILD_REPORT_LATEST view, 41
CUBE_UPGRADE_INFO table, 41
cubes
optimizer statistics, 31
CURRENT_INSTANCE function, 155
cursors
DBMS_SQL package, 135

D

data dictionary
removing Streams information, 143
DATA function and procedure, 234
data mining
algorithms, 44
anomaly detection, 44
association rules, 44
attribute importance, 44
attributes, 44
automated, 103
Automatic Data Preparation, 44
classification, 44, 44
clustering, 44, 44
confusion matrix, 44
cost matrix, 44
creating a model, 44
data transformation, 44, 44, 44, 44
feature extraction, 44
lift, 44
mining functions, 44, 44
PMML, 44
regression, 44, 44
ROC, 44
schema objects, 44
scoring, 44, 44, 44, 44
supervised, 44
transactional data, 44
transformations, 45
unsupervised, 44
DATA_BLOCK_ADDRESS_BLOCK function, 155
DATA_BLOCK_ADDRESS_FILE function, 155
database
locking
OWA_OPT_LOCK package, 189
database tables
creating for DBMS_TRACE, 150
database_role attribute (Scheduler job), 127
DATABASE_TRACE_DISABLE Procedure, 91
DATABASE_TRACE_ENABLE Procedure, 91
datatypes
DBMS_DESCRIBE, 57
PL/SQL
numeric codes for, 57
DATE_TABLE Table Type, 135
DB_CONNECT_INFO Procedure, 89
DB_VERSION procedure, 155
DBLINK_ARRAY Table Type, 155
DBMS, 169
DBMS_ NETWORK_ACL_ADMIN package, 93, 94
DBMS_ALERT package, 19
DBMS_APPLICATION_INFO package, 20
DBMS_APPLY_ADM package, 21
DBMS_AQADM Constants, 23
DBMS_AQELM package, 24
DBMS_AQIN package, 25
DBMS_AUDIT_MGMT package, 27
CLEAN_AUDIT_TRAIL procedure, 27
CLEAR_AUDIT_TRAIL_PROPERTY procedure, 27
CLEAR_LAST_ARCHIVE_TIMESTAMP procedure, 27
CREATE_PURGE_JOB procedure, 27
DEINIT_CLEANUP procedure, 27
DROP_PURGE_JOB procedure, 27
GET_AUDIT_COMMIT_DELAY function, 27
INIT_CLEANUP procedure, 27
IS_CLEANUP_INITIALIZED function, 27
SET_AUDIT_TRAIL_LOCATION procedure, 27
SET_AUDIT_TRAIL_PROPERTY procedure, 27
SET_LAST_ARCHIVE_TIMESTAMP procedure, 27
SET_PURGE_JOB_INTERVAL procedure, 27
SET_PURGE_JOB_STATUS procedure, 27
DBMS_AUTO_TASK_ADMIN package, 29
DBMS_AW_STATS package, 31
DBMS_CAPTURE package, 242
DBMS_CAPTURE_ADM package, 32
DBMS_CDC_PUBLISH package
ALTER_AUTOLOG_CHANGE_SOURCE procedure, 33
ALTER_CHANGE_SET procedure, 33
ALTER_CHANGE_TABLE procedure, 33
ALTER_HOTLOG_CHANGE_SOURCE procedure, 33
CREATE_AUTOLOG_CHANGE_SOURCE procedure, 33
CREATE_CHANGE_SET procedure, 33
CREATE_CHANGE_TABLE procedure, 33
CREATE_HOTLOG_CHANGE_SOURCE procedure, 33
DROP_CHANGE_SET procedure, 33
DROP_CHANGE_SOURCE procedure, 33
DROP_CHANGE_TABLE procedure, 33, 33
DROP_SUBSCRIPTION procedure, 33
Oracle GoldenGate, 33
PURGE procedure, 33
PURGE_CHANGE_SET procedure, 33
PURGE_CHANGE_TABLE procedure, 33
DBMS_CDC_SUBSCRIBE package
ACTIVATE_SUB SCRIPTION procedure, 34
CREATE_SUBSCRIPTION procedure, 34, 34
DROP_SUBSCRIBER_VIEW procedure, 34
DROP_SUBSCRIPTION procedure, 34
EXTEND_WINDOW procedure, 34
GET_SUBSCRIPTION_HANDLE procedure, 34
Oracle GoldenGate, 34
PREPARE_SUBSCRIBER_VIEW procedure, 34
PURGE_WINDOW procedure, 34
SUBSCRIBE procedure, 34
DBMS_CHANGE_NOTIFICATION package, 38
DBMS_COMPARISON package, 35
constants, 35
data structures, 35
index columns, 35
lead index column, 35
requirements, 35
subprograms, 35
using, 35
views, 35
DBMS_CONNECTION_POOL package, 37
DBMS_CONTENT_CONTEXT_T Object Type, 243
DBMS_CSX_ADMIN package, 40
DBMS_CUBE package, 41
DBMS_CUBE_ADVISE package, 42
DBMS_CUBE_LOG package, 43
DBMS_DATA_MINING package, 44
ADD_COST_MATRIX procedure, 44
algorithms, 44
ALL_MINING_MODEL_ATTRIBUTES data dictionary view, 44
ALL_MINING_MODEL_SETTINGS data dictionary view, 44
ALL_MINING_MODELS data dictionary view, 44
ALTER_REVERSE_EXPRESSION procedure, 44
APPLY procedure, 44
Automatic Data Preparation, 44
COMPUTE_CONFUSION_MATRIX procedure, 44
COMPUTE_LIFT procedure, 44
COMPUTE_ROC procedure, 44
CREATE_MODEL procedure, 44
data transformation, 44, 44, 44
data types, 44
deprecated subprograms, 44
DROP_MODEL procedure, 44
EXPORT_MODEL procedure, 44
GET_ASSOCIATION_RULES function, 44
GET_FREQUENT_ITEMSETS function, 44
GET_MODEL_COST_MATRIX function, 44
GET_MODEL_DETAILS_AI function, 44
GET_MODEL_DETAILS_GLM function, 44
GET_MODEL_DETAILS_GLOBAL function, 44
GET_MODEL_DETAILS_KM function, 44
GET_MODEL_DETAILS_NB function, 44
GET_MODEL_DETAILS_NMF function, 44
GET_MODEL_DETAILS_OC function, 44
GET_MODEL_DETAILS_SVM function, 44
GET_MODEL_DETAILS_XML function, 44
GET_MODEL_TRANSFORMATIONS function, 44
GET_TRANSFORM_LIST procedure, 44
IMPORT_MODEL procedure, 44
mining functions, 44
overview, 44
PMML, 44
RANK_APPLY procedure, 44
REMOVE_COST_MATRIX procedure, 44
RENAME_MODEL procedure, 44
scoring, 44, 44, 44, 44, 44, 44, 44
security model, 44
settings
algorithm names, 44
decision tree, 44
GLM, 44
global, 44
k-Means, 44
mining functions, 44
mining models, 44
Naive Bayes, 44
NMF, 44
O-Cluster, 44
SVM, 44
subprograms, 44
supermodels, 44
transactional data, 44
DBMS_DATA_MINING_TRANSFORM
data types, 45
introduction, 45
package, 45
subprograms, 45
DBMS_DATAPUMP package, 46
ADD_FILE procedure, 46
ATTACH function, 46
DATA_FILTER procedure, 46
DETACH procedure, 46
GET_DUMPFILE_INFO procedure, 46
GET_STATUS procedure, 46
LOG_ENTRY procedure, 46
METADATA_FILTER procedure, 46
METADATA_REMAP procedure, 46
METADATA_TRANSFORM procedure, 46
OPEN function, 46
roles used by, 46
SET_PARALLEL procedure, 46
SET_PARAMETER procedure, 46
START_JOB procedure, 46
STOP_JOB procedure, 46
types used by, 46
WAIT_FOR_JOB procedure, 46
DBMS_DB_VERSION package, 51
DBMS_DBFS_CONTENT package, 47
DBMS_DBFS_CONTENT_LIST_ITEM_T Object Type, 243
DBMS_DBFS_CONTENT_LIST_ITEMS_T Table Type, 243
DBMS_DBFS_CONTENT_PROPERTIES_T Table Type, 243
DBMS_DBFS_CONTENT_PROPERTY_T Object Type, 243
DBMS_DBFS_CONTENT_RAW_T Table Type, 243
DBMS_DBFS_CONTENT_SPI package, 48
DBMS_DBFS_HS package, 49
DBMS_DBFS_SFS package, 50
DBMS_DDL package, 53
DBMS_DEBUG package, 52
DBMS_DEFER package documentation, 54
DBMS_DEFER_QUERY package documentation, 55
DBMS_DEFER_SYS package documentation, 56
DBMS_DESCRIBE package, 57
DBMS_DG Package
INITIATE_FS_FAILOVER procedure, 58
DBMS_DG package, 58
using, 58
DBMS_DIMENSION package, 59
DBMS_DISTRIBUTED_TRUST_ADMIN package, 61
DBMS_EPG package, 62, 62
DBMS_EXPFIL package, 64
ADD_ELEMENTARY_ATTRIBUTE, 64
ADD_FUNCTIONS, 64
ASSIGN_ATTRIBUTE_SET, 64
BUILD_EXCEPTIONS_TABLE, 64
CLEAR_EXPRSET_STATS, 64
COPY_ATTRIBUTE_SET, 64
CREATE_ATTRIBUTE_SET, 64
DEFAULT_INDEX_PARAMETERS, 64
DEFAULT_XPINDEX_PARAMETERS, 64
DEFRAG_INDEX, 64
DROP_ATTRIBUTE_SET, 64
GET_EXPRSET_STATS, 64
GRANT_PRIVILEGE, 64
INDEX_PARAMETERS, 64
MODIFY_OPERATOR_LIST, 64
REVOKE_PRIVILEGE, 64
SYNC_TEXT_INDEXES, 64
UNASSIGN_ATTRIBUTE_SET, 64
VALIDATE_EXPRESSIONS, 64
XPINDEX_PARAMETERS, 64
DBMS_FGA package, 65
DBMS_FILE_GROUP package, 66
constants, 66
DBMS_FILE_TRANSFER package, 67
DBMS_FLASHBACK package, 68
DBMS_FREQUENT_ITEMSET package, 70
DBMS_HPROF package, 72
DBMS_HS_PARALLEL package, 73
CREATE_OR_REPLACE_VIEW procedure, 73
CREATE_TABLE_TEMPLATE procedure, 73
DROP_VIEW procedure, 73
LOAD_TABLE procedure, 73
DBMS_HS_PASSTHROUGH package, 74
DBMS_IOT package, 75
DBMS_JAVA package documentation, 76
DBMS_JOB package, 77
DBMS_LDAP package documentation, 78
DBMS_LDAP_UTL package documentation, 79
DBMS_LIBCACHE package, 80
DBMS_LOB package, 81
DBMS_LOCK package, 82
DBMS_LOGMNR package, 83
ADD_LOGFILE procedure, 83
COLUMN_PRESENT function, 83
END_LOGMNR procedure, 83
MINE_VALUE function, 83
REMOVE_LOGFILE procedure, 83
START_LOGMNR procedure, 83
DBMS_LOGMNR_D package, 84
BUILD procedure, 84
SET_TABLESPACE procedure, 84
DBMS_LOGSTDBY package, 85
APPLY_SET procedure, 85
APPLY_UNSET procedure, 85
BUILD procedure, 85
INSTANTIATE_TABLE procedure, 85
MAP_PRIMARY_SCN function, 85
overview of managing SQL Apply, 85
PREPARE_FOR_NEW_PRIMARY procedure, 85
PURGE_SESSION procedure, 85
SET_TABLESPACE procedure, 85
SKIP procedure, 85
SKIP_ERROR procedure, 85
SKIP_TRANSACTION procedure, 85
UNSKIP procedure, 85
UNSKIP_ERROR procedure, 85
UNSKIP_TRANSACTION procedure, 85
using, 85
DBMS_METADATA package, 86
ADD_TRANSFORM function, 86
CLOSE procedure, 86
CONVERT functions and procedures, 86
GET_DDL function, 86
GET_QUERY function, 86
GET_XML function, 86
OPEN function, 86
OPENW function, 86
PUT function, 86
security, 86
SET_COUNT procedure, 86
SET_FILTER procedure, 86
SET_PARSE_ITEM procedure, 86
SET_REMAP_PARAM procedure, 86
SET_TRANSFORM_PARAM procedure, 86
DBMS_METADATA_DIFF package, 87, 87, 87, 87
ADD_DOCUMENT procedure, 87
FETCH_CLOB functions and procedures, 87
OPENC function, 87
DBMS_MGD_ID_UTL package, 88
ADD_SCHEME procedure, 88
CREATE_CATEGORY function, 88
EPC_TO_ORACLE_SCHEME function, 88
GET_CATEGORY_ID function, 88
GET_COMPONENTS function, 88
GET_ENCODINGS function, 88
GET_JAVA_LOGGING_LEVEL function, 88
GET_PLSQL_LOGGING_LEVEL function, 88
GET_SCHEMENAMES function, 88
GET_TDT_XML function, 88
GET_VALIDATOR function, 88
REFRESH_CATEGORY function, 88
REMOVE_CATEGORY procedure, 88
REMOVE_PROXY procedure, 88
REMOVE_SCHEME procedure, 88
SET_JAVA_LOGGING_LEVEL procedure, 88
SET_PLSQL_LOGGING_LEVEL procedure, 88
SET_PROXY procedure, 88
VALIDATE_SCHEME function, 88
DBMS_MGWADM package
summary of subprograms, 89
DBMS_MGWMSG package
constants, 90
summary of subprograms, 90
DBMS_MONITOR package
stastics tracing and gathering
DBMS_MONITOR package, 91
DBMS_MVIEW package
BEGIN_TABLE_REORGANIZATION procedure, 92
END_TABLE_REORGANIZATION procedure, 92
EXPLAIN_MVIEW procedure, 92
EXPLAIN_REWRITE procedure, 92
I_AM_A_REFRESH function, 92
PMARKER function, 92
PURGE_DIRECT_LOAD_LOG procedure, 92
PURGE_LOG procedure, 92
PURGE_MVIEW_FROM_LOG procedure, 92
REFRESH procedure, 92
REFRESH_ALL_MVIEWS procedure, 92
REFRESH_DEPENDENT procedure, 92
REGISTER_MVIEW procedure, 92
UNREGISTER_MVIEW procedure, 92
DBMS_OBFUSCATION_TOOLKIT package, 95
DBMS_ODCI package, 96
ESTIMATE_CPU_UNITS function, 96
methods, 96
DBMS_OFFLINE_OG package documentation, 97
DBMS_OUTLN package, 98
DBMS_OUTPUT package, 99
DBMS_PARALLEL_EXECUTE package, 100
DBMS_PCLXUTIL package, 101
DBMS_PIPE package, 102
DBMS_PREDICTIVE_ANALYTICS package, 103
EXPLAIN procedure, 103
PREDICT procedure, 103
PROFILE Procedure, 103
DBMS_PREPROCESSOR package, 104
DBMS_PROFILER package, 105
DBMS_PROPAGATION_ADM package, 106
DBMS_RANDOM package, 107
DBMS_RECTIFIER_DIFF package documentation, 108
DBMS_REDEFINITION package, 109
DBMS_REFRESH package documentation, 110
DBMS_REPAIR package, 111
DBMS_REPCAT package documentation, 112
DBMS_REPCAT_ADMIN package documentation, 113
DBMS_REPCAT_INSTANTIATE package documentation, 114
DBMS_REPCAT_RGT package documentation, 115
DBMS_REPUTIL package documentation, 116
DBMS_RESCONFIG package, 117
DBMS_RESOURCE_MANAGER package, 118
DBMS_RESOURCE_MANAGER_PRIVS package, 119
DBMS_RESULT_CACHE package, 120
DBMS_RESUMABLE package, 121
DBMS_RLMGR package, 122
ADD_ELEMENTARY_ATTRIBUTE, 122
ADD_EVENT, 122
ADD_FUNCTIONS, 122
ADD_RULE, 122
CONDITION_REF, 122
CONSUME_EVENT, 122
CONSUME_PRIM_EVENT, 122
CREATE_CONDITIONS_TABLE, 122
CREATE_EVENT_STRUCT, 122
CREATE_EXPFIL_INDEXES, 122
CREATE_INTERFACE, 122
CREATE_RULE_CLASS, 122
DELETE_RULE, 122
DROP_CONDITIONS_TABLE, 122
DROP_EVENT_STRUCT, 122
DROP_EXPFIL_INDEXES, 122
DROP_INTERFACE, 122
DROP_RULE_CLASS, 122
EXTEND_EVENT_STRUCT, 122
GET_AGGREGATE_VALUE, 122
GRANT_PRIVILEGE, 122
PROCESS_RULES, 122
PURGE_EVENTS, 122
RESET_SESSION, 122
REVOKE_PRIVILEGE, 122
SYNC_TEXT_INDEXES, 122
DBMS_RLS package, 123
DBMS_RLS.ADD_GROUPED_POLICY parameters
enable, 123
function_schema, 123
long_predicate, 123
object_name, 123
object_schema, 123
policy_function, 123
policy_group, 123
policy_name, 123
policy_type, 123
sec_relevant_cols, 123
statement_types, 123
static_policy, 123
update_check, 123
DBMS_RLS.ADD_POLICY parameters
enable, 123
function_schema, 123
long_predicate, 123
object_name, 123
object_schema, 123
policy_function, 123
policy_name, 123
policy_type, 123
sec_relevant_cols, 123
sec_relevant_cols_opt, 123
statement_types, 123
static_policy, 123
update_check, 123
DBMS_RLS.ADD_POLICY policy types
CONTEXT_SENSITIVE, 123
DYNAMIC, 123
SHARED_CONTEXT_SENSITIVE, 123
SHARED_STATIC, 123
STATIC, 123
DBMS_RLS.ADD_POLICY_CONTEXT parameters
attribute, 123
namespace, 123
object_name, 123
object_schema, 123
DBMS_RLS.CREATE_POLICY_GROUP parameters
object_name, 123
object_schema, 123
policy_group, 123
DBMS_RLS.DELETE_POLICY_GROUP parameters
object_name, 123
object_schema, 123
policy_group, 123
DBMS_RLS.DISABLE_GROUPED_POLICY parameters
group_name, 123
object_name, 123
object_schema, 123
policy_name, 123
DBMS_RLS.DROP_GROUPED_POLICY parameters
object_name, 123, 123
object_schema, 123, 123
policy_group, 123
policy_name, 123, 123
DBMS_RLS.DROP_POLICY_CONTEXT parameters
attribute, 123
namespace, 123
object_name, 123
object_schema, 123
DBMS_RLS.ENABLE_GROUPED_POLICY parameters
enable, 123
group_name, 123
object_name, 123
object_schema, 123
policy_name, 123
DBMS_RLS.ENABLE_POLICY parameters
enable, 123
object_name, 123
object_schema, 123
policy_name, 123
DBMS_RLS.REFRESH_GROUPED_POLICY parameters
group_name, 123
object_name, 123
object_schema, 123
policy_name, 123
DBMS_RLS.REFRESH_POLICY parameters
object_name, 123
object_schema, 123
policy_name, 123
DBMS_ROWID package, 124
DBMS_RULE package, 125
DBMS_RULE_ADM package, 126
DBMS_SCHEDULER package, 127
DBMS_SERVER_ALERT package, 128
DBMS_SERVICE package, 129
DBMS_SESSION package, 130
DBMS_SHARED_POOL package, 131
DBMS_SPACE package, 132
DBMS_SPACE_ADMIN package, 133
DBMS_SPM package, 134
DBMS_SQL package, 135
DBMS_SQLDIAG package, 136
DBMS_SQLTUNE package, 28, 28, 137, 138, 138
DBMS_STAT_FUNCS package, 139
DBMS_STATS package, 140
DBMS_STORAGE_MAP package, 141
DBMS_STREAMS package, 142
DBMS_STREAMS_ADM package, 143
apply user, 143
deprecated subprograms, 143
inbound server rules, 143
inbound servers, 143
outbound server rules, 143
DBMS_STREAMS_ADVISOR_ADM package, 144
constants, 144
operational notes, 144
subprograms, 144
using, 144
views, 144
DBMS_STREAMS_AUTH package, 145
DBMS_STREAMS_HANDLER_ADM package, 146
DBMS_STREAMS_MESSAGING package, 147
DBMS_STREAMS_TABLESPACE package, 148
DBMS_TDB package, 149
DBMS_TDB.CHECK_DB Function, 149
DBMS_TDB.CHECK_DB procedure, 149
DBMS_TRACE package, 150
DBMS_TRANSACTION package, 151
DBMS_TRANSFORM package, 152
DBMS_TTS package, 153
DBMS_TYPES package, 154
DBMS_UTILITY package, 155
DBMS_WARNING package, 156
DBMS_WM package documentation, 157
DBMS_WORKLOAD_RECORD package, 158
DBMS_WORKLOAD_REPLAY package, 159
DBMS_WORKLOAD_REPOSITORY package, 160
DBMS_XA_XID Object Type, 161
DBMS_XA_XID_ARRAY Table Type, 161
DBMS_XBD_VERSION package, 164
DBMS_XDB Constants, 162
DBMS_XDB Overview, 162
DBMS_XDB package, 162
ACLCHECKPRIVILEGES function, 162
CFG_GET function, 162
CFG_REFRESH procedure, 162
CFG_UPDATE procedure, 162
CHECKPRIVILEGES function, 162
CONFIGUREAUTOSYNC procedure, 166
constants, 162
ConText synchronization settings, 166
CREATEDATASTOREPREF procedure, 166
CREATEFILTERPREF procedure, 166
CREATEFOLDER function, 162
CREATEINDEX procedure, 166
CREATELEXERPREF procedure, 166
CREATEOIDPATH function, 162
CREATEPREFERENCES procedure, 166
CREATERESOURCE function, 162
CREATESECTIONGROUPPREF procedure, 166
CREATESTOPLISTPREF procedure, 166
CREATESTORAGEPREF procedure, 166
CREATEWORLDLISTPREF procedure, 166
DELETERESOURCE procedure, 162
DROPPREFERENCES procedure, 166
EXISTSRESOURCE function, 162
filtering settings, 166
general indexing settings, 166
GETACLDOCUMENT function, 162
GETLOCKTOKEN procedure, 162
GETRESOID function, 162
GETXDB_TABLESPACE function, 162
LOCKRESOURCE function, 162
methods, 162, 166
miscellaneous settings, 166
MOVEXDB_TABLESPACE procedure, 162
other index preference settings, 166
REBUILDHIERARCHICALINDEX procedure, 162
RENAMERESOURCE procedure, 162
sectioning and section group settings, 166
SETACL procedure, 162
stoplist settings, 166
SYNC settings, 166
UNLOCKRESOURCE function, 162
DBMS_XDB_ADMIN package, 163
DBMS_XDB_VERSION package
CHECKIN function, 164
CHECKOUT procedure, 164
GETCONTENTSBLOBBYRESID function, 164
GETCONTENTSCLOBBYRESID function, 164
GETCONTENTSXMLBYRESID function, 164
GETPREDECESSORS function, 164
GETPREDSBYRESID function, 164
GETRESOURCEBYRESID function, 164
GETSUCCESSORS function, 164
GETSUCCSBYRESID function, 164
MAKEVERSIONED function, 164
UNCHECKOUT function, 164
DBMS_XDBRESOURCE package, 165
DBMS_XDBZ package
DISABLE_HIERARCHY procedure, 167
ENABLE_HIERARCHY procedure, 167
GET_ACLOID function, 167
GET_USERID function, 167
IS_HIERARCHY_ENABLED function, 167
PURGELDAPCACHE function, 167
DBMS_XMLDOM Constants, 169
DBMS_XMLDOM package, 169
APPENDDATA procedure, 169
CREATEATTRIBUTE function, 169
CREATECDATASECTION function, 169
CREATECOMMENT function, 169
CREATEDOCUMENT function, 169
CREATEDOCUMENTFRAGMENT, 169
CREATEELEMENT function, 169
CREATEENTITYREFERENCE function, 169
CREATEPROCESSINGINSTRUCTION function, 169
CREATETEXTNODE function, 169
DELETEDATA procedure, 169
description, 169
exceptions, 169
FINDENTITY function, 169
FINDNOTATION function, 169
FREEDOCFRAG procedure, 169
FREEDOCUMENT procedure, 169
GETATTRIBUTE function, 169
GETATTRIBUTENODE function, 169
GETBUBLICID function, 169
GETCHARSET function, 169
GETCHILDRENBYTAGNAME function, 169
GETDATA function, 169
GETDOCTYPE function, 169
GETDOCUMENTELEMENT function, 169
GETELEMENTSBYTAGNAME function, 169, 169
GETENTITIES function, 169
GETEXPANDEDNAME function, 169, 169
GETIMPLEMENTATION function, 169
GETLENGTH function, 169, 169, 169
GETNAME function, 169, 169
GETNAMEDITEM function, 169
GETNAMESPACE function, 169, 169
GETNAMESPACE procedure, 169
GETNEXTSIBLING function, 169
GETNODENAME function, 169
GETNODETYPE function, 169
GETNODEVALUE function, 169
GETNOTATIONNAME function, 169
GETNOTATIONS function, 169
GETOWNERDOCUMENT function, 169
GETOWNERELEMENT function, 169
GETPARENTNODE function, 169
GETPREFIX function, 169
GETPREVIOUSSIBLING function, 169
GETPUBLICID function, 169, 169
GETQUALIFIEDNAME function, 169, 169
GETSCHEMANODE function, 169
GETSPECIFIED function, 169
GETSTANDALONE function, 169
GETSYSTEMID function, 169, 169, 169
GETTAGNAME function, 169
GETTARGET function, 169
GETVALUE function, 169
GETVERSION function, 169
GETXMLTYPE function, 169
HASATTRIBUTE function, 169
HASATTRIBUTES function, 169
HASCHILDNODES function, 169
HASFEATURE function, 169
IMPORTNODE function, 169
INSERTBEFORE function, 169
INSERTDATA procedure, 169
ISNULL function, 169
MAKEATTR function, 169
MAKECDATASECTION function, 169
MAKECHARACTERDATA function, 169
MAKECOMMENT function, 169
MAKEDOCUMENT function, 169
MAKEDOCUMENTFRAGMENT function, 169
MAKEDOCUMENTTYPE function, 169
MAKEELEMENT function, 169
MAKEENTITY function, 169
MAKEENTITYREFERENCE function, 169
MAKENODE function, 169, 169, 169, 169
MAKENOTATION function, 169
MAKEPROCESSINGINSTRUCTION function, 169
MAKETEXT function, 169
methods
APPENDCHILD function, 169
APPENDDATA procedure, 169
CLONENODE function, 169
CREATEATTRIBUTE function, 169
CREATECDATASECTION function, 169
CREATECOMMENT function, 169
CREATEDOCUMENT function, 169
CREATEDOCUMENTFRAGMENT function, 169
CREATEELEMENT function, 169
CREATEENTITYREFERENCE function, 169
CREATEPROCESSINGINSTRUCTION function, 169
CREATETEXTNODE function, 169
DELETEDATA procedure, 169
DOMAttr interface, 169
DOMCDataSection interface, 169
DOMCharacterData interface, 169
DOMComment interface, 169
DOMDocument interface, 169
DOMDocumentFragment interface, 169, 169
DOMDocumentType interface, 169, 169
DOMElement interface, 169, 169
DOMEntity interface, 169, 169
DOMEntityReference interface, 169
DOMImplementation interface, 169
DOMNamedNodeMap interface, 169
DOMNode, 169, 169, 169, 169, 169, 169, 169, 169
DOMNodeList interface, 169
DOMNotation interface, 169
DOMProcessingInstruction interface, 169
DOMText interface, 169, 169
FINDENTITY function, 169
FINDNOTATION function, 169
FREEDOCFRAG procedure, 169
FREEDOCUMENT procedure, 169
FREEELEMENT procedure, 169
FREENODE procedure, 169, 169, 169
FREENODELIST Procedure, 169
GETATTRIBUTE function, 169
GETATTRIBUTENODE function, 169
GETATTRIBUTES function, 169
GETBUBLICID function, 169
GETCHARSET function, 169
GETCHILDNODES function, 169
GETCHILDRENBYTAGNAME function, 169
GETDATA function, 169
GETDOCTYPE function, 169
GETDOCUMENTELEMENT function, 169
GETELEMENTSBYTAGNAME function, 169, 169
GETENTITIES function, 169
GETEXPANDEDNAME function, 169, 169
GETEXPANDEDNAME procedure, 169
GETFIRSTCHILD function, 169
GETIMPLEMENTATION function, 169
GETLASTCHILD function, 169
GETLENGTH function, 169, 169, 169
GETLOCALNAME procedure, 169
GETNAME function, 169, 169
GETNAMEDITEM function, 169
GETNAMESPACE function, 169, 169
GETNAMESPACE procedure, 169
GETNEXTSIBLING function, 169
GETNODENAME function, 169
GETNODETYPE function, 169
GETNODEVALUE function, 169
GETNOTATIONNAME function, 169
GETNOTATIONS function, 169
GETOWNERDOCUMENT function, 169
GETOWNERELEMENT function, 169
GETPARENTNODE function, 169
GETPREFIX function, 169
GETPREVIOUSSIBLING function, 169
GETPUBLICID function, 169, 169
GETQUALIFIEDNAME function, 169, 169
GETSCHEMANODE function, 169
GETSPECIFIED function, 169
GETSTANDALONE function, 169
GETSYSTEMID function, 169, 169, 169
GETTAGNAME function, 169
GETTARGET function, 169
GETVALUE function, 169
GETVERSION function, 169
GETXMLTYPE function, 169
HASATTRIBUTE function, 169
HASATTRIBUTES function, 169
HASCHILDNODES function, 169
HASFEATURE function, 169
IMPORTNODE function, 169
INSERTBEFORE function, 169
INSERTDATA procedure, 169
ISNULL function, 169
MAKEATTR function, 169
MAKECDATASECTION function, 169
MAKECHARACTERDATA function, 169
MAKECOMMENT function, 169
MAKEDOCUMENT function, 169
MAKEDOCUMENTFRAGMENT function, 169
MAKEDOCUMENTTYPE function, 169
MAKEELEMENT function, 169
MAKEENTITY function, 169
MAKEENTITYREFERENCE function, 169
MAKENODE function, 169, 169, 169, 169
MAKENOTATION function, 169
MAKEPROCESSINGINSTRUCTION function, 169
MAKETEXT function, 169
NEWDOMDOCUMENT function, 169
NORMALIZE procedure, 169
REMOVEATTRIBUTE procedure, 169
REMOVEATTRIBUTENODE function, 169
REMOVENAMEDITEM function, 169
REPLACECHILD function, 169
REPLACEDATA procedure, 169
RESOLVENAMESPACEPREFIX function, 169
SETATTRIBUTE procedure, 169
SETATTRIBUTENODE function, 169
SETCHARSET procedure, 169
SETDATA procedure, 169
SETNAMEDITEM function, 169
SETNODEVALUE procedure, 169
SETPREFIX procedure, 169
SETSTANDALONE procedure, 169
SETVALUE procedure, 169
SETVERSION procedure, 169
SPLITTEXT function, 169
SUBSTRINGDATA function, 169
WRITETOBUFFER procedure, 169
WRITETOCLOB procedure, 169
WRITETOFILE procedure, 169
NEWDOMDOCUMENT function, 169
NORMALIZE procedure, 169
REMOVEATTRIBUTE procedure, 169
REMOVEATTRIBUTENODE function, 169
REMOVENAMEDITEM function, 169
REPLACECHILD function, 169
REPLACEDATA procedure, 169
RESOLVENAMESPACEPREFIX function, 169
SETATTRIBUTE procedure, 169
SETATTRIBUTENODE function, 169
SETCHARSET procedure, 169
SETDATA procedure, 169
SETNAMEDITEM function, 169
SETNODEVALUE procedure, 169
SETPREFIX procedure, 169
SETSTANDALONE procedure, 169
SETVALUE procedure, 169
SETVERSION procedure, 169
SPLITTEXT function, 169
SUBSTRINGDATA function, 169
types, 68, 169
WRITETOBUFFER procedure, 169
WRITETOCLOB procedure, 169
WRITETOFILE procedure, 169
DBMS_XMLGEN package, 170
CLOSECONTEXT procedure, 170
CONVERT function, 170
GETNUMROWSPROCESSED Function, 170
GETXML function, 170
GETXMLTYPE function, 170
NEWCONTEXT function, 170
RESTARTQUERY procedure, 170
SETCONVERTSPECIALCHARS procedure, 170
SETMAXROWS procedure, 170
SETROWSETTAG procedure, 170
SETROWTAG procedure, 170
SETSKIPROWS procedure, 170
USEITEMTAGSFORCOLL procedure, 170
USENULLATTRIBUTEINDICATOR procedure, 170
DBMS_XMLINDEX package, 171
DBMS_XMLPARSER package, 172
FREEPARSER procedure, 172
GETDOCTYPE function, 172
GETDOCUMENT function, 172
GETRELEASEVERSION function, 172
GETVALIDATIONMODE function, 172
NEWPARSER function, 172
PARSE function, 172, 172
PARSE procedure, 172
PARSEBUFFER procedure, 172
PARSECLOB procedure, 172
PARSEDTD procedure, 172
PARSEDTDBUFFER procedure, 172
PARSEDTDCLOB procedure, 172
SETBASEDIR procedure, 172
SETDOCTYPE procedure, 172
SETERRORLOG procedure, 172
SETPRESERVEWHITESPACE procedure, 172
SETVALIDATIONMODE procedure, 172
SHOWWARNINGS procedure, 172
DBMS_XMLQUERY package, 173
CLOSECONTEXT procedure, 173
constants, 173
GETDTD function, 173
GETDTD procedure, 173
GETEXCEPTIONCONTENT procedure, 173
GETNUMROWSPROCESSED procedure, 173
GETVERSION procedure, 173
GETXML function, 173
GETXML procedure, 173
NEWCONTEXT function, 173
PROPAGATEORIGINALEXCEPTION procedure, 173
REMOVEXSLTPARAM procedure, 173
SETBINDVALUE procedure, 173
SETCOLLIDATTRNAME procedure, 173
SETDATAHEADER procedure, 173
SETDATEFORMAT procedure, 173
SETENCODINGTAG procedure, 173
SETERRORTAG procedure, 173
SETMAXROWS procedure, 173
SETMETAHEADER procedure, 173
SETRAISEEXCEPTION procedure, 173
SETRAISENOROWSEXCEPTION procedure, 173
SETROWIDATTRNAME procedure, 173
SETROWIDATTRVALUE procedure, 173
SETROWSETTAG procedure, 173
SETROWTAG procedure, 173
SETSKIPROWS procedure, 173
SETSQLTOXMLNAMEESCAPING procedure, 173
SETSTYLESHEETHEADER procedure, 173
SETTAGCASE procedure, 173
SETXSLT procedure, 173
SETXSLTPARAM procedure, 173
types, 173
USENULLATTRIBUTEINDICATOR procedure, 173
USETYPEFORCOLLELEMTAG procedure, 173
DBMS_XMLSAVE package, 174
CLEARKEYCOLUMNLIST procedure, 174
CLEARUPDATECOLUMNLIST procedure, 174
CLOSECONTEXT procedure, 174
constants, 174
DELETEXML function, 174
GETEXCEPTIONCONTENT procedure, 174
INSERTXML function, 174
NEWCONTEXT function, 174
PROPAGATEORIGINALEXCEPTION procedure, 174
REMOVEXSLTPARAM procedure, 174
SETBATCHSIZE procedure, 174
SETCOMMITBATCH procedure, 174
SETDATEFORMAT procedure, 174
SETIGNORECASE procedure, 174
SETKEYCOLUMN procedure, 174
SETPRESERVEWHITESPACE procedure, 174
SETROWTAG procedure, 174
SETSQLTOXMLNAMEESCAPING procedure, 174
SETUPDATECOLUMN procedure, 174
SETXSLT procedure, 174
SETXSLTPARAM procedure, 174
UPDATEXML function, 174
DBMS_XMLSCHEMA Constants, 175
DBMS_XMLSCHEMA Operational Notes, 175
DBMS_XMLSCHEMA package, 175
DBMS_XMLSCHEMA Views, 175
DBMS_XMLSTORE package, 176
CLEARKEYCOLUMNLIST procedure, 176
CLEARUPDATECOLUMNLIST procedure, 176
CLOSECONTEXT procedure, 176
DELETEXML function, 176
INSERTXML function, 176
NEWCONTEXT function, 176
SETKEYCOLUMN procedure, 176
SETROWTAG procedure, 176
SETUPDATECOLUMN procedure, 176
types, 176
UPDATEXML function, 176
DBMS_XMLTRANSLATIONS package, 177
DBMS_XPLAN package, 178
DBMS_XSLPROCESSOR Package, 179, 179
DBMS_XSLPROCESSOR package
CLOB2FILE procedure, 179
FREEPROCESSOR procedure, 179
FREESTYLESHEET procedure, 179
NEWPROCESSOR function, 179
NEWSTYLESHEET function, 179
PROCESSXSL function, 179
READ2CLOB function, 179
REMOVEPARAM procedure, 179
RESETPARAMS procedure, 179
SELECTNODES function, 179
SELECTSINGLENODE function, 179
SETERRORLOG procedure, 179
SETPARAM procedure, 179
SHOWWARNINGS procedure, 179
TRANSFORMNODE function, 179
VALUEOF procedure, 179
DBMSOUTPUT_LINESARRAY Object Type, 99
DBUriType, 244
DBURITYPE function, 244
DBUriType subtype, 244
CREATEURI function, 244
DBURITYPE function, 244
GETBLOB function, 244
GETCLOB function, 244
GETCONTENTTYPE function, 244
GETEXTERNALURL function, 244
GETURL function, 244
GETXML function, 244
methods, 244
DEAUTHORIZE_DAD Procedure, 62
DEBUG_EXPTOC package, 180
DEBUG_ON procedure, 52
DECLARE_REWRITE_EQUIVALENCE Procedures, 17
DECODEFEATURES Function, 47
DEFAULT_INDEX_PARAMETERS procedure, 64
DEFAULT_NAME function, 43
DEFAULT_XPINDEX_PARAMETERS procedure, 64
DEFINE_ARRAY procedure, 135
DEFINE_COLUMN procedure, 135
DEFINE_COLUMN_CHAR Procedure, 135
DEFINE_COLUMN_LONG procedure, 135
DEFINE_COLUMN_RAW Procedure, 135
DEFINE_COLUMN_ROWID Procedure, 135
DEFRAG_INDEX procedure, 64
DEINIT_CLEANUP procedure, 27
DELETE Procedure, 16
DELETE_ALL_ERRORS procedure, 21
DELETE_BREAKPOINT function, 52
DELETE_CAPTURE_INFO Procedure, 158
DELETE_CATEGORY Procedure, 118
DELETE_COLUMN member procedure, 247
DELETE_COLUMN procedure, 143
DELETE_COLUMN_STATS pocedure, 140
DELETE_CONSUMER_GROUP procedure, 118
DELETE_DAD_ATTRIBUTE Procedure, 62, 62
DELETE_DATABASE_PREFS Procedure, 140
DELETE_DATABASE_STATS procedure, 140
DELETE_DICTIONARY_STATS procedure, 140
DELETE_ERROR procedure, 21
DELETE_FILTER Procedure, 158, 159
DELETE_FINDING_DIRECTIVE Procedure, 16
DELETE_FIXED_OBJECTS_STATS procedure, 140
DELETE_INDEX_STATS procedure, 140
DELETE_OBJECT procedure, 233
DELETE_OER_BREAKPOINT function, 52
DELETE_PARAMETER_DIRECTIVE Procedure, 16
DELETE_PENDING_STATS Procedure, 140
DELETE_PLAN procedure, 118
DELETE_PLAN_CASCADE procedure, 118
DELETE_PLAN_DIRECTIVE procedure, 118
DELETE_PRIVILEGE Procedure, 93
DELETE_REPLAY_INFO Procedure, 159
DELETE_RULE procedure, 122
DELETE_SCHEMA_PREFS Procedure, 140
DELETE_SCHEMA_STATS Procedure, 140
DELETE_SEGMENT_DIRECTIVE Procedure, 16
DELETE_SERVICE procedure, 129
DELETE_SQL_DIRECTIVE Procedure, 16
DELETE_SQLSET procedure, 138
DELETE_SQLWKLD Procedure, 18
DELETE_SQLWKLD_REF Procedure, 18
DELETE_SQLWKLD_STATEMENT Procedure, 18
DELETE_SYSTEM_STATS procedure, 140
DELETE_TABLE_PREFS Procedure, 140
DELETE_TABLE_STATS procedure, 140
DELETE_TASK Procedure, 18
DELETECONTENT Procedure, 47, 48
DELETEDATA procedure, 169
DELETEDIRECTORY Procedure, 47, 48
DELETEFILE Procedure, 47, 48
DELETEHTTPEXPIREMAPPING Procedure, 162
DELETEMIMEMAPPING Procedure, 162
DELETEREPOSITORYRESCONFIG Procedure, 117
DELETERESCONFIG Procedure, 117
DELETERESOURCE procedure, 162
DELETERESOURCEMETADATA Procedures, 162
DELETESCHEMA procedure, 175
DELETESCHEMALOCMAPPING Procedure, 162
DELETESERVLET Procedure, 162
DELETESERVLETMAPPING Procedure, 162
DELETESERVLETSECROLE Procedure, 162
DELETEXML function, 174, 176
DELETEXMLEXTENSION Procedure, 162
DEQUEUE procedure, 147
DEQUEUE_ARRAY Function, 22
DEQUEUE_OPTIONS_T Type, 242
DEREGISTER Procedure, 38
DEREGSTORECOMMAND Function, 49
DERIVE_FROM_MVIEW function, 41
DESC_REC2 Record Type, 135
DESC_REC3 Record Type, 135
DESC_RESC Record Type, 135
DESC_TAB Table Type, 135
DESC_TAB2 Table Type, 135
DESC_TAB3 Table Type, 135
DESCRIBE_COLUMNS procedure, 135
DESCRIBE_COLUMNS2 procedure, 135
DESCRIBE_COLUMNS3 Procedure, 135
DESCRIBE_DIMENSION procedure, 59
DESCRIBE_PROCEDURE procedure, 57
DESCRIBE_STACK procedure, 45
DESDecrypt procedure, 95, 95
DESEncrypt procedure, 95
DESTROY_REQUEST_CONTEXT Procedure, 223, 223
DETACH_SESSION procedure, 52
DETACH_SIMPLE_TABLESPACE procedure, 148
DETACH_TABLESPACES procedure, 148
DFN function
of HTF package, 181
DFN procedure
of HTP package, 182
DIFF_TABLE_STATS_IN_HISTORY Function, 140
DIFF_TABLE_STATS_IN_PENDING Function, 140
DIFF_TABLE_STATS_IN_STATTAB Function, 140
dimension maintenance (cube), 41
dimensions
optimizer statistics, 31
DIRECTORY_OBJECT_SET type, 148
DIRLISTCLOSE function
of HTF package, 181
DIRLISTCLOSE procedure
of HTP package, 182
DIRLISTOPEN function
of HTF package, 181
DIRLISTOPEN procedure
of HTP package, 182
DISABLE procedure, 43
of DBMS_FLASHBACK package, 68
of DBMS_OUTPUT package, 99
of OWA_CACHE package, 185
DISABLE Procedures, 29
DISABLE_BREAKPOINT function, 52
DISABLE_HIERARCHY procedure, 167
DISABLE_JOB Procedure, 89
DISABLE_PROPAGATION_SCHEDULE Procedure, 89
DISABLETRANSLATION Procedure, 177
DISCONNECT_SESSION procedure, 129
DISPLAY function, 178
DISPLAY_AWR function, 178
DISPLAY_CURSOR function, 178
DISPLAY_PLAN Function, 178
DISPLAY_SQL_PLAN_BASELINE Function, 178
DISPLAY_SQLSET Function, 178
DIST_TXN_SYNC Procedure, 161
DIV function
of HTF package, 181
DIV procedure
of HTP package, 182
DLISTCLOSE function
of HTF package, 181
DLISTCLOSE procedure
of HTP package, 182
DLISTDEF function
of HTF package, 181
DLISTDEF procedure
of HTP package, 182
DLISTOPEN function
of HTF package, 181
DLISTOPEN procedure
of HTP package, 182
DLISTTERM function
of HTF package, 181
DLISTTERM procedure
of HTP package, 182
DOMAIN_LEVEL Function, 94
DOMAINS Function, 94
DOMAttr methods, 169
DOMCDataSection methods, 169
DOMCharacterData methods, 169
DOMComment methods, 169
DOMDocument methods, 169
DOMDocumentType methods, 169, 169
DOMEntity methods, 169
DOMNamedNodeMap methods, 169
DOMText methods, 169
DOWNGRADE procedure, 153
DOWNLOAD_FILE procedures, 238
DROFILESYSTEM Procedures, 50
DROP_ACL Procedure, 93
DROP_ALL function, 141
DROP_ANALYSIS_TASK Procedure, 137
DROP_APPLY procedure, 21
DROP_ATTRIBUTE_SET procedure, 64
DROP_BASELINE procedure, 160
DROP_BY_CAT procedure, 98
DROP_CAPTURE procedure
capture process
dropping, 32
DROP_CHUNKS Procedure, 100
DROP_COMPARISON Procedure, 35
DROP_CONDITIONS_TABLE procedure, 122
DROP_DAD Procedure, 62
DROP_DIAGNOSIS_TASK Procedure, 136
DROP_EMPTY_SEGMENTS Procedure, 133
DROP_EVALUATION_CONTEXT procedure, 126
DROP_EVENT_STRUCT procedure, 122
DROP_EXPFIL_INDEXES procedure, 122
DROP_EXTENDED_STATS Procedure, 140
DROP_FILE function, 141
DROP_FILE_GROUP procedure, 66
DROP_INTERFACE procedure, 122
DROP_MVIEW procedure, 41, 41
DROP_OBJECT_DEPENDENCY procedure, 21
DROP_PROPAGATION procedure, 106
DROP_PURGE_JOB procedure, 27
DROP_REWRITE_EQUIVALENCE Procedure, 17
DROP_RULE procedure, 126
DROP_RULE_CLASS procedure, 122
DROP_RULE_SET procedure, 126
DROP_SNAPSHOT_RANGE procedure, 160
DROP_SQL_PATCH Function & Procedure, 136
DROP_SQL_PLAN_BASELINE, 134
DROP_SQL_PROFILE procedure, 138
DROP_SQLSET procedure, 138
DROP_STAT_TABLE procedure, 140
DROP_STMT_HANDLER procedure, 146
DROP_TASK Procedure, 100
DROP_TRANSFORMATION procedure, 152
DROP_TUNING_TASK procedure, 138
DROP_UNUSED procedure, 98
DROP_VERSION procedure, 66
DROP_VIEW procedure
of DBMS_HS_PARALLEL package, 73
DROPPARAMETER Procedure, 171
DROPPREFERENCES procedure, 166
DROPREPOSITORYXMLINDEX Procedure, 163
DROPSTORE Procedure, 49
DUMP_ORPHAN_KEYS procedure, 111
dynamic SQL
anonymous blocks and, 135
DBMS_SQL functions, using, 135
execution flow in, 135

E

EDIT_DISTANCE Function, 229
EDIT_DISTANCE_SIMILARITY Function, 229
EHLO function and procedure, 234
EM function
of HTF package, 181
EM procedure
of HTP package, 182
e-mail from PL/SQL (email), 236
EMPHASIS function
of HTF package, 181
EMPHASIS procedure
of HTP package, 182
ENABLE procedure, 43, 99
ENABLE Procedures, 29
ENABLE_AT_SYSTEM_CHANGE_NUMBER procedure, 68
ENABLE_AT_TIME procedure, 68
ENABLE_BREAKPOINT function, 52
ENABLE_HIERARCHY procedure, 167
ENABLE_JOB Procedure, 89
ENABLE_PROPAGATION_SCHEDULE Procedure, 89
ENABLETRANSLATION Procedure, 177
END_PREPARE Procedure, 60
END_REQUEST procedure, 223
END_RESPONSE procedure, 223
END_SQL_BLOCK Procedure, 118
END_UPGRADE Procedure, 60
ENDCREATE member procedure
of ANYDATA TYPE, 239
of ANYDATASET TYPE, 240
of ANYTYPE TYPE, 241
ENQUEUE procedure, 147
ENQUEUE_ARRAY Function, 22
ENQUEUE_OPTIONS_T Type, 242
ENQUOTE_LITERAL Function, 26
ENQUOTE_NAME Function, 26
EPC_TO_ORACLE_SCHEME function, 88
EQUALS_HOST Function, 94
ERASE Procedures, 81
error queue
deleting errors, 21, 21
executing errors, 21, 21
getting error messages, 21
ESCAPE function, 237
ESCAPE_SC function
of HTF package, 181
ESCAPE_SC procedure
of HTP package, 182
ESCAPE_URL function
of HTF package, 181
ESCAPEURI function, 244
ESTIMATE_CPU_UNITS function, 96
ESTIMATE_MVIEW_SIZE Procedure, 92
ETINSTANCE member function
of ANYDATASET TYPE, 240
EVALUATE procedure, 125
EVOLVE_SQL_PLAN_BASELINE Function, 134
EXACT_TEXT_SIGNATURES procedure, 98
EXEC_DDL_STATEMENT procedure, 155
EXECUTE function, 135
EXECUTE member procedure, 247, 247
EXECUTE procedure, 52
EXECUTE_ALL_ERRORS procedure, 21
EXECUTE_ANALYSIS_TASK, 137
EXECUTE_AND_FETCH function, 135
EXECUTE_DIAGNOSIS_TASK Procedure, 136
EXECUTE_ERROR procedure, 21
EXECUTE_IMMEDIATE Procedure, 74
EXECUTE_NON_QUERY Function, 74
EXECUTE_TASK Procedure, 18
EXECUTE_TUNING_TASK Function & Procedure, 28, 138
execution flow
in dynamic SQL, 135
EXF$ATTRIBUTE object type, 246
EXF$ATTRIBUTE_LIST object type, 246
EXF$INDEXOPER object type, 246
EXF$TABLE_ALIAS object type, 246
EXF$TEXT object type, 246
EXF$XPATH_TAG object type, 246
EXF$XPATH_TAGS object type, 246
EXISTSNODE function, 258
EXISTSRESOURCE function, 162
EXPAND_MESSAGE function, 128
EXPLAIN_SQL_TESTCASE Function, 136
EXPONENTIAL_DIST_FIT procedure, 139
EXPORT_AWR Procedure, 158, 159
EXPORT_COLUMN_STATS procedure, 140
EXPORT_DATABASE_PREFS Procedure, 140
EXPORT_DATABASE_STATS procedure, 140
EXPORT_DICTIONARY_STATS procedure, 140
EXPORT_FIXED_OBJECTS_STATS procedure, 140
EXPORT_INDEX_STATS procedure, 140
EXPORT_PENDING_STATS Procedure, 140
EXPORT_SCHEMA_PREFS Procedure, 140
EXPORT_SCHEMA_STATS procedure, 140
EXPORT_SQL_TESTCASE Procedures, 136
EXPORT_SQL_TESTCASE_DIR_BY_INC Function, 136
EXPORT_SQL_TESTCASE_DIR_BY_TXT Function, 136
EXPORT_SYSTEM_STATS procedure, 140
EXPORT_TABLE_PREFS Procedure, 140
EXPORT_TABLE_STATS procedure, 140
EXPORT_XML procedure, 41, 41
EXPORT_XML_TO_FILE procedure, 41, 41
Expression Filter object types, 246
extend window
to create a new view, 34
EXTEND_EVENT_STRUCT procedure, 122
EXTRACT function, 258
EXTRACTXLIFF Function & Procedure, 177

F

FCLOSE procedure, 222
FCLOSE_ALL procedure, 222
FCOPY procedure, 222
FEATURE_T Record Type, 47
FEATURENAME Function, 47
FEATURES_T Table Type, 47
FETCH_ROW Function, 74
FETCH_ROWS function, 135
FFLUSH procedure, 222
FGETATTR procedure, 222
FGETPOS function, 222
FI_HORIZONTAL function, 70
FI_TRANSACTIONAL function, 70
file groups, 66
adding files, 66
altering, 66
altering files, 66
altering versions, 66
creating, 66
creating versions, 66
dropping, 66
dropping versions, 66
granting object privileges, 66
granting system privileges, 66
purging, 66
removing files, 66
revoking object privileges, 66
revoking system privileges, 66
FILE type, 148
FILE_SET type, 148
FILECLOSE Procedure, 81
FILECLOSEALL Procedure, 81
FILEEXISTS Function, 81
FILEGETNAME Procedure, 81
FILEISOPEN Function, 81
FILEOPEN Procedure, 81
FILETYPE Record Type, 222
FIND_AFFECTED_TABLE Procedure, 60
FINDENTITY function, 169
FINDNOTATION function, 169
fine-grained access control
DBMS_RLS package, 123
FINISH_CAPTURE Procedure, 158
FINISH_REDEF_TABLE procedure, 109
FIX_CORRUPT_BLOCKS procedure, 111
FLUSH Function & Procedure, 120
FLUSH procedure, 43, 236
FLUSH_DATA function and procedure, 105
FLUSH_DATABASE_MONITORING_INFO procedure, 140
FLUSHCACHE Procedure, 49
FONTCLOSE function
of HTF package, 181
FONTCLOSE procedure
of HTP package, 182
FONTOPEN function
of HTF package, 181
FONTOPEN procedure
of HTP package, 182
FOPEN function, 222
FOPEN_NCHAR function, 222
FORCE parameter
and job-to-instance affinity, 77
FORMAT function, 254
FORMAT_CALL_STACK Function, 155
FORMAT_CELL function
of HTF package, 181
FORMAT_ERROR_BACKTRACE function, 155
FORMAT_ERROR_STACK function, 155
FORMCHECKBOX function
of HTF package, 181
FORMCHECKBOX procedure
of HTP package, 182
FORMCLOSE function
of HTF package, 181, 181
FORMCLOSE procedure
of HTP package, 182
FORMFILE function
of HTF package, 181
FORMFILE procedure
of HTP package, 182, 182
FORMHIDDEN function
of HTF package, 181
FORMHIDDEN procedure
of HTP package, 182
FORMIMAGE function
of HTF package, 181
FORMIMAGE procedure
of HTP package, 182
FORMOPEN function
of HTF package, 181
FORMOPEN procedure
of HTP package, 182
FORMPASSWORD function
of HTF package, 181
FORMPASSWORD procedure
of HTP package, 182
FORMRADIO function
of HTF package, 181
FORMRADIO procedure
of HTP package, 182
FORMRESET function
of HTF package, 181
FORMRESET procedure
of HTP package, 182
FORMSELECTCLOSE function
of HTF package, 181
FORMSELECTCLOSE procedure
of HTP package, 182
FORMSELECTOPEN function
of HTF package, 181
FORMSELECTOPEN procedure
of HTP package, 182
FORMSELECTOPTION function
of HTF package, 181
FORMSELECTOPTION procedure
of HTP package, 182
FORMSUBMIT function
of HTF package, 181
FORMSUBMIT procedure
of HTP package, 182
FORMTEXT function
of HTF package, 181
FORMTEXT procedure
of HTP package, 182
FORMTEXTAREA function
of HTF package, 181
FORMTEXTAREA procedure
of HTP package, 182
FORMTEXTAREA2 function
of HTF package, 181
FORMTEXTAREA2 procedure
of HTP package, 182
FORMTEXTAREACLOSE function
of HTF package, 181
FORMTEXTAREACLOSE procedure
of HTP package, 182
FORMTEXTAREAOPEN function
of HTF package, 181
FORMTEXTAREAOPEN procedure
of HTP package, 182
FORMTEXTAREAOPEN2 function
of HTF package, 181
FORMTEXTAREAOPEN2 procedure
of HTP package, 182
FRAGMENT_DELETE Procedure, 81
FRAGMENT_INSERT Function, 81
FRAGMENT_MOVE Procedure, 81
FRAGMENT_REPLACE Procedure, 81
FRAME function
of HTF package, 181
FRAME procedure
of HTP package, 182
FRAMESETCLOSE function
of HTF package, 181
FRAMESETCLOSE procedure
of HTP package, 182
FRAMESETOPEN function
of HTF package, 181
FRAMESETOPEN procedure
of HTP package, 182
FREE_BLOCKS procedure, 132
FREE_UNUSED_USER_MEMORY Procedure, 130
FREEDOCFRAG procedure, 169
FREEDOCUMENT procedure, 169
FREENODE procedure, 169, 169
FREEPARSER procedure, 172
FREEPROCESSOR procedure, 179
FREERESOURCE Procedure, 165
FREESTYLESHEET procedure, 179
FREETEMPORARY Procedures, 81
FREMOVE procedure, 222, 222
FRENAME procedure, 222
FSEEK procedure, 222
functions
adding to attribute sets, 64, 122

G

GATHER_DATABASE_STATS procedures, 140
GATHER_DICTIONARY_STATS procedure, 140
GATHER_FIXED_OBJECTS_STATS procedure, 140
GATHER_INDEX_STATS Procedure, 140
GATHER_OPTIMIZER_STATS Procedure, 30
GATHER_SCHEMA_STATS procedures, 140
GATHER_SYSTEM_STATS procedure, 140
GATHER_TABLE_STATS procedure, 140
GENERATE_STATS procedure, 140
GENERATE_TASK_NAME Function, 100
GENERATESCHEMAS function, 175
GET function
of OWA_COOKIE package, 186
GET* member functions
of ANYDATA TYPE, 239
of ANYDATASET TYPE, 240
GET_ACLOID function, 167
GET_AGGREGATE_VALUE function, 122
GET_ALL procedure, 186
GET_ALL_DAD_ATTRIBUTES Procedure, 62
GET_ALL_DAD_MAPPINGS Procedure, 62
GET_ALL_GLOBAL_ATTRIBUTES Procedure, 62
GET_ALL_NAMES member function, 255
GET_ASH_QUERY Function, 16
GET_AUDIT_COMMIT_DELAY function, 27
GET_AUTHENTICATION procedure, 223
GET_BASE_TABLE_NAME member function, 247
GET_BASE_TABLE_OWNER member function, 247
GET_BODY_CHARSET procedure, 223
GET_CAPTURE_INFO Function, 158
GET_CATEGORY function, 156
GET_CATEGORY_ID function, 88
GET_CGI_ENV function, 193
GET_CLIENT_ATTRIBUTES Procedure, 29
GET_CLIENT_HOSTNAME function, 191
GET_CLIENT_IP function, 191
GET_COLUMN_STATS procedures, 140
GET_COMMAND_TYPE member function, 247
GET_COMMIT_SCN member function, 247
GET_COMMIT_SCN_FROM_POSITION static function, 247
GET_COMMIT_TIME member function, 247
GET_COMMON_TIME_ZONES Function, 224
GET_COMPATIBLE member function, 247
GET_COMPONENT function, 254
GET_COMPONENTS function, 88
GET_COMPRESSION_RATIO Procedure, 36
GET_COMPRESSION_TYPE Function, 36
GET_COOKIE_COUNT function, 223
GET_COOKIE_SUPPORT procedure, 223
GET_COOKIES function, 223
GET_CPU_TIME function, 155
GET_CURRENT_SCHEMA member function, 247
GET_DAD_ATTRIBUTE Function, 62
GET_DAD_LIST Procedure, 62
GET_DBFS_LINK Functions, 81
GET_DBFS_LINK_STATE Procedure, 81
GET_DEFAULT_ISO_CURRENCY Function, 224
GET_DEFAULT_LINGUISTIC_SORT Function, 224
GET_DEPENDENCY procedure, 155
GET_DETAILED_EXCP_SUPPORT procedure, 223
GET_DETAILED_SQLCODE function, 223
GET_DETAILED_SQLERRM function, 223
GET_DIVERGING_STATEMENT Function, 159
GET_EDITION_NAME member function, 247
GET_ENCODINGS function, 88
GET_ENDIANNESS Function, 155
GET_ERROR_MESSAGE function, 21
GET_ETAG function, 185
GET_EXPRESSION function, 45
GET_EXPRSET_STATS procedure, 64
GET_EXTRA_ATTRIBUTE member function, 247
GET_FILE procedure, 67
GET_FIX_CONTROL Function, 136
GET_FOLLOW_REDIRECT procedure, 223
GET_GLOBAL_ATTRIBUTE Function, 62
GET_HASH_VALUE function, 155
GET_HEADER procedure, 223
GET_HEADER_BY_NAME procedure, 223
GET_HEADER_COUNT function, 223
GET_HOST_ADDRESS function, 225
GET_HOST_NAME function, 225
GET_INDEX_STATS procedures, 140
GET_INDEXES function, 52
GET_INFORMATION function, 142
GET_JAVA_LOGGING_LEVEL function, 88
GET_LEVEL function, 185
GET_LINE function, 236
GET_LINE procedure, 99, 222
GET_LINE_MAP function, 52
GET_LINE_NCHAR Function, 236
GET_LINE_NCHAR procedure, 222
GET_LINES procedure, 99
GET_LOB_INFORMATION member function, 247
GET_LOB_OFFSET member function, 247
GET_LOB_OPERATION_SIZE member procedure, 247
GET_LOCAL_LINGUISTIC_SORTS Function, 224
GET_LOG procedure, 43
GET_LOG_SPEC function, 43
GET_LOGON_USER member function, 247
GET_LONG_INFORMATION member function, 247
GET_MESSAGE_TRACKING function, 143
GET_MORE_SOURCE procedure, 52
GET_NEXT_HIT function, 125
GET_NUMBER_COL_CHUNK Procedure, 100
GET_OBJECT_NAME member function, 247
GET_OBJECT_OWNER member function, 247
GET_OBJECT_TYPE member function, 247
GET_OWA_SERVICE_PATH function, 193
GET_P1_RESOURCES Procedure, 29
GET_PACKAGE_MEMORY_UTILIZATION Procedure, 130
GET_PARAM function, 140
GET_PARAMETER function, 43
GET_PARAMETER_VALUE function, 155
GET_PASSWORD function, 191
GET_PERSISTENT_CONN_COUNT function, 223
GET_PERSISTENT_CONN_SUPPORT procedure, 223
GET_PERSISTENT_CONNS procedure, 223
GET_PLSQL_LOGGING_LEVEL function, 88
GET_PLSQL_TRACE_LEVEL function, 150
GET_POSITION member function, 247
GET_POST_PROCESSED_SOURCE Functions, 104
GET_PREFS Function, 140
GET_PROCEDURE function, 193
GET_PROXY procedure, 223
GET_RAW function, 222, 236
GET_REC_ATTRIBUTES Procedure, 18
GET_REPLAY_INFO Function, 159
GET_REPLAY_TIMEOUT Procedure, 159
GET_REPORT Function, 16
GET_RESPONSE function, 223
GET_RESPONSE_ERROR_CHECK procedure, 223
GET_ROW_TEXT member procedure, 247
GET_ROWID function, 189
GET_ROWID_CHUNK Procedure, 100
GET_RUN_REPORT Function, 71
GET_RUNTIME_INFO function, 52
GET_SCHEME_NAMES function, 88
GET_SCN member function, 247
GET_SCN_FROM_POSITION static function, 247
GET_SCN_MAPPING procedure, 143
GET_SESSION_TIMEOUT function, 121
GET_SOURCE_DATABASE_NAME member function, 247
GET_SOURCE_TIME member function, 247
GET_SQL Function, 136
GET_SQL_HASH Function, 155
GET_STATS_HISTORY_AVAILABILITY function, 140
GET_STATS_HISTORY_RETENTION function, 140
GET_STREAMS_NAME function, 142
GET_STREAMS_TYPE function, 142
GET_SYSTEM_STATS procedure, 140
GET_TABLE_STATS procedure, 140
GET_TAG function, 142, 143
GET_TAG member function, 247
GET_TASK_REPORT Procedure, 18
GET_TASK_SCRIPT Procedure, 18
GET_TDT_XML function, 88
GET_TEXT function, 236
GET_TEXT_NCHAR Function, 236
GET_THREAD_NUMBER member function, 247
GET_THRESHOLD procedure, 128
GET_TIME function, 155
GET_TIMEOUT function, 121
GET_TIMEOUT_BEHAVIOUR function, 52
GET_TRANSACTION_ID member function, 247
GET_TRANSFER_TIMEOUT procedure, 223
GET_USER_ID function, 191
GET_USERID function, 167
GET_VALIDATOR function, 88
GET_VALUE function, 52
GET_VALUE member function, 247, 255
GET_VALUE Procedure, 74
GET_VALUE_RAW Procedure, 74
GET_VALUES member function, 247
GET_VERSION procedure, 105
GET_WARNING_SETTING_CAT function, 156
GET_WARNING_SETTING_NUM function, 156
GET_WARNING_SETTING_STRING function, 156
GET_WHERE_CLAUSE member procedure, 247
GET_X function, 188
GET_XML_INFORMATION member function, 247
GET_Y function, 188
GETACL Function, 165
GETACLDOCFROMRES Function, 165
GETACLDOCUMENT function, 162
GETAPPLICATIONDATA Function, 168
GETATTRELEMINFO member function
of ANYTYPE TYPE, 241
GETATTRIBUTE function, 169
GETATTRIBUTENODE function, 169
GETATTRIBUTES function, 169
GETAUTHOR Function, 165
GETBASEDOCUMENT Function, 177
GETBLOB function, 244, 244, 244, 244
GETBLOBVAL function, 258
GETBUBLICID function, 169
GETCHARACTERSET Function, 165
GETCHARSET Function, 169
GETCHILDNODES function, 169
GETCHILDOID Function, 168
GETCHILDRENBYTAGNAME function, 169
GETCHILDRESPATHS Function, 162
GETCHUNKSIZE Functions, 81
GETCLOB function, 244, 244, 244, 244
GETCLOBVAL function, 258
GETCOMMENT Function, 165
GETCONTENTBLOB Function, 162, 165
GETCONTENTCLOB Function, 162, 165
GETCONTENTREF Function, 165
GETCONTENTSBLOBBYRESID function, 164
GETCONTENTSCLOBBYRESID function, 164, 164
GETCONTENTSXMLBYRESID function, 164
GETCONTENTTYPE Function, 165
GETCONTENTTYPE function, 244, 244, 244, 244
GETCONTENTTYPE Functions, 81
GETCONTENTVARCHAR2 Function, 162, 165
GETCONTENTXML Function, 165
GETCONTENTXMLREF Function, 162
GETCONTENTXMLTYPE Function, 162
GETCOUNT member function
of ANYDATASET TYPE, 240
GETCREATIONDATE Function, 165
GETCREATOR Function, 165
GETCURRENTUSER Function, 168
GETCUSTOMMETADATA Function, 165
GETDATA function, 169
GETDCHARSET function, 169
GETDEFAULTACL Procedure, 47
GETDEFAULTASOF Procedure, 47
GETDEFAULTOWNER Procedure, 47
GETDEFAULTPRINCIPAL Procedure, 47
GETDISPLAYNAME Function, 165
GETDOCTYPE function, 169, 172
GETDOCUMENT function, 172
GETDOCUMENTELEMENT function, 169
GETDTD function, 173
GETDTD procedure, 173
GETELEMENTSBYTAGNAME function, 169, 169
GETENTITIES function, 169
GETEVENT Function, 168
GETEXCEPTIONCONTENT procedure, 173, 174
GETEXPANDEDNAME function, 169, 169
GETEXPANDEDNAME procedure, 169
GETEXTERNALURL function, 244, 244, 244, 244
GETFEATURES Function, 48
GETFEATURESBYMOUNT Function, 47
GETFEATURESBYNAME Function, 47
GETFEATURESBYPATH Function, 47
GETFIRST Function, 168
GETFIRSTCHILD function, 169
GETFTPPORT Function, 162
GETHANDLERLIST Function, 168
GETHTTPPORT Function, 162
GETIMPLEMENTATION function, 169
GETINFO member function
of ANYTYPE TYPE, 241
GETINTERFACE Function, 168
GETLANGUAGE Function, 165, 168, 168
GETLASTCHILD function, 169
GETLASTMODIFIER Function, 165
GETLENGTH function, 169, 169, 169
GETLENGTH Functions, 81
GETLINK Function, 168
GETLINKNAME Function, 168
GETLISTENERENDPOINT Procedure, 162
GETLISTENERS Function, 117
GETLOCK Function, 168
GETLOCKTOKEN procedure, 162
GETMODIFICATIONDATE Function, 165
GETNAME Function, 168
GETNAME function, 169, 169
GETNAMEDITEM function, 169
GETNAMESPACE function, 169, 169
GETNAMESPACE procedure, 169
GETNEXTSIBLING function, 169
GETNODENAME function, 169
GETNODETYPE function, 169
GETNODEVALUE function, 169
GETNODEVALUEASBINARYSTREAM Function & Procedure, 169
GETNODEVALUEASCHARACTERSTREAM Function & Procedure, 169
GETNOTATIONNAME function, 169
GETNOTATIONS function, 169
GETNUMBERVAL function, 258
GETNUMROWSPROCESSED function, 170
GETNUMROWSPROCESSED procedure, 173
GETOLDRESOURCE Function, 168
GETOPENACCESSMODE Function, 168
GETOPENDENYMODE Function, 168
GETOPTIONS Functions, 81
GETOUTPUTSTREAM Function, 168
GETOWNER Function, 165
GETOWNERDOCUMENT function, 169
GETOWNERELEMENT function, 169
GETPARAMETER Function, 168
GETPARENT Function, 168
GETPARENTNAME Function, 168
GETPARENTNODE function, 169
GETPARENTOID Function, 168
GETPARENTPATH Function, 168
GETPAT procedure, 190
GETPATH Function, 168
GETPATH Procedures, 47, 48
GETPATHBYMOUNTID Function, 47
GETPATHBYREPOSID Function, 48
GETPATHBYSTOREID Function, 47
GETPATHNOWAIT Procedure, 48
GETPATHNOWAIT Procedures, 47
GETPERSISTENT static function
of ANYTYPE TYPE, 241
GETPREDECESSORS function, 164
GETPREDSBYRESID function, 164
GETPREFIX function, 169
GETPREVIOUSSIBLING function, 169
GETPRIVILEGES function, 162
GETPUBLICID function, 169, 169
GETQUALIFIEDNAME function, 169, 169
GETREFCOUNT Function, 165
GETRELEASEVERSION function, 172
GETREPOSITORYRESCONFIG Function, 117
GETREPOSITORYRESCONFIGPATHS Function, 117
GETRESCONFIG Function, 117
GETRESCONFIGPATHS Function, 117
GETRESOID function, 162
GETRESOURCE Function, 168
GETRESOURCEBYRESID function, 164
GETROOTELEMENT function, 258
GETRUL function, 244
GETSCHEMA Function, 168
GETSCHEMANODE function, 169
GETSCHEMAURL function, 258
GETSOURCE Function, 168
GETSPECIFIED function, 169
GETSTANDALONE function, 169
GETSTATS Procedure, 47
GETSTOREBYMOUNT Function, 47
GETSTOREBYNAME Function, 47
GETSTOREBYPATH Function, 47
GETSTOREID Function, 48
GETSTOREPROPERTY Function, 49
GETSTRINGVAL function, 258
GETSUCCESSORS function, 164
GETSUCCSBYRESID function, 164
GETSYSTEMID function, 169, 169, 169
GETTAGNAME function, 169
GETTARGET function, 169
GETTDEFAULTCONTEXT Procedure, 47
GETTOKENTABLEINFO Procedure & Function, 40
GETTOKENTABLEINFOBYTABLESPACE Procedure, 40
GETTRACE Function, 47
GETTYPE member function
of ANYDATA TYPE, 239
of ANYDATASET TYPE, 240
GETTYPENAME member function
of ANYDATA TYPE, 239
of ANYDATASET TYPE, 240
GETUPDATEBYTECOUNT Function, 168
GETUPDATEBYTEOFFSET Function, 168
GETURL function, 244, 244, 244, 244
GETVALIDATIONMODE function, 172
GETVALUE function, 169
GETVERSION Function, 47, 48
GETVERSION function, 169
GETVERSION procedure, 173
GETVERSIONID Function, 165
GETXDB_TABLESPACE function, 162
GETXDBEVENT Function, 168
GETXML function, 170, 173, 244, 244, 244, 244
GETXML procedure, 173
GETXMLTYPE function, 169, 170
GRANT_ADMIN_PRIVILEGE procedure, 145
GRANT_OBJECT_PRIVILEGE procedure, 126
GRANT_PRIVILEGE procedure, 64, 122
GRANT_REMOTE_ADMIN_ACCESS procedure, 145
GRANT_SWITCH_CONSUMER_GROUP procedure, 119
GRANT_SYSTEM_PRIVILEGE procedure, 66, 119, 126
GRANTING_OBJECT_PRIVILEGE procedure, 66

H

HASACLCHANGED Function, 165
HASATTRIBUTE function, 169
HASAUTHORCHANGED Function, 165
HASBLOBCONTENT Function, 162
HASCHANGED Function, 165
HASCHARACTERSETCHANGED Function, 165
HASCHARCONTENT Function, 162
HASCHILDNODES function, 169
HASCOMMENTCHANGED Function, 165
HASCONTENTCHANGED Function, 165
HASCONTENTTYPECHANGED Function, 165
HASCREATIONDATECHANGED Function, 165
HASCREATORCHANGED Function, 165
HASCUSTOMMETADATACHANGED Function, 165
HASDISPLAYNAMECHANGED Function, 165
HASFEATURE function, 169
HASLANGUAGECHANGED Function, 165
HASLASTMODIFIERCHANGED Function, 165
HASMODIFICATIONDATECHANGED Function, 165
HASOWNERCHANGED Function, 165
HASREFCOUNTCHANGED Function, 165
HASVERSIONIDCHANGED Function, 165
HASXMLCONTENT Function, 162
HASXMLREFERENCE Function, 162
HEADCLOSE function
of HTF package, 181
HEADCLOSE procedure
of HTP package, 182
HEADER function
of HTF package, 181
HEADER procedure
of HTP package, 182
HEADOPEN function
of HTF package, 181
HEADOPEN procedure
of HTP package, 182
HELO function and procedure, 234
HELP function, 234
HR function
of HTF package, 181
HR procedure
of HTP package, 182
HTF package, 181
HTML tags
applet tags
functions, 181
procedures, 182
atags tags
procedures, 182
character formatting tags
functions, 181
procedures, 182
form tags
functions, 181
procedures, 182
frame tags
functions, 181
procedures, 182
list tags
functions, 181
procedures, 182
paragraph formatting tags
functions, 181
procedures, 182
table tags
functions, 181
HTMLCLOSE function
of HTF package, 181
HTMLCLOSE procedure
of HTP package, 182
HTMLDB_UTIL package documentation, 5
HTMLOPEN function
of HTF package, 181
HTMLOPEN procedure
of HTP package, 182
HTP package, 182
HTTP_HEADER_CLOSE procedure, 193
HttpUriType, 244
HTTPURITYPE function, 244
HttpUriType subtype, 244
CREATEURI function, 244
GETBLOB function, 244
GETCLOB function, 244
GETCONTENTTYPE function, 244
GETEXTERNALURL function, 244
GETRUL function, 244
GETXML function, 244
HTTPURITYPE function, 244
methods, 244

I

IMG function
of HTF package, 181
IMG procedure
of HTP package, 182
IMG2 procedure
of HTP package, 182
IMPLEMENT_TASK Procedure, 18
IMPLEMENT_TUNING_TASK Function, 138
IMPORT_AWR Function, 159
IMPORT_AWR Procedure, 158
IMPORT_COLUMN_STATS procedure, 140
IMPORT_DATABASE_PREFS Procedure, 140
IMPORT_DATABASE_STATS procedure, 140
IMPORT_DICTIONARY_STATS procedure, 140
IMPORT_FIXED_OBJECTS_STATS procedure, 140
IMPORT_INDEX_STATS procedure, 140
IMPORT_SCHEMA_PREFS Procedure, 140
IMPORT_SCHEMA_STATS procedure, 140
IMPORT_SQL_TESTCASE Procedures, 136
IMPORT_SQLWKLD_SCHEMA Procedure, 18
IMPORT_SQLWKLD_SQLCACHE Procedure, 18
IMPORT_SQLWKLD_STS Procedure, 18
IMPORT_SQLWKLD_SUMADV Procedure, 18
IMPORT_SQLWKLD_USER Procedure, 18
IMPORT_SYSTEM_STATS procedure, 140
IMPORT_TABLE_PREFS Procedure, 140
IMPORT_TABLE_STATS procedure, 140
IMPORT_XML procedure, 41, 41
IMPORTNODE function, 169
inbound servers
DBMS_STREAMS_ADM package, 143
rules, 143
INCIDENTID_2_SQL Procedure, 136
INCLUDE_EXTRA_ATTRIBUTES procedure, 32
INDEX_PARAMETERS procedure, 64
INDEX_TABLE_TYPE Table Type, 155
INIT_CLEANUP procedure, 27
INITFS Procedure, 50
INITIALIZE function, 52
INITIALIZE procedure, 107
INITIALIZE_CUBE_UPGRADE procedure, 41, 41
INITIALIZE_REPLAY Procedure, 159
INPLACEEVOLVE Procedure, 175
INSERT_AUTOBIN_NUM_EQWIDTH procedure, 45
INSERT_BIN_CAT_FREQ procedure, 45
INSERT_BIN_NUM_EQWIDTH procedure, 45
INSERT_BIN_NUM_QTILE procedure, 45
INSERT_BIN_SUPER procedure, 45
INSERT_CLIP_TRIM_TAIL procedure, 45
INSERT_CLIP_WINSOR_TAIL procedure, 45
INSERT_FINDING_DIRECTIVE Procedure, 16
INSERT_MISS_CAT_MODE procedure, 45
INSERT_MISS_NUM_MEAN procedure, 45
INSERT_NORM_LIN_MINMAX procedure, 45
INSERT_NORM_LIN_SCALE procedure, 45
INSERT_NORM_LIN_ZSCORE procedure, 45
INSERT_PARAMETER_DIRECTIVE Procedure, 16
INSERT_SEGMENT_DIRECTIVE Procedure, 16
INSERT_SQL_DIRECTIVE Procedure, 16
INSERTBEFORE function, 169
INSERTDATA procedure, 169
INSERTXML function, 174, 176
INSTANCE procedure, 77
INSTANCE_RECORD Record Type, 155
INSTANCE_TABLE Table Type, 155
instantiation
aborting database preparation, 32
aborting schema preparation, 32
aborting table preparation, 32
global SCN, 21
preparing a database for, 32
preparing a schema for, 32
preparing a table for, 32, 32
schema SCN, 21
table SCN, 21
INSTR Functions, 81
INTEGER_ARRAY Table Type, 130
INTERNAL_VERSION_CHECK function, 105
internet addressing
using UTL_INADDR, 225
INTERRUPT_ANALYSIS_TASK Procedure, 137
INTERRUPT_DIAGNOSIS_TASK Procedure, 136
INTERRUPT_TASK Procedure, 18
INTERRUPT_TUNING_TASK procedure, 138
INTERVAL procedure, 77
INTERVAL_DAY_TO_SECOND_TABLE, 135
INTERVAL_YEAR_TO_MONTH_TABLE Table Type, 135
INVALIDATE Functions & Procedures, 120
INVALIDATE Procedure, 155
INVALIDATE_OBJECT Functions & Procedures, 120
IS_CLEANUP_INITIALIZED function, 27
IS_CLUSTER_DATABASE function, 155
IS_HIERARCHY_ENABLED function, 167
IS_LOCATOR function, 219
IS_NULL_TAG member function, 247
IS_OPEN function, 135, 222
IS_REPLAY_PAUSED Procedure, 159
IS_ROLE_ENABLED Function, 130
IS_SESSION_ALIVE Function, 130
IS_TRIGGER_FIRE_ONCE function, 53
ISFOLDER Function, 162, 165
ISFRAGMENT function, 258
ISINDEX function
of HTF package, 181
ISINDEX procedure
of HTP package, 182
ISNULL Function, 165, 168
ISNULL function, 169
ISOPEN function, 220
ISOPEN Functions, 81
ISSCHEMABASED function, 258
ISSCHEMAVALID function, 258
ISSCHEMAVALIDATED function, 258
ISTEMPORARY Functions, 81
ITALIC function
of HTF package, 181
ITALIC procedure
of HTP package, 182
ITEM Functions, 169

J

JARO_WINKLER Function, 229
JARO_WINKLER_SIMILARITY Function, 229
JOB constructor function, 127
JOB object type, 127, 127
JOB_ARRAY table type, 127, 127
JOBARG constructor function, 127
JOBARG object type, 127
JOBARG_ARRAY table type, 127
JOBATTR constructor function, 127
JOBATTR object type, 127
JOBATTR_ARRAY table type, 127

K

KBD function
of HTF package, 181
KBD procedure
of HTP package, 182
KEEP procedure, 131
KEEP_COLUMNS member procedure, 247
KEEP_COLUMNS procedure, 143
KEYBOARD function
of HTF package, 181
KEYBOARD procedure
of HTP package, 182

L

LAPACK Driver Routines (Linear Equations) Subprograms, 230
LAPACK Driver Routines (LLS and Eigenvalue Problems), 230
LAPACK_GBSV Procedures, 230
LAPACK_GEES Procedures, 230
LAPACK_GEEV Procedures, 230
LAPACK_GELS Procedures, 230
LAPACK_GESDD Procedures, 230
LAPACK_GESV Procedures, 230
LAPACK_GESVD Procedures, 230
LAPACK_GTSV Procedures, 230
LAPACK_PBSV Procedures, 230
LAPACK_POSV Procedures, 230
LAPACK_PPSV Procedures, 230
LAPACK_PTSV Procedures, 230
LAPACK_SBEV Procedures, 230
LAPACK_SBEVD Procedures, 230
LAPACK_SPEV Procedures, 230
LAPACK_SPEVD Procedures, 230
LAPACK_SPSV Procedures, 230
LAPACK_STEV Procedures, 230
LAPACK_STEVD Procedures, 230
LAPACK_SYEV Procedures, 230
LAPACK_SYEVD Procedures, 230
LAPACK_SYSV Procedures, 230
LAST_ERROR_POSITION function, 135
LAST_ROW_COUNT function, 135
LAST_ROW_ID function, 135
LAST_SQL_FUNCTION_CODE function, 135
LCR$_DDL_RECORD type, 247
LCR$_ROW_LIST type, 247
LCR$_ROW_RECORD type, 247
LCR$_ROW_UNIT type, 247
GET_LOB_INFORMATION member function, 247
GET_LOB_OPERATION_SIZE member procedure, 247
GET_LONG_INFORMATION member function, 247
GET_POSITION member function, 247
GET_ROW_TEXT member procedure, 247
GET_WHERE_CLAUSE member procedure, 247
SET_LOB_INFORMATION member procedure, 247
SET_LOB_OPERATION_SIZE member procedure, 247
LCR_TO_XML Function, 90
LENGTH function, 231
LINE function
of HTF package, 181
LINE procedure
of HTP package, 182
LINK Procedures, 162
LINKREL function
of HTF package, 181
LINKREL procedure
of HTP package, 182
LINKREV function
of HTF package, 181
LINKREV procedure
of HTP package, 182
LIST Function, 47, 48
LIST_CONTEXT Procedures, 130
LISTALLCONTENT Function, 47
LISTALLPROPERTIES Function, 47
LISTHEADER function
of HTF package, 181
LISTHEADER procedure
of HTP package, 182
LISTINGCLOSE function
of HTF package, 181
LISTINGCLOSE procedure
of HTP package, 182
LISTINGOPEN function
of HTF package, 181
LISTINGOPEN procedure
of HTP package, 182
LISTITEM function
of HTF package, 181
LISTITEM procedure
of HTP package, 182
LISTMOUNTS Function, 47
LISTPRINT procedure, 193
LISTSTORES Function, 47
LNAME_ARRAY Table Type, 130, 155
LOAD_PLANS_FROM_CURSOR_CACHE Functions, 134
LOAD_PLANS_FROM_SQLSET Function, 134
LOAD_SQLSET procedure, 138
LOAD_SQLSET_FROM_TCB Function, 136
LOAD_TABLE procedure
of DBMS_HS_PARALLEL package, 73
LOADBLOBFROMFILE Procedure, 81
LOADCLOBFROMFILE Procedure, 81
LOADFROMFILE Procedure, 81
LOBs
DBMS_LOB package, 81
LOCAL_TRANSACTION_ID function, 151
LOCK_MAP procedure, 141
LOCK_OBJECT procedure, 233
LOCK_PARTITION_STATS Procedure, 140
LOCK_SCHEMA_STATS procedure, 140
LOCK_TABLE_STATS procedure, 140
LOCKPATH Procedure, 47, 48
LOCKRESOURCE function, 162
log apply services
managing initialization parameters for logical standby databases, 85
logical change records (LCRs)
DDL LCRs, 247
getting base table name, 247
getting base table owner, 247
getting current schema, 247
getting edition name, 247
getting logon user name, 247
getting object type, 247
setting base table name, 247
setting base table owner, 247
setting current schema, 247
setting DDL text, 247
setting logon user, 247
setting object type, 247
determining if tag is NULL, 247
executing, 247, 247
extra attributes
excluding, 32
including, 32
GET_THREAD_NUMBER member function, 247
getting command type, 247
getting commit SCN, 247
getting commit SCN from position, 247
getting commit time, 247
getting compatibility information, 247
getting extra attributes, 247
getting LCR creation time, 247
getting object name, 247
getting object owner, 247
getting SCN, 247
getting SCN from position, 247
getting source database name, 247
getting tag, 247
getting transaction identifier, 247
LCR$_DDL_RECORD type, 247
LCR$_ROW_LIST type, 247
LCR$_ROW_RECORD type, 247
LCR$_ROW_UNIT type, 247
row LCRs, 247
adding value to column, 247
converting LONG to LOB, 247
deleting value to column, 247
getting column value, 247
getting list of column values, 247
getting LOB offset, 247
getting XML information, 247
keeping columns, 247
renaming column, 247
setting column value, 247
setting list of column values, 247
setting LOB offset, 247
setting XML information, 247
setting command type, 247
setting extra attributes, 247
setting object name, 247
setting object owner, 247
setting source database name, 247
setting tag, 247
types, 247
logical standby databases
managing with DBMS_LOGSTDBY package, 85
logs
Cube Build, 43
Cube Dimension Compile, 43
Cube Operations, 43
Cube Rejected Records, 43
LZ_COMPRESS functions and procedures, 220
LZ_COMPRESS_ADD procedure, 220
LZ_COMPRESS_CLOSE procedure, 220
LZ_COMPRESS_OPEN function, 220
LZ_UNCOMPRESS functions and procedures, 220
LZ_UNCOMPRESS_CLOSE procedure, 220
LZ_UNCOMPRESS_EXTRACT procedure, 220
LZ_UNCOMPRESS_OPEN function, 220

M

MAIL function and procedure, 234
MAILTO function
of HTF package, 181
MAILTO procedure
of HTP package, 182
MAINTAIN_CHANGE_TABLE procedure, 143
MAINTAIN_GLOBAL procedure, 143
MAINTAIN_SCHEMAS procedure, 143
MAINTAIN_SIMPLE_TABLESPACE procedure, 143
MAINTAIN_SIMPLE_TTS procedure, 143
MAINTAIN_TABLES procedure, 143
MAINTAIN_TABLESPACES procedure, 143
MAINTAIN_TTS procedure, 143
MAKE_DATA_BLOCK_ADDRESS function, 155
MAKEATTR function, 169
MAKECDATASECTION function, 169
MAKECHARACTERDATA function, 169
MAKECOMMENT function, 169
MAKEDOCUMENT Function, 165
MAKEDOCUMENT function, 169
MAKEDOCUMENTFRAGMENT function, 169
MAKEDOCUMENTTYPE function, 169
MAKEELEMENT function, 169
MAKEENTITY function, 169
MAKEENTITYREFERENCE function, 169
MAKENODE function, 169, 169, 169, 169
MAKENOTATION function, 169
MAKEPROCESSINGINSTRUCTION function, 169
MAKETEXT function, 169
MAKEVERSIONED function, 164
MAP_ALL function, 141
MAP_DAD Procedure, 62
MAP_ELEMENT function, 141
MAP_FILE function, 141
MAP_OBJECT function, 141
MAPCLOSE function
of HTF package, 181
MAPCLOSE procedure
of HTP package, 182
MAPOPEN function
of HTF package, 181
MAPOPEN procedure
of HTP package, 182
MARK_RECOMMENDATION Procedure, 18
MATCH function, 190
MATERIALIZE_DEFERRED_SEGMENTS Procedure, 133
materialized view logs
master table
purging, 92, 92, 92
materialized views
comparing, 35
converting from table- to cube-organized, 41
optimizing cube organized, 42
refreshing, 92, 92, 92
materialized views (cube organized), 41
MEMORY_REPORT Procedure, 120
MENULISTCLOSE function
of HTF package, 181
MENULISTCLOSE procedure
of HTP package, 182
MENULISTOPEN function
of HTF package, 181
MENULISTOPEN procedure
of HTP package, 182
merge streams, 143, 143
MERGE_COL_USAGE Procedure, 140
MERGE_STREAMS procedure, 143
MERGE_STREAMS_JOB procedure, 143
MERGEXLIFF Functions, 177
MESSAGE_PROPERTIES_ARRAY_T Type, 242
MESSAGE_PROPERTIES_T Type, 242
messaging client
messaging client user, 143
rules
for LCRs, 143
for user messages, 143
META function
of HTF package, 181
META procedure
of HTP package, 182
MG2 function
of HTF package, 181
MGD_ID constructor function, 254
MGD_ID object type, 254
FORMAT function, 254
GET_COMPONENT function, 254
MGD_ID constructor function, 254
TO_STRING function, 254
TRANSLATE function, 254
MGD_ID object types, 254
MGD_ID_COMPONENT object type, 254
MGD_ID_COMPONENT_VARRAY object type, 254
MIGRATE_STORED_OUTLINE Function, 134
migration
post-migration actions, 95
MIME_HEADER procedure, 193
MIMEHEADER_DECODE function, 221
MIMEHEADER_ENCODE function, 221
MODIFY_BASELINE_WINDOW_SIZE Procedure, 160
MODIFY_OPERATOR_LIST procedure, 64
MODIFY_PACKAGE_STATE Procedure, 130
MODIFY_SERVICE Procedure, 129
MODIFY_SNAPSHOT_SETTINGS procedure, 160
MODIFY_TRANSFORMATION procedure, 152
MODIFYPARAMETER Procedure, 171
MOUNT_T Record Type, 47
MOUNTS_T Table Type, 47
MOUNTSTORE Procedure, 47
MOVE_TO_DBFS_LINK Procedures, 81
MOVEXDB_TABLESPACE procedure, 162
MSGID_ARRAY_T Type, 242
MV_CUBE_ADVICE function, 42

N

NAME_ARRAY Table Type, 155
NAME_RESOLVE procedure, 155
NAME_TOKENIZE procedure, 155
NAMELIST Table Type, 134
NAMESPACE function, 258
NAMESPACEIDTABLE Procedure, 40
NEW_LINE procedure, 99, 222
NEW_ROW_LIST function and procedure, 192
NEWCONTEXT function, 170, 173, 174, 176
NEWDOMDOCUMENT function, 169
NEWPARSER function, 172
NEWPROCESSOR function, 179
NEWSTYLESHEET function, 179
NEXT_DATE procedure, 77
NEXT_ITEM_TYPE function, 102
NL function
of HTF package, 181
NL procedure
of HTP package, 182
NOBR function
of HTF package, 181
NOBR procedure
of HTP package, 182
NOFRAMESCLOSE function
of HTF package, 181
NOFRAMESCLOSE procedure
of HTP package, 182
NOFRAMESOPEN function
of HTF package, 181
NOFRAMESOPEN procedure
of HTP package, 182
NOOP function and procedure, 234
NOOP Functions, 26
NORMAL function, 107
NORMAL_DIST_FIT procedure, 139
NORMALIZE procedure, 169
NORMALIZEPATH Functions, 47
NUMBER_ARRAY Table Type, 155
NUMBER_TABLE Table Type, 135
NVARRAY_ADD Procedure, 90
NVARRAY_FIND_NAME Function, 90
NVARRAY_FIND_NAME_TYPE Function, 90
NVARRAY_GET Function, 90
NVARRAY_GET_BOOLEAN, 90
NVARRAY_GET_BYTE, 90
NVARRAY_GET_DATE Function, 90
NVARRAY_GET_DOUBLE Function, 90
NVARRAY_GET_FLOAT Function, 90
NVARRAY_GET_INTEGER, 90
NVARRAY_GET_LONG Function, 90
NVARRAY_GET_RAW Function, 90
NVARRAY_GET_SHORT, 90
NVARRAY_GET_TEXT Function, 90

O

OBJECT_DEPENDENT_SEGMENTS function, 132
OBJECT_GROWTH_TREND function, 132
ogical change records (LCRs)
tracking, 143, 143
OLAP aggregation operators, 41
OLAP logs
Cube Build, 43
Cube Dimension Compile, 43
Cube Operations, 43
Cube Rejected Records, 43
OLAP metadata
upgrading to OLAP 11g, 41
OLAP PL/SQL packages
DBMS_CUBE_LOG, 43
OLAP templates
validation, 41
writing to XML files, 41
OLAP_DBA role, 41
OLAP_USER role, 41, 41
OLD_CURRENT_SCHEMA Function, 155
OLD_CURRENT_USER Function, 155
OLISTCLOSE function
of HTF package, 181
OLISTCLOSE procedure
of HTP package, 182
OLISTOPEN function
of HTF package, 181
OLISTOPEN procedure
of HTP package, 182
ONLINE_INDEX_CLEAN Function, 111
OPEN Procedures, 81
OPEN_CONNECTION function, 236
OPEN_CONNECTION functions, 234
OPEN_CURSOR Function, 74
OPEN_CURSOR function, 135
OPEN_DATA function and procedure, 234
OPEN_FBA Procedure, 69
optimizer statistics, 31
OR REPLACE clause
for creating packages, 1
Oracle Data Mining, 44
Oracle Streams
administrator
granting privileges, 145
revoking privileges, 145
advisors, 144
change data capture
configuring, 143
compatibility, 142, 142, 142, 142, 142, 247
creating queues, 143
data dictionary
removing information, 143
messaging
notification, 143
privileges, 145
replication
configuring, 143, 143, 143, 143, 143, 143, 143, 143
Oracle-supplied types
logical change record (LCR) types, 247
rule types, 255
ORD_DICOM package documentation, 183
ORD_DICOM_ADMIN package documentation, 184
outbound servers
rules, 143
OVERLAY function, 231
OVERRIDE_PRIORITY Procedures, 29
OWA_CACHE package, 185
OWA_COOKIE package, 186
OWA_CUSTOM package, 187
OWA_IMAGE package, 188
OWA_OPT_LOCK package, 189
OWA_PATTERN package, 190
OWA_SEC package, 191
OWA_TEXT package, 192
OWA_UTIL package, 193

P

PACK_MESSAGE procedures, 102
PACK_STGTAB_BASELINE Function, 134
PACK_STGTAB_SQLPATCH Procedure, 136
PACK_STGTAB_SQLPROF Procedure, 138
PACK_STGTAB_SQLSET Procedure, 138
package
DBMS_EXPFIL, 64
DBMS_ODCI, 96
DBMS_RLMGR, 122
DBMS_XDB, 162
DBMS_XMLDOM, 169
DBMS_XMLGEN, 170
DBMS_XMLPARSER, 172
DBMS_XMLQUERY, 173
DBMS_XMLSAVE, 174
DBMS_XMLSCHEMA, 175
UriFactory, 244
Package - UriFactory, 244
package overview, 1
package variables
i_am_a_refresh, 92
packages
creating, 1
DBMS_MGD_ID_UTL, 88
referencing, 1
where documented, 1
PARA function
of HTF package, 181
PARA procedure
of HTP package, 182
PARAGRAPH function
of HTF package, 181
PARAGRAPH procedure
of HTP package, 182
PARAM function
of HTF package, 181
PARAM procedure
of HTP package, 182
PARSE Procedure, 74
PARSE procedure, 135, 172
PARSEBUFFER procedure, 172
PARSECLOB procedure, 172
PARSEDTD procedure, 172
PARSEDTDBUFFER procedure, 172
PARSEDTDCLOB procedure, 172
PATCHREPOSITORYRESCONFIGLIST Procedure, 117
PATH_ITEM_T Record Type, 47
PATH_ITEMS_T Table Type, 47
PATHIDTABLE Function, 40
PAUSE_PROFILER function and procedure, 105
PAUSE_REPLAY Procedure, 159
PIECEWISE member procedure
of ANYDATA TYPE, 239
of ANYDATASET TYPE, 240
PING procedure, 52
PLAINTEXT function
of HTF package, 181
PLAINTEXT procedure
of HTP package, 182
plan stability, 98
PL/SQL
datatypes, 57
numeric codes for, 57
functions
DBMS_MGWADM package subprograms, 89
DBMS_MGWMSG package subprograms, 90
procedures
DBMS_MGWADM package subprograms, 89
DBMS_MGWMSG package subprograms, 90
PL/SQL package
DBMS_HS_PARALLEL, 73
PLSQL_TRACE_VERSION procedure, 150
pointer to
CTX_ADM package, 6
point-in-time recovery
Oracle Streams, 143
POISSON_DIST_FIT procedure, 139
POPULATE_DIVERGENCE Procedure, 159
PORT_STRING function, 155
POST_INSTANTIATION_SETUP procedure, 143
PRE_INSTANTIATION_SETUP procedure, 143
PRECLOSE function
of HTF package, 181
PRECLOSE procedure
of HTP package, 182
predictive analytics, 103
PREOPEN function
of HTF package, 181
PREOPEN procedure
of HTP package, 182
PREPARE Procedure, 159
PREPARE_COLUMN_VALUES procedures, 140, 140
PREPARE_COLUMN_VALUES_NVARCHAR2 procedure, 140
PREPARE_COLUMN_VALUES_ROWID procedure, 140
PREPARE_GLOBAL_INSTANTIATION procedure, 32
PREPARE_SCHEMA_INSTANTIATION procedure, 32
PREPARE_SYNC_INSTANTIATION function, 32
PREPARE_TABLE_INSTANTIATION procedure, 32
PRINT function
of HTF package, 181
PRINT procedure
of HTP package, 182
PRINT_BACKTRACE procedure, 52
PRINT_CGI_ENV procedure, 193
PRINT_INSTANTIATIONS procedure, 52
PRINT_MULTI procedure, 192
PRINT_POST_PROCESSED_SOURCE Procedure, 104
PRINT_ROW_LIST procedure, 192
PRINTS procedure
of HTP package, 182
privileges
granting, 64
Oracle Streams administrator, 145, 145
revoking, 64
PRN function
of HTF package, 181
PRN procedure
of HTP package, 182
PROBE_VERSION procedure, 52
PROCESS_CAPTURE Procedure, 158
PROCESS_RECORDING Procedure, 159
PROCESS_RULES procedure, 122
PROCESSLINKS Procedure, 162
PROCESSXSL function, 179
PROGRAM_INFO Record Type, 52
PROP_ITEM_T Record Type, 47
PROP_ITEMS_T Table Type, 47
PROPAGATEORIGINALEXCEPTION procedure, 173, 174
propagations
altering, 106
creating, 106, 143, 143, 143, 143, 143
DBMS_PROPAGATION_ADM package, 106
dropping, 106
propagation user, 143
rules
defining global, 143
defining message, 143
defining schema, 143
defining subset, 143
defining table, 143
for LCRs, 143
for user messages, 143
starting, 106
stopping, 106
PROPANY Functions, 47
PROPERTIES_T Table Type, 47
PROPERTIESH2T Function, 47
PROPERTIEST2H Function, 47
PROPERTY_T Record Type, 47
PROPNUMBER Function, 47
PROPRAW Function, 47
PROPTIMESTAMP Function, 47
PROPVARCHAR2 Function, 47
PS procedure
of HTP package, 182
PUBLISH_PENDING_STATS Procedure, 140
PULL_SIMPLE_TABLESPACE procedure, 148
PULL_TABLESPACES procedure, 148
PURGE Procedure, 131
PURGE procedure, 102
PURGE_COMPARISON Procedure, 35
PURGE_EVENTS procedure, 122
PURGE_FILE_GROUP procedure, 66
PURGE_LOST_DB_ENTRY procedure, 151
PURGE_MIXED procedure, 151
PURGE_PROCESSED_CHUNKS Procedure, 100
PURGE_QUEUE_TABLE Procedure, 23
PURGE_SOURCE_CATALOG procedure, 143
PURGE_STATS procedure, 140
PURGEALL Procedure, 47, 48
PURGELDAPCACHE function, 167
PURGEPATH Procedure, 47, 48
PURGERESOURCEMETADATA Procedure, 162
PURGESCHEMA Procedure, 175
purging
the subscription window, 34
PUT procedure, 222
PUT procedures, 99
PUT_FILE procedure, 67
PUT_LINE Procedure, 222
PUT_LINE procedures, 99
PUT_LINE_NCHAR procedure, 222
PUT_NCHAR procedure, 222
PUT_RAW function, 222
PUTF procedure, 222
PUTF_NCHAR procedure, 222
PUTPATH Procedures, 47, 48

Q

QNAMEIDTABLE Function, 40
QUALIFIED_SQL_NAME Function, 26
queues
AnyData
creating, 143
removing, 143
QUICK_TUNE Procedure, 18
QUIT function and procedure, 234
QUOTED_PRINTABLE_DECODE function, 221
QUOTED_PRINTABLE_ENCODE function, 221

R

RANDOM procedure, 107
RCPT function, 234
RE$ATTRIBUTE_VALUE type, 255
RE$ATTRIBUTE_VALUE_LIST type, 255
RE$COLUMN_VALUE type, 255, 255
RE$COLUMN_VALUE_LIST type, 255
RE$NAME_ARRAY type, 255
RE$NV_ARRAY type, 255
RE$NV_LIST type, 255
ADD_PAIR member procedure, 255
GET_ALL_NAMES member function, 255
GET_VALUE member function, 255
REMOVE_PAIR member procedure, 255
RE$RULE_HIT type, 255
RE$RULE_HIT_LIST type, 255
RE$TABLE_ALIAS type, 255
RE$TABLE_ALIAS_LIST type, 255
RE$TABLE_VALUE type, 255
RE$TABLE_VALUE_LIST type, 255
RE$VARIABLE_TYPE type, 255
RE$VARIABLE_TYPE_LIST type, 255
RE$VARIABLE_VALUE type, 255
RE$VARIABLE_VALUE_LIST type, 255
READ Procedures, 81
READ_CLIENT_INFO procedure, 20
READ_LINE function, 236
READ_LINE procedure
of UTL_HTTP, 223
READ_MODULE procedure, 20
READ_ONLY procedure, 151
READ_RAW function, 236
READ_RAW procedure
of UTL_HTTP, 223
READ_TEXT function, 236
READ_TEXT procedure
of UTL_HTTP, 223
READ_WRITE procedure, 151
READ2CLOB function, 179
Real-time SQL Monitoring Subprograms, 138
REASSOCIATE_FBA Procedure, 69
REBUILD_FREELISTS procedure, 111
RECEIVE_MESSAGE function, 102
RECHECK Function, 35
RECOMP_PARALLEL procedure, 232
RECOMP_SERIAL procedure, 232
RECONFIGCACHE Procedure, 49
REDIRECT_URL procedure, 193
refresh
materialized views, 92, 92, 92
REFRESH_CATEGORY function, 88
REFRESH_MVIEW procedure, 41, 41
REGISTER Procedure, 19
REGISTER_DEPENDENT_OBJECT procedure, 109
REGISTER_FOREIGN_QUEUE Procedure, 89
REGISTERPARAMETER Procedure, 171
REGISTERSCHEMA procedure, 175
REGISTERSTORE Procedure, 47
REGISTERSTORECOMMAND Procedur, 49
REGISTERTOKENTABLESET Procedure, 40
REGISTERURI procedure, 175
REGISTERURLHANDLER procedure, 244
RELEASE function, 82
REMAP_CONNECTION Procedure, 159
REMAP_STGTAB_SQLPROF Procedure, 138
REMAP_STGTAB_SQLSET Procedure, 138
REMOVE Procedure, 168
REMOVE procedure
of DBMS_ALERT package, 19
of DBMS_JOB package, 77
of OWA_COOKIE package, 186
REMOVE_AGENT Procedure, 89
REMOVE_CATEGORY procedure, 88
REMOVE_COLORED_SQL Procedure, 160
REMOVE_FILE procedure, 66
REMOVE_JOB Procedure, 89
REMOVE_MSGSYSTEM_LINK Procedure, 89
REMOVE_OPTION Procedure, 89
REMOVE_PAIR member procedure, 255
REMOVE_PIPE function, 102
REMOVE_PROXY procedure, 88
REMOVE_QUEUE procedure, 143
REMOVE_RULE procedure, 126, 143
REMOVE_SCHEME procedure, 88
REMOVE_SQLSET_REFERENCE procedure, 138
REMOVE_STMT_FROM_HANDLER procedure, 146
REMOVE_STMT_HANDLER procedure, 21
REMOVE_STREAMS_CONFIGURATION procedure, 143
REMOVE_SUBSCRIBER Procedure, 89
REMOVEALL procedure, 19
REMOVEATTRIBUTE procedure, 169
REMOVEATTRIBUTENODE function, 169
REMOVENAMEDITEM function, 169
REMOVEPARAM procedure, 179
REMOVEXSLTPARAM procedure, 173, 174
RENAME_BASELINE Procedure, 160
RENAME_COLUMN member procedure, 247
RENAME_COLUMN procedure, 143
RENAME_SCHEMA procedure, 143
RENAME_TABLE procedure, 143
RENAMEPATH Procedure, 48
RENAMEPATH Procedures, 47
RENAMERESOURCE procedure, 162
REPLACECHILD function, 169
REPLACEDATA procedure, 169
replication
Oracle Streams
configuring, 143, 143, 143, 143, 143, 143, 143, 143
split and merge, 143, 143, 143
REPLY, REPLIES record types, 234
REPORT Function, 158, 159
REPORT_ANALYSIS_TASK Function, 137
REPORT_AUTO_TUNING_TASK Function, 138
REPORT_DIAGNOSIS_TASK Function, 136
REPORT_SQL_DETAIL Function, 138
REPORT_SQL_MONITOR Function, 138
REPORT_SQL_MONITOR_LIST Function, 138
REPORT_TUNING_TASK function, 28, 138
REQUEST function, 82, 223
REQUEST_PIECES function, 223
RESET_ANALYSIS_TASK Procedure, 137
RESET_BUFFER procedure, 102
RESET_DIAGNOSIS_TASK Procedure, 136
RESET_GLOBAL_PREFS_DEFAULTS Procedure, 140
RESET_JOB Procedure, 89
RESET_PACKAGE Procedure, 130
RESET_PARAM_DEFAULTS Procedure, 140
RESET_SESSION procedure, 122
RESET_SQLWKLD Procedure, 18
RESET_SUBSCRIBER Procedure, 89
RESET_TASK Procedure, 18
RESET_TUNING_TASK procedure, 138
RESETPARAMS procedure, 179
RESOLVENAMESPACEPREFIX function, 169
RESTARTQUERY procedure, 170
RESTORE function, 141
RESTORE_DATBASE_STATS procedure, 140
RESTORE_DEFAULTS Procedure, 37
RESTORE_DICTIONARY_STATS procedure, 140
RESTORE_FIXED_OBJECTS_STATS procedure, 140
RESTORE_SCHEMA_STATS procedure, 140
RESTORE_SYSTEM_STATS procedure, 140
RESTORE_TABLE_STATS procedure, 140
RESTOREALL Procedure, 47, 48
RESTOREPATH Procedure, 47, 48
RESUME_ANALYSIS_TASK Procedure, 137
RESUME_DIAGNOSIS_TASK Procedure, 136
RESUME_PROFILER function and procedure, 105
RESUME_REPLAY Procedure, 159
RESUME_TASK Procedure, 100
RESUME_TUNING_TASK Procedure, 138
REUSE_REPLAY_FILTER_SET Procedure, 159
REVERSE function, 231
REVOKE_ADMIN_PRIVILEGE procedure, 145
REVOKE_OBJECT_PRIVILEGE procedure, 66, 126
REVOKE_PRIVILEGE procedure, 64, 122
REVOKE_REMOTE_ADMIN_ACCESS procedure, 145
REVOKE_SWITCH_CONSUMER_GROUP procedure, 119
REVOKE_SYSTEM_PRIVILEGE procedure, 66, 119, 126
RLM$EVENTIDS object type, 256
ROLLBACK procedure, 151
ROLLBACK_FORCE procedure, 151
ROLLBACK_SAVEPOINT procedure, 151
row migration, 143, 143
ROWID datatype
extended format, 124
ROWID_BLOCK_NUMBER function, 124
ROWID_CREATE function, 124
ROWID_INFO procedure, 124
ROWID_OBJECT function, 124
ROWID_RELATIVE_FNO function, 124
ROWID_ROW_NUMBER function, 124
ROWID_TO_ABSOLUTE_FNO function, 124
ROWID_TO_EXTENDED function, 124
ROWID_TO_RESTRICTED function, 124
ROWID_TYPE function, 124
ROWID_VERIFY function, 124
rule sets
adding rules to, 126
creating, 126
dropping, 126
removing rules from, 126
rule-based transformations
setting, 143
rules
action contexts
adding name-value pairs, 255
getting name-value pairs, 255
getting value for name, 255
removing name-value pairs, 255
transformations, 143
altering, 126
creating, 126
DBMS_RULE package, 125
DBMS_RULE_ADM package, 126
dropping, 126
evaluation, 125
iterators, 125, 125
evaluation contexts
altering, 126
creating, 126
dropping, 126
inbound servers, 143
object privileges
granting, 126
revoking, 126
outbound servers, 143
propagations
removing, 143
RE$ATTRIBUTE_VALUE type, 255
RE$ATTRIBUTE_VALUE_LIST type, 255
RE$COLUMN_VALUE type, 255, 255
RE$COLUMN_VALUE_LIST type, 255
RE$NAME_ARRAY type, 255
RE$NV_ARRAY type, 255
RE$NV_LIST type, 255
RE$RULE_HIT type, 255
RE$RULE_HIT_LIST type, 255
RE$TABLE_ALIAS type, 255
RE$TABLE_ALIAS_LIST type, 255
RE$TABLE_VALUE type, 255
RE$TABLE_VALUE_LIST type, 255
RE$VARIABLE_TYPE type, 255
RE$VARIABLE_TYPE_LIST type, 255
RE$VARIABLE_VALUE type, 255
RE$VARIABLE_VALUE_LIST type, 255
subset
defining, 143, 143
system privileges
granting, 126
revoking, 126
system-created, 143
global apply, 143
global capture, 143
global propagation, 143
global schema, 143
message, 143, 143
message propagation, 143
removing, 143
schema capture, 143
schema propagation, 143
subset apply, 143
subset capture, 143
subset propagation, 143
table apply, 143
table capture, 143
table propagation, 143
types, 255
Rules Manager object types, 256
RUN procedure, 77
RUN_CHECK Procedure, 71
RUN_TASK Procedure, 100
RUNTIME_INFO Record Type, 52

S

S function
of HTF package, 181
S procedure
of HTP package, 182
SAM (SQL Aggregation Management), 41
SAMPLE function
of HTF package, 181
SAMPLE procedure
of HTP package, 182
SAVE function, 141
SAVE Procedure, 165
SAVEPOINT procedure, 151
SCHEDULE_PROPAGATION Procedure, 23, 89
SCHEDULER$_STEP_TYPE object type, 127
SCHEDULER$_STEP_TYPE_LIST table type, 127
SCHEMA_NAME Function, 26
SCHEMAVALIDATE procedure, 258
SCRIPT function
of HTF package, 181
SCRIPT procedure
of HTP package, 182
SCRIPT_TUNING_TASK Function, 138
SDO_CS package documentation, 194
SDO_CSW_PROCESS package documentation, 195
SDO_GCDR package documentation, 196
SDO_GEOM package documentation, 197
SDO_GEOR package documentation, 198
SDO_GEOR_ADMIN package documentation, 199
SDO_GEOR_UTL package documentation, 200
SDO_LRS package documentation, 201
SDO_MIGRATE package documentation, 202
SDO_NET package documentation, 203
SDO_NET_MEM package documentation, 204
SDO_OLS package documentation, 205
SDO_PC_PKG package documentation, 206
SDO_SAM package documentation, 207
SDO_TIN_PKG package documentation, 208
SDO_TOPO package documentation, 209
SDO_TOPO_MAP package documentation, 210
SDO_TUNE package documentation, 211
SDO_UTIL package documentation, 212
SDO_WFS_LOCK package documentation, 213
SDO_WFS_PROCESS package documentation, 214
SEARCH Function, 47, 48
SECURE_CONNECTION Procedure, 236
SEED procedures, 107
SEED_COL_USAGE Procedures, 140
SEGMENT_CORRUPT procedure, 133
SEGMENT_DROP_CORRUPT procedure, 133
SEGMENT_DUMP procedure, 133
SEGMENT_FIX_STATUS procedure, 111
SEGMENT_VERIFY procedure, 133
SELECT_BASELINE_METRICS Function, 160
SELECT_CURSOR_CACHE Function, 138
SELECT_OBJECT procedure, 233
SELECT_SQL_TRACE Function, 138
SELECT_SQLSET function, 138, 138, 138, 138
SELECT_WORKLOAD_REPOSITORY functions, 138
SELECTNODES function, 179
SELECTSINGLENODE function, 179
SELF_CHECK procedure, 52
SEM_APIS package documentation, 215
SEM_PERF package documentation, 216
SEM_RDFSA package documentation, 217, 218
SEND procedure, 186, 228
SEND_ATTACH_RAW procedure, 228
SEND_ATTACH_VARCHAR2 procedure, 228
SEND_MESSAGE function, 102
SENDCOMMAND Procedures, 49
SERV_MOD_ACT_STAT_DISABLE procedure, 91
SERV_MOD_ACT_STAT_ENABLE procedure, 91
SERV_MOD_ACT_TRACE_DISABLE procedure, 91
SERV_MOD_ACT_TRACE_ENABLE procedure, 91
SESSION _TRACE_DISABLE Procedure, 130
SESSION _TRACE_ENABLE Procedur, 130
SESSION_TRACE_DISABLE procedure, 91
SESSION_TRACE_ENABLE procedure, 91
SET* member procedures
of ANYDATA TYPE, 239
of ANYDATASET TYPE, 240
SET_ACTION procedure, 20
SET_ADVANCED_PARAMETER Procedure, 159
SET_ANALYSIS_DEFAULT_PARAMETER Procedures, 137
SET_ANALYSIS_TASK_PARAMETER Procedure, 137
SET_AUDIT_TRAIL_LOCATION procedure, 27
SET_AUDIT_TRAIL_PROPERTY procedure, 27
SET_AUTHENTICATION procedure, 223
SET_AUTHENTICATION_FROM_WALLET Procedure, 223
SET_AUTHORIZATION procedure, 191
SET_AUTO_TUNING_TASK_PARAMETER Procedures, 28
SET_BASE_TABLE_NAME member procedure, 247
SET_BASE_TABLE_OWNER member procedure, 247
SET_BODY_CHARSET procedures, 223, 223
SET_BREAKPOINT function, 52
SET_CHANGE_HANDLER procedure, 21
SET_CHUNK_STATUS Procedure, 100
SET_CLIENT_INFO procedure, 20
SET_CLIENT_SERVICE Procedure, 29
SET_CNS_EXCEPTION_LOG procedure, 42
SET_COLUMN_STATS procedures, 140
SET_COMMAND_TYPE member procedure, 247
SET_CONSUMER_GROUP_MAPPING procedure, 118
SET_CONSUMER_GROUP_MAPPING_PRI procedure, 118
SET_CONTEXT Procedure, 130
SET_COOKIE_SUPPORT procedures, 223
SET_CURRENT_SCHEMA member procedure, 247
SET_DAD_ATTRIBUTE Procedure, 62
SET_DATABASE_PREFS Procedure, 140
SET_DBFS_LINK Procedures, 81
SET_DDL_TEXT member procedure, 247
SET_DEFAULT_SQLWKLD_PARAMETER Procedure, 18
SET_DEFAULT_TASK_PARAMETER Procedures, 18
SET_DEFAULTS procedure, 19
SET_DETAILED_EXCP_SUPPORT procedure, 223
SET_DIAGNOSIS_TASK_PARAMETER Procedure, 136
SET_DML_HANDLER procedure, 21
SET_EDITION_DEFERRED Procedure, 130
SET_ENQUEUE_DESTINATION procedure, 21
SET_EXECUTE procedure, 21
SET_EXPRESSION procedure, 45
SET_EXTRA_ATTRIBUTE member procedure, 247
SET_FOLLOW_REDIRECT procedures, 223
SET_GLOBAL_ATTRIBUTE Procedure, 62
SET_GLOBAL_INSTANTIATION procedure, 21
SET_GLOBAL_PREFS Procedure, 140
SET_HEADER procedure, 223
SET_IDENTIFIER, 130
SET_INDEX_STATS procedures, 140
SET_INITIAL_CONSUMER_GROUP procedure, 118
SET_JAVA_LOGGING_LEVEL procedure, 88
SET_KEY_COLUMNS procedure, 21
SET_LAST_ARCHIVE_TIMESTAMP procedure, 27
SET_LOB_INFORMATION member procedure, 247
SET_LOB_OFFSET member procedure, 247
SET_LOB_OPERATION_SIZE member procedure, 247
SET_LOG_LEVEL Procedure, 89
SET_LOG_SPEC procedure, 43
SET_LOGON_USER member procedure, 247
SET_MAILHOST Procedure, 24
SET_MAILPORT Procedure, 24
SET_MESSAGE_NOTIFICATION procedure, 143
SET_MESSAGE_TRACKING procedure, 143
SET_MODULE procedure, 20
SET_NLS Procedure, 130
SET_OBJECT_NAME member procedure, 247
SET_OBJECT_OWNER member procedure, 247
SET_OBJECT_TYPE member procedure, 247
SET_OER_BREAKPOINT function, 52
SET_OPTION Procedure, 89
SET_P1_RESOURCES Procedure, 29
SET_PARAM procedure, 140
SET_PARAMETER procedure, 32, 43
apply process, 21
SET_PERSISTENT_CONN_SUPPORT procedure, 223
SET_PLSQL_LOGGING_LEVEL procedure, 88
SET_PLSQL_TRACE procedure, 150
SET_PROTECTION_REALM procedure, 191
SET_PROXY procedure, 88, 223
SET_PURGE_JOB_INTERVAL procedure, 27
SET_PURGE_JOB_STATUS procedure, 27
SET_REPLAY_TIMEOUT Procedure, 159
SET_RESPONSE_ERROR_CHECK procedure, 223
SET_ROLE Procedure, 130
SET_RULE_TRANSFORM_FUNCTION procedure, 143
SET_SCHEMA_INSTANTIATION procedure, 21
SET_SCHEMA_PREFS Procedure, 140
SET_SENDFROM Procedure, 24
SET_SESSION_LONGOPS procedure, 20
SET_SESSION_TIMEOUT procedure, 121
SET_SOURCE_DATABASE_NAME member procedure, 247
SET_SQL_TRACE Procedure, 130
SET_SQLWKLD_PARAMETER Procedure, 18
SET_SYSTEM_STATS procedure, 140
SET_TABLE_INSTANTIATION procedure, 21
SET_TABLE_PREFS Procedure, 140
SET_TABLE_STATS procedure, 140
SET_TAG member procedure, 247
SET_TAG procedure, 142, 143
SET_TASK_PARAMETER Procedure, 18
SET_THRESHOLD procedure, 128
SET_TIMEOUT function, 52
SET_TIMEOUT procedure, 121
SET_TIMEOUT_BEHAVIOUR procedure, 52
SET_TRANSFER_TIMEOUT procedure, 223
SET_TRANSFORM procedure, 45
SET_TRIGGER_FIRING_PROPERTY procedure, 53
SET_TUNING_TASK_PARAMETER Function, 138
SET_UP_QUEUE procedure, 143
SET_UPDATE_CONFLICT_HANDLER procedure, 21
SET_VALUE function, 52
SET_VALUE member procedure, 247
SET_VALUE_DEPENDENCY procedure, 21
SET_VALUES member procedure, 247
SET_WALLET procedure, 223
SET_WARNING_SETTING_STRING procedure, 156
SET_WATERMARK Procedure, 23
SET_XML_INFORMATION member procedure, 247
SETACL Procedure, 165
SETACL procedure, 162
SETATTRIBUTE procedure, 169
SETATTRIBUTENODE function, 169
SETAUTHOR Procedure, 165
SETBASEDIR procedure, 172
SETBATCHSIZE procedure, 174
SETBINDVALUE procedure, 173
SETCHARACTERSET Procedure, 165
SETCHARSET Procedure, 169
SETCOLLIDATTRNAME procedure, 173
SETCOMMENT Procedure, 165
SETCOMMITBATCH procedure, 174
SETCONTENT Procedures, 162, 165
SETCONTENTTYPE Procedure, 81, 165
SETCONVERTSPECIALCHARS procedure, 170
SETCUSTOMMETADATA Procedure, 165
SETDATA procedure, 169
SETDATAHEADER procedure, 173
SETDATEFORMAT procedure, 173, 174
SETDCHARSET procedure, 169
SETDEFAULTACL Procedure, 47
SETDEFAULTASOF Procedur, 47
SETDEFAULTCONTEXT Procedure, 47
SETDEFAULTOWNER Procedure, 47
SETDEFAULTPRINCIPAL Procedure, 47
SETDISPLAYNAME Procedure, 165
SETDOCTYPE Procedure, 169
SETDOCTYPE procedure, 172
SETDVERSION procedure, 169
SETENCODINGTAG procedure, 173
SETERRORLOG procedure, 172, 179
SETERRORTAG procedure, 173
SETFTPPORT Procedure, 162
SETHTTPPORT Procedure, 162
SETIGNORECASE procedure, 174
SETINFO member procedure
of ANYTYPE TYPE, 241
SETKEYCOLUMN procedure, 174, 176
SETLANGUAGE Procedure, 165
SETLISTENERENDPOINT Procedure, 162
SETLISTENERLOCALACCESS Procedure, 162
SETMAXROWS procedure, 170, 173
SETMETAHEADER procedure, 173
SETNAMEDITEM function, 169
SETNODEVALUE procedure, 169
SETNODEVALUEASBINARYSTREAM Function & Procedure, 169
SETNODEVALUEASCHARACTERSTREAM Function & Procedure, 169
SETOPTIONS Procedure, 81
SETOWNER Procedure, 165
SETPARAM procedure, 179
SETPATH Procedure, 48
SETPATH Procedures, 47
SETPREFIX procedure, 169
SETPRESERVEWHITESPACE procedure, 172, 174
SETRAISEEXCEPTION procedure, 173
SETRAISENOROWSEXCEPTION procedure, 173
SETRENDERPATH Procedure, 168
SETRENDERSTREAM Procedure, 168
SETROWIDATTRNAME procedure, 173
SETROWIDATTRVALUE procedure, 173
SETROWSETTAG procedure, 170, 173
SETROWTAG procedure, 173, 174, 176
SETSCHEMAVALIDATED procedure, 258
SETSKIPROWS procedure, 170, 173
SETSOURCELANG Function, 177
SETSQLTOXMLNAMEESCAPING procedure, 173, 174
SETSTANDALONE procedure, 169
SETSTATS Procedure, 47
SETSTOREPROPERTY Procedure, 49
SETSTYLESHEETHEADER procedure, 173
SETTAGCASE procedure, 173
SETTRACE Procedure, 47
SETUPDATECOLUMN procedure, 174, 176
SETVALIDATIONMODE procedure, 172
SETVALUE procedure, 169
SETXSLT procedure, 173, 174
SETXSLTPARAM procedure, 173, 174
SHOW_BREAKPOINTS procedures, 52
SHOW_EXTENDED_STATS_NAME Function, 140
SHOW_FRAME_SOURCE procedure, 52
SHOW_SOURCE procedures, 52
SHOW_STATS procedure, 235
SHOWPAGE procedure, 193
SHOWSOURCE procedure, 193
SHOWWARNINGS procedure, 172, 179
SHUTDOWN Procedure, 89
SIGNAL procedure, 19
SIGNATURE procedure, 193
SIMPLE_SQL_NAME Function, 26
SIZES procedure, 131
SKIP_CORRUPT_BLOCKS procedure, 111
SLEEP procedure, 82
SMALL function
of HTF package, 181
SMALL procedure
of HTP package, 182
snapshot. See DBMS_MVIEW, 92
SOURCE_LINES_T Table Type, 104
SPACE_ERROR_INFO function, 121
SPACE_USAGE procedure, 132
SPACEUSAGE Procedure, 47, 48
split streams, 143
SPLIT_STREAMS procedure, 143
SPLITPATH Procedure, 162
SPLITTEXT function, 169
SQL Apply
managing logical standby databases, 85
managing with DBMS_LOGSTDBY package, 85
SQL generation, 247, 247
SQL Performance Reporting Subprograms, 138
SQL*Plus
creating a sequence, 1
SQL_OBJECT_NAME Function, 26
SQLID_TO_SQLHASH Function, 155
SQLSET_ROW Object Type, 138
SQLTEXT_TO_SIGNATURE Function, 138
STACK_BIN_CAT procedure, 45
STACK_BIN_NUM procedure, 45
STACK_CLIP procedure, 45
STACK_COL_REM procedure, 45
STACK_MISS_CAT procedure, 45
STACK_MISS_NUM procedure, 45
STACK_NORM_LIN procedure, 45
staging
queues
creating, 143
removing, 143
START_APPLY procedure, 21
START_CAPTURE Procedure, 158
START_CAPTURE procedure, 32
START_POOL Procedure, 37
START_PROFILER functions and procedures, 105
START_PROFILING Procedure, 72
START_PROPAGATION procedure, 106
START_REDEF_TABLE procedure, 109
START_REPLAY Procedure, 159
START_SERVICE procedure, 129
STARTTLS Function and Procedure, 234
STARTUP Procedure, 89
STARTUP_EXTPROC_AGENT procedure, 180
STATUS Function, 120
STATUS_LINE procedure, 193
STEP_ID function, 151
STOP_APPLY procedure, 21
STOP_CAPTURE procedure, 32
STOP_POOL Procedure, 37
STOP_PROFILER function and procedure, 105
STOP_PROFILING Procedure, 72
STOP_PROPAGATION procedure, 106
STOP_SERVICE procedure, 129
STOP_TASK Procedure, 100
STORE_T Record Type, 47
STORE_VALUES procedure, 189
stored outlines
DBMS_OUTLN, 98
OUTLN_PKG package, 98
STOREPUSH Procedure, 49
STREAM2MULTI procedure, 192
Streams
removing configuration, 143
STREAMS$_TRANSFORM_FUNCTION, 143
STRIKE function
of HTF package, 181
STRIKE procedure
of HTP package, 182
STRING function, 107
STRING_TO_RAW Function, 224
STRONG function
of HTF package, 181
STRONG procedure
of HTP package, 182
STYLE function
of HTF package, 181
STYLE procedure
of HTP package, 182
SUB procedure
of HTP package, 182
SUBMIT procedure, 77
SUBMIT_PENDING_AREA procedure, 118
subscribers
drop the subscription, 34
extend the window to create a new view, 34
purging the subscription window, 34
retrieve change data from the subscriber views, 34
subscription window
purging, 34
SUBSTR function, 231
SUBSTR Functions, 81
SUBSTRINGDATA function, 169
Summary of DBMS_AQELM Subprograms, 24
Summary of DBMS_DIMENSION Subprograms, 59
Summary of DBMS_ERRLOG Subprograms, 63
Summary of DBMS_MVIEW Subprograms, 92
Summary of DBMS_XDBZ Subprograms, 167
Summary of DBMS_XMLDOM Subprograms, 169
Summary of DBMS_XMLSCHEMA Subprograms, 175
Summary of UTL_LMS Subprograms, 227
SUMMARY procedure, 139
SUP function
of HTF package, 181
SUP procedure
of HTP package, 182
SWITCH_CONSUMER_GROUP_FOR_SESS procedure, 118
SWITCH_CONSUMER_GROUP_FOR_USER procedure, 118
SWITCH_CURRENT_CONSUMER_GROUP Procedure, 130
SWITCH_PLAN procedure, 118
SYNC_INTERIM_TABLE procedure, 109
SYNC_TEXT_INDEXES procedure, 64, 122
SYNCHRONIZE function, 52
synchronous capture
altering, 32
instantiation
preparing a table for, 32
rules, 143
SYNCINDEX Procedure, 171
synonyms
comparing, 35
SYS.MGW_MQSERIES_PROPERTIES Object Type, 89
SYS.MGW_PROPERTIES Object Type, 89
SYS.MGW_PROPERTY Object Type, 89
SYS.MGW_TIBRV_PROPERTIES Object Type, 89

T

table alias
attributes, 246
TABLE_CREATE procedure, 43
TABLE_TO_COMMA procedures, 155
TABLECAPTION function
of HTF package, 181
TABLECAPTION procedure
of HTP package, 182
TABLECLOSE function
of HTF package, 181
TABLECLOSE procedure
of HTP package, 182
TABLEDATA function
of HTF package, 181
TABLEDATA procedure
of HTP package, 182
TABLEHEADER function
of HTF package, 181
TABLEHEADER procedure
of HTP package, 182
TABLEOPEN function
of HTF package, 181
TABLEOPEN procedure
of HTP package, 182
TABLEPRINT function, 193
TABLEROWCLOSE function
of HTF package, 181
TABLEROWCLOSE procedure
of HTP package, 182
TABLEROWOPEN function
of HTF package, 181
TABLEROWOPEN procedure
of HTP package, 182
tables
comparing, 35
table items as arrays, 135
tablespace repositories
attaching tablespaces, 148
cloning tablespaces, 148
detaching tablespaces, 148
TABLESPACE_FIX_BITMAPS procedure, 133
TABLESPACE_FIX_SEGMENT_STATES procedure, 133
TABLESPACE_MIGRATE_FROM_LOCAL procedure, 133
TABLESPACE_MIGRATE_TO_LOCAL procedure, 133
TABLESPACE_REBUILD_BITMAPS procedure, 133
TABLESPACE_REBUILD_QUOTAS procedure, 133
TABLESPACE_RELOCATE_BITMAPS procedure, 133
TABLESPACE_SET type, 148
TABLESPACE_VERIFY procedure, 133
tablespaces
change tables and, 33
tags
GET_TAG function, 142, 143
SET_TAG procedure, 142, 143
TARGET_FILE function, 43
TARGET_LOB function, 43
TARGET_PROGRAM_RUNNING procedure, 52
TARGET_TABLE function, 43
TARGET_TRACE function, 43
TELETYPE function
of HTF package, 181
TELETYPE procedure
of HTP package, 182
TERMINATE procedure, 107
TEXT_DECODE function, 221
TEXT_ENCODE function, 221
TIME_TABLE Table Type, 135
TIME_WITH_TIME_ZONE_TABLE Table Type, 135
TIMESTAMP_TABLE Table Type, 135
TIMESTAMP_WITH_LTZ_TABLE Table Type, 135
TIMESTAMP_WITH_TIME_ZONE_TABLE Table Type, 135
TITLE function
of HTF package, 181, 181
TITLE procedure
of HTP package, 182
TO_CURSOR_NUMBER Function, 135
TO_REFCURSOR Function, 135
TO_STRING function, 254
TODATE function, 193
TOOBJECT procedure, 258
TOUCHRESOURCE Procedure, 162
TRACE Procedure, 47
TRACE procedure, 42
TRACEENABLED Function, 47
TRACETAB.SQL, 150
tracking LCRs, 143, 143
TRANSACTION_BACKOUT Procedures, 68
TRANSFORM function, 258
transformations
rule-based
adding a column, 143
custom, 143
deleting a column, 143
keeping columns, 143
renaming a column, 143
renaming a schema, 143
renaming a table, 143
STREAMS$_TRANSFORM_FUNCTION, 143
TRANSFORMNODE function, 179
TRANSLATE function, 231, 254
TRANSLATEXML Function, 177
TRANSLITERATE Function, 224, 231
transparent data encryption
apply process, 21
TRANSPORT_SET_CHECK procedure, 153
TRIM Procedures, 81
TUNE_MVIEW Procedure, 18
TYPE_BUILD function, 43
TYPE_DIMENSION_COMPILE function, 43
TYPE_OPERATIONS function, 43
TYPE_REJECTED_RECORDS function, 43
types
Expression Filter, 246
MGD_ID, 254, 254
MGD_ID_COMPONENT, 254
MGD_ID_COMPONENT_VARRAY, 254
Oracle Multimedia
ORDAudio, 248
ORDDicom, 249
ORDDoc, 250
ORDImage, 251
ORDVideo, 253
SQL/MM Still Image, 252
Rules Manager, 256

U

ULISTCLOSE function
of HTF package, 181
ULISTCLOSE procedure
of HTP package, 182
ULISTOPEN function
of HTF package, 181
ULISTOPEN procedure
of HTP package, 182
UNASSIGN_ACL Procedure, 93
UNASSIGN_ATTRIBUTE_SET procedure, 64
UNASSIGN_WALLET_ACL Procedure, 93
UNCHECKOUT function, 164
UNCL_ARRAY Table Type, 155
UNDERLINE function
of HTF package, 181
UNDERLINE procedure
of HTP package, 182
UNESCAPE function, 237
UNESCAPEURI function, 244
UNIFORM_DIST_FIT procedure, 139
UNIQUE_SESSION_ID Function, 130
UNIQUE_SESSION_NAME function, 102
UNKEEP procedure, 131
UNLOCK_MAP procedure, 141
UNLOCK_PARTITION_STATS Procedure, 140
UNLOCK_SCHEMA_STATS procedure, 140
UNLOCK_TABLE_STATS procedure, 140
UNLOCKPATH Procedure, 47, 48
UNLOCKRESOURCE function, 162
UNMAP_DAD Procedure, 62
UNMOUNTSTORE Procedure, 47
UNPACK_MESSAGE procedures, 102
UNPACK_STGTAB_BASELINE Function, 134
UNPACK_STGTAB_SQLPATCH Procedure, 136
UNPACK_STGTAB_SQLPROF Procedure, 138
UNPACK_STGTAB_SQLSET Procedure, 138
UNREGISTER_DEPENDENT_OBJECT procedure, 109
UNREGISTER_FOREIGN_QUEUE Procedure, 89
UNREGISTERSTORE Procedure, 47
UNREGISTERURLHANDLER procedure, 244
UNSCHEDULE_PROPAGATION Procedure, 89
UNUSED_SPACE procedure, 132
UPDATE_BY_CAT procedure, 98
UPDATE_CATEGORY Procedure, 118
UPDATE_CONSUMER_GROUP procedure, 118
UPDATE_OBJECT Procedure, 18
UPDATE_OBJECT procedure, 233
UPDATE_PLAN procedure, 118
UPDATE_PLAN_DIRECTIVE procedure, 118
UPDATE_REC_ATTRIBUTES Procedure, 18
UPDATE_SIGNATURES procedure, 98
UPDATE_SQLSET procedures, 138
UPDATE_SQLWKLD_ATTRIBUTES Procedure, 18
UPDATE_SQLWKLD_STATEMENT Procedure, 18
UPDATE_TASK_ATTRIBUTES Procedure, 18
UPDATERESOURCEMETADATA Procedures, 162
UPDATETRANSLATION Function, 177
UPDATEXML function, 174, 176
UPGRADE_DATABASE Procedure, 60
UPGRADE_SCHEMA Procedure, 60
UPGRADE_STAT_TABLE procedure, 140
UPGRADE_TABLE Procedure, 60
upgrading
post-upgrade actions, 95
URI Types
description, 244
UriFactory package, 244
ESCAPEURI function, 244
GETURL function, 244
methods, 244
REGISTERURLHANDLER procedure, 244
UNESCAPEURI function, 244
UNREGISTERURLHANDLER procedure, 244
UriType supertype, 244
GETBLOB function, 244
GETCLOB function, 244
GETCONTENTTYPE function, 244
GETEXTERNALURL function, 244
GETURL function, 244
GETXML function, 244
methods, 244
UROWID_TABLE Table Type, 135
USE_FILTER_SET Procedure, 159
USE_ROLLBACK_SEGMENT procedure, 151
USEBINARYSTREAM Function, 169
USEITEMTAGSFORCOLL procedure, 170
USENULLATTRIBUTEINDICATOR procedure, 170, 173
USER_EXPORT procedures, 77
USETYPEFORCOLLELEMTAG procedure, 173
Using DBMS_ADVISOR, 18
Using DBMS_AQIN, 25, 25
Using DBMS_FILE_GROUP, 66
Using DBMS_MVIEW, 92
Using DBMS_RULE, 125
Using DBMS_RULE_ADM, 126
Using DBMS_STREAMS, 142
Using DBMS_STREAMS_ADM, 143
Using DBMS_STREAMS_TABLESPACE_ADM, 148
Using DBMS_XMLDOM, 169
Using DBMS_XMLSCHEMA, 175
Using UTL_HTTP, 223
UTL Streams Types, 257
UTL_BINARYINPUTSTREAM Type, 257
UTL_BINARYOUTPUTSTREAM Type, 257
UTL_CHARACTERINPUTSTREAM Type, 257
UTL_CHARACTEROUTPUTSTREAM Type, 257
UTL_COLL package, 219
UTL_COMPRESS package, 220
UTL_ENCODE package, 221
UTL_FILE package, 222
UTL_HTTP package, 223
UTL_I18N package, 224
ESCAPE_REFERENCE function, 224, 224, 224, 224, 224, 224, 224
GET_DEFAULT_CHARSET function, 224
MAP_CHARSET function, 224
MAP_LANGUAGE_FROM_ISO function, 224
MAP_LOCALE_TO_ISO function, 224
MAP_TERRITORY_FROM_ISO function, 224
RAW_TO_CHAR function, 224
RAW_TO_NCHAR function, 224
UNESCAPE_REFERENCE function, 224
UTL_INADDR package, 225
UTL_LMS package, 227
FORMAT_MESSAGE function, 227
GET_MESSAGE function, 227
UTL_MAIL package, 228
UTL_MATCH package, 229
UTL_NLA package, 230
UTL_RAW package, 231
UTL_RECOMP package, 232
UTL_REF package, 233
UTL_SPADV package, 235
UTL_TCP package, 236
UTL_URL package, 237
UUDECODE function, 221
UUENCODE function, 221

V

V$STREAMS_MESSAGE_TRACKING view, 143, 143
v$vpd_policies, 123
VALIDATE procedure, 155
VALIDATE_DIMENSION procedure, 59
VALIDATE_EXPRESSIONS procedure, 64
VALIDATE_PENDING_AREA procedure, 118
VALIDATE_REWRITE_EQUIVALENCE Procedure, 17
VALIDATE_SCHEME function, 88
VALIDATE_XML procedure, 41
VALUE functions, 107
VALUEOF procedure, 179
VARCHAR2_TABLE Table Type, 135
VARCHAR2A Table Type, 135
VARCHAR2S Table Type, 135
VARIABLE function
of HTF package, 181
VARIABLE procedure
of HTP package, 182
VARIABLE_VALUE procedures, 135
VERBOSE_ACTION function, 43
VERBOSE_DEBUG function, 43
VERBOSE_INFO function, 43
VERBOSE_NOTICE function, 43
VERBOSE_STATS function, 43
VERIFY_VALUES function, 189
VERSION function, 43
views
comparing, 35
virtual dependency definitions
object dependencies
creating, 21
dropping, 21
value dependencies, 21
Virtual Private Database. See VPD
VPD
column masking, 123
enabling column-level, 123
viewing current cursors and policy predicates, 123
VPD use of DBMS_RLS, 123
VRFY function, 234

W

WAIT_ON_PENDING_DML Procedure, 155
WAITANY procedure, 19
WAITONE procedure, 19
WBR function
of HTF package, 181
WBR procedure
of HTP package, 182
WEIBULL_DIST_FIT procedure, 139
WHAT procedure, 77
WHO_CALLED_ME procedure, 193
WPG_DOCLOAD package, 238
WRAP Functions, 53
WRITE Procedures, 81
WRITE_DATA procedure, 234
WRITE_LINE function, 236
WRITE_LINE procedure, 223
WRITE_RAW function, 236
WRITE_RAW procedure, 223
WRITE_RAW_DATA procedure, 234
WRITE_TEXT function, 236
WRITE_TEXT procedure, 223
WRITEAPPEND Procedures, 81
WRITETOBUFFER procedure, 169
WRITETOCLOB procedure, 169
WRITETOFILE procedure, 169

X

XA_COMMIT Function, 161
XA_END Function, 161
XA_FORGET Function, 161
XA_GETLASTOER Function, 161
XA_PREPARE Function, 161
XA_RECOVER Function, 161
XA_ROLLBACK Function, 161
XA_SETTIMEOUT Function, 161
XA_START Function, 161
XDBEvent Type Subprograms, 168
XDBHandler Type Subprograms, 168
XDBHandlerList Type Subprograms, 168
XDBLink Type Subprograms, 168
XDBPath Type Subprograms, 168
XDBRepositoryEvent Type Subprograms, 168
XDBUriType, 244
XDBURITYPE function, 244
XDBUriType subtype, 244
CREATEURI function, 244
GETBLOB function, 244
GETCLOB function, 244
GETCONTENTTYPE function, 244
GETEXTERNALURL function, 244
GETURL function, 244
GETXML function, 244
methods, 244
XDBURITYPE function, 244
XDBZ Constants, 167
XFORM_BIN_CAT procedure, 45
XFORM_BIN_NUM procedure, 45
XFORM_CLIP procedure, 45
XFORM_COL_REM procedure, 45
XFORM_EXPR_NUM procedure, 45
XFORM_EXPR_STR procedure, 45
XFORM_MISS_CAT procedure, 45
XFORM_MISS_NUM procedure, 45
XFORM_NORM_LIN procedure, 45
XFORM_STACK procedure, 45
XML tags
specifying list of
configuring index parameters, 246
XML_TO_LCR Function, 90
XMLINDEXADDPATH Procedure, 163
XMLINDEXREMOVEPATH Procedure, 163
XMLType
CREATENONSCHEMABASEDXML function, 258
CREATESCHEMABASEDXML function, 258
CREATEXML function, 258
description, 258
EXISTSNODE function, 258
EXTRACT function, 258
GETBLOBVAL function, 258
GETCLOBVAL function, 258
GETNUMBERVAL function, 258
GETROOTELEMENT function, 258
GETSCHEMAURL function, 258
GETSTRINGVAL function, 258
ISFRAGMENT function, 258
ISSCHEMABASED function, 258
ISSCHEMAVALID function, 258
ISSCHEMAVALIDATED function, 258
NAMESPACE function, 258
SCHEMAVALIDATE procedure, 258
SETSCHEMAVALIDATED procedure, 258
TOOBJECT procedure, 258
TRANSFORM function, 258
XMLTYPE function, 258
XMLTYPE function, 258
XPath parameters
adding to attribute list, 64
dropping from attribute list, 64
XPath predicates
indexing set of
configuring XML element or XML attribute, 246
XPINDEX_PARAMETERS procedure, 64
XRANGE function, 231