265/265

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