Skip Headers
Oracle® Database PL/SQL Packages and Types Reference
11g Release 2 (11.2)
E40758-03
Go to Documentation Home
Home		 Go to Book List
Book List		 Go to Table of Contents
Contents		 Go to Master Index
Master Index		 Go to Feedback page
Contact Us
Go to previous page
Previous
PDF · Mobi · ePub

Index

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

A

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

B

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

C

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

D

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

E

EDIT_DISTANCE Function, 231
EDIT_DISTANCE_SIMILARITY Function, 231
EHLO function and procedure, 236
EM function
of HTF package, 183
EM procedure
of HTP package, 184
e-mail from PL/SQL (email), 238
EMPHASIS function
of HTF package, 183
EMPHASIS procedure
of HTP package, 184
ENABLE procedure, 43, 100
ENABLE Procedures, 29
ENABLE_AT_SYSTEM_CHANGE_NUMBER procedure, 69
ENABLE_AT_TIME procedure, 69
ENABLE_BREAKPOINT function, 52
ENABLE_HIERARCHY procedure, 169
ENABLE_JOB Procedure, 90
ENABLE_POLICY Procedure, 111
ENABLE_PROPAGATION_SCHEDULE Procedure, 90
ENABLETRANSLATION Procedure, 179
END_PREPARE Procedure, 60
END_REPLAY_SCHEDULE Procedure, 161
END_REQUEST procedure, 225
END_RESPONSE procedure, 225
END_SQL_BLOCK Procedure, 120
END_UPGRADE Procedure, 60
ENDCREATE member procedure
of ANYDATA TYPE, 241
of ANYDATASET TYPE, 242
of ANYTYPE TYPE, 243
ENQUEUE procedure, 149
ENQUEUE_ARRAY Function, 22
ENQUEUE_OPTIONS_T Type, 244
ENQUOTE_LITERAL Function, 26
ENQUOTE_NAME Function, 26
EPC_TO_ORACLE_SCHEME function, 89
EQUALS_HOST Function, 95
ERASE Procedures, 82
error queue
deleting errors, 21, 21
executing errors, 21, 21
getting error messages, 21
ESCAPE function, 239
ESCAPE_SC function
of HTF package, 183
ESCAPE_SC procedure
of HTP package, 184
ESCAPE_URL function
of HTF package, 183
ESCAPEURI function, 246
ESTIMATE_CPU_UNITS function, 97
ESTIMATE_MVIEW_SIZE Procedure, 93
ETINSTANCE member function
of ANYDATASET TYPE, 242
EVALUATE procedure, 127
EVOLVE_SQL_PLAN_BASELINE Function, 136
EXACT_TEXT_SIGNATURES procedure, 99
EXEC_DDL_STATEMENT procedure, 157
EXECUTE function, 137
EXECUTE member procedure, 249, 249
EXECUTE procedure, 52
EXECUTE_ALL_ERRORS procedure, 21
EXECUTE_ANALYSIS_TASK, 139
EXECUTE_AND_FETCH function, 137
EXECUTE_DIAGNOSIS_TASK Procedure, 138
EXECUTE_ERROR procedure, 21
EXECUTE_IMMEDIATE Procedure, 75
EXECUTE_NON_QUERY Function, 75
EXECUTE_TASK Procedure, 18
EXECUTE_TUNING_TASK Function & Procedure, 28, 140
execution flow
in dynamic SQL, 137
EXF$ATTRIBUTE object type, 248
EXF$ATTRIBUTE_LIST object type, 248
EXF$INDEXOPER object type, 248
EXF$TABLE_ALIAS object type, 248
EXF$TEXT object type, 248
EXF$XPATH_TAG object type, 248
EXF$XPATH_TAGS object type, 248
EXISTSNODE function, 260
EXISTSRESOURCE function, 164
EXPAND_MESSAGE function, 130
EXPLAIN_SQL_TESTCASE Function, 138
EXPONENTIAL_DIST_FIT procedure, 141
EXPORT_AWR Procedure, 160, 161
EXPORT_COLUMN_STATS procedure, 142
EXPORT_DATABASE_PREFS Procedure, 142
EXPORT_DATABASE_STATS procedure, 142
EXPORT_DICTIONARY_STATS procedure, 142
EXPORT_FIXED_OBJECTS_STATS procedure, 142
EXPORT_INDEX_STATS procedure, 142
EXPORT_PENDING_STATS Procedure, 142
EXPORT_SCHEMA_PREFS Procedure, 142
EXPORT_SCHEMA_STATS procedure, 142
EXPORT_SQL_TESTCASE Procedures, 138
EXPORT_SQL_TESTCASE_DIR_BY_INC Function, 138
EXPORT_SQL_TESTCASE_DIR_BY_TXT Function, 138
EXPORT_SYSTEM_STATS procedure, 142
EXPORT_TABLE_PREFS Procedure, 142
EXPORT_TABLE_STATS procedure, 142
EXPORT_XML procedure, 41, 41
EXPORT_XML_TO_FILE procedure, 41
Expression Filter object types, 248
extend window
to create a new view, 34
EXTEND_EVENT_STRUCT procedure, 124
EXTRACT function, 260
EXTRACTXLIFF Function & Procedure, 179

F

FCLOSE procedure, 224
FCLOSE_ALL procedure, 224
FCOPY procedure, 224
FEATURE_T Record Type, 47
FEATURENAME Function, 47
FEATURES_T Table Type, 47
FETCH_ROW Function, 75
FETCH_ROWS function, 137
FFLUSH procedure, 224
FGETATTR procedure, 224
FGETPOS function, 224
FI_HORIZONTAL function, 71
FI_TRANSACTIONAL function, 71
file groups, 67
adding files, 67
altering, 67
altering files, 67
altering versions, 67
creating, 67
creating versions, 67
dropping, 67
dropping versions, 67
granting object privileges, 67
granting system privileges, 67
purging, 67
removing files, 67
revoking object privileges, 67
revoking system privileges, 67
FILE type, 150
FILE_SET type, 150
FILECLOSE Procedure, 82
FILECLOSEALL Procedure, 82
FILEEXISTS Function, 82
FILEGETNAME Procedure, 82
FILEISOPEN Function, 82
FILEOPEN Procedure, 82
FILETYPE Record Type, 224
FIND_AFFECTED_TABLE Procedure, 60
FINDENTITY function, 171
FINDNOTATION function, 171
fine-grained access control
DBMS_RLS package, 125
FINISH_CAPTURE Procedure, 160
FINISH_REDEF_TABLE procedure, 110
FIX_CORRUPT_BLOCKS procedure, 113
FLUSH Function & Procedure, 122
FLUSH procedure, 43, 238
FLUSH_DATA function and procedure, 106
FLUSH_DATABASE_MONITORING_INFO procedure, 142
FLUSHCACHE Procedure, 49
FONTCLOSE function
of HTF package, 183
FONTCLOSE procedure
of HTP package, 184
FONTOPEN function
of HTF package, 183
FONTOPEN procedure
of HTP package, 184
FOPEN function, 224
FOPEN_NCHAR function, 224
FORCE parameter
and job-to-instance affinity, 78
FORMAT function, 256
FORMAT_CALL_STACK Function, 157
FORMAT_CELL function
of HTF package, 183
FORMAT_ERROR_BACKTRACE function, 157
FORMAT_ERROR_STACK function, 157
FORMCHECKBOX function
of HTF package, 183
FORMCHECKBOX procedure
of HTP package, 184
FORMCLOSE function
of HTF package, 183, 183
FORMCLOSE procedure
of HTP package, 184
FORMFILE function
of HTF package, 183
FORMFILE procedure
of HTP package, 184, 184
FORMHIDDEN function
of HTF package, 183
FORMHIDDEN procedure
of HTP package, 184
FORMIMAGE function
of HTF package, 183
FORMIMAGE procedure
of HTP package, 184
FORMOPEN function
of HTF package, 183
FORMOPEN procedure
of HTP package, 184
FORMPASSWORD function
of HTF package, 183
FORMPASSWORD procedure
of HTP package, 184
FORMRADIO function
of HTF package, 183
FORMRADIO procedure
of HTP package, 184
FORMRESET function
of HTF package, 183
FORMRESET procedure
of HTP package, 184
FORMSELECTCLOSE function
of HTF package, 183
FORMSELECTCLOSE procedure
of HTP package, 184
FORMSELECTOPEN function
of HTF package, 183
FORMSELECTOPEN procedure
of HTP package, 184
FORMSELECTOPTION function
of HTF package, 183
FORMSELECTOPTION procedure
of HTP package, 184
FORMSUBMIT function
of HTF package, 183
FORMSUBMIT procedure
of HTP package, 184
FORMTEXT function
of HTF package, 183
FORMTEXT procedure
of HTP package, 184
FORMTEXTAREA function
of HTF package, 183
FORMTEXTAREA procedure
of HTP package, 184
FORMTEXTAREA2 function
of HTF package, 183
FORMTEXTAREA2 procedure
of HTP package, 184
FORMTEXTAREACLOSE function
of HTF package, 183
FORMTEXTAREACLOSE procedure
of HTP package, 184
FORMTEXTAREAOPEN function
of HTF package, 183
FORMTEXTAREAOPEN procedure
of HTP package, 184
FORMTEXTAREAOPEN2 function
of HTF package, 183
FORMTEXTAREAOPEN2 procedure
of HTP package, 184
FRAGMENT_DELETE Procedure, 82
FRAGMENT_INSERT Function, 82
FRAGMENT_MOVE Procedure, 82
FRAGMENT_REPLACE Procedure, 82
FRAME function
of HTF package, 183
FRAME procedure
of HTP package, 184
FRAMESETCLOSE function
of HTF package, 183
FRAMESETCLOSE procedure
of HTP package, 184
FRAMESETOPEN function
of HTF package, 183
FRAMESETOPEN procedure
of HTP package, 184
FREE_BLOCKS procedure, 134
FREE_UNUSED_USER_MEMORY Procedure, 132
FREEDOCFRAG procedure, 171
FREEDOCUMENT procedure, 171
FREENODE procedure, 171, 171
FREEPARSER procedure, 174
FREEPROCESSOR procedure, 181
FREERESOURCE Procedure, 167
FREESTYLESHEET procedure, 181
FREETEMPORARY Procedures, 82
FREMOVE procedure, 224, 224
FRENAME procedure, 224
FSEEK procedure, 224
functions
adding to attribute sets, 65, 124

G

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

H

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

I

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

J

JARO_WINKLER Function, 231
JARO_WINKLER_SIMILARITY Function, 231
JOB constructor function, 129
JOB object type, 129, 129
JOB_ARRAY table type, 129, 129
JOBARG constructor function, 129
JOBARG object type, 129
JOBARG_ARRAY table type, 129
JOBATTR constructor function, 129
JOBATTR object type, 129
JOBATTR_ARRAY table type, 129

K

KBD function
of HTF package, 183
KBD procedure
of HTP package, 184
KEEP procedure, 133
KEEP_COLUMNS member procedure, 249
KEEP_COLUMNS procedure, 145
KEYBOARD function
of HTF package, 183
KEYBOARD procedure
of HTP package, 184

L

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

M

MAIL function and procedure, 236
MAILTO function
of HTF package, 183
MAILTO procedure
of HTP package, 184
MAINTAIN_CHANGE_TABLE procedure, 145
MAINTAIN_GLOBAL procedure, 145
MAINTAIN_SCHEMAS procedure, 145
MAINTAIN_SIMPLE_TABLESPACE procedure, 145
MAINTAIN_SIMPLE_TTS procedure, 145
MAINTAIN_TABLES procedure, 145
MAINTAIN_TABLESPACES procedure, 145
MAINTAIN_TTS procedure, 145
MAKE_DATA_BLOCK_ADDRESS function, 157
MAKEATTR function, 171
MAKECDATASECTION function, 171
MAKECHARACTERDATA function, 171
MAKECOMMENT function, 171
MAKEDOCUMENT function, 171
MAKEDOCUMENT Function, 167
MAKEDOCUMENTFRAGMENT function, 171
MAKEDOCUMENTTYPE function, 171
MAKEELEMENT function, 171
MAKEENTITY function, 171
MAKEENTITYREFERENCE function, 171
MAKENODE function, 171, 171, 171, 171
MAKENOTATION function, 171
MAKEPROCESSINGINSTRUCTION function, 171
MAKETEXT function, 171
MAKEVERSIONED function, 166
MAP_ALL function, 143
MAP_DAD Procedure, 63
MAP_ELEMENT function, 143
MAP_FILE function, 143
MAP_OBJECT function, 143
MAPCLOSE function
of HTF package, 183
MAPCLOSE procedure
of HTP package, 184
MAPOPEN function
of HTF package, 183
MAPOPEN procedure
of HTP package, 184
MARK_RECOMMENDATION Procedure, 18
MARKHOT Procedure, 133
MATCH function, 192
MATERIALIZE_DEFERRED_SEGMENTS Procedure, 135
materialized view logs
master table
purging, 93, 93, 93
materialized views
comparing, 35
converting from table- to cube-organized, 41
optimizing cube organized, 42
refreshing, 93, 93, 93
materialized views (cube organized), 41
MEMORY_REPORT Procedure, 122
MENULISTCLOSE function
of HTF package, 183
MENULISTCLOSE procedure
of HTP package, 184
MENULISTOPEN function
of HTF package, 183
MENULISTOPEN procedure
of HTP package, 184
merge streams, 145, 145
MERGE_COL_USAGE Procedure, 142
MERGE_STREAMS procedure, 145
MERGE_STREAMS_JOB procedure, 145
MERGEXLIFF Functions, 179
MESSAGE_PROPERTIES_ARRAY_T Type, 244
MESSAGE_PROPERTIES_T Type, 244
messaging client
messaging client user, 145
rules
for LCRs, 145
for user messages, 145
META function
of HTF package, 183
META procedure
of HTP package, 184
MG2 function
of HTF package, 183
MGD_ID constructor function, 256
MGD_ID object type, 256
FORMAT function, 256
GET_COMPONENT function, 256
MGD_ID constructor function, 256
TO_STRING function, 256
TRANSLATE function, 256
MGD_ID object types, 256
MGD_ID_COMPONENT object type, 256
MGD_ID_COMPONENT_VARRAY object type, 256
MIGRATE_STORED_OUTLINE Function, 136
migration
post-migration actions, 96
MIME_HEADER procedure, 195
MIMEHEADER_DECODE function, 223
MIMEHEADER_ENCODE function, 223
model transparency, 45
MODIFY_BASELINE_WINDOW_SIZE Procedure, 162
MODIFY_OPERATOR_LIST procedure, 65
MODIFY_PACKAGE_STATE Procedure, 132
MODIFY_SERVICE Procedure, 131
MODIFY_SNAPSHOT_SETTINGS procedure, 162
MODIFY_TRANSFORMATION procedure, 154
MODIFYPARAMETER Procedure, 173
MOUNT_T Record Type, 47
MOUNTS_T Table Type, 47
MOUNTSTORE Procedure, 47
MOVE_TO_DBFS_LINK Procedures, 82
MOVEXDB_TABLESPACE Procedure, 165
MSGID_ARRAY_T Type, 244
MV_CUBE_ADVICE function, 42

N

NAME_ARRAY Table Type, 157
NAME_RESOLVE procedure, 157
NAME_TOKENIZE procedure, 157
NAMELIST Table Type, 136
NAMESPACE function, 260
NAMESPACEIDTABLE Procedure, 40
NEW_LINE procedure, 100, 224
NEW_ROW_LIST function and procedure, 194
NEWCONTEXT function, 172, 175, 176, 178
NEWCONTEXTFROMHIERARCHY Function, 172
NEWDOMDOCUMENT function, 171
NEWPARSER function, 174
NEWPROCESSOR function, 181
NEWSTYLESHEET function, 181
NEXT_DATE procedure, 78
NEXT_ITEM_TYPE function, 103
NL function
of HTF package, 183
NL procedure
of HTP package, 184
NOBR function
of HTF package, 183
NOBR procedure
of HTP package, 184
NOFRAMESCLOSE function
of HTF package, 183
NOFRAMESCLOSE procedure
of HTP package, 184
NOFRAMESOPEN function
of HTF package, 183
NOFRAMESOPEN procedure
of HTP package, 184
NOOP function and procedure, 236
NOOP Functions, 26
NORMAL function, 108
NORMAL_DIST_FIT procedure, 141
NORMALIZE procedure, 171
NORMALIZEPATH Functions, 47
NUMBER_ARRAY Table Type, 157
NUMBER_TABLE Table Type, 137
NVARRAY_ADD Procedure, 91
NVARRAY_FIND_NAME Function, 91
NVARRAY_FIND_NAME_TYPE Function, 91
NVARRAY_GET Function, 91
NVARRAY_GET_BOOLEAN, 91
NVARRAY_GET_BYTE, 91
NVARRAY_GET_DATE Function, 91
NVARRAY_GET_DOUBLE Function, 91
NVARRAY_GET_FLOAT Function, 91
NVARRAY_GET_INTEGER, 91
NVARRAY_GET_LONG Function, 91
NVARRAY_GET_RAW Function, 91
NVARRAY_GET_SHORT, 91
NVARRAY_GET_TEXT Function, 91

O

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

P

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

Q

QNAMEIDTABLE Function, 40
QUALIFIED_SQL_NAME Function, 26
queues
AnyData
creating, 145
removing, 145
QUICK_TUNE Procedure, 18
QUIT function and procedure, 236
QUOTED_PRINTABLE_DECODE function, 223
QUOTED_PRINTABLE_ENCODE function, 223

R

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

S

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

T

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

U

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

V

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

W

WAIT_ON_PENDING_DML Procedure, 157
WAITANY procedure, 19
WAITONE procedure, 19
WBR function
of HTF package, 183
WBR procedure
of HTP package, 184
WEIBULL_DIST_FIT procedure, 141
WHAT procedure, 78
WHO_CALLED_ME procedure, 195
WPG_DOCLOAD package, 240
WRAP Functions, 53
WRITE Procedures, 82
WRITE_DATA procedure, 236
WRITE_LINE function, 238
WRITE_LINE procedure, 225
WRITE_RAW function, 238
WRITE_RAW procedure, 225
WRITE_RAW_DATA procedure, 236
WRITE_TEXT function, 238
WRITE_TEXT procedure, 225
WRITEAPPEND Procedures, 82
WRITETOBUFFER procedure, 171
WRITETOCLOB procedure, 171
WRITETOFILE procedure, 171

X

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