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

B28419-03
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, 108
ABORT_GLOBAL_INSTANTIATION procedure, 28
ABORT_REDEF_TABLE procedure, 95
ABORT_SCHEMA_INSTANTIATION procedure, 28
ABORT_TABLE_INSTANTIATION procedure, 28
ABORTED_REQUEST_THRESHOLD procedure, 118
ACCEPT_SQL_PATCH Procedure, 123
ACCEPT_SQL_PROFILE procedure, 125
ACLCHECKPRIVILEGES function, 148
ACTIVATE_SUBSCRIPTION Procedure, 30
ACTIVE_INSTANCES procedure, 141
ADD_COLORED_SQL Procedure, 146
ADD_COLUMN member procedure, 228
ADD_COLUMN procedure, 130
ADD_COOKIES procedure, 207
ADD_COST_MATRIX procedure, 38
ADD_ELEMENTARY_ATTRIBUTE procedure, 53, 109
ADD_EVENT procedure, 109
ADD_FILE procedure, 55
ADD_FILTER Procedure, 144
ADD_FUNCTIONS procedure, 53, 109
ADD_GLOBAL_PROPAGATION_RULES procedure, 130
ADD_GLOBAL_RULES procedure, 130
ADD_MESSAGE_PROPAGATION_RULE procedure, 130
ADD_MESSAGE_RULE procedure, 130
ADD_PAIR member procedure, 236
ADD_PRIVILEGE Procedure, 80
ADD_RULE procedure, 109, 113
ADD_SCHEMA_PROPAGATION_RULES procedure, 130
ADD_SCHEMA_RULES procedure, 130
ADD_SCHEME procedure, 75
ADD_SQLSET_REFERENCE function, 125
ADD_SQLWKLD_REF Procedure, 17
ADD_SQLWKLD_STATEMENT Procedure, 17
ADD_SUBSCRIBER Procedure, 76
ADD_SUBSET_PROPAGATION_RULES procedure, 130
ADD_SUBSET_RULES procedure, 130
ADD_TABLE_PROPAGATION_RULES procedure, 130
ADD_TABLE_RULES procedure, 130
ADD_WARNING_SETTING_CAT procedure, 142
ADD_WARNING_SETTING_NUM procedure, 142
ADD2MULTI procedure, 178
ADDATTR member procedure
of ANYTYPE TYPE, 223
ADDINSTANCE member procedure
of ANYDATASET TYPE, 222
ADDMIMEMAPPING Procedure, 148
ADDREPOSITORYRESCONFIG Procedure, 104
ADDRESCONFIG Function, 104
ADDRESS function
of HTF package, 167
ADDRESS procedure
of HTP package, 168
ADDSCHEMALOCMAPPING Procedure, 148
ADDSERVLET Procedure, 148
ADDSERVLETMAPPING Procedure, 148
ADDSERVLETSECROLE Procedure, 148
ADDXMLEXTENSION Procedure, 148
ADMIN_TABLES procedure, 97
ADVISE_COMMIT procedure, 137
ADVISE_NOTHING procedure, 137
ADVISE_ROLLBACK procedure, 137
advisors
Oracle Streams, 131
ALLOCATE_UNIQUE procedure, 70
ALTER_AGENT Procedure, 76
ALTER_APPLY procedure, 20
ALTER_CAPTURE procedure, 28
ALTER_COMPILE procedure, 42
ALTER_EVALUATION_CONTEXT procedure, 113
ALTER_FILE procedure, 55
ALTER_FILE_GROUP procedure, 55
ALTER_JOB Procedure, 76
ALTER_MSGSYSTEM_LINK Procedure for TIB/Rendezvous, 76
ALTER_MSGSYSTEM_LINK Procedure for WebSphere MQ, 76
ALTER_PARAM Procedure, 32
ALTER_PROPAGATION procedure, 92
ALTER_PROPAGATION_SCHEDULE Procedure, 76
ALTER_REVERSE_EXPRESSION procedure, 38
ALTER_REWRITE_EQUIVALENCE Procedure, 16
ALTER_RULE procedure, 113
ALTER_SQL_PATCH Procedure, 123
ALTER_SQL_PLAN_BASELINE Procedure, 121
ALTER_SQL_PROFILE procedure, 125
ALTER_STATS_HISTORY_RETENTION procedure, 127
ALTER_SUBSCRIBER Procedure, 76
ALTER_SYNC_CAPTURE procedure, 28
ALTER_TABLE_NOT_REFERENCEABLE procedure, 42
ALTER_TABLE_REFERENCEABLE procedure, 42
ALTER_VERSION procedure, 55
AMATCH function, 176
ANALYZE Function, 60
ANALYZE Procedure, 27
ANALYZE_CURRENT_PERFORMANCE procedure, 131
ANALYZE_DATABASE Procedure, 141
ANALYZE_DB Procedure, 15
ANALYZE_INST Procedure, 15
ANALYZE_PART_OBJECT procedure, 141
ANALYZE_PARTIAL Procedure, 15
ANALYZE_SCHEMA Procedure, 141
ANCHOR function
of HTF package, 167
ANCHOR procedure
of HTP package, 168
ANCHOR2 function
of HTF package, 167
ANCHOR2 procedure
of HTP package, 168
anonymous PL/SQL blocks
dynamic SQL and, 122
AnyData datatype
queues
creating, 130
removing, 130
ANYDATA TYPE, 221
ANYDATASET TYPE, 222
ANYTYPE TYPE, 223
APEX_APPLICATION package documentation, 3
APEX_CUSTOM_AUTH package documentation, 2
APEX_ITEM package documentation, 4
APPEND Procedures, 69
APPENDCHILD function, 155
APPENDDATA procedure, 155
APPENDPATH Procedure, 148
APPENDRESCONFIG Procedure, 104
APPENDRESOURCEMETADATA Procedure, 148
APPLETCLOSE function
of HTF package, 167
APPLETCLOSE procedure
of HTP package, 168
APPLETOPEN function
of HTF package, 167
APPLETOPEN procedure
of HTP package, 168
APPLY procedure, 38
apply process
altering, 20
apply user, 130
conflict handlers
setting, 20
creating, 20, 130, 130, 130, 130, 130
DBMS_APPLY_ADM package, 20
DDL handler
setting, 20, 20
DML handlers
setting, 20
dropping, 20
enqueuing events, 20
error handlers
setting, 20
error queue
deleting errors, 20, 20
executing errors, 20, 20
getting error messages, 20
instantiation
global SCN, 20
schema SCN, 20
table SCN, 20
message handler
setting, 20, 20
parameters
allow_duplicate_rows, 20
commit_serialization, 20
disable_on_error, 20
disable_on_limit, 20
maximum_scn, 20
parallelism, 20
preserve_encryption, 20
setting, 20
startup_seconds, 20, 20
time_limit, 20
trace_level, 20
transaction_limit, 20
txn_lcr_spill_threshold, 20
precommit handler
setting, 20, 20
rules
defining global, 130
defining message, 130
defining schema, 130
defining subset, 130
defining table, 130
for LCRs, 130
for user messages, 130
removing, 130
specifying execution, 20
starting, 20
stopping, 20
substitute key columns
setting, 20
transparent data encryption, 20
APPLY$_ENQUEUE, 20
APPLY$_EXECUTE, 20
AQ$_AGENT Type, 224
AQ$_AGENT_LIST_T Type, 224
AQ$_DESCRIPTOR Type, 224, 224
AQ$_NTFN_MSGID_ARRAY Type, 224
AQ$_POST_INFO Type, 224
AQ$_POST_INFO_LIST Type, 224
AQ$_PURGE_OPTIONS_T Type, 224
AQ$_RECIPIENT_LIST_T Type, 224
AQ$_REG_INFO Type, 224
AQ$_REG_INFO_LIST Type, 224
AQ$_SUBSCRIBER_LIST_T Type, 224
AREA function
of HTF package, 167
AREA procedure
of HTP package, 168
arrays
BIND_ARRAY procedure, 122
bulk DML using DBMS_SQL, 122
ASA_RECO_ROW Record Type, 119
ASA_RECO_ROW_TB Table Type, 119
ASA_RECOMMENDATIONS Function, 119
ASH_REPORT_HTML Function, 146
ASH_REPORT_TEXT Function, 146
ASSIGN_ACL Procedure, 80
ASSIGN_ATTRIBUTE_SET procedure, 53
ASSM_SEGMENT_VERIFY Procedure, 120
ASSM_TABLESPACE_VERIFY Procedure, 120
ATTACH_SESSION procedure, 43
ATTACH_SIMPLE_TABLESPACE procedure, 134
ATTACH_TABLESPACES procedure, 134
attribute sets
dropping, 53
AUTHORIZE function, 173
AUTHORIZE_DAD Procedure, 51
AVAILABLE function, 218
AWR_BASELINE_METRIC_TYPE Object Type, 146
AWR_BASELINE_METRIC_TYPE_TABLE Table Type, 146
AWR_DIFF_REPORT_HTML Function, 146
AWR_DIFF_REPORT_TEXT Function, 146
AWR_REPORT_HTML function, 146
AWR_REPORT_TEXT function, 146
AWR_SQL_REPORT_HTML Function, 146
AWR_SQL_REPORT_TEXT Function, 146

B

BASE function
of HTF package, 167
BASE procedure
of HTP package, 168
BASE64_DECODE function, 205
BASE64_ENCODE function, 205
BASEFONT function
of HTF package, 167
BASEFONT procedure
of HTP package, 168
BEGIN_DISCRETE_TRANSACTION procedure, 137
BEGIN_REQUEST function, 207
BEGINCREATE static procedure
of ANYDATA TYPE, 221
of ANYDATASET TYPE, 222
of ANYTYPE TYPE, 223
BFILE_TABLE Table Type, 122
BGSOUND function
of HTF package, 167
BGSOUND procedure
of HTP package, 168
BIG function
of HTF package, 167
BIG procedure
of HTP package, 168
BINARY_DOUBLE_TABLE Table Type, 122
BINARY_FLOAT_TABLE Table Type, 122
BIND_ARRAY procedures, 122
BIND_INOUT_VARIABLE Procedure, 62
BIND_INOUT_VARIABLE_RAW Procedure, 62
BIND_OUT_VARIABLE Procedure, 62
BIND_OUT_VARIABLE_RAW Procedure, 62
BIND_VARIABLE Procedure, 62
BIND_VARIABLE procedures, 122
BIND_VARIABLE_RAW Procedure, 62
BIND_VARIABLES function, 179
BIT_AND function, 213
BIT_COMPLEMENT function, 213
BIT_OR function, 213
BIT_XOR function, 213
BLAS Level 1 (Vector-Vector Operations) Subprograms, 212
BLAS Level 2 (Matrix-Vector Operations) Subprograms, 212
BLAS Level 3 (Matrix-Matrix Operations) Subprograms, 212
BLAS_ASUM Functions, 212
BLAS_AXPY Procedures, 212
BLAS_COPY Procedures, 212
BLAS_DOT Functions, 212
BLAS_GBMV Procedures, 212
BLAS_GEMM Procedures, 212
BLAS_GEMV Procedures, 212
BLAS_GER Procedures, 212
BLAS_IAMAX Functions, 212
BLAS_NRM2 Functions, 212
BLAS_ROT Procedures, 212
BLAS_ROTG Procedures, 212
BLAS_SBMV Procedures, 212
BLAS_SCAL Procedure, 212
BLAS_SPMV Procedures, 212
BLAS_SPR Procedures, 212
BLAS_SPR2 Procedures, 212
BLAS_SWAP Procedure, 212
BLAS_SYMM Procedures, 212
BLAS_SYMV Procedures, 212
BLAS_SYR Procedures, 212
BLAS_SYR2 Procedures, 212
BLAS_SYRK Procedures, 212
BLAS_TBMV Procedures, 212
BLAS_TBSV Procedures, 212
BLAS_TPMV Procedures, 212
BLAS_TPSV Procedures, 212
BLAS_TRMM Procedures, 212
BLAS_TRMV Procedures, 212
BLAS_TRSM Procedures, 212
BLAS_TRSV Procedures, 212
BLOB_TABLE Table Type, 122
BLOCKQUOTECLOSE function
of HTF package, 167
BLOCKQUOTECLOSE procedure
of HTP package, 168, 168
BLOCKQUOTEOPEN function
of HTF package, 167
BLOCKQUOTEOPEN procedure
of HTP package, 168
BODYCLOSE function
of HTF package, 167
BODYCLOSE procedure
of HTP package, 168
BODYOPEN function
of HTF package, 167
BODYOPEN procedure
of HTP package, 168
BOLD function
of HTF package, 167
BOLD procedure
of HTP package, 168
BR function
of HTF package, 167
BR procedure
of HTP package, 168
BREAKPOINT_INFO Record Type, 43
BROKEN procedure, 65
BUILD procedure, 28, 36
BUILD_CHAIN_ROWS_TABLE procedure, 64
BUILD_EXCEPTIONS_TABLE procedure, 53, 64
BUILD_PART_INDEX procedure, 87
BUILD_SAFE_REWRITE_EQUIVALENCE Procedure, 16
BYPASS Procedure, 107

C

CALENDARPRINT procedures, 179
CALIBRATE Function, 145
CALIBRATE_IO Procedure, 105
CAN_REDEF_TABLE procedure, 95
CANCEL_ANALYSIS_TASK Procedure, 124
CANCEL_DIAGNOSIS_TASK Procedure, 123
CANCEL_REPLAY Procedure, 145
CANCEL_TASK Procedure, 17
CANCEL_TUNING_TASK procedure, 125
CANONICALIZE procedure, 141
capture process
altering, 28
building a Streams data dictionary, 28
capture user, 130
creating, 130, 130, 130, 130
in-flight transactions, 28
DBMS_CAPTURE_ADM package, 28
instantiation
aborting database preparation, 28
aborting schema preparation, 28
aborting table preparation, 28
preparing a database for, 28
preparing a schema for, 28
preparing a table for, 28
parameters
disable_on_limit, 28
downstream_real_time_mine, 28
maximum_scn, 28
message_limit, 28
message_tracking_frequency, 28
parallelism, 28
setting, 28
skip_autofiltered_table_ddl, 28
startup_seconds, 28
time_limit, 28
trace_level, 28
write_alert_log, 28
rules, 130
defining global, 130
defining schema, 130
defining subset, 130
defining table, 130
removing, 130
starting, 28
stopping, 28
CAPTURE_CURSOR_CACHE_SQLSET Procedure, 125
CAST_FROM_BINARY_DOUBLE function, 213
CAST_FROM_BINARY_FLOAT function, 213
CAST_FROM_BINARY_INTEGER function, 213
CAST_FROM_NUMBER function, 213
CAST_TO_BINARY_DOUBLE function, 213
CAST_TO_BINARY_FLOAT function, 213
CAST_TO_BINARY_INTEGER function, 213
CAST_TO_NUMBER function, 213
CAST_TO_NVARCHAR2 function, 213
CAST_TO_RAW function, 213
CAST_TO_VARCHAR2 function, 213
CELLSPRINT procedures, 179
CENTER function
of HTF package, 167
CENTER procedure
of HTP package, 168
CENTERCLOSE function
of HTF package, 167
CENTERCLOSE procedure
of HTP package, 168
CENTEROPEN function
of HTF package, 167
CENTEROPEN procedure
of HTP package, 168
CFG_GET function, 148
CFG_REFRESH procedure, 148
CFG_UPDATE procedure, 148
Change Data Capture
DBMS_CDC_PUBLISH package, 29
CHANGE functions and procedures, 176
CHANGE procedure, 65
change tables
tablespaces created in, 29
CHANGEOWNER Procedure, 148
CHANGEPRIVILEGES Function, 148
CHARARR Table Type, 86
CHECK_OBJECT procedure, 97
CHECK_PRIVILEGE Procedure, 80
CHECK_PRIVILEGE_ACLID Function, 80
CHECKIN function, 151
CHECKOUT procedure, 151
CHECKPRIVILEGES function, 148
CHECKSUM functions, 175
CHOOSE_DATE procedure, 179
CITE function
of HTF package, 167
CITE procedure
of HTP package, 168
CLEANUP_GATEWAY Procedure, 76
CLEANUP_INSTANTIATION_SETUP procedure, 130
CLEAR Procedure, 154
CLEAR_ALL_CONTEXT Procedure, 117
CLEAR_CONTEXT Procedure, 117
CLEAR_COOKIES procedure, 207
CLEAR_EXPRSET_STATS procedure, 53
CLEAR_IDENTIFIER Procedure, 117
CLEAR_PENDING_AREA procedure, 105
CLEAR_PLSQL_TRACE procedure, 136
CLEAR_USED procedure, 85
CLEARKEYCOLUMNLIST procedure, 160, 162
CLEARUPDATECOLUMNLIST procedure, 160, 162
CLIENT_ID_STAT_DISABLE procedure, 78
CLIENT_ID_STAT_ENABLE procedure, 78
CLIENT_ID_TRACE_DISABLE procedure, 78
CLIENT_ID_TRACE_ENABLE procedure, 78
CLOB_TABLE Table Type, 122
CLOB2FILE procedure, 165
CLONE_SIMPLE_TABLESPACE procedure, 134
CLONE_TABLESPACES procedure, 134
CLONENODE function, 155
CLOSE Procedure, 69
CLOSE_ALL_CONNECTIONS procedure, 218
CLOSE_CONNECTION procedure, 218
CLOSE_CURSOR Procedure, 62
CLOSE_CURSOR procedure, 122
CLOSE_DATABASE_LINK Procedure, 117
CLOSE_ITERATOR procedure, 112
CLOSE_PERSISTENT_CONN procedure, 207
CLOSE_PERSISTENT_CONNS procedure, 207
CLOSECONTEXT procedure, 156, 159, 160, 162
COAD_ADVICE_REC type, 37
COAD_ADVICE_T type, 37
CODE function
of HTF package, 167
CODE procedure
of HTP package, 168
COLLECT_STATS procedure, 217
collections
table items, 122
column masking for VPD, 110
COLUMN_VALUE procedure, 122
COLUMN_VALUE_LONG procedure, 122
column-level VPD, 110
COMMA_TO_TABLE procedures, 141
COMMAND function and procedure, 216
COMMAND_REPLIES function, 216
COMMENT function
of HTF package, 167
COMMENT procedure
of HTP package, 168
COMMIT procedure, 137
COMMIT_COMMENT procedure, 137
COMMIT_FORCE procedure, 137
COMPARE Function, 31
COMPARE function, 213
COMPARE Functions, 69
COMPARE_OLD_VALUES procedure, 20
COMPARISON_TYPE type, 31
COMPATIBLE_10_1 function, 129, 228
COMPATIBLE_10_2 function, 129, 228
COMPATIBLE_11_1 function, 129
COMPATIBLE_9_2 function, 129, 228
COMPILE_FROM_REMOTE procedure, 68
COMPILE_SCHEMA procedure, 141
COMPILESCHEMA procedure, 161
COMPUTE_CONFUSION_MATRIX procedure, 38
COMPUTE_LIFT procedure, 38
COMPUTE_ROC procedure, 38
CONCAT function, 213
CONDITION_REF function, 109
CONFIGURE Procedure, 121
CONFIGURE_POOL Procedure, 32
CONFIGUREAUTOSYNC procedure, 152
conflicts
detection
stopping, 20
CONNECTION record type, 216
constants
DBMS_MGWMSG package, 77
CONSUME_EVENT procedure, 109
CONSUME_PRIM_EVENT procedure, 109
CONTINUE function, 43
CONVERGE Procedure, 31
CONVERT function, 70, 156, 213
CONVERT_ANYDATA_TO_LCR_DDL function, 129
CONVERT_ANYDATA_TO_LCR_ROW function, 129
CONVERT_LCR_TO_XML function, 129
CONVERT_LONG_TO_LOB_CHUNK member procedure, 228
CONVERT_RAW_VALUE procedures, 127
CONVERT_RAW_VALUE_NVARCHAR procedure, 127
CONVERT_RAW_VALUE_ROWID procedure, 127
CONVERT_XML_TO_LCR function, 129
CONVERTTOBLOB procedure, 69
CONVERTTOCLOB Procedure, 69
COPIES function, 213
COPY Procedures, 69
COPY_ATTRIBUTE_SET procedure, 53
COPY_FILE procedure, 56
COPY_TABLE_DEPENDENTS procedure, 95
COPY_TABLE_STATS Procedure, 127
COPYDEFAULTTOKENTABLESET Procedure, 35
COPYEVOLVE procedure, 161
COPYRESOURCE Procedure, 148
CQ_NOTIFICATION$_DESCRIPTOR Object Type, 33
CQ_NOTIFICATION$_QUERY Object Type, 33
CQ_NOTIFICATION$_QUERY_ARRAY Object (Array) Type, 33
CQ_NOTIFICATION$_REG_INFO Object Type, 33
CQ_NOTIFICATION$_ROW Object Type, 33
CQ_NOTIFICATION$_TABLE Object Type, 33
CQ_NOTIFICATION$_TABLE_ARRAY Object (Array) Type, 33
CQ_NOTIFICATION_QUERYID Function, 33
CREATE PACKAGE BODY command, 1
CREATE PACKAGE command, 1
CREATE_ACL Procedure, 80
CREATE_AGENT Procedure, 76
CREATE_ALTER_TYPE_ERROR_TABLE procedure, 141
CREATE_ANALYSIS_TASK Functions, 124
CREATE_APPLY procedure, 20
CREATE_ATTRIBUTE_SET procedure, 53
CREATE_BASELINE Function & Procedure, 146
CREATE_BASELINE_TEMPLATE Procedures, 146
CREATE_BIN_CAT procedure, 39
CREATE_BIN_NUM procedure, 39
CREATE_CAPTURE procedure
capture process
creating, 28
CREATE_CATEGORY function, 75
CREATE_CLIP procedure, 39
CREATE_COL_REM procedure, 39
CREATE_COMPARISON Procedure, 31
CREATE_CONDITIONS_TABLE procedure, 109
CREATE_CONSUMER_GROUP procedure, 105
CREATE_DAD Procedure, 51
CREATE_DIAGNOSIS_TASK Functions, 123
CREATE_ERROR_LOG Procedure, 52
CREATE_EVALUATION_CONTEXT procedure, 113
CREATE_EVENT_STRUCT procedure, 109
CREATE_EXPFIL_INDEXES procedure, 109
CREATE_EXTENDED_STATS Function, 127
CREATE_FILE Procedure, 17
CREATE_FILE_GROUP procedure, 55
CREATE_INDEX_COST procedure, 119
CREATE_INTERFACE procedure, 109
CREATE_JOB Procedure, 76
CREATE_MISS_CAT procedure, 39
CREATE_MISS_NUM procedure, 39
CREATE_MODEL procedure, 38
CREATE_MSGSYSTEM_LINK Procedure for TIB/Rendezvous, 76
CREATE_MSGSYSTEM_LINK Procedure for WebSphere MQ, 76
CREATE_NORM_LIN procedure, 39
CREATE_OBJECT Procedure, 17
CREATE_OBJECT_DEPENDENCY procedure, 20
CREATE_OR_REPLACE_VIEW procedure
of DBMS_HS_PARALLEL package, 61
CREATE_OUTLINE procedure, 85
CREATE_PENDING_AREA procedure, 105
CREATE_PIPE function, 88
CREATE_PLAN procedure, 105
CREATE_PLAN_DIRECTIVE procedure, 105
CREATE_PROPAGATION procedure, 92
CREATE_RULE procedure, 113
CREATE_RULE_CLASS procedure, 109
CREATE_RULE_SET procedure, 113
CREATE_SERVICE procedure, 116
CREATE_SIMPLE_PLAN procedure, 105
CREATE_SNAPSHOT function and procedure, 146
CREATE_SQLSET procedure, 125
CREATE_SQLWKLD Procedure, 17
CREATE_STAT_TABLE procedure, 127
CREATE_STGTAB_BASELINE Procedure, 121
CREATE_STGTAB_SQLPATCH Procedure, 123
CREATE_STGTAB_SQLPROF Procedure, 125
CREATE_STGTAB_SQSET Procedure, 125
CREATE_SYNC_CAPTURE procedure
synchronous capture
creating, 28
CREATE_TABLE_COST procedures, 119
CREATE_TABLE_TEMPLAGE procedure
of DBMS_HS_PARALLEL package, 61
CREATE_TASK Procedures, 17
CREATE_TRANSFORMATION procedure, 138
CREATE_TUNING_TASK functions, 125
CREATE_VERSION procedure, 55
CREATE_WRAPPED Procedure, 42
CREATEATTRIBUTE function, 155
CREATECDATASECTION function, 155
CREATECOMMENT function, 155
CREATEDATASTOREPREF procedure, 152
CREATEDATEINDEX Procedure, 157
CREATEDOCUMENT function, 155
CREATEDOCUMENTFRAGMENT function, 155
CREATEELEMENT function, 155
CREATEENTITYREFERENCE function, 155
CREATEFILTERPREF procedure, 152
CREATEFOLDER function, 148
CREATEINDEX procedure, 152
CREATELEXERPREF procedure, 152
CREATENONSCHEMABASEDXML function, 239
CREATENUMBERINDEX Procedure, 157
CREATEOIDPATH function, 148
CREATEPREFERENCES procedure, 152
CREATEPROCESSINGINSTRUCTION function, 155
CREATEREPOSITORYXMLINDEX Procedure, 149
CREATERESOURCE function, 148
CREATESCHEMABASEDXML function, 239
CREATESECTIONGROUPPREF procedure, 152
CREATESTOPLISTPREF procedure, 152
CREATESTORAGEPREF procedure, 152
CREATETEMPORARY Procedures, 69
CREATETEXTNODE function, 155
CREATEURI function, 225, 225, 225
CREATEWORLDLISTPREF procedure, 152
CREATEXML function, 239
creating
packages, 1
CTX_ADM package documentation, 6
CTX_CLS package documentation, 7
CTX_DDL package documentation, 8
CTX_DOC package documentation, 9
CTX_OUTPUT package documentation, 10
CTX_QUERY package documentation, 11
CTX_REPORT package documentation, 12
CTX_THES package documentation, 13
CTX_ULEXER package documentation, 14
cube maintenance, 36
cube materialized views
optimizing, 37
cubes
optimizer statistics, 27
CURRENT_INSTANCE function, 141
cursors
DBMS_SQL package, 122

D

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

E

EHLO function and procedure, 216
EM function
of HTF package, 167
EM procedure
of HTP package, 168
e-mail from PL/SQL (email), 218
EMPHASIS function
of HTF package, 167
EMPHASIS procedure
of HTP package, 168
ENABLE procedure, 86
ENABLE Procedures, 26
ENABLE_AT_SYSTEM_CHANGE_NUMBER procedure, 57
ENABLE_AT_TIME procedure, 57
ENABLE_BREAKPOINT function, 43
ENABLE_HIERARCHY procedure, 153
ENABLE_JOB Procedure, 76
ENABLE_PROPAGATION_SCHEDULE Procedure, 76
ENABLETRANSLATION Procedure, 163
END_REQUEST procedure, 207
END_RESPONSE procedure, 207
ENDCREATE member procedure
of ANYDATA TYPE, 221
of ANYDATASET TYPE, 222
of ANYTYPE TYPE, 223
ENQUEUE procedure, 133
ENQUEUE_ARRAY Function, 21
ENQUEUE_OPTIONS_T Type, 224
ENQUOTE_LITERAL Function, 25
ENQUOTE_NAME Function, 25
EPC_TO_ORACLE_SCHEME function, 75
ERASE Procedures, 69
error queue
deleting errors, 20, 20
executing errors, 20, 20
getting error messages, 20
ESCAPE function, 219
ESCAPE_SC function
of HTF package, 167
ESCAPE_SC procedure
of HTP package, 168
ESCAPE_URL function
of HTF package, 167
ESCAPEURI function, 225
ESTIMATE_CPU_UNITS function, 83
ESTIMATE_MVIEW_SIZE Procedure, 79
ETINSTANCE member function
of ANYDATASET TYPE, 222
EVALUATE procedure, 112
EVOLVE_SQL_PLAN_BASELINE Function, 121
EXACT_TEXT_SIGNATURES procedure, 85
EXEC_DDL_STATEMENT procedure, 141
EXECUTE function, 122
EXECUTE member procedure, 228, 228
EXECUTE procedure, 43
EXECUTE_ALL_ERRORS procedure, 20
EXECUTE_ANALYSIS_TASK, 124
EXECUTE_AND_FETCH function, 122
EXECUTE_DIAGNOSIS_TASK Procedure, 123
EXECUTE_ERROR procedure, 20
EXECUTE_IMMEDIATE Procedure, 62
EXECUTE_NON_QUERY Function, 62
EXECUTE_TASK Procedure, 17
EXECUTE_TUNING_TASK Function & Procedure, 125
execution flow
in dynamic SQL, 122
EXF$ATTRIBUTE object type, 226
EXF$ATTRIBUTE_LIST object type, 226
EXF$INDEXOPER object type, 226
EXF$TABLE_ALIAS object type, 226
EXF$TEXT object type, 226
EXF$XPATH_TAG object type, 226
EXF$XPATH_TAGS object type, 226
EXISTSNODE function, 239
EXISTSRESOURCE function, 148
EXPAND_MESSAGE function, 115
EXPLAIN_SQL_TESTCASE Function, 123
EXPONENTIAL_DIST_FIT procedure, 126
EXPORT_AWR Procedure, 144, 145
EXPORT_COLUMN_STATS procedure, 127
EXPORT_DATABASE_PREFS Procedure, 127
EXPORT_DATABASE_STATS procedure, 127
EXPORT_DICTIONARY_STATS procedure, 127
EXPORT_FIXED_OBJECTS_STATS procedure, 127
EXPORT_INDEX_STATS procedure, 127
EXPORT_MODEL procedure, 38
EXPORT_PENDING_STATS Procedure, 127
EXPORT_SCHEMA_PREFS Procedure, 127
EXPORT_SCHEMA_STATS procedure, 127
EXPORT_SQL_TESTCASE Procedures, 123
EXPORT_SQL_TESTCASE_DIR_BY_INC Procedure, 123
EXPORT_SQL_TESTCASE_DIR_BY_TXT Function, 123
EXPORT_SYSTEM_STATS procedure, 127
EXPORT_TABLE_PREFS Procedure, 127
EXPORT_TABLE_STATS procedure, 127
Expression Filter object types, 226
extend window
to create a new view, 30
EXTEND_EVENT_STRUCT procedure, 109
EXTRACT function, 239
EXTRACTXLIFF Function & Procedure, 163

F

FCLOSE procedure, 206
FCLOSE_ALL procedure, 206
FCOPY procedure, 206
FETCH_ROW Function, 62
FETCH_ROWS function, 122
FFLUSH procedure, 206
FGETATTR procedure, 206
FGETPOS function, 206
FI_HORIZONTAL function, 58
FI_TRANSACTIONAL function, 58
file groups, 55
adding files, 55
altering, 55
altering files, 55
altering versions, 55
creating, 55
creating versions, 55
dropping, 55
dropping versions, 55
granting object privileges, 55
granting system privileges, 55
purging, 55
removing files, 55
revoking object privileges, 55
revoking system privileges, 55
FILE type, 134
FILE_SET type, 134
FILECLOSE Procedure, 69
FILECLOSEALL Procedure, 69
FILEEXISTS Function, 69
FILEGETNAME Procedure, 69
FILEISOPEN Function, 69
FILEOPEN Procedure, 69
FINDENTITY function, 155
FINDNOTATION function, 155
fine-grained access control
DBMS_RLS package, 110
FINISH_CAPTURE Procedure, 144
FINISH_REDEF_TABLE procedure, 95
FIX_CORRUPT_BLOCKS procedure, 97
FLUSH Function & Procedure, 107
FLUSH procedure, 218
FLUSH_DATA function and procedure, 91
FLUSH_DATABASE_MONITORING_INFO procedure, 127
FONTCLOSE function
of HTF package, 167
FONTCLOSE procedure
of HTP package, 168
FONTOPEN function
of HTF package, 167
FONTOPEN procedure
of HTP package, 168
FOPEN function, 206
FOPEN_NCHAR function, 206
FORCE parameter
and job-to-instance affinity, 65
FORMAT function, 235
FORMAT_CALL_STACK Function, 141
FORMAT_CELL function
of HTF package, 167
FORMAT_ERROR_BACKTRACE function, 141
FORMAT_ERROR_STACK function, 141
FORMAT_REPORT Function, 101
FORMCHECKBOX function
of HTF package, 167
FORMCHECKBOX procedure
of HTP package, 168
FORMCLOSE function
of HTF package, 167, 167
FORMCLOSE procedure
of HTP package, 168
FORMFILE function
of HTF package, 167
FORMFILE procedure
of HTP package, 168, 168
FORMHIDDEN function
of HTF package, 167
FORMHIDDEN procedure
of HTP package, 168
FORMIMAGE function
of HTF package, 167
FORMIMAGE procedure
of HTP package, 168
FORMOPEN function
of HTF package, 167
FORMOPEN procedure
of HTP package, 168
FORMPASSWORD function
of HTF package, 167
FORMPASSWORD procedure
of HTP package, 168
FORMRADIO function
of HTF package, 167
FORMRADIO procedure
of HTP package, 168
FORMRESET function
of HTF package, 167
FORMRESET procedure
of HTP package, 168
FORMSELECTCLOSE function
of HTF package, 167
FORMSELECTCLOSE procedure
of HTP package, 168
FORMSELECTOPEN function
of HTF package, 167
FORMSELECTOPEN procedure
of HTP package, 168
FORMSELECTOPTION function
of HTF package, 167
FORMSELECTOPTION procedure
of HTP package, 168
FORMSUBMIT function
of HTF package, 167
FORMSUBMIT procedure
of HTP package, 168
FORMTEXT function
of HTF package, 167
FORMTEXT procedure
of HTP package, 168
FORMTEXTAREA function
of HTF package, 167
FORMTEXTAREA procedure
of HTP package, 168
FORMTEXTAREA2 function
of HTF package, 167
FORMTEXTAREA2 procedure
of HTP package, 168
FORMTEXTAREACLOSE function
of HTF package, 167
FORMTEXTAREACLOSE procedure
of HTP package, 168
FORMTEXTAREAOPEN function
of HTF package, 167
FORMTEXTAREAOPEN procedure
of HTP package, 168
FORMTEXTAREAOPEN2 function
of HTF package, 167
FORMTEXTAREAOPEN2 procedure
of HTP package, 168
FRAGMENT_DELETE Procedure, 69
FRAGMENT_INSERT Function, 69
FRAGMENT_MOVE Procedure, 69
FRAGMENT_REPLACE Procedure, 69
FRAME function
of HTF package, 167
FRAME procedure
of HTP package, 168
FRAMESETCLOSE function
of HTF package, 167
FRAMESETCLOSE procedure
of HTP package, 168
FRAMESETOPEN function
of HTF package, 167
FRAMESETOPEN procedure
of HTP package, 168
FREE_BLOCKS procedure, 119
FREE_UNUSED_USER_MEMORY Procedure, 117
FREEDOCFRAG procedure, 155
FREEDOCUMENT procedure, 155
FREENODE procedure, 155
FREEPARSER procedure, 158
FREEPROCESSOR procedure, 165
FREERESOURCE Procedure, 150
FREESTYLESHEET procedure, 165
FREETEMPORARY Procedures, 69
FREMOVE procedure, 206, 206
FRENAME procedure, 206
FSEEK procedure, 206
functions
adding to attribute sets, 53, 109

G

GATHER_DATABASE_STATS procedures, 127
GATHER_DICTIONARY_STATS procedure, 127
GATHER_FIXED_OBJECTS_STATS procedure, 127
GATHER_INDEX_STATS Procedure, 127
GATHER_SCHEMA_STATS procedures, 127
GATHER_SYSTEM_STATS procedure, 127
GATHER_TABLE_STATS procedure, 127
GENERATE_STATS procedure, 127
GENERATEBEAN procedure, 161
GENERATESCHEMAS function, 161
GET function
of OWA_COOKIE package, 172
GET* member functions
of ANYDATA TYPE, 221
of ANYDATASET TYPE, 222
GET_ACLOID function, 153
GET_AGGREGATE_VALUE function, 109
GET_ALL procedure, 172
GET_ALL_DAD_ATTRIBUTES Procedure, 51
GET_ALL_DAD_MAPPINGS Procedure, 51
GET_ALL_GLOBAL_ATTRIBUTES Procedure, 51
GET_ALL_NAMES member function, 236
GET_ASSOCIATION_RULES function, 38
GET_AUTHENTICATION procedure, 207
GET_BASE_TABLE_NAME member function, 228
GET_BASE_TABLE_OWNER member function, 228
GET_BODY_CHARSET procedure, 207
GET_CAPTURE_INFO Procedure, 144
GET_CATEGORY function, 142
GET_CATEGORY_ID function, 75
GET_CGI_ENV function, 179
GET_CLIENT_ATTRIBUTES Procedure, 26
GET_CLIENT_HOSTNAME function, 177
GET_CLIENT_IP function, 177
GET_COLUMN_STATS procedures, 127
GET_COMMAND_TYPE member function, 228
GET_COMMIT_SCN member function, 228
GET_COMMON_TIME_ZONES Function, 208
GET_COMPATIBLE member function, 228
GET_COMPONENT function, 235
GET_COMPONENTS function, 75
GET_COOKIE_COUNT function, 207
GET_COOKIE_SUPPORT procedure, 207
GET_COOKIES function, 207
GET_CPU_TIME function, 141
GET_CURRENT_SCHEMA member function, 228
GET_DAD_ATTRIBUTE Procedure, 51
GET_DAD_LIST Procedure, 51
GET_DEFAULT_ISO_CURRENCY Function, 208
GET_DEFAULT_LINGUISTIC_SORT Function, 208
GET_DEFAULT_SETTINGS function, 38
GET_DEPENDENCY procedure, 141
GET_DETAILED_EXCP_SUPPORT procedure, 207
GET_DETAILED_SQLCODE function, 207
GET_DETAILED_SQLERRM function, 207
GET_ENCODINGS function, 75
GET_ERROR_MESSAGE function, 20
GET_ETAG function, 171
GET_EXPRESSION function, 39
GET_EXPRSET_STATS procedure, 53
GET_EXTRA_ATTRIBUTE member function, 228
GET_FILE procedure, 56
GET_FOLLOW_REDIRECT procedure, 207
GET_FREQUENT_ITEMSETS function, 38
GET_GLOBAL_ATTRIBUTE Function, 51
GET_HASH_VALUE function, 141
GET_HEADER procedure, 207
GET_HEADER_BY_NAME procedure, 207
GET_HEADER_COUNT function, 207
GET_HOST_ADDRESS function, 209
GET_HOST_NAME function, 209
GET_INDEX_STATS procedures, 127
GET_INDEXES function, 43
GET_INFORMATION function, 129
GET_JAVA_LOGGING_LEVEL function, 75
GET_LEVEL function, 171
GET_LINE function, 218
GET_LINE procedure, 86, 206
GET_LINE_MAP function, 43
GET_LINE_NCHAR Function, 218
GET_LINE_NCHAR procedure, 206
GET_LINES procedure, 86
GET_LOB_INFORMATION member function, 228
GET_LOB_OFFSET member function, 228
GET_LOB_OPERATION_SIZE member procedure, 228
GET_LOCAL_LINGUISTIC_SORTS Function, 208
GET_LOGON_USER member function, 228
GET_LONG_INFORMATION member function, 228
GET_MESSAGE_TRACKING function, 130
GET_MODEL_COST_MATRIX function, 38
GET_MODEL_DETAILS_ABN function, 38
GET_MODEL_DETAILS_AI function, 38
GET_MODEL_DETAILS_GLM function, 38
GET_MODEL_DETAILS_GLOBAL function, 38
GET_MODEL_DETAILS_KM function, 38
GET_MODEL_DETAILS_NB function, 38
GET_MODEL_DETAILS_NMF function, 38
GET_MODEL_DETAILS_OC function, 38
GET_MODEL_DETAILS_SVM function, 38
GET_MODEL_DETAILS_XML function, 38
GET_MODEL_SETTINGS function, 38
GET_MODEL_SIGNATURE function, 38
GET_MODEL_TRANSFORMATIONS function, 38
GET_MORE_SOURCE procedure, 43
GET_NEXT_HIT function, 112
GET_OBJECT_NAME member function, 228
GET_OBJECT_OWNER member function, 228
GET_OBJECT_TYPE member function, 228
GET_OWA_SERVICE_PATH function, 179
GET_P1_RESOURCES Procedure, 26
GET_PARAM function, 127
GET_PARAMETER_VALUE function, 141
GET_PASSWORD function, 177
GET_PERSISTENT_CONN_COUNT function, 207
GET_PERSISTENT_CONN_SUPPORT procedure, 207
GET_PERSISTENT_CONNS procedure, 207
GET_PLSQL_LOGGING_LEVEL function, 75
GET_PLSQL_TRACE_LEVEL function, 136
GET_POST_PROCESSED_SOURCE Procedure, 90
GET_PREFS Function, 127
GET_PROCEDURE function, 179
GET_PROXY procedure, 207
GET_RAW function, 206, 218
GET_REC_ATTRIBUTES Procedure, 17
GET_REPLAY_INFO Function, 145
GET_REPORT Function, 15, 101
GET_RESPONSE function, 207
GET_RESPONSE_ERROR_CHECK procedure, 207
GET_ROWID function, 175
GET_RUN_REPORT Function, 59
GET_RUNTIME_INFO function, 43
GET_SCHEME_NAMES function, 75
GET_SCN member function, 228
GET_SCN_MAPPING procedure, 130
GET_SESSION_TIMEOUT function, 108
GET_SOURCE_DATABASE_NAME member function, 228
GET_SOURCE_TIME member function, 228
GET_SQL Function, 123
GET_STATS_HISTORY_AVAILABILITY function, 127
GET_STATS_HISTORY_RETENTION function, 127
GET_STREAMS_NAME function, 129
GET_STREAMS_TYPE function, 129
GET_SYSTEM_STATS procedure, 127
GET_TABLE_STATS procedure, 127
GET_TAG function, 129
GET_TAG member function, 228
GET_TASK_REPORT Procedure, 17
GET_TASK_SCRIPT Procedure, 17
GET_TDT_XML function, 75
GET_TEXT function, 218
GET_TEXT_NCHAR Function, 218
GET_THRESHOLD procedure, 115
GET_TIME function, 141
GET_TIMEOUT function, 108
GET_TIMEOUT_BEHAVIOUR function, 43
GET_TRANSACTION_ID member function, 228
GET_TRANSFER_TIMEOUT procedure, 207
GET_TRANSFORM_LIST procedure, 38
GET_USER_ID function, 177
GET_USERID function, 153
GET_VALIDATOR function, 75
GET_VALUE function, 43
GET_VALUE member function, 228, 236
GET_VALUE Procedure, 62
GET_VALUE_RAW Procedure, 62
GET_VALUES member function, 228
GET_VERSION procedure, 91
GET_WARNING_SETTING_CAT function, 142
GET_WARNING_SETTING_NUM function, 142
GET_WARNING_SETTING_STRING function, 142
GET_X function, 174
GET_XML_INFORMATION member function, 228
GET_Y function, 174
GETACL Function, 150
GETACLDOCFROMRES Function, 150
GETACLDOCUMENT function, 148
GETAPPLICATIONDATA Function, 154
GETATTRELEMINFO member function
of ANYTYPE TYPE, 223
GETATTRIBUTE function, 155
GETATTRIBUTENODE function, 155
GETATTRIBUTES function, 155
GETAUTHOR Function, 150
GETBASEDOCUMENT Function, 163
GETBLOB function, 225, 225, 225, 225
GETBLOBVAL function, 239
GETBUBLICID function, 155
GETCHARACTERSET Function, 150
GETCHILDNODES function, 155
GETCHILDOID Function, 154
GETCHILDRENBYTAGNAME function, 155
GETCHILDRESPATHS Function, 148
GETCHUNKSIZE Functions, 69
GETCLOB function, 225, 225, 225, 225
GETCLOBVAL function, 239
GETCOMMENT Function, 150
GETCONTENTBLOB Function, 148, 150
GETCONTENTCLOB Function, 148, 150
GETCONTENTREF Function, 150
GETCONTENTSBLOBBYRESID function, 151
GETCONTENTSCLOBBYRESID function, 151, 151
GETCONTENTSXMLBYRESID function, 151
GETCONTENTTYPE Function, 150
GETCONTENTTYPE function, 225, 225, 225, 225
GETCONTENTVARCHAR2 Function, 148, 150
GETCONTENTXML Function, 150
GETCONTENTXMLREF Function, 148
GETCONTENTXMLTYPE Function, 148
GETCOUNT member function
of ANYDATASET TYPE, 222
GETCREATIONDATE Function, 150
GETCREATOR Function, 150
GETCURRENTUSER Function, 154
GETCUSTOMMETADATA Function, 150
GETDATA function, 155
GETDCHARSET function, 155
GETDISPLAYNAME Function, 150
GETDOCTYPE function, 155, 158
GETDOCUMENT function, 158
GETDOCUMENTELEMENT function, 155
GETDTD function, 159
GETDTD procedure, 159
GETELEMENTSBYTAGNAME function, 155, 155
GETENTITIES function, 155
GETEVENT Function, 154
GETEXCEPTIONCONTENT procedure, 159, 160
GETEXPANDEDNAME function, 155, 155
GETEXPANDEDNAME procedure, 155
GETEXTERNALURL function, 225, 225, 225, 225
GETFIRST Function, 154
GETFIRSTCHILD function, 155
GETFTPPORT Function, 148
GETHANDLERLIST Function, 154
GETHTTPPORT Function, 148
GETIMPLEMENTATION function, 155
GETINFO member function
of ANYTYPE TYPE, 223
GETINTERFACE Function, 154
GETLANGUAGE Function, 150, 154, 154
GETLASTCHILD function, 155
GETLASTMODIFIER Function, 150
GETLENGTH function, 155, 155, 155
GETLENGTH Functions, 69
GETLINK Function, 154
GETLINKNAME Function, 154
GETLISTENERENDPOINT Procedure, 148
GETLISTENERS Function, 104
GETLOCK Function, 154
GETLOCKTOKEN procedure, 148
GETMODIFICATIONDATE Function, 150
GETNAME Function, 154
GETNAME function, 155, 155
GETNAMEDITEM function, 155
GETNAMESPACE function, 155, 155
GETNAMESPACE procedure, 155
GETNEXTSIBLING function, 155
GETNODENAME function, 155
GETNODETYPE function, 155
GETNODEVALUE function, 155
GETNODEVALUEASBINARYSTREAM Function & Procedure, 155
GETNODEVALUEASCHARACTERSTREAM Function & Procedure, 155
GETNOTATIONNAME function, 155
GETNOTATIONS function, 155
GETNUMBERVAL function, 239
GETNUMROWSPROCESSED function, 156
GETNUMROWSPROCESSED procedure, 159
GETOLDRESOURCE Function, 154
GETOPENACCESSMODE Function, 154
GETOPENDENYMODE Function, 154
GETOPTIONS Functions, 69
GETOUTPUTSTREAM Function, 154
GETOWNER Function, 150
GETOWNERDOCUMENT function, 155
GETOWNERELEMENT function, 155
GETPARAMETER Function, 154
GETPARENT Function, 154
GETPARENTNAME Function, 154
GETPARENTNODE function, 155
GETPARENTOID Function, 154
GETPARENTPATH Function, 154
GETPAT procedure, 176
GETPATH Function, 154
GETPERSISTENT static function
of ANYTYPE TYPE, 223
GETPREDECESSORS function, 151
GETPREDSBYRESID function, 151
GETPREFIX function, 155
GETPREVIOUSSIBLING function, 155
GETPRIVILEGES function, 148
GETPUBLICID function, 155, 155
GETQUALIFIEDNAME function, 155, 155
GETREFCOUNT Function, 150
GETRELEASEVERSION function, 158
GETREPOSITORYRESCONFIG Function, 104
GETREPOSITORYRESCONFIGPATHS Function, 104
GETRESCONFIG Function, 104
GETRESCONFIGPATHS Function, 104
GETRESOID function, 148
GETRESOURCE Function, 154
GETRESOURCEBYRESID function, 151
GETROOTELEMENT function, 239
GETRUL function, 225
GETSCHEMA Function, 154
GETSCHEMANODE function, 155
GETSCHEMAURL function, 239
GETSOURCE Function, 154
GETSPECIFIED function, 155
GETSTANDALONE function, 155
GETSTRINGVAL function, 239
GETSUCCESSORS function, 151
GETSUCCSBYRESID function, 151
GETSYSTEMID function, 155, 155, 155
GETTAGNAME function, 155
GETTARGET function, 155
GETTOKENTABLEINFO Procedure & Function, 35
GETTOKENTABLEINFOBYTABLESPACE Procedure, 35
GETTYPE member function
of ANYDATA TYPE, 221
of ANYDATASET TYPE, 222
GETTYPENAME member function
of ANYDATA TYPE, 221
of ANYDATASET TYPE, 222
GETUPDATEBYTECOUNT Function, 154
GETUPDATEBYTEOFFSET Function, 154
GETURL function, 225, 225, 225, 225
GETVALIDATIONMODE function, 158
GETVALUE function, 155
GETVERSION function, 155
GETVERSION procedure, 159
GETVERSIONID Function, 150
GETXDB_TABLESPACE function, 148
GETXDBEVENT Function, 154
GETXML function, 156, 159, 225, 225, 225, 225
GETXML procedure, 159
GETXMLTYPE function, 155, 156
GRANT_ADMIN_PRIVILEGE procedure, 132
GRANT_OBJECT_PRIVILEGE procedure, 113
GRANT_PRIVILEGE procedure, 53, 109
GRANT_REMOTE_ADMIN_ACCESS procedure, 132
GRANT_SWITCH_CONSUMER_GROUP procedure, 106
GRANT_SYSTEM_PRIVILEGE procedure, 55, 106, 113
GRANTING_OBJECT_PRIVILEGE procedure, 55

H

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

I

IMG function
of HTF package, 167
IMG procedure
of HTP package, 168
IMG2 procedure
of HTP package, 168
IMPLEMENT_TASK Procedure, 17
IMPLEMENT_TUNING_TASK Function, 125
IMPORT_AWR Function, 145
IMPORT_AWR Procedure, 144
IMPORT_COLUMN_STATS procedure, 127
IMPORT_DATABASE_PREFS Procedure, 127
IMPORT_DATABASE_STATS procedure, 127
IMPORT_DICTIONARY_STATS procedure, 127
IMPORT_FIXED_OBJECTS_STATS procedure, 127
IMPORT_INDEX_STATS procedure, 127
IMPORT_MODEL procedure, 38
IMPORT_SCHEMA_PREFS Procedure, 127
IMPORT_SCHEMA_STATS procedure, 127
IMPORT_SQLWKLD_SCHEMA Procedure, 17
IMPORT_SQLWKLD_SQLCACHE Procedur, 17
IMPORT_SQLWKLD_STS Procedure, 17
IMPORT_SQLWKLD_SUMADV Procedure, 17
IMPORT_SQLWKLD_USER Procedure, 17
IMPORT_SYSTEM_STATS procedure, 127
IMPORT_TABLE_PREFS Procedure, 127
IMPORT_TABLE_STATS procedure, 127
IMPORT_XML procedure, 36
IMPORTNODE function, 155
INCIDENTID_2_SQL Procedure, 123
INCLUDE_EXTRA_ATTRIBUTES procedure, 28
INDEX_PARAMETERS procedure, 53
in-flight transactions, 28
INITIALIZE function, 43
INITIALIZE procedure, 93
INITIALIZE_REPLAY Procedure, 145
INPLACEEVOLVE Procedure, 161
INSERT_AUTOBIN_NUM_EQWIDTH procedure, 39
INSERT_BIN_CAT_FREQ procedure, 39
INSERT_BIN_NUM_EQWIDTH procedure, 39
INSERT_BIN_NUM_QTILE procedure, 39
INSERT_BIN_SUPER procedure, 39
INSERT_CLIP_TRIM_TAIL procedure, 39
INSERT_CLIP_WINSOR_TAIL procedure, 39
INSERT_FINDING_DIRECTIVE Procedure, 15
INSERT_MISS_CAT_MODE procedure, 39
INSERT_MISS_NUM_MEAN procedure, 39
INSERT_NORM_LIN_MINMAX procedure, 39
INSERT_NORM_LIN_SCALE procedure, 39
INSERT_NORM_LIN_ZSCORE procedure, 39
INSERT_PARAMETER_DIRECTIVE Procedure, 15
INSERT_SEGMENT_DIRECTIVE Procedure, 15
INSERT_SQL_DIRECTIVE Procedure, 15
INSERTBEFORE function, 155
INSERTDATA procedure, 155
INSERTXML function, 160, 162
INSTANCE procedure, 65
instantiation
aborting database preparation, 28
aborting schema preparation, 28
aborting table preparation, 28
global SCN, 20
preparing a database for, 28
preparing a schema for, 28
preparing a table for, 28, 28
schema SCN, 20
table SCN, 20
INSTR Functions, 69
INTERNAL_VERSION_CHECK function, 91
internet addressing
using UTL_INADDR, 209
INTERRUPT_ANALYSIS_TASK Procedure, 124
INTERRUPT_DIAGNOSIS_TASK Procedure, 123
INTERRUPT_TASK Procedure, 17
INTERRUPT_TUNING_TASK procedure, 125
INTERVAL procedure, 65
INTERVAL_DAY_TO_SECOND_TABLE, 122
INTERVAL_YEAR_TO_MONTH_TABLE Table Type, 122
INVALIDATE Functions & Procedures, 107
INVALIDATE Procedure, 141
INVALIDATE_OBJECT Functions & Procedures, 107
IS_CLUSTER_DATABASE function, 141
IS_HIERARCHY_ENABLED function, 153
IS_LOCATOR function, 203
IS_NULL_TAG member function, 228
IS_OPEN function, 122, 206
IS_ROLE_ENABLED Function, 117
IS_SESSION_ALIVE Function, 117
IS_TRIGGER_FIRE_ONCE function, 42
ISFOLDER Function, 148, 150
ISFRAGMENT function, 239
ISINDEX function
of HTF package, 167
ISINDEX procedure
of HTP package, 168
ISNULL Function, 150, 154
ISNULL function, 155
ISOPEN function, 204
ISOPEN Functions, 69
ISSCHEMABASED function, 239
ISSCHEMAVALID function, 239
ISSCHEMAVALIDATED function, 239
ISTEMPORARY Functions, 69
ITALIC function
of HTF package, 167
ITALIC procedure
of HTP package, 168
ITEM Functions, 155

J

JOB constructor function, 114
JOB object type, 114
JOB_ARRAY table type, 114
JOBARG constructor function, 114
JOBARG object type, 114
JOBARG_ARRAY table type, 114
JOBATTR constructor function, 114
JOBATTR object type, 114
JOBATTR_ARRAY table type, 114

K

KBD function
of HTF package, 167
KBD procedure
of HTP package, 168
KEEP procedure, 118
KEYBOARD function
of HTF package, 167
KEYBOARD procedure
of HTP package, 168

L

LAPACK Driver Routines (Linear Equations) Subprograms, 212
LAPACK Driver Routines (LLS and Eigenvalue Problems), 212
LAPACK_GBSV Procedures, 212
LAPACK_GEES Procedures, 212
LAPACK_GEEV Procedures, 212
LAPACK_GELS Procedures, 212
LAPACK_GESDD Procedures, 212
LAPACK_GESV Procedures, 212
LAPACK_GESVD Procedures, 212
LAPACK_GTSV Procedures, 212
LAPACK_PBSV Procedures, 212
LAPACK_POSV Procedures, 212
LAPACK_PPSV Procedures, 212
LAPACK_PTSV Procedures, 212
LAPACK_SBEV Procedures, 212
LAPACK_SBEVD Procedures, 212
LAPACK_SPEV Procedures, 212
LAPACK_SPEVD Procedures, 212
LAPACK_SPSV Procedures, 212
LAPACK_STEV Procedures, 212
LAPACK_STEVD Procedures, 212
LAPACK_SYEV Procedures, 212
LAPACK_SYEVD Procedures, 212
LAPACK_SYSV Procedures, 212
LAST_ERROR_POSITION function, 122
LAST_ROW_COUNT function, 122
LAST_ROW_ID function, 122
LAST_SQL_FUNCTION_CODE function, 122
LCR$_DDL_RECORD type, 228
LCR$_ROW_LIST type, 228
LCR$_ROW_RECORD type, 228
LCR$_ROW_UNIT type, 228
GET_LOB_INFORMATION member function, 228
GET_LOB_OPERATION_SIZE member procedure, 228
GET_LONG_INFORMATION member function, 228
SET_LOB_INFORMATION member procedure, 228
SET_LOB_OPERATION_SIZE member procedure, 228
LCR_TO_XML Function, 77
LENGTH function, 213
LINE function
of HTF package, 167
LINE procedure
of HTP package, 168
LINK Procedures, 148
LINKREL function
of HTF package, 167
LINKREL procedure
of HTP package, 168
LINKREV function
of HTF package, 167
LINKREV procedure
of HTP package, 168
LIST_CONTEXT Procedures, 117
LISTHEADER function
of HTF package, 167
LISTHEADER procedure
of HTP package, 168
LISTINGCLOSE function
of HTF package, 167
LISTINGCLOSE procedure
of HTP package, 168
LISTINGOPEN function
of HTF package, 167
LISTINGOPEN procedure
of HTP package, 168
LISTITEM function
of HTF package, 167
LISTITEM procedure
of HTP package, 168
LISTPRINT procedure, 179
LOAD_PLANS_FROM_CURSOR_CACHE Functions, 121
LOAD_PLANS_FROM_SQLSET Function, 121
LOAD_SQLSET procedure, 125
LOAD_TABLE procedure
of DBMS_HS_PARALLEL package, 61
LOADBLOBFROMFILE Procedure, 69
LOADCLOBFROMFILE Procedure, 69
LOADFROMFILE Procedure, 69
LOBs
DBMS_LOB package, 69
LOCAL_TRANSACTION_ID function, 137
LOCK_MAP procedure, 128
LOCK_OBJECT procedure, 215
LOCK_PARTITION_STATS Procedure, 127
LOCK_SCHEMA_STATS procedure, 127
LOCK_TABLE_STATS procedure, 127
LOCKRESOURCE function, 148
log apply services
managing initialization parameters for logical standby databases, 73
logical change records (LCRs)
DDL LCRs, 228
getting base table name, 228
getting base table owner, 228
getting current schema, 228
getting logon user name, 228
getting object type, 228
setting base table name, 228
setting base table owner, 228
setting current schema, 228
setting DDL text, 228
setting logon user, 228
setting object type, 228
determining if tag is NULL, 228
executing, 228, 228
extra attributes
excluding, 28
including, 28
getting command type, 228
getting commit SCN, 228
getting compatibility information, 228
getting extra attributes, 228
getting LCR creation time, 228
getting object name, 228
getting object owner, 228
getting SCN, 228
getting source database name, 228
getting tag, 228
getting transaction identifier, 228
LCR$_DDL_RECORD type, 228
LCR$_ROW_LIST type, 228
LCR$_ROW_RECORD type, 228
LCR$_ROW_UNIT type, 228
row LCRs, 228
adding value to column, 228
converting LONG to LOB, 228
deleting value to column, 228
getting column value, 228
getting list of column values, 228
getting LOB offset, 228
getting XML information, 228
renaming column, 228
setting column value, 228
setting list of column values, 228
setting LOB offset, 228
setting XML information, 228
setting command type, 228
setting extra attributes, 228
setting object name, 228
setting object owner, 228
setting source database name, 228
setting tag, 228
types, 228
logical standby databases
managing with DBMS_LOGSTDBY package, 73
LOGSTDBY_ADMINISTRATOR role, 73
LZ_COMPRESS functions and procedures, 204
LZ_COMPRESS_ADD procedure, 204
LZ_COMPRESS_CLOSE procedure, 204
LZ_COMPRESS_OPEN function, 204
LZ_UNCOMPRESS functions and procedures, 204
LZ_UNCOMPRESS_CLOSE procedure, 204
LZ_UNCOMPRESS_EXTRACT procedure, 204
LZ_UNCOMPRESS_OPEN function, 204

M

MAIL function and procedure, 216
MAILTO function
of HTF package, 167
MAILTO procedure
of HTP package, 168
MAINTAIN_GLOBAL procedure, 130
MAINTAIN_SCHEMAS procedure, 130
MAINTAIN_SIMPLE_TABLESPACE procedure, 130
MAINTAIN_SIMPLE_TTS procedure, 130
MAINTAIN_TABLES procedure, 130
MAINTAIN_TABLESPACES procedure, 130
MAINTAIN_TTS procedure, 130
MAKE_DATA_BLOCK_ADDRESS function, 141
MAKEATTR function, 155
MAKECDATASECTION function, 155
MAKECHARACTERDATA function, 155
MAKECOMMENT function, 155
MAKEDOCUMENT Function, 150
MAKEDOCUMENT function, 155
MAKEDOCUMENTFRAGMENT function, 155
MAKEDOCUMENTTYPE function, 155
MAKEELEMENT function, 155
MAKEENTITY function, 155
MAKEENTITYREFERENCE function, 155
MAKENODE function, 155, 155, 155, 155
MAKENOTATION function, 155
MAKEPROCESSINGINSTRUCTION function, 155
MAKETEXT function, 155
MAKEVERSIONED function, 151
MAP_ALL function, 128
MAP_DAD Procedure, 51
MAP_ELEMENT function, 128
MAP_FILE function, 128
MAP_OBJECT function, 128
MAPCLOSE function
of HTF package, 167
MAPCLOSE procedure
of HTP package, 168
MAPOPEN function
of HTF package, 167
MAPOPEN procedure
of HTP package, 168
MARK_RECOMMENDATION Procedure, 17
MATCH function, 176
materialized view logs
master table
purging, 79, 79, 79
materialized views
comparing, 31
optimizing cube organized, 37
refreshing, 79, 79, 79
MEMORY_REPORT Procedure, 107
MENULISTCLOSE function
of HTF package, 167
MENULISTCLOSE procedure
of HTP package, 168
MENULISTOPEN function
of HTF package, 167
MENULISTOPEN procedure
of HTP package, 168
merge streams, 130, 130
MERGE_STREAMS procedure, 130
MERGE_STREAMS_JOB procedure, 130
MERGEXLIFF Functions, 163
MESSAGE_PROPERTIES_ARRAY_T Type, 224
MESSAGE_PROPERTIES_T Type, 224
messaging client
messaging client user, 130
rules
for LCRs, 130
for user messages, 130
META function
of HTF package, 167
META procedure
of HTP package, 168
MG2 function
of HTF package, 167
MGD_ID constructor function, 235
MGD_ID object type, 235
FORMAT function, 235
GET_COMPONENT function, 235
MGD_ID constructor function, 235
TO_STRING function, 235
TRANSLATE function, 235
MGD_ID object types, 235
MGD_ID_COMPONENT object type, 235
MGD_ID_COMPONENT_VARRAY object type, 235
migration
post-migration actions, 82
MIME_HEADER procedure, 179
MIMEHEADER_DECODE function, 205
MIMEHEADER_ENCODE function, 205
MODIFY_BASELINE_WINDOW_SIZE Procedure, 146
MODIFY_OPERATOR_LIST procedure, 53
MODIFY_PACKAGE_STATE Procedure, 117
MODIFY_SERVICE Procedure, 116
MODIFY_SNAPSHOT_SETTINGS procedure, 146
MODIFY_TRANSFORMATION procedure, 138
MOVEXDB_TABLESPACE procedure, 148
MSGID_ARRAY_T Type, 224
MV_CUBE_ADVICE function, 37

N

NAME_RESOLVE procedure, 141
NAME_TOKENIZE procedure, 141
NAMESPACE function, 239
NAMESPACEIDTABLE Procedure, 35
NEW_LINE procedure, 86, 206
NEW_ROW_LIST function and procedure, 178
NEWCONTEXT function, 156, 159, 160, 162
NEWDOMDOCUMENT function, 155
NEWPARSER function, 158
NEWPROCESSOR function, 165
NEWSTYLESHEET function, 165
NEXT_DATE procedure, 65
NEXT_ITEM_TYPE function, 88
NL function
of HTF package, 167
NL procedure
of HTP package, 168
NOBR function
of HTF package, 167
NOBR procedure
of HTP package, 168
NOFRAMESCLOSE function
of HTF package, 167
NOFRAMESCLOSE procedure
of HTP package, 168
NOFRAMESOPEN function
of HTF package, 167
NOFRAMESOPEN procedure
of HTP package, 168
NOOP function and procedure, 216
NOOP Functions, 25
NORMAL function, 93
NORMAL_DIST_FIT procedure, 126
NORMALIZE procedure, 155
NUMBER_TABLE Table Type, 122
NVARRAY_ADD Procedure, 77
NVARRAY_FIND_NAME Function, 77
NVARRAY_FIND_NAME_TYPE Function, 77
NVARRAY_GET Function, 77
NVARRAY_GET_BOOLEAN, 77
NVARRAY_GET_BYTE, 77
NVARRAY_GET_DATE Function, 77
NVARRAY_GET_DOUBLE Function, 77
NVARRAY_GET_FLOAT Function, 77
NVARRAY_GET_INTEGER, 77
NVARRAY_GET_LONG Function, 77
NVARRAY_GET_RAW Function, 77
NVARRAY_GET_SHORT, 77
NVARRAY_GET_TEXT Function, 77

O

OBJECT_DEPENDENT_SEGMENTS function, 119
OBJECT_GROWTH_TREND function, 119
ogical change records (LCRs)
tracking, 130, 130
OLD_CURRENT_SCHEMA Function, 141
OLD_CURRENT_USER Function, 141
OLISTCLOSE function
of HTF package, 167
OLISTCLOSE procedure
of HTP package, 168
OLISTOPEN function
of HTF package, 167
OLISTOPEN procedure
of HTP package, 168
ONLINE_INDEX_CLEAN Function, 97
OPEN Procedures, 69
OPEN_CONNECTION function, 218
OPEN_CONNECTION functions, 216
OPEN_CURSOR Function, 62
OPEN_CURSOR function, 122
OPEN_DATA function and procedure, 216
operational notes
DBMS_LOGSTDBY package, 73
optimizer statistics, 27
OR REPLACE clause
for creating packages, 1
Oracle Data Mining, 38
Oracle Streams
administrator
granting privileges, 132
revoking privileges, 132
advisors, 131
compatibility, 129, 129, 129, 129, 228
creating queues, 130
data dictionary
removing information, 130
messaging
notification, 130
privileges, 132
replication
configuring, 130, 130, 130, 130, 130, 130, 130, 130
Oracle-supplied types
logical change record (LCR) types, 228
rule types, 236
OVERLAY function, 213
OVERRIDE_PRIORITY Procedures, 26
OWA_CACHE package, 171
OWA_COOKIE package, 172
OWA_CUSTOM package, 173
OWA_IMAGE package, 174
OWA_OPT_LOCK package, 175
OWA_PATTERN package, 176
OWA_SEC package, 177
OWA_TEXT package, 178
OWA_UTIL package, 179

P

PACK_MESSAGE procedures, 88
PACK_STGTAB_BASELINE Function, 121
PACK_STGTAB_SQLPATCH Procedure, 123
PACK_STGTAB_SQLPROF Procedure, 125
PACK_STGTAB_SQLSET Procedure, 125
package
DBMS_EXPFIL, 53
DBMS_ODCI, 83
DBMS_RLMGR, 109
DBMS_XDB, 148
DBMS_XMLDOM, 155
DBMS_XMLGEN, 156
DBMS_XMLPARSER, 158
DBMS_XMLQUERY, 159
DBMS_XMLSAVE, 160
DBMS_XMLSCHEMA, 161
UriFactory, 225
Package - UriFactory, 225
package overview, 1
package variables
i_am_a_refresh, 79
packages
creating, 1
DBMS_MGD_ID_UTL, 75
referencing, 1
where documented, 1
PARA function
of HTF package, 167
PARA procedure
of HTP package, 168
PARAGRAPH function
of HTF package, 167
PARAGRAPH procedure
of HTP package, 168
PARAM function
of HTF package, 167
PARAM procedure
of HTP package, 168
PARSE Procedure, 62
PARSE procedure, 122, 158
PARSEBUFFER procedure, 158
PARSECLOB procedure, 158
PARSEDTD procedure, 158
PARSEDTDBUFFER procedure, 158
PARSEDTDCLOB procedure, 158
PATHIDTABLE Function, 35
PAUSE_PROFILER function and procedure, 91
PAUSE_REPLAY Procedure, 145
PIECEWISE member procedure
of ANYDATA TYPE, 221
of ANYDATASET TYPE, 222
PING procedure, 43
PLAINTEXT function
of HTF package, 167
PLAINTEXT procedure
of HTP package, 168
plan stability, 85
PL/SQL
datatypes, 47
numeric codes for, 47
functions
DBMS_MGWADM package subprograms, 76
DBMS_MGWMSG package subprograms, 77
procedures
DBMS_MGWADM package subprograms, 76
DBMS_MGWMSG package subprograms, 77
PL/SQL package
DBMS_HS_PARALLEL, 61
PLSQL_TRACE_VERSION procedure, 136
pointer to
CTX_ADM package, 6
point-in-time recovery
Oracle Streams, 130
POISSON_DIST_FIT procedure, 126
PORT_STRING function, 141
POST_INSTANTIATION_SETUP procedure, 130
PRE_INSTANTIATION_SETUP procedure, 130
PRECLOSE function
of HTF package, 167
PRECLOSE procedure
of HTP package, 168
predictive analytics, 89
PREOPEN function
of HTF package, 167
PREOPEN procedure
of HTP package, 168
PREPARE Procedure, 145
PREPARE_COLUMN_VALUES procedures, 127, 127
PREPARE_COLUMN_VALUES_NVARCHAR2 procedure, 127
PREPARE_COLUMN_VALUES_ROWID procedure, 127
PREPARE_GLOBAL_INSTANTIATION procedure, 28
PREPARE_SCHEMA_INSTANTIATION procedure, 28
PREPARE_SYNC_INSTANTIATION function, 28
PREPARE_TABLE_INSTANTIATION procedure, 28
PRINT function
of HTF package, 167
PRINT procedure
of HTP package, 168
PRINT_BACKTRACE procedure, 43
PRINT_CGI_ENV procedure, 179
PRINT_INSTANTIATIONS procedure, 43
PRINT_MULTI procedure, 178
PRINT_POST_PROCESSED_SOURCE Procedure, 90
PRINT_ROW_LIST procedure, 178
PRINTS procedure
of HTP package, 168
privileges
DBMS_LOGSTDBY package, 73
granting, 53
Oracle Streams administrator, 132, 132
revoking, 53
PRN function
of HTF package, 167
PRN procedure
of HTP package, 168
PROBE_VERSION procedure, 43
PROCESS_CAPTURE Procedure, 144
PROCESS_RECORDING Procedure, 145
PROCESS_RULES procedure, 109
PROCESSLINKS Procedure, 148
PROCESSXSL function, 165
PROGRAM_INFO Record Type, 43
PROPAGATEORIGINALEXCEPTION procedure, 159, 160
propagations
altering, 92
creating, 92, 130, 130, 130, 130, 130
DBMS_PROPAGATION_ADM package, 92
dropping, 92
propagation user, 130
rules
defining global, 130
defining message, 130
defining schema, 130
defining subset, 130
defining table, 130
for LCRs, 130
for user messages, 130
starting, 92
stopping, 92
PS procedure
of HTP package, 168
PUBLISH_PENDING_STATS Procedure, 127
PULL_SIMPLE_TABLESPACE procedure, 134
PULL_TABLESPACES procedure, 134
PURGE Procedure, 118
PURGE procedure, 88
PURGE_COMPARISON Procedure, 31
PURGE_EVENTS procedure, 109
PURGE_FILE_GROUP procedure, 55
PURGE_LOST_DB_ENTRY procedure, 137
PURGE_MIXED procedure, 137
PURGE_QUEUE_TABLE Procedure, 22
PURGE_SOURCE_CATALOG procedure, 130
PURGE_STATS procedure, 127
PURGELDAPCACHE function, 153
PURGERESOURCEMETADATA Procedure, 148
PURGESCHEMA Procedure, 161
purging
the subscription window, 30
PUT procedure, 206
PUT procedures, 86
PUT_FILE procedure, 56
PUT_LINE Procedure, 206
PUT_LINE procedures, 86
PUT_LINE_NCHAR procedure, 206
PUT_NCHAR procedure, 206
PUT_RAW function, 206
PUTF procedure, 206
PUTF_NCHAR procedure, 206

Q

QNAMEIDTABLE Function, 35
QUALIFIED_SQL_NAME Function, 25
queues
AnyData
creating, 130
removing, 130
QUICK_TUNE Procedure, 17
QUIT function and procedure, 216
QUOTED_PRINTABLE_DECODE function, 205
QUOTED_PRINTABLE_ENCODE function, 205

R

RANDOM procedure, 93
RANK_APPLY procedure, 38
RCPT function, 216
RE$ATTRIBUTE_VALUE type, 236
RE$ATTRIBUTE_VALUE_LIST type, 236
RE$COLUMN_VALUE type, 236, 236
RE$COLUMN_VALUE_LIST type, 236
RE$NAME_ARRAY type, 236
RE$NV_ARRAY type, 236
RE$NV_LIST type, 236
ADD_PAIR member procedure, 236
GET_ALL_NAMES member function, 236
GET_VALUE member function, 236
REMOVE_PAIR member procedure, 236
RE$RULE_HIT type, 236
RE$RULE_HIT_LIST type, 236
RE$TABLE_ALIAS type, 236
RE$TABLE_ALIAS_LIST type, 236
RE$TABLE_VALUE type, 236
RE$TABLE_VALUE_LIST type, 236
RE$VARIABLE_TYPE type, 236
RE$VARIABLE_TYPE_LIST type, 236
RE$VARIABLE_VALUE type, 236
RE$VARIABLE_VALUE_LIST type, 236
READ Procedures, 69
READ_CLIENT_INFO procedure, 19
READ_LINE function, 218
READ_LINE procedure
of UTL_HTTP, 207
READ_MODULE procedure, 19
READ_ONLY procedure, 137
READ_RAW function, 218
READ_RAW procedure
of UTL_HTTP, 207
READ_TEXT function, 218
READ_TEXT procedure
of UTL_HTTP, 207
READ_WRITE procedure, 137
READ2CLOB function, 165
Real-time SQL Monitoring Subprograms, 125
REBUILD_FREELISTS procedure, 97
RECEIVE_MESSAGE function, 88
RECHECK Function, 31
RECOMP_PARALLEL procedure, 214
RECOMP_SERIAL procedure, 214
REDIRECT_URL procedure, 179
refresh
materialized views, 79, 79, 79
REFRESH_CATEGORY function, 75
REGISTER Procedure, 18
REGISTER_DEPENDENT_OBJECT procedure, 95
REGISTER_FOREIGN_QUEUE Procedure, 76
REGISTERSCHEMA procedure, 161
REGISTERTOKENTABLESET Procedure, 35
REGISTERURI procedure, 161
REGISTERURLHANDLER procedure, 225
RELEASE function, 70
REMAP_CONNECTION Procedure, 145
REMAP_STGTAB_SQLPROF Procedure, 125
REMAP_STGTAB_SQLSET Procedure, 125
REMOVE Procedure, 154
REMOVE procedure
of DBMS_ALERT package, 18
of DBMS_JOB package, 65
of OWA_COOKIE package, 172
REMOVE_AGENT Procedure, 76
REMOVE_CATEGORY procedure, 75
REMOVE_COLORED_SQL Procedure, 146
REMOVE_COST_MATRIX procedure, 38
REMOVE_FILE procedure, 55
REMOVE_JOB Procedure, 76
REMOVE_MSGSYSTEM_LINK Procedure, 76
REMOVE_OPTION Procedure, 76
REMOVE_PAIR member procedure, 236
REMOVE_PIPE function, 88
REMOVE_PROXY procedure, 75
REMOVE_QUEUE procedure, 130
REMOVE_RULE procedure, 113, 130
REMOVE_SCHEME procedure, 75
REMOVE_SQLSET_REFERENCE procedure, 125
REMOVE_STREAMS_CONFIGURATION procedure, 130
REMOVE_SUBSCRIBER Procedure, 76
REMOVEALL procedure, 18
REMOVEATTRIBUTE procedure, 155
REMOVEATTRIBUTENODE function, 155
REMOVENAMEDITEM function, 155
REMOVEPARAM procedure, 165
REMOVEXSLTPARAM procedure, 159, 160
RENAME_BASELINE Procedure, 146
RENAME_COLUMN member procedure, 228
RENAME_COLUMN procedure, 130
RENAME_MODEL procedure, 38
RENAME_SCHEMA procedure, 130
RENAME_TABLE procedure, 130
RENAMERESOURCE procedure, 148
REPLACECHILD function, 155
REPLACEDATA procedure, 155
replication
Oracle Streams
configuring, 130, 130, 130, 130, 130, 130, 130, 130
split and merge, 130, 130, 130
REPLY, REPLIES record types, 216
REPORT Function, 144, 145
REPORT_ANALYSIS_TASK Function, 124
REPORT_AUTO_TUNING_TASK Function, 125
REPORT_DIAGNOSIS_TASK Function, 123
REPORT_SQL_MONITOR Function, 125
REPORT_TUNING_TASK function, 125
REQUEST function, 70, 207
REQUEST_PIECES function, 207
RESET_ANALYSIS_TASK Procedure, 124
RESET_BUFFER procedure, 88
RESET_DIAGNOSIS_TASK Procedure, 123
RESET_GLOBAL_PREFS_DEFAULTS Procedure, 127
RESET_JOB Procedure, 76
RESET_PACKAGE Procedure, 117
RESET_PARAM_DEFAULTS Procedure, 127
RESET_SESSION procedure, 109
RESET_SQLWKLD Procedure, 17
RESET_SUBSCRIBER Procedure, 76
RESET_TASK Procedure, 17
RESET_TUNING_TASK procedure, 125
RESETPARAMS procedure, 165
RESOLVENAMESPACEPREFIX function, 155
RESTARTQUERY procedure, 156
RESTORE function, 128
RESTORE_DATBASE_STATS procedure, 127
RESTORE_DEFAULTS Procedure, 32
RESTORE_DICTIONARY_STATS procedure, 127
RESTORE_FIXED_OBJECTS_STATS procedure, 127
RESTORE_SCHEMA_STATS procedure, 127
RESTORE_SYSTEM_STATS procedure, 127
RESTORE_TABLE_STATS procedure, 127
RESUME_ANALYSIS_TASK Procedure, 124
RESUME_DIAGNOSIS_TASK Procedure, 123
RESUME_PROFILER function and procedure, 91
RESUME_REPLAY Procedure, 145
RESUME_TUNING_TASK Procedure, 125
REVERSE function, 213
REVOKE_ADMIN_PRIVILEGE procedure, 132
REVOKE_OBJECT_PRIVILEGE procedure, 55, 113
REVOKE_PRIVILEGE procedure, 53, 109
REVOKE_REMOTE_ADMIN_ACCESS procedure, 132
REVOKE_SWITCH_CONSUMER_GROUP procedure, 106
REVOKE_SYSTEM_PRIVILEGE procedure, 55, 106, 113
RLM$EVENTIDS object type, 237
ROLLBACK procedure, 137
ROLLBACK_FORCE procedure, 137
ROLLBACK_SAVEPOINT procedure, 137
row migration, 130, 130
ROWID datatype
extended format, 111
ROWID_BLOCK_NUMBER function, 111
ROWID_CREATE function, 111
ROWID_INFO procedure, 111
ROWID_OBJECT function, 111
ROWID_RELATIVE_FNO function, 111
ROWID_ROW_NUMBER function, 111
ROWID_TO_ABSOLUTE_FNO function, 111
ROWID_TO_EXTENDED function, 111
ROWID_TO_RESTRICTED function, 111
ROWID_TYPE function, 111
ROWID_VERIFY function, 111
rule sets
adding rules to, 113
creating, 113
dropping, 113
removing rules from, 113
rule-based transformations
setting, 130
rules
action contexts
adding name-value pairs, 236
getting name-value pairs, 236
getting value for name, 236
removing name-value pairs, 236
transformations, 130
altering, 113
creating, 113
DBMS_RULE package, 112
DBMS_RULE_ADM package, 113
dropping, 113
evaluation, 112
iterators, 112, 112
evaluation contexts
altering, 113
creating, 113
dropping, 113
object privileges
granting, 113
revoking, 113
propagations
removing, 130
RE$ATTRIBUTE_VALUE type, 236
RE$ATTRIBUTE_VALUE_LIST type, 236
RE$COLUMN_VALUE type, 236, 236
RE$COLUMN_VALUE_LIST type, 236
RE$NAME_ARRAY type, 236
RE$NV_ARRAY type, 236
RE$NV_LIST type, 236
RE$RULE_HIT type, 236
RE$RULE_HIT_LIST type, 236
RE$TABLE_ALIAS type, 236
RE$TABLE_ALIAS_LIST type, 236
RE$TABLE_VALUE type, 236
RE$TABLE_VALUE_LIST type, 236
RE$VARIABLE_TYPE type, 236
RE$VARIABLE_TYPE_LIST type, 236
RE$VARIABLE_VALUE type, 236
RE$VARIABLE_VALUE_LIST type, 236
subset
defining, 130, 130
system privileges
granting, 113
revoking, 113
system-created, 130
global apply, 130
global capture, 130
global propagation, 130
global schema, 130
message, 130, 130
message propagation, 130
removing, 130
schema capture, 130
schema propagation, 130
subset apply, 130
subset capture, 130
subset propagation, 130
table apply, 130
table capture, 130
table propagation, 130
types, 236
Rules Manager object types, 237
RUN procedure, 65
RUN_CHECK Procedure, 59
RUNTIME_INFO Record Type, 43

S

S function
of HTF package, 167
S procedure
of HTP package, 168
SAMPLE function
of HTF package, 167
SAMPLE procedure
of HTP package, 168
SAVE function, 128
SAVE Procedure, 150
SAVEPOINT procedure, 137
SCHEDULE_PROPAGATION Procedure, 76
SCHEDULER$_STEP_TYPE object type, 114
SCHEDULER$_STEP_TYPE_LIST table type, 114
SCHEMA_NAME Function, 25
SCHEMAVALIDATE procedure, 239
SCRIPT function
of HTF package, 167
SCRIPT procedure
of HTP package, 168
SCRIPT_TUNING_TASK Function, 125
SDO_CS package documentation, 180
SDO_CSW_PROCESS package documentation, 181
SDO_GCDR package documentation, 182
SDO_GEOM package documentation, 183
SDO_GEOR package documentation, 184
SDO_GEOR_ADMIN package documentation, 185
SDO_GEOR_UTL package documentation, 186
SDO_LRS package documentation, 187
SDO_MIGRATE package documentation, 188
SDO_NET package documentation, 189
SDO_NET_MEM package documentation, 190
SDO_OLS package documentation, 191
SDO_PC_PKG package documentation, 192
SDO_SAM package documentation, 193
SDO_TIN_PKG package documentation, 194
SDO_TOPO package documentation, 195
SDO_TOPO_MAP package documentation, 196
SDO_TUNE package documentation, 197
SDO_UTIL package documentation, 198
SDO_WFS_LOCK package documentation, 199
SDO_WFS_PROCESS package documentation, 200
security
DBMS_LOGSTDBY package, 73
SEED procedures, 93
SEGMENT_CORRUPT procedure, 120
SEGMENT_DROP_CORRUPT procedure, 120
SEGMENT_DUMP procedure, 120
SEGMENT_FIX_STATUS procedure, 97
SEGMENT_VERIFY procedure, 120
SELECT_BASELINE_METRICS Function, 146
SELECT_CURSOR_CACHE Function, 125
SELECT_OBJECT procedure, 215
SELECT_SQL_TRACE Function, 125
SELECT_SQLSET function, 125, 125
SELECT_WORKLOAD_REPOSITORY functions, 125
SELECTNODES function, 165
SELECTSINGLENODE function, 165
SELF_CHECK procedure, 43
SEM_APIS package documentation, 201
SEM_PERF package documentation, 202
SEND procedure, 172, 211
SEND_ATTACH_RAW procedure, 211
SEND_ATTACH_VARCHAR2 procedure, 211
SEND_MESSAGE function, 88
SERV_MOD_ACT_STAT_DISABLE procedure, 78
SERV_MOD_ACT_STAT_ENABLE procedure, 78
SERV_MOD_ACT_TRACE_DISABLE procedure, 78
SERV_MOD_ACT_TRACE_ENABLE procedure, 78
SESSION _TRACE_DISABLE Procedure, 117
SESSION _TRACE_ENABLE Procedur, 117
SESSION_TRACE_DISABLE procedure, 78
SESSION_TRACE_ENABLE procedure, 78
SET* member procedures
of ANYDATA TYPE, 221
of ANYDATASET TYPE, 222
SET_ACTION procedure, 19
SET_ANALYSIS_DEFAULT_PARAMETER Procedures, 124
SET_ANALYSIS_TASK_PARAMETER Procedure, 124
SET_AUTHENTICATION procedure, 207
SET_AUTHORIZATION procedure, 177
SET_BASE_TABLE_NAME member procedure, 228
SET_BASE_TABLE_OWNER member procedure, 228
SET_BODY_CHARSET procedures, 207, 207
SET_BREAKPOINT function, 43
SET_CLIENT_INFO procedure, 19
SET_CLIENT_SERVICE Procedure, 26
SET_CNS_EXCEPTION_LOG procedure, 37
SET_COLUMN_STATS procedures, 127
SET_COMMAND_TYPE member procedure, 228
SET_CONSUMER_GROUP_MAPPING procedure, 105
SET_CONSUMER_GROUP_MAPPING_PRI procedure, 105
SET_CONTEXT Procedure, 117
SET_COOKIE_SUPPORT procedures, 207
SET_CURRENT_SCHEMA member procedure, 228
SET_DAD_ATTRIBUTE Procedure, 51
SET_DATABASE_PREFS Procedure, 127
SET_DDL_TEXT member procedure, 228
SET_DEFAULT_SQLWKLD_PARAMETER Procedure, 17
SET_DEFAULT_TASK_PARAMETER Procedures, 17
SET_DEFAULTS procedure, 18
SET_DETAILED_EXCP_SUPPORT procedure, 207
SET_DIAGNOSIS_TASK_PARAMETER Procedure, 123
SET_DML_HANDLER procedure, 20
SET_ENQUEUE_DESTINATION procedure, 20
SET_EXECUTE procedure, 20
SET_EXPRESSION procedure, 39
SET_EXTRA_ATTRIBUTE member procedure, 228
SET_FOLLOW_REDIRECT procedures, 207
SET_GLOBAL_ATTRIBUTE Function, 51
SET_GLOBAL_INSTANTIATION procedure, 20
SET_GLOBAL_PREFS Procedure, 127
SET_HEADER procedure, 207
SET_IDENTIFIER, 117
SET_INDEX_STATS procedures, 127
SET_INITIAL_CONSUMER_GROUP procedure, 105
SET_JAVA_LOGGING_LEVEL procedure, 75
SET_KEY_COLUMNS procedure, 20
SET_LOB_INFORMATION member procedure, 228
SET_LOB_OFFSET member procedure, 228
SET_LOB_OPERATION_SIZE member procedure, 228
SET_LOG_LEVEL Procedure, 76
SET_LOGON_USER member procedure, 228
SET_MAILHOST Procedure, 23
SET_MAILPORT Procedure, 23
SET_MESSAGE_NOTIFICATION procedure, 130
SET_MESSAGE_TRACKING procedure, 130
SET_MODULE procedure, 19
SET_NLS Procedure, 117
SET_OBJECT_NAME member procedure, 228
SET_OBJECT_OWNER member procedure, 228
SET_OBJECT_TYPE member procedure, 228
SET_OER_BREAKPOINT function, 43
SET_OPTION Procedure, 76
SET_P1_RESOURCES Procedure, 26
SET_PARAM procedure, 127
SET_PARAMETER procedure, 28
apply process, 20
SET_PERSISTENT_CONN_SUPPORT procedure, 207
SET_PLSQL_LOGGING_LEVEL procedure, 75
SET_PLSQL_TRACE procedure, 136
SET_PROTECTION_REALM procedure, 177
SET_PROXY procedure, 75, 207
SET_RESPONSE_ERROR_CHECK procedure, 207
SET_ROLE Procedure, 117
SET_RULE_TRANSFORM_FUNCTION procedure, 130
SET_SCHEMA_INSTANTIATION procedure, 20
SET_SCHEMA_PREFS Procedure, 127
SET_SENDFROM Procedure, 23
SET_SESSION_LONGOPS procedure, 19
SET_SESSION_TIMEOUT procedure, 108
SET_SOURCE_DATABASE_NAME member procedure, 228
SET_SQL_TRACE Procedure, 117
SET_SQLWKLD_PARAMETER Procedure, 17
SET_SYSTEM_STATS procedure, 127
SET_TABLE_INSTANTIATION procedure, 20
SET_TABLE_PREFS Procedure, 127
SET_TABLE_STATS procedure, 127
SET_TAG member procedure, 228
SET_TAG procedure, 129
SET_TASK_PARAMETER Procedure, 17
SET_THRESHOLD procedure, 115
SET_TIMEOUT function, 43
SET_TIMEOUT procedure, 108
SET_TIMEOUT_BEHAVIOUR procedure, 43
SET_TRANSFER_TIMEOUT procedure, 207
SET_TRANSFORM procedure, 39
SET_TRIGGER_FIRING_PROPERTY procedure, 42
SET_TUNING_TASK_PARAMETER Function, 125
SET_UP_QUEUE procedure, 130
SET_UPDATE_CONFLICT_HANDLER procedure, 20
SET_VALUE function, 43
SET_VALUE member procedure, 228
SET_VALUE_DEPENDENCY procedure, 20
SET_VALUES member procedure, 228
SET_WALLET procedure, 207
SET_WARNING_SETTING_STRING procedure, 142
SET_WATERMARK Procedure, 22
SET_XML_INFORMATION member procedure, 228
SETACL Procedure, 150
SETACL procedure, 148
SETATTRIBUTE procedure, 155
SETATTRIBUTENODE function, 155
SETAUTHOR Procedure, 150
SETBASEDIR procedure, 158
SETBATCHSIZE procedure, 160
SETBINDVALUE procedure, 159
SETCHARACTERSET Procedure, 150
SETCOLLIDATTRNAME procedure, 159
SETCOMMENT Procedure, 150
SETCOMMITBATCH procedure, 160
SETCONTENT Procedures, 148, 150
SETCONTENTTYPE Procedure, 150
SETCONVERTSPECIALCHARS procedure, 156
SETCUSTOMMETADATA Procedure, 150
SETDATA procedure, 155
SETDATAHEADER procedure, 159
SETDATEFORMAT procedure, 159, 160
SETDCHARSET procedure, 155
SETDISPLAYNAME Procedure, 150
SETDOCTYPE Procedure, 155
SETDOCTYPE procedure, 158
SETDVERSION procedure, 155
SETENCODINGTAG procedure, 159
SETERRORLOG procedure, 158, 165
SETERRORTAG procedure, 159
SETFTPPORT Procedure, 148
SETHTTPPORT Procedure, 148
SETIGNORECASE procedure, 160
SETINFO member procedure
of ANYTYPE TYPE, 223
SETKEYCOLUMN procedure, 160, 162
SETLANGUAGE Procedure, 150
SETLISTENERENDPOINT Procedure, 148
SETLISTENERLOCALACCESS Procedure, 148
SETMAXROWS procedure, 156, 159
SETMETAHEADER procedure, 159
SETNAMEDITEM function, 155
SETNODEVALUE procedure, 155
SETNODEVALUEASBINARYSTREAM Function & Procedure, 155
SETNODEVALUEASCHARACTERSTREAM Function & Procedure, 155
SETOPTIONS Procedure, 69
SETOWNER Procedure, 150
SETPARAM procedure, 165
SETPREFIX procedure, 155
SETPRESERVEWHITESPACE procedure, 158, 160
SETRAISEEXCEPTION procedure, 159
SETRAISENOROWSEXCEPTION procedure, 159
SETRENDERPATH Procedure, 154
SETRENDERSTREAM Procedure, 154
SETROWIDATTRNAME procedure, 159
SETROWIDATTRVALUE procedure, 159
SETROWSETTAG procedure, 156, 159
SETROWTAG procedure, 159, 160, 162
SETSCHEMAVALIDATED procedure, 239
SETSKIPROWS procedure, 156, 159
SETSOURCELANG Function, 163
SETSQLTOXMLNAMEESCAPING procedure, 159, 160
SETSTANDALONE procedure, 155
SETSTYLESHEETHEADER procedure, 159
SETTAGCASE procedure, 159
SETUPDATECOLUMN procedure, 160, 162
SETVALIDATIONMODE procedure, 158
SETVALUE procedure, 155
SETXSLT procedure, 159, 160
SETXSLTPARAM procedure, 159, 160
SHOW_BREAKPOINTS procedures, 43
SHOW_EXTENDED_STATS_NAME Function, 127
SHOW_FRAME_SOURCE procedure, 43
SHOW_SOURCE procedures, 43
SHOW_STATS procedure, 217
SHOWPAGE procedure, 179
SHOWSOURCE procedure, 179
SHOWWARNINGS procedure, 158, 165
SHUTDOWN Procedure, 76
SIGNAL procedure, 18
SIGNATURE procedure, 179
SIMPLE_SQL_NAME Function, 25
SIZES procedure, 118
SKIP_CORRUPT_BLOCKS procedure, 97
SLEEP procedure, 70
SMALL function
of HTF package, 167
SMALL procedure
of HTP package, 168
snapshot. See DBMS_MVIEW, 79
SOURCE_LINES_T Table Type, 90
SPACE_ERROR_INFO function, 108
SPACE_USAGE procedure, 119
split streams, 130
SPLIT_STREAMS procedure, 130
SPLITPATH Procedure, 148
SPLITTEXT function, 155
SQL Apply
managing logical standby databases, 73
managing with DBMS_LOGSTDBY package, 73
SQL*Plus
creating a sequence, 1
SQL_OBJECT_NAME Function, 25
SQLID_TO_SQLHASH Function, 141
SQLSET_ROW Object Type, 125
SQLTEXT_TO_SIGNATURE Function, 125
STACK_BIN_CAT procedure, 39
STACK_BIN_NUM procedure, 39
STACK_CLIP procedure, 39
STACK_COL_REM procedure, 39
STACK_MISS_CAT procedure, 39
STACK_MISS_NUM procedure, 39
STACK_NORM_LIN procedure, 39
staging
queues
creating, 130
removing, 130
START_APPLY procedure, 20
START_CAPTURE Procedure, 144
START_CAPTURE procedure, 28
START_POOL Procedure, 32
START_PROFILER functions and procedures, 91
START_PROFILING Procedure, 60
START_PROPAGATION procedure, 92
START_REDEF_TABLE procedure, 95
START_REPLAY Procedure, 145
START_SERVICE procedure, 116
STARTUP Procedure, 76
STARTUP_EXTPROC_AGENT procedure, 166
STATUS Function, 107
STATUS_LINE procedure, 179
STEP_ID function, 137
STOP_APPLY procedure, 20
STOP_CAPTURE procedure, 28
STOP_POOL Procedure, 32
STOP_PROFILER function and procedure, 91
STOP_PROFILING Procedure, 60
STOP_PROPAGATION procedure, 92
STOP_SERVICE procedure, 116
STORE_VALUES procedure, 175
stored outlines
DBMS_OUTLN, 85
OUTLN_PKG package, 85
STREAM2MULTI procedure, 178
Streams
removing configuration, 130
STREAMS$_TRANSFORM_FUNCTION, 130
STRIKE function
of HTF package, 167
STRIKE procedure
of HTP package, 168
STRING function, 93
STRING_TO_RAW Function, 208
STRONG function
of HTF package, 167
STRONG procedure
of HTP package, 168
STYLE function
of HTF package, 167
STYLE procedure
of HTP package, 168
SUB procedure
of HTP package, 168
SUBMIT procedure, 65
SUBMIT_PENDING_AREA procedure, 105
subscribers
drop the subscription, 30
extend the window to create a new view, 30
purging the subscription window, 30
retrieve change data from the subscriber views, 30
subscription window
purging, 30
SUBSTR function, 213
SUBSTR Functions, 69
SUBSTRINGDATA function, 155
Summary of DBMS_AQELM Subprograms, 23
Summary of DBMS_DIMENSION Subprograms, 49
Summary of DBMS_ERRLOG Subprograms, 52
Summary of DBMS_MVIEW Subprograms, 79
Summary of DBMS_XDBZ Subprograms, 153
Summary of DBMS_XMLDOM Subprograms, 155
Summary of DBMS_XMLSCHEMA Subprograms, 161
Summary of UTL_LMS Subprograms, 210
SUMMARY procedure, 126
SUP function
of HTF package, 167
SUP procedure
of HTP package, 168
SWITCH_CONSUMER_GROUP_FOR_SESS procedure, 105
SWITCH_CONSUMER_GROUP_FOR_USER procedure, 105
SWITCH_CURRENT_CONSUMER_GROUP Procedure, 117
SWITCH_PLAN procedure, 105
SYNC_INTERIM_TABLE procedure, 95
SYNC_TEXT_INDEXES procedure, 53, 109
SYNCHRONIZE function, 43
synchronous capture
altering, 28
instantiation
preparing a table for, 28
rules, 130
SYNCINDEX Procedure, 157
synonyms
comparing, 31
SYS.MGW_MQSERIES_PROPERTIES Object Type, 76
SYS.MGW_PROPERTIES Object Type, 76
SYS.MGW_PROPERTY Object Type, 76
SYS.MGW_TIBRV_PROPERTIES Object Type, 76

T

table alias
attributes, 226
TABLE_TO_COMMA procedures, 141
TABLECAPTION function
of HTF package, 167
TABLECAPTION procedure
of HTP package, 168
TABLECLOSE function
of HTF package, 167
TABLECLOSE procedure
of HTP package, 168
TABLEDATA function
of HTF package, 167
TABLEDATA procedure
of HTP package, 168
TABLEHEADER function
of HTF package, 167
TABLEHEADER procedure
of HTP package, 168
TABLEOPEN function
of HTF package, 167
TABLEOPEN procedure
of HTP package, 168
TABLEPRINT function, 179
TABLEROWCLOSE function
of HTF package, 167
TABLEROWCLOSE procedure
of HTP package, 168
TABLEROWOPEN function
of HTF package, 167
TABLEROWOPEN procedure
of HTP package, 168
tables
comparing, 31
table items as arrays, 122
tablespace repositories
attaching tablespaces, 134
cloning tablespaces, 134
detaching tablespaces, 134
TABLESPACE_FIX_BITMAPS procedure, 120
TABLESPACE_FIX_SEGMENT_STATES procedure, 120
TABLESPACE_MIGRATE_FROM_LOCAL procedure, 120
TABLESPACE_MIGRATE_TO_LOCAL procedure, 120
TABLESPACE_REBUILD_BITMAPS procedure, 120
TABLESPACE_REBUILD_QUOTAS procedure, 120
TABLESPACE_RELOCATE_BITMAPS procedure, 120
TABLESPACE_SET type, 134
TABLESPACE_VERIFY procedure, 120
tablespaces
change tables and, 29
tags
GET_TAG function, 129
SET_TAG procedure, 129
TARGET_PROGRAM_RUNNING procedure, 43
TELETYPE function
of HTF package, 167
TELETYPE procedure
of HTP package, 168
TERMINATE procedure, 93
TEXT_DECODE function, 205
TEXT_ENCODE function, 205
TIME_TABLE Table Type, 122
TIME_WITH_TIME_ZONE_TABLE Table Type, 122
TIMESTAMP_TABLE Table Type, 122
TIMESTAMP_WITH_LTZ_TABLE Table Type, 122
TIMESTAMP_WITH_TIME_ZONE_TABLE Table Type, 122
TITLE function
of HTF package, 167, 167
TITLE procedure
of HTP package, 168
TO_CURSOR_NUMBER Function, 122
TO_REFCURSOR Function, 122
TO_STRING function, 235
TODATE function, 179
TOOBJECT procedure, 239
TOUCHRESOURCE Procedure, 148
TRACE procedure, 37
TRACETAB.SQL, 136
tracking LCRs, 130, 130
TRANSACTION_BACKOUT Procedures, 57
TRANSFORM function, 239
transformations
rule-based
adding a column, 130
custom, 130
deleting a column, 130
renaming a column, 130
renaming a schema, 130
renaming a table, 130
STREAMS$_TRANSFORM_FUNCTION, 130
TRANSFORMNODE function, 165
TRANSLATE function, 213, 235
TRANSLATEXML Function, 163
TRANSLITERATE Function, 208
transparent data encryption
apply process, 20
TRANSPORT_SET_CHECK procedure, 139
TRIM Procedures, 69
TUNE_MVIEW Procedure, 17
types
Expression Filter, 226
MGD_ID, 235, 235
MGD_ID_COMPONENT, 235
MGD_ID_COMPONENT_VARRAY, 235
Rules Manager, 237

U

ULISTCLOSE function
of HTF package, 167
ULISTCLOSE procedure
of HTP package, 168
ULISTOPEN function
of HTF package, 167
ULISTOPEN procedure
of HTP package, 168
UNASSIGN_ACL Procedure, 80
UNASSIGN_ATTRIBUTE_SET procedure, 53
UNCHECKOUT function, 151
UNDERLINE function
of HTF package, 167
UNDERLINE procedure
of HTP package, 168
UNESCAPE function, 219
UNESCAPEURI function, 225
UNIFORM_DIST_FIT procedure, 126
UNIQUE_SESSION_ID Function, 117
UNIQUE_SESSION_NAME function, 88
UNKEEP procedure, 118
UNLOCK_MAP procedure, 128
UNLOCK_PARTITION_STATS Procedure, 127
UNLOCK_SCHEMA_STATS procedure, 127
UNLOCK_TABLE_STATS procedure, 127
UNLOCKRESOURCE function, 148
UNMAP_DAD Procedure, 51
UNPACK_MESSAGE procedures, 88
UNPACK_STGTAB_BASELINE Function, 121
UNPACK_STGTAB_SQLPATCH Procedure, 123
UNPACK_STGTAB_SQLPROF Procedure, 125
UNPACK_STGTAB_SQLSET Procedure, 125
UNREGISTER_DEPENDENT_OBJECT procedure, 95
UNREGISTER_FOREIGN_QUEUE Procedure, 76
UNREGISTERURLHANDLER procedure, 225
UNSCHEDULE_PROPAGATION Procedure, 76
UNUSED_SPACE procedure, 119
UPDATE_BY_CAT procedure, 85
UPDATE_CONSUMER_GROUP procedure, 105
UPDATE_OBJECT Procedure, 17
UPDATE_OBJECT procedure, 215
UPDATE_PLAN procedure, 105
UPDATE_PLAN_DIRECTIVE procedure, 105
UPDATE_REC_ATTRIBUTES Procedure, 17
UPDATE_SIGNATURES procedure, 85
UPDATE_SQLSET procedures, 125
UPDATE_SQLWKLD_ATTRIBUTES Procedure, 17
UPDATE_SQLWKLD_STATEMENT Procedure, 17
UPDATE_TASK_ATTRIBUTES Procedure, 17
UPDATERESOURCEMETADATA Procedures, 148
UPDATETRANSLATION Function, 163
UPDATEXML function, 160, 162
UPGRADE_STAT_TABLE procedure, 127
upgrading
post-upgrade actions, 82
URI Types
description, 225
UriFactory package, 225
ESCAPEURI function, 225
GETURL function, 225
methods, 225
REGISTERURLHANDLER procedure, 225
UNESCAPEURI function, 225
UNREGISTERURLHANDLER procedure, 225
UriType supertype, 225
GETBLOB function, 225
GETCLOB function, 225
GETCONTENTTYPE function, 225
GETEXTERNALURL function, 225
GETURL function, 225
GETXML function, 225
methods, 225
UROWID_TABLE Table Type, 122
USE_ROLLBACK_SEGMENT procedure, 137
USEBINARYSTREAM Function, 155
USEITEMTAGSFORCOLL procedure, 156
USENULLATTRIBUTEINDICATOR procedure, 156, 159
USER_EXPORT procedures, 65
USETYPEFORCOLLELEMTAG procedure, 159
Using DBMS_ADVISOR, 17
Using DBMS_AQIN, 24, 24
Using DBMS_FILE_GROUP, 55
Using DBMS_MVIEW, 79
Using DBMS_RULE, 112
Using DBMS_RULE_ADM, 113
Using DBMS_STREAMS, 129
Using DBMS_STREAMS_ADM, 130
Using DBMS_STREAMS_TABLESPACE_ADM, 134
Using DBMS_XMLDOM, 155
Using DBMS_XMLSCHEMA, 161
Using UTL_HTTP, 207
UTL Streams Types, 238
UTL_BINARYINPUTSTREAM Type, 238
UTL_BINARYOUTPUTSTREAM Type, 238
UTL_CHARACTERINPUTSTREAM Type, 238
UTL_CHARACTEROUTPUTSTREAM Type, 238
UTL_COLL package, 203
UTL_COMPRESS package, 204
UTL_ENCODE package, 205
UTL_FILE package, 206
UTL_HTTP package, 207
UTL_I18N package, 208
ESCAPE_REFERENCE function, 208, 208, 208, 208, 208, 208, 208
GET_DEFAULT_CHARSET function, 208
MAP_CHARSET function, 208
MAP_LANGUAGE_FROM_ISO function, 208
MAP_LOCALE_TO_ISO function, 208
MAP_TERRITORY_FROM_ISO function, 208
RAW_TO_CHAR function, 208
RAW_TO_NCHAR function, 208
UNESCAPE_REFERENCE function, 208
UTL_INADDR package, 209
UTL_LMS package, 210
FORMAT_MESSAGE function, 210
GET_MESSAGE function, 210
UTL_MAIL package, 211
UTL_NLA package, 212
UTL_RAW package, 213
UTL_RECOMP package, 214
UTL_REF package, 215
UTL_SPADV package, 217
UTL_TCP package, 218
UTL_URL package, 219
UUDECODE function, 205
UUENCODE function, 205

V

V$STREAMS_MESSAGE_TRACKING view, 130, 130
v$vpd_policies, 110
VALIDATE procedure, 141
VALIDATE_DIMENSION procedure, 49
VALIDATE_EXPRESSIONS procedure, 53
VALIDATE_PENDING_AREA procedure, 105
VALIDATE_REWRITE_EQUIVALENCE Procedure, 16
VALIDATE_SCHEME function, 75
VALIDATE_XML procedure, 36
VALUE functions, 93
VALUEOF procedure, 165
VARCHAR2_TABLE Table Type, 122
VARCHAR2A Table Type, 122
VARCHAR2S Table Type, 122
VARIABLE function
of HTF package, 167
VARIABLE procedure
of HTP package, 168
VARIABLE_VALUE procedures, 122
VERIFY_VALUES function, 175
views
comparing, 31
virtual dependency definitions
object dependencies
creating, 20
dropping, 20
value dependencies, 20
Virtual Private Database. See VPD
VPD
column masking, 110
enabling column-level, 110
viewing current cursors and policy predicates, 110
VPD use of DBMS_RLS, 110
VRFY function, 216

W

WAITANY procedure, 18
WAITONE procedure, 18
WBR function
of HTF package, 167
WBR procedure
of HTP package, 168
WEIBULL_DIST_FIT procedure, 126
WHAT procedure, 65
WHO_CALLED_ME procedure, 179
WPG_DOCLOAD package, 220
WRAP Functions, 42
WRITE Procedures, 69
WRITE_DATA procedure, 216
WRITE_LINE function, 218
WRITE_LINE procedure, 207
WRITE_RAW function, 218
WRITE_RAW procedure, 207
WRITE_RAW_DATA procedure, 216
WRITE_TEXT function, 218
WRITE_TEXT procedure, 207
WRITEAPPEND Procedures, 69
WRITETOBUFFER procedure, 155
WRITETOCLOB procedure, 155
WRITETOFILE procedure, 155

X

XA_COMMIT Function, 147
XA_END Function, 147
XA_FORGET Function, 147
XA_GETLASTOER Function, 147
XA_PREPARE Function, 147
XA_RECOVER Function, 147
XA_ROLLBACK Function, 147
XA_SETTIMEOUT Function, 147
XA_START Function, 147
XDBEvent Type Subprograms, 154
XDBHandler Type Subprograms, 154
XDBHandlerList Type Subprograms, 154
XDBLink Type Subprograms, 154
XDBPath Type Subprograms, 154
XDBRepositoryEvent Type Subprograms, 154
XDBUriType, 225
XDBURITYPE function, 225
XDBUriType subtype, 225
CREATEURI function, 225
GETBLOB function, 225
GETCLOB function, 225
GETCONTENTTYPE function, 225
GETEXTERNALURL function, 225
GETURL function, 225
GETXML function, 225
methods, 225
XDBURITYPE function, 225
XDBZ Constants, 153
XFORM_BIN_CAT procedure, 39
XFORM_BIN_NUM procedure, 39
XFORM_CLIP procedure, 39
XFORM_COL_REM procedure, 39
XFORM_EXPR_NUM procedure, 39
XFORM_EXPR_STR procedure, 39
XFORM_MISS_CAT procedure, 39
XFORM_MISS_NUM procedure, 39
XFORM_NORM_LIN procedure, 39
XFORM_STACK procedure, 39
XML tags
specifying list of
configuring index parameters, 226
XML_TO_LCR Function, 77
XMLINDEXADDPATH Function, 149
XMLINDEXREMOVEPATH Function, 149
XMLType
CREATENONSCHEMABASEDXML function, 239
CREATESCHEMABASEDXML function, 239
CREATEXML function, 239
description, 239
EXISTSNODE function, 239
EXTRACT function, 239
GETBLOBVAL function, 239
GETCLOBVAL function, 239
GETNUMBERVAL function, 239
GETROOTELEMENT function, 239
GETSCHEMAURL function, 239
GETSTRINGVAL function, 239
ISFRAGMENT function, 239
ISSCHEMABASED function, 239
ISSCHEMAVALID function, 239
ISSCHEMAVALIDATED function, 239
NAMESPACE function, 239
SCHEMAVALIDATE procedure, 239
SETSCHEMAVALIDATED procedure, 239
TOOBJECT procedure, 239
TRANSFORM function, 239
XMLTYPE function, 239
XMLTYPE function, 239
XPath parameters
adding to attribute list, 53
dropping from attribute list, 53
XPath predicates
indexing set of
configuring XML element or XML attribute, 226
XPINDEX_PARAMETERS procedure, 53
XRANGE function, 213