Skip Headers
Oracle® Database PL/SQL Packages and Types Reference
12c Release 1 (12.1)

E17602-14
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
PDF · Mobi · ePub

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, 132
ABORT_GLOBAL_INSTANTIATION procedure, 34
ABORT_REDEF_TABLE procedure, 120
ABORT_SCHEMA_INSTANTIATION procedure, 34
ABORT_TABLE_INSTANTIATION procedure, 34
ABORTED_REQUEST_THRESHOLD procedure, 142
ACCEPT_SQL_PATCH Procedure, 150
ACCEPT_SQL_PLAN_BASELINE Procedure, 146
ACCEPT_SQL_PROFILE procedure, 152
ACLCHECKPRIVILEGES Function, 183
ACTIVE_INSTANCES Procedure, 172
ADD_CAPTURE Procedure, 176
ADD_COLORED_SQL Procedure, 177
ADD_COLUMN member procedure, 273
ADD_COLUMN procedure, 157, 202
ADD_COOKIES procedure, 250
ADD_FILE procedure, 68
ADD_FILTER Procedure, 175, 176
ADD_GLOBAL_PROPAGATION_RULES procedure, 157, 202
ADD_GLOBAL_RULES procedure, 157, 202
ADD_GROUPED_POLICY Procedure, 133
ADD_MESSAGE_PROPAGATION_RULE procedure, 157
ADD_MESSAGE_RULE procedure, 157
ADD_OUTBOUND procedure, 202
ADD_PAIR member procedure, 281
ADD_POLICY Procedure, 67, 119, 133, 169
ADD_POLICY_CONTEXT Procedure, 133
ADD_PRIVILEGE Procedure, 100
ADD_RULE procedure, 137
ADD_SCHEDULE_ORDERING Function, 176
ADD_SCHEMA_PROPAGATION_RULES procedure, 157, 202
ADD_SCHEMA_RULES procedure, 157, 202
ADD_SCHEME procedure, 95
ADD_SENSITIVE_COLUMN Procedure, 168
ADD_SENSITIVE_TYPE Procedure, 168
ADD_SQLSET_REFERENCE function, 152
ADD_SQLWKLD_REF Procedure, 19
ADD_SQLWKLD_STATEMENT Procedure, 19
ADD_STMT_HANDLER procedure, 23
ADD_STMT_TO_HANDLER procedure, 160
ADD_SUBSCRIBER Procedure, 96
ADD_SUBSET_OUTBOUND_RULES procedure, 202
ADD_SUBSET_PROPAGATION_RULES procedure, 157, 202
ADD_SUBSET_RULES procedure, 157, 202
ADD_TABLE_PROPAGATION_RULES procedure, 157, 202
ADD_TABLE_RULES procedure, 157, 202
ADD_TABLE_TO_APPLICATION Procedure, 71
ADD_TO_ILM Procedure, 79
ADD_WARNING_SETTING_CAT procedure, 173
ADD_WARNING_SETTING_NUM procedure, 173
ADD2MULTI procedure, 216
ADDATTR member procedure
of ANYTYPE TYPE, 268
ADDHTTPEXPIREMAPPING Procedure, 181
ADDINSTANCE member procedure
of ANYDATASET TYPE, 267
ADDMIMEMAPPING Procedure, 181
ADDREPOSITORYRESCONFIG Procedure, 128
ADDRESCONFIG Function, 128
ADDRESS function
of HTF package, 205
ADDRESS procedure
of HTP package, 206
ADDSCHEMALOCMAPPING Procedure, 181
ADDSERVLET Procedure, 181
ADDSERVLETMAPPING Procedure, 181
ADDSERVLETSECROLE Procedure, 181
ADDXDBNAMESPACE, 196
ADDXMLEXTENSION Procedure, 181
ADM_DROP_CHUNKS Procedure, 106
ADM_DROP_TASK Procedure, 106
ADM_GET_TASK_STATUS Procedure, 106
ADM_STOP_TASK Procedure, 106
ADMIN_TABLES procedure, 122
ADVISE_COMMIT procedure, 166
ADVISE_NOTHING procedure, 166
ADVISE_ROLLBACK procedure, 166
ADVISOR privilege, 42, 42
advisors
Oracle Streams, 158
aggregation management, 42
aggregation operators (OLAP), 42
ALLOCATE_UNIQUE procedure, 88
ALTER_AGENT Procedure, 96
ALTER_APPLY procedure, 23
ALTER_CAPTURE procedure, 34
ALTER_COMPILE procedure, 54
ALTER_EVALUATION_CONTEXT procedure, 137
ALTER_FILE procedure, 68
ALTER_FILE_GROUP procedure, 68
ALTER_GROUPED_POLICY Procedure, 133
ALTER_INBOUND procedure, 202
ALTER_JOB Procedure, 96
ALTER_MSGSYSTEM_LINK Procedure for TIB/Rendezvous, 96
ALTER_MSGSYSTEM_LINK Procedure for WebSphere MQ, 96
ALTER_OUTBOUND procedure, 202
ALTER_PARAM Procedure, 37
ALTER_POLICY Procedure, 119, 133, 169
ALTER_PROPAGATION procedure, 115
ALTER_PROPAGATION_SCHEDULE Procedure, 96
ALTER_REWRITE_EQUIVALENCE Procedure, 18
ALTER_RULE procedure, 137
ALTER_SENSITIVE_COLUMN Procedure, 168
ALTER_SQL_PATCH Procedure, 150
ALTER_SQL_PLAN_BASELINE Function, 146
ALTER_SQL_PLAN_DIRECTIVE Procedure, 145
ALTER_SQL_PROFILE procedure, 152
ALTER_STATS_HISTORY_RETENTION procedure, 153
ALTER_SUBSCRIBER Procedure, 96
ALTER_SYNC_CAPTURE procedure, 34
ALTER_TABLE_NOT_REFERENCEABLE procedure, 54
ALTER_TABLE_REFERENCEABLE procedure, 54
ALTER_VERSION procedure, 68
AMATCH function, 214
ANALYZE Function, 76
ANALYZE Procedure, 33
ANALYZE_CURRENT_PERFORMANCE procedure, 158
ANALYZE_DATABASE Procedure, 172
ANALYZE_DB Procedure, 17
ANALYZE_INST Procedure, 17
ANALYZE_PART_OBJECT Procedure, 172
ANALYZE_PARTIAL Procedure, 17
ANALYZE_SCHEMA Procedure, 172
ANCHOR function
of HTF package, 205
ANCHOR procedure
of HTP package, 206
ANCHOR2 function
of HTF package, 205
ANCHOR2 procedure
of HTP package, 206
anonymous PL/SQL blocks
dynamic SQL and, 147
AnyData datatype
queues
creating, 157, 202
removing, 157, 202
ANYDATA TYPE, 266
ANYDATASET TYPE, 267
ANYTYPE TYPE, 268
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, 87
APPEND_HOST_ACE Procedure, 100
APPEND_HOST_ACL Procedure, 100
APPEND_WALLET_ACE Procedure, 100
APPEND_WALLET_ACL Procedure, 100
APPENDCHILD function, 189
APPENDDATA procedure, 189
APPENDRESCONFIG Procedure, 128
APPENDRESOURCEMETADATA Procedure, 183
APPLETCLOSE function
of HTF package, 205
APPLETCLOSE procedure
of HTP package, 206
APPLETOPEN function
of HTF package, 205
APPLETOPEN procedure
of HTP package, 206
apply process
altering, 23
apply user, 157
change handlers
setting, 23
conflict handlers
setting, 23
creating, 23, 157, 157, 157, 157, 157, 202, 202, 202, 202
DBMS_APPLY_ADM package, 23
DDL handler
setting, 23, 23
dropping, 23
enqueuing events, 23
error handlers
setting, 23
error queue
deleting errors, 23, 23
executing errors, 23, 23
getting error messages, 23
instantiation
global SCN, 23
schema SCN, 23
table SCN, 23
message handler
setting, 23, 23
parameters
allow_duplicate_rows, 23, 34, 34
apply_sequence_nextval, 23
commit_serialization, 23
compare_key_only, 23
compute_lcr_dep_on_arrival, 23
disable_on_error, 23
disable_on_limit, 23
eager_size, 23
enable_xstream_table_stats, 23
grouptransops, 23
handle_collisions, 23
ignore_transaction, 23
max_parallelism, 23
max_sga_size, 23
maximum_scn, 23
optimize_progress_table, 23
optimize_self_updates, 23
parallelism, 23
parallelism_interval, 23
preserve_encryption, 23
rtrim_on_implicit_conversion, 23
setting, 23
startup_seconds, 23
suppresstriggers, 23
time_limit, 23
trace_level, 23
transaction_limit, 23
txn_age_spill_threshold, 23
txn_lcr_spill_threshold, 23
precommit handler
setting, 23, 23
procedure DML handlers
setting, 23
rules
defining global, 157, 202
defining message, 157
defining schema, 157, 202
defining subset, 157, 202
defining table, 157, 202
for LCRs, 157
for user messages, 157
removing, 157, 202
specifying execution, 23
starting, 23
statement DML handlers
setting, 23, 23
stopping, 23
substitute key columns
setting, 23
apply user
DBMS_STREAMS_ADM package, 157
APPLY$_ENQUEUE, 23
APPLY$_EXECUTE, 23
AQ$_AGENT Type, 269
AQ$_AGENT_LIST_T Type, 269
AQ$_DESCRIPTOR Type, 269, 269
AQ$_NTFN_MSGID_ARRAY Type, 269
AQ$_POST_INFO Type, 269
AQ$_POST_INFO_LIST Type, 269
AQ$_PURGE_OPTIONS_T Type, 269
AQ$_RECIPIENT_LIST_T Type, 269
AQ$_REG_INFO Type, 269
AQ$_REG_INFO_LIST Type, 269
AQ$_SUBSCRIBER_LIST_T Type, 269
ARCHIVESTATENAME Function, 79
AREA function
of HTF package, 205
AREA procedure
of HTP package, 206
arrays
BIND_ARRAY procedure, 147
bulk DML using DBMS_SQL, 147
ASA_RECO_ROW Record Type, 143
ASA_RECO_ROW_TB Table Type, 143
ASA_RECOMMENDATIONS Function, 143
ASH_GLOBAL_REPORT_HTML Function, 177
ASH_GLOBAL_REPORT_TEXT Function, 177
ASH_REPORT_HTML Function, 177
ASH_REPORT_TEXT Function, 177
ASSIGN_ACL Procedure, 100
ASSIGN_WALLET_ACL Procedure, 100
ASSM_SEGMENT_VERIFY Procedure, 144
ASSM_TABLESPACE_VERIFY Procedure, 144
ASSOCIATE_POLICY Procedure, 169
ATTACH_SESSION procedure, 53
ATTACH_SIMPLE_TABLESPACE procedure, 162
ATTACH_TABLESPACES procedure, 162
AUTH Function and Procedure, 261
AUTHORIZE function, 211
AUTHORIZE_DAD Procedure, 65
AVAILABLE function, 263
AWR_BASELINE_METRIC_TYPE Object Type, 177
AWR_BASELINE_METRIC_TYPE_TABLE Table Type, 177
AWR_DIFF_REPORT_HTML Function, 177
AWR_DIFF_REPORT_TEXT Function, 177
AWR_GLOBAL_DIFF_REPORT_HTML Functions, 177
AWR_GLOBAL_DIFF_REPORT_TEXT Functions, 177, 177
AWR_GLOBAL_REPORT_HTML Functions, 177
AWR_GLOBAL_REPORT_TEXT Functions, 177
AWR_REPORT_HTML function, 177
AWR_REPORT_TEXT function, 177
AWR_SET_REPORT_THRESHOLDS Procedure, 177
AWR_SQL_REPORT_HTML Function, 177
AWR_SQL_REPORT_TEXT Function, 177

B

BACKTRACE_DEPTH Function, 245
BACKTRACE_LINE Function, 245
BACKTRACE_UNIT Function, 245
BASE function
of HTF package, 205
BASE procedure
of HTP package, 206
BASE64_DECODE function, 248
BASE64_ENCODE function, 248
BASEFONT function
of HTF package, 205
BASEFONT procedure
of HTP package, 206
BEGIN_OPERATION Function, 98, 149
BEGIN_PREPARE Procedure, 62
BEGIN_REPLAY_SCHEDULE Procedure, 176
BEGIN_REQUEST function, 250
BEGIN_SQL_BLOCK Procedure, 129
BEGIN_UPGRADE Procedure, 62
BEGINCREATE static procedure
of ANYDATA TYPE, 266
of ANYDATASET TYPE, 267
of ANYTYPE TYPE, 268
BFILE_TABLE Table Type, 147
BGSOUND function
of HTF package, 205
BGSOUND procedure
of HTP package, 206
BIG function
of HTF package, 205
BIG procedure
of HTP package, 206
BINARY_DOUBLE_TABLE Table Type, 147
BINARY_FLOAT_TABLE Table Type, 147
BIND_ARRAY procedures, 147
BIND_INOUT_VARIABLE Procedure, 78
BIND_INOUT_VARIABLE_RAW Procedure, 78
BIND_OUT_VARIABLE Procedure, 78
BIND_OUT_VARIABLE_RAW Procedure, 78
BIND_VARIABLE Procedure, 78
BIND_VARIABLE procedures, 147
BIND_VARIABLE_RAW Procedure, 78
BIND_VARIABLES function, 217
BIT_AND function, 258
BIT_COMPLEMENT function, 258
BIT_OR function, 258
BIT_XOR function, 258
BLAS Level 1 (Vector-Vector Operations) Subprograms, 257
BLAS Level 2 (Matrix-Vector Operations) Subprograms, 257
BLAS Level 3 (Matrix-Matrix Operations) Subprograms, 257
BLAS_ASUM Functions, 257
BLAS_AXPY Procedures, 257
BLAS_COPY Procedures, 257
BLAS_DOT Functions, 257
BLAS_GBMV Procedures, 257
BLAS_GEMM Procedures, 257
BLAS_GEMV Procedures, 257
BLAS_GER Procedures, 257
BLAS_IAMAX Functions, 257
BLAS_NRM2 Functions, 257
BLAS_ROT Procedures, 257
BLAS_ROTG Procedures, 257
BLAS_SBMV Procedures, 257
BLAS_SCAL Procedure, 257
BLAS_SPMV Procedures, 257
BLAS_SPR Procedures, 257
BLAS_SPR2 Procedures, 257
BLAS_SWAP Procedure, 257
BLAS_SYMM Procedures, 257
BLAS_SYMV Procedures, 257
BLAS_SYR Procedures, 257
BLAS_SYR2 Procedures, 257
BLAS_SYRK Procedures, 257
BLAS_TBMV Procedures, 257
BLAS_TBSV Procedures, 257
BLAS_TPMV Procedures, 257
BLAS_TPSV Procedures, 257
BLAS_TRMM Procedures, 257
BLAS_TRMV Procedures, 257
BLAS_TRSM Procedures, 257
BLAS_TRSV Procedures, 257
BLOB_TABLE Table Type, 147
BLOCK_HEAT_MAP Function, 74
BLOCKQUOTECLOSE function
of HTF package, 205
BLOCKQUOTECLOSE procedure
of HTP package, 206, 206
BLOCKQUOTEOPEN function
of HTF package, 205
BLOCKQUOTEOPEN procedure
of HTP package, 206
BODYCLOSE function
of HTF package, 205
BODYCLOSE procedure
of HTP package, 206
BODYOPEN function
of HTF package, 205
BODYOPEN procedure
of HTP package, 206
BOLD function
of HTF package, 205
BOLD procedure
of HTP package, 206
BR function
of HTF package, 205
BR procedure
of HTP package, 206
BREAKPOINT_INFO Record Type, 53
BROKEN procedure, 83
BUILD procedure, 34, 42
BUILD_CHAIN_ROWS_TABLE procedure, 81
BUILD_EXCEPTIONS_TABLE procedure, 81
BUILD_PART_INDEX procedure, 108
BUILD_SAFE_REWRITE_EQUIVALENCE Procedure, 18
BYPASS Procedure, 131

C

CALENDARPRINT procedures, 217
CALIBRATE Function, 176
CALIBRATE_IO Procedure, 129
CAN_REDEF_TABLE procedure, 120
CANCEL_ANALYSIS_TASK Procedure, 151
CANCEL_DIAGNOSIS_TASK Procedure, 150
CANCEL_EVOLVE_TASK Procedure, 146
CANCEL_REPLAY Procedure, 176
CANCEL_TASK Procedure, 19
CANCEL_TUNING_TASK procedure, 152
CANONICALIZE Procedure, 172
capture process
altering, 34
building a Streams data dictionary, 34
capture user, 157
creating, 157, 157, 157, 157, 202, 202, 202, 202
DBMS_CAPTURE_ADM package, 34
instantiation
aborting database preparation, 34
aborting schema preparation, 34
aborting table preparation, 34
preparing a database for, 34
preparing a schema for, 34
preparing a table for, 34
parameters
disable_on_limit, 34
downstream_real_time_mine, 34
excludetag, 23, 34
excludetrans, 23, 34
excludeuser, 23, 34
excludeuserid, 23, 34
getapplops, 23, 34
ignore_transaction, 34
ignore_unsupported_table, 34
include_objects, 34
max_sga_size, 34
maximum_scn, 34
merge_threshold, 34
message_limit, 34
message_tracking_frequency, 34
parallelism, 34
setting, 34
skip_autofiltered_table_ddl, 34
startup_seconds, 34
time_limit, 34
trace_level, 34
write_alert_log, 34, 34
xout_client_exists, 34
rules, 157
defining global, 157, 202
defining schema, 157, 202
defining subset, 157, 202
defining table, 157, 202
removing, 157, 202
starting, 34
stopping, 34
CAPTURE_CURSOR_CACHE_SQLSET Procedure, 152
CAST_FROM_BINARY_DOUBLE function, 258
CAST_FROM_BINARY_FLOAT function, 258
CAST_FROM_BINARY_INTEGER function, 258
CAST_FROM_NUMBER function, 258
CAST_TO_BINARY_DOUBLE function, 258
CAST_TO_BINARY_FLOAT function, 258
CAST_TO_BINARY_INTEGER function, 258
CAST_TO_NUMBER function, 258
CAST_TO_NVARCHAR2 function, 258
CAST_TO_RAW function, 258
CAST_TO_VARCHAR2 function, 258
CB$ table prefix, 42
CELLSPRINT procedures, 217
CENTER function
of HTF package, 205
CENTER procedure
of HTP package, 206
CENTERCLOSE function
of HTF package, 205
CENTERCLOSE procedure
of HTP package, 206
CENTEROPEN function
of HTF package, 205
CENTEROPEN procedure
of HTP package, 206
CFG_GET Function, 181
CFG_REFRESH Procedure, 181
CFG_UPDATE Procedure, 181
change data capture
Oracle Streams
configuring, 157
CHANGE functions and procedures, 214
CHANGE procedure, 83
CHANGEOWNER Procedure, 183
CHANGEPRIVILEGES Function, 183
CHARARR Table Type, 105
CHECK_OBJECT procedure, 122
CHECK_PLUG_COMPATIBILITY Function, 109
CHECK_PRIVILEGE Function, 100
CHECK_PRIVILEGE_ACLID Function, 100
CHECKACCESS Function, 48, 49
CHECKIN function, 184
CHECKOUT procedure, 184
CHECKPRIVILEGES Function, 183
CHECKSPI Functions and Procedures, 48
CHECKSUM functions, 213
CHOOSE_DATE procedure, 217
CITE function
of HTF package, 205
CITE procedure
of HTP package, 206
CLEAN_AUDIT_TRAIL procedure, 29
CLEANUP_GATEWAY Procedure, 96
CLEANUP_GIDX Procedure, 107
CLEANUP_INSTANTIATION_SETUP procedure, 157
CLEANUP_ONLINE_OP Procedure, 107
CLEANUPUNUSEDBACKUPFILES Procedure, 50
CLEAR Procedure, 188
CLEAR_ALL_CONTEXT Procedure, 141
CLEAR_AUDIT_TRAIL_PROPERTY procedure, 29
CLEAR_CONTEXT Procedure, 141
CLEAR_COOKIES procedure, 250
CLEAR_HEAT_MAP_ALL Procedur, 80
CLEAR_HEAT_MAP_TABLE Procedure, 80
CLEAR_IDENTIFIER Procedure, 141
CLEAR_LAST_ARCHIVE_TIMESTAMP procedure, 29
CLEAR_PENDING_AREA procedure, 129
CLEAR_PLSQL_TRACE procedure, 165
CLEAR_USED procedure, 104
CLEARKEYCOLUMNLIST procedure, 194, 198
CLEARUPDATECOLUMNLIST procedure, 194, 198
CLIENT_ID_STAT_DISABLE procedure, 98
CLIENT_ID_STAT_ENABLE procedure, 98
CLIENT_ID_TRACE_DISABLE procedure, 98
CLIENT_ID_TRACE_ENABLE procedure, 98
CLOB_TABLE Table Type, 147
CLOB2FILE procedure, 201
CLONE_SIMPLE_TABLESPACE procedure, 162
CLONE_TABLESPACES procedure, 162
CLONEDB_RENAMEFILE Procedure, 61
CLONENODE function, 189
CLOSE Procedure, 87
CLOSE_ALL_CONNECTIONS procedure, 263
CLOSE_CONNECTION procedure, 263
CLOSE_CONNECTION Procedure, 261
CLOSE_CURSOR procedure, 147
CLOSE_CURSOR Procedure, 78
CLOSE_DATA Function and Procedure, 261
CLOSE_DATABASE_LINK Procedure, 141
CLOSE_ITERATOR procedure, 136
CLOSE_PERSISTENT_CONN procedure, 250
CLOSE_PERSISTENT_CONNS procedure, 250
CLOSECONTEXT procedure, 190, 193, 194, 198
COAD_ADVICE_REC type, 43
COAD_ADVICE_T type, 43
CODE function
of HTF package, 205
CODE procedure
of HTP package, 206
COLLECT_STATS procedure, 262
collections
table items, 147
COLUMN_VALUE procedure, 147
COLUMN_VALUE_LONG procedure, 147
COMMA_TO_TABLE Procedures, 172
COMMAND function and procedure, 261
COMMAND_REPLIES function, 261
COMMENT function
of HTF package, 205
COMMENT procedure
of HTP package, 206
COMMIT procedure, 166
COMMIT_COMMENT procedure, 166
COMMIT_FORCE procedure, 166
COMPARE function, 258
COMPARE Function, 35
COMPARE Functions, 87
COMPARE_CAPTURE_REPLAY_REPORT Function, 17
COMPARE_DATABASES Function, 17
COMPARE_INSTANCES Function, 17
COMPARE_OLD_VALUES procedure, 23
COMPARE_PERIOD_REPORT Procedure, 176
COMPARE_REPLAY_REPLAY_REPORT Function, 17
COMPARE_SQLSET_REPORT Function, 176
COMPARISON_TYPE type, 35
COMPATIBLE_10_1 function, 156, 273
COMPATIBLE_10_2 function, 156, 273
COMPATIBLE_11_1 function, 156
COMPATIBLE_11_2 function, 156
COMPATIBLE_12_1 function, 156
COMPATIBLE_9_2 function, 156, 273
COMPILE_FROM_REMOTE procedure, 86
COMPILE_SCHEMA Procedure, 172
COMPILESCHEMA procedure, 195
CONCAT function, 258
CONCATENATE_SUBPROGRAM Function, 245
CONFIGURE Procedure, 146
CONFIGURE_POOL Procedure, 37
CONFIGUREAUTOSYNC procedure, 186
conflicts
detection
stopping, 23
CONNECTION record type, 261
constants
DBMS_MGWMSG package, 97
CONTAINS_HOST Function, 101
CONTINUE function, 53
CONVERGE Procedure, 35
CONVERT function, 88, 190, 258
CONVERT_ANYDATA_TO_LCR_DDL function, 156
CONVERT_ANYDATA_TO_LCR_ROW function, 156
CONVERT_LCR_TO_XML function, 156
CONVERT_LONG_TO_LOB_CHUNK member procedure, 273
CONVERT_RAW_VALUE procedures, 153
CONVERT_RAW_VALUE_NVARCHAR procedure, 153
CONVERT_RAW_VALUE_ROWID procedure, 153
CONVERT_XML_TO_LCR function, 156
CONVERTTOBLOB procedure, 87
CONVERTTOCLOB Procedure, 87
COPIES function, 258
COPY Procedures, 87
COPY_DBFS_LINK Procedures, 87
COPY_FILE procedure, 69
COPY_FROM_DBFS_LINK, 87
COPY_TABLE_DEPENDENTS procedure, 120
COPY_TABLE_STATS Procedure, 153
COPYEVOLVE procedure, 195
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, 42
CREATE ANY MATERIALIZED VIEW privilege, 42
CREATE DIMENSION privilege, 42
CREATE MATERIALIZED VIEW privilege, 42
CREATE PACKAGE BODY command, 1
CREATE PACKAGE command, 1
CREATE SESSION privilege, 42, 42
CREATE_ACL Procedure, 100
CREATE_AFFECTED_TABLE Procedure, 62
CREATE_AGENT Procedure, 96
CREATE_ALTER_TYPE_ERROR_TABLE Procedure, 172
CREATE_ANALYSIS_TASK Functions, 151
CREATE_APPLY procedure, 23
CREATE_BASELINE Function & Procedure, 177
CREATE_BASELINE_TEMPLATE Procedures, 177
CREATE_BIN_CAT procedure, 46
CREATE_BIN_NUM procedure, 46
CREATE_CAPTURE procedure
capture process
creating, 34
CREATE_CAPTURE Procedure, 113
CREATE_CATEGORY function, 95
CREATE_CATEGORY Procedure, 129
CREATE_CDB_PLAN Procedure, 129
CREATE_CDB_PLAN_DIRECTIVE Procedure, 129
CREATE_CHUNKS_BY_NUMBER_COL Procedure, 106
CREATE_CHUNKS_BY_ROWID Procedure, 106
CREATE_CHUNKS_BY_SQL Procedure, 106
CREATE_CLIP procedure, 46
CREATE_COL_REM procedure, 46
CREATE_COMPARISON Procedure, 35
CREATE_CONSUMER_GROUP procedure, 129
CREATE_CREDENTIAL Procedure, 39
CREATE_DAD Procedure, 65
CREATE_DIAGNOSIS_TASK Functions, 150
CREATE_ERROR_LOG Procedure, 66
CREATE_ERROR_TABLE Procedure, 62
CREATE_EVALUATION_CONTEXT procedure, 137
CREATE_EVOLVE_TASK Function, 146
CREATE_EXTENDED_STATS Function, 153
CREATE_FILE Procedure, 19
CREATE_FILE_GROUP procedure, 68
CREATE_FILTER_SET Procedure, 176
CREATE_INBOUND procedure, 202
CREATE_INDEX_COST procedure, 143
CREATE_JOB Procedure, 96
CREATE_MISS_CAT procedure, 46
CREATE_MISS_NUM procedure, 46
CREATE_MSGSYSTEM_LINK Procedure for TIB/Rendezvous, 96
CREATE_MSGSYSTEM_LINK Procedure for WebSphere MQ, 96
CREATE_MVIEW function, 42, 42
CREATE_NORM_LIN procedure, 46
CREATE_OBJECT Procedure, 19
CREATE_OBJECT_DEPENDENCY procedure, 23
CREATE_OR_REPLACE_VIEW procedure
of DBMS_HS_PARALLEL package, 77
CREATE_OUTBOUND procedure, 202
CREATE_OUTLINE procedure, 104
CREATE_PENDING_AREA procedure, 129
CREATE_PIPE function, 110
CREATE_PLAN procedure, 129
CREATE_PLAN_DIRECTIVE procedure, 129
CREATE_POLICY_GROUP Procedure, 133
CREATE_PROFILE Procedure, 148
CREATE_PROPAGATION procedure, 115
CREATE_PURGE_JOB procedure, 29
CREATE_REQUEST_CONTEXT Function, 250
CREATE_RULE procedure, 137
CREATE_RULE_SET procedure, 137
CREATE_SERVICE procedure, 140
CREATE_SIMPLE_PLAN procedure, 129
CREATE_SNAPSHOT function and procedure, 177
CREATE_SQL_PLAN_BASELINE Procedure, 152
CREATE_SQLSET procedure, 152
CREATE_SQLWKLD Procedure, 19
CREATE_STAT_TABLE procedure, 153
CREATE_STGTAB_BASELINE Procedure, 146
CREATE_STGTAB_DIRECTIVE Procedure, 145
CREATE_STGTAB_SQLPATCH Procedure, 150
CREATE_STGTAB_SQLPROF Procedure, 152
CREATE_STGTAB_SQLSET Procedure, 152
CREATE_STMT_HANDLER procedure, 160
CREATE_SYNC_CAPTURE procedure
synchronous capture
creating, 34
CREATE_TABLE_COST procedures, 143
CREATE_TABLE_COST_COLINFO Object Type, 143
CREATE_TABLE_TEMPLAGE procedure
of DBMS_HS_PARALLEL package, 77
CREATE_TASK Procedure, 106
CREATE_TASK Procedures, 19
CREATE_TEMP_HISTORY_TABLE Procedure, 71
CREATE_TRANSFORMATION procedure, 167
CREATE_TRIGGER_TABLE Procedure, 62
CREATE_TUNING_TASK functions, 152
CREATE_VERSION procedure, 68
CREATE_WRAPPED Procedure, 54
CREATEATTRIBUTE function, 189
CREATEBUCKET Procedure, 50
CREATECDATASECTION function, 189
CREATECOMMENT function, 189
CREATEDATASTOREPREF procedure, 186
CREATEDATEINDEX Procedure, 191
CREATEDIRECTORY Procedures, 48, 49
CREATEDOCUMENT function, 189
CREATEDOCUMENTFRAGMENT function, 189
CREATEELEMENT function, 189
CREATEENTITYREFERENCE function, 189
CREATEFILE Procedures, 48, 49
CREATEFILESYSTEM Procedure, 51
CREATEFILTERPREF procedure, 186
CREATEFOLDER Function, 183
CREATEINDEX procedure, 186
CREATELEXERPREF procedure, 186
CREATELINK Procedures, 48, 49
CREATENONCEKEY Procedure, 180, 187
CREATENONSCHEMABASEDXML function, 283
CREATENUMBERINDEX Procedure, 191
CREATEOIDPATH Function, 183
CREATEPREFERENCES procedure, 186
CREATEPROCESSINGINSTRUCTION function, 189
CREATEREFERENCE Procedures, 48, 49
CREATEREPOSITORYXMLINDEX Procedure, 180
CREATERESOURCE Functions, 183
CREATESCHEMABASEDXML function, 283
CREATESECTIONGROUPPREF procedure, 186
CREATESTOPLISTPREF procedure, 186
CREATESTORAGEPREF procedure, 186
CREATESTORE Procedure, 50, 51
CREATETEMPORARY Procedures, 87
CREATETEXTNODE function, 189
CREATEURI function, 271, 271, 271
CREATEWORLDLISTPREF procedure, 186
CREATEXML function, 283
creating
packages, 1
CTX_ADM package, 6
CTX_ADM package documentation, 6
CTX_ANL package, 7
CTX_ANL package documentation, 7
CTX_CLS package, 8
CTX_CLS package documentation, 8
CTX_DDL package, 9
CTX_DDL package documentation, 9
CTX_DOC package documentation, 10
CTX_ENTITY package, 11
CTX_ENTITY package documentation, 11
CTX_OUTPUT package documentation, 12
CTX_QUERY package documentation, 13
CTX_REPORT package documentation, 14
CTX_THES package documentation, 15
CTX_ULEXER package documentation, 16
cube aggregation, 42
Cube Build log, 44
Cube Dimension Compile log, 44
cube log verbosity levels, 44
cube logging targets, 44
cube logging types, 44
cube maintenance, 42
cube materialized views, 42
optimizing, 43
Cube Operations log, 44
cube refresh, 42
Cube Rejected Records Log, 44
CUBE_BUILD_LATEST view, 42
CUBE_BUILD_REPORT view, 42
CUBE_BUILD_REPORT_LATEST view, 42
CUBE_UPGRADE_INFO table, 42
cubes
optimizer statistics, 33
CURRENT_EDITION Function, 245
CURRENT_INSTANCE Function, 172
cursors
DBMS_SQL package, 147
CUSTOMIZE_ILM Procedure, 80

D

data dictionary
removing Streams information, 157
removing XStream information, 202
DATA function and procedure, 261
data mining
algorithms, 45
anomaly detection, 45
association rules, 45
attribute importance, 45
automated, 111
Automatic Data Preparation, 45
classification, 45
clustering, 45, 45
confusion matrix, 45
cost matrix, 45
creating a model, 45
data transformation, 45, 45, 45, 45
feature extraction, 45
lift, 45
mining functions, 45
PMML, 45
regression, 45, 45
ROC, 45
scoring, 45, 45
supervised, 45
transactional data, 45
transformations, 46
unsupervised, 45
DATA_BLOCK_ADDRESS_BLOCK Function, 172
DATA_BLOCK_ADDRESS_FILE Function, 172
database
locking
OWA_OPT_LOCK package, 213
database tables
creating for DBMS_TRACE, 165
DATABASE_TRACE_DISABLE Procedure, 98
DATABASE_TRACE_ENABLE Procedure, 98
datatypes
DBMS_DESCRIBE, 58
PL/SQL
numeric codes for, 58
DATE_TABLE Table Type, 147
DB_CONNECT_INFO Procedure, 96
DB_VERSION Procedure, 172
DBFS_LINK_GENERATE_PATH Functions, 87
DBLINK_ARRAY Table Type, 172
DBMS, 189
DBMS_ NETWORK_ACL_ADMIN package, 100, 101
DBMS_ALERT package, 20
DBMS_APPLICATION_INFO package, 22
DBMS_APPLY_ADM package, 23
DBMS_AQADM Constants, 25
DBMS_AQELM package, 26
DBMS_AQIN package, 27
DBMS_AUDIT_MGMT package, 29
CLEAN_AUDIT_TRAIL procedure, 29
CLEAR_AUDIT_TRAIL_PROPERTY procedure, 29
CLEAR_LAST_ARCHIVE_TIMESTAMP procedure, 29
CREATE_PURGE_JOB procedure, 29
DEINIT_CLEANUP procedure, 29
DROP_PURGE_JOB procedure, 29
GET_AUDIT_COMMIT_DELAY function, 29
INIT_CLEANUP procedure, 29
IS_CLEANUP_INITIALIZED function, 29
SET_AUDIT_TRAIL_LOCATION procedure, 29
SET_AUDIT_TRAIL_PROPERTY procedure, 29
SET_LAST_ARCHIVE_TIMESTAMP procedure, 29
SET_PURGE_JOB_INTERVAL procedure, 29
SET_PURGE_JOB_STATUS procedure, 29
DBMS_AUTO_TASK_ADMIN package, 32
DBMS_AW_STATS package, 33
DBMS_CAPTURE package, 269
DBMS_CAPTURE_ADM package, 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, 270
DBMS_CSX_ADMIN package, 41
DBMS_CUBE package, 42
DBMS_CUBE_ADVISE package, 43
DBMS_CUBE_LOG package, 44
DBMS_DATA_MINING package, 45
ADD_COST_MATRIX procedure, 45
algorithms, 45
ALTER_REVERSE_EXPRESSION procedure, 45
APPLY procedure, 45
Automatic Data Preparation, 45
COMPUTE_CONFUSION_MATRIX procedure, 45
COMPUTE_LIFT procedure, 45
COMPUTE_ROC procedure, 45
CREATE_MODEL procedure, 45
data transformation, 45, 45, 45
datatypes, 45
DROP_MODEL procedure, 45
EXPORT_MODEL procedure, 45
GET_ASSOCIATION_RULES function, 45
GET_FREQUENT_ITEMSETS function, 45
GET_MODEL_COST_MATRIX function, 45
GET_MODEL_DETAILS_AI function, 45
GET_MODEL_DETAILS_EM function, 45
GET_MODEL_DETAILS_EM_COMP function, 45
GET_MODEL_DETAILS_EM_PROJ function, 45
GET_MODEL_DETAILS_GLM function, 45
GET_MODEL_DETAILS_GLOBAL function, 45
GET_MODEL_DETAILS_KM function, 45
GET_MODEL_DETAILS_NB function, 45
GET_MODEL_DETAILS_NMF function, 45
GET_MODEL_DETAILS_OC function, 45
GET_MODEL_DETAILS_SVM function, 45, 45
GET_MODEL_DETAILS_XML function, 45
GET_MODEL_TRANSFORMATIONS function, 45
GET_TRANSFORM_LIST procedure, 45
IMPORT_MODEL procedure, 45
overview, 45
PMML, 45
RANK_APPLY procedure, 45
REMOVE_COST_MATRIX procedure, 45
RENAME_MODEL procedure, 45
scoring, 45, 45, 45, 45, 45
security model, 45
settings
algorithm names, 45
decision tree, 45
GLM, 45
global, 45
k-Means, 45
mining functions, 45
mining models, 45
Naive Bayes, 45
NMF, 45
O-Cluster, 45
SVM, 45
subprograms, 45
transactional data, 45
DBMS_DATA_MINING_TRANSFORM
datatypes, 46
introduction, 46
package, 46
subprograms, 46
DBMS_DATAPUMP package, 47
ADD_FILE procedure, 47
ATTACH function, 47
DATA_FILTER procedure, 47
DETACH procedure, 47
GET_DUMPFILE_INFO procedure, 47
GET_STATUS procedure, 47
LOG_ENTRY procedure, 47
METADATA_FILTER procedure, 47
METADATA_REMAP procedure, 47
METADATA_TRANSFORM procedure, 47
OPEN function, 47
roles used by, 47
SET_PARALLEL procedure, 47
SET_PARAMETER procedure, 47
START_JOB procedure, 47
STOP_JOB procedure, 47
types used by, 47
WAIT_FOR_JOB procedure, 47
DBMS_DB_VERSION package, 52
DBMS_DBFS_CONTENT package, 48
DBMS_DBFS_CONTENT_LIST_ITEM_T Object Type, 270
DBMS_DBFS_CONTENT_LIST_ITEMS_T Table Type, 270
DBMS_DBFS_CONTENT_PROPERTIES_T Table Type, 270
DBMS_DBFS_CONTENT_PROPERTY_T Object Type, 270
DBMS_DBFS_CONTENT_RAW_T Table Type, 270
DBMS_DBFS_CONTENT_SPI package, 49
DBMS_DBFS_HS package, 50
DBMS_DBFS_SFS package, 51
DBMS_DDL package, 54
DBMS_DEBUG package, 53
DBMS_DEFER package documentation, 55
DBMS_DEFER_QUERY package documentation, 56
DBMS_DEFER_SYS package documentation, 57
DBMS_DESCRIBE package, 58
DBMS_DG package, 59
using, 59
DBMS_DG Package
INITIATE_FS_FAILOVER procedure, 59
DBMS_DIMENSION package, 60
DBMS_DISTRIBUTED_TRUST_ADMIN package, 63
DBMS_EDITIONS_UTILITIES package, 64, 64
DBMS_EPG package, 65, 65
DBMS_FGA package, 67
DBMS_FILE_GROUP package, 68
constants, 68
DBMS_FILE_TRANSFER package, 69
DBMS_FLASHBACK package, 70
DBMS_FREQUENT_ITEMSET package, 73
DBMS_GOLDENGATE_AUTH package, 72
DBMS_HPROF package, 76
DBMS_HS_PARALLEL package, 77
CREATE_OR_REPLACE_VIEW procedure, 77
CREATE_TABLE_TEMPLATE procedure, 77
DROP_VIEW procedure, 77
LOAD_TABLE procedure, 77
DBMS_HS_PASSTHROUGH package, 78
DBMS_IOT package, 81
DBMS_JAVA package documentation, 82
DBMS_JOB package, 83
DBMS_LDAP package documentation, 84
DBMS_LDAP_UTL package documentation, 85
DBMS_LIBCACHE package, 86
DBMS_LOB package, 87
DBMS_LOCK package, 88
DBMS_LOGMNR package, 89
ADD_LOGFILE procedure, 89
COLUMN_PRESENT function, 89
END_LOGMNR procedure, 89
MINE_VALUE function, 89
REMOVE_LOGFILE procedure, 89
START_LOGMNR procedure, 89
DBMS_LOGMNR_D package, 90
BUILD procedure, 90
SET_TABLESPACE procedure, 90
DBMS_LOGSTDBY package, 91
APPLY_SET procedure, 91
APPLY_UNSET procedure, 91
BUILD procedure, 91
INSTANTIATE_TABLE procedure, 91
MAP_PRIMARY_SCN function, 91
overview of managing SQL Apply, 91
PREPARE_FOR_NEW_PRIMARY procedure, 91
PURGE_SESSION procedure, 91
SET_TABLESPACE procedure, 91
SKIP procedure, 91
SKIP_ERROR procedure, 91
SKIP_TRANSACTION procedure, 91
UNSKIP procedure, 91
UNSKIP_ERROR procedure, 91
UNSKIP_TRANSACTION procedure, 91
using, 91
DBMS_METADATA package, 93
ADD_TRANSFORM function, 93
CLOSE procedure, 93
CONVERT functions and procedures, 93
GET_DDL function, 93
GET_QUERY function, 93
GET_XML function, 93
OPEN function, 93
OPENW function, 93
PUT function, 93
security, 93
SET_COUNT procedure, 93
SET_FILTER procedure, 93
SET_PARSE_ITEM procedure, 93
SET_REMAP_PARAM procedure, 93
SET_TRANSFORM_PARAM procedure, 93
DBMS_METADATA_DIFF package, 94, 94
ADD_DOCUMENT procedure, 94
FETCH_CLOB functions and procedures, 94
OPENC function, 94
DBMS_MGD_ID_UTL package, 95
ADD_SCHEME procedure, 95
CREATE_CATEGORY function, 95
EPC_TO_ORACLE_SCHEME function, 95
GET_CATEGORY_ID function, 95
GET_COMPONENTS function, 95
GET_ENCODINGS function, 95
GET_JAVA_LOGGING_LEVEL function, 95
GET_PLSQL_LOGGING_LEVEL function, 95
GET_SCHEMENAMES function, 95
GET_TDT_XML function, 95
GET_VALIDATOR function, 95
REFRESH_CATEGORY function, 95
REMOVE_CATEGORY procedure, 95
REMOVE_PROXY procedure, 95
REMOVE_SCHEME procedure, 95
SET_JAVA_LOGGING_LEVEL procedure, 95
SET_PLSQL_LOGGING_LEVEL procedure, 95
SET_PROXY procedure, 95
VALIDATE_SCHEME function, 95
DBMS_MGWADM package
summary of subprograms, 96
DBMS_MGWMSG package
constants, 97
summary of subprograms, 97
DBMS_MONITOR package
stastics tracing and gathering
DBMS_MONITOR package, 98
DBMS_MVIEW package
BEGIN_TABLE_REORGANIZATION procedure, 99
END_TABLE_REORGANIZATION procedure, 99
EXPLAIN_MVIEW procedure, 99
EXPLAIN_REWRITE procedure, 99
I_AM_A_REFRESH function, 99
PMARKER function, 99
PURGE_DIRECT_LOAD_LOG procedure, 99
PURGE_LOG procedure, 99
PURGE_MVIEW_FROM_LOG procedure, 99
REFRESH procedure, 99
REFRESH_ALL_MVIEWS procedure, 99
REFRESH_DEPENDENT procedure, 99
REGISTER_MVIEW procedure, 99
UNREGISTER_MVIEW procedure, 99
DBMS_ODCI package, 102
ESTIMATE_CPU_UNITS function, 102
methods, 102
DBMS_OFFLINE_OG package documentation, 103
DBMS_OUTLN package, 104
DBMS_OUTPUT package, 105
DBMS_PARALLEL_EXECUTE package, 106
DBMS_PCLXUTIL package, 108
DBMS_PIPE package, 110
DBMS_PREDICTIVE_ANALYTICS package, 111
EXPLAIN procedure, 111
PREDICT procedure, 111
PROFILE Procedure, 111
DBMS_PREPROCESSOR package, 112
DBMS_PROFILER package, 114
DBMS_PROPAGATION_ADM package, 115
DBMS_RANDOM package, 117
DBMS_RECTIFIER_DIFF package documentation, 118
DBMS_REDEFINITION package, 120
DBMS_REFRESH package documentation, 121
DBMS_REPAIR package, 122
DBMS_REPCAT package documentation, 123
DBMS_REPCAT_ADMIN package documentation, 124
DBMS_REPCAT_INSTANTIATE package documentation, 125
DBMS_REPCAT_RGT package documentation, 126
DBMS_REPUTIL package documentation, 127
DBMS_RESCONFIG package, 128
DBMS_RESOURCE_MANAGER package, 129
DBMS_RESOURCE_MANAGER_PRIVS package, 130
DBMS_RESULT_CACHE package, 131
DBMS_RESUMABLE package, 132
DBMS_RLS package, 133
DBMS_RLS.ADD_POLICY policy types
CONTEXT_SENSITIVE, 133
DYNAMIC, 133
SHARED_CONTEXT_SENSITIVE, 133
SHARED_STATIC, 133
STATIC, 133
DBMS_RLS.ENABLE_GROUPED_POLICY parameters
enable, 133
group_name, 133
object_name, 133
object_schema, 133
policy_name, 133
DBMS_RLS.REFRESH_POLICY parameters
object_name, 133
object_schema, 133
policy_name, 133
DBMS_ROWID package, 135
DBMS_RULE package, 136
DBMS_RULE_ADM package, 137
DBMS_SCHEDULER package, 138
ADD_EVENT_QUEUE_SUBSCRIBER Procedure, 138
ADD_GROUP_MEMBER Procedure, 138
ADD_JOB_EMAIL_NOTIFICATION Procedure, 138
ALTER_CHAIN Procedure, 138
ALTER_RUNNING_CHAIN Procedure, 138
CLOSE_WINDOW Procedure, 138
COPY_JOB Procedure, 138
CREATE_CHAIN Procedure, 138
CREATE_CREDENTIAL Procedure, 138
CREATE_DATABASE_DESTINATION Procedure, 138
CREATE_EVENT_SCHEDULE Procedure, 138
CREATE_FILE_WATCHER Procedure, 138
CREATE_GROUP Procedure, 138
CREATE_JOB Procedure, 138
CREATE_JOB_CLASS Procedure, 138
CREATE_JOBS Procedure, 138
CREATE_PROGRAM Procedure, 138
CREATE_SCHEDULE Procedure, 138
CREATE_WINDOW Procedure, 138
DEFINE_ANYDATA_ARGUMENT Procedure, 138
DEFINE_CHAIN_EVENT_STEP Procedure, 138
DEFINE_CHAIN_RULE Procedure, 138
DEFINE_CHAIN_STEP Procedure, 138
DEFINE_METADATA_ARGUMENT Procedure, 138
DEFINE_PROGRAM_ARGUMENT Procedure, 138
DISABLE Procedur, 138
DROP_AGENT_DESTINATION Procedure, 138
DROP_CHAIN Procedure, 138
DROP_CHAIN_RULE Procedure, 138
DROP_CHAIN_STEP Procedure, 138
DROP_CREDENTIAL Procedure, 138
DROP_DATABASE_DESTINATION Procedure, 138
DROP_FILE_WATCHER Procedure, 138
DROP_GROUP Procedure, 138
DROP_JOB Procedure, 138
DROP_JOB_CLASS Procedure, 138
DROP_PROGRAM Procedure, 138
DROP_PROGRAM_ARGUMENT Procedure, 138
DROP_SCHEDULE Procedure, 138
DROP_WINDOW Procedure, 138
ENABLE Procedure, 138
END_DETACHED_JOB_RUN Procedure, 138
EVALUATE_CALENDAR_STRING Procedure, 138
EVALUATE_RUNNING_CHAIN Procedure, 138
GENERATE_JOB_NAME Function, 138
GET_AGENT_INFO Function, 138
GET_AGENT_VERSION Function, 138
GET_ATTRIBUTE Procedure, 138
GET_FILE Procedure, 138
GET_SCHEDULER_ATTRIBUTE Procedure, 138
JOB DEFINITION constructor function, 138
JOB DEFINITION object type, 138
JOB_DEFINTION_ARRAY table type, 138
JOBARG constructor function, 138
JOBARG object type, 138
JOBARG_ARRAY table type, 138
JOBATTR constructor function, 138
JOBATTR object type, 138
JOBATTR_ARRAY table type, 138
OPEN_WINDOW Procedure, 138
PURGE_LOG Procedure, 138
PUT_FILE Procedure, 138
REMOVE_EVENT_QUEUE_SUBSCRIBER Procedure, 138
REMOVE_GROUP_MEMBER Procedure, 138
REMOVE_JOB_EMAIL_NOTIFICATION Procedure, 138
RESET_JOB_ARGUMENT_VALUE Procedure, 138
RUN_CHAIN Procedure, 138
RUN_JOB Procedure, 138
Scheduler Chain Condition Syntax, 138
SCHEDULER$_EVENT_INFO Object Type, 138
SCHEDULER$_STEP_TYPE object type, 138
SCHEDULER$_STEP_TYPE_LIST table type, 138
SCHEDULER_FILEWATCHER_REQUEST Object Type, 138
SCHEDULER_FILEWATCHER_RESULT Object Type, 138
SET_AGENT_REGISTRATION_PASS Procedure, 138
SET_ATTRIBUTE Procedure, 138
SET_ATTRIBUTE_NULL Procedure, 138, 138
SET_JOB_ANYDATA_VALUE Procedure, 138
SET_JOB_ARGUMENT_VALUE Procedure, 138, 138
SET_JOB_ATTRIBUTES Procedure, 138
SET_RESOURCE_CONSTRAINT Procedure, 138
SET_SCHEDULER_ATTRIBUTE Procedure, 138
STOP_JOB Procedure, 138
DBMS_SERVER_ALERT package, 139
DBMS_SERVICE package, 140
DBMS_SESSION package, 141
DBMS_SHARED_POOL package, 142
DBMS_SPACE package, 143
DBMS_SPACE_ADMIN package, 144
DBMS_SPM package, 146
DBMS_SQL package, 147
DBMS_SQLDIAG package, 150
DBMS_SQLTUNE package, 30, 30, 151, 152, 152
DBMS_STAT_FUNCS package, 154
DBMS_STATS package, 153
DBMS_STORAGE_MAP package, 155
DBMS_STREAMS package, 156
DBMS_STREAMS_ADM package, 157
apply user, 157
deprecated subprograms, 157
inbound server rules, 157
inbound servers, 157
outbound server rules, 157
DBMS_STREAMS_ADVISOR_ADM package, 158
constants, 158
operational notes, 158
subprograms, 158
using, 158
views, 158
DBMS_STREAMS_AUTH package, 159, 203
DBMS_STREAMS_HANDLER_ADM package, 160
DBMS_STREAMS_MESSAGING package, 161
DBMS_STREAMS_TABLESPACE package, 162
DBMS_TDB package, 164
DBMS_TDB.CHECK_DB Function, 164
DBMS_TDB.CHECK_DB procedure, 164
DBMS_TRACE package, 165
DBMS_TRANSACTION package, 166
DBMS_TRANSFORM package, 167
DBMS_TTS package, 170
DBMS_TYPES package, 171
DBMS_UTILITY package, 172
DBMS_WARNING package, 173
DBMS_WM package documentation, 174
DBMS_WORKLOAD_RECORD package, 175
DBMS_WORKLOAD_REPLAY package, 176
DBMS_WORKLOAD_REPOSITORY package, 177
DBMS_XA_XID Object Type, 178
DBMS_XA_XID_ARRAY Table Type, 178
DBMS_XBD_VERSION package, 184
DBMS_XDB Constants, 179
DBMS_XDB Overview, 179
DBMS_XDB package, 179
CONFIGUREAUTOSYNC procedure, 186
constants, 179
ConText synchronization settings, 186
CREATEDATASTOREPREF procedure, 186
CREATEFILTERPREF procedure, 186
CREATEINDEX procedure, 186
CREATELEXERPREF procedure, 186
CREATEPREFERENCES procedure, 186
CREATESECTIONGROUPPREF procedure, 186
CREATESTOPLISTPREF procedure, 186
CREATESTORAGEPREF procedure, 186
CREATEWORLDLISTPREF procedure, 186
DROPPREFERENCES procedure, 186
filtering settings, 186
general indexing settings, 186
methods, 179, 186
miscellaneous settings, 186
other index preference settings, 186
sectioning and section group settings, 186
stoplist settings, 186
SYNC settings, 186
DBMS_XDB_ADMIN package, 180
DBMS_XDB_VERSION package
CHECKIN function, 184
CHECKOUT procedure, 184
GETCONTENTSBLOBBYRESID function, 184
GETCONTENTSCLOBBYRESID function, 184
GETCONTENTSXMLBYRESID function, 184
GETPREDECESSORS function, 184
GETPREDSBYRESID function, 184
GETRESOURCEBYRESID function, 184
GETSUCCESSORS function, 184
GETSUCCSBYRESID function, 184
MAKEVERSIONED function, 184
UNCHECKOUT function, 184
DBMS_XDBRESOURCE package, 185
DBMS_XDBZ package
DISABLE_HIERARCHY procedure, 187
ENABLE_HIERARCHY procedure, 187
GET_ACLOID function, 187
GET_USERID function, 187
IS_HIERARCHY_ENABLED function, 187
PURGELDAPCACHE function, 187
DBMS_XMLDOM Constants, 189
DBMS_XMLDOM package, 189
APPENDDATA procedure, 189
CREATEATTRIBUTE function, 189
CREATECDATASECTION function, 189
CREATECOMMENT function, 189
CREATEDOCUMENT function, 189
CREATEDOCUMENTFRAGMENT, 189
CREATEELEMENT function, 189
CREATEENTITYREFERENCE function, 189
CREATEPROCESSINGINSTRUCTION function, 189
CREATETEXTNODE function, 189
DELETEDATA procedure, 189
description, 189
exceptions, 189
FINDENTITY function, 189
FINDNOTATION function, 189
FREEDOCFRAG procedure, 189
FREEDOCUMENT procedure, 189
GETATTRIBUTE function, 189
GETATTRIBUTENODE function, 189
GETBUBLICID function, 189
GETCHARSET function, 189
GETCHILDRENBYTAGNAME function, 189
GETDATA function, 189
GETDOCTYPE function, 189
GETDOCUMENTELEMENT function, 189
GETELEMENTSBYTAGNAME function, 189, 189
GETENTITIES function, 189
GETEXPANDEDNAME function, 189, 189
GETIMPLEMENTATION function, 189
GETLENGTH function, 189, 189, 189
GETNAME function, 189, 189
GETNAMEDITEM function, 189
GETNAMESPACE function, 189, 189
GETNAMESPACE procedure, 189
GETNEXTSIBLING function, 189
GETNODENAME function, 189
GETNODETYPE function, 189
GETNODEVALUE function, 189
GETNOTATIONNAME function, 189
GETNOTATIONS function, 189
GETOWNERDOCUMENT function, 189
GETOWNERELEMENT function, 189
GETPARENTNODE function, 189
GETPREFIX function, 189
GETPREVIOUSSIBLING function, 189
GETPUBLICID function, 189, 189
GETQUALIFIEDNAME function, 189, 189
GETSCHEMANODE function, 189
GETSPECIFIED function, 189
GETSTANDALONE function, 189
GETSYSTEMID function, 189, 189, 189
GETTAGNAME function, 189
GETTARGET function, 189
GETVALUE function, 189
GETVERSION function, 189
GETXMLTYPE function, 189
HASATTRIBUTE function, 189
HASATTRIBUTES function, 189
HASCHILDNODES function, 189
HASFEATURE function, 189
IMPORTNODE function, 189
INSERTBEFORE function, 189
INSERTDATA procedure, 189
ISNULL function, 189
MAKEATTR function, 189
MAKECDATASECTION function, 189
MAKECHARACTERDATA function, 189
MAKECOMMENT function, 189
MAKEDOCUMENT function, 189
MAKEDOCUMENTFRAGMENT function, 189
MAKEDOCUMENTTYPE function, 189
MAKEELEMENT function, 189
MAKEENTITY function, 189
MAKEENTITYREFERENCE function, 189
MAKENODE function, 189, 189, 189, 189
MAKENOTATION function, 189
MAKEPROCESSINGINSTRUCTION function, 189
MAKETEXT function, 189
methods
APPENDCHILD function, 189
APPENDDATA procedure, 189
CLONENODE function, 189
CREATEATTRIBUTE function, 189
CREATECDATASECTION function, 189
CREATECOMMENT function, 189
CREATEDOCUMENT function, 189
CREATEDOCUMENTFRAGMENT function, 189
CREATEELEMENT function, 189
CREATEENTITYREFERENCE function, 189
CREATEPROCESSINGINSTRUCTION function, 189
CREATETEXTNODE function, 189
DELETEDATA procedure, 189
DOMAttr interface, 189
DOMCDataSection interface, 189
DOMCharacterData interface, 189
DOMComment interface, 189
DOMDocument interface, 189
DOMDocumentFragment interface, 189, 189
DOMDocumentType interface, 189, 189
DOMElement interface, 189, 189
DOMEntity interface, 189, 189
DOMEntityReference interface, 189
DOMImplementation interface, 189
DOMNamedNodeMap interface, 189
DOMNodeAPPENDCHILD function, 189
DOMNodeCLONENODE function, 189
DOMNodeGETATTRIBUTES function, 189
DOMNodeGETCHILDNODES function, 189
DOMNodeGETEXPANDEDNAME procedure, 189
DOMNodeGETFIRSTCHILD function, 189
DOMNodeGETLASTCHILD function, 189
DOMNodeGETLOCALNAME procedure, 189
DOMNodeList interface, 189
DOMNotation interface, 189
DOMProcessingInstruction interface, 189
DOMText interface, 189, 189
FINDENTITY function, 189
FINDNOTATION function, 189
FREEDOCFRAG procedure, 189
FREEDOCUMENT procedure, 189
FREEELEMENT procedure, 189
FREENODE procedure, 189, 189, 189
FREENODELIST Procedure, 189
GETATTRIBUTE function, 189
GETATTRIBUTENODE function, 189
GETATTRIBUTES function, 189
GETBUBLICID function, 189
GETCHARSET function, 189
GETCHILDNODES function, 189
GETCHILDRENBYTAGNAME function, 189
GETDATA function, 189
GETDOCTYPE function, 189
GETDOCUMENTELEMENT function, 189
GETELEMENTSBYTAGNAME function, 189, 189
GETENTITIES function, 189
GETEXPANDEDNAME function, 189, 189
GETEXPANDEDNAME procedure, 189
GETFIRSTCHILD function, 189
GETIMPLEMENTATION function, 189
GETLASTCHILD function, 189
GETLENGTH function, 189, 189, 189
GETLOCALNAME procedure, 189
GETNAME function, 189, 189
GETNAMEDITEM function, 189
GETNAMESPACE function, 189, 189
GETNAMESPACE procedure, 189
GETNEXTSIBLING function, 189
GETNODENAME function, 189
GETNODETYPE function, 189
GETNODEVALUE function, 189
GETNOTATIONNAME function, 189
GETNOTATIONS function, 189
GETOWNERDOCUMENT function, 189
GETOWNERELEMENT function, 189
GETPARENTNODE function, 189
GETPREFIX function, 189
GETPREVIOUSSIBLING function, 189
GETPUBLICID function, 189, 189
GETQUALIFIEDNAME function, 189, 189
GETSCHEMANODE function, 189
GETSPECIFIED function, 189
GETSTANDALONE function, 189
GETSYSTEMID function, 189, 189, 189
GETTAGNAME function, 189
GETTARGET function, 189
GETVALUE function, 189
GETVERSION function, 189
GETXMLTYPE function, 189
HASATTRIBUTE function, 189
HASATTRIBUTES function, 189
HASCHILDNODES function, 189
HASFEATURE function, 189
IMPORTNODE function, 189
INSERTBEFORE function, 189
INSERTDATA procedure, 189
ISNULL function, 189
MAKEATTR function, 189
MAKECDATASECTION function, 189
MAKECHARACTERDATA function, 189
MAKECOMMENT function, 189
MAKEDOCUMENT function, 189
MAKEDOCUMENTFRAGMENT function, 189
MAKEDOCUMENTTYPE function, 189
MAKEELEMENT function, 189
MAKEENTITY function, 189
MAKEENTITYREFERENCE function, 189
MAKENODE function, 189, 189, 189, 189
MAKENOTATION function, 189
MAKEPROCESSINGINSTRUCTION function, 189
MAKETEXT function, 189
NEWDOMDOCUMENT function, 189
NORMALIZE procedure, 189
REMOVEATTRIBUTE procedure, 189
REMOVEATTRIBUTENODE function, 189
REMOVENAMEDITEM function, 189
REPLACECHILD function, 189
REPLACEDATA procedure, 189
RESOLVENAMESPACEPREFIX function, 189
SETATTRIBUTE procedure, 189
SETATTRIBUTENODE function, 189
SETCHARSET procedure, 189
SETDATA procedure, 189
SETNAMEDITEM function, 189
SETNODEVALUE procedure, 189
SETPREFIX procedure, 189
SETSTANDALONE procedure, 189
SETVALUE procedure, 189
SETVERSION procedure, 189
SPLITTEXT function, 189
SUBSTRINGDATA function, 189
WRITETOBUFFER procedure, 189
WRITETOCLOB procedure, 189
WRITETOFILE procedure, 189
NEWDOMDOCUMENT function, 189
NORMALIZE procedure, 189
REMOVEATTRIBUTE procedure, 189
REMOVEATTRIBUTENODE function, 189
REMOVENAMEDITEM function, 189
REPLACECHILD function, 189
REPLACEDATA procedure, 189
RESOLVENAMESPACEPREFIX function, 189
SETATTRIBUTE procedure, 189
SETATTRIBUTENODE function, 189
SETCHARSET procedure, 189
SETDATA procedure, 189
SETNAMEDITEM function, 189
SETNODEVALUE procedure, 189
SETPREFIX procedure, 189
SETSTANDALONE procedure, 189
SETVALUE procedure, 189
SETVERSION procedure, 189
SPLITTEXT function, 189
SUBSTRINGDATA function, 189
types, 70, 189
WRITETOBUFFER procedure, 189
WRITETOCLOB procedure, 189
WRITETOFILE procedure, 189
DBMS_XMLGEN package, 190
CLOSECONTEXT procedure, 190
CONVERT function, 190
GETNUMROWSPROCESSED Function, 190
GETXML function, 190
GETXMLTYPE function, 190
NEWCONTEXT function, 190
RESTARTQUERY procedure, 190
SETCONVERTSPECIALCHARS procedure, 190
SETMAXROWS procedure, 190
SETROWSETTAG procedure, 190
SETROWTAG procedure, 190
SETSKIPROWS procedure, 190
USEITEMTAGSFORCOLL procedure, 190
USENULLATTRIBUTEINDICATOR procedure, 190
DBMS_XMLINDEX package, 191
DBMS_XMLPARSER package, 192
FREEPARSER procedure, 192
GETDOCTYPE function, 192
GETDOCUMENT function, 192
GETRELEASEVERSION function, 192
GETVALIDATIONMODE function, 192
NEWPARSER function, 192
PARSE function, 192, 192
PARSE procedure, 192
PARSEBUFFER procedure, 192
PARSECLOB procedure, 192
PARSEDTD procedure, 192
PARSEDTDBUFFER procedure, 192
PARSEDTDCLOB procedure, 192
SETBASEDIR procedure, 192
SETDOCTYPE procedure, 192
SETERRORLOG procedure, 192
SETPRESERVEWHITESPACE procedure, 192
SETVALIDATIONMODE procedure, 192
SHOWWARNINGS procedure, 192
DBMS_XMLQUERY package, 193
CLOSECONTEXT procedure, 193
constants, 193
GETDTD function, 193
GETDTD procedure, 193
GETEXCEPTIONCONTENT procedure, 193
GETNUMROWSPROCESSED procedure, 193
GETVERSION procedure, 193
GETXML function, 193
GETXML procedure, 193
NEWCONTEXT function, 193
PROPAGATEORIGINALEXCEPTION procedure, 193
REMOVEXSLTPARAM procedure, 193
SETBINDVALUE procedure, 193
SETCOLLIDATTRNAME procedure, 193
SETDATAHEADER procedure, 193
SETDATEFORMAT procedure, 193
SETENCODINGTAG procedure, 193
SETERRORTAG procedure, 193
SETMAXROWS procedure, 193
SETMETAHEADER procedure, 193
SETRAISEEXCEPTION procedure, 193
SETRAISENOROWSEXCEPTION procedure, 193
SETROWIDATTRNAME procedure, 193
SETROWIDATTRVALUE procedure, 193
SETROWSETTAG procedure, 193
SETROWTAG procedure, 193
SETSKIPROWS procedure, 193
SETSQLTOXMLNAMEESCAPING procedure, 193
SETSTYLESHEETHEADER procedure, 193
SETTAGCASE procedure, 193
SETXSLT procedure, 193
SETXSLTPARAM procedure, 193
types, 193
USENULLATTRIBUTEINDICATOR procedure, 193
USETYPEFORCOLLELEMTAG procedure, 193
DBMS_XMLSAVE package, 194
CLEARKEYCOLUMNLIST procedure, 194
CLEARUPDATECOLUMNLIST procedure, 194
CLOSECONTEXT procedure, 194
constants, 194
DELETEXML function, 194
GETEXCEPTIONCONTENT procedure, 194
INSERTXML function, 194
NEWCONTEXT function, 194
PROPAGATEORIGINALEXCEPTION procedure, 194
REMOVEXSLTPARAM procedure, 194
SETBATCHSIZE procedure, 194
SETCOMMITBATCH procedure, 194
SETDATEFORMAT procedure, 194
SETIGNORECASE procedure, 194
SETKEYCOLUMN procedure, 194
SETPRESERVEWHITESPACE procedure, 194
SETROWTAG procedure, 194
SETSQLTOXMLNAMEESCAPING procedure, 194
SETUPDATECOLUMN procedure, 194
SETXSLT procedure, 194
SETXSLTPARAM procedure, 194
UPDATEXML function, 194
DBMS_XMLSCHEMA Constants, 195
DBMS_XMLSCHEMA Operational Notes, 195
DBMS_XMLSCHEMA package, 195
DBMS_XMLSCHEMA Views, 195
DBMS_XMLSTORE package, 198
CLEARKEYCOLUMNLIST procedure, 198
CLEARUPDATECOLUMNLIST procedure, 198
CLOSECONTEXT procedure, 198
DELETEXML function, 198
INSERTXML function, 198
NEWCONTEXT function, 198
SETKEYCOLUMN procedure, 198
SETROWTAG procedure, 198
SETUPDATECOLUMN procedure, 198
types, 198
UPDATEXML function, 198
DBMS_XMLTRANSLATIONS package, 199
DBMS_XPLAN package, 200
DBMS_XSLPROCESSOR package
CLOB2FILE procedure, 201
FREEPROCESSOR procedure, 201
FREESTYLESHEET procedure, 201
NEWPROCESSOR function, 201
NEWSTYLESHEET function, 201
PROCESSXSL function, 201
READ2CLOB function, 201
REMOVEPARAM procedure, 201
RESETPARAMS procedure, 201
SELECTNODES function, 201
SELECTSINGLENODE function, 201
SETERRORLOG procedure, 201
SETPARAM procedure, 201
SHOWWARNINGS procedure, 201
TRANSFORMNODE function, 201
VALUEOF procedure, 201
DBMS_XSLPROCESSOR Package, 201, 201
DBMS_XSTREAM_ADM package, 202
security, 202
DBMSOUTPUT_LINESARRAY Object Type, 105
DBUriType, 271
DBURITYPE function, 271
DBUriType subtype, 271
CREATEURI function, 271
DBURITYPE function, 271
GETBLOB function, 271
GETCLOB function, 271
GETCONTENTTYPE function, 271
GETEXTERNALURL function, 271
GETURL function, 271
GETXML function, 271
methods, 271
DEAUTHORIZE_DAD Procedure, 65
DEBUG_EXPTOC package, 204
DEBUG_ON procedure, 53
DECLARE_REWRITE_EQUIVALENCE Procedures, 18
DECODEFEATURES Function, 48
DEFAULT_NAME function, 44
DEFINE_ARRAY procedure, 147
DEFINE_COLUMN procedure, 147
DEFINE_COLUMN_CHAR Procedure, 147
DEFINE_COLUMN_LONG procedure, 147
DEFINE_COLUMN_RAW Procedure, 147
DEFINE_COLUMN_ROWID Procedure, 147
DEINIT_CLEANUP procedure, 29
DELETE Procedure, 17
DELETE_ALL_ERRORS procedure, 23
DELETE_BREAKPOINT function, 53
DELETE_CAPTURE_INFO Procedure, 175
DELETE_CATEGORY Procedure, 129
DELETE_CDB_PLAN Procedure, 129
DELETE_CDB_PLAN_DIRECTIVE Procedure, 129
DELETE_COLUMN member procedure, 273
DELETE_COLUMN procedure, 157, 202
DELETE_COLUMN_STATS pocedure, 153
DELETE_CONSUMER_GROUP procedure, 129
DELETE_DAD_ATTRIBUTE Procedure, 65, 65
DELETE_DATABASE_PREFS Procedure, 153
DELETE_DATABASE_STATS procedure, 153
DELETE_DICTIONARY_STATS procedure, 153
DELETE_ERROR procedure, 23
DELETE_FILTER Procedure, 175, 176
DELETE_FINDING_DIRECTIVE Procedure, 17
DELETE_FIXED_OBJECTS_STATS procedure, 153
DELETE_INDEX_STATS procedure, 153
DELETE_OBJECT procedure, 260
DELETE_OER_BREAKPOINT function, 53
DELETE_PARAMETER_DIRECTIVE Procedure, 17
DELETE_PENDING_STATS Procedure, 153
DELETE_PLAN procedure, 129
DELETE_PLAN_CASCADE procedure, 129
DELETE_PLAN_DIRECTIVE procedure, 129
DELETE_POLICY_GROUP Procedure, 133
DELETE_PRIVILEGE Procedure, 100
DELETE_PROCESSING_RATE Procedure, 153
DELETE_REPLAY_INFO Procedure, 176
DELETE_SCHEMA_PREFS Procedure, 153
DELETE_SCHEMA_STATS Procedure, 153
DELETE_SEGMENT_DIRECTIVE Procedure, 17
DELETE_SERVICE procedure, 140
DELETE_SQL_DIRECTIVE Procedure, 17
DELETE_SQLSET procedure, 152
DELETE_SQLWKLD Procedure, 19
DELETE_SQLWKLD_REF Procedure, 19
DELETE_SQLWKLD_STATEMENT Procedure, 19
DELETE_SYSTEM_STATS procedure, 153
DELETE_TABLE_PREFS Procedure, 153
DELETE_TABLE_STATS procedure, 153
DELETE_TASK Procedure, 19
DELETECONTENT Procedure, 48, 49
DELETEDATA procedure, 189
DELETEDIRECTORY Procedure, 48, 49
DELETEFILE Procedure, 48, 49
DELETEHTTPEXPIREMAPPING Procedure, 181
DELETEMIMEMAPPING Procedure, 181
DELETEREPOSITORYRESCONFIG Procedure, 128
DELETERESCONFIG Procedure, 128
DELETERESOURCE Procedure, 183
DELETERESOURCEMETADATA Procedures, 183
DELETESCHEMA procedure, 195
DELETESCHEMALOCMAPPING Procedure, 181
DELETESERVLET Procedure, 181
DELETESERVLETMAPPING Procedure, 181
DELETESERVLETSECROLE Procedure, 181
DELETEXML function, 194, 198
DELETEXMLEXTENSION Procedure, 181
DEQUEUE procedure, 161
DEQUEUE_ARRAY Function, 24
DEQUEUE_OPTIONS_T Type, 269
DEREGISTER Procedure, 38
DEREGISTER_ERROR_TRANSLATION Procedure, 148
DEREGISTER_SQL_TRANSLATION Procedure, 148
DEREGSTORECOMMAND Function, 50
DERIVE_FROM_MVIEW function, 42
DESC_REC2 Record Type, 147
DESC_REC3 Record Type, 147
DESC_RESC Record Type, 147
DESC_TAB Table Type, 147
DESC_TAB2 Table Type, 147
DESC_TAB3 Table Type, 147
DESCRIBE Procedure, 109
DESCRIBE_COLUMNS procedure, 147
DESCRIBE_COLUMNS2 procedure, 147
DESCRIBE_COLUMNS3 Procedure, 147
DESCRIBE_DIMENSION procedure, 60
DESCRIBE_PROCEDURE procedure, 58
DESCRIBE_STACK procedure, 46
DESTROY_REQUEST_CONTEXT Procedure, 250, 250
DETACH_SESSION procedure, 53
DETACH_SIMPLE_TABLESPACE procedure, 162
DETACH_TABLESPACES procedure, 162
DFN function
of HTF package, 205
DFN procedure
of HTP package, 206
DIFF_PLAN Function, 200
DIFF_TABLE_STATS_IN_HISTORY Function, 153
DIFF_TABLE_STATS_IN_PENDING Function, 153
DIFF_TABLE_STATS_IN_STATTAB Function, 153
dimension maintenance (cube), 42
dimensions
optimizer statistics, 33
DIRECTORY_OBJECT_SET type, 162
DIRLISTCLOSE function
of HTF package, 205
DIRLISTCLOSE procedure
of HTP package, 206
DIRLISTOPEN function
of HTF package, 205
DIRLISTOPEN procedure
of HTP package, 206
DISABLE procedure, 44
of DBMS_FLASHBACK package, 70
of DBMS_OUTPUT package, 105
of OWA_CACHE package, 209
DISABLE Procedures, 32
DISABLE_APPLICATION Procedure, 71
DISABLE_ASOF_VALID_TIME Procedure, 71
DISABLE_BREAKPOINT function, 53
DISABLE_CAPTURE Procedure, 113
DISABLE_CREDENTIAL Procedure, 39
DISABLE_GROUPED_POLICY Procedure, 133
DISABLE_HIERARCHY procedure, 187
DISABLE_ILM Procedure, 80
DISABLE_JOB Procedure, 96
DISABLE_POLICY Procedure, 119
DISABLE_PROPAGATION_SCHEDULE Procedure, 96
DISABLE_PROTECTION_COLUMN Procedure, 169
DISABLE_PROTECTION_SOURCE Procedure, 169
DISABLE_PROTECTION_TYPE Procedure, 169
DISABLEDEFAULTTABLECREATION Procedure, 196
DISABLEINDEXESANDCONSTRAINTS Procedure, 197
DISABLEMAINTAINDOM Procedure, 196
DISABLETRANSLATION Procedure, 199
DISASSOCIATE_FBA Procedure, 71
DISCONNECT_SESSION procedure, 140
DISPLAY function, 200
DISPLAY_AWR function, 200
DISPLAY_CURSOR function, 200
DISPLAY_PLAN Function, 200
DISPLAY_SQL_PLAN_BASELINE Function, 200
DISPLAY_SQLSET Function, 200
DIST_TXN_SYNC Procedure, 178
DIV function
of HTF package, 205
DIV procedure
of HTP package, 206
DLISTCLOSE function
of HTF package, 205
DLISTCLOSE procedure
of HTP package, 206
DLISTDEF function
of HTF package, 205
DLISTDEF procedure
of HTP package, 206
DLISTOPEN function
of HTF package, 205
DLISTOPEN procedure
of HTP package, 206
DLISTTERM function
of HTF package, 205
DLISTTERM procedure
of HTP package, 206
DOMAIN_LEVEL Function, 101
DOMAINS Function, 101
DOMAttr methods, 189
DOMCDataSection methods, 189
DOMCharacterData methods, 189
DOMComment methods, 189
DOMDocument methods, 189
DOMDocumentType methods, 189, 189
DOMEntity methods, 189
DOMNamedNodeMap methods, 189
DOMText methods, 189
DOWNGRADE procedure, 170
DOWNLOAD_FILE procedures, 265
DROFILESYSTEM Procedures, 51
DROP_ACL Procedure, 100
DROP_ALL function, 155
DROP_ANALYSIS_TASK Procedure, 151
DROP_APPLICATION Procedure, 71
DROP_APPLY procedure, 23
DROP_BASELINE procedure, 177
DROP_BY_CAT procedure, 104
DROP_CAPTURE procedure
capture process
dropping, 34
DROP_CAPTURE Procedure, 113
DROP_CHUNKS Procedure, 106
DROP_COMPARISON Procedure, 35
DROP_CREDENTIAL Procedure, 39
DROP_DAD Procedure, 65
DROP_DIAGNOSIS_TASK Procedure, 150
DROP_EMPTY_SEGMENTS Procedure, 144
DROP_EVALUATION_CONTEXT procedure, 137
DROP_EVOLVE_TASK Procedure, 146
DROP_EXTENDED_STATS Procedure, 153
DROP_FILE function, 155
DROP_FILE_GROUP procedure, 68
DROP_GROUPED_POLICY Procedure, 133
DROP_INBOUND procedure, 202
DROP_MVIEW procedure, 42, 42
DROP_OBJECT_DEPENDENCY procedure, 23
DROP_OUTBOUND procedure, 202
DROP_POLICY Procedure, 119, 133, 169
DROP_POLICY_CONTEXT Procedure, 133
DROP_PROFILE Procedure, 148
DROP_PROPAGATION procedure, 115
DROP_PURGE_JOB procedure, 29
DROP_REWRITE_EQUIVALENCE Procedure, 18
DROP_RULE procedure, 137
DROP_RULE_SET procedure, 137
DROP_SENSITIVE_COLUMN Procedure, 168
DROP_SENSITIVE_TYPE Procedure, 168
DROP_SENSITIVE_TYPE_SOURCE Procedure, 168
DROP_SNAPSHOT_RANGE procedure, 177
DROP_SQL_PATCH Function & Procedure, 150
DROP_SQL_PLAN_BASELINE, 146
DROP_SQL_PLAN_DIRECTIVE Procedure, 145
DROP_SQL_PROFILE procedure, 152
DROP_SQLSET procedure, 152
DROP_STAT_TABLE procedure, 153
DROP_STMT_HANDLER procedure, 160
DROP_TASK Procedure, 106
DROP_TRANSFORMATION procedure, 167
DROP_TUNING_TASK procedure, 152
DROP_UNUSED procedure, 104
DROP_VERSION procedure, 68
DROP_VIEW procedure
of DBMS_HS_PARALLEL package, 77
DROPPARAMETER Procedure, 191
DROPPREFERENCES procedure, 186
DROPREPOSITORYXMLINDEX Procedure, 180
DROPSTORE Procedure, 50
DUMP_ORPHAN_KEYS procedure, 122
dynamic SQL
anonymous blocks and, 147
DBMS_SQL functions, using, 147
execution flow in, 147
DYNAMIC_DEPTH Function, 245

E

EDIT_DISTANCE Function, 256
EDIT_DISTANCE_SIMILARITY Function, 256
EHLO function and procedure, 261
EM function
of HTF package, 205
EM procedure
of HTP package, 206
e-mail from PL/SQL (email), 263
EMPHASIS function
of HTF package, 205
EMPHASIS procedure
of HTP package, 206
ENABLE procedure, 44, 105
ENABLE Procedures, 32
ENABLE_APPLICATION Procedure, 71
ENABLE_AT_SYSTEM_CHANGE_NUMBER procedure, 70
ENABLE_AT_TIME procedure, 70
ENABLE_AT_VALID_TIME Procedure, 71
ENABLE_BREAKPOINT function, 53
ENABLE_CAPTURE Procedure, 113
ENABLE_CREDENTIAL Procedure, 39
ENABLE_ERROR_TRANSLATION Procedure, 148
ENABLE_GG_XSTREAM_FOR_STREAMS procedure, 202
ENABLE_GROUPED_POLICY Procedure, 133
ENABLE_HIERARCHY procedure, 187
ENABLE_ILM Procedure, 80
ENABLE_JOB Procedure, 96
ENABLE_POLICY Procedure, 119, 133
ENABLE_PROPAGATION_SCHEDULE Procedure, 96
ENABLE_PROTECTION_COLUMN Procedure, 169
ENABLE_PROTECTION_SOURCE Procedure, 169
ENABLE_PROTECTION_TYPE Procedure, 169
ENABLE_SQL_TRANSLATION Procedure, 148
ENABLEDEFAULTTABLECREATION Procedure, 196
ENABLEDIGESTAUTHENTICATION Procedure, 181
ENABLEINDEXESANDCONSTRAINTS Procedure, 197
ENABLEMAINTAINDOM Procedure, 196
ENABLETRANSLATION Procedure, 199
ENCODING_DEFAULT Function, 182
ENCODING_ISOLATIN1 Function, 182
ENCODING_UTF8 Function, 182
ENCODING_WIN1252 Function, 182
END_OPERATION Procedure, 98, 149
END_PREPARE Procedure, 62
END_REPLAY_SCHEDULE Procedure, 176
END_REQUEST procedure, 250
END_RESPONSE procedure, 250
END_SQL_BLOCK Procedure, 129
END_UPGRADE Procedure, 62
ENDCREATE member procedure
of ANYDATA TYPE, 266
of ANYDATASET TYPE, 267
of ANYTYPE TYPE, 268
ENQUEUE procedure, 161
ENQUEUE_ARRAY Function, 24
ENQUEUE_OPTIONS_T Type, 269
ENQUOTE_LITERAL Function, 28
ENQUOTE_NAME Function, 28
EPC_TO_ORACLE_SCHEME function, 95
EQUALS_HOST Function, 101
ERASE Procedures, 87
error queue
deleting errors, 23, 23
executing errors, 23, 23
getting error messages, 23
ERROR_DEPTH Function, 245
ERROR_MSG Function, 245
ERROR_NUMBER Function, 245
ESCAPE function, 264
ESCAPE_SC function
of HTF package, 205
ESCAPE_SC procedure
of HTP package, 206
ESCAPE_URL function
of HTF package, 205
ESCAPEURI function, 271
ESTIMATE_CPU_UNITS function, 102
ESTIMATE_MVIEW_SIZE Procedure, 99
ETINSTANCE member function
of ANYDATASET TYPE, 267
EVALUATE procedure, 136
EVOLVE_SQL_PLAN_BASELINE Function, 146
EXACT_TEXT_SIGNATURES procedure, 104
EXCHANGEPOSTPROC Procedure, 197
EXCHANGEPREPROC Procedure, 197
EXEC_DDL_STATEMENT Procedure, 172
EXECUTE function, 147
EXECUTE member procedure, 273, 273
EXECUTE procedure, 53
EXECUTE_ALL_ERRORS procedure, 23
EXECUTE_ANALYSIS_TASK, 151
EXECUTE_AND_FETCH function, 147
EXECUTE_DIAGNOSIS_TASK Procedure, 150
EXECUTE_ERROR procedure, 23
EXECUTE_EVOLVE_TASK Function, 146
EXECUTE_ILM Procedure, 79
EXECUTE_ILM_TASK Procedur, 79
EXECUTE_IMMEDIATE Procedure, 78
EXECUTE_NON_QUERY Function, 78
EXECUTE_TASK Procedure, 19
EXECUTE_TUNING_TASK Function & Procedure, 30, 152
execution flow
in dynamic SQL, 147
EXISTSNODE function, 283
EXISTSRESOURCE Function, 183
EXPAND_MESSAGE function, 139
EXPAND_SQL_TEXT Procedure, 172
EXPLAIN_SQL_TESTCASE Function, 150
EXPONENTIAL_DIST_FIT procedure, 154
EXPORT_AWR Procedure, 175, 176
EXPORT_COLUMN_STATS procedure, 153
EXPORT_DATABASE_PREFS Procedure, 153
EXPORT_DATABASE_STATS procedure, 153
EXPORT_DICTIONARY_STATS procedure, 153
EXPORT_FIXED_OBJECTS_STATS procedure, 153
EXPORT_INDEX_STATS procedure, 153
EXPORT_PENDING_STATS Procedure, 153
EXPORT_PROFILE Procedure, 148
EXPORT_SCHEMA_PREFS Procedure, 153
EXPORT_SCHEMA_STATS procedure, 153
EXPORT_SQL_TESTCASE Procedures, 150
EXPORT_SQL_TESTCASE_DIR_BY_INC Function, 150
EXPORT_SQL_TESTCASE_DIR_BY_TXT Function, 150
EXPORT_SYSTEM_STATS procedure, 153
EXPORT_TABLE_PREFS Procedure, 153
EXPORT_TABLE_STATS procedure, 153
EXPORT_XML procedure, 42, 42
EXPORT_XML_TO_FILE procedure, 42
EXTEND_MAPPINGS Procedure, 71
EXTENT_HEAT_MAP Function, 74
EXTRACT function, 283
EXTRACTXLIFF Function & Procedure, 199

F

FCLOSE procedure, 249
FCLOSE_ALL procedure, 249
FCOPY procedure, 249
FEATURE_OPTIONS Table Type, 169
FEATURE_T Record Type, 48
FEATURENAME Function, 48
FEATURES_T Table Type, 48
FETCH_ROW Function, 78
FETCH_ROWS function, 147
FFLUSH procedure, 249
FGETATTR procedure, 249
FGETPOS function, 249
FI_HORIZONTAL function, 73
FI_TRANSACTIONAL function, 73
file groups, 68
adding files, 68
altering, 68
altering files, 68
altering versions, 68
creating, 68
creating versions, 68
dropping, 68
dropping versions, 68
granting object privileges, 68
granting system privileges, 68
purging, 68
removing files, 68
revoking object privileges, 68
revoking system privileges, 68
FILE type, 162
FILE_SET type, 162
FILECLOSE Procedure, 87
FILECLOSEALL Procedure, 87
FILEEXISTS Function, 87
FILEGETNAME Procedure, 87
FILEISOPEN Function, 87
FILEOPEN Procedure, 87
FILETYPE Record Type, 249
FIND_AFFECTED_TABLE Procedure, 62
FINDENTITY function, 189
FINDNOTATION function, 189
fine-grained access control
DBMS_RLS package, 133
FINISH_CAPTURE Procedure, 175
FINISH_REDEF_TABLE procedure, 120
FINISH_REPORT_CAPTURE Procedure, 31
FIX_CORRUPT_BLOCKS procedure, 122
FLUSH Function & Procedure, 131
FLUSH procedure, 44, 263
FLUSH_DATA function and procedure, 114
FLUSH_DATABASE_MONITORING_INFO procedure, 153
FLUSH_SQL_PLAN_DIRECTIVE Procedure, 145
FLUSH_UNIFIED_AUDIT_TRAIL, 29
FLUSHCACHE Procedure, 50
FONTCLOSE function
of HTF package, 205
FONTCLOSE procedure
of HTP package, 206
FONTOPEN function
of HTF package, 205
FONTOPEN procedure
of HTP package, 206
FOPEN function, 249
FOPEN_NCHAR function, 249
FORCE parameter
and job-to-instance affinity, 83
FORMAT function, 280
FORMAT_CALL_STACK Function, 172
FORMAT_CELL function
of HTF package, 205
FORMAT_ERROR_BACKTRACE Function, 172
FORMAT_ERROR_STACK Function, 172
FORMCHECKBOX function
of HTF package, 205
FORMCHECKBOX procedure
of HTP package, 206
FORMCLOSE function
of HTF package, 205, 205
FORMCLOSE procedure
of HTP package, 206
FORMFILE function
of HTF package, 205
FORMFILE procedure
of HTP package, 206, 206
FORMHIDDEN function
of HTF package, 205
FORMHIDDEN procedure
of HTP package, 206
FORMIMAGE function
of HTF package, 205
FORMIMAGE procedure
of HTP package, 206
FORMOPEN function
of HTF package, 205
FORMOPEN procedure
of HTP package, 206
FORMPASSWORD function
of HTF package, 205
FORMPASSWORD procedure
of HTP package, 206
FORMRADIO function
of HTF package, 205
FORMRADIO procedure
of HTP package, 206
FORMRESET function
of HTF package, 205
FORMRESET procedure
of HTP package, 206
FORMSELECTCLOSE function
of HTF package, 205
FORMSELECTCLOSE procedure
of HTP package, 206
FORMSELECTOPEN function
of HTF package, 205
FORMSELECTOPEN procedure
of HTP package, 206
FORMSELECTOPTION function
of HTF package, 205
FORMSELECTOPTION procedure
of HTP package, 206
FORMSUBMIT function
of HTF package, 205
FORMSUBMIT procedure
of HTP package, 206
FORMTEXT function
of HTF package, 205
FORMTEXT procedure
of HTP package, 206
FORMTEXTAREA function
of HTF package, 205
FORMTEXTAREA procedure
of HTP package, 206
FORMTEXTAREA2 function
of HTF package, 205
FORMTEXTAREA2 procedure
of HTP package, 206
FORMTEXTAREACLOSE function
of HTF package, 205
FORMTEXTAREACLOSE procedure
of HTP package, 206
FORMTEXTAREAOPEN function
of HTF package, 205
FORMTEXTAREAOPEN procedure
of HTP package, 206
FORMTEXTAREAOPEN2 function
of HTF package, 205
FORMTEXTAREAOPEN2 procedure
of HTP package, 206
FRAGMENT_DELETE Procedure, 87
FRAGMENT_INSERT Function, 87
FRAGMENT_MOVE Procedure, 87
FRAGMENT_REPLACE Procedure, 87
FRAME function
of HTF package, 205
FRAME procedure
of HTP package, 206
FRAMESETCLOSE function
of HTF package, 205
FRAMESETCLOSE procedure
of HTP package, 206
FRAMESETOPEN function
of HTF package, 205
FRAMESETOPEN procedure
of HTP package, 206
FREE_BLOCKS procedure, 143
FREE_UNUSED_USER_MEMORY Procedure, 141
FREEDOCFRAG procedure, 189
FREEDOCUMENT procedure, 189
FREENODE procedure, 189, 189
FREEPARSER procedure, 192
FREEPROCESSOR procedure, 201
FREERESOURCE Procedure, 185
FREESTYLESHEET procedure, 201
FREETEMPORARY Procedures, 87
FREMOVE procedure, 249, 249
FRENAME procedure, 249
FSEEK procedure, 249

G

GATHER_DATABASE_STATS procedures, 153
GATHER_DICTIONARY_STATS procedure, 153
GATHER_FIXED_OBJECTS_STATS procedure, 153
GATHER_INDEX_STATS Procedure, 153
GATHER_PROCESSING_RATE Procedure, 153
GATHER_SCHEMA_STATS procedures, 153
GATHER_SYSTEM_STATS procedure, 153
GATHER_TABLE_STATS procedure, 153
GENERATE_CAPTURE_SUBSET Procedure, 176
GENERATE_RESULT Procedure, 113
GENERATE_STATS procedure, 153
GENERATE_TASK_NAME Function, 106
GENERATESCHEMA Function, 195
GENERATESCHEMAS function, 195
GET function
of OWA_COOKIE package, 210
GET* member functions
of ANYDATA TYPE, 266
of ANYDATASET TYPE, 267
GET_ACLOID function, 187
GET_ALL procedure, 210
GET_ALL_DAD_ATTRIBUTES Procedure, 65
GET_ALL_DAD_MAPPINGS Procedure, 65
GET_ALL_GLOBAL_ATTRIBUTES Procedure, 65
GET_ALL_NAMES member function, 281
GET_ASH_QUERY Function, 17
GET_AUDIT_COMMIT_DELAY function, 29
GET_AUTHENTICATION procedure, 250
GET_BASE_TABLE_NAME member function, 273
GET_BASE_TABLE_OWNER member function, 273
GET_BODY_CHARSET procedure, 250
GET_CAPTURE_INFO Function, 175
GET_CATEGORY function, 173
GET_CATEGORY_ID function, 95
GET_CGI_ENV function, 217
GET_CLIENT_ATTRIBUTES Procedure, 32
GET_CLIENT_HOSTNAME function, 215
GET_CLIENT_IP function, 215
GET_COLUMN_STATS procedures, 153
GET_COMMAND_TYPE member function, 273
GET_COMMIT_SCN member function, 273
GET_COMMIT_SCN_FROM_POSITION static function, 273
GET_COMMIT_TIME member function, 273
GET_COMMON_TIME_ZONES Function, 251
GET_COMPATIBLE member function, 273
GET_COMPONENT function, 280
GET_COMPONENTS function, 95
GET_COMPRESSION_RATIO Procedure, 36
GET_COMPRESSION_TYPE Function, 36
GET_COOKIE_COUNT function, 250
GET_COOKIE_SUPPORT procedure, 250
GET_COOKIES function, 250
GET_CPU_TIME Function, 172
GET_CURRENT_SCHEMA member function, 273
GET_DAD_ATTRIBUTE Function, 65
GET_DAD_LIST Procedure, 65
GET_DBFS_LINK Functions, 87
GET_DBFS_LINK_STATE Procedure, 87
GET_DEFAULT_ISO_CURRENCY Function, 251
GET_DEFAULT_LINGUISTIC_SORT Function, 251
GET_DEPENDENCY Procedure, 172
GET_DETAILED_EXCP_SUPPORT procedure, 250
GET_DETAILED_SQLCODE function, 250
GET_DETAILED_SQLERRM function, 250
GET_DIVERGING_STATEMENT Function, 176
GET_EDITION_NAME member function, 273
GET_ENCODINGS function, 95
GET_ENDIANNESS Function, 172
GET_ERROR_MESSAGE function, 23
GET_ETAG function, 209
GET_EXPRESSION function, 46
GET_EXTRA_ATTRIBUTE member function, 273
GET_FILE procedure, 69
GET_FIX_CONTROL Function, 150
GET_FOLLOW_REDIRECT procedure, 250
GET_GLOBAL_ATTRIBUTE Function, 65
GET_HASH_VALUE Function, 172
GET_HEADER procedure, 250
GET_HEADER_BY_NAME procedure, 250
GET_HEADER_COUNT function, 250
GET_HOST_ADDRESS function, 252
GET_HOST_NAME function, 252
GET_INDEX_STATS procedures, 153
GET_INDEXES function, 53
GET_INFORMATION function, 156
GET_JAVA_LOGGING_LEVEL function, 95
GET_LEVEL function, 209
GET_LINE function, 263
GET_LINE procedure, 105, 249
GET_LINE_MAP function, 53
GET_LINE_NCHAR Function, 263
GET_LINE_NCHAR procedure, 249
GET_LINES procedure, 105
GET_LOB_INFORMATION member function, 273
GET_LOB_OFFSET member function, 273
GET_LOB_OPERATION_SIZE member procedure, 273
GET_LOCAL_LINGUISTIC_SORTS Function, 251
GET_LOG procedure, 44
GET_LOG_SPEC function, 44
GET_LOGON_USER member function, 273
GET_LONG_INFORMATION member function, 273
GET_LTXID_OUTCOME Procedure, 21
GET_MAX_STREAMS_POOL Procedure, 25
GET_MESSAGE_TRACKING function, 157, 202
GET_MIN_STREAMS_POOL Procedure, 25
GET_MORE_SOURCE procedure, 53
GET_NEXT_HIT function, 136
GET_NEXT_RESULT Procedures, 147
GET_NUMBER_COL_CHUNK Procedure, 106
GET_OBJECT_NAME member function, 273
GET_OBJECT_OWNER member function, 273
GET_OBJECT_TYPE member function, 273
GET_OPATCH_BUGS Function, 116
GET_OPATCH_COUNT Function, 116
GET_OPATCH_DATA Function, 116
GET_OPATCH_FILES Function, 116
GET_OPATCH_INSTALL_INFO Function, 116
GET_OPATCH_LIST Function, 116
GET_OPATCH_LSINVENTORY, 116
GET_OPATCH_OLAYS Function, 116
GET_OPATCH_PREQS Function, 116
GET_OPATCH_XSLT, 116
GET_OWA_SERVICE_PATH function, 217
GET_P1_RESOURCES Procedure, 32
GET_PACKAGE_MEMORY_UTILIZATION Procedure, 141
GET_PARAM function, 153
GET_PARAMETER function, 44
GET_PARAMETER_VALUE Function, 172
GET_PASSWORD function, 215
GET_PENDING_ACTIVITY, 116
GET_PERSISTENT_CONN_COUNT function, 250
GET_PERSISTENT_CONN_SUPPORT procedure, 250
GET_PERSISTENT_CONNS procedure, 250
GET_PLSQL_LOGGING_LEVEL function, 95
GET_PLSQL_TRACE_LEVEL function, 165
GET_POSITION member function, 273, 273
GET_POST_PROCESSED_SOURCE Functions, 112
GET_PREFS Function, 145, 153
GET_PROCEDURE function, 217
GET_PROXY procedure, 250
GET_RAW function, 249, 263
GET_REC_ATTRIBUTES Procedure, 19
GET_REPLAY_DIRECTORY Function, 176
GET_REPLAY_INFO Function, 176
GET_REPLAY_TIMEOUT Procedure, 176
GET_REPORT Function, 17
GET_RESPONSE function, 250
GET_RESPONSE_ERROR_CHECK procedure, 250
GET_ROW_TEXT member procedure, 273
GET_ROWID function, 213
GET_ROWID_CHUNK Procedure, 106
GET_RUN_REPORT Function, 75
GET_RUNTIME_INFO function, 53
GET_SCHEME_NAMES function, 95
GET_SCN member function, 273
GET_SCN_FROM_POSITION static function, 273
GET_SCN_MAPPING procedure, 157
GET_SESSION_TIMEOUT function, 132
GET_SOURCE_DATABASE_NAME member function, 273
GET_SOURCE_TIME member function, 273
GET_SQL Function, 150
GET_SQL_HASH Function, 172
GET_SQLPATCH_STATUS, 116
GET_STATS_HISTORY_AVAILABILITY function, 153
GET_STATS_HISTORY_RETENTION function, 153
GET_STREAMS_NAME function, 156
GET_STREAMS_TYPE function, 156
GET_SYS_CONTEXT Function, 71
GET_SYSTEM_STATS procedure, 153
GET_TABLE_STATS procedure, 153
GET_TAG function, 156, 157, 202
GET_TAG member function, 273
GET_TASK_REPORT Procedure, 19
GET_TASK_SCRIPT Procedure, 19
GET_TDT_XML function, 95
GET_TEXT function, 263
GET_TEXT_NCHAR Function, 263
GET_THREAD_NUMBER member function, 273
GET_THRESHOLD procedure, 139
GET_TIME Function, 172
GET_TIMEOUT function, 132
GET_TIMEOUT_BEHAVIOUR function, 53
GET_TRANSACTION_ID member function, 273
GET_TRANSFER_TIMEOUT procedure, 250
GET_TZ_TRANSITIONS Procedure, 172
GET_USER_ID function, 215
GET_USERID function, 187
GET_VALIDATOR function, 95
GET_VALUE function, 53
GET_VALUE member function, 273, 281
GET_VALUE Procedure, 78
GET_VALUE_RAW Procedure, 78
GET_VALUES member function, 273
GET_VERSION procedure, 114
GET_WARNING_SETTING_CAT function, 173
GET_WARNING_SETTING_NUM function, 173
GET_WARNING_SETTING_STRING function, 173
GET_WATERMARK Procedure, 25
GET_WHERE_CLAUSE member procedure, 273
GET_X function, 212
GET_XML_INFORMATION member function, 273
GET_Y function, 212
GETACL Function, 185
GETACLDOCFROMRES Function, 185
GETACLDOCUMENT Function, 183
GETAPPLICATIONDATA Function, 188
GETATTRELEMINFO member function
of ANYTYPE TYPE, 268
GETATTRIBUTE function, 189
GETATTRIBUTENODE function, 189
GETATTRIBUTES function, 189
GETAUTHOR Function, 185
GETBASEDOCUMENT Function, 199
GETBLOB function, 271, 271, 271, 271
GETBLOBVAL function, 283
GETBUBLICID function, 189
GETCHARACTERSET Function, 185
GETCHARSET Function, 189
GETCHILDNODES function, 189
GETCHILDOID Function, 188
GETCHILDRENBYTAGNAME function, 189
GETCHUNKSIZE Functions, 87
GETCLOB function, 271, 271, 271, 271
GETCLOBVAL function, 283
GETCOMMENT Function, 185
GETCONTENTBLOB Function, 183, 185
GETCONTENTCLOB Function, 183, 185
GETCONTENTREF Function, 185
GETCONTENTSBLOBBYRESID function, 184
GETCONTENTSCLOBBYRESID function, 184, 184
GETCONTENTSXMLBYRESID function, 184
GETCONTENTTYPE function, 271, 271, 271, 271
GETCONTENTTYPE Function, 185
GETCONTENTTYPE Functions, 87
GETCONTENTVARCHAR2 Function, 183, 185
GETCONTENTXML Function, 185
GETCONTENTXMLREF Function, 183
GETCONTENTXMLTYPE Function, 183
GETCOUNT member function
of ANYDATASET TYPE, 267
GETCREATIONDATE Function, 185
GETCREATOR Function, 185
GETCURRENTUSER Function, 188
GETCUSTOMMETADATA Function, 185
GETDATA function, 189
GETDCHARSET function, 189
GETDEFAULTACL Procedure, 48
GETDEFAULTASOF Procedure, 48
GETDEFAULTOWNER Procedure, 48
GETDEFAULTPRINCIPAL Procedure, 48
GETDISPLAYNAME Function, 185
GETDOCTYPE function, 189, 192
GETDOCUMENT function, 192
GETDOCUMENTELEMENT function, 189
GETDTD function, 193
GETDTD procedure, 193
GETELEMENTSBYTAGNAME function, 189, 189
GETENTITIES function, 189
GETEVENT Function, 188
GETEXCEPTIONCONTENT procedure, 193, 194
GETEXPANDEDNAME function, 189, 189
GETEXPANDEDNAME procedure, 189
GETEXTERNALURL function, 271, 271, 271, 271
GETFEATURES Function, 49
GETFEATURESBYMOUNT Function, 48
GETFEATURESBYNAME Function, 48
GETFEATURESBYPATH Function, 48
GETFIRST Function, 188
GETFIRSTCHILD function, 189
GETFTPPORT Function, 181
GETHANDLERLIST Function, 188
GETHTTPPORT Function, 181
GETHTTPSPORT Function, 181
GETIMPLEMENTATION function, 189
GETINFO member function
of ANYTYPE TYPE, 268
GETINTERFACE Function, 188
GETLANGUAGE Function, 185, 188, 188
GETLASTCHILD function, 189
GETLASTMODIFIER Function, 185
GETLENGTH function, 189, 189, 189
GETLENGTH Functions, 87
GETLINK Function, 188
GETLINKNAME Function, 188
GETLISTENERENDPOINT Procedure, 181
GETLISTENERS Function, 128
GETLOCK Function, 188
GETLOCKTOKEN Procedure, 183
GETMODIFICATIONDATE Function, 185
GETNAME function, 189, 189
GETNAME Function, 188
GETNAMEDITEM function, 189
GETNAMESPACE function, 189, 189
GETNAMESPACE procedure, 189
GETNEXTSIBLING function, 189
GETNODENAME function, 189
GETNODETYPE function, 189
GETNODEVALUE function, 189
GETNODEVALUEASBINARYSTREAM Function & Procedure, 189
GETNODEVALUEASCHARACTERSTREAM Function & Procedure, 189
GETNOTATIONNAME function, 189
GETNOTATIONS function, 189
GETNUMBERVAL function, 283
GETNUMROWSPROCESSED function, 190
GETNUMROWSPROCESSED procedure, 193
GETOLDRESOURCE Function, 188
GETOPENACCESSMODE Function, 188
GETOPENDENYMODE Function, 188
GETOPTIONS Functions, 87
GETOUTPUTSTREAM Function, 188
GETOWNER Function, 185
GETOWNERDOCUMENT function, 189
GETOWNERELEMENT function, 189
GETPARAMETER Function, 188
GETPARENT Function, 188
GETPARENTNAME Function, 188
GETPARENTNODE function, 189
GETPARENTOID Function, 188
GETPARENTPATH Function, 188
GETPAT procedure, 214
GETPATH Function, 188
GETPATH Procedures, 48, 49
GETPATHBYMOUNTID Function, 48
GETPATHBYREPOSID Function, 49
GETPATHBYSTOREID Function, 48
GETPATHNOWAIT Procedure, 49
GETPATHNOWAIT Procedures, 48
GETPERSISTENT static function
of ANYTYPE TYPE, 268
GETPREDECESSORS function, 184
GETPREDSBYRESID function, 184
GETPREFIX function, 189
GETPREVIOUSSIBLING function, 189
GETPRIVILEGES Function, 183
GETPUBLICID function, 189, 189
GETQUALIFIEDNAME function, 189, 189
GETREFCOUNT Function, 185
GETRELEASEVERSION function, 192
GETREPOSITORYRESCONFIG Function, 128
GETREPOSITORYRESCONFIGPATHS Function, 128
GETRESCONFIG Function, 128
GETRESCONFIGPATHS Function, 128
GETRESOID Function, 183
GETRESOURCE Function, 188
GETRESOURCEBYRESID function, 184
GETROOTELEMENT function, 283
GETRUL function, 271
GETSCHEMA Function, 188
GETSCHEMAANNOTATIONS Function, 196
GETSCHEMANODE function, 189
GETSCHEMAURL function, 283
GETSIDXDEFFROMVIEW Function, 196
GETSOURCE Function, 188
GETSPECIFIED function, 189
GETSTANDALONE function, 189
GETSTATS Procedure, 48
GETSTOREBYMOUNT Function, 48
GETSTOREBYNAME Function, 48
GETSTOREBYPATH Function, 48
GETSTOREID Function, 49
GETSTOREPROPERTY Function, 50
GETSTRINGVAL function, 283
GETSUCCESSORS function, 184
GETSUCCSBYRESID function, 184
GETSYSTEMID function, 189, 189, 189
GETTAGNAME function, 189
GETTARGET function, 189
GETTDEFAULTCONTEXT Procedure, 48
GETTOKENTABLEINFO Procedure & Function, 41
GETTOKENTABLEINFOBYTABLESPACE Procedure, 41
GETTRACE Function, 48
GETTYPE member function
of ANYDATA TYPE, 266
of ANYDATASET TYPE, 267
GETTYPENAME member function
of ANYDATA TYPE, 266
of ANYDATASET TYPE, 267
GETUPDATEBYTECOUNT Function, 188
GETUPDATEBYTEOFFSET Function, 188
GETURL function, 271, 271, 271, 271
GETVALIDATIONMODE function, 192
GETVALUE function, 189
GETVERSION function, 189
GETVERSION Function, 48, 49
GETVERSION procedure, 193
GETVERSIONID Function, 185
GETXDB_TABLESPACE Function, 183
GETXDBEVENT Function, 188
GETXML function, 190, 193, 271, 271, 271, 271
GETXML procedure, 193
GETXMLTYPE function, 189, 190
GoldenGate
privileges, 72
GoldenGate administrator, 72
GRANT_ADMIN_PRIVILEGE procedure, 72, 159, 203
GRANT_OBJECT_PRIVILEGE procedure, 137
GRANT_REMOTE_ADMIN_ACCESS procedure, 159, 203
GRANT_SWITCH_CONSUMER_GROUP procedure, 130
GRANT_SYSTEM_PRIVILEGE procedure, 68, 130, 137
GRANTING_OBJECT_PRIVILEGE procedure, 68

H

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

I

IMG function
of HTF package, 205
IMG procedure
of HTP package, 206
IMG2 procedure
of HTP package, 206
IMPLEMENT_EVOLVE_TASK Procedure, 146
IMPLEMENT_TASK Procedure, 19
IMPLEMENT_TUNING_TASK Function, 152
IMPORT_AWR Function, 176
IMPORT_AWR Procedure, 175
IMPORT_COLUMN_STATS procedure, 153
IMPORT_DATABASE_PREFS Procedure, 153
IMPORT_DATABASE_STATS procedure, 153
IMPORT_DICTIONARY_STATS procedure, 153
IMPORT_DISCOVERY_RESULT Procedure, 168
IMPORT_FIXED_OBJECTS_STATS procedure, 153
IMPORT_HISTORY Procedure, 71
IMPORT_INDEX_STATS procedure, 153
IMPORT_PROFILE Procedure, 148
IMPORT_SCHEMA_PREFS Procedure, 153
IMPORT_SCHEMA_STATS procedure, 153
IMPORT_SENSITIVE_TYPES Procedure, 168
IMPORT_SQL_TESTCASE Procedures, 150
IMPORT_SQLWKLD_SCHEMA Procedure, 19
IMPORT_SQLWKLD_SQLCACHE Procedure, 19
IMPORT_SQLWKLD_STS Procedure, 19
IMPORT_SQLWKLD_SUMADV Procedure, 19
IMPORT_SQLWKLD_USER Procedure, 19
IMPORT_SYSTEM_STATS procedure, 153
IMPORT_TABLE_PREFS Procedure, 153
IMPORT_TABLE_STATS procedure, 153
IMPORT_XML procedure, 42, 42
IMPORTNODE function, 189
inbound servers
DBMS_STREAMS_ADM package, 157
rules, 157
INCIDENTID_2_SQL Procedure, 150
INCLUDE_EXTRA_ATTRIBUTES procedure, 34
INDEX_TABLE_TYPE Table Type, 172
INDEXXMLREFERENCES Procedure, 197
INIT_CLEANUP procedure, 29
INITFS Procedure, 51
INITIALIZE function, 53
INITIALIZE procedure, 117
INITIALIZE_CONSOLIDATED_REPLAY Procedure, 176
INITIALIZE_CUBE_UPGRADE procedure, 42, 42, 42
INITIALIZE_REPLAY Procedure, 176
INPLACEEVOLVE Procedure, 195
INSERT_AUTOBIN_NUM_EQWIDTH procedure, 46
INSERT_BIN_CAT_FREQ procedure, 46
INSERT_BIN_NUM_EQWIDTH procedure, 46
INSERT_BIN_NUM_QTILE procedure, 46
INSERT_BIN_SUPER procedure, 46
INSERT_CLIP_TRIM_TAIL procedure, 46
INSERT_CLIP_WINSOR_TAIL procedure, 46
INSERT_FINDING_DIRECTIVE Procedure, 17
INSERT_MISS_CAT_MODE procedure, 46
INSERT_MISS_NUM_MEAN procedure, 46
INSERT_NORM_LIN_MINMAX procedure, 46
INSERT_NORM_LIN_SCALE procedure, 46
INSERT_NORM_LIN_ZSCORE procedure, 46
INSERT_PARAMETER_DIRECTIVE Procedure, 17
INSERT_SEGMENT_DIRECTIVE Procedure, 17
INSERT_SQL_DIRECTIVE Procedure, 17
INSERTBEFORE function, 189
INSERTDATA procedure, 189
INSERTXML function, 194, 198
INSTALLDEFAULTWALLET Function, 180
INSTANCE procedure, 83
INSTANCE_RECORD Record Type, 172
INSTANCE_TABLE Table Type, 172
instantiation
aborting database preparation, 34
aborting schema preparation, 34
aborting table preparation, 34
global SCN, 23
preparing a database for, 34
preparing a schema for, 34
preparing a table for, 34, 34
schema SCN, 23
table SCN, 23
INSTR Functions, 87
INTEGER_ARRAY Table Type, 141
INTERNAL_VERSION_CHECK function, 114
internet addressing
using UTL_INADDR, 252
INTERRUPT_ANALYSIS_TASK Procedure, 151
INTERRUPT_DIAGNOSIS_TASK Procedure, 150
INTERRUPT_EVOLVE_TASK Procedure, 146
INTERRUPT_TASK Procedure, 19
INTERRUPT_TUNING_TASK procedure, 152
INTERVAL procedure, 83
INTERVAL_DAY_TO_SECOND_TABLE, 147
INTERVAL_YEAR_TO_MONTH_TABLE Table Type, 147
INVALIDATE Functions & Procedures, 131
INVALIDATE Procedure, 172
INVALIDATE_OBJECT Functions & Procedures, 131
IS_BIT_SET Function, 172
IS_CLEANUP_INITIALIZED function, 29
IS_CLUSTER_DATABASE Function, 172
IS_FAST Procedure, 136
IS_GG_XSTREAM_FOR_STREAMS function, 202
IS_HIERARCHY_ENABLED function, 187
IS_LOCATOR function, 246
IS_NULL_TAG member function, 273
IS_OPEN function, 147, 249
IS_PATCH_INSTALLED Function, 116
IS_REPLAY_PAUSED Procedure, 176
IS_ROLE_ENABLED Function, 141
IS_SESSION_ALIVE Function, 141
IS_TRIGGER_FIRE_ONCE function, 54
ISFOLDER Function, 183, 185
ISFRAGMENT function, 283
ISINDEX function
of HTF package, 205
ISINDEX procedure
of HTP package, 206
ISNULL function, 189
ISNULL Function, 185, 188
ISOPEN function, 247
ISOPEN Functions, 87
ISSCHEMABASED function, 283
ISSCHEMAVALID function, 283
ISSCHEMAVALIDATED function, 283
ISTEMPORARY Functions, 87
ITALIC function
of HTF package, 205
ITALIC procedure
of HTP package, 206
ITEM Functions, 189

J

JARO_WINKLER Function, 256
JARO_WINKLER_SIMILARITY Function, 256

K

KBD function
of HTF package, 205
KBD procedure
of HTP package, 206
KEEP Procedure, 142
KEEP_COLUMNS member procedure, 273
KEEP_COLUMNS procedure, 157, 202
KEYBOARD function
of HTF package, 205
KEYBOARD procedure
of HTP package, 206

L

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

M

MAIL function and procedure, 261
MAILTO function
of HTF package, 205
MAILTO procedure
of HTP package, 206
MAINTAIN_CHANGE_TABLE procedure, 157
MAINTAIN_GLOBAL procedure, 157
MAINTAIN_SCHEMAS procedure, 157
MAINTAIN_SIMPLE_TABLESPACE procedure, 157
MAINTAIN_SIMPLE_TTS procedure, 157
MAINTAIN_TABLES procedure, 157
MAINTAIN_TABLESPACES procedure, 157
MAINTAIN_TTS procedure, 157
MAKE_DATA_BLOCK_ADDRESS Function, 172
MAKEATTR function, 189
MAKECDATASECTION function, 189
MAKECHARACTERDATA function, 189
MAKECOMMENT function, 189
MAKEDOCUMENT function, 189
MAKEDOCUMENT Function, 185
MAKEDOCUMENTFRAGMENT function, 189
MAKEDOCUMENTTYPE function, 189
MAKEELEMENT function, 189
MAKEENTITY function, 189
MAKEENTITYREFERENCE function, 189
MAKENODE function, 189, 189, 189, 189
MAKENOTATION function, 189
MAKEPROCESSINGINSTRUCTION function, 189
MAKETEXT function, 189
MAKEVERSIONED function, 184
MAP_ALL function, 155
MAP_DAD Procedure, 65
MAP_ELEMENT function, 155
MAP_FILE function, 155
MAP_OBJECT function, 155
MAPCLOSE function
of HTF package, 205
MAPCLOSE procedure
of HTP package, 206
MAPOPEN function
of HTF package, 205
MAPOPEN procedure
of HTP package, 206
MARK_RECOMMENDATION Procedure, 19
MARKHOT Procedure, 142
MATCH function, 214
MATERIALIZE_DEFERRED_SEGMENTS Procedure, 144
materialized view logs
master table
purging, 99, 99, 99
materialized views
comparing, 35
converting from table- to cube-organized, 42
optimizing cube organized, 43
refreshing, 99, 99, 99
materialized views (cube organized), 42
MEMORY_REPORT Procedure, 131
MENULISTCLOSE function
of HTF package, 205
MENULISTCLOSE procedure
of HTP package, 206
MENULISTOPEN function
of HTF package, 205
MENULISTOPEN procedure
of HTP package, 206
merge streams, 157, 157, 202, 202
MERGE_COL_USAGE Procedure, 153
MERGE_STREAMS procedure, 157, 202
MERGE_STREAMS_JOB procedure, 157, 202
MERGEXLIFF Functions, 199
MESSAGE_PROPERTIES_ARRAY_T Type, 269
MESSAGE_PROPERTIES_T Type, 269
messaging client
messaging client user, 157
rules
for LCRs, 157
for user messages, 157
META function
of HTF package, 205
META procedure
of HTP package, 206
MG2 function
of HTF package, 205
MGD_ID constructor function, 280
MGD_ID object type, 280
FORMAT function, 280
GET_COMPONENT function, 280
MGD_ID constructor function, 280
TO_STRING function, 280
TRANSLATE function, 280
MGD_ID object types, 280
MGD_ID_COMPONENT object type, 280
MGD_ID_COMPONENT_VARRAY object type, 280
MIGRATE_STORED_OUTLINE Function, 146
MIME_HEADER procedure, 217
MIMEHEADER_DECODE function, 248
MIMEHEADER_ENCODE function, 248
model transparency, 46
MODIFY_BASELINE_WINDOW_SIZE Procedure, 177
MODIFY_PACKAGE_STATE Procedure, 141
MODIFY_SERVICE Procedure, 140
MODIFY_SNAPSHOT_SETTINGS procedure, 177
MODIFY_TRANSFORMATION procedure, 167
MODIFYPARAMETER Procedure, 191
MOUNT_T Record Type, 48
MOUNTS_T Table Type, 48
MOUNTSTORE Procedure, 48
MOVE_TO_DBFS_LINK Procedures, 87
MOVEXDB_TABLESPACE Procedure, 180
MSGID_ARRAY_T Type, 269
MV_CUBE_ADVICE function, 43

N

NAME_ARRAY Table Type, 172
NAME_RESOLVE Procedure, 172
NAME_TOKENIZE Procedure, 172
NAMELIST Table Type, 146
NAMESPACE function, 283
NAMESPACE_ACL Function, 182
NAMESPACE_METADATA Function, 182
NAMESPACE_ORACLE Function, 182
NAMESPACE_RESOURCE Function, 182
NAMESPACE_RESOURCE_CONFIG Function, 182
NAMESPACE_RESOURCE_EVENT Function, 182
NAMESPACE_XDBSCHEMA Function, 182
NAMESPACE_XMLDIFF Function, 182
NAMESPACE_XMLINSTANCE Functio, 182
NAMESPACE_XMLSCHEMA Function, 182
NAMESPACEIDTABLE Procedure, 41
NEW_LINE procedure, 105, 249
NEW_ROW_LIST function and procedure, 216
NEWCONTEXT function, 190, 193, 194, 198
NEWCONTEXTFROMHIERARCHY Function, 190
NEWDOMDOCUMENT function, 189
NEWPARSER function, 192
NEWPROCESSOR function, 201
NEWSTYLESHEET function, 201
NEXT_DATE procedure, 83
NEXT_ITEM_TYPE function, 110
NL function
of HTF package, 205
NL procedure
of HTP package, 206
NOBR function
of HTF package, 205
NOBR procedure
of HTP package, 206
NOFRAMESCLOSE function
of HTF package, 205
NOFRAMESCLOSE procedure
of HTP package, 206
NOFRAMESOPEN function
of HTF package, 205
NOFRAMESOPEN procedure
of HTP package, 206
NOOP function and procedure, 261
NOOP Functions, 28
NORMAL function, 117
NORMAL_DIST_FIT procedure, 154
NORMALIZE procedure, 189
NORMALIZEPATH Functions, 48
NSPREFIX_ACL_ACL Function, 182
NSPREFIX_RESCONFIG_RC Function, 182
NSPREFIX_RESOURCE_R Function, 182
NSPREFIX_XDB_XDB Function, 182
NSPREFIX_XMLDIFF_XD Function, 182
NSPREFIX_XMLINSTANCE_XSI Function, 182
NSPREFIX_XMLSCHEMA_XSD Functio, 182
NUMBER_ARRAY Table Type, 172
NUMBER_TABLE Table Type, 147
NVARRAY_ADD Procedure, 97
NVARRAY_FIND_NAME Function, 97
NVARRAY_FIND_NAME_TYPE Function, 97
NVARRAY_GET Function, 97
NVARRAY_GET_BOOLEAN, 97
NVARRAY_GET_BYTE, 97
NVARRAY_GET_DATE Function, 97
NVARRAY_GET_DOUBLE Function, 97
NVARRAY_GET_FLOAT Function, 97
NVARRAY_GET_INTEGER, 97
NVARRAY_GET_LONG Function, 97
NVARRAY_GET_RAW Function, 97
NVARRAY_GET_SHORT, 97
NVARRAY_GET_TEXT Function, 97

O

OBJECT_DEPENDENT_SEGMENTS function, 143
OBJECT_GROWTH_TREND function, 143
OBJECT_HEAT_MAP Procedure, 74
ogical change records (LCRs)
tracking, 157, 157, 202
OLAP aggregation operators, 42
OLAP logs
Cube Build, 44
Cube Dimension Compile, 44
Cube Operations, 44
Cube Rejected Records, 44
OLAP metadata
upgrading OLAP 10g to OLAP 12c, 42
OLAP PL/SQL packages
DBMS_AW_STATS, 33
DBMS_CUBE, 42
DBMS_CUBE_ADVISE, 43
DBMS_CUBE_LOG, 44
OLAP templates
validation, 42
writing to XML files, 42
OLAP_DBA role, 42
OLAP_USER role, 42, 42
OLD_CURRENT_SCHEMA Function, 172
OLD_CURRENT_USER Function, 172
OLISTCLOSE function
of HTF package, 205
OLISTCLOSE procedure
of HTP package, 206
OLISTOPEN function
of HTF package, 205
OLISTOPEN procedure
of HTP package, 206
ONLINE_INDEX_CLEAN Function, 122
OPEN Procedures, 87
OPEN_CONNECTION function, 263
OPEN_CONNECTION functions, 261
OPEN_CURSOR function, 147
OPEN_CURSOR Function, 78
OPEN_DATA function and procedure, 261
OPEN_WINDOW Procedure
OPEN_WINDOW Procedure, 138
optimizer statistics, 33
OR REPLACE clause
for creating packages, 1
Oracle Data Mining, 45
Oracle Streams
administrator
granting privileges, 159
revoking privileges, 159
advisors, 158
change data capture
configuring, 157
compatibility, 156, 156, 156, 156, 156, 156, 273
creating queues, 157
data dictionary
removing information, 157
messaging
notification, 157
privileges, 159
replication
configuring, 157, 157, 157, 157, 157, 157, 157, 157
Oracle XStream
creating queues, 202
data dictionary
removing information, 202
Oracle-supplied types
logical change record (LCR) types, 273
rule types, 281
ORD_DICOM package documentation, 207
ORD_DICOM_ADMIN package documentation, 208
outbound servers
rules, 157
OVERLAY function, 258
OVERRIDE_PRIORITY Procedures, 32
OWA_CACHE package, 209
OWA_COOKIE package, 210
OWA_CUSTOM package, 211
OWA_IMAGE package, 212
OWA_OPT_LOCK package, 213
OWA_PATTERN package, 214
OWA_SEC package, 215
OWA_TEXT package, 216
OWA_UTIL package, 217
OWNER Function, 245

P

PACK_MESSAGE procedures, 110
PACK_STGTAB_BASELINE Function, 146
PACK_STGTAB_DIRECTIVE Function, 145
PACK_STGTAB_SQLPATCH Procedure, 150
PACK_STGTAB_SQLPROF Procedure, 152
PACK_STGTAB_SQLSET Procedure, 152
package
DBMS_ODCI, 102
DBMS_XDB, 179
DBMS_XMLDOM, 189
DBMS_XMLGEN, 190
DBMS_XMLPARSER, 192
DBMS_XMLQUERY, 193
DBMS_XMLSAVE, 194
DBMS_XMLSCHEMA, 195
UriFactory, 271
Package - UriFactory, 271
package overview, 1
package variables
i_am_a_refresh, 99
packages
creating, 1
DBMS_MGD_ID_UTL, 95
referencing, 1
where documented, 1
PARA function
of HTF package, 205
PARA procedure
of HTP package, 206
PARAGRAPH function
of HTF package, 205
PARAGRAPH procedure
of HTP package, 206
PARAM function
of HTF package, 205
PARAM procedure
of HTP package, 206
PARSE procedure, 147, 192
PARSE Procedure, 78
PARSEBUFFER procedure, 192
PARSECLOB procedure, 192
PARSEDTD procedure, 192
PARSEDTDBUFFER procedure, 192
PARSEDTDCLOB procedure, 192
PATCH_CONFLICT_DETECTION Function, 116
PATCHREPOSITORYRESCONFIGLIST Procedure, 128
PATH_ITEM_T Record Type, 48
PATH_ITEMS_T Table Type, 48
PATHIDTABLE Function, 41
PAUSE_PROFILER function and procedure, 114
PAUSE_REPLAY Procedure, 176
PIECEWISE member procedure
of ANYDATA TYPE, 266
of ANYDATASET TYPE, 267
PING procedure, 53
PLAINTEXT function
of HTF package, 205
PLAINTEXT procedure
of HTP package, 206
plan stability, 104
PL/SQL
datatypes, 58
numeric codes for, 58
functions
DBMS_MGWADM package subprograms, 96
DBMS_MGWMSG package subprograms, 97
procedures
DBMS_MGWADM package subprograms, 96
DBMS_MGWMSG package subprograms, 97
PL/SQL package
DBMS_HS_PARALLEL, 77
PLSQL_TRACE_VERSION procedure, 165
pointer to
CTX_ADM package, 6
CTX_ANL package, 7
point-in-time recovery
Oracle Streams, 157
POISSON_DIST_FIT procedure, 154
POLICY_CONDITION Table Type, 169
POPULATE_DIVERGENCE Procedure, 176
PORT_STRING Function, 172
POST_INSTANTIATION_SETUP procedure, 157
PRE_INSTANTIATION_SETUP procedure, 157
PRECLOSE function
of HTF package, 205
PRECLOSE procedure
of HTP package, 206
predictive analytics, 111
PREOPEN function
of HTF package, 205
PREOPEN procedure
of HTP package, 206
PREPARE Procedure, 176
PREPARE_COLUMN_VALUES procedures, 153, 153
PREPARE_COLUMN_VALUES_NVARCHAR2 procedure, 153
PREPARE_COLUMN_VALUES_ROWID procedure, 153
PREPARE_CONSOLIDATED_REPLAY Procedure, 176
PREPARE_GLOBAL_INSTANTIATION procedure, 34
PREPARE_SCHEMA_INSTANTIATION procedure, 34
PREPARE_SYNC_INSTANTIATION function, 34
PREPARE_TABLE_INSTANTIATION procedure, 34
PREVIEW_ILM Procedure, 79
PRINT function
of HTF package, 205
PRINT procedure
of HTP package, 206
PRINT_BACKTRACE procedure, 53
PRINT_CGI_ENV procedure, 217
PRINT_INSTANTIATIONS procedure, 53
PRINT_MULTI procedure, 216
PRINT_POST_PROCESSED_SOURCE Procedure, 112
PRINT_ROW_LIST procedure, 216
PRINTS procedure
of HTP package, 206
PRINTWARNINGS Procedur, 196
privileges
GoldenGate administrator, 72, 72
Oracle Streams administrator, 159, 159
XStream administrator, 203, 203
PRN function
of HTF package, 205
PRN procedure
of HTP package, 206
PROBE_VERSION procedure, 53
PROCESS_CAPTURE Procedure, 176
PROCESS_PENDING Procedure, 191
PROCESSLINKS Procedure, 183
PROCESSXSL function, 201
PROGRAM_INFO Record Type, 53
PROP_ITEM_T Record Type, 48
PROP_ITEMS_T Table Type, 48
PROPAGATEORIGINALEXCEPTION procedure, 193, 194
propagations
altering, 115
creating, 115, 157, 157, 157, 157, 157, 202, 202, 202, 202
DBMS_PROPAGATION_ADM package, 115
dropping, 115
propagation user, 157
rules
defining global, 157, 202
defining message, 157
defining schema, 157, 202
defining subset, 157, 202
defining table, 157, 202
for LCRs, 157
for user messages, 157
starting, 115
stopping, 115
PROPANY Functions, 48
PROPERTIES_T Table Type, 48
PROPERTIESH2T Function, 48
PROPERTIEST2H Function, 48
PROPERTY_T Record Type, 48
PROPNUMBER Function, 48
PROPRAW Function, 48
PROPTIMESTAMP Function, 48
PROPVARCHAR2 Function, 48
PS procedure
of HTP package, 206
PUBLISH_PENDING_STATS Procedure, 153
PULL_SIMPLE_TABLESPACE procedure, 162
PULL_TABLESPACES procedure, 162
PURGE procedure, 110
PURGE Procedure, 142
PURGE_COMPARISON Procedure, 35
PURGE_CONTEXT Procedure, 71
PURGE_FILE_GROUP procedure, 68
PURGE_LOST_DB_ENTRY procedure, 166
PURGE_MIXED procedure, 166
PURGE_PROCESSED_CHUNKS Procedure, 106
PURGE_QUEUE_TABLE Procedure, 25
PURGE_SOURCE_CATALOG procedure, 157, 202
PURGE_SQL_DETAILS Procedure, 177
PURGE_STATS procedure, 153
PURGEALL Procedure, 48, 49
PURGELDAPCACHE function, 187
PURGEPATH Procedure, 48, 49
PURGERESOURCEMETADATA Procedure, 183
PURGESCHEMA Procedure, 195
PUT procedure, 249
PUT procedures, 105
PUT_FILE procedure, 69
PUT_LINE Procedure, 249
PUT_LINE procedures, 105
PUT_LINE_NCHAR procedure, 249
PUT_NCHAR procedure, 249
PUT_RAW function, 249
PUTF procedure, 249
PUTF_NCHAR procedure, 249
PUTPATH Procedures, 48, 49

Q

QNAMEIDTABLE Function, 41
QUALIFIED_SQL_NAME Function, 28
queues
AnyData
creating, 157, 202
removing, 157, 202
QUICK_TUNE Procedure, 19
QUIT function and procedure, 261
QUOTED_PRINTABLE_DECODE function, 248
QUOTED_PRINTABLE_ENCODE function, 248

R

RANDOM procedure, 117
RCPT function, 261
RE$ATTRIBUTE_VALUE type, 281
RE$ATTRIBUTE_VALUE_LIST type, 281
RE$COLUMN_VALUE type, 281, 281
RE$COLUMN_VALUE_LIST type, 281
RE$NAME_ARRAY type, 281
RE$NV_ARRAY type, 281
RE$NV_LIST type, 281
ADD_PAIR member procedure, 281
GET_ALL_NAMES member function, 281
GET_VALUE member function, 281
REMOVE_PAIR member procedure, 281
RE$RULE_HIT type, 281
RE$RULE_HIT_LIST type, 281
RE$TABLE_ALIAS type, 281
RE$TABLE_ALIAS_LIST type, 281
RE$TABLE_VALUE type, 281
RE$TABLE_VALUE_LIST type, 281
RE$VARIABLE_TYPE type, 281
RE$VARIABLE_TYPE_LIST type, 281
RE$VARIABLE_VALUE type, 281
RE$VARIABLE_VALUE_LIST type, 281
READ Procedures, 87
READ_CLIENT_INFO procedure, 22
READ_LINE function, 263
READ_LINE procedure
of UTL_HTTP, 250
READ_MODULE procedure, 22
READ_ONLY procedure, 166
READ_RAW function, 263
READ_RAW procedure
of UTL_HTTP, 250
READ_TEXT function, 263
READ_TEXT procedure
of UTL_HTTP, 250
READ_WRITE procedure, 166
READ2CLOB function, 201
REAL_TIME_ADDM_REPORT Function, 17
Real-time SQL Monitoring Subprograms, 152
REASSOCIATE_FBA Procedure, 71
REBUILD_FREELISTS procedure, 122
REBUILDHIERARCHICALINDEX Procedure, 180
RECEIVE_MESSAGE function, 110
RECHECK Function, 35
RECOMP_PARALLEL procedure, 259
RECOMP_SERIAL procedure, 259
RECONFIGCACHE Procedure, 50
RECOVER_OPERATION procedure, 202
REDEF_TABLE Procedure, 120
REDIRECT_URL procedure, 217
refresh
materialized views, 99, 99, 99
REFRESH_CATEGORY function, 95
REFRESH_GROUPED_POLICY Procedure, 133
REFRESH_MVIEW procedure, 42, 42
REFRESH_POLICY Procedure, 133
REGISTER Procedure, 20
REGISTER_APPLICATION Procedure, 71
REGISTER_DEPENDENT_OBJECT procedure, 120
REGISTER_ERROR_TRANSLATION Procedure, 148
REGISTER_FOREIGN_QUEUE Procedure, 96
REGISTER_SQL_TRANSLATION Procedure, 148
REGISTERPARAMETER Procedure, 191
REGISTERSCHEMA procedure, 195
REGISTERSTORE Procedure, 48
REGISTERSTORECOMMAND Procedur, 50
REGISTERURI procedure, 195
REGISTERURLHANDLER procedure, 271
RELEASE function, 88
REMAP_CONNECTION Procedure, 176
REMAP_STAT_TABLE Procedure, 153
REMAP_STGTAB_SQLPROF Procedure, 152
REMAP_STGTAB_SQLSET Procedure, 152
REMOVE procedure
of DBMS_ALERT package, 20
of DBMS_JOB package, 83
of OWA_COOKIE package, 210
REMOVE Procedure, 188
REMOVE_AGENT Procedure, 96
REMOVE_CAPTURE Procedure, 176
REMOVE_CATEGORY procedure, 95
REMOVE_COLORED_SQL Procedure, 177
REMOVE_DISCOVERY_RESULT Procedure, 168
REMOVE_FILE procedure, 68
REMOVE_FROM_ILM Procedure, 79
REMOVE_HOST_ACE Procedure, 100
REMOVE_JOB Procedure, 96
REMOVE_MSGSYSTEM_LINK Procedure, 96
REMOVE_OPTION Procedure, 96
REMOVE_PAIR member procedure, 281
REMOVE_PIPE function, 110
REMOVE_PROXY procedure, 95
REMOVE_QUEUE procedure, 157, 202
REMOVE_RULE procedure, 137, 157, 202
REMOVE_SCHEDULE_ORDERING Procedure, 176
REMOVE_SCHEME procedure, 95
REMOVE_SQLSET_REFERENCE procedure, 152
REMOVE_STMT_FROM_HANDLER procedure, 160
REMOVE_STMT_HANDLER procedure, 23
REMOVE_STREAMS_CONFIGURATION procedure, 157
REMOVE_SUBSCRIBER Procedure, 96
REMOVE_SUBSET_OUTBOUND_RULES procedure, 202
REMOVE_TABLE_FROM_APPLICATION, 71
REMOVE_WALLET_ACE Procedure, 100
REMOVE_XSTREAM_CONFIGURATION procedure, 202
REMOVEALL procedure, 20
REMOVEANYSTORAGE Procedure, 196
REMOVEATTRIBUTE procedure, 189
REMOVEATTRIBUTENODE function, 189
REMOVEDEFAULTTABLE Procedure, 196
REMOVEMAINTAINDOM Procedure, 196
REMOVENAMEDITEM function, 189
REMOVEOUTOFLINE Procedure, 196
REMOVEPARAM procedure, 201
REMOVESQLCOLLTYPE Procedure, 196
REMOVESQLNAME Procedure, 196
REMOVESQLTYPE Procedure, 196
REMOVESQLTYPEMAPPING Procedure, 196
REMOVETABLEPROPS Procedure, 196
REMOVETIMESTAMPWITHTIMEZONE Procedure, 196
REMOVEXSLTPARAM procedure, 193, 194
RENAME_BASELINE Procedure, 177
RENAME_COLUMN member procedure, 273
RENAME_COLUMN procedure, 157, 202
RENAME_SCHEMA procedure, 157, 202
RENAME_TABLE procedure, 157, 202
RENAMECOLLECTIONTABLE Procedure, 197
RENAMEPATH Procedure, 49
RENAMEPATH Procedures, 48
RENAMERESOURCE Procedure, 183
REPLACECHILD function, 189
REPLACEDATA procedure, 189
REPLAY_SQL_TESTCASE Procedure, 150
replication
Oracle Streams
configuring, 157, 157, 157, 157, 157, 157, 157, 157
split and merge, 157, 157, 157, 202, 202, 202
REPLY, REPLIES record types, 261
REPORT Function, 175, 176
REPORT_ANALYSIS_TASK Function, 151
REPORT_AUTO_EVOLVE_TASK Function, 146
REPORT_AUTO_TUNING_TASK Function, 152
REPORT_COL_USAGE Procedure, 153
REPORT_DIAGNOSIS_TASK Function, 150
REPORT_EVOLVE_TASK Function, 146
REPORT_GATHER_AUTO_STATS Function, 153
REPORT_GATHER_DATABASE_STATS Functions, 153
REPORT_GATHER_DICTIONARY_STATS Functions, 153
REPORT_GATHER_FIXED_OBJ_STATS Function, 153
REPORT_GATHER_SCHEMA_STATS Functions, 153
REPORT_GATHER_TABLE_STATS Function, 153
REPORT_REPOSITORY_DETAIL Function, 31
REPORT_REPOSITORY_DETAIL_XML Function, 31
REPORT_REPOSITORY_LIST_XML Procedure, 31
REPORT_SINGLE_STATS_OPERATION Function, 153
REPORT_SQL_DETAIL Function, 152
REPORT_SQL_MONITOR Function, 149, 152
REPORT_SQL_MONITOR_LIST Function, 149, 152
REPORT_STATS_OPERATIONS Function, 153
REPORT_TUNING_TASK function, 30, 152
REQUEST function, 88, 250
REQUEST_PIECES function, 250
RESET_ANALYSIS_TASK Procedure, 151
RESET_BUFFER procedure, 110
RESET_DIAGNOSIS_TASK Procedure, 150
RESET_EVOLVE_TASK Procedure, 146
RESET_GLOBAL_PREFS_DEFAULTS Procedure, 153
RESET_JOB Procedure, 96
RESET_PACKAGE Procedure, 141
RESET_PARAM_DEFAULTS Procedure, 153
RESET_SQLWKLD Procedure, 19
RESET_SUBSCRIBER Procedure, 96
RESET_TASK Procedure, 19
RESET_TUNING_TASK procedure, 152
RESETPARAMS procedure, 201
RESOLVENAMESPACEPREFIX function, 189
RESTARTQUERY procedure, 190
RESTORE function, 155
RESTORE_DATBASE_STATS procedure, 153
RESTORE_DEFAULTS Procedure, 37
RESTORE_DICTIONARY_STATS procedure, 153
RESTORE_FIXED_OBJECTS_STATS procedure, 153
RESTORE_SCHEMA_STATS procedure, 153
RESTORE_SYSTEM_STATS procedure, 153
RESTORE_TABLE_STATS procedure, 153
RESTOREALL Procedure, 48, 49
RESTOREPATH Procedure, 48, 49
RESUME_ANALYSIS_TASK Procedure, 151
RESUME_DIAGNOSIS_TASK Procedure, 150
RESUME_EVOLVE_TASK Procedure, 146
RESUME_PROFILER function and procedure, 114
RESUME_REPLAY Procedure, 176
RESUME_TASK Procedure, 106
RESUME_TUNING_TASK Procedure, 152
RETURN_RESULT Procedures, 147
REUSE_REPLAY_FILTER_SET Procedure, 176
REVERSE function, 258
REVOKE_ADMIN_PRIVILEGE procedure, 72, 159, 203
REVOKE_OBJECT_PRIVILEGE procedure, 68, 137
REVOKE_REMOTE_ADMIN_ACCESS procedure, 159, 203
REVOKE_SWITCH_CONSUMER_GROUP procedure, 130
REVOKE_SYSTEM_PRIVILEGE procedure, 68, 130, 137
ROLLBACK procedure, 166
ROLLBACK_FORCE procedure, 166
ROLLBACK_SAVEPOINT procedure, 166
row migration, 157, 157, 202, 202
ROWID datatype
extended format, 135
ROWID_BLOCK_NUMBER function, 135
ROWID_CREATE function, 135
ROWID_INFO procedure, 135
ROWID_OBJECT function, 135
ROWID_RELATIVE_FNO function, 135
ROWID_ROW_NUMBER function, 135
ROWID_TO_ABSOLUTE_FNO function, 135
ROWID_TO_EXTENDED function, 135
ROWID_TO_RESTRICTED function, 135
ROWID_TYPE function, 135
ROWID_VERIFY function, 135
rule sets
adding rules to, 137
creating, 137
dropping, 137
removing rules from, 137
rule-based transformations
setting, 157
rules
action contexts
adding name-value pairs, 281
getting name-value pairs, 281
getting value for name, 281
removing name-value pairs, 281
transformations, 157
altering, 137
creating, 137
DBMS_RULE package, 136
DBMS_RULE_ADM package, 137
dropping, 137
evaluation, 136
iterators, 136, 136
evaluation contexts
altering, 137
creating, 137
dropping, 137
fast evaluation, 136
inbound servers, 157
object privileges
granting, 137
revoking, 137
outbound servers, 157
propagations
removing, 157, 202
RE$ATTRIBUTE_VALUE type, 281
RE$ATTRIBUTE_VALUE_LIST type, 281
RE$COLUMN_VALUE type, 281, 281
RE$COLUMN_VALUE_LIST type, 281
RE$NAME_ARRAY type, 281
RE$NV_ARRAY type, 281
RE$NV_LIST type, 281
RE$RULE_HIT type, 281
RE$RULE_HIT_LIST type, 281
RE$TABLE_ALIAS type, 281
RE$TABLE_ALIAS_LIST type, 281
RE$TABLE_VALUE type, 281
RE$TABLE_VALUE_LIST type, 281
RE$VARIABLE_TYPE type, 281
RE$VARIABLE_TYPE_LIST type, 281
RE$VARIABLE_VALUE type, 281
RE$VARIABLE_VALUE_LIST type, 281
subset
defining, 157, 157, 202, 202
system privileges
granting, 137
revoking, 137
system-created, 157
global apply, 157, 202
global capture, 157, 202
global propagation, 157, 202
global schema, 157, 202
message, 157, 157
message propagation, 157
removing, 157, 202
schema capture, 157, 202
schema propagation, 157, 202
subset apply, 157, 202
subset capture, 157, 202
subset propagation, 157, 202
table apply, 157, 202
table capture, 157, 202
table propagation, 157, 202
types, 281
RUN procedure, 83
RUN_CHECK Procedure, 75
RUN_TASK Procedure, 106
RUNTIME_INFO Record Type, 53

S

S function
of HTF package, 205
S procedure
of HTP package, 206
SAM (SQL Aggregation Management), 42
SAMPLE function
of HTF package, 205
SAMPLE procedure
of HTP package, 206
SAVE function, 155
SAVE Procedure, 185
SAVEPOINT procedure, 166
SCHEDULE_PROPAGATION Procedure, 25, 96
SCHEMA_NAME Function, 28
SCHEMAELEM_RES_ACL Function, 182
SCHEMAELEM_RESCONTENT_BINARY Function, 182
SCHEMAELEM_RESCONTENT_TEXT Function, 182
SCHEMAURL_ACL Function, 182
SCHEMAURL_RESOURCE Function, 182
SCHEMAURL_XDBSCHEMA Function, 182
SCHEMAVALIDATE procedure, 283
SCOPEXMLREFERENCES Procedure, 197
SCRIPT function
of HTF package, 205
SCRIPT procedure
of HTP package, 206
SCRIPT_TUNING_TASK Function, 152
SDO_CS package documentation, 218
SDO_CSW_PROCESS package documentation, 219
SDO_GCDR package documentation, 220
SDO_GEOM package documentation, 221
SDO_GEOR package documentation, 222
SDO_GEOR_ADMIN package documentation, 223
SDO_GEOR_UTL package documentation, 226
SDO_LRS package documentation, 227
SDO_MIGRATE package documentation, 228
SDO_NET package documentation, 229
SDO_OLS package documentation, 230
SDO_PC_PKG package documentation, 231
SDO_SAM package documentation, 232
SDO_TIN_PKG package documentation, 233
SDO_TOPO package documentation, 234
SDO_TOPO_MAP package documentation, 235
SDO_TUNE package documentation, 236
SDO_UTIL package documentation, 237
SDO_WFS_LOCK package documentation, 238
SDO_WFS_PROCESS package documentation, 239
SEARCH Function, 49
SECURE_CONNECTION Procedure, 263
security
XStream, 202
SEED procedures, 117
SEED_COL_USAGE Procedures, 153
SEGMENT_CORRUPT procedure, 144
SEGMENT_DROP_CORRUPT procedure, 144
SEGMENT_DUMP procedure, 144
SEGMENT_FIX_STATUS procedure, 122
SEGMENT_HEAT_MAP Procedure, 74
SEGMENT_VERIFY procedure, 144
SELECT_BASELINE_METRIC Function, 177
SELECT_CURSOR_CACHE Function, 152
SELECT_OBJECT procedure, 260
SELECT_SQL_TRACE Function, 152
SELECT_SQLSET function, 152, 152, 152, 152
SELECT_WORKLOAD_REPOSITORY functions, 152
SELECTNODES function, 201
SELECTSINGLENODE function, 201
SELF_CHECK procedure, 53
SEM_APIS package documentation, 240
SEM_PERF package documentation, 242
SEM_RDFSA package documentation, 243, 244
SEND procedure, 210, 255
SEND_ATTACH_RAW procedure, 255
SEND_ATTACH_VARCHAR2 procedure, 255
SEND_MESSAGE function, 110
SENDCOMMAND Procedures, 50
SERV_MOD_ACT_STAT_DISABLE procedure, 98
SERV_MOD_ACT_STAT_ENABLE procedure, 98
SERV_MOD_ACT_TRACE_DISABLE procedure, 98
SERV_MOD_ACT_TRACE_ENABLE procedure, 98
SESSION _TRACE_DISABLE Procedure, 141
SESSION _TRACE_ENABLE Procedur, 141
SESSION_TRACE_DISABLE procedure, 98
SESSION_TRACE_ENABLE procedure, 98
SET* member procedures
of ANYDATA TYPE, 266
of ANYDATASET TYPE, 267
SET_ACTION procedure, 22
SET_ADVANCED_PARAMETER Procedure, 176
SET_ANALYSIS_DEFAULT_PARAMETER Procedures, 151
SET_ANALYSIS_TASK_PARAMETER Procedure, 151
SET_ATTRIBUTE Procedure, 148
SET_AUDIT_TRAIL_LOCATION procedure, 29
SET_AUDIT_TRAIL_PROPERTY procedure, 29
SET_AUTHENTICATION procedure, 250
SET_AUTHENTICATION_FROM_WALLET Procedure, 250
SET_AUTHORIZATION procedure, 215
SET_AUTO_TUNING_TASK_PARAMETER Procedures, 30
SET_BASE_TABLE_NAME member procedure, 273
SET_BASE_TABLE_OWNER member procedure, 273
SET_BODY_CHARSET procedures, 250, 250
SET_BREAKPOINT function, 53
SET_CHANGE_HANDLER procedure, 23
SET_CHUNK_STATUS Procedure, 106
SET_CLIENT_INFO procedure, 22
SET_CLIENT_SERVICE Procedure, 32
SET_CNS_EXCEPTION_LOG procedure, 43
SET_COLUMN_STATS procedures, 153
SET_COMMAND_TYPE member procedure, 273
SET_CONSUMER_GROUP_MAPPING procedure, 129
SET_CONSUMER_GROUP_MAPPING_PRI procedure, 129
SET_CONTEXT Procedure, 141
SET_CONTEXT_LEVEL Procedure, 71
SET_COOKIE_SUPPORT procedures, 250
SET_CURRENT_OPINST Procedure, 116
SET_CURRENT_SCHEMA member procedure, 273
SET_DAD_ATTRIBUTE Procedure, 65
SET_DATABASE_PREFS Procedure, 153
SET_DBFS_LINK Procedures, 87
SET_DDL_TEXT member procedure, 273
SET_DEFAULT_SQLWKLD_PARAMETER Procedure, 19
SET_DEFAULT_TASK_PARAMETER Procedures, 19
SET_DEFAULTS procedure, 20
SET_DETAILED_EXCP_SUPPORT procedure, 250
SET_DIAGNOSIS_TASK_PARAMETER Procedure, 150
SET_DML_HANDLER procedure, 23
SET_EDITION_DEFERRED Procedure, 141
SET_EDITIONING_VIEWS_READ_ONLY Procedure, 64
SET_ENQUEUE_DESTINATION procedure, 23
SET_EVOLVE_TASK_PARAMETER Function, 146
SET_EXECUTE procedure, 23
SET_EXPRESSION procedure, 46
SET_EXTRA_ATTRIBUTE member procedure, 273
SET_FOLLOW_REDIRECT procedures, 250
SET_GLOBAL_ATTRIBUTE Procedure, 65
SET_GLOBAL_INSTANTIATION procedure, 23
SET_GLOBAL_PREFS Procedure, 153
SET_HEADER procedure, 250
SET_HEAT_MAP_ALL Procedure, 80
SET_HEAT_MAP_START Procedure, 80
SET_HEAT_MAP_TABLE Procedure, 80
SET_HOST_ACL Procedure, 100
SET_IDENTIFIER, 141
SET_INDEX_STATS procedures, 153
SET_INITIAL_CONSUMER_GROUP procedure, 129
SET_JAVA_LOGGING_LEVEL procedure, 95
SET_KEY_COLUMNS procedure, 23
SET_LAST_ARCHIVE_TIMESTAMP procedure, 29
SET_LOB_INFORMATION member procedure, 273
SET_LOB_OFFSET member procedure, 273
SET_LOB_OPERATION_SIZE member procedure, 273
SET_LOG_LEVEL Procedure, 96
SET_LOG_SPEC procedure, 44
SET_LOGON_USER member procedure, 273
SET_MAILHOST Procedure, 26
SET_MAILPORT Procedure, 26
SET_MAX_STREAMS_POOL Procedure, 25
SET_MESSAGE_NOTIFICATION procedure, 157
SET_MESSAGE_TRACKING procedure, 157
SET_MIN_STREAMS_POOL Procedure, 25
SET_MODULE procedure, 22
SET_NLS Procedure, 141
SET_NULL_COLUMN_VALUES_TO_EXPR Procedure, 64
SET_OBJECT_NAME member procedure, 273
SET_OBJECT_OWNER member procedure, 273, 273
SET_OBJECT_TYPE member procedure, 273
SET_OER_BREAKPOINT function, 53
SET_OPTION Procedure, 96
SET_P1_RESOURCES Procedure, 32
SET_PARAM procedure, 153
SET_PARAMETER procedure, 34, 44, 202
apply process, 23
SET_PERSISTENT_CONN_SUPPORT procedure, 250
SET_PLSQL_LOGGING_LEVEL procedure, 95
SET_PLSQL_TRACE procedure, 165
SET_PREFS Procedure, 145
SET_PROCESSING_RATE Procedure, 153
SET_PROTECTION_REALM procedure, 215
SET_PROXY procedure, 95, 250
SET_PURGE_JOB_INTERVAL procedure, 29
SET_PURGE_JOB_STATUS procedure, 29
SET_REPLAY_DIRECTORY Procedure, 176
SET_REPLAY_TIMEOUT Procedure, 176
SET_RESPONSE_ERROR_CHECK procedure, 250
SET_ROLE Procedure, 141
SET_ROWID_THRESHOLD Procedure, 38
SET_RULE_TRANSFORM_FUNCTION procedure, 157
SET_SCHEMA_INSTANTIATION procedure, 23
SET_SCHEMA_PREFS Procedure, 153
SET_SENDFROM Procedure, 26
SET_SESSION_LONGOPS procedure, 22
SET_SESSION_TIMEOUT procedure, 132
SET_SOURCE_DATABASE_NAME member procedure, 273
SET_SQL_TRACE Procedure, 141
SET_SQLWKLD_PARAMETER Procedure, 19
SET_SYSTEM_STATS procedure, 153
SET_TABLE_INSTANTIATION procedure, 23
SET_TABLE_PREFS Procedure, 153
SET_TABLE_STATS procedure, 153
SET_TAG member procedure, 273
SET_TAG procedure, 156, 157, 202
SET_TASK_PARAMETER Procedure, 19
SET_THRESHOLD procedure, 139
SET_TIMEOUT function, 53
SET_TIMEOUT procedure, 132
SET_TIMEOUT_BEHAVIOUR procedure, 53
SET_TRANSFER_TIMEOUT procedure, 250
SET_TRANSFORM procedure, 46
SET_TRIGGER_FIRING_PROPERTY procedure, 54
SET_TUNING_TASK_PARAMETER Function, 152
SET_UP_QUEUE procedure, 157, 202
SET_UPDATE_CONFLICT_HANDLER procedure, 23
SET_USER_MAPPING Procedure, 176
SET_VALUE function, 53
SET_VALUE member procedure, 273
SET_VALUE_DEPENDENCY procedure, 23
SET_VALUES member procedure, 273
SET_WALLET procedure, 250
SET_WALLET_ACL Procedure, 100
SET_WARNING_SETTING_STRING procedure, 173
SET_WATERMARK Procedure, 25
SET_XML_INFORMATION member procedure, 273
SETACL Procedure, 183, 185
SETANYSTORAGE Procedure, 196
SETATTRIBUTE procedure, 189
SETATTRIBUTENODE function, 189
SETAUTHOR Procedure, 185
SETBASEDIR procedure, 192
SETBATCHSIZE procedure, 194
SETBINDVALUE procedure, 193
SETCHARACTERSET Procedure, 185
SETCHARSET Procedure, 189
SETCOLLIDATTRNAME procedure, 193
SETCOMMENT Procedure, 185
SETCOMMITBATCH procedure, 194
SETCONTENT Procedures, 185
SETCONTENTTYPE Procedure, 87, 185
SETCONVERTSPECIALCHARS procedure, 190
SETCUSTOMMETADATA Procedure, 185
SETDATA procedure, 189
SETDATAHEADER procedure, 193
SETDATEFORMAT procedure, 193, 194
SETDCHARSET procedure, 189
SETDEFAULTACL Procedure, 48
SETDEFAULTASOF Procedur, 48
SETDEFAULTCONTEXT Procedure, 48
SETDEFAULTOWNER Procedure, 48
SETDEFAULTPRINCIPAL Procedure, 48
SETDEFAULTTABLE Procedure, 196
SETDISPLAYNAME Procedure, 185
SETDOCTYPE procedure, 192
SETDOCTYPE Procedure, 189
SETDVERSION procedure, 189
SETENCODINGTAG procedure, 193
SETERRORLOG procedure, 192, 201
SETERRORTAG procedure, 193
SETFTPPORT Procedure, 181
SETHTTPPORT Procedure, 181
SETHTTPSPORT Procedure, 181
SETIGNORECASE procedure, 194
SETINFO member procedure
of ANYTYPE TYPE, 268
SETKEYCOLUMN procedure, 194, 198
SETLANGUAGE Procedure, 185
SETLISTENERENDPOINT Procedure, 181
SETLISTENERLOCALACCESS Procedure, 181
SETMAXROWS procedure, 190, 193
SETMETAHEADER procedure, 193
SETNAMEDITEM function, 189
SETNODEVALUE procedure, 189
SETNODEVALUEASBINARYSTREAM Function & Procedure, 189
SETNODEVALUEASCHARACTERSTREAM Function & Procedure, 189
SETOPTIONS Procedure, 87
SETOUTOFLINE Procedure, 196
SETOWNER Procedure, 185
SETPARAM procedure, 201
SETPATH Procedure, 49
SETPATH Procedures, 48
SETPREFIX procedure, 189
SETPRESERVEWHITESPACE procedure, 192, 194
SETRAISEEXCEPTION procedure, 193
SETRAISENOROWSEXCEPTION procedure, 193
SETRENDERPATH Procedure, 188
SETRENDERSTREAM Procedure, 188
SETROWIDATTRNAME procedure, 193
SETROWIDATTRVALUE procedure, 193
SETROWSETTAG procedure, 190, 193
SETROWTAG procedure, 193, 194, 198
SETSCHEMAANNOTATATIONS Procedure, 196
SETSCHEMAVALIDATED procedure, 283
SETSKIPROWS procedure, 190, 193
SETSOURCELANG Function, 199
SETSQLCOLLTYPE Procedure, 196
SETSQLNAME Procedure, 196
SETSQLTOXMLNAMEESCAPING procedure, 193, 194
SETSQLTYPE Procedure, 196
SETSQLTYPEMAPPING Procedure, 196
SETSTANDALONE procedure, 189
SETSTATS Procedure, 48
SETSTOREPROPERTY Procedure, 50
SETSTYLESHEETHEADER procedure, 193
SETTABLEPROPS Procedure, 196
SETTAGCASE procedure, 193
SETTIMESTAMPWITHTIMEZONE Procedure, 196
SETTRACE Procedure, 48
SETUPDATECOLUMN procedure, 194, 198
SETVALIDATIONMODE procedure, 192
SETVALUE procedure, 189
SETXSLT procedure, 193, 194
SETXSLTPARAM procedure, 193, 194
SHOW_BREAKPOINTS procedures, 53
SHOW_EXTENDED_STATS_NAME Function, 153
SHOW_FRAME_SOURCE procedure, 53
SHOW_SOURCE procedures, 53
SHOW_STATS procedure, 262
SHOW_STATS_HTML procedure, 262
SHOWPAGE procedure, 217
SHOWSOURCE procedure, 217
SHOWWARNINGS procedure, 192, 201
SHUTDOWN Procedure, 96
SIGNAL procedure, 20
SIGNATURE procedure, 217
SIMPLE_SQL_NAME Function, 28
SIZES procedure, 142
SKIP_CORRUPT_BLOCKS procedure, 122
SLEEP procedure, 88
SMALL function
of HTF package, 205
SMALL procedure
of HTP package, 206
snapshot. See DBMS_MVIEW, 99
SOURCE_LINES_T Table Type, 112
SPACE_ERROR_INFO function, 132
SPACE_USAGE procedure, 143
SPACEUSAGE Procedure, 48, 49
split streams, 157, 202
SPLIT_STREAMS procedure, 157, 202
SPLITPATH Procedure, 183
SPLITTEXT function, 189
SQL Apply
managing logical standby databases, 91
managing with DBMS_LOGSTDBY package, 91
SQL generation, 273, 273
SQL Performance Reporting Subprograms, 152
SQL*Plus
creating a sequence, 1
SQL_HASH Function, 148
SQL_ID Function, 148
SQL_OBJECT_NAME Function, 28
SQLID_TO_SQLHASH Function, 172
SQLSET_ROW Object Type, 152
SQLTEXT_TO_SIGNATURE Function, 152
STACK_BIN_CAT procedure, 46
STACK_BIN_NUM procedure, 46
STACK_CLIP procedure, 46
STACK_COL_REM procedure, 46
STACK_MISS_CAT procedure, 46
STACK_MISS_NUM procedure, 46
STACK_NORM_LIN procedure, 46
staging
queues
creating, 157, 202
removing, 157, 202
START__CONSOLIDATED_REPLAY Procedure, 176
START_APPLY procedure, 23
START_CAPTURE procedure, 34
START_CAPTURE Procedure, 175
START_OUTBOUND procedure, 202, 202
START_POOL Procedure, 37
START_PROFILER functions and procedures, 114
START_PROFILING Procedure, 76
START_PROPAGATION procedure, 115
START_REDEF_TABLE procedure, 120
START_REPLAY Procedure, 176
START_REPORT_CAPTURE Procedure, 31
START_SERVICE procedure, 140
STARTTLS Function and Procedure, 261
STARTUP Procedure, 96
STARTUP_EXTPROC_AGENT procedure, 204
STATUS Function, 131
STATUS_LINE procedure, 217
STEP_ID function, 166
STOP_APPLY procedure, 23
STOP_CAPTURE procedure, 34
STOP_ILM Procedure, 79
STOP_POOL Procedure, 37
STOP_PROFILER function and procedure, 114
STOP_PROFILING Procedure, 76
STOP_PROPAGATION procedure, 115
STOP_SERVICE procedure, 140
STOP_TASK Procedure, 106
STORE_T Record Type, 48
STORE_VALUES procedure, 213
stored outlines
DBMS_OUTLN, 104
OUTLN_PKG package, 104
STOREPUSH Procedure, 50
STREAM2MULTI procedure, 216
Streams
removing configuration, 157
STREAMS$_TRANSFORM_FUNCTION, 157
STRIKE function
of HTF package, 205
STRIKE procedure
of HTP package, 206
STRING function, 117
STRING_TO_RAW Function, 251
STRONG function
of HTF package, 205
STRONG procedure
of HTP package, 206
STYLE function
of HTF package, 205
STYLE procedure
of HTP package, 206
SUB procedure
of HTP package, 206
SUBMIT procedure, 83
SUBMIT_PENDING_AREA procedure, 129
SUBPROGRAM Function, 245
SUBSTR function, 258
SUBSTR Functions, 87
SUBSTRINGDATA function, 189
Summary of DBMS_AQELM Subprograms, 26
Summary of DBMS_DIMENSION Subprograms, 60
Summary of DBMS_ERRLOG Subprograms, 66
Summary of DBMS_MVIEW Subprograms, 99
Summary of DBMS_XDBZ Subprograms, 187
Summary of DBMS_XMLDOM Subprograms, 189
Summary of DBMS_XMLSCHEMA Subprograms, 195
Summary of UTL_LMS Subprograms, 254
SUMMARY procedure, 154
SUP function
of HTF package, 205
SUP procedure
of HTP package, 206
SWITCH_CONSUMER_GROUP_FOR_SESS procedure, 129
SWITCH_CONSUMER_GROUP_FOR_USER procedure, 129
SWITCH_CURRENT_CONSUMER_GROUP Procedure, 141
SWITCH_PLAN procedure, 129
SYNC_INTERIM_TABLE procedure, 120
SYNCHRONIZE function, 53
synchronous capture
altering, 34
instantiation
preparing a table for, 34
rules, 157
SYNCINDEX Procedure, 191
synonyms
comparing, 35
SYS.MGW_MQSERIES_PROPERTIES Object Type, 96
SYS.MGW_PROPERTIES Object Type, 96
SYS.MGW_PROPERTY Object Type, 96
SYS.MGW_TIBRV_PROPERTIES Object Type, 96

T

TABLE_CREATE procedure, 44
TABLE_TO_COMMA Procedures, 172
TABLECAPTION function
of HTF package, 205
TABLECAPTION procedure
of HTP package, 206
TABLECLOSE function
of HTF package, 205
TABLECLOSE procedure
of HTP package, 206
TABLEDATA function
of HTF package, 205
TABLEDATA procedure
of HTP package, 206
TABLEHEADER function
of HTF package, 205
TABLEHEADER procedure
of HTP package, 206
TABLEOPEN function
of HTF package, 205
TABLEOPEN procedure
of HTP package, 206
TABLEPRINT function, 217
TABLEROWCLOSE function
of HTF package, 205
TABLEROWCLOSE procedure
of HTP package, 206
TABLEROWOPEN function
of HTF package, 205
TABLEROWOPEN procedure
of HTP package, 206
tables
comparing, 35
table items as arrays, 147
tablespace repositories
attaching tablespaces, 162
cloning tablespaces, 162
detaching tablespaces, 162
TABLESPACE_FIX_BITMAPS procedure, 144
TABLESPACE_FIX_SEGMENT_STATES procedure, 144
TABLESPACE_HEAT_MAP Procedure, 74
TABLESPACE_MIGRATE_FROM_LOCAL procedure, 144
TABLESPACE_MIGRATE_TO_LOCAL procedure, 144
TABLESPACE_REBUILD_BITMAPS procedure, 144
TABLESPACE_REBUILD_QUOTAS procedure, 144
TABLESPACE_RELOCATE_BITMAPS procedure, 144
TABLESPACE_SET type, 162
TABLESPACE_VERIFY procedure, 144
tags
GET_TAG function, 156, 157, 202
SET_TAG procedure, 156, 157, 202
TARGET_FILE function, 44
TARGET_LOB function, 44
TARGET_PROGRAM_RUNNING procedure, 53
TARGET_TABLE function, 44
TARGET_TRACE function, 44
TELETYPE function
of HTF package, 205
TELETYPE procedure
of HTP package, 206
TERMINATE procedure, 117
TEXT_DECODE function, 248
TEXT_ENCODE function, 248
The DBMS_XDB_REPOS package, 183
TIME_TABLE Table Type, 147
TIME_WITH_TIME_ZONE_TABLE Table Type, 147
TIMESTAMP_TABLE Table Type, 147
TIMESTAMP_WITH_LTZ_TABLE Table Type, 147
TIMESTAMP_WITH_TIME_ZONE_TABLE Table Type, 147
TITLE function
of HTF package, 205, 205
TITLE procedure
of HTP package, 206
TO_CURSOR_NUMBER Function, 147
TO_REFCURSOR Function, 147
TO_STRING function, 280
TODATE function, 217
TOOBJECT procedure, 283
TOUCHRESOURCE Procedure, 183
TRACE procedure, 43
TRACE Procedure, 48
TRACEENABLED Function, 48
TRACETAB.SQL, 165
tracking LCRs, 157, 157, 202
TRANSACTION_BACKOUT Procedures, 70
TRANSFER_STATS Procedure, 153
TRANSFORM function, 283
transformations
rule-based
adding a column, 157, 202
custom, 157
deleting a column, 157, 202
keeping columns, 157, 202
renaming a column, 157, 202
renaming a schema, 157, 202
renaming a table, 157, 202
STREAMS$_TRANSFORM_FUNCTION, 157
TRANSFORMNODE function, 201
TRANSLATE function, 258, 280
TRANSLATE_ERROR Procedure, 148
TRANSLATE_SQL Procedure, 148
TRANSLATEXML Function, 199
TRANSLITERATE Function, 251, 258
TRANSPORT_SET_CHECK procedure, 170
TRIM Procedures, 87
TUNE_MVIEW Procedure, 19
TYPE_BUILD function, 44
TYPE_DIMENSION_COMPILE function, 44
TYPE_OPERATIONS function, 44
TYPE_REJECTED_RECORDS function, 44
types
MGD_ID, 280, 280
MGD_ID_COMPONENT, 280
MGD_ID_COMPONENT_VARRAY, 280
Oracle Multimedia
ORDAudio, 274
ORDDicom, 275
ORDDoc, 276
ORDImage, 277
ORDVideo, 279
SQL/MM Still Image, 278

U

ULISTCLOSE function
of HTF package, 205
ULISTCLOSE procedure
of HTP package, 206
ULISTOPEN function
of HTF package, 205
ULISTOPEN procedure
of HTP package, 206
UNASSIGN_ACL Procedure, 100
UNASSIGN_WALLET_ACL Procedure, 100
UNCHECKOUT function, 184
UNCL_ARRAY Table Type, 172
UNDERLINE function
of HTF package, 205
UNDERLINE procedure
of HTP package, 206
UNESCAPE function, 264
UNESCAPEURI function, 271
UNIFORM_DIST_FIT procedure, 154
UNIQUE_SESSION_ID Function, 141
UNIQUE_SESSION_NAME function, 110
UNIT_LINE Function, 245
UNKEEP procedure, 142
UNLOCK_MAP procedure, 155
UNLOCK_PARTITION_STATS Procedure, 153
UNLOCK_SCHEMA_STATS procedure, 153
UNLOCK_TABLE_STATS procedure, 153
UNLOCKPATH Procedure, 48, 49
UNLOCKRESOURCE Function, 183
UNMAP_DAD Procedure, 65
UNMARKHOT Procedure, 142
UNMOUNTSTORE Procedure, 48
UNPACK_MESSAGE procedures, 110
UNPACK_STGTAB_BASELINE Function, 146
UNPACK_STGTAB_DIRECTIVE Function, 145
UNPACK_STGTAB_SQLPATCH Procedure, 150
UNPACK_STGTAB_SQLPROF Procedure, 152
UNPACK_STGTAB_SQLSET Procedure, 152
UNREGISTER_DEPENDENT_OBJECT procedure, 120
UNREGISTER_FOREIGN_QUEUE Procedure, 96
UNREGISTERSTORE Procedure, 48
UNREGISTERURLHANDLER procedure, 271
UNSCHEDULE_PROPAGATION Procedure, 96
UNUSED_SPACE procedure, 143
UPDATE_BY_CAT procedure, 104
UPDATE_CATEGORY Procedure, 129
UPDATE_CDB_AUTOTASK_DIRECTIVE Procedure, 129
UPDATE_CDB_DEFAULT_DIRECTIVE Procedure, 129
UPDATE_CDB_PLAN Procedure, 129
UPDATE_CDB_PLAN_DIRECTIVE Procedure, 129
UPDATE_CONSUMER_GROUP procedure, 129
UPDATE_CREDENTIAL Procedure, 39
UPDATE_FULL_REDACTION_VALUES Procedure, 119
UPDATE_OBJECT procedure, 260
UPDATE_OBJECT Procedure, 19
UPDATE_OBJECT_INFO Function, 177
UPDATE_PLAN procedure, 129
UPDATE_PLAN_DIRECTIVE procedure, 129
UPDATE_REC_ATTRIBUTES Procedure, 19
UPDATE_SIGNATURES procedure, 104
UPDATE_SQLSET procedures, 152
UPDATE_SQLWKLD_ATTRIBUTES Procedure, 19
UPDATE_SQLWKLD_STATEMENT Procedure, 19
UPDATE_TASK_ATTRIBUTES Procedure, 19
UPDATERESOURCEMETADATA Procedures, 183
UPDATETRANSLATION Function, 199
UPDATEXML function, 194, 198
UPGRADE_DATABASE Procedure, 62
UPGRADE_SCHEMA Procedure, 62
UPGRADE_STAT_TABLE procedure, 153
UPGRADE_TABLE Procedure, 62
URI Types
description, 271
UriFactory package, 271
ESCAPEURI function, 271
GETURL function, 271
methods, 271
REGISTERURLHANDLER procedure, 271
UNESCAPEURI function, 271
UNREGISTERURLHANDLER procedure, 271
UriType supertype, 271
GETBLOB function, 271
GETCLOB function, 271
GETCONTENTTYPE function, 271
GETEXTERNALURL function, 271
GETURL function, 271
GETXML function, 271
methods, 271
UROWID_TABLE Table Type, 147
USE_FILTER_SET Procedure, 176
USE_ROLLBACK_SEGMENT procedure, 166
USEBINARYSTREAM Function, 189
USEDPORT Procedure, 181
USEITEMTAGSFORCOLL procedure, 190
USENULLATTRIBUTEINDICATOR procedure, 190, 193
USER_EXPORT procedures, 83
USETYPEFORCOLLELEMTAG procedure, 193
Using DBMS_ADVISOR, 19
Using DBMS_AQIN, 27, 27
Using DBMS_FILE_GROUP, 68
Using DBMS_MVIEW, 99
Using DBMS_RULE, 136
Using DBMS_RULE_ADM, 137
Using DBMS_STREAMS, 156
Using DBMS_STREAMS_ADM, 157
Using DBMS_STREAMS_TABLESPACE_ADM, 162
Using DBMS_XMLDOM, 189
Using DBMS_XMLSCHEMA, 195
Using UTL_HTTP, 250
UTL Streams Types, 282
UTL_BINARYINPUTSTREAM Type, 282
UTL_BINARYOUTPUTSTREAM Type, 282
UTL_CHARACTERINPUTSTREAM Type, 282
UTL_CHARACTEROUTPUTSTREAM Type, 282
UTL_COLL package, 246
UTL_COMPRESS package, 247
UTL_ENCODE package, 248
UTL_FILE package, 249
UTL_HTTP package, 250
UTL_I18N package, 251
ESCAPE_REFERENCE function, 251, 251, 251, 251, 251, 251, 251
GET_DEFAULT_CHARSET function, 251
MAP_CHARSET function, 251
MAP_LANGUAGE_FROM_ISO function, 251
MAP_LOCALE_TO_ISO function, 251
MAP_TERRITORY_FROM_ISO function, 251
RAW_TO_CHAR function, 251
RAW_TO_NCHAR function, 251
UNESCAPE_REFERENCE function, 251
UTL_INADDR package, 252
UTL_LMS package, 254
FORMAT_MESSAGE function, 254
GET_MESSAGE function, 254
UTL_MAIL package, 255
UTL_MATCH package, 256
UTL_NLA package, 257
UTL_RAW package, 258
UTL_RECOMP package, 259
UTL_REF package, 260
UTL_SPADV package, 262
UTL_TCP package, 263
UTL_URL package, 264
UUDECODE function, 248
UUENCODE function, 248

V

V$STREAMS_MESSAGE_TRACKING view, 157, 157, 202
v$vpd_policies, 133
VALIDATE Procedure, 172
VALIDATE_DIMENSION procedure, 60
VALIDATE_PENDING_AREA procedure, 129
VALIDATE_REWRITE_EQUIVALENCE Procedure, 18
VALIDATE_SCHEME function, 95
VALIDATE_XML procedure, 42
VALUE functions, 117
VALUEOF procedure, 201
VARCHAR2_TABLE Table Type, 147
VARCHAR2A Table Type, 147
VARCHAR2S Table Type, 147
VARIABLE function
of HTF package, 205
VARIABLE procedure
of HTP package, 206
VARIABLE_VALUE procedures, 147
VERBOSE_ACTION function, 44
VERBOSE_DEBUG function, 44
VERBOSE_INFO function, 44
VERBOSE_NOTICE function, 44
VERBOSE_STATS function, 44
VERIFY_VALUES function, 213
VERSION function, 44
views
comparing, 35
virtual dependency definitions
object dependencies
creating, 23
dropping, 23
value dependencies, 23
Virtual Private Database. See VPD
VPD
viewing current cursors and policy predicates, 133
VPD use of DBMS_RLS, 133
VRFY function, 261

W

WAIT_ON_PENDING_DML Procedure, 172
WAITANY procedure, 20
WAITONE procedure, 20
WBR function
of HTF package, 205
WBR procedure
of HTP package, 206
WEIBULL_DIST_FIT procedure, 154
WHAT procedure, 83
WHO_CALLED_ME procedure, 217
WPG_DOCLOAD package, 265
WRAP Functions, 54
WRITE Procedures, 87
WRITE_DATA procedure, 261
WRITE_LINE function, 263
WRITE_LINE procedure, 250
WRITE_RAW function, 263
WRITE_RAW procedure, 250
WRITE_RAW_DATA procedure, 261
WRITE_TEXT function, 263
WRITE_TEXT procedure, 250
WRITEAPPEND Procedures, 87
WRITETOBUFFER procedure, 189
WRITETOCLOB procedure, 189
WRITETOFILE procedure, 189

X

XA_COMMIT Function, 178
XA_END Function, 178
XA_FORGET Function, 178
XA_GETLASTOER Function, 178
XA_PREPARE Function, 178
XA_RECOVER Function, 178
XA_ROLLBACK Function, 178
XA_SETTIMEOUT Function, 178
XA_START Function, 178
XDBEvent Type Subprograms, 188
XDBHandler Type Subprograms, 188
XDBHandlerList Type Subprograms, 188
XDBLink Type Subprograms, 188
XDBPath Type Subprograms, 188
XDBRepositoryEvent Type Subprograms, 188
XDBSCHEMA_PREFIXES Function, 182
XDBUriType, 271
XDBURITYPE function, 271
XDBUriType subtype, 271
CREATEURI function, 271
GETBLOB function, 271
GETCLOB function, 271
GETCONTENTTYPE function, 271
GETEXTERNALURL function, 271
GETURL function, 271
GETXML function, 271
methods, 271
XDBURITYPE function, 271
XDBZ Constants, 187
XFORM_BIN_CAT procedure, 46
XFORM_BIN_NUM procedure, 46
XFORM_CLIP procedure, 46
XFORM_COL_REM procedure, 46
XFORM_EXPR_NUM procedure, 46
XFORM_EXPR_STR procedure, 46
XFORM_MISS_CAT procedure, 46
XFORM_MISS_NUM procedure, 46
XFORM_NORM_LIN procedure, 46
XFORM_STACK procedure, 46
XML_TO_LCR Function, 97
XMLINDEXADDPATH Procedure, 180
XMLINDEXREMOVEPATH Procedure, 180
XMLType
CREATENONSCHEMABASEDXML function, 283
CREATESCHEMABASEDXML function, 283
CREATEXML function, 283
description, 283
EXISTSNODE function, 283
EXTRACT function, 283
GETBLOBVAL function, 283
GETCLOBVAL function, 283
GETNUMBERVAL function, 283
GETROOTELEMENT function, 283
GETSCHEMAURL function, 283
GETSTRINGVAL function, 283
ISFRAGMENT function, 283
ISSCHEMABASED function, 283
ISSCHEMAVALID function, 283
ISSCHEMAVALIDATED function, 283
NAMESPACE function, 283
SCHEMAVALIDATE procedure, 283
SETSCHEMAVALIDATED procedure, 283
TOOBJECT procedure, 283
TRANSFORM function, 283
XMLTYPE function, 283
XMLTYPE function, 283
XPATH2TABCOLMAPPING Function, 197
XRANGE function, 258
XSD_ATTRIBUTE Function, 182
XSD_COMPLEX_TYPE Function, 182
XSD_ELEMENT Function, 182
XSD_GROUP Function, 182
XStream
DBMS_XSTREAM_ADM package, 202
privileges, 203
removing configuration, 202
security, 202
XStream administrator, 203