Skip Headers
Oracle® Database PL/SQL Packages and Types Reference
11g Release 2 (11.2)
Part Number E10577-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
View PDF

Index

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

A

ABORT procedure, 119
ABORT_GLOBAL_INSTANTIATION procedure, 30
ABORT_REDEF_TABLE procedure, 107
ABORT_SCHEMA_INSTANTIATION procedure, 30
ABORT_TABLE_INSTANTIATION procedure, 30
ABORTED_REQUEST_THRESHOLD procedure, 129
ACCEPT_SQL_PATCH Procedure, 134
ACCEPT_SQL_PROFILE procedure, 136
ACLCHECKPRIVILEGES function, 160
ACTIVATE_SUBSCRIPTION Procedure, 32
ACTIVE_INSTANCES procedure, 153
ADD_COLORED_SQL Procedure, 158
ADD_COLUMN member procedure, 245
ADD_COLUMN procedure, 141
ADD_COOKIES procedure, 221
ADD_COST_MATRIX procedure, 42
ADD_ELEMENTARY_ATTRIBUTE procedure, 62, 120
ADD_EVENT procedure, 120
ADD_FILE procedure, 64
ADD_FILTER Procedure, 156, 157
ADD_FUNCTIONS procedure, 62, 120
ADD_GLOBAL_PROPAGATION_RULES procedure, 141
ADD_GLOBAL_RULES procedure, 141
ADD_MESSAGE_PROPAGATION_RULE procedure, 141
ADD_MESSAGE_RULE procedure, 141
ADD_PAIR member procedure, 253
ADD_PRIVILEGE Procedure, 91
ADD_RULE procedure, 120, 124
ADD_SCHEMA_PROPAGATION_RULES procedure, 141
ADD_SCHEMA_RULES procedure, 141
ADD_SCHEME procedure, 86
ADD_SQLSET_REFERENCE function, 136
ADD_SQLWKLD_REF Procedure, 17
ADD_SQLWKLD_STATEMENT Procedure, 17
ADD_STMT_HANDLER procedure, 20
ADD_STMT_TO_HANDLER procedure, 144
ADD_SUBSCRIBER Procedure, 87
ADD_SUBSET_PROPAGATION_RULES procedure, 141
ADD_SUBSET_RULES procedure, 141
ADD_TABLE_PROPAGATION_RULES procedure, 141
ADD_TABLE_RULES procedure, 141
ADD_WARNING_SETTING_CAT procedure, 154
ADD_WARNING_SETTING_NUM procedure, 154
ADD2MULTI procedure, 190
ADDATTR member procedure
of ANYTYPE TYPE, 239
ADDINSTANCE member procedure
of ANYDATASET TYPE, 238
ADDMIMEMAPPING Procedure, 160
ADDREPOSITORYRESCONFIG Procedure, 115
ADDRESCONFIG Function, 115
ADDRESS function
of HTF package, 179
ADDRESS procedure
of HTP package, 180
ADDSCHEMALOCMAPPING Procedure, 160
ADDSERVLET Procedure, 160
ADDSERVLETMAPPING Procedure, 160
ADDSERVLETSECROLE Procedure, 160
ADDXMLEXTENSION Procedure, 160
ADM_DROP_CHUNKS Procedure, 98
ADM_DROP_TASK Procedure, 98
ADM_GET_TASK_STATUS Procedure, 98
ADM_STOP_TASK Procedure, 98
ADMIN_TABLES procedure, 109
ADVISE_COMMIT procedure, 149
ADVISE_NOTHING procedure, 149
ADVISE_ROLLBACK procedure, 149
advisors
Oracle Streams, 142
aggregation management, 39
aggregation operators (OLAP), 39
ALLOCATE_UNIQUE procedure, 80
ALTER_AGENT Procedure, 87
ALTER_APPLY procedure, 20
ALTER_CAPTURE procedure, 30
ALTER_COMPILE procedure, 50
ALTER_EVALUATION_CONTEXT procedure, 124
ALTER_FILE procedure, 64
ALTER_FILE_GROUP procedure, 64
ALTER_JOB Procedure, 87
ALTER_MSGSYSTEM_LINK Procedure for TIB/Rendezvous, 87
ALTER_MSGSYSTEM_LINK Procedure for WebSphere MQ, 87
ALTER_PARAM Procedure, 35
ALTER_PROPAGATION procedure, 104
ALTER_PROPAGATION_SCHEDULE Procedure, 87
ALTER_REVERSE_EXPRESSION procedure, 42
ALTER_REWRITE_EQUIVALENCE Procedure, 16
ALTER_RULE procedure, 124
ALTER_SQL_PATCH Procedure, 134
ALTER_SQL_PLAN_BASELINE Procedure, 132
ALTER_SQL_PROFILE procedure, 136
ALTER_STATS_HISTORY_RETENTION procedure, 138
ALTER_SUBSCRIBER Procedure, 87
ALTER_SYNC_CAPTURE procedure, 30
ALTER_TABLE_NOT_REFERENCEABLE procedure, 50
ALTER_TABLE_REFERENCEABLE procedure, 50
ALTER_VERSION procedure, 64
AMATCH function, 188
ANALYZE Function, 70
ANALYZE Procedure, 29
ANALYZE_CURRENT_PERFORMANCE procedure, 142
ANALYZE_DATABASE Procedure, 153
ANALYZE_DB Procedure, 15
ANALYZE_INST Procedure, 15
ANALYZE_PART_OBJECT procedure, 153
ANALYZE_PARTIAL Procedure, 15
ANALYZE_SCHEMA Procedure, 153
ANCHOR function
of HTF package, 179
ANCHOR procedure
of HTP package, 180
ANCHOR2 function
of HTF package, 179
ANCHOR2 procedure
of HTP package, 180
anonymous PL/SQL blocks
dynamic SQL and, 133
AnyData datatype
queues
creating, 141
removing, 141
ANYDATA TYPE, 237
ANYDATASET TYPE, 238
ANYTYPE TYPE, 239
APEX_APPLICATION package documentation, 3
APEX_CUSTOM_AUTH package documentation, 2
APEX_ITEM package documentation, 4
APPEND Procedures, 79
APPENDCHILD function, 167
APPENDDATA procedure, 167
APPENDPATH Procedure, 160
APPENDRESCONFIG Procedure, 115
APPENDRESOURCEMETADATA Procedure, 160
APPLETCLOSE function
of HTF package, 179
APPLETCLOSE procedure
of HTP package, 180
APPLETOPEN function
of HTF package, 179
APPLETOPEN procedure
of HTP package, 180
APPLY procedure, 42
apply process
altering, 20
apply user, 141
change handlers
setting, 20
conflict handlers
setting, 20
creating, 20, 141, 141, 141, 141, 141
DBMS_APPLY_ADM package, 20
DDL handler
setting, 20, 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_age_spill_threshold, 20
txn_lcr_spill_threshold, 20
precommit handler
setting, 20, 20
procedure DML handlers
setting, 20
rules
defining global, 141
defining message, 141
defining schema, 141
defining subset, 141
defining table, 141
for LCRs, 141
for user messages, 141
removing, 141
specifying execution, 20
starting, 20
statement DML handlers
setting, 20, 20
stopping, 20
substitute key columns
setting, 20
transparent data encryption, 20
APPLY$_ENQUEUE, 20
APPLY$_EXECUTE, 20
AQ$_AGENT Type, 240
AQ$_AGENT_LIST_T Type, 240
AQ$_DESCRIPTOR Type, 240, 240
AQ$_NTFN_MSGID_ARRAY Type, 240
AQ$_POST_INFO Type, 240
AQ$_POST_INFO_LIST Type, 240
AQ$_PURGE_OPTIONS_T Type, 240
AQ$_RECIPIENT_LIST_T Type, 240
AQ$_REG_INFO Type, 240
AQ$_REG_INFO_LIST Type, 240
AQ$_SUBSCRIBER_LIST_T Type, 240
AREA function
of HTF package, 179
AREA procedure
of HTP package, 180
arrays
BIND_ARRAY procedure, 133
bulk DML using DBMS_SQL, 133
ASA_RECO_ROW Record Type, 130
ASA_RECO_ROW_TB Table Type, 130
ASA_RECOMMENDATIONS Function, 130
ASH_GLOBAL_REPORT_HTML Function, 158
ASH_GLOBAL_REPORT_TEXT Function, 158
ASH_REPORT_HTML Function, 158
ASH_REPORT_TEXT Function, 158
ASSIGN_ACL Procedure, 91
ASSIGN_ATTRIBUTE_SET procedure, 62
ASSIGN_WALLET_ACL Procedure, 91
ASSM_SEGMENT_VERIFY Procedure, 131
ASSM_TABLESPACE_VERIFY Procedure, 131
ATTACH_SESSION procedure, 51
ATTACH_SIMPLE_TABLESPACE procedure, 146
ATTACH_TABLESPACES procedure, 146
attribute sets
dropping, 62
AUTHORIZE function, 185
AUTHORIZE_DAD Procedure, 60
AVAILABLE function, 234
AWR_BASELINE_METRIC_TYPE Object Type, 158
AWR_BASELINE_METRIC_TYPE_TABLE Table Type, 158
AWR_DIFF_REPORT_HTML Function, 158
AWR_DIFF_REPORT_TEXT Function, 158
AWR_GLOBAL_DIFF_REPORT_HTML Functions, 158
AWR_GLOBAL_DIFF_REPORT_TEXT Functions, 158, 158
AWR_GLOBAL_REPORT_HTML Functions, 158
AWR_GLOBAL_REPORT_TEXT Functions, 158
AWR_REPORT_HTML function, 158
AWR_REPORT_TEXT function, 158
AWR_SQL_REPORT_HTML Function, 158
AWR_SQL_REPORT_TEXT Function, 158

B

BASE function
of HTF package, 179
BASE procedure
of HTP package, 180
BASE64_DECODE function, 219
BASE64_ENCODE function, 219
BASEFONT function
of HTF package, 179
BASEFONT procedure
of HTP package, 180
BEGIN_DISCRETE_TRANSACTION procedure, 149
BEGIN_PREPARE Procedure, 58
BEGIN_REQUEST function, 221
BEGIN_UPGRADE Procedure, 58
BEGINCREATE static procedure
of ANYDATA TYPE, 237
of ANYDATASET TYPE, 238
of ANYTYPE TYPE, 239
BFILE_TABLE Table Type, 133
BGSOUND function
of HTF package, 179
BGSOUND procedure
of HTP package, 180
BIG function
of HTF package, 179
BIG procedure
of HTP package, 180
BINARY_DOUBLE_TABLE Table Type, 133
BINARY_FLOAT_TABLE Table Type, 133
BIND_ARRAY procedures, 133
BIND_INOUT_VARIABLE Procedure, 72
BIND_INOUT_VARIABLE_RAW Procedure, 72
BIND_OUT_VARIABLE Procedure, 72
BIND_OUT_VARIABLE_RAW Procedure, 72
BIND_VARIABLE Procedure, 72
BIND_VARIABLE procedures, 133
BIND_VARIABLE_RAW Procedure, 72
BIND_VARIABLES function, 191
BIT_AND function, 229
BIT_COMPLEMENT function, 229
BIT_OR function, 229
BIT_XOR function, 229
BLAS Level 1 (Vector-Vector Operations) Subprograms, 228
BLAS Level 2 (Matrix-Vector Operations) Subprograms, 228
BLAS Level 3 (Matrix-Matrix Operations) Subprograms, 228
BLAS_ASUM Functions, 228
BLAS_AXPY Procedures, 228
BLAS_COPY Procedures, 228
BLAS_DOT Functions, 228
BLAS_GBMV Procedures, 228
BLAS_GEMM Procedures, 228
BLAS_GEMV Procedures, 228
BLAS_GER Procedures, 228
BLAS_IAMAX Functions, 228
BLAS_NRM2 Functions, 228
BLAS_ROT Procedures, 228
BLAS_ROTG Procedures, 228
BLAS_SBMV Procedures, 228
BLAS_SCAL Procedure, 228
BLAS_SPMV Procedures, 228
BLAS_SPR Procedures, 228
BLAS_SPR2 Procedures, 228
BLAS_SWAP Procedure, 228
BLAS_SYMM Procedures, 228
BLAS_SYMV Procedures, 228
BLAS_SYR Procedures, 228
BLAS_SYR2 Procedures, 228
BLAS_SYRK Procedures, 228
BLAS_TBMV Procedures, 228
BLAS_TBSV Procedures, 228
BLAS_TPMV Procedures, 228
BLAS_TPSV Procedures, 228
BLAS_TRMM Procedures, 228
BLAS_TRMV Procedures, 228
BLAS_TRSM Procedures, 228
BLAS_TRSV Procedures, 228
BLOB_TABLE Table Type, 133
BLOCKQUOTECLOSE function
of HTF package, 179
BLOCKQUOTECLOSE procedure
of HTP package, 180, 180
BLOCKQUOTEOPEN function
of HTF package, 179
BLOCKQUOTEOPEN procedure
of HTP package, 180
BODYCLOSE function
of HTF package, 179
BODYCLOSE procedure
of HTP package, 180
BODYOPEN function
of HTF package, 179
BODYOPEN procedure
of HTP package, 180
BOLD function
of HTF package, 179
BOLD procedure
of HTP package, 180
BR function
of HTF package, 179
BR procedure
of HTP package, 180
BREAKPOINT_INFO Record Type, 51
BROKEN procedure, 75
BUILD procedure, 30, 39
BUILD_CHAIN_ROWS_TABLE procedure, 74
BUILD_EXCEPTIONS_TABLE procedure, 62, 74
BUILD_PART_INDEX procedure, 99
BUILD_SAFE_REWRITE_EQUIVALENCE Procedure, 16
BYPASS Procedure, 118

C

CALENDARPRINT procedures, 191
CALIBRATE Function, 157
CALIBRATE_IO Procedure, 116
CAN_REDEF_TABLE procedure, 107
CANCEL_ANALYSIS_TASK Procedure, 135
CANCEL_DIAGNOSIS_TASK Procedure, 134
CANCEL_REPLAY Procedure, 157
CANCEL_TASK Procedure, 17
CANCEL_TUNING_TASK procedure, 136
CANONICALIZE procedure, 153
capture process
altering, 30
building a Streams data dictionary, 30
capture user, 141
creating, 141, 141, 141, 141
in-flight transactions, 30
DBMS_CAPTURE_ADM package, 30
instantiation
aborting database preparation, 30
aborting schema preparation, 30
aborting table preparation, 30
preparing a database for, 30
preparing a schema for, 30
preparing a table for, 30
parameters
disable_on_limit, 30
downstream_real_time_mine, 30
maximum_scn, 30
message_limit, 30
message_tracking_frequency, 30
parallelism, 30
setting, 30
skip_autofiltered_table_ddl, 30
startup_seconds, 30
time_limit, 30
trace_level, 30
write_alert_log, 30
rules, 141
defining global, 141
defining schema, 141
defining subset, 141
defining table, 141
removing, 141
starting, 30
stopping, 30
CAPTURE_CURSOR_CACHE_SQLSET Procedure, 136
CAST_FROM_BINARY_DOUBLE function, 229
CAST_FROM_BINARY_FLOAT function, 229
CAST_FROM_BINARY_INTEGER function, 229
CAST_FROM_NUMBER function, 229
CAST_TO_BINARY_DOUBLE function, 229
CAST_TO_BINARY_FLOAT function, 229
CAST_TO_BINARY_INTEGER function, 229
CAST_TO_NUMBER function, 229
CAST_TO_NVARCHAR2 function, 229
CAST_TO_RAW function, 229
CAST_TO_VARCHAR2 function, 229
CB$ table prefix, 39
CELLSPRINT procedures, 191
CENTER function
of HTF package, 179
CENTER procedure
of HTP package, 180
CENTERCLOSE function
of HTF package, 179
CENTERCLOSE procedure
of HTP package, 180
CENTEROPEN function
of HTF package, 179
CENTEROPEN procedure
of HTP package, 180
CFG_GET function, 160
CFG_REFRESH procedure, 160
CFG_UPDATE procedure, 160
Change Data Capture
DBMS_CDC_PUBLISH package, 31
change data capture
Oracle Streams
configuring, 141
CHANGE functions and procedures, 188
CHANGE procedure, 75
change tables
tablespaces created in, 31
CHANGEOWNER Procedure, 160
CHANGEPRIVILEGES Function, 160
CHARARR Table Type, 97
CHECK_OBJECT procedure, 109
CHECK_PRIVILEGE Procedure, 91
CHECK_PRIVILEGE_ACLID Function, 91
CHECKACCESS Function, 43, 44
CHECKIN function, 162
CHECKOUT procedure, 162
CHECKPRIVILEGES function, 160
CHECKSPI Functions and Procedures, 43
CHECKSUM functions, 187
CHOOSE_DATE procedure, 191
CITE function
of HTF package, 179
CITE procedure
of HTP package, 180
CLEAN_AUDIT_TRAIL procedure, 26
CLEANUP_GATEWAY Procedure, 87
CLEANUP_INSTANTIATION_SETUP procedure, 141
CLEANUPUNUSEDBACKUPFILES Procedure, 45
CLEAR Procedure, 166
CLEAR_ALL_CONTEXT Procedure, 128
CLEAR_AUDIT_TRAIL_PROPERTY procedure, 26
CLEAR_CONTEXT Procedure, 128
CLEAR_COOKIES procedure, 221
CLEAR_EXPRSET_STATS procedure, 62
CLEAR_IDENTIFIER Procedure, 128
CLEAR_LAST_ARCHIVE_TIMESTAMP procedure, 26
CLEAR_PENDING_AREA procedure, 116
CLEAR_PLSQL_TRACE procedure, 148
CLEAR_USED procedure, 96
CLEARKEYCOLUMNLIST procedure, 172, 174
CLEARUPDATECOLUMNLIST procedure, 172, 174
CLIENT_ID_STAT_DISABLE procedure, 89
CLIENT_ID_STAT_ENABLE procedure, 89
CLIENT_ID_TRACE_DISABLE procedure, 89
CLIENT_ID_TRACE_ENABLE procedure, 89
CLOB_TABLE Table Type, 133
CLOB2FILE procedure, 177
CLONE_SIMPLE_TABLESPACE procedure, 146
CLONE_TABLESPACES procedure, 146
CLONENODE function, 167
CLOSE Procedure, 79
CLOSE_ALL_CONNECTIONS procedure, 234
CLOSE_CONNECTION Procedure, 232
CLOSE_CONNECTION procedure, 234
CLOSE_CURSOR Procedure, 72
CLOSE_CURSOR procedure, 133
CLOSE_DATA Function and Procedure, 232
CLOSE_DATABASE_LINK Procedure, 128
CLOSE_ITERATOR procedure, 123
CLOSE_PERSISTENT_CONN procedure, 221
CLOSE_PERSISTENT_CONNS procedure, 221
CLOSECONTEXT procedure, 168, 171, 172, 174
COAD_ADVICE_REC type, 40
COAD_ADVICE_T type, 40
CODE function
of HTF package, 179
CODE procedure
of HTP package, 180
COLLECT_STATS procedure, 233
collections
table items, 133
column masking for VPD, 121
COLUMN_VALUE procedure, 133
COLUMN_VALUE_LONG procedure, 133
column-level VPD, 121
COMMA_TO_TABLE procedures, 153
COMMAND function and procedure, 232
COMMAND_REPLIES function, 232
COMMENT function
of HTF package, 179
COMMENT procedure
of HTP package, 180
COMMIT procedure, 149
COMMIT_COMMENT procedure, 149
COMMIT_FORCE procedure, 149
COMPARE Function, 33
COMPARE function, 229
COMPARE Functions, 79
COMPARE_OLD_VALUES procedure, 20
COMPARE_PERIOD_REPORT Procedure, 157
COMPARISON_TYPE type, 33
COMPATIBLE_10_1 function, 140, 245
COMPATIBLE_10_2 function, 140, 245
COMPATIBLE_11_1 function, 140
COMPATIBLE_11_2 function, 140
COMPATIBLE_9_2 function, 140, 245
COMPILE_FROM_REMOTE procedure, 78
COMPILE_SCHEMA procedure, 153
COMPILESCHEMA procedure, 173
COMPUTE_CONFUSION_MATRIX procedure, 42
COMPUTE_LIFT procedure, 42
COMPUTE_ROC procedure, 42
CONCAT function, 229
CONDITION_REF function, 120
CONFIGURE Procedure, 132
CONFIGURE_POOL Procedure, 35
CONFIGUREAUTOSYNC procedure, 164
conflicts
detection
stopping, 20
CONNECTION record type, 232
constants
DBMS_MGWMSG package, 88
CONSUME_EVENT procedure, 120
CONSUME_PRIM_EVENT procedure, 120
CONTAINS_HOST Function, 92
CONTINUE function, 51
CONVERGE Procedure, 33
CONVERT function, 80, 168, 229
CONVERT_ANYDATA_TO_LCR_DDL function, 140
CONVERT_ANYDATA_TO_LCR_ROW function, 140
CONVERT_LCR_TO_XML function, 140
CONVERT_LONG_TO_LOB_CHUNK member procedure, 245
CONVERT_RAW_VALUE procedures, 138
CONVERT_RAW_VALUE_NVARCHAR procedure, 138
CONVERT_RAW_VALUE_ROWID procedure, 138
CONVERT_XML_TO_LCR function, 140
CONVERTTOBLOB procedure, 79
CONVERTTOCLOB Procedure, 79
COPIES function, 229
COPY Procedures, 79
COPY_ATTRIBUTE_SET procedure, 62
COPY_DBFS_LINK Procedures, 79
COPY_FILE procedure, 65
COPY_FROM_DBFS_LINK, 79
COPY_TABLE_DEPENDENTS procedure, 107
COPY_TABLE_STATS Procedure, 138
COPYDEFAULTTOKENTABLESET Procedure, 38
COPYEVOLVE procedure, 173
CQ_NOTIFICATION$_DESCRIPTOR Object Type, 36
CQ_NOTIFICATION$_QUERY Object Type, 36
CQ_NOTIFICATION$_QUERY_ARRAY Object (Array) Type, 36
CQ_NOTIFICATION$_REG_INFO Object Type, 36
CQ_NOTIFICATION$_ROW Object Type, 36
CQ_NOTIFICATION$_TABLE Object Type, 36
CQ_NOTIFICATION$_TABLE_ARRAY Object (Array) Type, 36
CQ_NOTIFICATION_QUERYID Function, 36
CREATE PACKAGE BODY command, 1
CREATE PACKAGE command, 1
CREATE_ACL Procedure, 91
CREATE_AFFECTED_TABLE Procedure, 58
CREATE_AGENT Procedure, 87
CREATE_ALTER_TYPE_ERROR_TABLE procedure, 153
CREATE_ANALYSIS_TASK Functions, 135
CREATE_APPLY procedure, 20
CREATE_ATTRIBUTE_SET procedure, 62
CREATE_BASELINE Function & Procedure, 158
CREATE_BASELINE_TEMPLATE Procedures, 158
CREATE_BIN_CAT procedure, 47
CREATE_BIN_NUM procedure, 47
CREATE_CAPTURE procedure
capture process
creating, 30
CREATE_CATEGORY function, 86
CREATE_CATEGORY Procedure, 116
CREATE_CHUNKS_BY_NUMBER_COL Procedure, 98
CREATE_CHUNKS_BY_ROWID Procedure, 98
CREATE_CHUNKS_BY_SQL Procedure, 98
CREATE_CLIP procedure, 47
CREATE_COL_REM procedure, 47
CREATE_COMPARISON Procedure, 33
CREATE_CONDITIONS_TABLE procedure, 120
CREATE_CONSUMER_GROUP procedure, 116
CREATE_DAD Procedure, 60
CREATE_DIAGNOSIS_TASK Functions, 134
CREATE_ERROR_LOG Procedure, 61
CREATE_ERROR_TABLE Procedure, 58
CREATE_EVALUATION_CONTEXT procedure, 124
CREATE_EVENT_STRUCT procedure, 120
CREATE_EXPFIL_INDEXES procedure, 120
CREATE_EXTENDED_STATS Function, 138
CREATE_FILE Procedure, 17
CREATE_FILE_GROUP procedure, 64
CREATE_FILTER_SET Procedure, 157
CREATE_INDEX_COST procedure, 130
CREATE_INTERFACE procedure, 120
CREATE_JOB Procedure, 87
CREATE_MISS_CAT procedure, 47
CREATE_MISS_NUM procedure, 47
CREATE_MODEL procedure, 42
CREATE_MSGSYSTEM_LINK Procedure for TIB/Rendezvous, 87
CREATE_MSGSYSTEM_LINK Procedure for WebSphere MQ, 87
CREATE_MVIEW function, 39, 39
CREATE_NORM_LIN procedure, 47
CREATE_OBJECT Procedure, 17
CREATE_OBJECT_DEPENDENCY procedure, 20
CREATE_OR_REPLACE_VIEW procedure
of DBMS_HS_PARALLEL package, 71
CREATE_OUTLINE procedure, 96
CREATE_PENDING_AREA procedure, 116
CREATE_PIPE function, 100
CREATE_PLAN procedure, 116
CREATE_PLAN_DIRECTIVE procedure, 116
CREATE_PROPAGATION procedure, 104
CREATE_PURGE_JOB procedure, 26
CREATE_REQUEST_CONTEXT Function, 221
CREATE_RULE procedure, 124
CREATE_RULE_CLASS procedure, 120
CREATE_RULE_SET procedure, 124
CREATE_SERVICE procedure, 127
CREATE_SIMPLE_PLAN procedure, 116
CREATE_SNAPSHOT function and procedure, 158
CREATE_SQL_PLAN_BASELINE Procedure, 136
CREATE_SQLSET procedure, 136
CREATE_SQLWKLD Procedure, 17
CREATE_STAT_TABLE procedure, 138
CREATE_STGTAB_BASELINE Procedure, 132
CREATE_STGTAB_SQLPATCH Procedure, 134
CREATE_STGTAB_SQLPROF Procedure, 136
CREATE_STGTAB_SQSET Procedure, 136
CREATE_STMT_HANDLER procedure, 144
CREATE_SYNC_CAPTURE procedure
synchronous capture
creating, 30
CREATE_TABLE_COST procedures, 130
CREATE_TABLE_COST_COLINFO Object Type, 130
CREATE_TABLE_TEMPLAGE procedure
of DBMS_HS_PARALLEL package, 71
CREATE_TASK Procedure, 98
CREATE_TASK Procedures, 17
CREATE_TRANSFORMATION procedure, 150
CREATE_TRIGGER_TABLE Procedure, 58
CREATE_TUNING_TASK functions, 136
CREATE_VERSION procedure, 64
CREATE_WRAPPED Procedure, 50
CREATEATTRIBUTE function, 167
CREATEBUCKET Procedure, 45
CREATECDATASECTION function, 167
CREATECOMMENT function, 167
CREATEDATASTOREPREF procedure, 164
CREATEDATEINDEX Procedure, 169
CREATEDIRECTORY Procedures, 43, 44
CREATEDOCUMENT function, 167
CREATEDOCUMENTFRAGMENT function, 167
CREATEELEMENT function, 167
CREATEENTITYREFERENCE function, 167
CREATEFILE Procedures, 43, 44
CREATEFILESYSTEM Procedure, 46
CREATEFILTERPREF procedure, 164
CREATEFOLDER function, 160
CREATEINDEX procedure, 164
CREATELEXERPREF procedure, 164
CREATELINK Procedures, 43, 44
CREATENONSCHEMABASEDXML function, 256
CREATENUMBERINDEX Procedure, 169
CREATEOIDPATH function, 160
CREATEPREFERENCES procedure, 164
CREATEPROCESSINGINSTRUCTION function, 167
CREATEREFERENCE Procedures, 43, 44
CREATEREPOSITORYXMLINDEX Procedure, 161
CREATERESOURCE function, 160
CREATESCHEMABASEDXML function, 256
CREATESECTIONGROUPPREF procedure, 164
CREATESTOPLISTPREF procedure, 164
CREATESTORAGEPREF procedure, 164
CREATESTORE Procedure, 45, 46
CREATETEMPORARY Procedures, 79
CREATETEXTNODE function, 167
CREATEURI function, 242, 242, 242
CREATEWORLDLISTPREF procedure, 164
CREATEXML function, 256
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 aggregation, 39
Cube Build log, 41
Cube Dimension Compile log, 41
cube log verbosity levels, 41
cube logging targets, 41
cube logging types, 41
cube maintenance, 39
cube materialized views, 39
optimizing, 40
Cube Operations log, 41
cube refresh, 39
Cube Rejected Records Log, 41
CUBE_BUILD_LATEST view, 39
CUBE_BUILD_REPORT view, 39
CUBE_BUILD_REPORT_LATEST view, 39
CUBE_UPGRADE_INFO table, 39
cubes
optimizer statistics, 29
CURRENT_INSTANCE function, 153
cursors
DBMS_SQL package, 133

D

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

E

EDIT_DISTANCE Function, 227
EDIT_DISTANCE_SIMILARITY Function, 227
EHLO function and procedure, 232
EM function
of HTF package, 179
EM procedure
of HTP package, 180
e-mail from PL/SQL (email), 234
EMPHASIS function
of HTF package, 179
EMPHASIS procedure
of HTP package, 180
ENABLE procedure, 41, 97
ENABLE Procedures, 27
ENABLE_AT_SYSTEM_CHANGE_NUMBER procedure, 66
ENABLE_AT_TIME procedure, 66
ENABLE_BREAKPOINT function, 51
ENABLE_HIERARCHY procedure, 165
ENABLE_JOB Procedure, 87
ENABLE_PROPAGATION_SCHEDULE Procedure, 87
ENABLETRANSLATION Procedure, 175
END_PREPARE Procedure, 58
END_REQUEST procedure, 221
END_RESPONSE procedure, 221
END_UPGRADE Procedure, 58
ENDCREATE member procedure
of ANYDATA TYPE, 237
of ANYDATASET TYPE, 238
of ANYTYPE TYPE, 239
ENQUEUE procedure, 145
ENQUEUE_ARRAY Function, 21
ENQUEUE_OPTIONS_T Type, 240
ENQUOTE_LITERAL Function, 25
ENQUOTE_NAME Function, 25
EPC_TO_ORACLE_SCHEME function, 86
EQUALS_HOST Function, 92
ERASE Procedures, 79
error queue
deleting errors, 20, 20
executing errors, 20, 20
getting error messages, 20
ESCAPE function, 235
ESCAPE_SC function
of HTF package, 179
ESCAPE_SC procedure
of HTP package, 180
ESCAPE_URL function
of HTF package, 179
ESCAPEURI function, 242
ESTIMATE_CPU_UNITS function, 94
ESTIMATE_MVIEW_SIZE Procedure, 90
ETINSTANCE member function
of ANYDATASET TYPE, 238
EVALUATE procedure, 123
EVOLVE_SQL_PLAN_BASELINE Function, 132
EXACT_TEXT_SIGNATURES procedure, 96
EXEC_DDL_STATEMENT procedure, 153
EXECUTE function, 133
EXECUTE member procedure, 245, 245
EXECUTE procedure, 51
EXECUTE_ALL_ERRORS procedure, 20
EXECUTE_ANALYSIS_TASK, 135
EXECUTE_AND_FETCH function, 133
EXECUTE_DIAGNOSIS_TASK Procedure, 134
EXECUTE_ERROR procedure, 20
EXECUTE_IMMEDIATE Procedure, 72
EXECUTE_NON_QUERY Function, 72
EXECUTE_TASK Procedure, 17
EXECUTE_TUNING_TASK Function & Procedure, 136
execution flow
in dynamic SQL, 133
EXF$ATTRIBUTE object type, 243
EXF$ATTRIBUTE_LIST object type, 243
EXF$INDEXOPER object type, 243
EXF$TABLE_ALIAS object type, 243
EXF$TEXT object type, 243
EXF$XPATH_TAG object type, 243
EXF$XPATH_TAGS object type, 243
EXISTSNODE function, 256
EXISTSRESOURCE function, 160
EXPAND_MESSAGE function, 126
EXPLAIN_SQL_TESTCASE Function, 134
EXPONENTIAL_DIST_FIT procedure, 137
EXPORT_AWR Procedure, 156, 157
EXPORT_COLUMN_STATS procedure, 138
EXPORT_DATABASE_PREFS Procedure, 138
EXPORT_DATABASE_STATS procedure, 138
EXPORT_DICTIONARY_STATS procedure, 138
EXPORT_FIXED_OBJECTS_STATS procedure, 138
EXPORT_INDEX_STATS procedure, 138
EXPORT_MODEL procedure, 42
EXPORT_PENDING_STATS Procedure, 138
EXPORT_SCHEMA_PREFS Procedure, 138
EXPORT_SCHEMA_STATS procedure, 138
EXPORT_SQL_TESTCASE Procedures, 134
EXPORT_SQL_TESTCASE_DIR_BY_INC Procedure, 134
EXPORT_SQL_TESTCASE_DIR_BY_TXT Function, 134
EXPORT_SYSTEM_STATS procedure, 138
EXPORT_TABLE_PREFS Procedure, 138
EXPORT_TABLE_STATS procedure, 138
EXPORT_XML procedure, 39, 39
EXPORT_XML_TO_FILE procedure, 39, 39
Expression Filter object types, 243
extend window
to create a new view, 32
EXTEND_EVENT_STRUCT procedure, 120
EXTRACT function, 256
EXTRACTXLIFF Function & Procedure, 175

F

FCLOSE procedure, 220
FCLOSE_ALL procedure, 220
FCOPY procedure, 220
FEATURE_T Record Type, 43
FEATURENAME Function, 43
FEATURES_T Table Type, 43
FETCH_ROW Function, 72
FETCH_ROWS function, 133
FFLUSH procedure, 220
FGETATTR procedure, 220
FGETPOS function, 220
FI_HORIZONTAL function, 68
FI_TRANSACTIONAL function, 68
file groups, 64
adding files, 64
altering, 64
altering files, 64
altering versions, 64
creating, 64
creating versions, 64
dropping, 64
dropping versions, 64
granting object privileges, 64
granting system privileges, 64
purging, 64
removing files, 64
revoking object privileges, 64
revoking system privileges, 64
FILE type, 146
FILE_SET type, 146
FILECLOSE Procedure, 79
FILECLOSEALL Procedure, 79
FILEEXISTS Function, 79
FILEGETNAME Procedure, 79
FILEISOPEN Function, 79
FILEOPEN Procedure, 79
FILETYPE Record Type, 220
FIND_AFFECTED_TABLE Procedure, 58
FINDENTITY function, 167
FINDNOTATION function, 167
fine-grained access control
DBMS_RLS package, 121
FINISH_CAPTURE Procedure, 156
FINISH_REDEF_TABLE procedure, 107
FIX_CORRUPT_BLOCKS procedure, 109
FLUSH Function & Procedure, 118
FLUSH procedure, 41, 234
FLUSH_DATA function and procedure, 103
FLUSH_DATABASE_MONITORING_INFO procedure, 138
FLUSHCACHE Procedure, 45
FONTCLOSE function
of HTF package, 179
FONTCLOSE procedure
of HTP package, 180
FONTOPEN function
of HTF package, 179
FONTOPEN procedure
of HTP package, 180
FOPEN function, 220
FOPEN_NCHAR function, 220
FORCE parameter
and job-to-instance affinity, 75
FORMAT function, 252
FORMAT_CALL_STACK Function, 153
FORMAT_CELL function
of HTF package, 179
FORMAT_ERROR_BACKTRACE function, 153
FORMAT_ERROR_STACK function, 153
FORMCHECKBOX function
of HTF package, 179
FORMCHECKBOX procedure
of HTP package, 180
FORMCLOSE function
of HTF package, 179, 179
FORMCLOSE procedure
of HTP package, 180
FORMFILE function
of HTF package, 179
FORMFILE procedure
of HTP package, 180, 180
FORMHIDDEN function
of HTF package, 179
FORMHIDDEN procedure
of HTP package, 180
FORMIMAGE function
of HTF package, 179
FORMIMAGE procedure
of HTP package, 180
FORMOPEN function
of HTF package, 179
FORMOPEN procedure
of HTP package, 180
FORMPASSWORD function
of HTF package, 179
FORMPASSWORD procedure
of HTP package, 180
FORMRADIO function
of HTF package, 179
FORMRADIO procedure
of HTP package, 180
FORMRESET function
of HTF package, 179
FORMRESET procedure
of HTP package, 180
FORMSELECTCLOSE function
of HTF package, 179
FORMSELECTCLOSE procedure
of HTP package, 180
FORMSELECTOPEN function
of HTF package, 179
FORMSELECTOPEN procedure
of HTP package, 180
FORMSELECTOPTION function
of HTF package, 179
FORMSELECTOPTION procedure
of HTP package, 180
FORMSUBMIT function
of HTF package, 179
FORMSUBMIT procedure
of HTP package, 180
FORMTEXT function
of HTF package, 179
FORMTEXT procedure
of HTP package, 180
FORMTEXTAREA function
of HTF package, 179
FORMTEXTAREA procedure
of HTP package, 180
FORMTEXTAREA2 function
of HTF package, 179
FORMTEXTAREA2 procedure
of HTP package, 180
FORMTEXTAREACLOSE function
of HTF package, 179
FORMTEXTAREACLOSE procedure
of HTP package, 180
FORMTEXTAREAOPEN function
of HTF package, 179
FORMTEXTAREAOPEN procedure
of HTP package, 180
FORMTEXTAREAOPEN2 function
of HTF package, 179
FORMTEXTAREAOPEN2 procedure
of HTP package, 180
FRAGMENT_DELETE Procedure, 79
FRAGMENT_INSERT Function, 79
FRAGMENT_MOVE Procedure, 79
FRAGMENT_REPLACE Procedure, 79
FRAME function
of HTF package, 179
FRAME procedure
of HTP package, 180
FRAMESETCLOSE function
of HTF package, 179
FRAMESETCLOSE procedure
of HTP package, 180
FRAMESETOPEN function
of HTF package, 179
FRAMESETOPEN procedure
of HTP package, 180
FREE_BLOCKS procedure, 130
FREE_UNUSED_USER_MEMORY Procedure, 128
FREEDOCFRAG procedure, 167
FREEDOCUMENT procedure, 167
FREENODE procedure, 167, 167
FREEPARSER procedure, 170
FREEPROCESSOR procedure, 177
FREERESOURCE Procedure, 163
FREESTYLESHEET procedure, 177
FREETEMPORARY Procedures, 79
FREMOVE procedure, 220, 220
FRENAME procedure, 220
FSEEK procedure, 220
functions
adding to attribute sets, 62, 120

G

GATHER_DATABASE_STATS procedures, 138
GATHER_DICTIONARY_STATS procedure, 138
GATHER_FIXED_OBJECTS_STATS procedure, 138
GATHER_INDEX_STATS Procedure, 138
GATHER_OPTIMIZER_STATS Procedure, 28
GATHER_SCHEMA_STATS procedures, 138
GATHER_SYSTEM_STATS procedure, 138
GATHER_TABLE_STATS procedure, 138
GENERATE_STATS procedure, 138
GENERATE_TASK_NAME Function, 98
GENERATESCHEMAS function, 173
GET function
of OWA_COOKIE package, 184
GET* member functions
of ANYDATA TYPE, 237
of ANYDATASET TYPE, 238
GET_ACLOID function, 165
GET_AGGREGATE_VALUE function, 120
GET_ALL procedure, 184
GET_ALL_DAD_ATTRIBUTES Procedure, 60
GET_ALL_DAD_MAPPINGS Procedure, 60
GET_ALL_GLOBAL_ATTRIBUTES Procedure, 60
GET_ALL_NAMES member function, 253
GET_ASH_QUERY Function, 15
GET_ASSOCIATION_RULES function, 42
GET_AUDIT_COMMIT_DELAY function, 26
GET_AUTHENTICATION procedure, 221
GET_BASE_TABLE_NAME member function, 245
GET_BASE_TABLE_OWNER member function, 245
GET_BODY_CHARSET procedure, 221
GET_CAPTURE_INFO Procedure, 156
GET_CATEGORY function, 154
GET_CATEGORY_ID function, 86
GET_CGI_ENV function, 191
GET_CLIENT_ATTRIBUTES Procedure, 27
GET_CLIENT_HOSTNAME function, 189
GET_CLIENT_IP function, 189
GET_COLUMN_STATS procedures, 138
GET_COMMAND_TYPE member function, 245
GET_COMMIT_SCN member function, 245
GET_COMMIT_TIME member function, 245
GET_COMMON_TIME_ZONES Function, 222
GET_COMPATIBLE member function, 245
GET_COMPONENT function, 252
GET_COMPONENTS function, 86
GET_COMPRESSION_RATIO Procedure, 34
GET_COMPRESSION_TYPE Function, 34
GET_COOKIE_COUNT function, 221
GET_COOKIE_SUPPORT procedure, 221
GET_COOKIES function, 221
GET_CPU_TIME function, 153
GET_CURRENT_SCHEMA member function, 245
GET_DAD_ATTRIBUTE Procedure, 60
GET_DAD_LIST Procedure, 60
GET_DBFS_LINK Functions, 79
GET_DBFS_LINK_STATE Procedure, 79
GET_DEFAULT_ISO_CURRENCY Function, 222
GET_DEFAULT_LINGUISTIC_SORT Function, 222
GET_DEFAULT_SETTINGS function, 42
GET_DEPENDENCY procedure, 153
GET_DETAILED_EXCP_SUPPORT procedure, 221
GET_DETAILED_SQLCODE function, 221
GET_DETAILED_SQLERRM function, 221
GET_DIVERGING_STATEMENT Function, 157
GET_EDITION_NAME member function, 245
GET_ENCODINGS function, 86
GET_ENDIANNESS Function, 153
GET_ERROR_MESSAGE function, 20
GET_ETAG function, 183
GET_EXPRESSION function, 47
GET_EXPRSET_STATS procedure, 62
GET_EXTRA_ATTRIBUTE member function, 245
GET_FILE procedure, 65
GET_FIX_CONTROL Function, 134
GET_FOLLOW_REDIRECT procedure, 221
GET_FREQUENT_ITEMSETS function, 42
GET_GLOBAL_ATTRIBUTE Function, 60
GET_HASH_VALUE function, 153
GET_HEADER procedure, 221
GET_HEADER_BY_NAME procedure, 221
GET_HEADER_COUNT function, 221
GET_HOST_ADDRESS function, 224
GET_HOST_NAME function, 224
GET_INDEX_STATS procedures, 138
GET_INDEXES function, 51
GET_INFORMATION function, 140
GET_JAVA_LOGGING_LEVEL function, 86
GET_LEVEL function, 183
GET_LINE function, 234
GET_LINE procedure, 97, 220
GET_LINE_MAP function, 51
GET_LINE_NCHAR Function, 234
GET_LINE_NCHAR procedure, 220
GET_LINES procedure, 97
GET_LOB_INFORMATION member function, 245
GET_LOB_OFFSET member function, 245
GET_LOB_OPERATION_SIZE member procedure, 245
GET_LOCAL_LINGUISTIC_SORTS Function, 222
GET_LOG procedure, 41
GET_LOG_SPEC function, 41
GET_LOGON_USER member function, 245
GET_LONG_INFORMATION member function, 245
GET_MESSAGE_TRACKING function, 141
GET_MODEL_COST_MATRIX function, 42
GET_MODEL_DETAILS_ABN function, 42
GET_MODEL_DETAILS_AI function, 42
GET_MODEL_DETAILS_GLM function, 42
GET_MODEL_DETAILS_GLOBAL function, 42
GET_MODEL_DETAILS_KM function, 42
GET_MODEL_DETAILS_NB function, 42
GET_MODEL_DETAILS_NMF function, 42
GET_MODEL_DETAILS_OC function, 42
GET_MODEL_DETAILS_SVM function, 42
GET_MODEL_DETAILS_XML function, 42
GET_MODEL_SETTINGS function, 42
GET_MODEL_SIGNATURE function, 42
GET_MODEL_TRANSFORMATIONS function, 42
GET_MORE_SOURCE procedure, 51
GET_NEXT_HIT function, 123
GET_NUMBER_COL_CHUNK Procedure, 98
GET_OBJECT_NAME member function, 245
GET_OBJECT_OWNER member function, 245
GET_OBJECT_TYPE member function, 245
GET_OWA_SERVICE_PATH function, 191
GET_P1_RESOURCES Procedure, 27
GET_PACKAGE_MEMORY_UTILIZATION Procedure, 128
GET_PARAM function, 138
GET_PARAMETER function, 41
GET_PARAMETER_VALUE function, 153
GET_PASSWORD function, 189
GET_PERSISTENT_CONN_COUNT function, 221
GET_PERSISTENT_CONN_SUPPORT procedure, 221
GET_PERSISTENT_CONNS procedure, 221
GET_PLSQL_LOGGING_LEVEL function, 86
GET_PLSQL_TRACE_LEVEL function, 148
GET_POST_PROCESSED_SOURCE Procedure, 102
GET_PREFS Function, 138
GET_PROCEDURE function, 191
GET_PROXY procedure, 221
GET_RAW function, 220, 234
GET_REC_ATTRIBUTES Procedure, 17
GET_REPORT Function, 15
GET_RESPONSE function, 221
GET_RESPONSE_ERROR_CHECK procedure, 221
GET_ROW_TEXT member procedure, 245
GET_ROWID function, 187
GET_ROWID_CHUNK Procedure, 98
GET_RUN_REPORT Function, 69
GET_RUNTIME_INFO function, 51
GET_SCHEME_NAMES function, 86
GET_SCN member function, 245
GET_SCN_MAPPING procedure, 141
GET_SESSION_TIMEOUT function, 119
GET_SOURCE_DATABASE_NAME member function, 245
GET_SOURCE_TIME member function, 245
GET_SQL Function, 134
GET_SQL_HASH Function, 153
GET_STATS_HISTORY_AVAILABILITY function, 138
GET_STATS_HISTORY_RETENTION function, 138
GET_STREAMS_NAME function, 140
GET_STREAMS_TYPE function, 140
GET_SYSTEM_STATS procedure, 138
GET_TABLE_STATS procedure, 138
GET_TAG function, 140, 141
GET_TAG member function, 245
GET_TASK_REPORT Procedure, 17
GET_TASK_SCRIPT Procedure, 17
GET_TDT_XML function, 86
GET_TEXT function, 234
GET_TEXT_NCHAR Function, 234
GET_THREAD_NUMBER member function, 245
GET_THRESHOLD procedure, 126
GET_TIME function, 153
GET_TIMEOUT function, 119
GET_TIMEOUT_BEHAVIOUR function, 51
GET_TRANSACTION_ID member function, 245
GET_TRANSFER_TIMEOUT procedure, 221
GET_TRANSFORM_LIST procedure, 42
GET_USER_ID function, 189
GET_USERID function, 165
GET_VALIDATOR function, 86
GET_VALUE function, 51
GET_VALUE member function, 245, 253
GET_VALUE Procedure, 72
GET_VALUE_RAW Procedure, 72
GET_VALUES member function, 245
GET_VERSION procedure, 103
GET_WARNING_SETTING_CAT function, 154
GET_WARNING_SETTING_NUM function, 154
GET_WARNING_SETTING_STRING function, 154
GET_WHERE_CLAUSE member procedure, 245
GET_X function, 186
GET_XML_INFORMATION member function, 245
GET_Y function, 186
GETACL Function, 163
GETACLDOCFROMRES Function, 163
GETACLDOCUMENT function, 160
GETAPPLICATIONDATA Function, 166
GETATTRELEMINFO member function
of ANYTYPE TYPE, 239
GETATTRIBUTE function, 167
GETATTRIBUTENODE function, 167
GETATTRIBUTES function, 167
GETAUTHOR Function, 163
GETBASEDOCUMENT Function, 175
GETBLOB function, 242, 242, 242, 242
GETBLOBVAL function, 256
GETBUBLICID function, 167
GETCHARACTERSET Function, 163
GETCHILDNODES function, 167
GETCHILDOID Function, 166
GETCHILDRENBYTAGNAME function, 167
GETCHILDRESPATHS Function, 160
GETCHUNKSIZE Functions, 79
GETCLOB function, 242, 242, 242, 242
GETCLOBVAL function, 256
GETCOMMENT Function, 163
GETCONTENTBLOB Function, 160, 163
GETCONTENTCLOB Function, 160, 163
GETCONTENTREF Function, 163
GETCONTENTSBLOBBYRESID function, 162
GETCONTENTSCLOBBYRESID function, 162, 162
GETCONTENTSXMLBYRESID function, 162
GETCONTENTTYPE Function, 163
GETCONTENTTYPE function, 242, 242, 242, 242
GETCONTENTTYPE Functions, 79
GETCONTENTVARCHAR2 Function, 160, 163
GETCONTENTXML Function, 163
GETCONTENTXMLREF Function, 160
GETCONTENTXMLTYPE Function, 160
GETCOUNT member function
of ANYDATASET TYPE, 238
GETCREATIONDATE Function, 163
GETCREATOR Function, 163
GETCURRENTUSER Function, 166
GETCUSTOMMETADATA Function, 163
GETDATA function, 167
GETDCHARSET function, 167
GETDEFAULTACL Procedure, 43
GETDEFAULTASOF Procedure, 43
GETDEFAULTOWNER Procedure, 43
GETDEFAULTPRINCIPAL Procedure, 43
GETDISPLAYNAME Function, 163
GETDOCTYPE function, 167, 170
GETDOCUMENT function, 170
GETDOCUMENTELEMENT function, 167
GETDTD function, 171
GETDTD procedure, 171
GETELEMENTSBYTAGNAME function, 167, 167
GETENTITIES function, 167
GETEVENT Function, 166
GETEXCEPTIONCONTENT procedure, 171, 172
GETEXPANDEDNAME function, 167, 167
GETEXPANDEDNAME procedure, 167
GETEXTERNALURL function, 242, 242, 242, 242
GETFEATURES Function, 44
GETFEATURESBYMOUNT Function, 43
GETFEATURESBYNAME Function, 43
GETFEATURESBYPATH Function, 43
GETFIRST Function, 166
GETFIRSTCHILD function, 167
GETFTPPORT Function, 160
GETHANDLERLIST Function, 166
GETHTTPPORT Function, 160
GETIMPLEMENTATION function, 167
GETINFO member function
of ANYTYPE TYPE, 239
GETINTERFACE Function, 166
GETLANGUAGE Function, 163, 166, 166
GETLASTCHILD function, 167
GETLASTMODIFIER Function, 163
GETLENGTH function, 167, 167, 167
GETLENGTH Functions, 79
GETLINK Function, 166
GETLINKNAME Function, 166
GETLISTENERENDPOINT Procedure, 160
GETLISTENERS Function, 115
GETLOCK Function, 166
GETLOCKTOKEN procedure, 160
GETMODIFICATIONDATE Function, 163
GETNAME Function, 166
GETNAME function, 167, 167
GETNAMEDITEM function, 167
GETNAMESPACE function, 167, 167
GETNAMESPACE procedure, 167
GETNEXTSIBLING function, 167
GETNODENAME function, 167
GETNODETYPE function, 167
GETNODEVALUE function, 167
GETNODEVALUEASBINARYSTREAM Function & Procedure, 167
GETNODEVALUEASCHARACTERSTREAM Function & Procedure, 167
GETNOTATIONNAME function, 167
GETNOTATIONS function, 167
GETNUMBERVAL function, 256
GETNUMROWSPROCESSED function, 168
GETNUMROWSPROCESSED procedure, 171
GETOLDRESOURCE Function, 166
GETOPENACCESSMODE Function, 166
GETOPENDENYMODE Function, 166
GETOPTIONS Functions, 79
GETOUTPUTSTREAM Function, 166
GETOWNER Function, 163
GETOWNERDOCUMENT function, 167
GETOWNERELEMENT function, 167
GETPARAMETER Function, 166
GETPARENT Function, 166
GETPARENTNAME Function, 166
GETPARENTNODE function, 167
GETPARENTOID Function, 166
GETPARENTPATH Function, 166
GETPAT procedure, 188
GETPATH Function, 166
GETPATH Procedures, 43, 44
GETPATHBYMOUNTID Function, 43
GETPATHBYREPOSID Function, 44
GETPATHBYSTOREID Function, 43
GETPATHNOWAIT Procedure, 44
GETPATHNOWAIT Procedures, 43
GETPERSISTENT static function
of ANYTYPE TYPE, 239
GETPREDECESSORS function, 162
GETPREDSBYRESID function, 162
GETPREFIX function, 167
GETPREVIOUSSIBLING function, 167
GETPRIVILEGES function, 160
GETPUBLICID function, 167, 167
GETQUALIFIEDNAME function, 167, 167
GETREFCOUNT Function, 163
GETRELEASEVERSION function, 170
GETREPOSITORYRESCONFIG Function, 115
GETREPOSITORYRESCONFIGPATHS Function, 115
GETRESCONFIG Function, 115
GETRESCONFIGPATHS Function, 115
GETRESOID function, 160
GETRESOURCE Function, 166
GETRESOURCEBYRESID function, 162
GETROOTELEMENT function, 256
GETRUL function, 242
GETSCHEMA Function, 166
GETSCHEMANODE function, 167
GETSCHEMAURL function, 256
GETSOURCE Function, 166
GETSPECIFIED function, 167
GETSTANDALONE function, 167
GETSTATS Procedure, 43
GETSTOREBYMOUNT Function, 43
GETSTOREBYNAME Function, 43
GETSTOREBYPATH Function, 43
GETSTOREID Function, 44
GETSTOREPROPERTY Function, 45
GETSTRINGVAL function, 256
GETSUCCESSORS function, 162
GETSUCCSBYRESID function, 162
GETSYSTEMID function, 167, 167, 167
GETTAGNAME function, 167
GETTARGET function, 167
GETTDEFAULTCONTEXT Procedure, 43
GETTOKENTABLEINFO Procedure & Function, 38
GETTOKENTABLEINFOBYTABLESPACE Procedure, 38
GETTRACE Function, 43
GETTYPE member function
of ANYDATA TYPE, 237
of ANYDATASET TYPE, 238
GETTYPENAME member function
of ANYDATA TYPE, 237
of ANYDATASET TYPE, 238
GETUPDATEBYTECOUNT Function, 166
GETUPDATEBYTEOFFSET Function, 166
GETURL function, 242, 242, 242, 242
GETVALIDATIONMODE function, 170
GETVALUE function, 167
GETVERSION Function, 43, 44
GETVERSION function, 167
GETVERSION procedure, 171
GETVERSIONID Function, 163
GETXDB_TABLESPACE function, 160
GETXDBEVENT Function, 166
GETXML function, 168, 171, 242, 242, 242, 242
GETXML procedure, 171
GETXMLTYPE function, 167, 168
GRANT_ADMIN_PRIVILEGE procedure, 143
GRANT_OBJECT_PRIVILEGE procedure, 124
GRANT_PRIVILEGE procedure, 62, 120
GRANT_REMOTE_ADMIN_ACCESS procedure, 143
GRANT_SWITCH_CONSUMER_GROUP procedure, 117
GRANT_SYSTEM_PRIVILEGE procedure, 64, 117, 124
GRANTING_OBJECT_PRIVILEGE procedure, 64

H

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

I

IMG function
of HTF package, 179
IMG procedure
of HTP package, 180
IMG2 procedure
of HTP package, 180
IMPLEMENT_TASK Procedure, 17
IMPLEMENT_TUNING_TASK Function, 136
IMPORT_AWR Function, 157
IMPORT_AWR Procedure, 156
IMPORT_COLUMN_STATS procedure, 138
IMPORT_DATABASE_PREFS Procedure, 138
IMPORT_DATABASE_STATS procedure, 138
IMPORT_DICTIONARY_STATS procedure, 138
IMPORT_FIXED_OBJECTS_STATS procedure, 138
IMPORT_INDEX_STATS procedure, 138
IMPORT_MODEL procedure, 42
IMPORT_SCHEMA_PREFS Procedure, 138
IMPORT_SCHEMA_STATS procedure, 138
IMPORT_SQL_TESTCASE Procedures, 134
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, 138
IMPORT_TABLE_PREFS Procedure, 138
IMPORT_TABLE_STATS procedure, 138
IMPORT_XML procedure, 39, 39
IMPORTNODE function, 167
INCIDENTID_2_SQL Procedure, 134
INCLUDE_EXTRA_ATTRIBUTES procedure, 30
INDEX_PARAMETERS procedure, 62
INDEX_TABLE_TYPE Table Type, 153
in-flight transactions, 30
INIT_CLEANUP procedure, 26
INITFS Procedure, 46
INITIALIZE function, 51
INITIALIZE procedure, 105
INITIALIZE_CUBE_UPGRADE procedure, 39, 39
INITIALIZE_REPLAY Procedure, 157
INPLACEEVOLVE Procedure, 173
INSERT_AUTOBIN_NUM_EQWIDTH procedure, 47
INSERT_BIN_CAT_FREQ procedure, 47
INSERT_BIN_NUM_EQWIDTH procedure, 47
INSERT_BIN_NUM_QTILE procedure, 47
INSERT_BIN_SUPER procedure, 47
INSERT_CLIP_TRIM_TAIL procedure, 47
INSERT_CLIP_WINSOR_TAIL procedure, 47
INSERT_FINDING_DIRECTIVE Procedure, 15
INSERT_MISS_CAT_MODE procedure, 47
INSERT_MISS_NUM_MEAN procedure, 47
INSERT_NORM_LIN_MINMAX procedure, 47
INSERT_NORM_LIN_SCALE procedure, 47
INSERT_NORM_LIN_ZSCORE procedure, 47
INSERT_PARAMETER_DIRECTIVE Procedure, 15
INSERT_SEGMENT_DIRECTIVE Procedure, 15
INSERT_SQL_DIRECTIVE Procedure, 15
INSERTBEFORE function, 167
INSERTDATA procedure, 167
INSERTXML function, 172, 174
INSTANCE procedure, 75
INSTANCE_RECORD Record Type, 153
INSTANCE_TABLE Table Type, 153
instantiation
aborting database preparation, 30
aborting schema preparation, 30
aborting table preparation, 30
global SCN, 20
preparing a database for, 30
preparing a schema for, 30
preparing a table for, 30, 30
schema SCN, 20
table SCN, 20
INSTR Functions, 79
INTEGER_ARRAY Table Type, 128
INTERNAL_VERSION_CHECK function, 103
internet addressing
using UTL_INADDR, 224
INTERRUPT_ANALYSIS_TASK Procedure, 135
INTERRUPT_DIAGNOSIS_TASK Procedure, 134
INTERRUPT_TASK Procedure, 17
INTERRUPT_TUNING_TASK procedure, 136
INTERVAL procedure, 75
INTERVAL_DAY_TO_SECOND_TABLE, 133
INTERVAL_YEAR_TO_MONTH_TABLE Table Type, 133
INVALIDATE Functions & Procedures, 118
INVALIDATE Procedure, 153
INVALIDATE_OBJECT Functions & Procedures, 118
IS_BIT_SET Function, 153
IS_CLEANUP_INITIALIZED function, 26
IS_CLUSTER_DATABASE function, 153
IS_HIERARCHY_ENABLED function, 165
IS_LOCATOR function, 217
IS_NULL_TAG member function, 245
IS_OPEN function, 133, 220
IS_REPLAY_PAUSED Procedure, 157
IS_ROLE_ENABLED Function, 128
IS_SESSION_ALIVE Function, 128
IS_TRIGGER_FIRE_ONCE function, 50
ISFOLDER Function, 160, 163
ISFRAGMENT function, 256
ISINDEX function
of HTF package, 179
ISINDEX procedure
of HTP package, 180
ISNULL Function, 163, 166
ISNULL function, 167
ISOPEN function, 218
ISOPEN Functions, 79
ISSCHEMABASED function, 256
ISSCHEMAVALID function, 256
ISSCHEMAVALIDATED function, 256
ISTEMPORARY Functions, 79
ITALIC function
of HTF package, 179
ITALIC procedure
of HTP package, 180
ITEM Functions, 167

J

JARO_WINKLER Function, 227
JARO_WINKLER_SIMILARITY Function, 227
JOB constructor function, 125
JOB object type, 125, 125
JOB_ARRAY table type, 125, 125
JOBARG constructor function, 125
JOBARG object type, 125
JOBARG_ARRAY table type, 125
JOBATTR constructor function, 125
JOBATTR object type, 125
JOBATTR_ARRAY table type, 125

K

KBD function
of HTF package, 179
KBD procedure
of HTP package, 180
KEEP procedure, 129
KEEP_COLUMNS member procedure, 245
KEEP_COLUMNS procedure, 141
KEYBOARD function
of HTF package, 179
KEYBOARD procedure
of HTP package, 180

L

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

M

MAIL function and procedure, 232
MAILTO function
of HTF package, 179
MAILTO procedure
of HTP package, 180
MAINTAIN_CHANGE_TABLE procedure, 141
MAINTAIN_GLOBAL procedure, 141
MAINTAIN_SCHEMAS procedure, 141
MAINTAIN_SIMPLE_TABLESPACE procedure, 141
MAINTAIN_SIMPLE_TTS procedure, 141
MAINTAIN_TABLES procedure, 141
MAINTAIN_TABLESPACES procedure, 141
MAINTAIN_TTS procedure, 141
MAKE_DATA_BLOCK_ADDRESS function, 153
MAKEATTR function, 167
MAKECDATASECTION function, 167
MAKECHARACTERDATA function, 167
MAKECOMMENT function, 167
MAKEDOCUMENT Function, 163
MAKEDOCUMENT function, 167
MAKEDOCUMENTFRAGMENT function, 167
MAKEDOCUMENTTYPE function, 167
MAKEELEMENT function, 167
MAKEENTITY function, 167
MAKEENTITYREFERENCE function, 167
MAKENODE function, 167, 167, 167, 167
MAKENOTATION function, 167
MAKEPROCESSINGINSTRUCTION function, 167
MAKETEXT function, 167
MAKEVERSIONED function, 162
MAP_ALL function, 139
MAP_DAD Procedure, 60
MAP_ELEMENT function, 139
MAP_FILE function, 139
MAP_OBJECT function, 139
MAPCLOSE function
of HTF package, 179
MAPCLOSE procedure
of HTP package, 180
MAPOPEN function
of HTF package, 179
MAPOPEN procedure
of HTP package, 180
MARK_RECOMMENDATION Procedure, 17
MATCH function, 188
materialized view logs
master table
purging, 90, 90, 90
materialized views
comparing, 33
converting from table- to cube-organized, 39
optimizing cube organized, 40
refreshing, 90, 90, 90
materialized views (cube organized), 39
MEMORY_REPORT Procedure, 118
MENULISTCLOSE function
of HTF package, 179
MENULISTCLOSE procedure
of HTP package, 180
MENULISTOPEN function
of HTF package, 179
MENULISTOPEN procedure
of HTP package, 180
merge streams, 141, 141
MERGE_STREAMS procedure, 141
MERGE_STREAMS_JOB procedure, 141
MERGEXLIFF Functions, 175
MESSAGE_PROPERTIES_ARRAY_T Type, 240
MESSAGE_PROPERTIES_T Type, 240
messaging client
messaging client user, 141
rules
for LCRs, 141
for user messages, 141
META function
of HTF package, 179
META procedure
of HTP package, 180
MG2 function
of HTF package, 179
MGD_ID constructor function, 252
MGD_ID object type, 252
FORMAT function, 252
GET_COMPONENT function, 252
MGD_ID constructor function, 252
TO_STRING function, 252
TRANSLATE function, 252
MGD_ID object types, 252
MGD_ID_COMPONENT object type, 252
MGD_ID_COMPONENT_VARRAY object type, 252
MIGRATE_STORED_OUTLINE Function, 132
migration
post-migration actions, 93
MIME_HEADER procedure, 191
MIMEHEADER_DECODE function, 219
MIMEHEADER_ENCODE function, 219
MODIFY_BASELINE_WINDOW_SIZE Procedure, 158
MODIFY_OPERATOR_LIST procedure, 62
MODIFY_PACKAGE_STATE Procedure, 128
MODIFY_SERVICE Procedure, 127
MODIFY_SNAPSHOT_SETTINGS procedure, 158
MODIFY_TRANSFORMATION procedure, 150
MODIFYPARAMETER Procedure, 169
MOUNT_T Record Type, 43
MOUNTS_T Table Type, 43
MOUNTSTORE Procedure, 43
MOVE_TO_DBFS_LINK Procedures, 79
MOVEXDB_TABLESPACE procedure, 160
MSGID_ARRAY_T Type, 240
MV_CUBE_ADVICE function, 40

N

NAME_ARRAY Table Type, 153
NAME_RESOLVE procedure, 153
NAME_TOKENIZE procedure, 153
NAMELIST Table Type, 132
NAMESPACE function, 256
NAMESPACEIDTABLE Procedure, 38
NEW_LINE procedure, 97, 220
NEW_ROW_LIST function and procedure, 190
NEWCONTEXT function, 168, 171, 172, 174
NEWDOMDOCUMENT function, 167
NEWPARSER function, 170
NEWPROCESSOR function, 177
NEWSTYLESHEET function, 177
NEXT_DATE procedure, 75
NEXT_ITEM_TYPE function, 100
NL function
of HTF package, 179
NL procedure
of HTP package, 180
NOBR function
of HTF package, 179
NOBR procedure
of HTP package, 180
NOFRAMESCLOSE function
of HTF package, 179
NOFRAMESCLOSE procedure
of HTP package, 180
NOFRAMESOPEN function
of HTF package, 179
NOFRAMESOPEN procedure
of HTP package, 180
NOOP function and procedure, 232
NOOP Functions, 25
NORMAL function, 105
NORMAL_DIST_FIT procedure, 137
NORMALIZE procedure, 167
NORMALIZEPATH Functions, 43
NUMBER_ARRAY Table Type, 153
NUMBER_TABLE Table Type, 133
NVARRAY_ADD Procedure, 88
NVARRAY_FIND_NAME Function, 88
NVARRAY_FIND_NAME_TYPE Function, 88
NVARRAY_GET Function, 88
NVARRAY_GET_BOOLEAN, 88
NVARRAY_GET_BYTE, 88
NVARRAY_GET_DATE Function, 88
NVARRAY_GET_DOUBLE Function, 88
NVARRAY_GET_FLOAT Function, 88
NVARRAY_GET_INTEGER, 88
NVARRAY_GET_LONG Function, 88
NVARRAY_GET_RAW Function, 88
NVARRAY_GET_SHORT, 88
NVARRAY_GET_TEXT Function, 88

O

OBJECT_DEPENDENT_SEGMENTS function, 130
OBJECT_GROWTH_TREND function, 130
ogical change records (LCRs)
tracking, 141, 141
OLAP aggregation operators, 39
OLAP logs
Cube Build, 41
Cube Dimension Compile, 41
Cube Operations, 41
Cube Rejected Records, 41
OLAP metadata
upgrading to OLAP 11g, 39
OLAP PL/SQL packages
DBMS_CUBE_LOG, 41
OLAP templates
validation, 39
writing to XML files, 39
OLD_CURRENT_SCHEMA Function, 153
OLD_CURRENT_USER Function, 153
OLISTCLOSE function
of HTF package, 179
OLISTCLOSE procedure
of HTP package, 180
OLISTOPEN function
of HTF package, 179
OLISTOPEN procedure
of HTP package, 180
ONLINE_INDEX_CLEAN Function, 109
OPEN Procedures, 79
OPEN_CONNECTION function, 234
OPEN_CONNECTION functions, 232
OPEN_CURSOR Function, 72
OPEN_CURSOR function, 133
OPEN_DATA function and procedure, 232
OPEN_FBA Procedure, 67
operational notes
DBMS_LOGSTDBY package, 83
optimizer statistics, 29
OR REPLACE clause
for creating packages, 1
Oracle Data Mining, 42
Oracle Streams
administrator
granting privileges, 143
revoking privileges, 143
advisors, 142
change data capture
configuring, 141
compatibility, 140, 140, 140, 140, 140, 245
creating queues, 141
data dictionary
removing information, 141
messaging
notification, 141
privileges, 143
replication
configuring, 141, 141, 141, 141, 141, 141, 141, 141
Oracle-supplied types
logical change record (LCR) types, 245
rule types, 253
ORD_DICOM package documentation, 181
ORD_DICOM_ADMIN package documentation, 182
OVERLAY function, 229
OVERRIDE_PRIORITY Procedures, 27
OWA_CACHE package, 183
OWA_COOKIE package, 184
OWA_CUSTOM package, 185
OWA_IMAGE package, 186
OWA_OPT_LOCK package, 187
OWA_PATTERN package, 188
OWA_SEC package, 189
OWA_TEXT package, 190
OWA_UTIL package, 191

P

PACK_MESSAGE procedures, 100
PACK_STGTAB_BASELINE Function, 132
PACK_STGTAB_SQLPATCH Procedure, 134
PACK_STGTAB_SQLPROF Procedure, 136
PACK_STGTAB_SQLSET Procedure, 136
package
DBMS_EXPFIL, 62
DBMS_ODCI, 94
DBMS_RLMGR, 120
DBMS_XDB, 160
DBMS_XMLDOM, 167
DBMS_XMLGEN, 168
DBMS_XMLPARSER, 170
DBMS_XMLQUERY, 171
DBMS_XMLSAVE, 172
DBMS_XMLSCHEMA, 173
UriFactory, 242
Package - UriFactory, 242
package overview, 1
package variables
i_am_a_refresh, 90
packages
creating, 1
DBMS_MGD_ID_UTL, 86
referencing, 1
where documented, 1
PARA function
of HTF package, 179
PARA procedure
of HTP package, 180
PARAGRAPH function
of HTF package, 179
PARAGRAPH procedure
of HTP package, 180
PARAM function
of HTF package, 179
PARAM procedure
of HTP package, 180
PARSE Procedure, 72
PARSE procedure, 133, 170
PARSEBUFFER procedure, 170
PARSECLOB procedure, 170
PARSEDTD procedure, 170
PARSEDTDBUFFER procedure, 170
PARSEDTDCLOB procedure, 170
PATCHREPOSITORYRESCONFIGLIST Procedure, 115
PATH_ITEM_T Record Type, 43
PATH_ITEMS_T Table Type, 43
PATHIDTABLE Function, 38
PAUSE_PROFILER function and procedure, 103
PAUSE_REPLAY Procedure, 157
PIECEWISE member procedure
of ANYDATA TYPE, 237
of ANYDATASET TYPE, 238
PING procedure, 51
PLAINTEXT function
of HTF package, 179
PLAINTEXT procedure
of HTP package, 180
plan stability, 96
PL/SQL
datatypes, 55
numeric codes for, 55
functions
DBMS_MGWADM package subprograms, 87
DBMS_MGWMSG package subprograms, 88
procedures
DBMS_MGWADM package subprograms, 87
DBMS_MGWMSG package subprograms, 88
PL/SQL package
DBMS_HS_PARALLEL, 71
PLSQL_TRACE_VERSION procedure, 148
pointer to
CTX_ADM package, 6
point-in-time recovery
Oracle Streams, 141
POISSON_DIST_FIT procedure, 137
POPULATE_DIVERGENCE Procedure, 157
PORT_STRING function, 153
POST_INSTANTIATION_SETUP procedure, 141
PRE_INSTANTIATION_SETUP procedure, 141
PRECLOSE function
of HTF package, 179
PRECLOSE procedure
of HTP package, 180
predictive analytics, 101
PREOPEN function
of HTF package, 179
PREOPEN procedure
of HTP package, 180
PREPARE Procedure, 157
PREPARE_COLUMN_VALUES procedures, 138, 138
PREPARE_COLUMN_VALUES_NVARCHAR2 procedure, 138
PREPARE_COLUMN_VALUES_ROWID procedure, 138
PREPARE_GLOBAL_INSTANTIATION procedure, 30
PREPARE_SCHEMA_INSTANTIATION procedure, 30
PREPARE_SYNC_INSTANTIATION function, 30
PREPARE_TABLE_INSTANTIATION procedure, 30
PRINT function
of HTF package, 179
PRINT procedure
of HTP package, 180
PRINT_BACKTRACE procedure, 51
PRINT_CGI_ENV procedure, 191
PRINT_INSTANTIATIONS procedure, 51
PRINT_MULTI procedure, 190
PRINT_POST_PROCESSED_SOURCE Procedure, 102
PRINT_ROW_LIST procedure, 190
PRINTS procedure
of HTP package, 180
privileges
DBMS_LOGSTDBY package, 83
granting, 62
Oracle Streams administrator, 143, 143
revoking, 62
PRN function
of HTF package, 179
PRN procedure
of HTP package, 180
PROBE_VERSION procedure, 51
PROCESS_CAPTURE Procedure, 156
PROCESS_RECORDING Procedure, 157
PROCESS_RULES procedure, 120
PROCESSLINKS Procedure, 160
PROCESSXSL function, 177
PROGRAM_INFO Record Type, 51
PROP_ITEM_T Record Type, 43
PROP_ITEMS_T Table Type, 43
PROPAGATEORIGINALEXCEPTION procedure, 171, 172
propagations
altering, 104
creating, 104, 141, 141, 141, 141, 141
DBMS_PROPAGATION_ADM package, 104
dropping, 104
propagation user, 141
rules
defining global, 141
defining message, 141
defining schema, 141
defining subset, 141
defining table, 141
for LCRs, 141
for user messages, 141
starting, 104
stopping, 104
PROPANY Functions, 43
PROPERTIES_T Table Type, 43
PROPERTIESH2T Function, 43
PROPERTIEST2H Function, 43
PROPERTY_T Record Type, 43
PROPNUMBER Function, 43
PROPRAW Function, 43
PROPTIMESTAMP Function, 43
PROPVARCHAR2 Function, 43
PS procedure
of HTP package, 180
PUBLISH_PENDING_STATS Procedure, 138
PULL_SIMPLE_TABLESPACE procedure, 146
PULL_TABLESPACES procedure, 146
PURGE Procedure, 129
PURGE procedure, 100
PURGE_COMPARISON Procedure, 33
PURGE_EVENTS procedure, 120
PURGE_FILE_GROUP procedure, 64
PURGE_LOST_DB_ENTRY procedure, 149
PURGE_MIXED procedure, 149
PURGE_PROCESSED_CHUNKS Procedure, 98
PURGE_QUEUE_TABLE Procedure, 22
PURGE_SOURCE_CATALOG procedure, 141
PURGE_STATS procedure, 138
PURGEALL Procedure, 43, 44
PURGELDAPCACHE function, 165
PURGEPATH Procedure, 43, 44
PURGERESOURCEMETADATA Procedure, 160
PURGESCHEMA Procedure, 173
purging
the subscription window, 32
PUT procedure, 220
PUT procedures, 97
PUT_FILE procedure, 65
PUT_LINE Procedure, 220
PUT_LINE procedures, 97
PUT_LINE_NCHAR procedure, 220
PUT_NCHAR procedure, 220
PUT_RAW function, 220
PUTF procedure, 220
PUTF_NCHAR procedure, 220
PUTPATH Procedures, 43, 44

Q

QNAMEIDTABLE Function, 38
QUALIFIED_SQL_NAME Function, 25
queues
AnyData
creating, 141
removing, 141
QUICK_TUNE Procedure, 17
QUIT function and procedure, 232
QUOTED_PRINTABLE_DECODE function, 219
QUOTED_PRINTABLE_ENCODE function, 219

R

RANDOM procedure, 105
RANK_APPLY procedure, 42
RCPT function, 232
RE$ATTRIBUTE_VALUE type, 253
RE$ATTRIBUTE_VALUE_LIST type, 253
RE$COLUMN_VALUE type, 253, 253
RE$COLUMN_VALUE_LIST type, 253
RE$NAME_ARRAY type, 253
RE$NV_ARRAY type, 253
RE$NV_LIST type, 253
ADD_PAIR member procedure, 253
GET_ALL_NAMES member function, 253
GET_VALUE member function, 253
REMOVE_PAIR member procedure, 253
RE$RULE_HIT type, 253
RE$RULE_HIT_LIST type, 253
RE$TABLE_ALIAS type, 253
RE$TABLE_ALIAS_LIST type, 253
RE$TABLE_VALUE type, 253
RE$TABLE_VALUE_LIST type, 253
RE$VARIABLE_TYPE type, 253
RE$VARIABLE_TYPE_LIST type, 253
RE$VARIABLE_VALUE type, 253
RE$VARIABLE_VALUE_LIST type, 253
READ Procedures, 79
READ_CLIENT_INFO procedure, 19
READ_LINE function, 234
READ_LINE procedure
of UTL_HTTP, 221
READ_MODULE procedure, 19
READ_ONLY procedure, 149
READ_RAW function, 234
READ_RAW procedure
of UTL_HTTP, 221
READ_TEXT function, 234
READ_TEXT procedure
of UTL_HTTP, 221
READ_WRITE procedure, 149
READ2CLOB function, 177
Real-time SQL Monitoring Subprograms, 136
REASSOCIATE_FBA Procedure, 67
REBUILD_FREELISTS procedure, 109
RECEIVE_MESSAGE function, 100
RECHECK Function, 33
RECOMP_PARALLEL procedure, 230
RECOMP_SERIAL procedure, 230
RECONFIGCACHE Procedure, 45
REDIRECT_URL procedure, 191
refresh
materialized views, 90, 90, 90
REFRESH_CATEGORY function, 86
REFRESH_MVIEW procedure, 39, 39
REGISTER Procedure, 18
REGISTER_DEPENDENT_OBJECT procedure, 107
REGISTER_FOREIGN_QUEUE Procedure, 87
REGISTERPARAMETER Procedure, 169
REGISTERSCHEMA procedure, 173
REGISTERSTORE Procedure, 43
REGISTERSTORECOMMAND Procedur, 45
REGISTERTOKENTABLESET Procedure, 38
REGISTERURI procedure, 173
REGISTERURLHANDLER procedure, 242
RELEASE function, 80
REMAP_CONNECTION Procedure, 157
REMAP_STGTAB_SQLPROF Procedure, 136
REMAP_STGTAB_SQLSET Procedure, 136
REMOVE Procedure, 166
REMOVE procedure
of DBMS_ALERT package, 18
of DBMS_JOB package, 75
of OWA_COOKIE package, 184
REMOVE_AGENT Procedure, 87
REMOVE_CATEGORY procedure, 86
REMOVE_COLORED_SQL Procedure, 158
REMOVE_COST_MATRIX procedure, 42
REMOVE_FILE procedure, 64
REMOVE_JOB Procedure, 87
REMOVE_MSGSYSTEM_LINK Procedure, 87
REMOVE_OPTION Procedure, 87
REMOVE_PAIR member procedure, 253
REMOVE_PIPE function, 100
REMOVE_PROXY procedure, 86
REMOVE_QUEUE procedure, 141
REMOVE_RULE procedure, 124, 141
REMOVE_SCHEME procedure, 86
REMOVE_SQLSET_REFERENCE procedure, 136
REMOVE_STMT_FROM_HANDLER procedure, 144
REMOVE_STMT_HANDLER procedure, 20
REMOVE_STREAMS_CONFIGURATION procedure, 141
REMOVE_SUBSCRIBER Procedure, 87
REMOVEALL procedure, 18
REMOVEATTRIBUTE procedure, 167
REMOVEATTRIBUTENODE function, 167
REMOVENAMEDITEM function, 167
REMOVEPARAM procedure, 177
REMOVEXSLTPARAM procedure, 171, 172
RENAME_BASELINE Procedure, 158
RENAME_COLUMN member procedure, 245
RENAME_COLUMN procedure, 141
RENAME_MODEL procedure, 42
RENAME_SCHEMA procedure, 141
RENAME_TABLE procedure, 141
RENAMEPATH Procedure, 44
RENAMEPATH Procedures, 43
RENAMERESOURCE procedure, 160
REPLACECHILD function, 167
REPLACEDATA procedure, 167
replication
Oracle Streams
configuring, 141, 141, 141, 141, 141, 141, 141, 141
split and merge, 141, 141, 141
REPLY, REPLIES record types, 232
REPORT Function, 156, 157
REPORT_ANALYSIS_TASK Function, 135
REPORT_AUTO_TUNING_TASK Function, 136
REPORT_DIAGNOSIS_TASK Function, 134
REPORT_SQL_DETAIL Function, 136
REPORT_SQL_MONITOR Function, 136
REPORT_SQL_MONITOR_LIST Function, 136
REPORT_TUNING_TASK function, 136
REQUEST function, 80, 221
REQUEST_PIECES function, 221
RESET_ANALYSIS_TASK Procedure, 135
RESET_BUFFER procedure, 100
RESET_DIAGNOSIS_TASK Procedure, 134
RESET_GLOBAL_PREFS_DEFAULTS Procedure, 138
RESET_JOB Procedure, 87
RESET_PACKAGE Procedure, 128
RESET_PARAM_DEFAULTS Procedure, 138
RESET_SESSION procedure, 120
RESET_SQLWKLD Procedure, 17
RESET_SUBSCRIBER Procedure, 87
RESET_TASK Procedure, 17
RESET_TUNING_TASK procedure, 136
RESETPARAMS procedure, 177
RESOLVENAMESPACEPREFIX function, 167
RESTARTQUERY procedure, 168
RESTORE function, 139
RESTORE_DATBASE_STATS procedure, 138
RESTORE_DEFAULTS Procedure, 35
RESTORE_DICTIONARY_STATS procedure, 138
RESTORE_FIXED_OBJECTS_STATS procedure, 138
RESTORE_SCHEMA_STATS procedure, 138
RESTORE_SYSTEM_STATS procedure, 138
RESTORE_TABLE_STATS procedure, 138
RESTOREALL Procedure, 43, 44
RESTOREPATH Procedure, 43, 44
RESUME_ANALYSIS_TASK Procedure, 135
RESUME_DIAGNOSIS_TASK Procedure, 134
RESUME_PROFILER function and procedure, 103
RESUME_REPLAY Procedure, 157
RESUME_TASK Procedure, 98
RESUME_TUNING_TASK Procedure, 136
REVERSE function, 229
REVOKE_ADMIN_PRIVILEGE procedure, 143
REVOKE_OBJECT_PRIVILEGE procedure, 64, 124
REVOKE_PRIVILEGE procedure, 62, 120
REVOKE_REMOTE_ADMIN_ACCESS procedure, 143
REVOKE_SWITCH_CONSUMER_GROUP procedure, 117
REVOKE_SYSTEM_PRIVILEGE procedure, 64, 117, 124
RLM$EVENTIDS object type, 254
ROLLBACK procedure, 149
ROLLBACK_FORCE procedure, 149
ROLLBACK_SAVEPOINT procedure, 149
row migration, 141, 141
ROWID datatype
extended format, 122
ROWID_BLOCK_NUMBER function, 122
ROWID_CREATE function, 122
ROWID_INFO procedure, 122
ROWID_OBJECT function, 122
ROWID_RELATIVE_FNO function, 122
ROWID_ROW_NUMBER function, 122
ROWID_TO_ABSOLUTE_FNO function, 122
ROWID_TO_EXTENDED function, 122
ROWID_TO_RESTRICTED function, 122
ROWID_TYPE function, 122
ROWID_VERIFY function, 122
rule sets
adding rules to, 124
creating, 124
dropping, 124
removing rules from, 124
rule-based transformations
setting, 141
rules
action contexts
adding name-value pairs, 253
getting name-value pairs, 253
getting value for name, 253
removing name-value pairs, 253
transformations, 141
altering, 124
creating, 124
DBMS_RULE package, 123
DBMS_RULE_ADM package, 124
dropping, 124
evaluation, 123
iterators, 123, 123
evaluation contexts
altering, 124
creating, 124
dropping, 124
object privileges
granting, 124
revoking, 124
propagations
removing, 141
RE$ATTRIBUTE_VALUE type, 253
RE$ATTRIBUTE_VALUE_LIST type, 253
RE$COLUMN_VALUE type, 253, 253
RE$COLUMN_VALUE_LIST type, 253
RE$NAME_ARRAY type, 253
RE$NV_ARRAY type, 253
RE$NV_LIST type, 253
RE$RULE_HIT type, 253
RE$RULE_HIT_LIST type, 253
RE$TABLE_ALIAS type, 253
RE$TABLE_ALIAS_LIST type, 253
RE$TABLE_VALUE type, 253
RE$TABLE_VALUE_LIST type, 253
RE$VARIABLE_TYPE type, 253
RE$VARIABLE_TYPE_LIST type, 253
RE$VARIABLE_VALUE type, 253
RE$VARIABLE_VALUE_LIST type, 253
subset
defining, 141, 141
system privileges
granting, 124
revoking, 124
system-created, 141
global apply, 141
global capture, 141
global propagation, 141
global schema, 141
message, 141, 141
message propagation, 141
removing, 141
schema capture, 141
schema propagation, 141
subset apply, 141
subset capture, 141
subset propagation, 141
table apply, 141
table capture, 141
table propagation, 141
types, 253
Rules Manager object types, 254
RUN procedure, 75
RUN_CHECK Procedure, 69
RUN_TASK Procedure, 98
RUNTIME_INFO Record Type, 51

S

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

T

table alias
attributes, 243
TABLE_CREATE procedure, 41
TABLE_TO_COMMA procedures, 153
TABLECAPTION function
of HTF package, 179
TABLECAPTION procedure
of HTP package, 180
TABLECLOSE function
of HTF package, 179
TABLECLOSE procedure
of HTP package, 180
TABLEDATA function
of HTF package, 179
TABLEDATA procedure
of HTP package, 180
TABLEHEADER function
of HTF package, 179
TABLEHEADER procedure
of HTP package, 180
TABLEOPEN function
of HTF package, 179
TABLEOPEN procedure
of HTP package, 180
TABLEPRINT function, 191
TABLEROWCLOSE function
of HTF package, 179
TABLEROWCLOSE procedure
of HTP package, 180
TABLEROWOPEN function
of HTF package, 179
TABLEROWOPEN procedure
of HTP package, 180
tables
comparing, 33
table items as arrays, 133
tablespace repositories
attaching tablespaces, 146
cloning tablespaces, 146
detaching tablespaces, 146
TABLESPACE_FIX_BITMAPS procedure, 131
TABLESPACE_FIX_SEGMENT_STATES procedure, 131
TABLESPACE_MIGRATE_FROM_LOCAL procedure, 131
TABLESPACE_MIGRATE_TO_LOCAL procedure, 131
TABLESPACE_REBUILD_BITMAPS procedure, 131
TABLESPACE_REBUILD_QUOTAS procedure, 131
TABLESPACE_RELOCATE_BITMAPS procedure, 131
TABLESPACE_SET type, 146
TABLESPACE_VERIFY procedure, 131
tablespaces
change tables and, 31
tags
GET_TAG function, 140, 141
SET_TAG procedure, 140, 141
TARGET_FILE function, 41
TARGET_LOB function, 41
TARGET_PROGRAM_RUNNING procedure, 51
TARGET_TABLE function, 41
TARGET_TRACE function, 41
TELETYPE function
of HTF package, 179
TELETYPE procedure
of HTP package, 180
TERMINATE procedure, 105
TEXT_DECODE function, 219
TEXT_ENCODE function, 219
TIME_TABLE Table Type, 133
TIME_WITH_TIME_ZONE_TABLE Table Type, 133
TIMESTAMP_TABLE Table Type, 133
TIMESTAMP_WITH_LTZ_TABLE Table Type, 133
TIMESTAMP_WITH_TIME_ZONE_TABLE Table Type, 133
TITLE function
of HTF package, 179, 179
TITLE procedure
of HTP package, 180
TO_CURSOR_NUMBER Function, 133
TO_REFCURSOR Function, 133
TO_STRING function, 252
TODATE function, 191
TOOBJECT procedure, 256
TOUCHRESOURCE Procedure, 160
TRACE Procedure, 43
TRACE procedure, 40
TRACEENABLED Function, 43
TRACETAB.SQL, 148
tracking LCRs, 141, 141
TRANSACTION_BACKOUT Procedures, 66
TRANSFORM function, 256
transformations
rule-based
adding a column, 141
custom, 141
deleting a column, 141
keeping columns, 141
renaming a column, 141
renaming a schema, 141
renaming a table, 141
STREAMS$_TRANSFORM_FUNCTION, 141
TRANSFORMNODE function, 177
TRANSLATE function, 229, 252
TRANSLATEXML Function, 175
TRANSLITERATE Function, 222
transparent data encryption
apply process, 20
TRANSPORT_SET_CHECK procedure, 151
TRIM Procedures, 79
TUNE_MVIEW Procedure, 17
TYPE_BUILD function, 41
TYPE_DIMENSION_COMPILE function, 41
TYPE_OPERATIONS function, 41
TYPE_REJECTED_RECORDS function, 41
types
Expression Filter, 243
MGD_ID, 252, 252
MGD_ID_COMPONENT, 252
MGD_ID_COMPONENT_VARRAY, 252
Oracle Multimedia
ORDAudio, 246
ORDDicom, 247
ORDDoc, 248
ORDImage, 249
ORDVideo, 251
SQL/MM Still Image, 250
Rules Manager, 254

U

ULISTCLOSE function
of HTF package, 179
ULISTCLOSE procedure
of HTP package, 180
ULISTOPEN function
of HTF package, 179
ULISTOPEN procedure
of HTP package, 180
UNASSIGN_ACL Procedure, 91
UNASSIGN_ATTRIBUTE_SET procedure, 62
UNASSIGN_WALLET_ACL Procedure, 91
UNCHECKOUT function, 162
UNCL_ARRAY Table Type, 153
UNDERLINE function
of HTF package, 179
UNDERLINE procedure
of HTP package, 180
UNESCAPE function, 235
UNESCAPEURI function, 242
UNIFORM_DIST_FIT procedure, 137
UNIQUE_SESSION_ID Function, 128
UNIQUE_SESSION_NAME function, 100
UNKEEP procedure, 129
UNLOCK_MAP procedure, 139
UNLOCK_PARTITION_STATS Procedure, 138
UNLOCK_SCHEMA_STATS procedure, 138
UNLOCK_TABLE_STATS procedure, 138
UNLOCKPATH Procedure, 43, 44
UNLOCKRESOURCE function, 160
UNMAP_DAD Procedure, 60
UNMOUNTSTORE Procedure, 43
UNPACK_MESSAGE procedures, 100
UNPACK_STGTAB_BASELINE Function, 132
UNPACK_STGTAB_SQLPATCH Procedure, 134
UNPACK_STGTAB_SQLPROF Procedure, 136
UNPACK_STGTAB_SQLSET Procedure, 136
UNREGISTER_DEPENDENT_OBJECT procedure, 107
UNREGISTER_FOREIGN_QUEUE Procedure, 87
UNREGISTERSTORE Procedure, 43
UNREGISTERURLHANDLER procedure, 242
UNSCHEDULE_PROPAGATION Procedure, 87
UNUSED_SPACE procedure, 130
UPDATE_BY_CAT procedure, 96
UPDATE_CATEGORY Procedure, 116
UPDATE_CONSUMER_GROUP procedure, 116
UPDATE_OBJECT Procedure, 17
UPDATE_OBJECT procedure, 231
UPDATE_PLAN procedure, 116
UPDATE_PLAN_DIRECTIVE procedure, 116
UPDATE_REC_ATTRIBUTES Procedure, 17
UPDATE_SIGNATURES procedure, 96
UPDATE_SQLSET procedures, 136
UPDATE_SQLWKLD_ATTRIBUTES Procedure, 17
UPDATE_SQLWKLD_STATEMENT Procedure, 17
UPDATE_TASK_ATTRIBUTES Procedure, 17
UPDATERESOURCEMETADATA Procedures, 160
UPDATETRANSLATION Function, 175
UPDATEXML function, 172, 174
UPGRADE_DATABASE Procedure, 58
UPGRADE_SCHEMA Procedure, 58
UPGRADE_STAT_TABLE procedure, 138
UPGRADE_TABLE Procedure, 58
upgrading
post-upgrade actions, 93
URI Types
description, 242
UriFactory package, 242
ESCAPEURI function, 242
GETURL function, 242
methods, 242
REGISTERURLHANDLER procedure, 242
UNESCAPEURI function, 242
UNREGISTERURLHANDLER procedure, 242
UriType supertype, 242
GETBLOB function, 242
GETCLOB function, 242
GETCONTENTTYPE function, 242
GETEXTERNALURL function, 242
GETURL function, 242
GETXML function, 242
methods, 242
UROWID_TABLE Table Type, 133
USE_FILTER_SET Procedure, 157
USE_ROLLBACK_SEGMENT procedure, 149
USEBINARYSTREAM Function, 167
USEITEMTAGSFORCOLL procedure, 168
USENULLATTRIBUTEINDICATOR procedure, 168, 171
USER_EXPORT procedures, 75
USETYPEFORCOLLELEMTAG procedure, 171
Using DBMS_ADVISOR, 17
Using DBMS_AQIN, 24, 24
Using DBMS_FILE_GROUP, 64
Using DBMS_MVIEW, 90
Using DBMS_RULE, 123
Using DBMS_RULE_ADM, 124
Using DBMS_STREAMS, 140
Using DBMS_STREAMS_ADM, 141
Using DBMS_STREAMS_TABLESPACE_ADM, 146
Using DBMS_XMLDOM, 167
Using DBMS_XMLSCHEMA, 173
Using UTL_HTTP, 221
UTL Streams Types, 255
UTL_BINARYINPUTSTREAM Type, 255
UTL_BINARYOUTPUTSTREAM Type, 255
UTL_CHARACTERINPUTSTREAM Type, 255
UTL_CHARACTEROUTPUTSTREAM Type, 255
UTL_COLL package, 217
UTL_COMPRESS package, 218
UTL_ENCODE package, 219
UTL_FILE package, 220
UTL_HTTP package, 221
UTL_I18N package, 222
ESCAPE_REFERENCE function, 222, 222, 222, 222, 222, 222, 222
GET_DEFAULT_CHARSET function, 222
MAP_CHARSET function, 222
MAP_LANGUAGE_FROM_ISO function, 222
MAP_LOCALE_TO_ISO function, 222
MAP_TERRITORY_FROM_ISO function, 222
RAW_TO_CHAR function, 222
RAW_TO_NCHAR function, 222
UNESCAPE_REFERENCE function, 222
UTL_INADDR package, 224
UTL_LMS package, 225
FORMAT_MESSAGE function, 225
GET_MESSAGE function, 225
UTL_MAIL package, 226
UTL_NLA package, 228
UTL_RAW package, 229
UTL_RECOMP package, 230
UTL_REF package, 231
UTL_SPADV package, 233
UTL_TCP package, 234
UTL_URL package, 235
UUDECODE function, 219
UUENCODE function, 219

V

V$STREAMS_MESSAGE_TRACKING view, 141, 141
v$vpd_policies, 121
VALIDATE procedure, 153
VALIDATE_DIMENSION procedure, 57
VALIDATE_EXPRESSIONS procedure, 62
VALIDATE_PENDING_AREA procedure, 116
VALIDATE_REWRITE_EQUIVALENCE Procedure, 16
VALIDATE_SCHEME function, 86
VALIDATE_XML procedure, 39
VALUE functions, 105
VALUEOF procedure, 177
VARCHAR2_TABLE Table Type, 133
VARCHAR2A Table Type, 133
VARCHAR2S Table Type, 133
VARIABLE function
of HTF package, 179
VARIABLE procedure
of HTP package, 180
VARIABLE_VALUE procedures, 133
VERBOSE_ACTION function, 41
VERBOSE_DEBUG function, 41
VERBOSE_INFO function, 41
VERBOSE_NOTICE function, 41
VERBOSE_STATS function, 41
VERIFY_VALUES function, 187
VERSION function, 41
views
comparing, 33
virtual dependency definitions
object dependencies
creating, 20
dropping, 20
value dependencies, 20
Virtual Private Database. See VPD
VPD
column masking, 121
enabling column-level, 121
viewing current cursors and policy predicates, 121
VPD use of DBMS_RLS, 121
VRFY function, 232

W

WAIT_ON_PENDING_DML Procedure, 153
WAITANY procedure, 18
WAITONE procedure, 18
WBR function
of HTF package, 179
WBR procedure
of HTP package, 180
WEIBULL_DIST_FIT procedure, 137
WHAT procedure, 75
WHO_CALLED_ME procedure, 191
WPG_DOCLOAD package, 236
WRAP Functions, 50
WRITE Procedures, 79
WRITE_DATA procedure, 232
WRITE_LINE function, 234
WRITE_LINE procedure, 221
WRITE_RAW function, 234
WRITE_RAW procedure, 221
WRITE_RAW_DATA procedure, 232
WRITE_TEXT function, 234
WRITE_TEXT procedure, 221
WRITEAPPEND Procedures, 79
WRITETOBUFFER procedure, 167
WRITETOCLOB procedure, 167
WRITETOFILE procedure, 167

X

XA_COMMIT Function, 159
XA_END Function, 159
XA_FORGET Function, 159
XA_GETLASTOER Function, 159
XA_PREPARE Function, 159
XA_RECOVER Function, 159
XA_ROLLBACK Function, 159
XA_SETTIMEOUT Function, 159
XA_START Function, 159
XDBEvent Type Subprograms, 166
XDBHandler Type Subprograms, 166
XDBHandlerList Type Subprograms, 166
XDBLink Type Subprograms, 166
XDBPath Type Subprograms, 166
XDBRepositoryEvent Type Subprograms, 166
XDBUriType, 242
XDBURITYPE function, 242
XDBUriType subtype, 242
CREATEURI function, 242
GETBLOB function, 242
GETCLOB function, 242
GETCONTENTTYPE function, 242
GETEXTERNALURL function, 242
GETURL function, 242
GETXML function, 242
methods, 242
XDBURITYPE function, 242
XDBZ Constants, 165
XFORM_BIN_CAT procedure, 47
XFORM_BIN_NUM procedure, 47
XFORM_CLIP procedure, 47
XFORM_COL_REM procedure, 47
XFORM_EXPR_NUM procedure, 47
XFORM_EXPR_STR procedure, 47
XFORM_MISS_CAT procedure, 47
XFORM_MISS_NUM procedure, 47
XFORM_NORM_LIN procedure, 47
XFORM_STACK procedure, 47
XML tags
specifying list of
configuring index parameters, 243
XML_TO_LCR Function, 88
XMLINDEXADDPATH Function, 161
XMLINDEXREMOVEPATH Function, 161
XMLType
CREATENONSCHEMABASEDXML function, 256
CREATESCHEMABASEDXML function, 256
CREATEXML function, 256
description, 256
EXISTSNODE function, 256
EXTRACT function, 256
GETBLOBVAL function, 256
GETCLOBVAL function, 256
GETNUMBERVAL function, 256
GETROOTELEMENT function, 256
GETSCHEMAURL function, 256
GETSTRINGVAL function, 256
ISFRAGMENT function, 256
ISSCHEMABASED function, 256
ISSCHEMAVALID function, 256
ISSCHEMAVALIDATED function, 256
NAMESPACE function, 256
SCHEMAVALIDATE procedure, 256
SETSCHEMAVALIDATED procedure, 256
TOOBJECT procedure, 256
TRANSFORM function, 256
XMLTYPE function, 256
XMLTYPE function, 256
XPath parameters
adding to attribute list, 62
dropping from attribute list, 62
XPath predicates
indexing set of
configuring XML element or XML attribute, 243
XPINDEX_PARAMETERS procedure, 62
XRANGE function, 229
Go to previous page
Previous
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