Index

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

A

ABORT procedure, 87

ABORT_GLOBAL_INSTANTIATION procedure, 20

ABORT_REDEF_TABLE procedure, 77

ABORT_SCHEMA_INSTANTIATION procedure, 20

ABORT_TABLE_INSTANTIATION procedure, 20

ABORTED_REQUEST_THRESHOLD procedure, 97

ACCEPT_SQL_PROFILE procedure, 101

ACLCHECKPRIVILEGES function, 121

ACTIVATE_SUBSCRIPTION Procedure, 22

ACTIVE_INSTANCES procedure, 116

ADD_COLUMN member procedure, 189

ADD_COLUMN procedure, 106

ADD_COOKIES procedure, 169

ADD_ELEMENTARY_ATTRIBUTE procedure, 39, 88

ADD_EVENT procedure, 88

ADD_FILE procedure, 41

ADD_FILTER Procedure, 118

ADD_FUNCTIONS procedure, 39, 88

ADD_GLOBAL_PROPAGATION_RULES procedure, 106

ADD_GLOBAL_RULES procedure, 106

ADD_MESSAGE_PROPAGATION_RULE procedure, 106

ADD_MESSAGE_RULE procedure, 106

ADD_PAIR member procedure, 197

ADD_RULE procedure, 88, 92

ADD_SCHEMA_PROPAGATION_RULES procedure, 106

ADD_SCHEMA_RULES procedure, 106

ADD_SQLSET_REFERENCE function, 101

ADD_SQLWKLD_REF Procedure, 12

ADD_SQLWKLD_STATEMENT Procedure, 12

ADD_SUBSCRIBER Procedure, 58

ADD_SUBSET_PROPAGATION_RULES procedure, 106

ADD_SUBSET_RULES procedure, 106

ADD_TABLE_PROPAGATION_RULES procedure, 106

ADD_TABLE_RULES procedure, 106

ADD_WARNING_SETTING_CAT procedure, 117

ADD_WARNING_SETTING_NUM procedure, 117

ADD2MULTI procedure, 148

ADDATTR member procedure

of ANYTYPE TYPE, 184

ADDINSTANCE member procedure

of ANYDATASET TYPE, 183

ADDRESS function

of HTF package, 135

ADDRESS procedure

of HTP package, 140

ADMIN_TABLES procedure, 79

ADVISE_COMMIT procedure, 111

ADVISE_NOTHING procedure, 111

ADVISE_ROLLBACK procedure, 111

ALLOCATE_UNIQUE procedure, 53

ALTER_AGENT Procedure, 58

ALTER_APPLY procedure, 15

ALTER_CAPTURE procedure, 20

ALTER_COMPILE procedure, 29

ALTER_DATABASE_TAB_MONITORING procedure, 103

ALTER_EVALUATION_CONTEXT procedure, 92

ALTER_FILE procedure, 41

ALTER_FILE_GROUP procedure, 41

ALTER_MSGSYSTEM_LINK Procedure for TIB/Rendezvous, 58

ALTER_MSGSYSTEM_LINK Procedure for WebSphere MQ, 58

ALTER_PROPAGATION procedure, 74

ALTER_PROPAGATION_SCHEDULE Procedure, 58

ALTER_REWRITE_EQUIVALENCE Procedure, 11

ALTER_RULE procedure, 92

ALTER_SCHEMA_TAB_MONITORING procedure, 103

ALTER_SQL_PROFILE procedure, 101

ALTER_STATS_HISTORY_RETENTION procedure, 103

ALTER_SUBSCRIBER Procedure, 58

ALTER_TABLE_NOT_REFERENCEABLE procedure, 29

ALTER_TABLE_REFERENCEABLE procedure, 29

ALTER_VERSION procedure, 41

AMATCH function, 146

ANALYZE_DATABASE procedure, 116

ANALYZE_PART_OBJECT procedure, 116

ANALYZE_SCHEMA procedure, 116

ANCHOR function

of HTF package, 135

ANCHOR procedure

of HTP package, 140

ANCHOR2 function

of HTF package, 135

ANCHOR2 procedure

of HTP package, 140

anomaly detection, 25, 25, 25, 25, 25, 25, 25, 25

anonymous PL/SQL blocks

dynamic SQL and, 100

AnyData datatype

queues

creating, 106

removing, 106

ANYDATA TYPE, 182

ANYDATASET TYPE, 183

ANYTYPE TYPE, 184

APPEND Procedures, 52

APPENDCHILD function, 125

APPENDDATA procedure, 125

APPENDRESOURCEMETADATA Procedure, 121

APPLETCLOSE function

of HTF package, 135

APPLETCLOSE procedure

of HTP package, 140

APPLETOPEN function

of HTF package, 135

APPLETOPEN procedure

of HTP package, 140

APPLY procedure, 25

apply process

altering, 15

apply user, 106

conflict handlers

setting, 15

creating, 15, 106, 106, 106, 106, 106

DBMS_APPLY_ADM package, 15

DDL handler

setting, 15, 15

DML handlers

setting, 15

dropping, 15

enqueuing events, 15

error handlers

setting, 15

error queue

deleting errors, 15, 15

executing errors, 15, 15

getting error messages, 15

instantiation

global SCN, 15

schema SCN, 15

table SCN, 15

message handler

setting, 15, 15

parameters

allow_duplicate_rows, 15

commit_serialization, 15

disable_on_error, 15

disable_on_limit, 15

maximum_scn, 15

parallelism, 15

setting, 15

startup_seconds, 15

time_limit, 15

trace_level, 15

transaction_limit, 15

txn_lcr_spill_threshold, 15

precommit handler

setting, 15, 15

rules

defining global, 106

defining message, 106

defining schema, 106

defining subset, 106

defining table, 106

for LCRs, 106

for user messages, 106

removing, 106

specifying execution, 15

starting, 15

stopping, 15

substitute key columns

setting, 15

APPLY$_ENQUEUE, 15

APPLY$_EXECUTE, 15

AQ$_AGENT Type, 185

AQ$_AGENT_LIST_T Type, 185

AQ$_DESCRIPTOR Type, 185, 185

AQ$_POST_INFO Type, 185

AQ$_POST_INFO_LIST Type, 185

AQ$_PURGE_OPTIONS_T Type, 185

AQ$_RECIPIENT_LIST_T Type, 185

AQ$_REG_INFO Type, 185

AQ$_REG_INFO_LIST Type, 185

AQ$_SUBSCRIBER_LIST_T Type, 185

AREA function

of HTF package, 135

AREA procedure

of HTP package, 140

arrays

BIND_ARRAY procedure, 100

bulk DML using DBMS_SQL, 100, 100

ASA_RECO_ROW Record Type, 98

ASA_RECO_ROW_TB Table Type, 98

ASA_RECOMMENDATIONS Function, 98

ASH_REPORT_HTML Function, 119

ASH_REPORT_TEXT Function, 119

ASSIGN_ATTRIBUTE_SET procedure, 39

ASSM_SEGMENT_VERIFY Procedure, 99

ASSM_TABLESPACE_VERIFY Procedure, 99

ATTACH_SESSION procedure, 30

ATTACH_SIMPLE_TABLESPACE procedure, 109

ATTACH_TABLESPACES procedure, 109

attribute sets

dropping, 39

AUTHORIZE function, 143

AUTHORIZE_DAD Procedure, 37

AVAILABLE function, 179

AWR_DIFF_REPORT_HTML Function, 119

AWR_DIFF_REPORT_TEXT Function, 119

AWR_REPORT_HTML function, 119

AWR_REPORT_TEXT function, 119

AWR_SQL_REPORT_HTML Function, 119

AWR_SQL_REPORT_TEXT Function, 119

B

BASE function

of HTF package, 135

BASE procedure

of HTP package, 140

BASE64_DECODE function, 167

BASE64_ENCODE function, 167

BASEFONT function

of HTF package, 135

BASEFONT procedure

of HTP package, 140

BEGIN_DISCRETE_TRANSACTION procedure, 111

BEGIN_REQUEST function, 169

BEGINCREATE static procedure

of ANYDATA TYPE, 182

of ANYDATASET TYPE, 183

of ANYTYPE TYPE, 184

BGSOUND function

of HTF package, 135

BGSOUND procedure

of HTP package, 140

BIG function

of HTF package, 135

BIG procedure

of HTP package, 140

BIND_ARRAY procedures, 100

BIND_INOUT_VARIABLE Procedure, 45

BIND_INOUT_VARIABLE_RAW Procedure, 45

BIND_OUT_VARIABLE Procedure, 45

BIND_OUT_VARIABLE_RAW Procedure, 45

BIND_VARIABLE Procedure, 45

BIND_VARIABLE procedures, 100

BIND_VARIABLE_RAW Procedure, 45

BIND_VARIABLES function, 149

binning, 26

categorical, 26

numerical, 26, 26

quantile, 26

BIT_AND function, 175

BIT_COMPLEMENT function, 175

BIT_OR function, 175

BIT_XOR function, 175

BLAS Level 1 (Vector-Vector Operations) Subprograms, 174

BLAS Level 2 (Matrix-Vector Operations) Subprograms, 174

BLAS Level 3 (Matrix-Matrix Operations) Subprograms, 174

BLAS_ASUM Functions, 174

BLAS_AXPY Procedures, 174

BLAS_COPY Procedures, 174

BLAS_DOT Functions, 174

BLAS_GBMV Procedures, 174

BLAS_GEMM Procedures, 174

BLAS_GEMV Procedures, 174

BLAS_GER Procedures, 174

BLAS_IAMAX Functions, 174

BLAS_NRM2 Functions, 174

BLAS_ROT Procedures, 174

BLAS_ROTG Procedures, 174

BLAS_SBMV Procedures, 174

BLAS_SCAL Procedure, 174

BLAS_SPMV Procedures, 174

BLAS_SPR Procedures, 174

BLAS_SPR2 Procedures, 174

BLAS_SWAP Procedure, 174

BLAS_SYMM Procedures, 174

BLAS_SYMV Procedures, 174

BLAS_SYR Procedures, 174

BLAS_SYR2 Procedures, 174

BLAS_SYRK Procedures, 174

BLAS_TBMV Procedures, 174

BLAS_TBSV Procedures, 174

BLAS_TPMV Procedures, 174

BLAS_TPSV Procedures, 174

BLAS_TRMM Procedures, 174

BLAS_TRMV Procedures, 174

BLAS_TRSM Procedures, 174

BLAS_TRSV Procedures, 174

BLOCKQUOTECLOSE function

of HTF package, 135

BLOCKQUOTECLOSE procedure

of HTP package, 140, 140

BLOCKQUOTEOPEN function

of HTF package, 135

BLOCKQUOTEOPEN procedure

of HTP package, 140

BODYCLOSE function

of HTF package, 135

BODYCLOSE procedure

of HTP package, 140

BODYOPEN function

of HTF package, 135

BODYOPEN procedure

of HTP package, 140

BOLD function

of HTF package, 135

BOLD procedure

of HTP package, 140

BR function

of HTF package, 135

BR procedure

of HTP package, 140

BREAKPOINT_INFO Record Type, 30

BROKEN procedure, 48

BUILD procedure, 20

BUILD_CHAIN_ROWS_TABLE procedure, 46

BUILD_EXCEPTIONS_TABLE procedure, 39, 46

BUILD_PART_INDEX procedure, 69

BUILD_SAFE_REWRITE_EQUIVALENCE Procedure, 11

C

CALENDARPRINT procedures, 149

CAN_REDEF_TABLE procedure, 77

CANCEL_TASK Procedure, 12

CANCEL_TUNING_TASK procedure, 101

CANONICALIZE procedure, 116

capture process

altering, 20

building a Streams data dictionary, 20

capture user, 106

creating, 106, 106, 106, 106

DBMS_CAPTURE_ADM package, 20

instantiation

aborting database preparation, 20

aborting schema preparation, 20

aborting table preparation, 20

preparing a database for, 20

preparing a schema for, 20

preparing a table for, 20

parameters

disable_on_limit, 20

downstream_real_time_mine, 20

maximum_scn, 20

message_limit, 20

parallelism, 20

setting, 20

startup_seconds, 20

time_limit, 20

trace_level, 20

write_alert_log, 20

rules, 106

defining global, 106

defining schema, 106

defining subset, 106

defining table, 106

removing, 106

starting, 20

stopping, 20

CAPTURE_CURSOR_CACHE_SQLSET Procedure, 101

CAST_FROM_BINARY_DOUBLE function, 175

CAST_FROM_BINARY_FLOAT function, 175

CAST_FROM_BINARY_INTEGER function, 175

CAST_FROM_NUMBER function, 175

CAST_TO_BINARY_DOUBLE function, 175

CAST_TO_BINARY_FLOAT function, 175

CAST_TO_BINARY_INTEGER function, 175

CAST_TO_NUMBER function, 175

CAST_TO_NVARCHAR2 function, 175

CAST_TO_RAW function, 175

CAST_TO_VARCHAR2 function, 175

categorical binning, 26

catproc.sql script, 1

CELLSPRINT procedures, 149

CENTER function

of HTF package, 135

CENTER procedure

of HTP package, 140

CENTERCLOSE function

of HTF package, 135

CENTERCLOSE procedure

of HTP package, 140

CENTEROPEN function

of HTF package, 135

CENTEROPEN procedure

of HTP package, 140

CFG_GET function, 121

CFG_REFRESH procedure, 121

CFG_UPDATE procedure, 121

Change Data Capture

DBMS_CDC_PUBLISH package, 21

CHANGE functions and procedures, 146

CHANGE procedure, 48

change tables

tablespaces created in, 21

CHANGE_JOIN_POS procedure, 67

CHARARR Table Type, 68

CHECK_OBJECT procedure, 79

CHECKIN function, 122

CHECKOUT procedure, 122

CHECKPRIVILEGES function, 121

CHECKSUM functions, 145

CHNF$_DESC Object Type, 23

CHNF$_RDESC Object Type, 23

CHNF$_RDESC_ARRAY Object Type, 23

CHNF$_REG_INFO Object Type, 23

CHNF$_TDESC Object Type, 23

CHNF$_TDESC_ARRAY Object (Array) Type, 23

CHOOSE_DATE procedure, 149

CITE function

of HTF package, 135

CITE procedure

of HTP package, 140

CLEANUP_GATEWAY Procedure, 58

CLEANUP_INSTANTIATION_SETUP procedure, 106

CLEAR_ALL_CONTEXT Procedure, 96

CLEAR_CONTEXT Procedure, 96

CLEAR_COOKIES procedure, 169

CLEAR_EXPRSET_STATS procedure, 39

CLEAR_IDENTIFIER Procedure, 96

CLEAR_PENDING_AREA procedure, 85

CLEAR_PLSQL_TRACE procedure, 110

CLEAR_USED procedure, 66

CLEARKEYCOLUMNLIST procedure, 129, 131

CLEARUPDATECOLUMNLIST procedure, 129, 131

CLIENT_ID_STAT_DISABLE procedure, 60

CLIENT_ID_STAT_ENABLE procedure, 60

CLIENT_ID_TRACE_DISABLE procedure, 60

CLIENT_ID_TRACE_ENABLE procedure, 60

clipping

see trimming, 26

CLOB2FILE procedure, 133

CLONE_SIMPLE_TABLESPACE procedure, 109

CLONE_TABLESPACES procedure, 109

CLONENODE function, 125

CLOSE Procedure, 52

CLOSE_ALL_CONNECTIONS procedure, 179

CLOSE_CONNECTION procedure, 179

CLOSE_CURSOR Procedure, 45

CLOSE_CURSOR procedure, 100

CLOSE_ITERATOR procedure, 91

CLOSE_PERSISTENT_CONN procedure, 169

CLOSE_PERSISTENT_CONNS procedure, 169

CLOSECONTEXT procedure, 126, 128, 129, 131

CODE function

of HTF package, 135

CODE procedure

of HTP package, 140

collections

table items, 100, 100

column masking for VPD, 89

COLUMN_VALUE procedure, 100

COLUMN_VALUE_LONG procedure, 100

column-level VPD, 89

COMMA_TO_TABLE procedures, 116

COMMAND function and procedure, 178

COMMAND_REPLIES function, 178

COMMENT function

of HTF package, 135

COMMENT procedure

of HTP package, 140

COMMIT procedure, 111

COMMIT_COMMENT procedure, 111

COMMIT_FORCE procedure, 111

COMPARE function, 175

COMPARE Functions, 52

COMPARE_OLD_VALUES procedure, 15

COMPATIBLE_10_1 function, 105, 189

COMPATIBLE_10_2 function, 105, 189

COMPATIBLE_9_2 function, 105, 189

COMPILE_FROM_REMOTE procedure, 51

COMPILE_SCHEMA procedure, 116

COMPILESCHEMA procedure, 130

COMPUTE_CONFUSION_MATRIX procedure, 25

COMPUTE_LIFT procedure, 25

COMPUTE_ROC procedure, 25

CONCAT function, 175

CONFIGUREAUTOSYNC procedure, 123

conflicts

detection

stopping, 15

CONNECTION record type, 178

constants

DBMS_DATA_MINING, 25

DBMS_MGWMSG package, 59

CONSUME_EVENT procedure, 88

CONSUME_PRIM_EVENT procedure, 88

CONTINUE function, 30

CONVERT function, 53, 126, 175

CONVERT_ANYDATA_TO_LCR_DDL function, 105

CONVERT_ANYDATA_TO_LCR_ROW function, 105

CONVERT_LCR_TO_XML function, 105

CONVERT_LONG_TO_LOB_CHUNK member procedure, 189

CONVERT_RAW_VALUE procedures, 103

CONVERT_RAW_VALUE_NVARCHAR procedure, 103

CONVERT_RAW_VALUE_ROWID procedure, 103

CONVERT_XML_TO_LCR function, 105

CONVERTTOBLOB procedure, 52

CONVERTTOCLOB procedure, 52

COPIES function, 175

COPY Procedures, 52

COPY_ATTRIBUTE_SET procedure, 39

COPY_FILE procedure, 42

COPY_TABLE_DEPENDENTS procedure, 77

COPYEVOLVE procedure, 130

CREATE PACKAGE BODY command, 1

CREATE PACKAGE command, 1

CREATE_ALTER_TYPE_ERROR_TABLE procedure, 116

CREATE_APPLY procedure, 15

CREATE_ATTRIBUTE_SET procedure, 39

CREATE_BASELINE function and procedure, 119

CREATE_BIN_CAT procedure, 26

CREATE_BIN_NUM procedure, 26

CREATE_CALL function, 166

CREATE_CAPTURE procedure

capture process

creating, 20

CREATE_CLIP procedure, 26

CREATE_CONSUMER_GROUP procedure, 85

CREATE_DAD Procedure, 37

CREATE_EDIT_TABLES procedure, 67

CREATE_ERROR_LOG Procedure, 38

CREATE_EVALUATION_CONTEXT procedure, 92

CREATE_EVENT_STRUCTURE procedure, 88

CREATE_FILE Procedure, 12

CREATE_FILE_GROUP procedure, 41

CREATE_INDEX_COST procedure, 98

CREATE_MISS_CAT Procedure, 26

CREATE_MISS_CAT procedure, 26

CREATE_MISS_NUM Procedure, 26

CREATE_MISS_NUM procedure, 26

CREATE_MODEL procedure, 25

CREATE_MSGSYSTEM_LINK Procedure for TIB/Rendezvous, 58

CREATE_MSGSYSTEM_LINK Procedure for WebSphere MQ, 58

CREATE_NORM_LIN procedure, 26

CREATE_OBJECT Procedure, 12

CREATE_OBJECT_DEPENDENCY procedure, 15

CREATE_OUTLINE procedure, 66

CREATE_PENDING_AREA procedure, 85

CREATE_PIPE function, 70

CREATE_PLAN procedure, 85

CREATE_PLAN_DIRECTIVE procedure, 85

CREATE_PROPAGATION procedure, 74

CREATE_RULE procedure, 92

CREATE_RULE_CLASS procedure, 88

CREATE_RULE_SET procedure, 92

CREATE_SERVICE function, 166

CREATE_SERVICE procedure, 95

CREATE_SIMPLE_PLAN procedure, 85

CREATE_SNAPSHOT function and procedure, 119

CREATE_SQLSET procedure, 101

CREATE_SQLWKLD Procedure, 12

CREATE_STAT_TABLE procedure, 103

CREATE_STGTAB_SQLPROF Procedure, 101

CREATE_STGTAB_SQSET Procedure, 101

CREATE_TABLE_COST procedures, 98

CREATE_TASK Procedures, 12

CREATE_TRANSFORMATION procedure, 112

CREATE_TUNING_TASK functions, 101

CREATE_VERSION procedure, 41

CREATE_WRAPPED Procedure, 29

CREATEATTRIBUTE function, 125

CREATECDATASECTION function, 125

CREATECOMMENT function, 125

CREATEDATASTOREPREF procedure, 123

CREATEDOCUMENT function, 125

CREATEDOCUMENTFRAGMENT function, 125

CREATEELEMENT function, 125

CREATEENTITYREFERENCE function, 125

CREATEFILTERPREF procedure, 123

CREATEFOLDER function, 121

CREATEINDEX procedure, 123

CREATELEXERPREF procedure, 123

CREATENONSCHEMABASEDXML function, 198

CREATEOIDPATH function, 121

CREATEPREFERENCES procedure, 123

CREATEPROCESSINGINSTRUCTION function, 125

CREATERESOURCE function, 121

CREATESCHEMABASEDXML function, 198

CREATESECTIONGROUPPREF procedure, 123

CREATESTOPLISTPREF procedure, 123

CREATESTORAGEPREF procedure, 123

CREATETEMPORARY Procedures, 52

CREATETEXTNODE function, 125

CREATEURI function, 186, 186, 186

CREATEWORLDLISTPREF procedure, 123

CREATEXML function, 198

creating

packages, 1

CTX_ADM package documentation, 2

CTX_CLS package documentation, 3

CTX_DDL package documentation, 4

CTX_DOC package documentation, 5

CTX_OUTPUT package documentation, 6

CTX_QUERY package documentation, 7

CTX_REPORT package documentation, 8

CTX_THES package documentation, 9

CTX_ULEXER package documentation, 10

CURRENT_INSTANCE function, 116

cursors

DBMS_SQL package, 100

D

data dictionary

removing Streams information, 106

DATA function and procedure, 178

data mining

automated, 72

overview, 25

transformations, 26

data types

table of, 25, 26

DATA_BLOCK_ADDRESS_BLOCK function, 116

DATA_BLOCK_ADDRESS_FILE function, 116

database

locking

OWA_OPT_LOCK package, 145

database tables

creating for DBMS_TRACE, 110

DATABASE_TRACE_DISABLE Procedure, 60

DATABASE_TRACE_ENABLE Procedure, 60

datatypes

DBMS_DESCRIBE, 34

PL/SQL

numeric codes for, 34

DB_CONNECT_INFO Procedure, 58

DB_VERSION procedure, 116

DBA privileges

for DBMS_LOGSTDBY packages, 56

DBA privileges for the DBMS_LOGSTDBY package, 56

DBMS, 125

DBMS_ALERT package, 13

DBMS_APPLICATION_INFO package, 14

DBMS_APPLY_ADM package, 15

DBMS_AQADM Constants, 17

DBMS_AQELM package, 18

DBMS_AQIN package, 19

DBMS_CAPTURE package, 185

DBMS_CAPTURE_ADM package, 20

DBMS_CDC_PUBLISH package, 21

ALTER_AUTOLOG_CHANGE_SOURCE procedure, 21

ALTER_CHANGE_SET procedure, 21

ALTER_CHANGE_TABLE procedure, 21

ALTER_HOTLOG_CHANGE_SOURCE procedure, 21

CREATE_AUTOLOG_CHANGE_SOURCE procedure, 21

CREATE_CHANGE_SET procedure, 21

CREATE_CHANGE_TABLE procedure, 21

CREATE_HOTLOG_CHANGE_SOURCE procedure, 21

DROP_CHANGE_SET procedure, 21

DROP_CHANGE_SOURCE procedure, 21

DROP_CHANGE_TABLE procedure, 21, 21

DROP_SUBSCRIPTION procedure, 21

PURGE procedure, 21

PURGE_CHANGE_SET procedure, 21

PURGE_CHANGE_TABLE procedure, 21

DBMS_CDC_SUBSCRIBE package, 22

ACTIVATE_SUB SCRIPTION procedure, 22

CREATE_SUBSCRIPTION procedure, 22, 22

DROP_SUBSCRIBER_VIEW procedure, 22

DROP_SUBSCRIPTION procedure, 22

EXTEND_WINDOW procedure, 22

GET_SUBSCRIPTION_HANDLE procedure, 22

PREPARE_SUBSCRIBER_VIEW procedure, 22

PURGE_WINDOW procedure, 22

SUBSCRIBE procedure, 22

DBMS_CHANGE_NOTIFICATION package, 23

DBMS_DATA_MINING

constants, 25

data types, 25

introduction, 25

package, 25

subprograms, 25

user views, 25

DBMS_DATA_MINING_TRANSFORM

introduction, 26

package, 26

subprograms, 26

DBMS_DATAPUMP Package

GET_DUMPFILE_INFO procedure, 27

WAIT_FOR_JOB procedure, 27

DBMS_DATAPUMP package, 27

ADD_FILE procedure, 27

ATTACH function, 27

DATA_FILTER procedure, 27

DETACH procedure, 27

GET_STATUS procedure, 27

LOG_ENTRY procedure, 27

METADATA_FILTER procedure, 27

METADATA_REMAP procedure, 27

METADATA_TRANSFORM procedure, 27

OPEN function, 27

roles used by, 27

SET_PARALLEL procedure, 27

SET_PARAMETER procedure, 27

START_JOB procedure, 27

STOP_JOB procedure, 27

types used by, 27

DBMS_DB_VERSION package, 28

DBMS_DDL package, 29

DBMS_DEBUG package, 30

DBMS_DEFER package documentation, 31

DBMS_DEFER_QUERY package documentation, 32

DBMS_DEFER_SYS package documentation, 33

DBMS_DESCRIBE package, 34

DBMS_DIMENSION package, 35

DBMS_DISTRIBUTED_TRUST_ADMIN package, 36

DBMS_EPG package, 37, 37

DBMS_EXPFIL package, 39

ADD_ELEMENTARY_ATTRIBUTE, 39

ADD_FUNCTIONS, 39

ASSIGN_ATTRIBUTE_SET, 39

BUILD_EXCEPTIONS_TABLE, 39

CLEAR_EXPRSET_STATS, 39

COPY_ATTRIBUTE_SET, 39

CREATE_ATTRIBUTE_SET, 39

DEFAULT_INDEX_PARAMETERS, 39

DEFAULT_XPINDEX_PARAMETERS, 39

DEFRAG_INDEX, 39

DROP_ATTRIBUTE_SET, 39

GET_EXPRSET_STATS, 39

GRANT_PRIVILEGE, 39

INDEX_PARAMETERS, 39

MODIFY_OPERATOR_LIST, 39

REVOKE_PRIVILEGE, 39

UNASSIGN_ATTRIBUTE_SET, 39

VALIDATE_EXPRESSIONS, 39

XPINDEX_PARAMETERS, 39

DBMS_FGA package, 40

DBMS_FILE_GROUP package, 41

constants, 41

DBMS_FILE_TRANSFER package, 42

DBMS_FLASHBACK package, 43

DBMS_FREQUENT_ITEMSET package, 44

DBMS_HS_PASSTHROUGH package, 45

DBMS_IOT package, 46

DBMS_JAVA package documentation, 47

DBMS_JOB package, 48

DBMS_LDAP package documentation, 49

DBMS_LDAP_UTL package documentation, 50

DBMS_LIBCACHE package, 51

DBMS_LOB package, 52

DBMS_LOCK package, 53

DBMS_LOGMNR package, 54

ADD_LOGFILE procedure, 54

COLUMN_PRESENT function, 54

END_LOGMNR procedure, 54

MINE_VALUE function, 54

REMOVE_LOGFILE procedure, 54

START_LOGMNR procedure, 54

DBMS_LOGMNR_CDC_PUBLISH

See DBMS_CDC_PUBLISH, 21

DBMS_LOGMNR_CDC_SUBSCRIBE

See DBMS_CDC_SUBSCRIBE, 22

DBMS_LOGMNR_D package, 55

BUILD procedure, 55

SET_TABLESPACE procedure, 55

DBMS_LOGSTDBY package, 56

APPLY_SET procedure, 56

APPLY_UNSET procedure, 56

BUILD procedure, 56

case sensitivity, 56

deprecated subprograms, 56

INSTANTIATE_TABLE procedure, 56

operational notes, 56

overview of managing SQL Apply, 56

PREPARE_FOR_NEW_PRIMARY procedure, 56

privileges and security, 56

SKIP procedure, 56

SKIP_ERROR procedure, 56

SKIP_TRANSACTION procedure, 56

UNSKIP procedure, 56

UNSKIP_ERROR procedure, 56

UNSKIP_TRANSACTION procedure, 56

using, 56

DBMS_METADATA package, 57

ADD_TRANSFORM function, 57

CLOSE procedure, 57

CONVERT functions and procedures, 57

GET_DDL function, 57

GET_QUERY function, 57

GET_XML function, 57

OPEN function, 57

OPENW function, 57

PUT function, 57

security, 57

SET_COUNT procedure, 57

SET_FILTER procedure, 57

SET_PARSE_ITEM procedure, 57

SET_REMAP_PARAM procedure, 57

SET_TRANSFORM_PARAM procedure, 57

DBMS_MGWADM package

summary of subprograms, 58

DBMS_MGWMSG package

constants, 59

summary of subprograms, 59

DBMS_MONITOR package

stastics tracing and gathering

DBMS_MONITOR package, 60

DBMS_MVIEW package

BEGIN_TABLE_REORGANIZATION procedure, 61

END_TABLE_REORGANIZATION procedure, 61

EXPLAIN_MVIEW procedure, 61

EXPLAIN_REWRITE procedure, 61

I_AM_A_REFRESH function, 61

PMARKER function, 61

PURGE_DIRECT_LOAD_LOG procedure, 61

PURGE_LOG procedure, 61

PURGE_MVIEW_FROM_LOG procedure, 61

REFRESH procedure, 61

REFRESH_ALL_MVIEWS procedure, 61

REFRESH_DEPENDENT procedure, 61

REGISTER_MVIEW procedure, 61

UNREGISTER_MVIEW procedure, 61

DBMS_OBFUSCATION_TOOLKIT package, 62

DBMS_ODCI package, 63

ESTIMATE_CPU_UNITS function, 63

methods, 63

DBMS_OFFLINE_OG package documentation, 64

DBMS_OLAP package, 65

DBMS_OUTLN package, 66

DBMS_OUTLN_EDIT package, 67

DBMS_OUTPUT package, 68

DBMS_PCLXUTIL package, 69

DBMS_PIPE package, 70

DBMS_PREDICTIVE_ANALYTICS package, 72

DBMS_PREPROCESSOR package, 71

DBMS_PROFILER package, 73

DBMS_PROPAGATION_ADM package, 74

DBMS_RANDOM package, 75

DBMS_RECTIFIER_DIFF package documentation, 76

DBMS_REDEFINITION package, 77

DBMS_REFRESH package documentation, 78

DBMS_REPAIR package, 79

DBMS_REPCAT package documentation, 80

DBMS_REPCAT_ADMIN package documentation, 81

DBMS_REPCAT_INSTANTIATE package documentation, 82

DBMS_REPCAT_RGT package documentation, 83

DBMS_REPUTIL package documentation, 84

DBMS_RESOURCE_MANAGER package, 85

DBMS_RESOURCE_MANAGER_PRIVS package, 86

DBMS_RESUMABLE package, 87

DBMS_RLMGR package, 88

ADD_ELEMENTARY_ATTRIBUTE, 88

ADD_EVENT, 88

ADD_FUNCTIONS, 88

ADD_RULE, 88

CONSUME_EVENT, 88

CONSUME_PRIM_EVENT, 88

CREATE_EVENT_STRUCTURE, 88

CREATE_RULE_CLASS, 88

DELETE_RULE, 88

DROP_EVENT_STRUCTURE, 88

DROP_RULE_CLASS, 88

GRANT_PRIVILEGE, 88

PROCESS_RULES, 88

RESET_SESSION, 88

REVOKE_PRIVILEGE, 88

DBMS_RLS package, 89

DBMS_RLS.ADD_GROUPED_POLICY parameters

enable, 89

function_schema, 89

long_predicate, 89

object_name, 89

object_schema, 89

policy_function, 89

policy_group, 89

policy_name, 89

policy_type, 89

sec_relevant_cols, 89

statement_types, 89

static_policy, 89

update_check, 89

DBMS_RLS.ADD_POLICY parameters

enable, 89

function_schema, 89

long_predicate, 89

object_name, 89

object_schema, 89

policy_function, 89

policy_name, 89

policy_type, 89

sec_relevant_cols, 89

sec_relevant_cols_opt, 89

statement_types, 89

static_policy, 89

update_check, 89

DBMS_RLS.ADD_POLICY policy types

CONTEXT_SENSITIVE, 89

DYNAMIC, 89

SHARED_CONTEXT_SENSITIVE, 89

SHARED_STATIC, 89

STATIC, 89

DBMS_RLS.ADD_POLICY_CONTEXT parameters

attribute, 89

namespace, 89

object_name, 89

object_schema, 89

DBMS_RLS.CREATE_POLICY_GROUP parameters

object_name, 89

object_schema, 89

policy_group, 89

DBMS_RLS.DELETE_POLICY_GROUP parameters

object_name, 89

object_schema, 89

policy_group, 89

DBMS_RLS.DISABLE_GROUPED_POLICY parameters

group_name, 89

object_name, 89

object_schema, 89

policy_name, 89

DBMS_RLS.DROP_GROUPED_POLICY parameters

object_name, 89, 89

object_schema, 89, 89

policy_group, 89

policy_name, 89, 89

DBMS_RLS.DROP_POLICY_CONTEXT parameters

attribute, 89

namespace, 89

object_name, 89

object_schema, 89

DBMS_RLS.ENABLE_GROUPED_POLICY parameters

enable, 89

group_name, 89

object_name, 89

object_schema, 89

policy_name, 89

DBMS_RLS.ENABLE_POLICY parameters

enable, 89

object_name, 89

object_schema, 89

policy_name, 89

DBMS_RLS.REFRESH_GROUPED_POLICY parameters

group_name, 89

object_name, 89

object_schema, 89

policy_name, 89

DBMS_RLS.REFRESH_POLICY parameters

object_name, 89

object_schema, 89

policy_name, 89

DBMS_ROWID package, 90

DBMS_RULE package, 91

DBMS_RULE_ADM package, 92

DBMS_SCHEDULER package, 93

DBMS_SERVER_ALERT package, 94

DBMS_SERVICE package, 95

DBMS_SESSION package, 96

DBMS_SHARED_POOL package, 97

DBMS_SPACE package, 98

DBMS_SPACE_ADMIN package, 99

DBMS_SQL package, 100

DBMS_SQLTUNE package, 101

DBMS_STAT_FUNCS package, 102

DBMS_STATS package, 103

DBMS_STORAGE_MAP package, 104

DBMS_STREAMS package, 105

DBMS_STREAMS_ADM package, 106

deprecated subprograms, 106

DBMS_STREAMS_AUTH package, 107

DBMS_STREAMS_MESSAGING package, 108

DBMS_STREAMS_TABLESPACE package, 109

DBMS_TDB package, 113

DBMS_TDB.CHECK_DB procedure, 113, 113

DBMS_TRACE package, 110

DBMS_TRANSACTION package, 111

DBMS_TRANSFORM package, 112

DBMS_TTS package, 114

DBMS_TYPES package, 115

DBMS_UTILITY package, 116

DBMS_WARNING package, 117

DBMS_WM package documentation, 120

DBMS_WORKLOAD_RECORD package, 118

DBMS_WORKLOAD_REPOSITORY package, 119

DBMS_XBD_VERSION package, 122

DBMS_XDB Constants, 121

DBMS_XDB Overview, 121

DBMS_XDB package, 121

ACLCHECKPRIVILEGES function, 121

CFG_GET function, 121

CFG_REFRESH procedure, 121

CFG_UPDATE procedure, 121

CHECKPRIVILEGES function, 121

CONFIGUREAUTOSYNC procedure, 123

constants, 121

ConText synchronization settings, 123

CREATEDATASTOREPREF procedure, 123

CREATEFILTERPREF procedure, 123

CREATEFOLDER function, 121

CREATEINDEX procedure, 123

CREATELEXERPREF procedure, 123

CREATEOIDPATH function, 121

CREATEPREFERENCES procedure, 123

CREATERESOURCE function, 121

CREATESECTIONGROUPPREF procedure, 123

CREATESTOPLISTPREF procedure, 123

CREATESTORAGEPREF procedure, 123

CREATEWORLDLISTPREF procedure, 123

DELETERESOURCE procedure, 121

DROPPREFERENCES procedure, 123

EXISTSRESOURCE function, 121

filtering settings, 123

general indexing settings, 123

GETACLDOCUMENT function, 121

GETLOCKTOKEN procedure, 121

GETRESOID function, 121

GETXDB_TABLESPACE function, 121

LINK procedure, 121

LOCKRESOURCE function, 121

methods, 121, 123

miscellaneous settings, 123

MOVEXDB_TABLESPACE procedure, 121

other index preference settings, 123

REBUILDHIERARCHICALINDEX procedure, 121

RENAMERESOURCE procedure, 121

sectioning and section group settings, 123

SETACL procedure, 121

stoplist settings, 123

SYNC settings, 123

UNLOCKRESOURCE function, 121

DBMS_XDB_VERSION package

CHECKIN function, 122

CHECKOUT procedure, 122

GETCONTENTSBLOBBYRESID function, 122

GETCONTENTSCLOBBYRESID function, 122

GETCONTENTSXMLBYRESID function, 122

GETPREDECESSORS function, 122

GETPREDSBYRESID function, 122

GETRESOURCEBYRESID function, 122

GETSUCCESSORS function, 122

GETSUCCSBYRESID function, 122

MAKEVERSIONED function, 122

UNCHECKOUT function, 122

DBMS_XDBZ package

DISABLE_HIERARCHY procedure, 124

ENABLE_HIERARCHY procedure, 124

GET_ACLOID function, 124

GET_USERID function, 124

IS_HIERARCHY_ENABLED function, 124

PURGELDAPCACHE function, 124

DBMS_XMLDOM Constants, 125

DBMS_XMLDOM package, 125

APPENDDATA procedure, 125

CREATEATTRIBUTE function, 125

CREATECDATASECTION function, 125

CREATECOMMENT function, 125

CREATEDOCUMENT function, 125

CREATEDOCUMENTFRAGMENT, 125

CREATEELEMENT function, 125

CREATEENTITYREFERENCE function, 125

CREATEPROCESSINGINSTRUCTION function, 125

CREATETEXTNODE function, 125

DELETEDATA procedure, 125

description, 125

exceptions, 125

FINDENTITY function, 125

FINDNOTATION function, 125

FREEDOCFRAG procedure, 125

FREEDOCUMENT procedure, 125

GETATTRIBUTE function, 125

GETATTRIBUTENODE function, 125

GETBUBLICID function, 125

GETCHARSET function, 125

GETCHILDRENBYTAGNAME function, 125

GETDATA function, 125

GETDOCTYPE function, 125

GETDOCUMENTELEMENT function, 125

GETELEMENTSBYTAGNAME function, 125, 125

GETENTITIES function, 125

GETEXPANDEDNAME function, 125, 125

GETIMPLEMENTATION function, 125

GETLENGTH function, 125, 125, 125

GETNAME function, 125, 125

GETNAMEDITEM function, 125

GETNAMESPACE function, 125, 125

GETNAMESPACE procedure, 125

GETNEXTSIBLING function, 125

GETNODENAME function, 125

GETNODETYPE function, 125

GETNODEVALUE function, 125

GETNOTATIONNAME function, 125

GETNOTATIONS function, 125

GETOWNERDOCUMENT function, 125

GETOWNERELEMENT function, 125

GETPARENTNODE function, 125

GETPREFIX function, 125

GETPREVIOUSSIBLING function, 125

GETPUBLICID function, 125, 125

GETQUALIFIEDNAME function, 125, 125

GETSCHEMANODE function, 125

GETSPECIFIED function, 125

GETSTANDALONE function, 125

GETSYSTEMID function, 125, 125, 125

GETTAGNAME function, 125

GETTARGET function, 125

GETVALUE function, 125

GETVERSION function, 125

GETXMLTYPE function, 125

HASATTRIBUTE function, 125

HASATTRIBUTES function, 125

HASCHILDNODES function, 125

HASFEATURE function, 125

IMPORTNODE function, 125

INSERTBEFORE function, 125

INSERTDATA procedure, 125

ISNULL function, 125

MAKEATTR function, 125

MAKECDATASECTION function, 125

MAKECHARACTERDATA function, 125

MAKECOMMENT function, 125

MAKEDOCUMENT function, 125

MAKEDOCUMENTFRAGMENT function, 125

MAKEDOCUMENTTYPE function, 125

MAKEELEMENT function, 125

MAKEENTITY function, 125

MAKEENTITYREFERENCE function, 125

MAKENODE function, 125, 125, 125, 125

MAKENOTATION function, 125

MAKEPROCESSINGINSTRUCTION function, 125

MAKETEXT function, 125

methods

APPENDCHILD function, 125

APPENDDATA procedure, 125

CLONENODE function, 125

CREATEATTRIBUTE function, 125

CREATECDATASECTION function, 125

CREATECOMMENT function, 125

CREATEDOCUMENT function, 125

CREATEDOCUMENTFRAGMENT function, 125

CREATEELEMENT function, 125

CREATEENTITYREFERENCE function, 125

CREATEPROCESSINGINSTRUCTION function, 125

CREATETEXTNODE function, 125

DELETEDATA procedure, 125

DOMAttr interface, 125

DOMCDataSection interface, 125

DOMCharacterData interface, 125

DOMComment interface, 125

DOMDocument interface, 125

DOMDocumentFragment interface, 125, 125

DOMDocumentType interface, 125, 125

DOMElement interface, 125, 125

DOMEntity interface, 125, 125

DOMEntityReference interface, 125

DOMImplementation interface, 125

DOMNamedNodeMap interface, 125

DOMNode, 125, 125, 125, 125, 125, 125, 125, 125, 125

DOMNodeList interface, 125

DOMNotation interface, 125

DOMProcessingInstruction interface, 125

DOMText interface, 125, 125

FINDENTITY function, 125

FINDNOTATION function, 125

FREEDOCFRAG procedure, 125

FREEDOCUMENT procedure, 125

FREENODE procedure, 125

GETATTRIBUTE function, 125

GETATTRIBUTENODE function, 125

GETATTRIBUTES function, 125

GETBUBLICID function, 125

GETCHARSET function, 125

GETCHILDNODES function, 125

GETCHILDRENBYTAGNAME function, 125

GETDATA function, 125

GETDOCTYPE function, 125

GETDOCUMENTELEMENT function, 125

GETELEMENTSBYTAGNAME function, 125, 125

GETENTITIES function, 125

GETEXPANDEDNAME function, 125, 125

GETEXPANDEDNAME procedure, 125

GETFIRSTCHILD function, 125

GETIMPLEMENTATION function, 125

GETLASTCHILD function, 125

GETLENGTH function, 125, 125, 125

GETLOCALNAME procedure, 125

GETNAME function, 125, 125

GETNAMEDITEM function, 125

GETNAMESPACE function, 125, 125

GETNAMESPACE procedure, 125

GETNEXTSIBLING function, 125

GETNODENAME function, 125

GETNODETYPE function, 125

GETNODEVALUE function, 125

GETNOTATIONNAME function, 125

GETNOTATIONS function, 125

GETOWNERDOCUMENT function, 125

GETOWNERELEMENT function, 125

GETPARENTNODE function, 125

GETPREFIX function, 125

GETPREVIOUSSIBLING function, 125

GETPUBLICID function, 125, 125

GETQUALIFIEDNAME function, 125, 125

GETSCHEMANODE function, 125

GETSPECIFIED function, 125

GETSTANDALONE function, 125

GETSYSTEMID function, 125, 125, 125

GETTAGNAME function, 125

GETTARGET function, 125

GETVALUE function, 125

GETVERSION function, 125

GETXMLTYPE function, 125

HASATTRIBUTE function, 125

HASATTRIBUTES function, 125

HASCHILDNODES function, 125

HASFEATURE function, 125

IMPORTNODE function, 125

INSERTBEFORE function, 125

INSERTDATA procedure, 125

ISNULL function, 125

MAKEATTR function, 125

MAKECDATASECTION function, 125

MAKECHARACTERDATA function, 125

MAKECOMMENT function, 125

MAKEDOCUMENT function, 125

MAKEDOCUMENTFRAGMENT function, 125

MAKEDOCUMENTTYPE function, 125

MAKEELEMENT function, 125

MAKEENTITY function, 125

MAKEENTITYREFERENCE function, 125

MAKENODE function, 125, 125, 125, 125

MAKENOTATION function, 125

MAKEPROCESSINGINSTRUCTION function, 125

MAKETEXT function, 125

NEWDOMDOCUMENT function, 125

NORMALIZE procedure, 125

REMOVEATTRIBUTE procedure, 125

REMOVEATTRIBUTENODE function, 125

REMOVENAMEDITEM function, 125

REPLACECHILD function, 125

REPLACEDATA procedure, 125

RESOLVENAMESPACEPREFIX function, 125

SETATTRIBUTE procedure, 125

SETATTRIBUTENODE function, 125

SETCHARSET procedure, 125

SETDATA procedure, 125

SETNAMEDITEM function, 125

SETNODEVALUE procedure, 125

SETPREFIX procedure, 125

SETSTANDALONE procedure, 125

SETVALUE procedure, 125

SETVERSION procedure, 125

SPLITTEXT function, 125

SUBSTRINGDATA function, 125

WRITETOBUFFER procedure, 125

WRITETOCLOB procedure, 125

WRITETOFILE procedure, 125

NEWDOMDOCUMENT function, 125

NORMALIZE procedure, 125

REMOVEATTRIBUTE procedure, 125

REMOVEATTRIBUTENODE function, 125

REMOVENAMEDITEM function, 125

REPLACECHILD function, 125

REPLACEDATA procedure, 125

RESOLVENAMESPACEPREFIX function, 125

SETATTRIBUTE procedure, 125

SETATTRIBUTENODE function, 125

SETCHARSET procedure, 125

SETDATA procedure, 125

SETNAMEDITEM function, 125

SETNODEVALUE procedure, 125

SETPREFIX procedure, 125

SETSTANDALONE procedure, 125

SETVALUE procedure, 125

SETVERSION procedure, 125

SPLITTEXT function, 125

SUBSTRINGDATA function, 125

types, 125

WRITETOBUFFER procedure, 125

WRITETOCLOB procedure, 125

WRITETOFILE procedure, 125

DBMS_XMLGEN package, 126

CLOSECONTEXT procedure, 126

CONVERT function, 126

GETNUMROWSPROCESSED function, 126

GETXML function, 126

GETXMLTYPE function, 126

NEWCONTEXT function, 126

RESTARTQUERY procedure, 126

SETCONVERTSPECIALCHARS procedure, 126

SETMAXROWS procedure, 126

SETROWSETTAG procedure, 126

SETROWTAG procedure, 126

SETSKIPROWS procedure, 126

USEITEMTAGSFORCOLL procedure, 126

USENULLATTRIBUTEINDICATOR procedure, 126

DBMS_XMLPARSER package, 127

FREEPARSER procedure, 127

GETDOCTYPE function, 127

GETDOCUMENT function, 127

GETRELEASEVERSION function, 127

GETVALIDATIONMODE function, 127

NEWPARSER function, 127

PARSE function, 127, 127

PARSE procedure, 127

PARSEBUFFER procedure, 127

PARSECLOB procedure, 127

PARSEDTD procedure, 127

PARSEDTDBUFFER procedure, 127

PARSEDTDCLOB procedure, 127

SETBASEDIR procedure, 127

SETDOCTYPE procedure, 127

SETERRORLOG procedure, 127

SETPRESERVEWHITESPACE procedure, 127

SETVALIDATIONMODE procedure, 127

SHOWWARNINGS procedure, 127

DBMS_XMLQUERY package, 128

CLOSECONTEXT procedure, 128

constants, 128

GETDTD function, 128

GETDTD procedure, 128

GETEXCEPTIONCONTENT procedure, 128

GETNUMROWSPROCESSED procedure, 128

GETVERSION procedure, 128

GETXML function, 128

GETXML procedure, 128

NEWCONTEXT function, 128

PROPAGATEORIGINALEXCEPTION procedure, 128

REMOVEXSLTPARAM procedure, 128

SETBINDVALUE procedure, 128

SETCOLLIDATTRNAME procedure, 128

SETDATAHEADER procedure, 128

SETDATEFORMAT procedure, 128

SETENCODINGTAG procedure, 128

SETERRORTAG procedure, 128

SETMAXROWS procedure, 128

SETMETAHEADER procedure, 128

SETRAISEEXCEPTION procedure, 128

SETRAISENOROWSEXCEPTION procedure, 128

SETROWIDATTRNAME procedure, 128

SETROWIDATTRVALUE procedure, 128

SETROWSETTAG procedure, 128

SETROWTAG procedure, 128

SETSKIPROWS procedure, 128

SETSQLTOXMLNAMEESCAPING procedure, 128

SETSTYLESHEETHEADER procedure, 128

SETTAGCASE procedure, 128

SETXSLT procedure, 128

SETXSLTPARAM procedure, 128

types, 128

USENULLATTRIBUTEINDICATOR procedure, 128

USETYPEFORCOLLELEMTAG procedure, 128

DBMS_XMLSAVE package, 129

CLEARKEYCOLUMNLIST procedure, 129

CLEARUPDATECOLUMNLIST procedure, 129

CLOSECONTEXT procedure, 129

constants, 129

DELETEXML function, 129

GETEXCEPTIONCONTENT procedure, 129

INSERTXML function, 129

NEWCONTEXT function, 129

PROPAGATEORIGINALEXCEPTION procedure, 129

REMOVEXSLTPARAM procedure, 129

SETBATCHSIZE procedure, 129

SETCOMMITBATCH procedure, 129

SETDATEFORMAT procedure, 129

SETIGNORECASE procedure, 129

SETKEYCOLUMN procedure, 129

SETPRESERVEWHITESPACE procedure, 129

SETROWTAG procedure, 129

SETSQLTOXMLNAMEESCAPING procedure, 129

SETUPDATECOLUMN procedure, 129

SETXSLT procedure, 129

SETXSLTPARAM procedure, 129

UPDATEXML function, 129

DBMS_XMLSCHEMA Constants, 130

DBMS_XMLSCHEMA package, 130

COMPILESCHEMA procedure, 130

COPYEVOLVE procedure, 130

DELETESCHEMA procedure, 130

GENERATEBEAN procedure, 130

GENERATESCHEMA function, 130

GENERATESCHEMAS function, 130

REGISTERSCHEMA procedure, 130

REGISTERURI procedure, 130

DBMS_XMLSCHEMA Views, 130

DBMS_XMLSTORE package, 131

CLEARKEYCOLUMNLIST procedure, 131

CLEARUPDATECOLUMNLIST procedure, 131

CLOSECONTEXT procedure, 131

DELETEXML function, 131

INSERTXML function, 131

NEWCONTEXT function, 131

SETKEYCOLUMN procedure, 131

SETROWTAG procedure, 131

SETUPDATECOLUMN procedure, 131

types, 131

UPDATEXML function, 131

DBMS_XPLAN package, 132

DBMS_XSLPROCESSOR Package, 133, 133

DBMS_XSLPROCESSOR package

CLOB2FILE procedure, 133

FREEPROCESSOR procedure, 133

FREESTYLESHEET procedure, 133

NEWPROCESSOR function, 133

NEWSTYLESHEET function, 133

PROCESSXSL function, 133

READ2CLOB function, 133

REMOVEPARAM procedure, 133

RESETPARAMS procedure, 133

SELECTNODES function, 133

SELECTSINGLENODE function, 133

SETERRORLOG procedure, 133

SETPARAM procedure, 133

SHOWWARNINGS procedure, 133

TRANSFORMNODE function, 133

VALUEOF procedure, 133

DBMSOUTPUT_LINESARRAY Object Type, 68

DBUriType, 186

DBURITYPE function, 186

DBUriType subtype, 186

CREATEURI function, 186

DBURITYPE function, 186

GETBLOB function, 186

GETCLOB function, 186

GETCONTENTTYPE function, 186

GETEXTERNALURL function, 186

GETURL function, 186

GETXML function, 186

methods, 186

DEAUTHORIZE_DAD Procedure, 37

DEBUG_EXPTOC package, 134

DEBUG_ON procedure, 30

DECLARE_REWRITE_EQUIVALENCE Procedures, 11

DEFAULT_INDEX_PARAMETERS procedure, 39

DEFAULT_XPINDEX_PARAMETERS procedure, 39

DEFINE_ARRAY procedure, 100

DEFINE_COLUMN procedure, 100

DEFINE_COLUMN_LONG procedure, 100

DEFRAG_INDEX procedure, 39

DELETE_ALL_ERRORS procedure, 15

DELETE_BREAKPOINT function, 30

DELETE_CAPTURE_INFO Procedure, 118

DELETE_COLUMN member procedure, 189

DELETE_COLUMN procedure, 106

DELETE_COLUMN_STATS pocedure, 103

DELETE_CONSUMER_GROUP procedure, 85

DELETE_DAD_ATTRIBUTE Procedure, 37, 37

DELETE_DATABASE_STATS procedure, 103

DELETE_DICTIONARY_STATS procedure, 103

DELETE_ERROR procedure, 15

DELETE_FILTER Procedure, 118

DELETE_FIXED_OBJECTS_STATS procedure, 103

DELETE_INDEX_STATS procedure, 103

DELETE_OBJECT procedure, 177

DELETE_OER_BREAKPOINT function, 30

DELETE_PLAN procedure, 85

DELETE_PLAN_CASCADE procedure, 85

DELETE_PLAN_DIRECTIVE procedure, 85

DELETE_RULE procedure, 88

DELETE_SCHEMA_STATS Procedure, 103

DELETE_SERVICE procedure, 95

DELETE_SQLSET procedure, 101

DELETE_SQLWKLD Procedure, 12

DELETE_SQLWKLD_REF Procedure, 12

DELETE_SQLWKLD_STATEMENT Procedure, 12

DELETE_SYSTEM_STATS procedure, 103

DELETE_TABLE_STATS procedure, 103

DELETE_TASK Procedure, 12

DELETEDATA procedure, 125

DELETERESOURCE procedure, 121

DELETERESOURCEMETADATA Procedures, 121

DELETESCHEMA procedure, 130

DELETEXML function, 129, 131

DEQUEUE procedure, 108

DEQUEUE_ARRAY Function, 16

DEQUEUE_OPTIONS_T Type, 185

DEREGISTER Procedure, 23

DESCRIBE_COLUMNS procedure, 100

DESCRIBE_COLUMNS2 procedure, 100

DESCRIBE_DIMENSION procedure, 35

DESCRIBE_PROCEDURE procedure, 34

DESDecrypt procedure, 62, 62

DESEncrypt procedure, 62

DETACH_SESSION procedure, 30

DETACH_SIMPLE_TABLESPACE procedure, 109

DETACH_TABLESPACES procedure, 109

DFN function

of HTF package, 135

DFN procedure

of HTP package, 140

DIRECTORY_OBJECT_SET type, 109

DIRLISTCLOSE function

of HTF package, 135

DIRLISTCLOSE procedure

of HTP package, 140

DIRLISTOPEN function

of HTF package, 135

DIRLISTOPEN procedure

of HTP package, 140

DISABLE procedure

of DBMS_FLASHBACK package, 43

of DBMS_OUTPUT package, 68

of OWA_CACHE package, 141

DISABLE_BREAKPOINT function, 30

DISABLE_HIERARCHY procedure, 124

DISABLE_PROPAGATION_SCHEDULE Procedure, 58

DISCONNECT_SESSION procedure, 95

DISPLAY function, 132

DISPLAY_AWR function, 132

DISPLAY_CURSOR function, 132

DISPLAY_SQLSET Function, 132

DIV function

of HTF package, 135

DIV procedure

of HTP package, 140

DLISTCLOSE function

of HTF package, 135

DLISTCLOSE procedure

of HTP package, 140

DLISTDEF function

of HTF package, 135

DLISTDEF procedure

of HTP package, 140

DLISTOPEN function

of HTF package, 135

DLISTOPEN procedure

of HTP package, 140

DLISTTERM function

of HTF package, 135

DLISTTERM procedure

of HTP package, 140

DOMAttr methods, 125

DOMCDataSection methods, 125

DOMCharacterData methods, 125

DOMComment methods, 125

DOMDocument methods, 125

DOMDocumentType methods, 125, 125

DOMEntity methods, 125

DOMNamedNodeMap methods, 125

DOMText methods, 125

DOWNGRADE procedure, 114

DOWNLOAD_FILE procedures, 181

DROP_ALL function, 104

DROP_APPLY procedure, 15

DROP_ATTRIBUTE_SET procedure, 39

DROP_BASELINE procedure, 119

DROP_BY_CAT procedure, 66

DROP_CAPTURE procedure

capture process

dropping, 20

DROP_DAD Procedure, 37

DROP_EDIT_TABLES procedure, 67

DROP_EVALUATION_CONTEXT procedure, 92

DROP_EVENT_STRUCTURE procedure, 88

DROP_FILE function, 104

DROP_FILE_GROUP procedure, 41

DROP_MODEL procedure, 25

DROP_OBJECT_DEPENDENCY procedure, 15

DROP_PROPAGATION procedure, 74

DROP_REWRITE_EQUIVALENCE Procedure, 11

DROP_RULE procedure, 92

DROP_RULE_CLASS procedure, 88

DROP_RULE_SET procedure, 92

DROP_SNAPSHOT_RANGE procedure, 119

DROP_SQL_PROFILE procedure, 101

DROP_SQLSETprocedure, 101

DROP_STAT_TABLE procedure, 103

DROP_TRANSFORMATION procedure, 112

DROP_TUNING_TASK procedure, 101

DROP_UNUSED procedure, 66

DROP_VERSION procedure, 41

DROPPREFERENCES procedure, 123

DUMP_ORPHAN_KEYS procedure, 79

dynamic SQL

anonymous blocks and, 100

DBMS_SQL functions, using, 100

execution flow in, 100

E

EHLO function and procedure, 178

EM function

of HTF package, 135

EM procedure

of HTP package, 140

e-mail from PL/SQL (email), 179

EMPHASIS function

of HTF package, 135

EMPHASIS procedure

of HTP package, 140

ENABLE procedure, 68

ENABLE_AT_SYSTEM_CHANGE_NUMBER procedure, 43

ENABLE_AT_TIME procedure, 43

ENABLE_BREAKPOINT function, 30

ENABLE_HIERARCHY procedure, 124

ENABLE_PROPAGATION_SCHEDULE Procedure, 58

END_REQUEST procedure, 169

END_RESPONSE procedure, 169

ENDCREATE member procedure

of ANYDATA TYPE, 182

of ANYDATASET TYPE, 183

of ANYTYPE TYPE, 184

ENQUEUE procedure, 108

ENQUEUE_ARRAY Function, 16

ENQUEUE_OPTIONS_T Type, 185

ERASE Procedures, 52

error queue

deleting errors, 15, 15

executing errors, 15, 15

getting error messages, 15

errors

DBMS_DATA_MINING, 25

ESCAPE function, 180

ESCAPE_SC function

of HTF package, 135

ESCAPE_SC procedure

of HTP package, 140

ESCAPE_URL function

of HTF package, 135

ESCAPEURI function, 186

ESTIMATE_CPU_UNITS function, 63

ESTIMATE_MVIEW_SIZE Procedure, 61

ETINSTANCE member function

of ANYDATASET TYPE, 183

EVALUATE procedure, 91

EXACT_TEXT_SIGNATURES procedure, 66

EXEC_DDL_STATEMENT procedure, 116

EXECUTE function, 100

EXECUTE member procedure, 189, 189

EXECUTE procedure, 30

EXECUTE_ALL_ERRORS procedure, 15

EXECUTE_AND_FETCH function, 100

EXECUTE_ERROR procedure, 15

EXECUTE_IMMEDIATE Procedure, 45

EXECUTE_NON_QUERY Function, 45

EXECUTE_TASK Procedure, 12

EXECUTE_TUNING_TASK procedure, 101

execution flow

in dynamic SQL, 100

EXF$ATTRIBUTE object type, 187

EXF$ATTRIBUTE_LIST object type, 187

EXF$INDEXOPER object type, 187

EXF$TABLE_ALIAS object type, 187

EXF$XPATH_TAG object type, 187

EXF$XPATH_TAGS object type, 187

EXISTSNODE function, 198

EXISTSRESOURCE function, 121

EXPAND_MESSAGE function, 94

EXPLAIN procedure, 72

EXPONENTIAL_DIST_FIT procedure, 102

EXPORT_AWR Procedure, 118

EXPORT_COLUMN_STATS procedure, 103

EXPORT_DATABASE_STATS procedure, 103

EXPORT_DICTIONARY_STATS procedure, 103

EXPORT_FIXED_OBJECTS_STATS procedure, 103

EXPORT_INDEX_STATS procedure, 103

EXPORT_MODEL procedure, 25

EXPORT_SCHEMA_STATS procedure, 103

EXPORT_SYSTEM_STATS procedure, 103

EXPORT_TABLE_STATS procedure, 103

Expression Filter object types, 187

extend window

to create a new view, 22

EXTRACT function, 198

F

FCLOSE procedure, 168

FCLOSE_ALL procedure, 168

FCOPY procedure, 168

features, new, Preface

FETCH_ROW Function, 45

FETCH_ROWS function, 100

FFLUSH procedure, 168

FGETATTR procedure, 168

FGETPOS function, 168

FI_HORIZONTAL function, 44

FI_TRANSACTIONAL function, 44

file groups, 41

adding files, 41

altering, 41

altering files, 41

altering versions, 41

creating, 41

creating versions, 41

dropping, 41

dropping versions, 41

granting object privileges, 41

granting system privileges, 41

purging, 41

removing files, 41

revoking object privileges, 41

revoking system privileges, 41

FILE type, 109

FILE_SET type, 109

FILECLOSE Procedure, 52

FILECLOSEALL Procedure, 52

FILEEXISTS Function, 52

FILEGETNAME Procedure, 52

FILEISOPEN Function, 52

FILEOPEN Procedure, 52

FINDENTITY function, 125

FINDNOTATION function, 125

fine-grained access control

DBMS_RLS package, 89

FINISH_CAPTURE Procedure, 118

FINISH_REDEF_TABLE procedure, 77

FIX_CORRUPT_BLOCKS procedure, 79

FLUSH procedure, 179

FLUSH_DATA function and procedure, 73

FLUSH_DATABASE_MONITORING_INFO procedure, 103

FONTCLOSE function

of HTF package, 135

FONTCLOSE procedure

of HTP package, 140

FONTOPEN function

of HTF package, 135

FONTOPEN procedure

of HTP package, 140

FOPEN function, 168

FOPEN_NCHAR function, 168

FORCE parameter

and job-to-instance affinity, 48

FORMAT_CALL_STACK Function, 116

FORMAT_CELL function

of HTF package, 135

FORMAT_ERROR_BACKTRACE function, 116

FORMAT_ERROR_STACK function, 116

FORMCHECKBOX function

of HTF package, 135

FORMCHECKBOX procedure

of HTP package, 140

FORMCLOSE function

of HTF package, 135, 135

FORMCLOSE procedure

of HTP package, 140

FORMFILE function

of HTF package, 135

FORMFILE procedure

of HTP package, 140, 140

FORMHIDDEN function

of HTF package, 135

FORMHIDDEN procedure

of HTP package, 140

FORMIMAGE function

of HTF package, 135

FORMIMAGE procedure

of HTP package, 140

FORMOPEN function

of HTF package, 135

FORMOPEN procedure

of HTP package, 140

FORMPASSWORD function

of HTF package, 135

FORMPASSWORD procedure

of HTP package, 140

FORMRADIO function

of HTF package, 135

FORMRADIO procedure

of HTP package, 140

FORMRESET function

of HTF package, 135

FORMRESET procedure

of HTP package, 140

FORMSELECTCLOSE function

of HTF package, 135

FORMSELECTCLOSE procedure

of HTP package, 140

FORMSELECTOPEN function

of HTF package, 135

FORMSELECTOPEN procedure

of HTP package, 140

FORMSELECTOPTION function

of HTF package, 135

FORMSELECTOPTION procedure

of HTP package, 140

FORMSUBMIT function

of HTF package, 135

FORMSUBMIT procedure

of HTP package, 140

FORMTEXT function

of HTF package, 135

FORMTEXT procedure

of HTP package, 140

FORMTEXTAREA function

of HTF package, 135

FORMTEXTAREA procedure

of HTP package, 140

FORMTEXTAREA2 function

of HTF package, 135

FORMTEXTAREA2 procedure

of HTP package, 140

FORMTEXTAREACLOSE function

of HTF package, 135

FORMTEXTAREACLOSE procedure

of HTP package, 140

FORMTEXTAREAOPEN function

of HTF package, 135

FORMTEXTAREAOPEN procedure

of HTP package, 140

FORMTEXTAREAOPEN2 function

of HTF package, 135

FORMTEXTAREAOPEN2 procedure

of HTP package, 140

FRAME function

of HTF package, 135

FRAME procedure

of HTP package, 140

FRAMESETCLOSE function

of HTF package, 135

FRAMESETCLOSE procedure

of HTP package, 140

FRAMESETOPEN function

of HTF package, 135

FRAMESETOPEN procedure

of HTP package, 140

FREE_BLOCKS procedure, 98

FREEDOCFRAG procedure, 125

FREEDOCUMENT procedure, 125

FREENODE procedure, 125

FREEPARSER procedure, 127

FREEPROCESSOR procedure, 133

FREESTYLESHEET procedure, 133

FREETEMPORARY Procedures, 52

FREMOVE procedure, 168, 168

FRENAME procedure, 168

FSEEK procedure, 168

functions

adding to attribute sets, 39, 88

G

GATHER_DATABASE_STATS procedures, 103

GATHER_DICTIONARY_STATS procedure, 103

GATHER_FIXED_OBJECTS_STATS procedure, 103

GATHER_INDEX_STATS Procedure, 103

GATHER_SCHEMA_STATS procedures, 103

GATHER_SYSTEM_STATS procedure, 103

GATHER_TABLE_STATS procedure, 103

GENERATE_SIGNATURE procedure, 67

GENERATE_STATS procedure, 103

GENERATEBEAN procedure, 130

GENERATESCHEMA function, 130

GENERATESCHEMAS function, 130

GET function

of OWA_COOKIE package, 142

GET* member functions

of ANYDATA TYPE, 182

of ANYDATASET TYPE, 183

GET_ACLOID function, 124

GET_ALL procedure, 142

GET_ALL_DAD_ATTRIBUTES Procedure, 37

GET_ALL_DAD_MAPPINGS Procedure, 37

GET_ALL_GLOBAL_ATTRIBUTES Procedure, 37

GET_ALL_NAMES member function, 197

GET_ASSOCIATION_RULES function, 25

GET_AUTHENTICATION procedure, 169

GET_BASE_TABLE_NAME member function, 189

GET_BASE_TABLE_OWNER member function, 189

GET_BODY_CHARSET procedure, 169

GET_CAPTURE_INFO Procedure, 118

GET_CATEGORY function, 117

GET_CGI_ENV function, 149

GET_CLIENT_HOSTNAME function, 147

GET_CLIENT_IP function, 147

GET_COLUMN_STATS procedures, 103

GET_COMMAND_TYPE member function, 189

GET_COMMIT_SCN member function, 189

GET_COMMON_TIME_ZONES Function, 170

GET_COMPATIBLE member function, 189

GET_COOKIE_COUNT function, 169

GET_COOKIE_SUPPORT procedure, 169

GET_COOKIES function, 169

GET_CPU_TIME function, 116

GET_CURRENT_SCHEMA member function, 189

GET_DAD_ATTRIBUTE Procedure, 37

GET_DAD_LIST Procedure, 37

GET_DEFAULT_ISO_CURRENCY Function, 170

GET_DEFAULT_LINGUISTIC_SORT Function, 170

GET_DEFAULT_SETTINGS function, 25

GET_DEPENDENCY procedure, 116

GET_DETAILED_EXCP_SUPPORT procedure, 169

GET_DETAILED_SQLCODE function, 169

GET_DETAILED_SQLERRM function, 169

GET_ERROR_MESSAGE function, 15

GET_ETAG function, 141

GET_EXPRSET_STATS procedure, 39

GET_EXTRA_ATTRIBUTE member function, 189

GET_FILE procedure, 42

GET_FOLLOW_REDIRECT procedure, 169

GET_FREQUENT_ITEMSETS function, 25

GET_GLOBAL_ATTRIBUTE Function, 37

GET_HASH_VALUE function, 116

GET_HEADER procedure, 169

GET_HEADER_BY_NAME procedure, 169

GET_HEADER_COUNT function, 169

GET_HOST_ADDRESS function, 171

GET_HOST_NAME function, 171

GET_IN_PARAMETER_TYPES function, 166

GET_INDEX_STATS procedures, 103

GET_INDEXES function, 30

GET_INFORMATION function, 105

GET_LEVEL function, 141

GET_LINE function, 179

GET_LINE procedure, 68, 168

GET_LINE_MAP function, 30

GET_LINE_NCHAR procedure, 168

GET_LINES procedure, 68

GET_LOB_INFORMATION member function, 189

GET_LOB_OFFSET member function, 189

GET_LOB_OPERATION_SIZE member procedure, 189

GET_LOCAL_LINGUISTIC_SORTS Function, 170

GET_LOGON_USER member function, 189

GET_LONG_INFORMATION member function, 189

GET_MODEL_DETAILS_ABN function, 25

GET_MODEL_DETAILS_AI Function, 25

GET_MODEL_DETAILS_AI function, 25

GET_MODEL_DETAILS_KM function, 25

GET_MODEL_DETAILS_NB function, 25

GET_MODEL_DETAILS_NMF function, 25

GET_MODEL_DETAILS_OC function, 25

GET_MODEL_DETAILS_SVM function, 25

GET_MODEL_DETAILS_XML function, 25

GET_MODEL_SETTINGS function, 25

GET_MODEL_SIGNATURE function, 25

GET_MORE_SOURCE procedure, 30

GET_NEXT_HIT function, 91

GET_OBJECT_NAME member function, 189

GET_OBJECT_OWNER member function, 189

GET_OBJECT_TYPE member function, 189

GET_OUT_PARAMETER_TYPES function, 166

GET_OUTPUT_VALUES function, 166

GET_OWA_SERVICE_PATH function, 149

GET_PARAM function, 103

GET_PARAMETER_VALUE function, 116

GET_PASSWORD function, 147

GET_PERSISTENT_CONN_COUNT function, 169

GET_PERSISTENT_CONN_SUPPORT procedure, 169

GET_PERSISTENT_CONNS procedure, 169

GET_PORTS function, 166

GET_POST_PROCESSED_SOURCE Procedure, 71

GET_PROCEDURE function, 149

GET_PROPERTY function, 166

GET_PROXY procedure, 169

GET_RAW function, 168, 179

GET_REC_ATTRIBUTES Procedure, 12

GET_RESPONSE function, 169

GET_RESPONSE_ERROR_CHECK procedure, 169

GET_RETURN_TYPE function, 166

GET_ROWID function, 145

GET_RUNTIME_INFO function, 30

GET_SCN member function, 189

GET_SCN_MAPPING procedure, 106

GET_SERVICES function, 166

GET_SESSION_TIMEOUT function, 87

GET_SOURCE_DATABASE_NAME member function, 189

GET_SOURCE_TIME member function, 189

GET_STATS_HISTORY_AVAILABILITY function, 103

GET_STATS_HISTORY_RETENTION function, 103

GET_STREAMS_NAME function, 105

GET_STREAMS_TYPE function, 105

GET_SYSTEM_STATS procedure, 103

GET_TABLE_STATS procedure, 103

GET_TAG function, 105

GET_TAG member function, 189

GET_TASK_REPORT Procedure, 12

GET_TASK_SCRIPT Procedure, 12

GET_TEXT function, 179

GET_THRESHOLD procedure, 94

GET_TIME function, 116

GET_TIMEOUT function, 87

GET_TIMEOUT_BEHAVIOUR function, 30

GET_TRANSACTION_ID member function, 189

GET_TRANSFER_TIMEOUT procedure, 169

GET_USER_ID function, 147

GET_USERID function, 124

GET_VALUE function, 30

GET_VALUE member function, 189, 197

GET_VALUE Procedure, 45

GET_VALUE_RAW Procedure, 45

GET_VALUES member function, 189

GET_VERSION procedure, 73

GET_WARNING_SETTING_CAT function, 117

GET_WARNING_SETTING_NUM function, 117

GET_WARNING_SETTING_STRING function, 117

GET_X function, 144

GET_Y function, 144

GETACLDOCUMENT function, 121

GETATTRELEMINFO member function

of ANYTYPE TYPE, 184

GETATTRIBUTE function, 125

GETATTRIBUTENODE function, 125

GETATTRIBUTES function, 125

GETBLOB function, 186, 186, 186, 186

GETBLOBVAL function, 198

GETBUBLICID function, 125

GETCHILDNODES function, 125

GETCHILDRENBYTAGNAME function, 125

GETCHUNKSIZE Functions, 52

GETCLOB function, 186, 186, 186, 186

GETCLOBVAL function, 198

GETCONTENTSBLOBBYRESID function, 122

GETCONTENTSCLOBBYRESID function, 122, 122

GETCONTENTSXMLBYRESID function, 122

GETCONTENTTYPE function, 186, 186, 186, 186

GETCOUNT member function

of ANYDATASET TYPE, 183

GETDATA function, 125

GETDCHARSET function, 125

GETDOCTYPE function, 125, 127

GETDOCUMENT function, 127

GETDOCUMENTELEMENT function, 125

GETDTD function, 128

GETDTD procedure, 128

GETELEMENTSBYTAGNAME function, 125, 125

GETENTITIES function, 125

GETEXCEPTIONCONTENT procedure, 128, 129

GETEXPANDEDNAME function, 125, 125

GETEXPANDEDNAME procedure, 125

GETEXTERNALURL function, 186, 186, 186, 186

GETFIRSTCHILD function, 125

GETFTPPORT Function, 121

GETHTTPPORT Function, 121

GETIMPLEMENTATION function, 125

GETINFO member function

of ANYTYPE TYPE, 184

GETLASTCHILD function, 125

GETLENGTH function, 125, 125, 125

GETLENGTH Functions, 52

GETLOCKTOKEN procedure, 121

GETNAME function, 125, 125

GETNAMEDITEM function, 125

GETNAMESPACE function, 125, 125

GETNAMESPACE procedure, 125

GETNEXTSIBLING function, 125

GETNODENAME function, 125

GETNODETYPE function, 125

GETNODEVALUE function, 125

GETNOTATIONNAME function, 125

GETNOTATIONS function, 125

GETNUMBERVAL function, 198

GETNUMROWSPROCESSED function, 126

GETNUMROWSPROCESSED procedure, 128

GETOWNERDOCUMENT function, 125

GETOWNERELEMENT function, 125

GETPARENTNODE function, 125

GETPAT procedure, 146

GETPERSISTENT static function

of ANYTYPE TYPE, 184

GETPREDECESSORS function, 122

GETPREDSBYRESID function, 122

GETPREFIX function, 125

GETPREVIOUSSIBLING function, 125

GETPRIVILEGES function, 121

GETPUBLICID function, 125, 125

GETQUALIFIEDNAME function, 125, 125

GETRELEASEVERSION function, 127

GETRESOID function, 121

GETRESOURCEBYRESID function, 122

GETROOTELEMENT function, 198

GETRUL function, 186

GETSCHEMANODE function, 125

GETSCHEMAURL function, 198

GETSPECIFIED function, 125

GETSTANDALONE function, 125

GETSTRINGVAL function, 198

GETSUCCESSORS function, 122

GETSUCCSBYRESID function, 122

GETSYSTEMID function, 125, 125, 125

GETTAGNAME function, 125

GETTARGET function, 125

GETTYPE member function

of ANYDATA TYPE, 182

of ANYDATASET TYPE, 183

GETTYPENAME member function

of ANYDATA TYPE, 182

of ANYDATASET TYPE, 183

GETURL function, 186, 186, 186, 186

GETVALIDATIONMODE function, 127

GETVALUE function, 125

GETVERSION function, 125

GETVERSION procedure, 128

GETXDB_TABLESPACE function, 121

GETXML function, 126, 128, 186, 186, 186, 186

GETXML procedure, 128

GETXMLTYPE function, 125, 126

GRANT_ADMIN_PRIVILEGE procedure, 107

GRANT_OBJECT_PRIVILEGE procedure, 92

GRANT_PRIVILEGE procedure, 39, 88

GRANT_REMOTE_ADMIN_ACCESS procedure, 107

GRANT_SWITCH_CONSUMER_GROUP procedure, 86

GRANT_SYSTEM_PRIVILEGE procedure, 41, 86, 92

GRANTING_OBJECT_PRIVILEGE procedure, 41

H

HASATTRIBUTE function, 125

HASCHILDNODES function, 125

HASFEATURE function, 125

HEADCLOSE function

of HTF package, 135

HEADCLOSE procedure

of HTP package, 140

HEADER function

of HTF package, 135

HEADER procedure

of HTP package, 140

HEADOPEN function

of HTF package, 135

HEADOPEN procedure

of HTP package, 140

HELO function and procedure, 178

HELP function, 178

HR function

of HTF package, 135

HR procedure

of HTP package, 140

HTF package, 135

HTML tags

applet tags

functions, 135

procedures, 140

atags tags

procedures, 140

character formatting tags

functions, 135

procedures, 140

form tags

functions, 135

procedures, 140

frame tags

functions, 135

procedures, 140

list tags

functions, 135

procedures, 140

paragraph formatting tags

functions, 135

procedures, 140

table tags

functions, 135

HTMLCLOSE function

of HTF package, 135

HTMLCLOSE procedure

of HTP package, 140

HTMLDB_APPLICATION package documentation, 137

HTMLDB_CUSTOM_AUTH package documentation, 136

HTMLDB_ITEM package documentation, 138

HTMLDB_UTIL package documentation, 139

HTMLOPEN function

of HTF package, 135

HTMLOPEN procedure

of HTP package, 140

HTP package, 140

HTTP_HEADER_CLOSE procedure, 149

HttpUriType, 186

HTTPURITYPE function, 186

HttpUriType subtype, 186

CREATEURI function, 186

GETBLOB function, 186

GETCLOB function, 186

GETCONTENTTYPE function, 186

GETEXTERNALURL function, 186

GETRUL function, 186

GETXML function, 186

HTTPURITYPE function, 186

methods, 186

I

IMG function

of HTF package, 135

IMG procedure

of HTP package, 140

IMG2 procedure

of HTP package, 140

IMPLEMENT_TASK Procedure, 12

IMPORT_AWR Procedure, 118

IMPORT_COLUMN_STATS procedure, 103

IMPORT_DATABASE_STATS procedure, 103

IMPORT_DICTIONARY_STATS procedure, 103

IMPORT_FIXED_OBJECTS_STATS procedure, 103

IMPORT_INDEX_STATS procedure, 103

IMPORT_MODEL procedure, 25

IMPORT_SCHEMA_STATS procedure, 103

IMPORT_SQLWKLD_SCHEMA Procedure, 12

IMPORT_SQLWKLD_SQLCACHE Procedur, 12

IMPORT_SQLWKLD_STS Procedure, 12

IMPORT_SQLWKLD_SUMADV Procedure, 12

IMPORT_SQLWKLD_USER Procedure, 12

IMPORT_SYSTEM_STATS procedure, 103

IMPORT_TABLE_STATS procedure, 103

IMPORTNODE function, 125

INCLUDE_EXTRA_ATTRIBUTES procedure, 20

INDEX_PARAMETERS procedure, 39

INITIALIZE function, 30

INITIALIZE procedure, 75

INSERT_AUTOBIN_NUM_EQWIDTH procedure, 26

INSERT_BIN_CAT_FREQ procedure, 26

INSERT_BIN_NUM_EQWIDTH procedure, 26

INSERT_BIN_NUM_QTILE procedure, 26

INSERT_CLIP_TRIM_TAIL procedure, 26

INSERT_CLIP_WINSOR_TAIL procedure, 26

INSERT_MISS_CAT_MODE procedure, 26

INSERT_MISS_NUM_MEAN procedure, 26

INSERT_NORM_LIN_MINMAX procedure, 26

INSERT_NORM_LIN_SCALE Procedure, 26

INSERT_NORM_LIN_SCALE procedure, 26

INSERT_NORM_LIN_ZSCORE procedure, 26

INSERTBEFORE function, 125

INSERTDATA procedure, 125

INSERTXML function, 129, 131

INSTANCE procedure, 48

instantiation

aborting database preparation, 20

aborting schema preparation, 20

aborting table preparation, 20

global SCN, 15

preparing a database for, 20

preparing a schema for, 20

preparing a table for, 20

schema SCN, 15

table SCN, 15

INSTR Functions, 52

INTERNAL_VERSION_CHECK function, 73

internet addressing

using UTL_INADDR, 171

INTERRUPT_TASK Procedure, 12

INTERRUPT_TUNING_TASK procedure, 101

INTERVAL procedure, 48

INVALIDATE Procedure, 116

INVOKE function, 166

IS_CLUSTER_DATABASE function, 116

IS_HIERARCHY_ENABLED function, 124

IS_LOCATOR function, 164

IS_NULL_TAG member function, 189

IS_OPEN function, 100, 168

IS_TRIGGER_FIRE_ONCE function, 29

ISFRAGMENT function, 198

ISINDEX function

of HTF package, 135

ISINDEX procedure

of HTP package, 140

ISNULL function, 125

ISOPEN function, 165

ISOPEN Functions, 52

ISSCHEMABASED function, 198

ISSCHEMAVALID function, 198

ISSCHEMAVALIDATED function, 198

ISTEMPORARY Functions, 52

ITALIC function

of HTF package, 135

ITALIC procedure

of HTP package, 140

ITEM Functions, 125

K

KBD function

of HTF package, 135

KBD procedure

of HTP package, 140

KEEP procedure, 97

KEYBOARD function

of HTF package, 135

KEYBOARD procedure

of HTP package, 140

L

LAPACK Driver Routines (Linear Equations) Subprograms, 174

LAPACK Driver Routines (LLS and Eigenvalue Problems), 174

LAPACK_GBSV Procedures, 174

LAPACK_GEES Procedures, 174

LAPACK_GEEV Procedures, 174

LAPACK_GELS Procedures, 174

LAPACK_GESDD Procedures, 174

LAPACK_GESV Procedures, 174

LAPACK_GESVD Procedures, 174

LAPACK_GTSV Procedures, 174

LAPACK_PBSV Procedures, 174

LAPACK_POSV Procedures, 174

LAPACK_PPSV Procedures, 174

LAPACK_PTSV Procedures, 174

LAPACK_SBEV Procedures, 174

LAPACK_SBEVD Procedures, 174

LAPACK_SPEV Procedures, 174

LAPACK_SPEVD Procedures, 174

LAPACK_SPSV Procedures, 174

LAPACK_STEV Procedures, 174

LAPACK_STEVD Procedures, 174

LAPACK_SYEV Procedures, 174

LAPACK_SYEVD Procedures, 174

LAPACK_SYSV Procedures, 174

LAST_ERROR_POSITION function, 100

LAST_ROW_COUNT function, 100

LAST_ROW_ID function, 100

LAST_SQL_FUNCTION_CODE function, 100

LCR$_DDL_RECORD type, 189

LCR$_ROW_LIST type, 189

LCR$_ROW_RECORD type, 189

LCR$_ROW_UNIT type, 189

GET_LOB_INFORMATION member function, 189

GET_LOB_OPERATION_SIZE member procedure, 189

GET_LONG_INFORMATION member function, 189

SET_LOB_INFORMATION member procedure, 189

SET_LOB_OPERATION_SIZE member procedure, 189

LCR_TO_XML Function, 59

LENGTH function, 175

LINE function

of HTF package, 135

LINE procedure

of HTP package, 140

LINK procedure, 121

LINKREL function

of HTF package, 135

LINKREL procedure

of HTP package, 140

LINKREV function

of HTF package, 135

LINKREV procedure

of HTP package, 140

LISTHEADER function

of HTF package, 135

LISTHEADER procedure

of HTP package, 140

LISTINGCLOSE function

of HTF package, 135

LISTINGCLOSE procedure

of HTP package, 140

LISTINGOPEN function

of HTF package, 135

LISTINGOPEN procedure

of HTP package, 140

LISTITEM function

of HTF package, 135

LISTITEM procedure

of HTP package, 140

LISTPRINT procedure, 149

LOAD_SQLSET procedure, 101

LOADBLOBFROMFILE Procedure, 52

LOADCLOBFROMFILE Procedure, 52

LOADFROMFILE Procedure, 52

LOBs

DBMS_LOB package, 52

LOCAL_TRANSACTION_ID function, 111

LOCK_MAP procedure, 104

LOCK_OBJECT procedure, 177

LOCK_SCHEMA_STATS procedure, 103

LOCK_TABLE_STATS procedure, 103

LOCKRESOURCE function, 121

log apply services

managing initialization parameters for logical standby databases, 56

logical change records (LCRs)

DDL LCRs, 189

getting base table name, 189

getting base table owner, 189

getting current schema, 189

getting logon user name, 189

getting object type, 189

setting base table name, 189

setting base table owner, 189

setting current schema, 189

setting DDL text, 189

setting logon user, 189

setting object type, 189

determining if tag is NULL, 189

executing, 189, 189

extra attributes

excluding, 20

including, 20

getting command type, 189

getting commit SCN, 189

getting compatibility information, 189

getting extra attributes, 189

getting LCR creation time, 189

getting object name, 189

getting object owner, 189

getting SCN, 189

getting source database name, 189

getting tag, 189

getting transaction identifier, 189

LCR$_DDL_RECORD type, 189

LCR$_ROW_LIST type, 189

LCR$_ROW_RECORD type, 189

LCR$_ROW_UNIT type, 189

row LCRs, 189

adding value to column, 189

converting LONG to LOB, 189

deleting value to column, 189

getting column value, 189

getting list of column values, 189

getting LOB offset, 189

renaming column, 189

setting column value, 189

setting list of column values, 189

setting LOB offset, 189

setting command type, 189

setting extra attributes, 189

setting object name, 189

setting object owner, 189

setting source database name, 189

setting tag, 189

types, 189

logical standby databases

managing with DBMS_LOGSTDBY package, 56

LOGSTDBY_ADMINISTRATOR role, 56

LZ_COMPRESS functions and procedures, 165

LZ_COMPRESS_ADD procedure, 165

LZ_COMPRESS_CLOSE procedure, 165

LZ_COMPRESS_OPEN function, 165

LZ_UNCOMPRESS functions and procedures, 165

LZ_UNCOMPRESS_CLOSE procedure, 165

LZ_UNCOMPRESS_EXTRACT procedure, 165

LZ_UNCOMPRESS_OPEN function, 165

M

MAIL function and procedure, 178

MAILTO function

of HTF package, 135

MAILTO procedure

of HTP package, 140

MAINTAIN_GLOBAL procedure, 106

MAINTAIN_SCHEMAS procedure, 106

MAINTAIN_SIMPLE_TABLESPACE procedure, 106

MAINTAIN_SIMPLE_TTS procedure, 106

MAINTAIN_TABLES procedure, 106

MAINTAIN_TABLESPACES procedure, 106

MAINTAIN_TTS procedure, 106

MAKE_DATA_BLOCK_ADDRESS function, 116

MAKEATTR function, 125

MAKECDATASECTION function, 125

MAKECHARACTERDATA function, 125

MAKECOMMENT function, 125

MAKEDOCUMENT function, 125

MAKEDOCUMENTFRAGMENT function, 125

MAKEDOCUMENTTYPE function, 125

MAKEELEMENT function, 125

MAKEENTITY function, 125

MAKEENTITYREFERENCE function, 125

MAKENODE function, 125, 125, 125, 125

MAKENOTATION function, 125

MAKEPROCESSINGINSTRUCTION function, 125

MAKETEXT function, 125

MAKEVERSIONED function, 122

MAP_ALL function, 104

MAP_DAD Procedure, 37

MAP_ELEMENT function, 104

MAP_FILE function, 104

MAP_OBJECT function, 104

MAPCLOSE function

of HTF package, 135

MAPCLOSE procedure

of HTP package, 140

MAPOPEN function

of HTF package, 135

MAPOPEN procedure

of HTP package, 140

MARK_RECOMMENDATION Procedure, 12

MATCH function, 146

materialized view logs

master table

purging, 61, 61, 61

materialized views

refreshing, 61, 61, 61

MENULISTCLOSE function

of HTF package, 135

MENULISTCLOSE procedure

of HTP package, 140

MENULISTOPEN function

of HTF package, 135

MENULISTOPEN procedure

of HTP package, 140

MESSAGE_PROPERTIES_ARRAY_T Type, 185

MESSAGE_PROPERTIES_T Type, 185

messaging client

messaging client user, 106

rules

for LCRs, 106

for user messages, 106

META function

of HTF package, 135

META procedure

of HTP package, 140

methodology

transformation, 26

MG2 function

of HTF package, 135

MGW_FOREIGN_QUEUES View, 58

MGW_GATEWAY View, 58

MGW_LINKS View, 58

MGW_MQSERIES_LINKS View, 58

MGW_SCHEDULES View, 58

MGW_SUBSCRIBERS View, 58

MGW_TIBRV_LINKS View, 58

migration

post-migration actions, 62

MIME_HEADER procedure, 149

MIMEHEADER_DECODE function, 167

MIMEHEADER_ENCODE function, 167

min-max normalization, 26

missing value treatment, 26

MODIFY_OPERATOR_LIST procedure, 39

MODIFY_SERVICE Procedure, 95

MODIFY_SNAPSHOT_SETTINGS procedure, 119

MODIFY_TRANSFORMATION procedure, 112

MOVEXDB_TABLESPACE procedure, 121

MSGID_ARRAY_T Type, 185

N

NAME_RESOLVE procedure, 116

NAME_TOKENIZE procedure, 116

NAMESPACE function, 198

new features, Preface

NEW_LINE procedure, 68, 168

NEW_ROW_LIST function and procedure, 148

NEWCONTEXT function, 126, 128, 129, 131

NEWDOMDOCUMENT function, 125

NEWPARSER function, 127

NEWPROCESSOR function, 133

NEWSTYLESHEET function, 133

NEXT_DATE procedure, 48

NEXT_ITEM_TYPE function, 70

NL function

of HTF package, 135

NL procedure

of HTP package, 140

NOBR function

of HTF package, 135

NOBR procedure

of HTP package, 140

NOFRAMESCLOSE function

of HTF package, 135

NOFRAMESCLOSE procedure

of HTP package, 140

NOFRAMESOPEN function

of HTF package, 135

NOFRAMESOPEN procedure

of HTP package, 140

NOOP function and procedure, 178

NORMAL function, 75

NORMAL_DIST_FIT procedure, 102

normalization, 26

min-max, 26

z-score, 26

NORMALIZE procedure, 125

numerical binning, 26

NVARRAY_ADD Procedure, 59

NVARRAY_FIND_NAME Function, 59

NVARRAY_FIND_NAME_TYPE Function, 59

NVARRAY_GET Function, 59

NVARRAY_GET_BOOLEAN, 59

NVARRAY_GET_BYTE, 59

NVARRAY_GET_DATE Function, 59

NVARRAY_GET_DOUBLE Function, 59

NVARRAY_GET_FLOAT Function, 59

NVARRAY_GET_INTEGER, 59

NVARRAY_GET_LONG Function, 59

NVARRAY_GET_RAW Function, 59

NVARRAY_GET_SHORT, 59

NVARRAY_GET_TEXT Function, 59

O

OBJECT_DEPENDENT_SEGMENTS function, 98

OBJECT_GROWTH_TREND function, 98

OLISTCLOSE function

of HTF package, 135

OLISTCLOSE procedure

of HTP package, 140

OLISTOPEN function

of HTF package, 135

OLISTOPEN procedure

of HTP package, 140

One-Class SVM, 25, 25, 25, 25, 25, 25, 25

ONLINE_INDEX_CLEAN Function, 79

OPEN Procedures, 52

OPEN_CONNECTION function, 179

OPEN_CONNECTION functions, 178

OPEN_CURSOR Function, 45

OPEN_CURSOR function, 100

OPEN_DATA function and procedure, 178

operational notes

DBMS_LOGSTDBY package, 56

OR REPLACE clause

for creating packages, 1

Oracle Streams

administrator

granting privileges, 107

revoking privileges, 107

compatibility, 105, 105, 105, 189

creating queues, 106

data dictionary

removing information, 106

messaging

notification, 106

privileges, 107

replication

configuring, 106, 106, 106, 106, 106, 106, 106, 106

Oracle-supplied types

logical change record (LCR) types, 189

rule types, 197

OVERLAY function, 175

OWA_CACHE package, 141

OWA_COOKIE package, 142

OWA_CUSTOM package, 143

OWA_IMAGE package, 144

OWA_OPT_LOCK package, 145

OWA_PATTERN package, 146

OWA_SEC package, 147

OWA_TEXT package, 148

OWA_UTIL package, 149

P

PACK_MESSAGE procedures, 70

PACK_STGTAB_SQLPROF Procedure, 101

PACK_STGTAB_SQLSET Procedure, 101

package

DBMS_EXPFIL, 39

DBMS_ODCI, 63

DBMS_RLMGR, 88

DBMS_XDB, 121

DBMS_XMLDOM, 125

DBMS_XMLGEN, 126

DBMS_XMLPARSER, 127

DBMS_XMLQUERY, 128

DBMS_XMLSAVE, 129

DBMS_XMLSCHEMA, 130

UriFactory, 186

Package - UriFactory, 186

package overview, 1

package variables

i_am_a_refresh, 61

packages

creating, 1

referencing, 1

where documented, 1

PARA function

of HTF package, 135

PARA procedure

of HTP package, 140

PARAGRAPH function

of HTF package, 135

PARAGRAPH procedure

of HTP package, 140

PARAM function

of HTF package, 135

PARAM procedure

of HTP package, 140

PARSE Procedure, 45

PARSE procedure, 100, 127

PARSEBUFFER procedure, 127

PARSECLOB procedure, 127

PARSEDTD procedure, 127

PARSEDTDBUFFER procedure, 127

PARSEDTDCLOB procedure, 127

PAUSE_PROFILER function and procedure, 73

PIECEWISE member procedure

of ANYDATA TYPE, 182

of ANYDATASET TYPE, 183

PING procedure, 30

PLAINTEXT function

of HTF package, 135

PLAINTEXT procedure

of HTP package, 140

plan stability, 66

PL/SQL

datatypes, 34

numeric codes for, 34

functions

DBMS_MGWADM package subprograms, 58

DBMS_MGWMSG package subprograms, 59

procedures

DBMS_MGWADM package subprograms, 58

DBMS_MGWMSG package subprograms, 59

PLSQL_TRACE_VERSION procedure, 110

pointer to

CTX_ADM package, 2

point-in-time recovery

Oracle Streams, 106

POISSON_DIST_FIT procedure, 102

PORT_STRING function, 116

POST_INSTANTIATION_SETUP procedure, 106

PRE_INSTANTIATION_SETUP procedure, 106

PRECLOSE function

of HTF package, 135

PRECLOSE procedure

of HTP package, 140

PREDICT procedure, 72

PREOPEN function

of HTF package, 135

PREOPEN procedure

of HTP package, 140

PREPARE_COLUMN_VALUES procedures, 103, 103

PREPARE_COLUMN_VALUES_NVARCHAR2 procedure, 103

PREPARE_COLUMN_VALUES_ROWID procedure, 103

PREPARE_FOR_NEW_PRIMARY subprogram, 56

PREPARE_GLOBAL_INSTANTIATION procedure, 20

PREPARE_SCHEMA_INSTANTIATION procedure, 20

PREPARE_TABLE_INSTANTIATION procedure, 20

PRINT function

of HTF package, 135

PRINT procedure

of HTP package, 140

PRINT_BACKTRACE procedure, 30

PRINT_CGI_ENV procedure, 149

PRINT_INSTANTIATIONS procedure, 30

PRINT_MULTI procedure, 148

PRINT_POST_PROCESSED_SOURCE Procedure, 71

PRINT_ROW_LIST procedure, 148

PRINTS procedure

of HTP package, 140

privileges

DBMS_LOGSTDBY package, 56

granting, 39

Oracle Streams administrator, 107, 107

revoking, 39

PRN function

of HTF package, 135

PRN procedure

of HTP package, 140

PROBE_VERSION procedure, 30

PROCESS_RULES procedure, 88

PROCESSXSL function, 133

PROGRAM_INFO Record Type, 30

PROPAGATEORIGINALEXCEPTION procedure, 128, 129

propagations

altering, 74

creating, 74, 106, 106, 106, 106, 106

DBMS_PROPAGATION_ADM package, 74

dropping, 74

propagation user, 106

rules

defining global, 106

defining message, 106

defining schema, 106

defining subset, 106

defining table, 106

for LCRs, 106

for user messages, 106

starting, 74

stopping, 74

PS procedure

of HTP package, 140

PULL_SIMPLE_TABLESPACE procedure, 109

PULL_TABLESPACES procedure, 109

PURGE procedure, 70

PURGE_FILE_GROUP procedure, 41

PURGE_LOST_DB_ENTRY procedure, 111

PURGE_MIXED procedure, 111

PURGE_QUEUE_TABLE Procedure, 17

PURGE_SESSION Subprogram, 56

PURGE_SOURCE_CATALOG procedure, 106

PURGE_STATS procedure, 103

PURGELDAPCACHE function, 124

purging

the subscription window, 22

PUT procedure, 168

PUT procedures, 68

PUT_FILE procedure, 42

PUT_LINE procedure, 168

PUT_LINE procedures, 68

PUT_LINE_NCHAR procedure, 168

PUT_NCHAR procedure, 168

PUT_RAW function, 168

PUTF procedure, 168

PUTF_NCHAR procedure, 168

Q

quantile numerical binning, 26

query generation, 26

queues

AnyData

creating, 106

removing, 106

QUICK_TUNE Procedure, 12

QUIT function and procedure, 178

QUOTED_PRINTABLE_DECODE function, 167

QUOTED_PRINTABLE_ENCODE function, 167

R

RANDOM procedure, 75

RANK_APPLY procedure, 25

RCPT function, 178

RE$ATTRIBUTE_VALUE type, 197

RE$ATTRIBUTE_VALUE_LIST type, 197

RE$COLUMN_VALUE type, 197, 197

RE$COLUMN_VALUE_LIST type, 197

RE$NAME_ARRAY type, 197

RE$NV_ARRAY type, 197

RE$NV_LIST type, 197

ADD_PAIR member procedure, 197

GET_ALL_NAMES member function, 197

GET_VALUE member function, 197

REMOVE_PAIR member procedure, 197

RE$RULE_HIT type, 197

RE$RULE_HIT_LIST type, 197

RE$TABLE_ALIAS type, 197

RE$TABLE_ALIAS_LIST type, 197

RE$TABLE_VALUE type, 197

RE$TABLE_VALUE_LIST type, 197

RE$VARIABLE_TYPE type, 197

RE$VARIABLE_TYPE_LIST type, 197

RE$VARIABLE_VALUE type, 197

RE$VARIABLE_VALUE_LIST type, 197

READ Procedures, 52

READ_CLIENT_INFO procedure, 14

READ_LINE function, 179

READ_LINE procedure

of UTL_HTTP, 169

READ_MODULE procedure, 14

READ_ONLY procedure, 111

READ_RAW function, 179

READ_RAW procedure

of UTL_HTTP, 169

READ_TEXT function, 179

READ_TEXT procedure

of UTL_HTTP, 169

READ_WRITE procedure, 111

READ2CLOB function, 133

REBUILD_FREELISTS procedure, 79

RECEIVE_MESSAGE function, 70

RECOMP_PARALLEL procedure, 176

RECOMP_SERIAL procedure, 176

REDIRECT_URL procedure, 149

refresh

materialized views, 61, 61, 61

REFRESH_PRIVATE_OUTLINE procedure, 67

REGISTER_DEPENDENT_OBJECT procedure, 77

REGISTER_FOREIGN_QUEUE Procedure, 58

REGISTERSCHEMA procedure, 130

REGISTERURI procedure, 130

REGISTERURLHANDLER procedure, 186

RELEASE function, 53

RELEASE_ALL_SERVICES procedure, 166

RELEASE_CALL procedure, 166, 166

RELEASE_SERVICE procedure, 166

REMAP_STGTAB_SQLPROF Procedure, 101

REMAP_STGTAB_SQLSET Procedure, 101

REMOVE procedure

of DBMS_ALERT package, 13

of DBMS_JOB package, 48

of OWA_COOKIE package, 142

REMOVE_FILE procedure, 41

REMOVE_MSGSYSTEM_LINK Procedure, 58

REMOVE_PAIR member procedure, 197

REMOVE_PIPE function, 70

REMOVE_PROPERTY procedure, 166

REMOVE_QUEUE procedure, 106

REMOVE_RULE procedure, 92, 106

REMOVE_SQLSET_REFERENCE procedure, 101

REMOVE_STREAMS_CONFIGURATION procedure, 106

REMOVE_SUBSCRIBER Procedure, 58

REMOVEALL procedure, 13

REMOVEATTRIBUTE procedure, 125

REMOVEATTRIBUTENODE function, 125

REMOVENAMEDITEM function, 125

REMOVEPARAM procedure, 133

REMOVEXSLTPARAM procedure, 128, 129

RENAME_COLUMN member procedure, 189

RENAME_COLUMN procedure, 106

RENAME_MODEL procedure, 25

RENAME_SCHEMA procedure, 106

RENAME_TABLE procedure, 106

RENAMERESOURCE procedure, 121

REPLACECHILD function, 125

REPLACEDATA procedure, 125

replication

Oracle Streams

configuring, 106, 106, 106, 106, 106, 106, 106, 106

REPLY, REPLIES record types, 178

REPORT Function, 118

REPORT_TUNING_TASK function, 101

REQUEST function, 53, 169

REQUEST_PIECES function, 169

RESET_BUFFER procedure, 70

RESET_PARAM_DEFAULTS Procedure, 103

RESET_SESSION procedure, 88

RESET_SQLWKLD Procedure, 12

RESET_SUBSCRIBER Procedure, 58

RESET_TASK Procedure, 12

RESET_TUNING_TASK procedure, 101

RESETPARAMS procedure, 133

RESOLVENAMESPACEPREFIX function, 125

RESTARTQUERY procedure, 126

RESTORE function, 104

RESTORE_DATBASE_STATS procedure, 103

RESTORE_DICTIONARY_STATS procedure, 103

RESTORE_FIXED_OBJECTS_STATS procedure, 103

RESTORE_SCHEMA_STATS procedure, 103

RESTORE_SYSTEM_STATS procedure, 103

RESTORE_TABLE_STATS procedure, 103

RESUME_PROFILER function and procedure, 73

RESUME_TUNING_TASK Procedure, 101

REVERSE function, 175

REVOKE_ADMIN_PRIVILEGE procedure, 107

REVOKE_OBJECT_PRIVILEGE procedure, 41, 92

REVOKE_PRIVILEGE procedure, 39, 88

REVOKE_REMOTE_ADMIN_ACCESS procedure, 107

REVOKE_SWITCH_CONSUMER_GROUP procedure, 86

REVOKE_SYSTEM_PRIVILEGE procedure, 41, 86, 92

RLM$EVENTIDS object type, 196

ROLLBACK procedure, 111

ROLLBACK_FORCE procedure, 111

ROLLBACK_SAVEPOINT procedure, 111

row migration, 106, 106

ROWID datatype

extended format, 90

ROWID_BLOCK_NUMBER function, 90

ROWID_CREATE function, 90

ROWID_INFO procedure, 90

ROWID_OBJECT function, 90

ROWID_RELATIVE_FNO function, 90

ROWID_ROW_NUMBER function, 90

ROWID_TO_ABSOLUTE_FNO function, 90

ROWID_TO_EXTENDED function, 90

ROWID_TO_RESTRICTED function, 90

ROWID_TYPE function, 90

ROWID_VERIFY function, 90

rule sets

adding rules to, 92

creating, 92

dropping, 92

removing rules from, 92

rule-based transformations

setting, 106

rules

action contexts

adding name-value pairs, 197

getting name-value pairs, 197

getting value for name, 197

removing name-value pairs, 197

transformations, 106

altering, 92

creating, 92

DBMS_RULE package, 91

DBMS_RULE_ADM package, 92

dropping, 92

evaluation, 91

iterators, 91, 91

evaluation contexts

altering, 92

creating, 92

dropping, 92

object privileges

granting, 92

revoking, 92

propagations

removing, 106

RE$ATTRIBUTE_VALUE type, 197

RE$ATTRIBUTE_VALUE_LIST type, 197

RE$COLUMN_VALUE type, 197, 197

RE$COLUMN_VALUE_LIST type, 197

RE$NAME_ARRAY type, 197

RE$NV_ARRAY type, 197

RE$NV_LIST type, 197

RE$RULE_HIT type, 197

RE$RULE_HIT_LIST type, 197

RE$TABLE_ALIAS type, 197

RE$TABLE_ALIAS_LIST type, 197

RE$TABLE_VALUE type, 197

RE$TABLE_VALUE_LIST type, 197

RE$VARIABLE_TYPE type, 197

RE$VARIABLE_TYPE_LIST type, 197

RE$VARIABLE_VALUE type, 197

RE$VARIABLE_VALUE_LIST type, 197

subset

defining, 106, 106

system privileges

granting, 92

revoking, 92

system-created, 106

global apply, 106

global capture, 106

global propagation, 106

global schema, 106

message, 106, 106

message propagation, 106

removing, 106

schema capture, 106

schema propagation, 106

subset apply, 106

subset capture, 106

subset propagation, 106

table apply, 106

table capture, 106

table propagation, 106

types, 197

Rules Manager object types, 196

RUN procedure, 48

RUNTIME_INFO Record Type, 30

S

S function

of HTF package, 135

S procedure

of HTP package, 140

SAMPLE function

of HTF package, 135

SAMPLE procedure

of HTP package, 140

SAVE function, 104

SAVEPOINT procedure, 111

SCHEDULE_PROPAGATION Procedure, 58

SCHEMAVALIDATE procedure, 198

SCN_TO_TIMESTAMP function, 43

SCRIPT function

of HTF package, 135

SCRIPT procedure

of HTP package, 140

SCRIPT_TUNING_TASK Function, 101

SDO_CS package documentation, 150

SDO_GCDR package documentation, 151

SDO_GEOM package documentation, 152

SDO_GEOR package documentation, 153

SDO_GEOR_UTL package documentation, 154

SDO_LRS package documentation, 155

SDO_MIGRATE package documentation, 156

SDO_NET package documentation, 157

SDO_NET_MEM package documentation, 158

SDO_SAM package documentation, 159

SDO_TOPO package documentation, 160

SDO_TOPO_MAP package documentation, 161

SDO_TUNE package documentation, 162

SDO_UTIL package documentation, 163

security

DBMS_LOGSTDBY package, 56

SEED procedures, 75

SEGMENT_CORRUPT procedure, 99

SEGMENT_DROP_CORRUPT procedure, 99

SEGMENT_DUMP procedure, 99

SEGMENT_FIX_STATUS procedure, 79

SEGMENT_VERIFY procedure, 99

SELECT_CURSOR_CACHE Function, 101

SELECT_OBJECT procedure, 177

SELECT_SQLSET function, 101, 101

SELECT_WORKLOAD_REPOSITORY functions, 101

SELECTNODES function, 133

SELECTSINGLENODE function, 133

SELF_CHECK procedure, 30

SEND procedure, 142, 173

SEND_ATTACH_RAW procedure, 173

SEND_ATTACH_VARCHAR2 procedure, 173

SEND_MESSAGE function, 70

SERV_MOD_ACT_STAT_DISABLE procedure, 60

SERV_MOD_ACT_STAT_ENABLE procedure, 60

SERV_MOD_ACT_TRACE_DISABLE procedure, 60

SERV_MOD_ACT_TRACE_ENABLE procedure, 60

SESSION _TRACE_DISABLE Procedure, 96

SESSION _TRACE_ENABLE Procedur, 96

SESSION_TRACE_DISABLE procedure, 60

SESSION_TRACE_ENABLE procedure, 60

SET* member procedures

of ANYDATA TYPE, 182

of ANYDATASET TYPE, 183

SET_ACTION procedure, 14

SET_AUTHENTICATION procedure, 169

SET_AUTHORIZATION procedure, 147

SET_BASE_TABLE_NAME member procedure, 189

SET_BASE_TABLE_OWNER member procedure, 189

SET_BODY_CHARSET procedures, 169, 169

SET_BREAKPOINT function, 30

SET_CLIENT_INFO procedure, 14

SET_COLUMN_STATS procedures, 103

SET_COMMAND_TYPE member procedure, 189

SET_CONSUMER_GROUP_MAPPING procedure, 85

SET_CONSUMER_GROUP_MAPPING_PRI procedure, 85

SET_COOKIE_SUPPORT procedures, 169

SET_CURRENT_SCHEMA member procedure, 189

SET_DAD_ATTRIBUTE Procedure, 37

SET_DDL_TEXT member procedure, 189

SET_DEFAULT_SQLWKLD_PARAMETER Procedure, 12

SET_DEFAULT_TASK_PARAMETER Procedures, 12

SET_DEFAULTS procedure, 13

SET_DETAILED_EXCP_SUPPORT procedure, 169

SET_DML_HANDLER procedure, 15

SET_ENQUEUE_DESTINATION procedure, 15

SET_EXECUTE procedure, 15

SET_EXTRA_ATTRIBUTE member procedure, 189

SET_FOLLOW_REDIRECT procedures, 169

SET_GLOBAL_ATTRIBUTE Function, 37

SET_GLOBAL_INSTANTIATION procedure, 15

SET_HEADER procedure, 169

SET_INDEX_STATS procedures, 103

SET_INITIAL_CONSUMER_GROUP procedure, 85

SET_KEY_COLUMNS procedure, 15

SET_LOB_INFORMATION member procedure, 189

SET_LOB_OFFSET member procedure, 189

SET_LOB_OPERATION_SIZE member procedure, 189

SET_LOG_LEVEL Procedure, 58

SET_LOGON_USER member procedure, 189

SET_MAILHOST Procedure, 18

SET_MAILPORT Procedure, 18

SET_MESSAGE_NOTIFICATION procedure, 106

SET_MODULE procedure, 14

SET_OBJECT_NAME member procedure, 189

SET_OBJECT_OWNER member procedure, 189

SET_OBJECT_TYPE member procedure, 189

SET_OER_BREAKPOINT function, 30

SET_PARAM procedure, 103

SET_PARAMETER procedure, 20

apply process, 15

SET_PERSISTENT_CONN_SUPPORT procedure, 169

SET_PLSQL_TRACE procedure, 110

SET_PROPERTY procedure, 166

SET_PROTECTION_REALM procedure, 147

SET_PROXY procedure, 169

SET_RESPONSE_ERROR_CHECK procedure, 169

SET_RULE_TRANSFORM_FUNCTION procedure, 106

SET_SCHEMA_INSTANTIATION procedure, 15

SET_SENDFROM Procedure, 18

SET_SESSION_LONGOPS procedure, 14

SET_SESSION_TIMEOUT procedure, 87

SET_SOURCE_DATABASE_NAME member procedure, 189

SET_SQLWKLD_PARAMETER Procedure, 12

SET_SYSTEM_STATS procedure, 103

SET_TABLE_INSTANTIATION procedure, 15

SET_TABLE_STATS procedure, 103

SET_TABLESPACE Subprogram, 56

SET_TAG member procedure, 189

SET_TAG procedure, 105

SET_TASK_PARAMETER Procedure, 12

SET_THRESHOLD procedure, 94

SET_TIMEOUT function, 30

SET_TIMEOUT procedure, 87

SET_TIMEOUT_BEHAVIOUR procedure, 30

SET_TRANSFER_TIMEOUT procedure, 169

SET_TRIGGER_FIRING_PROPERTY procedure, 29

SET_UP_QUEUE procedure, 106

SET_UPDATE_CONFLICT_HANDLER procedure, 15

SET_VALUE function, 30

SET_VALUE member procedure, 189

SET_VALUE_DEPENDENCY procedure, 15

SET_VALUES member procedure, 189

SET_WALLET procedure, 169

SET_WARNING_SETTING_STRING procedure, 117

SET_WATERMARK Procedure, 17

SETACL procedure, 121

SETATTRIBUTE procedure, 125

SETATTRIBUTENODE function, 125

SETBASEDIR procedure, 127

SETBATCHSIZE procedure, 129

SETBINDVALUE procedure, 128

SETCOLLIDATTRNAME procedure, 128

SETCOMMITBATCH procedure, 129

SETCONVERTSPECIALCHARS procedure, 126

SETDATA procedure, 125

SETDATAHEADER procedure, 128

SETDATEFORMAT procedure, 128, 129

SETDCHARSET procedure, 125

SETDOCTYPE Procedure, 125

SETDOCTYPE procedure, 127

SETDVERSION procedure, 125

SETENCODINGTAG procedure, 128

SETERRORLOG procedure, 127, 133

SETERRORTAG procedure, 128

SETFTPPORT Procedure, 121

SETHTTPPORT Procedure, 121

SETIGNORECASE procedure, 129

SETINFO member procedure

of ANYTYPE TYPE, 184

SETKEYCOLUMN procedure, 129, 131

SETMAXROWS procedure, 126, 128

SETMETAHEADER procedure, 128

SETNAMEDITEM function, 125

SETNODEVALUE procedure, 125

SETPARAM procedure, 133

SETPREFIX procedure, 125

SETPRESERVEWHITESPACE procedure, 127, 129

SETRAISEEXCEPTION procedure, 128

SETRAISENOROWSEXCEPTION procedure, 128

SETROWIDATTRNAME procedure, 128

SETROWIDATTRVALUE procedure, 128

SETROWSETTAG procedure, 126, 128

SETROWTAG procedure, 128, 129, 131

SETSCHEMAVALIDATED procedure, 198

SETSKIPROWS procedure, 126, 128

SETSQLTOXMLNAMEESCAPING procedure, 128, 129

SETSTANDALONE procedure, 125

SETSTYLESHEETHEADER procedure, 128

SETTAGCASE procedure, 128

SETUPDATECOLUMN procedure, 129, 131

SETVALIDATIONMODE procedure, 127

SETVALUE procedure, 125

SETXSLT procedure, 128, 129

SETXSLTPARAM procedure, 128, 129

SHOW_BREAKPOINTS procedures, 30

SHOW_FRAME_SOURCE procedure, 30

SHOW_SOURCE procedures, 30

SHOWPAGE procedure, 149

SHOWSOURCE procedure, 149

SHOWWARNINGS procedure, 127, 133

SHUTDOWN Procedure, 58

SIGNAL procedure, 13

SIGNATURE procedure, 149

SIZES procedure, 97

SKIP_CORRUPT_BLOCKS procedure, 79

SLEEP procedure, 53

SMALL function

of HTF package, 135

SMALL procedure

of HTP package, 140

snapshot. See DBMS_MVIEW, 61

SOURCE_LINES_T Table Type, 71

SPACE_ERROR_INFO function, 87

SPACE_USAGE procedure, 98

SPLITTEXT function, 125

SQL Apply

managing logical standby databases, 56

managing with DBMS_LOGSTDBY package, 56

SQL statements

larger than 32 KB, 100

SQL*Plus

creating a sequence, 1

SQLSET_ROW Object Type, 101

SQLTEXT_TO_SIGNATURE Function, 101

staging

queues

creating, 106

removing, 106

START_APPLY procedure, 15

START_CAPTURE Procedure, 118

START_CAPTURE procedure, 20

START_PROFILER functions and procedures, 73

START_PROPAGATION procedure, 74

START_REDEF_TABLE procedure, 77

START_SERVICE procedure, 95

STARTUP Procedure, 58

STARTUP_EXTPROC_AGENT procedure, 134

STATUS_LINE procedure, 149

STEP_ID function, 111

STOP_APPLY procedure, 15

STOP_CAPTURE procedure, 20

STOP_PROFILER function and procedure, 73

STOP_PROPAGATION procedure, 74

STOP_SERVICE procedure, 95

STORE_VALUES procedure, 145

stored outlines

DBMS_OUTLN, 66

OUTLN_PKG package, 66

STREAM2MULTI procedure, 148

Streams

removing configuration, 106

STREAMS$_TRANSFORM_FUNCTION, 106

STRIKE function

of HTF package, 135

STRIKE procedure

of HTP package, 140

STRING function, 75

STRING_TO_RAW Function, 170

STRONG function

of HTF package, 135

STRONG procedure

of HTP package, 140

STYLE function

of HTF package, 135

STYLE procedure

of HTP package, 140

SUB procedure

of HTP package, 140

SUBMIT procedure, 48

SUBMIT_PENDING_AREA procedure, 85

subscribers

drop the subscription, 22

extend the window to create a new view, 22

purging the subscription window, 22

retrieve change data from the subscriber views, 22

subscription window

purging, 22

SUBSTR function, 175

SUBSTR Functions, 52

SUBSTRINGDATA function, 125

Summary of DBMS_AQELM Subprograms, 18

Summary of DBMS_DIMENSION Subprograms, 35

Summary of DBMS_ERRLOG Subprograms, 38

Summary of DBMS_MVIEW Subprograms, 61

Summary of DBMS_OLAP Subprograms, 65

Summary of DBMS_PREDICTIVE_ANALYTICS Subprograms, 72

Summary of DBMS_XDBZ Subprograms, 124

Summary of DBMS_XMLDOM Subprograms, 125

Summary of DBMS_XMLSCHEMA Subprograms, 130

Summary of UTL_LMS Subprograms, 172

SUMMARY procedure, 102

SUP function

of HTF package, 135

SUP procedure

of HTP package, 140

SWITCH_CONSUMER_GROUP_FOR_SESS procedure, 85

SWITCH_CONSUMER_GROUP_FOR_USER procedure, 85

SWITCH_PLAN procedure, 85

SYNC_INTERIM_TABLE procedure, 77

SYNCHRONIZE function, 30

SYS.MGW_MQSERIES_PROPERTIES Object Type, 58

SYS.MGW_PROPERTIES Object Type, 58

SYS.MGW_PROPERTY Object Type, 58

SYS.MGW_TIBRV_PROPERTIES Object Type, 58

T

table alias

attributes, 187

TABLE_TO_COMMA procedures, 116

TABLECAPTION function

of HTF package, 135

TABLECAPTION procedure

of HTP package, 140

TABLECLOSE function

of HTF package, 135

TABLECLOSE procedure

of HTP package, 140

TABLEDATA function

of HTF package, 135

TABLEDATA procedure

of HTP package, 140

TABLEHEADER function

of HTF package, 135

TABLEHEADER procedure

of HTP package, 140

TABLEOPEN function

of HTF package, 135

TABLEOPEN procedure

of HTP package, 140

TABLEPRINT function, 149

TABLEROWCLOSE function

of HTF package, 135

TABLEROWCLOSE procedure

of HTP package, 140

TABLEROWOPEN function

of HTF package, 135

TABLEROWOPEN procedure

of HTP package, 140

tables

table items as arrays, 100, 100

tablespace repositories

attaching tablespaces, 109

cloning tablespaces, 109

detaching tablespaces, 109

TABLESPACE_FIX_BITMAPS procedure, 99

TABLESPACE_FIX_SEGMENT_STATES procedure, 99

TABLESPACE_MIGRATE_FROM_LOCAL procedure, 99

TABLESPACE_MIGRATE_TO_LOCAL procedure, 99

TABLESPACE_REBUILD_BITMAPS procedure, 99

TABLESPACE_REBUILD_QUOTAS procedure, 99

TABLESPACE_RELOCATE_BITMAPS procedure, 99

TABLESPACE_SET type, 109

TABLESPACE_VERIFY procedure, 99

tablespaces

change tables and, 21

U

ULISTCLOSE function

of HTF package, 135

ULISTCLOSE procedure

of HTP package, 140

ULISTOPEN function

of HTF package, 135

ULISTOPEN procedure

of HTP package, 140

UNASSIGN_ATTRIBUTE_SET procedure, 39

UNCHECKOUT function, 122

UNDERLINE function

of HTF package, 135

UNDERLINE procedure

of HTP package, 140

UNESCAPE function, 180

UNESCAPEURI function, 186

UNIFORM_DIST_FIT procedure, 102

UNIQUE_SESSION_NAME function, 70

UNKEEP procedure, 97

UNLOCK_MAP procedure, 104

UNLOCK_SCHEMA_STATS procedure, 103

UNLOCK_TABLE_STATS procedure, 103

UNLOCKRESOURCE function, 121

UNMAP_DAD Procedure, 37

UNPACK_MESSAGE procedures, 70

UNPACK_STGTAB_SQLPROF Procedure, 101

UNPACK_STGTAB_SQLSET Procedure, 101

UNREGISTER_DEPENDENT_OBJECT procedure, 77

UNREGISTER_FOREIGN_QUEUE Procedure, 58

UNREGISTERURLHANDLER procedure, 186

UNSCHEDULE_PROPAGATION Procedure, 58

UNUSED_SPACE procedure, 98

UPDATE_BY_CAT procedure, 66

UPDATE_CONSUMER_GROUP procedure, 85

UPDATE_OBJECT Procedure, 12

UPDATE_OBJECT procedure, 177

UPDATE_PLAN procedure, 85

UPDATE_PLAN_DIRECTIVE procedure, 85

UPDATE_REC_ATTRIBUTES Procedure, 12

UPDATE_SIGNATURES procedure, 66

UPDATE_SQLSET procedures, 101

UPDATE_SQLWKLD_ATTRIBUTES Procedure, 12

UPDATE_SQLWKLD_STATEMENT Procedure, 12

UPDATE_TASK_ATTRIBUTES Procedure, 12

UPDATERESOURCEMETADATA Procedures, 121

UPDATEXML function, 129, 131

UPGRADE_STAT_TABLE procedure, 103

upgrading

post-upgrade actions, 62

URI Types

description, 186

UriFactory package, 186

ESCAPEURI function, 186

GETURL function, 186

methods, 186

REGISTERURLHANDLER procedure, 186

UNESCAPEURI function, 186

UNREGISTERURLHANDLER procedure, 186

UriType supertype, 186

GETBLOB function, 186

GETCLOB function, 186

GETCONTENTTYPE function, 186

GETEXTERNALURL function, 186

GETURL function, 186

GETXML function, 186

methods, 186

USE_ROLLBACK_SEGMENT procedure, 111

USEITEMTAGSFORCOLL procedure, 126

USENULLATTRIBUTEINDICATOR procedure, 126, 128

user views

DBMS_DATA_MINING, 25

USER_EXPORT procedures, 48

USETYPEFORCOLLELEMTAG procedure, 128

Using DBMS_ADVISOR, 12

Using DBMS_AQIN, 19, 19

Using DBMS_FILE_GROUP, 41

Using DBMS_MVIEW, 61

Using DBMS_PREDICTIVE_ANALYTICS, 72

Using DBMS_RULE, 91

Using DBMS_RULE_ADM, 92

Using DBMS_STREAMS, 105

Using DBMS_STREAMS_ADM, 106

Using DBMS_STREAMS_TABLESPACE_ADM, 109

Using DBMS_XMLDOM, 125

Using DBMS_XMLSCHEMA, 130

Using UTL_HTTP, 169

UTL_COLL package, 164

UTL_COMPRESS package, 165

UTL_DBWS package, 166

UTL_ENCODE package, 167

UTL_FILE package, 168

UTL_HTTP package, 169

UTL_I18N package, 170

ESCAPE_REFERENCE function, 170, 170, 170, 170, 170, 170, 170

GET_DEFAULT_CHARSET function, 170

MAP_CHARSET function, 170

MAP_LANGUAGE_FROM_ISO function, 170

MAP_LOCALE_TO_ISO function, 170

MAP_TERRITORY_FROM_ISO function, 170

RAW_TO_CHAR function, 170

RAW_TO_NCHAR function, 170

UNESCAPE_REFERENCE function, 170

UTL_INADDR package, 171

UTL_LMS package, 172

FORMAT_MESSAGE function, 172

GET_MESSAGE function, 172

UTL_MAIL package, 173

UTL_NLA package, 174

UTL_RAW package, 175

UTL_RECOMP package, 176

UTL_REF package, 177

UTL_TCP package, 179

UTL_URL package, 180

UUDECODE function, 167

UUENCODE function, 167

V

v$vpd_policies, 89

VALIDATE procedure, 116

VALIDATE_DIMENSION procedure, 35

VALIDATE_EXPRESSIONS procedure, 39

VALIDATE_PENDING_AREA procedure, 85

VALIDATE_REWRITE_EQUIVALENCE Procedure, 11

VALUE functions, 75

VALUEOF procedure, 133

VARIABLE function

of HTF package, 135

VARIABLE procedure

of HTP package, 140

VARIABLE_VALUE procedures, 100

VERIFY_VALUES function, 145

views

summary, 58

virtual dependency definitions

object dependencies

creating, 15

dropping, 15

value dependencies, 15

Virtual Private Database. See VPD

VPD

column masking, 89

enabling column-level, 89

viewing current cursors and policy predicates, 89

VPD use of DBMS_RLS, 89

VRFY function, 178

W

WAITANY procedure, 13

WAITONE procedure, 13

WBR function

of HTF package, 135

WBR procedure

of HTP package, 140

WEIBULL_DIST_FIT procedure, 102

WHAT procedure, 48

WHO_CALLED_ME procedure, 149

winsorizing, 26

WPG_DOCLOAD package, 181

WRAP Functions, 29

WRITE Procedures, 52

WRITE_DATA procedure, 178

WRITE_LINE function, 179

WRITE_LINE procedure, 169

WRITE_RAW function, 179

WRITE_RAW procedure, 169

WRITE_RAW_DATA procedure, 178

WRITE_TEXT function, 179

WRITE_TEXT procedure, 169

WRITEAPPEND Procedures, 52

WRITETOBUFFER procedure, 125

WRITETOCLOB procedure, 125

WRITETOFILE procedure, 125

X

XDBUriType, 186

XDBURITYPE function, 186

XDBUriType subtype, 186

CREATEURI function, 186

GETBLOB function, 186

GETCLOB function, 186

GETCONTENTTYPE function, 186

GETEXTERNALURL function, 186

GETURL function, 186

GETXML function, 186

methods, 186

XDBURITYPE function, 186

XDBZ Constants, 124

XFORM_BIN_CAT procedure, 26

XFORM_BIN_NUM procedure, 26

XFORM_CLIP procedure, 26

XFORM_MISS_CAT procedure, 26

XFORM_MISS_NUM procedure, 26

XFORM_NORM_LIN procedure, 26

XML tags

specifying list of

configuring index parameters, 187

XML_TO_LCR Function, 59

XMLType

CREATENONSCHEMABASEDXML function, 198

CREATESCHEMABASEDXML function, 198

CREATEXML function, 198

description, 198

EXISTSNODE function, 198

EXTRACT function, 198

GETBLOBVAL function, 198

GETCLOBVAL function, 198

GETNUMBERVAL function, 198

GETROOTELEMENT function, 198

GETSCHEMAURL function, 198

GETSTRINGVAL function, 198

ISFRAGMENT function, 198

ISSCHEMABASED function, 198

ISSCHEMAVALID function, 198

ISSCHEMAVALIDATED function, 198

NAMESPACE function, 198

SCHEMAVALIDATE procedure, 198

SETSCHEMAVALIDATED procedure, 198

TOOBJECT procedure, 198

TRANSFORM function, 198

XMLTYPE function, 198

XPath parameters

adding to attribute list, 39

dropping from attribute list, 39

XPath predicates

indexing set of

configuring XML element or XML attribute, 187

XPINDEX_PARAMETERS procedure, 39

XRANGE function, 175

Z

z-score normalization, 26