<<Back to http://devdoc.net
Mine with nofee-ng to get DevFee back!
Skip Headers
Oracle® Database PL/SQL Packages and Types Reference
11g Release 2 (11.2)

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

Go to previous page
Previous
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, 122
ABORT_GLOBAL_INSTANTIATION procedure, 32
ABORT_REDEF_TABLE procedure, 110
ABORT_SCHEMA_INSTANTIATION procedure, 32
ABORT_TABLE_INSTANTIATION procedure, 32
ABORTED_REQUEST_THRESHOLD procedure, 132
ACCEPT_SQL_PATCH Procedure, 137
ACCEPT_SQL_PROFILE procedure, 139
ACLCHECKPRIVILEGES function, 163
ACTIVATE_SUBSCRIPTION Procedure, 34
ACTIVE_INSTANCES procedure, 156
ADD_COLORED_SQL Procedure, 161
ADD_COLUMN member procedure, 248
ADD_COLUMN procedure, 144
ADD_COOKIES procedure, 224
ADD_ELEMENTARY_ATTRIBUTE procedure, 65, 123
ADD_EVENT procedure, 123
ADD_FILE procedure, 67
ADD_FILTER Procedure, 159, 160
ADD_FUNCTIONS procedure, 65, 123
ADD_GLOBAL_PROPAGATION_RULES procedure, 144
ADD_GLOBAL_RULES procedure, 144
ADD_MESSAGE_PROPAGATION_RULE procedure, 144
ADD_MESSAGE_RULE procedure, 144
ADD_PAIR member procedure, 256
ADD_PRIVILEGE Procedure, 94
ADD_RULE procedure, 123, 127
ADD_SCHEMA_PROPAGATION_RULES procedure, 144
ADD_SCHEMA_RULES procedure, 144
ADD_SCHEME procedure, 89
ADD_SQLSET_REFERENCE function, 139
ADD_SQLWKLD_REF Procedure, 18
ADD_SQLWKLD_STATEMENT Procedure, 18
ADD_STMT_HANDLER procedure, 21
ADD_STMT_TO_HANDLER procedure, 147
ADD_SUBSCRIBER Procedure, 90
ADD_SUBSET_PROPAGATION_RULES procedure, 144
ADD_SUBSET_RULES procedure, 144
ADD_TABLE_PROPAGATION_RULES procedure, 144
ADD_TABLE_RULES procedure, 144
ADD_WARNING_SETTING_CAT procedure, 157
ADD_WARNING_SETTING_NUM procedure, 157
ADD2MULTI procedure, 193
ADDATTR member procedure
of ANYTYPE TYPE, 242
ADDHTTPEXPIREMAPPING Procedure, 163
ADDINSTANCE member procedure
of ANYDATASET TYPE, 241
ADDMIMEMAPPING Procedure, 163
ADDREPOSITORYRESCONFIG Procedure, 118
ADDRESCONFIG Function, 118
ADDRESS function
of HTF package, 182
ADDRESS procedure
of HTP package, 183
ADDSCHEMALOCMAPPING Procedure, 163
ADDSERVLET Procedure, 163
ADDSERVLETMAPPING Procedure, 163
ADDSERVLETSECROLE Procedure, 163
ADDXMLEXTENSION Procedure, 163
ADM_DROP_CHUNKS Procedure, 101
ADM_DROP_TASK Procedure, 101
ADM_GET_TASK_STATUS Procedure, 101
ADM_STOP_TASK Procedure, 101
ADMIN_TABLES procedure, 112
ADVISE_COMMIT procedure, 152
ADVISE_NOTHING procedure, 152
ADVISE_ROLLBACK procedure, 152
ADVISOR privilege, 41, 41
advisors
Oracle Streams, 145
aggregation management, 41
aggregation operators (OLAP), 41
ALLOCATE_UNIQUE procedure, 83
ALTER_AGENT Procedure, 90
ALTER_APPLY procedure, 21
ALTER_CAPTURE procedure, 32
ALTER_COMPILE procedure, 53
ALTER_EVALUATION_CONTEXT procedure, 127
ALTER_FILE procedure, 67
ALTER_FILE_GROUP procedure, 67
ALTER_JOB Procedure, 90
ALTER_MSGSYSTEM_LINK Procedure for TIB/Rendezvous, 90
ALTER_MSGSYSTEM_LINK Procedure for WebSphere MQ, 90
ALTER_PARAM Procedure, 37
ALTER_PROPAGATION procedure, 107
ALTER_PROPAGATION_SCHEDULE Procedure, 90
ALTER_REWRITE_EQUIVALENCE Procedure, 17
ALTER_RULE procedure, 127
ALTER_SQL_PATCH Procedure, 137
ALTER_SQL_PLAN_BASELINE Function, 135
ALTER_SQL_PROFILE procedure, 139
ALTER_STATS_HISTORY_RETENTION procedure, 141
ALTER_SUBSCRIBER Procedure, 90
ALTER_SYNC_CAPTURE procedure, 32
ALTER_TABLE_NOT_REFERENCEABLE procedure, 53
ALTER_TABLE_REFERENCEABLE procedure, 53
ALTER_VERSION procedure, 67
AMATCH function, 191
ANALYZE Function, 73
ANALYZE Procedure, 31
ANALYZE_CURRENT_PERFORMANCE procedure, 145
ANALYZE_DATABASE Procedure, 156
ANALYZE_DB Procedure, 16
ANALYZE_INST Procedure, 16
ANALYZE_PART_OBJECT procedure, 156
ANALYZE_PARTIAL Procedure, 16
ANALYZE_SCHEMA Procedure, 156
ANCHOR function
of HTF package, 182
ANCHOR procedure
of HTP package, 183
ANCHOR2 function
of HTF package, 182
ANCHOR2 procedure
of HTP package, 183
anonymous PL/SQL blocks
dynamic SQL and, 136
AnyData datatype
queues
creating, 144
removing, 144
ANYDATA TYPE, 240
ANYDATASET TYPE, 241
ANYTYPE TYPE, 242
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, 82
APPENDCHILD function, 170
APPENDDATA procedure, 170
APPENDPATH Procedure, 163
APPENDRESCONFIG Procedure, 118
APPENDRESOURCEMETADATA Procedure, 163
APPLETCLOSE function
of HTF package, 182
APPLETCLOSE procedure
of HTP package, 183
APPLETOPEN function
of HTF package, 182
APPLETOPEN procedure
of HTP package, 183
apply process
altering, 21
apply user, 144
change handlers
setting, 21
conflict handlers
setting, 21
creating, 21, 144, 144, 144, 144, 144
DBMS_APPLY_ADM package, 21
DDL handler
setting, 21, 21
dropping, 21
enqueuing events, 21
error handlers
setting, 21
error queue
deleting errors, 21, 21
executing errors, 21, 21
getting error messages, 21
instantiation
global SCN, 21
schema SCN, 21
table SCN, 21
message handler
setting, 21, 21
parameters
allow_duplicate_rows, 21, 21, 32, 32
commit_serialization, 21
compare_key_only, 21
disable_on_error, 21
disable_on_limit, 21
grouptransops, 21
ignore_transaction, 21
max_sga_size, 21
maximum_scn, 21
parallelism, 21
preserve_encryption, 21
setting, 21
startup_seconds, 21, 21
time_limit, 21
trace_level, 21
transaction_limit, 21
txn_age_spill_threshold, 21
txn_lcr_spill_threshold, 21
precommit handler
setting, 21, 21
procedure DML handlers
setting, 21
rules
defining global, 144
defining message, 144
defining schema, 144
defining subset, 144
defining table, 144
for LCRs, 144
for user messages, 144
removing, 144
specifying execution, 21
starting, 21
statement DML handlers
setting, 21, 21
stopping, 21
substitute key columns
setting, 21
transparent data encryption, 21
apply user
DBMS_STREAMS_ADM package, 144
APPLY$_ENQUEUE, 21
APPLY$_EXECUTE, 21
AQ$_AGENT Type, 243
AQ$_AGENT_LIST_T Type, 243
AQ$_DESCRIPTOR Type, 243, 243
AQ$_NTFN_MSGID_ARRAY Type, 243
AQ$_POST_INFO Type, 243
AQ$_POST_INFO_LIST Type, 243
AQ$_PURGE_OPTIONS_T Type, 243
AQ$_RECIPIENT_LIST_T Type, 243
AQ$_REG_INFO Type, 243
AQ$_REG_INFO_LIST Type, 243
AQ$_SUBSCRIBER_LIST_T Type, 243
AREA function
of HTF package, 182
AREA procedure
of HTP package, 183
arrays
BIND_ARRAY procedure, 136
bulk DML using DBMS_SQL, 136
ASA_RECO_ROW Record Type, 133
ASA_RECO_ROW_TB Table Type, 133
ASA_RECOMMENDATIONS Function, 133
ASH_GLOBAL_REPORT_HTML Function, 161
ASH_GLOBAL_REPORT_TEXT Function, 161
ASH_REPORT_HTML Function, 161
ASH_REPORT_TEXT Function, 161
ASSIGN_ACL Procedure, 94
ASSIGN_ATTRIBUTE_SET procedure, 65
ASSIGN_WALLET_ACL Procedure, 94
ASSM_SEGMENT_VERIFY Procedure, 134
ASSM_TABLESPACE_VERIFY Procedure, 134
ATTACH_SESSION procedure, 52
ATTACH_SIMPLE_TABLESPACE procedure, 149
ATTACH_TABLESPACES procedure, 149
attribute sets
dropping, 65
AUTH Function and Procedure, 235
AUTHORIZE function, 188
AUTHORIZE_DAD Procedure, 63
AVAILABLE function, 237
AWR_BASELINE_METRIC_TYPE Object Type, 161
AWR_BASELINE_METRIC_TYPE_TABLE Table Type, 161
AWR_DIFF_REPORT_HTML Function, 161
AWR_DIFF_REPORT_TEXT Function, 161
AWR_GLOBAL_DIFF_REPORT_HTML Functions, 161
AWR_GLOBAL_DIFF_REPORT_TEXT Functions, 161, 161
AWR_GLOBAL_REPORT_HTML Functions, 161
AWR_GLOBAL_REPORT_TEXT Functions, 161
AWR_REPORT_HTML function, 161
AWR_REPORT_TEXT function, 161
AWR_SQL_REPORT_HTML Function, 161
AWR_SQL_REPORT_TEXT Function, 161

B

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

C

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

D

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

E

EDIT_DISTANCE Function, 230
EDIT_DISTANCE_SIMILARITY Function, 230
EHLO function and procedure, 235
EM function
of HTF package, 182
EM procedure
of HTP package, 183
e-mail from PL/SQL (email), 237
EMPHASIS function
of HTF package, 182
EMPHASIS procedure
of HTP package, 183
ENABLE procedure, 43, 100
ENABLE Procedures, 29
ENABLE_AT_SYSTEM_CHANGE_NUMBER procedure, 69
ENABLE_AT_TIME procedure, 69
ENABLE_BREAKPOINT function, 52
ENABLE_HIERARCHY procedure, 168
ENABLE_JOB Procedure, 90
ENABLE_PROPAGATION_SCHEDULE Procedure, 90
ENABLETRANSLATION Procedure, 178
END_PREPARE Procedure, 60
END_REQUEST procedure, 224
END_RESPONSE procedure, 224
END_SQL_BLOCK Procedure, 119
END_UPGRADE Procedure, 60
ENDCREATE member procedure
of ANYDATA TYPE, 240
of ANYDATASET TYPE, 241
of ANYTYPE TYPE, 242
ENQUEUE procedure, 148
ENQUEUE_ARRAY Function, 22
ENQUEUE_OPTIONS_T Type, 243
ENQUOTE_LITERAL Function, 26
ENQUOTE_NAME Function, 26
EPC_TO_ORACLE_SCHEME function, 89
EQUALS_HOST Function, 95
ERASE Procedures, 82
error queue
deleting errors, 21, 21
executing errors, 21, 21
getting error messages, 21
ESCAPE function, 238
ESCAPE_SC function
of HTF package, 182
ESCAPE_SC procedure
of HTP package, 183
ESCAPE_URL function
of HTF package, 182
ESCAPEURI function, 245
ESTIMATE_CPU_UNITS function, 97
ESTIMATE_MVIEW_SIZE Procedure, 93
ETINSTANCE member function
of ANYDATASET TYPE, 241
EVALUATE procedure, 126
EVOLVE_SQL_PLAN_BASELINE Function, 135
EXACT_TEXT_SIGNATURES procedure, 99
EXEC_DDL_STATEMENT procedure, 156
EXECUTE function, 136
EXECUTE member procedure, 248, 248
EXECUTE procedure, 52
EXECUTE_ALL_ERRORS procedure, 21
EXECUTE_ANALYSIS_TASK, 138
EXECUTE_AND_FETCH function, 136
EXECUTE_DIAGNOSIS_TASK Procedure, 137
EXECUTE_ERROR procedure, 21
EXECUTE_IMMEDIATE Procedure, 75
EXECUTE_NON_QUERY Function, 75
EXECUTE_TASK Procedure, 18
EXECUTE_TUNING_TASK Function & Procedure, 28, 139
execution flow
in dynamic SQL, 136
EXF$ATTRIBUTE object type, 247
EXF$ATTRIBUTE_LIST object type, 247
EXF$INDEXOPER object type, 247
EXF$TABLE_ALIAS object type, 247
EXF$TEXT object type, 247
EXF$XPATH_TAG object type, 247
EXF$XPATH_TAGS object type, 247
EXISTSNODE function, 259
EXISTSRESOURCE function, 163
EXPAND_MESSAGE function, 129
EXPLAIN_SQL_TESTCASE Function, 137
EXPONENTIAL_DIST_FIT procedure, 140
EXPORT_AWR Procedure, 159, 160
EXPORT_COLUMN_STATS procedure, 141
EXPORT_DATABASE_PREFS Procedure, 141
EXPORT_DATABASE_STATS procedure, 141
EXPORT_DICTIONARY_STATS procedure, 141
EXPORT_FIXED_OBJECTS_STATS procedure, 141
EXPORT_INDEX_STATS procedure, 141
EXPORT_PENDING_STATS Procedure, 141
EXPORT_SCHEMA_PREFS Procedure, 141
EXPORT_SCHEMA_STATS procedure, 141
EXPORT_SQL_TESTCASE Procedures, 137
EXPORT_SQL_TESTCASE_DIR_BY_INC Function, 137
EXPORT_SQL_TESTCASE_DIR_BY_TXT Function, 137
EXPORT_SYSTEM_STATS procedure, 141
EXPORT_TABLE_PREFS Procedure, 141
EXPORT_TABLE_STATS procedure, 141
EXPORT_XML procedure, 41, 41
EXPORT_XML_TO_FILE procedure, 41
Expression Filter object types, 247
extend window
to create a new view, 34
EXTEND_EVENT_STRUCT procedure, 123
EXTRACT function, 259
EXTRACTXLIFF Function & Procedure, 178

F

FCLOSE procedure, 223
FCLOSE_ALL procedure, 223
FCOPY procedure, 223
FEATURE_T Record Type, 47
FEATURENAME Function, 47
FEATURES_T Table Type, 47
FETCH_ROW Function, 75
FETCH_ROWS function, 136
FFLUSH procedure, 223
FGETATTR procedure, 223
FGETPOS function, 223
FI_HORIZONTAL function, 71
FI_TRANSACTIONAL function, 71
file groups, 67
adding files, 67
altering, 67
altering files, 67
altering versions, 67
creating, 67
creating versions, 67
dropping, 67
dropping versions, 67
granting object privileges, 67
granting system privileges, 67
purging, 67
removing files, 67
revoking object privileges, 67
revoking system privileges, 67
FILE type, 149
FILE_SET type, 149
FILECLOSE Procedure, 82
FILECLOSEALL Procedure, 82
FILEEXISTS Function, 82
FILEGETNAME Procedure, 82
FILEISOPEN Function, 82
FILEOPEN Procedure, 82
FILETYPE Record Type, 223
FIND_AFFECTED_TABLE Procedure, 60
FINDENTITY function, 170
FINDNOTATION function, 170
fine-grained access control
DBMS_RLS package, 124
FINISH_CAPTURE Procedure, 159
FINISH_REDEF_TABLE procedure, 110
FIX_CORRUPT_BLOCKS procedure, 112
FLUSH Function & Procedure, 121
FLUSH procedure, 43, 237
FLUSH_DATA function and procedure, 106
FLUSH_DATABASE_MONITORING_INFO procedure, 141
FLUSHCACHE Procedure, 49
FONTCLOSE function
of HTF package, 182
FONTCLOSE procedure
of HTP package, 183
FONTOPEN function
of HTF package, 182
FONTOPEN procedure
of HTP package, 183
FOPEN function, 223
FOPEN_NCHAR function, 223
FORCE parameter
and job-to-instance affinity, 78
FORMAT function, 255
FORMAT_CALL_STACK Function, 156
FORMAT_CELL function
of HTF package, 182
FORMAT_ERROR_BACKTRACE function, 156
FORMAT_ERROR_STACK function, 156
FORMCHECKBOX function
of HTF package, 182
FORMCHECKBOX procedure
of HTP package, 183
FORMCLOSE function
of HTF package, 182, 182
FORMCLOSE procedure
of HTP package, 183
FORMFILE function
of HTF package, 182
FORMFILE procedure
of HTP package, 183, 183
FORMHIDDEN function
of HTF package, 182
FORMHIDDEN procedure
of HTP package, 183
FORMIMAGE function
of HTF package, 182
FORMIMAGE procedure
of HTP package, 183
FORMOPEN function
of HTF package, 182
FORMOPEN procedure
of HTP package, 183
FORMPASSWORD function
of HTF package, 182
FORMPASSWORD procedure
of HTP package, 183
FORMRADIO function
of HTF package, 182
FORMRADIO procedure
of HTP package, 183
FORMRESET function
of HTF package, 182
FORMRESET procedure
of HTP package, 183
FORMSELECTCLOSE function
of HTF package, 182
FORMSELECTCLOSE procedure
of HTP package, 183
FORMSELECTOPEN function
of HTF package, 182
FORMSELECTOPEN procedure
of HTP package, 183
FORMSELECTOPTION function
of HTF package, 182
FORMSELECTOPTION procedure
of HTP package, 183
FORMSUBMIT function
of HTF package, 182
FORMSUBMIT procedure
of HTP package, 183
FORMTEXT function
of HTF package, 182
FORMTEXT procedure
of HTP package, 183
FORMTEXTAREA function
of HTF package, 182
FORMTEXTAREA procedure
of HTP package, 183
FORMTEXTAREA2 function
of HTF package, 182
FORMTEXTAREA2 procedure
of HTP package, 183
FORMTEXTAREACLOSE function
of HTF package, 182
FORMTEXTAREACLOSE procedure
of HTP package, 183
FORMTEXTAREAOPEN function
of HTF package, 182
FORMTEXTAREAOPEN procedure
of HTP package, 183
FORMTEXTAREAOPEN2 function
of HTF package, 182
FORMTEXTAREAOPEN2 procedure
of HTP package, 183
FRAGMENT_DELETE Procedure, 82
FRAGMENT_INSERT Function, 82
FRAGMENT_MOVE Procedure, 82
FRAGMENT_REPLACE Procedure, 82
FRAME function
of HTF package, 182
FRAME procedure
of HTP package, 183
FRAMESETCLOSE function
of HTF package, 182
FRAMESETCLOSE procedure
of HTP package, 183
FRAMESETOPEN function
of HTF package, 182
FRAMESETOPEN procedure
of HTP package, 183
FREE_BLOCKS procedure, 133
FREE_UNUSED_USER_MEMORY Procedure, 131
FREEDOCFRAG procedure, 170
FREEDOCUMENT procedure, 170
FREENODE procedure, 170, 170
FREEPARSER procedure, 173
FREEPROCESSOR procedure, 180
FREERESOURCE Procedure, 166
FREESTYLESHEET procedure, 180
FREETEMPORARY Procedures, 82
FREMOVE procedure, 223, 223
FRENAME procedure, 223
FSEEK procedure, 223
functions
adding to attribute sets, 65, 123

G

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

H

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

I

IMG function
of HTF package, 182
IMG procedure
of HTP package, 183
IMG2 procedure
of HTP package, 183
IMPLEMENT_TASK Procedure, 18
IMPLEMENT_TUNING_TASK Function, 139
IMPORT_AWR Function, 160
IMPORT_AWR Procedure, 159
IMPORT_COLUMN_STATS procedure, 141
IMPORT_DATABASE_PREFS Procedure, 141
IMPORT_DATABASE_STATS procedure, 141
IMPORT_DICTIONARY_STATS procedure, 141
IMPORT_FIXED_OBJECTS_STATS procedure, 141
IMPORT_INDEX_STATS procedure, 141
IMPORT_SCHEMA_PREFS Procedure, 141
IMPORT_SCHEMA_STATS procedure, 141
IMPORT_SQL_TESTCASE Procedures, 137
IMPORT_SQLWKLD_SCHEMA Procedure, 18
IMPORT_SQLWKLD_SQLCACHE Procedure, 18
IMPORT_SQLWKLD_STS Procedure, 18
IMPORT_SQLWKLD_SUMADV Procedure, 18
IMPORT_SQLWKLD_USER Procedure, 18
IMPORT_SYSTEM_STATS procedure, 141
IMPORT_TABLE_PREFS Procedure, 141
IMPORT_TABLE_STATS procedure, 141
IMPORT_XML procedure, 41, 41
IMPORTNODE function, 170
inbound servers
DBMS_STREAMS_ADM package, 144
rules, 144
INCIDENTID_2_SQL Procedure, 137
INCLUDE_EXTRA_ATTRIBUTES procedure, 32
INDEX_PARAMETERS procedure, 65
INDEX_TABLE_TYPE Table Type, 156
INIT_CLEANUP procedure, 27
INITFS Procedure, 50
INITIALIZE function, 52
INITIALIZE procedure, 108
INITIALIZE_CUBE_UPGRADE procedure, 41, 41, 41
INITIALIZE_REPLAY Procedure, 160
INPLACEEVOLVE Procedure, 176
INSERT_AUTOBIN_NUM_EQWIDTH procedure, 45
INSERT_BIN_CAT_FREQ procedure, 45
INSERT_BIN_NUM_EQWIDTH procedure, 45
INSERT_BIN_NUM_QTILE procedure, 45
INSERT_BIN_SUPER procedure, 45
INSERT_CLIP_TRIM_TAIL procedure, 45
INSERT_CLIP_WINSOR_TAIL procedure, 45
INSERT_FINDING_DIRECTIVE Procedure, 16
INSERT_MISS_CAT_MODE procedure, 45
INSERT_MISS_NUM_MEAN procedure, 45
INSERT_NORM_LIN_MINMAX procedure, 45
INSERT_NORM_LIN_SCALE procedure, 45
INSERT_NORM_LIN_ZSCORE procedure, 45
INSERT_PARAMETER_DIRECTIVE Procedure, 16
INSERT_SEGMENT_DIRECTIVE Procedure, 16
INSERT_SQL_DIRECTIVE Procedure, 16
INSERTBEFORE function, 170
INSERTDATA procedure, 170
INSERTXML function, 175, 177
INSTANCE procedure, 78
INSTANCE_RECORD Record Type, 156
INSTANCE_TABLE Table Type, 156
instantiation
aborting database preparation, 32
aborting schema preparation, 32
aborting table preparation, 32
global SCN, 21
preparing a database for, 32
preparing a schema for, 32
preparing a table for, 32, 32
schema SCN, 21
table SCN, 21
INSTR Functions, 82
INTEGER_ARRAY Table Type, 131
INTERNAL_VERSION_CHECK function, 106
internet addressing
using UTL_INADDR, 226
INTERRUPT_ANALYSIS_TASK Procedure, 138
INTERRUPT_DIAGNOSIS_TASK Procedure, 137
INTERRUPT_TASK Procedure, 18
INTERRUPT_TUNING_TASK procedure, 139
INTERVAL procedure, 78
INTERVAL_DAY_TO_SECOND_TABLE, 136
INTERVAL_YEAR_TO_MONTH_TABLE Table Type, 136
INVALIDATE Functions & Procedures, 121
INVALIDATE Procedure, 156
INVALIDATE_OBJECT Functions & Procedures, 121
IS_BIT_SET Function, 156
IS_CLEANUP_INITIALIZED function, 27
IS_CLUSTER_DATABASE function, 156
IS_HIERARCHY_ENABLED function, 168
IS_LOCATOR function, 220
IS_NULL_TAG member function, 248
IS_OPEN function, 136, 223
IS_REPLAY_PAUSED Procedure, 160
IS_ROLE_ENABLED Function, 131
IS_SESSION_ALIVE Function, 131
IS_TRIGGER_FIRE_ONCE function, 53
ISFOLDER Function, 163, 166
ISFRAGMENT function, 259
ISINDEX function
of HTF package, 182
ISINDEX procedure
of HTP package, 183
ISNULL Function, 166, 169
ISNULL function, 170
ISOPEN function, 221
ISOPEN Functions, 82
ISSCHEMABASED function, 259
ISSCHEMAVALID function, 259
ISSCHEMAVALIDATED function, 259
ISTEMPORARY Functions, 82
ITALIC function
of HTF package, 182
ITALIC procedure
of HTP package, 183
ITEM Functions, 170

J

JARO_WINKLER Function, 230
JARO_WINKLER_SIMILARITY Function, 230
JOB constructor function, 128
JOB object type, 128, 128
JOB_ARRAY table type, 128, 128
JOBARG constructor function, 128
JOBARG object type, 128
JOBARG_ARRAY table type, 128
JOBATTR constructor function, 128
JOBATTR object type, 128
JOBATTR_ARRAY table type, 128

K

KBD function
of HTF package, 182
KBD procedure
of HTP package, 183
KEEP procedure, 132
KEEP_COLUMNS member procedure, 248
KEEP_COLUMNS procedure, 144
KEYBOARD function
of HTF package, 182
KEYBOARD procedure
of HTP package, 183

L

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

M

MAIL function and procedure, 235
MAILTO function
of HTF package, 182
MAILTO procedure
of HTP package, 183
MAINTAIN_CHANGE_TABLE procedure, 144
MAINTAIN_GLOBAL procedure, 144
MAINTAIN_SCHEMAS procedure, 144
MAINTAIN_SIMPLE_TABLESPACE procedure, 144
MAINTAIN_SIMPLE_TTS procedure, 144
MAINTAIN_TABLES procedure, 144
MAINTAIN_TABLESPACES procedure, 144
MAINTAIN_TTS procedure, 144
MAKE_DATA_BLOCK_ADDRESS function, 156
MAKEATTR function, 170
MAKECDATASECTION function, 170
MAKECHARACTERDATA function, 170
MAKECOMMENT function, 170
MAKEDOCUMENT Function, 166
MAKEDOCUMENT function, 170
MAKEDOCUMENTFRAGMENT function, 170
MAKEDOCUMENTTYPE function, 170
MAKEELEMENT function, 170
MAKEENTITY function, 170
MAKEENTITYREFERENCE function, 170
MAKENODE function, 170, 170, 170, 170
MAKENOTATION function, 170
MAKEPROCESSINGINSTRUCTION function, 170
MAKETEXT function, 170
MAKEVERSIONED function, 165
MAP_ALL function, 142
MAP_DAD Procedure, 63
MAP_ELEMENT function, 142
MAP_FILE function, 142
MAP_OBJECT function, 142
MAPCLOSE function
of HTF package, 182
MAPCLOSE procedure
of HTP package, 183
MAPOPEN function
of HTF package, 182
MAPOPEN procedure
of HTP package, 183
MARK_RECOMMENDATION Procedure, 18
MARKHOT Procedure, 132
MATCH function, 191
MATERIALIZE_DEFERRED_SEGMENTS Procedure, 134
materialized view logs
master table
purging, 93, 93, 93
materialized views
comparing, 35
converting from table- to cube-organized, 41
optimizing cube organized, 42
refreshing, 93, 93, 93
materialized views (cube organized), 41
MEMORY_REPORT Procedure, 121
MENULISTCLOSE function
of HTF package, 182
MENULISTCLOSE procedure
of HTP package, 183
MENULISTOPEN function
of HTF package, 182
MENULISTOPEN procedure
of HTP package, 183
merge streams, 144, 144
MERGE_COL_USAGE Procedure, 141
MERGE_STREAMS procedure, 144
MERGE_STREAMS_JOB procedure, 144
MERGEXLIFF Functions, 178
MESSAGE_PROPERTIES_ARRAY_T Type, 243
MESSAGE_PROPERTIES_T Type, 243
messaging client
messaging client user, 144
rules
for LCRs, 144
for user messages, 144
META function
of HTF package, 182
META procedure
of HTP package, 183
MG2 function
of HTF package, 182
MGD_ID constructor function, 255
MGD_ID object type, 255
FORMAT function, 255
GET_COMPONENT function, 255
MGD_ID constructor function, 255
TO_STRING function, 255
TRANSLATE function, 255
MGD_ID object types, 255
MGD_ID_COMPONENT object type, 255
MGD_ID_COMPONENT_VARRAY object type, 255
MIGRATE_STORED_OUTLINE Function, 135
migration
post-migration actions, 96
MIME_HEADER procedure, 194
MIMEHEADER_DECODE function, 222
MIMEHEADER_ENCODE function, 222
model transparency, 45
MODIFY_BASELINE_WINDOW_SIZE Procedure, 161
MODIFY_OPERATOR_LIST procedure, 65
MODIFY_PACKAGE_STATE Procedure, 131
MODIFY_SERVICE Procedure, 130
MODIFY_SNAPSHOT_SETTINGS procedure, 161
MODIFY_TRANSFORMATION procedure, 153
MODIFYPARAMETER Procedure, 172
MOUNT_T Record Type, 47
MOUNTS_T Table Type, 47
MOUNTSTORE Procedure, 47
MOVE_TO_DBFS_LINK Procedures, 82
MOVEXDB_TABLESPACE Procedure, 164
MSGID_ARRAY_T Type, 243
MV_CUBE_ADVICE function, 42

N

NAME_ARRAY Table Type, 156
NAME_RESOLVE procedure, 156
NAME_TOKENIZE procedure, 156
NAMELIST Table Type, 135
NAMESPACE function, 259
NAMESPACEIDTABLE Procedure, 40
NEW_LINE procedure, 100, 223
NEW_ROW_LIST function and procedure, 193
NEWCONTEXT function, 171, 174, 175, 177
NEWCONTEXTFROMHIERARCHY Function, 171
NEWDOMDOCUMENT function, 170
NEWPARSER function, 173
NEWPROCESSOR function, 180
NEWSTYLESHEET function, 180
NEXT_DATE procedure, 78
NEXT_ITEM_TYPE function, 103
NL function
of HTF package, 182
NL procedure
of HTP package, 183
NOBR function
of HTF package, 182
NOBR procedure
of HTP package, 183
NOFRAMESCLOSE function
of HTF package, 182
NOFRAMESCLOSE procedure
of HTP package, 183
NOFRAMESOPEN function
of HTF package, 182
NOFRAMESOPEN procedure
of HTP package, 183
NOOP function and procedure, 235
NOOP Functions, 26
NORMAL function, 108
NORMAL_DIST_FIT procedure, 140
NORMALIZE procedure, 170
NORMALIZEPATH Functions, 47
NUMBER_ARRAY Table Type, 156
NUMBER_TABLE Table Type, 136
NVARRAY_ADD Procedure, 91
NVARRAY_FIND_NAME Function, 91
NVARRAY_FIND_NAME_TYPE Function, 91
NVARRAY_GET Function, 91
NVARRAY_GET_BOOLEAN, 91
NVARRAY_GET_BYTE, 91
NVARRAY_GET_DATE Function, 91
NVARRAY_GET_DOUBLE Function, 91
NVARRAY_GET_FLOAT Function, 91
NVARRAY_GET_INTEGER, 91
NVARRAY_GET_LONG Function, 91
NVARRAY_GET_RAW Function, 91
NVARRAY_GET_SHORT, 91
NVARRAY_GET_TEXT Function, 91

O

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

P

PACK_MESSAGE procedures, 103
PACK_STGTAB_BASELINE Function, 135
PACK_STGTAB_SQLPATCH Procedure, 137
PACK_STGTAB_SQLPROF Procedure, 139
PACK_STGTAB_SQLSET Procedure, 139
package
DBMS_EXPFIL, 65
DBMS_ODCI, 97
DBMS_RLMGR, 123
DBMS_XDB, 163
DBMS_XMLDOM, 170
DBMS_XMLGEN, 171
DBMS_XMLPARSER, 173
DBMS_XMLQUERY, 174
DBMS_XMLSAVE, 175
DBMS_XMLSCHEMA, 176
UriFactory, 245
Package - UriFactory, 245
package overview, 1
package variables
i_am_a_refresh, 93
packages
creating, 1
DBMS_MGD_ID_UTL, 89
referencing, 1
where documented, 1
PARA function
of HTF package, 182
PARA procedure
of HTP package, 183
PARAGRAPH function
of HTF package, 182
PARAGRAPH procedure
of HTP package, 183
PARAM function
of HTF package, 182
PARAM procedure
of HTP package, 183
PARSE Procedure, 75
PARSE procedure, 136, 173
PARSEBUFFER procedure, 173
PARSECLOB procedure, 173
PARSEDTD procedure, 173
PARSEDTDBUFFER procedure, 173
PARSEDTDCLOB procedure, 173
PATCHREPOSITORYRESCONFIGLIST Procedure, 118
PATH_ITEM_T Record Type, 47
PATH_ITEMS_T Table Type, 47
PATHIDTABLE Function, 40
PAUSE_PROFILER function and procedure, 106
PAUSE_REPLAY Procedure, 160
PIECEWISE member procedure
of ANYDATA TYPE, 240
of ANYDATASET TYPE, 241
PING procedure, 52
PLAINTEXT function
of HTF package, 182
PLAINTEXT procedure
of HTP package, 183
plan stability, 99
PL/SQL
datatypes, 57
numeric codes for, 57
functions
DBMS_MGWADM package subprograms, 90
DBMS_MGWMSG package subprograms, 91
procedures
DBMS_MGWADM package subprograms, 90
DBMS_MGWMSG package subprograms, 91
PL/SQL package
DBMS_HS_PARALLEL, 74
PLSQL_TRACE_VERSION procedure, 151
pointer to
CTX_ADM package, 6
point-in-time recovery
Oracle Streams, 144
POISSON_DIST_FIT procedure, 140
POPULATE_DIVERGENCE Procedure, 160
PORT_STRING function, 156
POST_INSTANTIATION_SETUP procedure, 144
PRE_INSTANTIATION_SETUP procedure, 144
PRECLOSE function
of HTF package, 182
PRECLOSE procedure
of HTP package, 183
predictive analytics, 104
PREOPEN function
of HTF package, 182
PREOPEN procedure
of HTP package, 183
PREPARE Procedure, 160
PREPARE_COLUMN_VALUES procedures, 141, 141
PREPARE_COLUMN_VALUES_NVARCHAR2 procedure, 141
PREPARE_COLUMN_VALUES_ROWID procedure, 141
PREPARE_GLOBAL_INSTANTIATION procedure, 32
PREPARE_SCHEMA_INSTANTIATION procedure, 32
PREPARE_SYNC_INSTANTIATION function, 32
PREPARE_TABLE_INSTANTIATION procedure, 32
PRINT function
of HTF package, 182
PRINT procedure
of HTP package, 183
PRINT_BACKTRACE procedure, 52
PRINT_CGI_ENV procedure, 194
PRINT_INSTANTIATIONS procedure, 52
PRINT_MULTI procedure, 193
PRINT_POST_PROCESSED_SOURCE Procedure, 105
PRINT_ROW_LIST procedure, 193
PRINTS procedure
of HTP package, 183
privileges
granting, 65
Oracle Streams administrator, 146, 146
revoking, 65
PRN function
of HTF package, 182
PRN procedure
of HTP package, 183
PROBE_VERSION procedure, 52
PROCESS_RECORDING Procedure, 160
PROCESS_RULES procedure, 123
PROCESSLINKS Procedure, 163
PROCESSXSL function, 180
PROGRAM_INFO Record Type, 52
PROP_ITEM_T Record Type, 47
PROP_ITEMS_T Table Type, 47
PROPAGATEORIGINALEXCEPTION procedure, 174, 175
propagations
altering, 107
creating, 107, 144, 144, 144, 144, 144
DBMS_PROPAGATION_ADM package, 107
dropping, 107
propagation user, 144
rules
defining global, 144
defining message, 144
defining schema, 144
defining subset, 144
defining table, 144
for LCRs, 144
for user messages, 144
starting, 107
stopping, 107
PROPANY Functions, 47
PROPERTIES_T Table Type, 47
PROPERTIESH2T Function, 47
PROPERTIEST2H Function, 47
PROPERTY_T Record Type, 47
PROPNUMBER Function, 47
PROPRAW Function, 47
PROPTIMESTAMP Function, 47
PROPVARCHAR2 Function, 47
PS procedure
of HTP package, 183
PUBLISH_PENDING_STATS Procedure, 141
PULL_SIMPLE_TABLESPACE procedure, 149
PULL_TABLESPACES procedure, 149
PURGE Procedure, 132
PURGE procedure, 103
PURGE_COMPARISON Procedure, 35
PURGE_EVENTS procedure, 123
PURGE_FILE_GROUP procedure, 67
PURGE_LOST_DB_ENTRY procedure, 152
PURGE_MIXED procedure, 152
PURGE_PROCESSED_CHUNKS Procedure, 101
PURGE_QUEUE_TABLE Procedure, 23
PURGE_SOURCE_CATALOG procedure, 144
PURGE_STATS procedure, 141
PURGEALL Procedure, 47, 48
PURGELDAPCACHE function, 168
PURGEPATH Procedure, 47, 48
PURGERESOURCEMETADATA Procedure, 163
PURGESCHEMA Procedure, 176
purging
the subscription window, 34
PUT procedure, 223
PUT procedures, 100
PUT_FILE procedure, 68
PUT_LINE Procedure, 223
PUT_LINE procedures, 100
PUT_LINE_NCHAR procedure, 223
PUT_NCHAR procedure, 223
PUT_RAW function, 223
PUTF procedure, 223
PUTF_NCHAR procedure, 223
PUTPATH Procedures, 47, 48

Q

QNAMEIDTABLE Function, 40
QUALIFIED_SQL_NAME Function, 26
queues
AnyData
creating, 144
removing, 144
QUICK_TUNE Procedure, 18
QUIT function and procedure, 235
QUOTED_PRINTABLE_DECODE function, 222
QUOTED_PRINTABLE_ENCODE function, 222

R

RANDOM procedure, 108
RCPT function, 235
RE$ATTRIBUTE_VALUE type, 256
RE$ATTRIBUTE_VALUE_LIST type, 256
RE$COLUMN_VALUE type, 256, 256
RE$COLUMN_VALUE_LIST type, 256
RE$NAME_ARRAY type, 256
RE$NV_ARRAY type, 256
RE$NV_LIST type, 256
ADD_PAIR member procedure, 256
GET_ALL_NAMES member function, 256
GET_VALUE member function, 256
REMOVE_PAIR member procedure, 256
RE$RULE_HIT type, 256
RE$RULE_HIT_LIST type, 256
RE$TABLE_ALIAS type, 256
RE$TABLE_ALIAS_LIST type, 256
RE$TABLE_VALUE type, 256
RE$TABLE_VALUE_LIST type, 256
RE$VARIABLE_TYPE type, 256
RE$VARIABLE_TYPE_LIST type, 256
RE$VARIABLE_VALUE type, 256
RE$VARIABLE_VALUE_LIST type, 256
READ Procedures, 82
READ_CLIENT_INFO procedure, 20
READ_LINE function, 237
READ_LINE procedure
of UTL_HTTP, 224
READ_MODULE procedure, 20
READ_ONLY procedure, 152
READ_RAW function, 237
READ_RAW procedure
of UTL_HTTP, 224
READ_TEXT function, 237
READ_TEXT procedure
of UTL_HTTP, 224
READ_WRITE procedure, 152
READ2CLOB function, 180
Real-time SQL Monitoring Subprograms, 139
REASSOCIATE_FBA Procedure, 70
REBUILD_FREELISTS procedure, 112
REBUILDHIERARCHICALINDEX Procedure, 164
RECEIVE_MESSAGE function, 103
RECHECK Function, 35
RECOMP_PARALLEL procedure, 233
RECOMP_SERIAL procedure, 233
RECONFIGCACHE Procedure, 49
REDIRECT_URL procedure, 194
refresh
materialized views, 93, 93, 93
REFRESH_CATEGORY function, 89
REFRESH_MVIEW procedure, 41, 41
REGISTER Procedure, 19
REGISTER_DEPENDENT_OBJECT procedure, 110
REGISTER_FOREIGN_QUEUE Procedure, 90
REGISTERPARAMETER Procedure, 172
REGISTERSCHEMA procedure, 176
REGISTERSTORE Procedure, 47
REGISTERSTORECOMMAND Procedur, 49
REGISTERTOKENTABLESET Procedure, 40
REGISTERURI procedure, 176
REGISTERURLHANDLER procedure, 245
RELEASE function, 83
REMAP_CONNECTION Procedure, 160
REMAP_STGTAB_SQLPROF Procedure, 139
REMAP_STGTAB_SQLSET Procedure, 139
REMOVE Procedure, 169
REMOVE procedure
of DBMS_ALERT package, 19
of DBMS_JOB package, 78
of OWA_COOKIE package, 187
REMOVE_AGENT Procedure, 90
REMOVE_CATEGORY procedure, 89
REMOVE_COLORED_SQL Procedure, 161
REMOVE_FILE procedure, 67
REMOVE_JOB Procedure, 90
REMOVE_MSGSYSTEM_LINK Procedure, 90
REMOVE_OPTION Procedure, 90
REMOVE_PAIR member procedure, 256
REMOVE_PIPE function, 103
REMOVE_PROXY procedure, 89
REMOVE_QUEUE procedure, 144
REMOVE_RULE procedure, 127, 144
REMOVE_SCHEME procedure, 89
REMOVE_SQLSET_REFERENCE procedure, 139
REMOVE_STMT_FROM_HANDLER procedure, 147
REMOVE_STMT_HANDLER procedure, 21
REMOVE_STREAMS_CONFIGURATION procedure, 144
REMOVE_SUBSCRIBER Procedure, 90
REMOVEALL procedure, 19
REMOVEATTRIBUTE procedure, 170
REMOVEATTRIBUTENODE function, 170
REMOVENAMEDITEM function, 170
REMOVEPARAM procedure, 180
REMOVEXSLTPARAM procedure, 174, 175
RENAME_BASELINE Procedure, 161
RENAME_COLUMN member procedure, 248
RENAME_COLUMN procedure, 144
RENAME_SCHEMA procedure, 144
RENAME_TABLE procedure, 144
RENAMEPATH Procedure, 48
RENAMEPATH Procedures, 47
RENAMERESOURCE procedure, 163
REPLACECHILD function, 170
REPLACEDATA procedure, 170
replication
Oracle Streams
configuring, 144, 144, 144, 144, 144, 144, 144, 144
split and merge, 144, 144, 144
REPLY, REPLIES record types, 235
REPORT Function, 159, 160
REPORT_ANALYSIS_TASK Function, 138
REPORT_AUTO_TUNING_TASK Function, 139
REPORT_DIAGNOSIS_TASK Function, 137
REPORT_SQL_DETAIL Function, 139
REPORT_SQL_MONITOR Function, 139
REPORT_SQL_MONITOR_LIST Function, 139
REPORT_TUNING_TASK function, 28, 139
REQUEST function, 83, 224
REQUEST_PIECES function, 224
RESET_ANALYSIS_TASK Procedure, 138
RESET_BUFFER procedure, 103
RESET_DIAGNOSIS_TASK Procedure, 137
RESET_GLOBAL_PREFS_DEFAULTS Procedure, 141
RESET_JOB Procedure, 90
RESET_PACKAGE Procedure, 131
RESET_PARAM_DEFAULTS Procedure, 141
RESET_SESSION procedure, 123
RESET_SQLWKLD Procedure, 18
RESET_SUBSCRIBER Procedure, 90
RESET_TASK Procedure, 18
RESET_TUNING_TASK procedure, 139
RESETPARAMS procedure, 180
RESOLVENAMESPACEPREFIX function, 170
RESTARTQUERY procedure, 171
RESTORE function, 142
RESTORE_DATBASE_STATS procedure, 141
RESTORE_DEFAULTS Procedure, 37
RESTORE_DICTIONARY_STATS procedure, 141
RESTORE_FIXED_OBJECTS_STATS procedure, 141
RESTORE_SCHEMA_STATS procedure, 141
RESTORE_SYSTEM_STATS procedure, 141
RESTORE_TABLE_STATS procedure, 141
RESTOREALL Procedure, 47, 48
RESTOREPATH Procedure, 47, 48
RESUME_ANALYSIS_TASK Procedure, 138
RESUME_DIAGNOSIS_TASK Procedure, 137
RESUME_PROFILER function and procedure, 106
RESUME_REPLAY Procedure, 160
RESUME_TASK Procedure, 101
RESUME_TUNING_TASK Procedure, 139
REUSE_REPLAY_FILTER_SET Procedure, 160
REVERSE function, 232
REVOKE_ADMIN_PRIVILEGE procedure, 146
REVOKE_OBJECT_PRIVILEGE procedure, 67, 127
REVOKE_PRIVILEGE procedure, 65, 123
REVOKE_REMOTE_ADMIN_ACCESS procedure, 146
REVOKE_SWITCH_CONSUMER_GROUP procedure, 120
REVOKE_SYSTEM_PRIVILEGE procedure, 67, 120, 127
RLM$EVENTIDS object type, 257
ROLLBACK procedure, 152
ROLLBACK_FORCE procedure, 152
ROLLBACK_SAVEPOINT procedure, 152
row migration, 144, 144
ROWID datatype
extended format, 125
ROWID_BLOCK_NUMBER function, 125
ROWID_CREATE function, 125
ROWID_INFO procedure, 125
ROWID_OBJECT function, 125
ROWID_RELATIVE_FNO function, 125
ROWID_ROW_NUMBER function, 125
ROWID_TO_ABSOLUTE_FNO function, 125
ROWID_TO_EXTENDED function, 125
ROWID_TO_RESTRICTED function, 125
ROWID_TYPE function, 125
ROWID_VERIFY function, 125
rule sets
adding rules to, 127
creating, 127
dropping, 127
removing rules from, 127
rule-based transformations
setting, 144
rules
action contexts
adding name-value pairs, 256
getting name-value pairs, 256
getting value for name, 256
removing name-value pairs, 256
transformations, 144
altering, 127
creating, 127
DBMS_RULE package, 126
DBMS_RULE_ADM package, 127
dropping, 127
evaluation, 126
iterators, 126, 126
evaluation contexts
altering, 127
creating, 127
dropping, 127
inbound servers, 144
object privileges
granting, 127
revoking, 127
outbound servers, 144
propagations
removing, 144
RE$ATTRIBUTE_VALUE type, 256
RE$ATTRIBUTE_VALUE_LIST type, 256
RE$COLUMN_VALUE type, 256, 256
RE$COLUMN_VALUE_LIST type, 256
RE$NAME_ARRAY type, 256
RE$NV_ARRAY type, 256
RE$NV_LIST type, 256
RE$RULE_HIT type, 256
RE$RULE_HIT_LIST type, 256
RE$TABLE_ALIAS type, 256
RE$TABLE_ALIAS_LIST type, 256
RE$TABLE_VALUE type, 256
RE$TABLE_VALUE_LIST type, 256
RE$VARIABLE_TYPE type, 256
RE$VARIABLE_TYPE_LIST type, 256
RE$VARIABLE_VALUE type, 256
RE$VARIABLE_VALUE_LIST type, 256
subset
defining, 144, 144
system privileges
granting, 127
revoking, 127
system-created, 144
global apply, 144
global capture, 144
global propagation, 144
global schema, 144
message, 144, 144
message propagation, 144
removing, 144
schema capture, 144
schema propagation, 144
subset apply, 144
subset capture, 144
subset propagation, 144
table apply, 144
table capture, 144
table propagation, 144
types, 256
Rules Manager object types, 257
RUN procedure, 78
RUN_CHECK Procedure, 72
RUN_TASK Procedure, 101
RUNTIME_INFO Record Type, 52

S

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

T

table alias
attributes, 247
TABLE_CREATE procedure, 43
TABLE_TO_COMMA procedures, 156
TABLECAPTION function
of HTF package, 182
TABLECAPTION procedure
of HTP package, 183
TABLECLOSE function
of HTF package, 182
TABLECLOSE procedure
of HTP package, 183
TABLEDATA function
of HTF package, 182
TABLEDATA procedure
of HTP package, 183
TABLEHEADER function
of HTF package, 182
TABLEHEADER procedure
of HTP package, 183
TABLEOPEN function
of HTF package, 182
TABLEOPEN procedure
of HTP package, 183
TABLEPRINT function, 194
TABLEROWCLOSE function
of HTF package, 182
TABLEROWCLOSE procedure
of HTP package, 183
TABLEROWOPEN function
of HTF package, 182
TABLEROWOPEN procedure
of HTP package, 183
tables
comparing, 35
table items as arrays, 136
tablespace repositories
attaching tablespaces, 149
cloning tablespaces, 149
detaching tablespaces, 149
TABLESPACE_FIX_BITMAPS procedure, 134
TABLESPACE_FIX_SEGMENT_STATES procedure, 134
TABLESPACE_MIGRATE_FROM_LOCAL procedure, 134
TABLESPACE_MIGRATE_TO_LOCAL procedure, 134
TABLESPACE_REBUILD_BITMAPS procedure, 134
TABLESPACE_REBUILD_QUOTAS procedure, 134
TABLESPACE_RELOCATE_BITMAPS procedure, 134
TABLESPACE_SET type, 149
TABLESPACE_VERIFY procedure, 134
tablespaces
change tables and, 33
tags
GET_TAG function, 143, 144
SET_TAG procedure, 143, 144
TARGET_FILE function, 43
TARGET_LOB function, 43
TARGET_PROGRAM_RUNNING procedure, 52
TARGET_TABLE function, 43
TARGET_TRACE function, 43
TELETYPE function
of HTF package, 182
TELETYPE procedure
of HTP package, 183
TERMINATE procedure, 108
TEXT_DECODE function, 222
TEXT_ENCODE function, 222
TIME_TABLE Table Type, 136
TIME_WITH_TIME_ZONE_TABLE Table Type, 136
TIMESTAMP_TABLE Table Type, 136
TIMESTAMP_WITH_LTZ_TABLE Table Type, 136
TIMESTAMP_WITH_TIME_ZONE_TABLE Table Type, 136
TITLE function
of HTF package, 182, 182
TITLE procedure
of HTP package, 183
TO_CURSOR_NUMBER Function, 136
TO_REFCURSOR Function, 136
TO_STRING function, 255
TODATE function, 194
TOOBJECT procedure, 259
TOUCHRESOURCE Procedure, 163
TRACE Procedure, 47
TRACE procedure, 42
TRACEENABLED Function, 47
TRACETAB.SQL, 151
tracking LCRs, 144, 144
TRANSACTION_BACKOUT Procedures, 69
TRANSFORM function, 259
transformations
rule-based
adding a column, 144
custom, 144
deleting a column, 144
keeping columns, 144
renaming a column, 144
renaming a schema, 144
renaming a table, 144
STREAMS$_TRANSFORM_FUNCTION, 144
TRANSFORMNODE function, 180
TRANSLATE function, 232, 255
TRANSLATEXML Function, 178
TRANSLITERATE Function, 225, 232
transparent data encryption
apply process, 21
TRANSPORT_SET_CHECK procedure, 154
TRIM Procedures, 82
TUNE_MVIEW Procedure, 18
TYPE_BUILD function, 43
TYPE_DIMENSION_COMPILE function, 43
TYPE_OPERATIONS function, 43
TYPE_REJECTED_RECORDS function, 43
types
Expression Filter, 247
MGD_ID, 255, 255
MGD_ID_COMPONENT, 255
MGD_ID_COMPONENT_VARRAY, 255
Oracle Multimedia
ORDAudio, 249
ORDDicom, 250
ORDDoc, 251
ORDImage, 252
ORDVideo, 254
SQL/MM Still Image, 253
Rules Manager, 257

U

ULISTCLOSE function
of HTF package, 182
ULISTCLOSE procedure
of HTP package, 183
ULISTOPEN function
of HTF package, 182
ULISTOPEN procedure
of HTP package, 183
UNASSIGN_ACL Procedure, 94
UNASSIGN_ATTRIBUTE_SET procedure, 65
UNASSIGN_WALLET_ACL Procedure, 94
UNCHECKOUT function, 165
UNCL_ARRAY Table Type, 156
UNDERLINE function
of HTF package, 182
UNDERLINE procedure
of HTP package, 183
UNESCAPE function, 238
UNESCAPEURI function, 245
UNIFORM_DIST_FIT procedure, 140
UNIQUE_SESSION_ID Function, 131
UNIQUE_SESSION_NAME function, 103
UNKEEP procedure, 132
UNLOCK_MAP procedure, 142
UNLOCK_PARTITION_STATS Procedure, 141
UNLOCK_SCHEMA_STATS procedure, 141
UNLOCK_TABLE_STATS procedure, 141
UNLOCKPATH Procedure, 47, 48
UNLOCKRESOURCE function, 163
UNMAP_DAD Procedure, 63
UNMARKHOT Procedure, 132
UNMOUNTSTORE Procedure, 47
UNPACK_MESSAGE procedures, 103
UNPACK_STGTAB_BASELINE Function, 135
UNPACK_STGTAB_SQLPATCH Procedure, 137
UNPACK_STGTAB_SQLPROF Procedure, 139
UNPACK_STGTAB_SQLSET Procedure, 139
UNREGISTER_DEPENDENT_OBJECT procedure, 110
UNREGISTER_FOREIGN_QUEUE Procedure, 90
UNREGISTERSTORE Procedure, 47
UNREGISTERURLHANDLER procedure, 245
UNSCHEDULE_PROPAGATION Procedure, 90
UNUSED_SPACE procedure, 133
UPDATE_BY_CAT procedure, 99
UPDATE_CATEGORY Procedure, 119
UPDATE_CONSUMER_GROUP procedure, 119
UPDATE_OBJECT Procedure, 18
UPDATE_OBJECT procedure, 234
UPDATE_PLAN procedure, 119
UPDATE_PLAN_DIRECTIVE procedure, 119
UPDATE_REC_ATTRIBUTES Procedure, 18
UPDATE_SIGNATURES procedure, 99
UPDATE_SQLSET procedures, 139
UPDATE_SQLWKLD_ATTRIBUTES Procedure, 18
UPDATE_SQLWKLD_STATEMENT Procedure, 18
UPDATE_TASK_ATTRIBUTES Procedure, 18
UPDATERESOURCEMETADATA Procedures, 163
UPDATETRANSLATION Function, 178
UPDATEXML function, 175, 177
UPGRADE_DATABASE Procedure, 60
UPGRADE_SCHEMA Procedure, 60
UPGRADE_STAT_TABLE procedure, 141
UPGRADE_TABLE Procedure, 60
upgrading
post-upgrade actions, 96
URI Types
description, 245
UriFactory package, 245
ESCAPEURI function, 245
GETURL function, 245
methods, 245
REGISTERURLHANDLER procedure, 245
UNESCAPEURI function, 245
UNREGISTERURLHANDLER procedure, 245
UriType supertype, 245
GETBLOB function, 245
GETCLOB function, 245
GETCONTENTTYPE function, 245
GETEXTERNALURL function, 245
GETURL function, 245
GETXML function, 245
methods, 245
UROWID_TABLE Table Type, 136
USE_FILTER_SET Procedure, 160
USE_ROLLBACK_SEGMENT procedure, 152
USEBINARYSTREAM Function, 170
USEITEMTAGSFORCOLL procedure, 171
USENULLATTRIBUTEINDICATOR procedure, 171, 174
USER_EXPORT procedures, 78
USETYPEFORCOLLELEMTAG procedure, 174
Using DBMS_ADVISOR, 18
Using DBMS_AQIN, 25, 25
Using DBMS_FILE_GROUP, 67
Using DBMS_MVIEW, 93
Using DBMS_RULE, 126
Using DBMS_RULE_ADM, 127
Using DBMS_STREAMS, 143
Using DBMS_STREAMS_ADM, 144
Using DBMS_STREAMS_TABLESPACE_ADM, 149
Using DBMS_XMLDOM, 170
Using DBMS_XMLSCHEMA, 176
Using UTL_HTTP, 224
UTL Streams Types, 258
UTL_BINARYINPUTSTREAM Type, 258
UTL_BINARYOUTPUTSTREAM Type, 258
UTL_CHARACTERINPUTSTREAM Type, 258
UTL_CHARACTEROUTPUTSTREAM Type, 258
UTL_COLL package, 220
UTL_COMPRESS package, 221
UTL_ENCODE package, 222
UTL_FILE package, 223
UTL_HTTP package, 224
UTL_I18N package, 225
ESCAPE_REFERENCE function, 225, 225, 225, 225, 225, 225, 225
GET_DEFAULT_CHARSET function, 225
MAP_CHARSET function, 225
MAP_LANGUAGE_FROM_ISO function, 225
MAP_LOCALE_TO_ISO function, 225
MAP_TERRITORY_FROM_ISO function, 225
RAW_TO_CHAR function, 225
RAW_TO_NCHAR function, 225
UNESCAPE_REFERENCE function, 225
UTL_INADDR package, 226
UTL_LMS package, 228
FORMAT_MESSAGE function, 228
GET_MESSAGE function, 228
UTL_MAIL package, 229
UTL_MATCH package, 230
UTL_NLA package, 231
UTL_RAW package, 232
UTL_RECOMP package, 233
UTL_REF package, 234
UTL_SPADV package, 236
UTL_TCP package, 237
UTL_URL package, 238
UUDECODE function, 222
UUENCODE function, 222

V

V$STREAMS_MESSAGE_TRACKING view, 144, 144
v$vpd_policies, 124
VALIDATE procedure, 156
VALIDATE_DIMENSION procedure, 59
VALIDATE_EXPRESSIONS procedure, 65
VALIDATE_PENDING_AREA procedure, 119
VALIDATE_REWRITE_EQUIVALENCE Procedure, 17
VALIDATE_SCHEME function, 89
VALIDATE_XML procedure, 41
VALUE functions, 108
VALUEOF procedure, 180
VARCHAR2_TABLE Table Type, 136
VARCHAR2A Table Type, 136
VARCHAR2S Table Type, 136
VARIABLE function
of HTF package, 182
VARIABLE procedure
of HTP package, 183
VARIABLE_VALUE procedures, 136
VERBOSE_ACTION function, 43
VERBOSE_DEBUG function, 43
VERBOSE_INFO function, 43
VERBOSE_NOTICE function, 43
VERBOSE_STATS function, 43
VERIFY_VALUES function, 190
VERSION function, 43
views
comparing, 35
virtual dependency definitions
object dependencies
creating, 21
dropping, 21
value dependencies, 21
Virtual Private Database. See VPD
VPD
column masking, 124
enabling column-level, 124
viewing current cursors and policy predicates, 124
VPD use of DBMS_RLS, 124
VRFY function, 235

W

WAIT_ON_PENDING_DML Procedure, 156
WAITANY procedure, 19
WAITONE procedure, 19
WBR function
of HTF package, 182
WBR procedure
of HTP package, 183
WEIBULL_DIST_FIT procedure, 140
WHAT procedure, 78
WHO_CALLED_ME procedure, 194
WPG_DOCLOAD package, 239
WRAP Functions, 53
WRITE Procedures, 82
WRITE_DATA procedure, 235
WRITE_LINE function, 237
WRITE_LINE procedure, 224
WRITE_RAW function, 237
WRITE_RAW procedure, 224
WRITE_RAW_DATA procedure, 235
WRITE_TEXT function, 237
WRITE_TEXT procedure, 224
WRITEAPPEND Procedures, 82
WRITETOBUFFER procedure, 170
WRITETOCLOB procedure, 170
WRITETOFILE procedure, 170

X

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