Skip Headers
Oracle® Database PL/SQL Packages and Types Reference
10g Release 2 (10.2)

Part Number B14258-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
View PDF

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, 120
ACTIVATE_SUBSCRIPTION Procedure, 22
ACTIVE_INSTANCES procedure, 116
ADD_COLUMN member procedure, 188
ADD_COLUMN procedure, 106
ADD_COOKIES procedure, 168
ADD_ELEMENTARY_ATTRIBUTE procedure, 39, 88
ADD_EVENT procedure, 88
ADD_FILE procedure, 41
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, 196
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, 147
ADDATTR member procedure
of ANYTYPE TYPE, 183
ADDINSTANCE member procedure
of ANYDATASET TYPE, 182
ADDRESS function
of HTF package, 134
ADDRESS procedure
of HTP package, 139
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, 145
ANALYZE_DATABASE procedure, 116
ANALYZE_PART_OBJECT procedure, 116
ANALYZE_SCHEMA procedure, 116
ANCHOR function
of HTF package, 134
ANCHOR procedure
of HTP package, 139
ANCHOR2 function
of HTF package, 134
ANCHOR2 procedure
of HTP package, 139
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, 181
ANYDATASET TYPE, 182
ANYTYPE TYPE, 183
APPEND Procedures, 52
APPENDCHILD function, 124
APPENDDATA procedure, 124
APPENDRESOURCEMETADATA Procedure, 120
APPLETCLOSE function
of HTF package, 134
APPLETCLOSE procedure
of HTP package, 139
APPLETOPEN function
of HTF package, 134
APPLETOPEN procedure
of HTP package, 139
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, 184
AQ$_AGENT_LIST_T Type, 184
AQ$_DESCRIPTOR Type, 184, 184
AQ$_POST_INFO Type, 184
AQ$_POST_INFO_LIST Type, 184
AQ$_PURGE_OPTIONS_T Type, 184
AQ$_RECIPIENT_LIST_T Type, 184
AQ$_REG_INFO Type, 184
AQ$_REG_INFO_LIST Type, 184
AQ$_SUBSCRIBER_LIST_T Type, 184
AREA function
of HTF package, 134
AREA procedure
of HTP package, 139
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, 118
ASH_REPORT_TEXT Function, 118
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, 142
AUTHORIZE_DAD Procedure, 37
AVAILABLE function, 178
AWR_DIFF_REPORT_HTML Function, 118
AWR_DIFF_REPORT_TEXT Function, 118
AWR_REPORT_HTML function, 118
AWR_REPORT_TEXT function, 118
AWR_SQL_REPORT_HTML Function, 118
AWR_SQL_REPORT_TEXT Function, 118

B

BASE function
of HTF package, 134
BASE procedure
of HTP package, 139
BASE64_DECODE function, 166
BASE64_ENCODE function, 166
BASEFONT function
of HTF package, 134
BASEFONT procedure
of HTP package, 139
BEGIN_DISCRETE_TRANSACTION procedure, 111
BEGIN_REQUEST function, 168
BEGINCREATE static procedure
of ANYDATA TYPE, 181
of ANYDATASET TYPE, 182
of ANYTYPE TYPE, 183
BGSOUND function
of HTF package, 134
BGSOUND procedure
of HTP package, 139
BIG function
of HTF package, 134
BIG procedure
of HTP package, 139
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, 148
binning, 26
categorical, 26
numerical, 26, 26
quantile, 26
BIT_AND function, 174
BIT_COMPLEMENT function, 174
BIT_OR function, 174
BIT_XOR function, 174
BLAS Level 1 (Vector-Vector Operations) Subprograms, 173
BLAS Level 2 (Matrix-Vector Operations) Subprograms, 173
BLAS Level 3 (Matrix-Matrix Operations) Subprograms, 173
BLAS_ASUM Functions, 173
BLAS_AXPY Procedures, 173
BLAS_COPY Procedures, 173
BLAS_DOT Functions, 173
BLAS_GBMV Procedures, 173
BLAS_GEMM Procedures, 173
BLAS_GEMV Procedures, 173
BLAS_GER Procedures, 173
BLAS_IAMAX Functions, 173
BLAS_NRM2 Functions, 173
BLAS_ROT Procedures, 173
BLAS_ROTG Procedures, 173
BLAS_SBMV Procedures, 173
BLAS_SCAL Procedure, 173
BLAS_SPMV Procedures, 173
BLAS_SPR Procedures, 173
BLAS_SPR2 Procedures, 173
BLAS_SWAP Procedure, 173
BLAS_SYMM Procedures, 173
BLAS_SYMV Procedures, 173
BLAS_SYR Procedures, 173
BLAS_SYR2 Procedures, 173
BLAS_SYRK Procedures, 173
BLAS_TBMV Procedures, 173
BLAS_TBSV Procedures, 173
BLAS_TPMV Procedures, 173
BLAS_TPSV Procedures, 173
BLAS_TRMM Procedures, 173
BLAS_TRMV Procedures, 173
BLAS_TRSM Procedures, 173
BLAS_TRSV Procedures, 173
BLOCKQUOTECLOSE function
of HTF package, 134
BLOCKQUOTECLOSE procedure
of HTP package, 139, 139
BLOCKQUOTEOPEN function
of HTF package, 134
BLOCKQUOTEOPEN procedure
of HTP package, 139
BODYCLOSE function
of HTF package, 134
BODYCLOSE procedure
of HTP package, 139
BODYOPEN function
of HTF package, 134
BODYOPEN procedure
of HTP package, 139
BOLD function
of HTF package, 134
BOLD procedure
of HTP package, 139
BR function
of HTF package, 134
BR procedure
of HTP package, 139
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, 148
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, 174
CAST_FROM_BINARY_FLOAT function, 174
CAST_FROM_BINARY_INTEGER function, 174
CAST_FROM_NUMBER function, 174
CAST_TO_BINARY_DOUBLE function, 174
CAST_TO_BINARY_FLOAT function, 174
CAST_TO_BINARY_INTEGER function, 174
CAST_TO_NUMBER function, 174
CAST_TO_NVARCHAR2 function, 174
CAST_TO_RAW function, 174
CAST_TO_VARCHAR2 function, 174
categorical binning, 26
catproc.sql script, 1
CELLSPRINT procedures, 148
CENTER function
of HTF package, 134
CENTER procedure
of HTP package, 139
CENTERCLOSE function
of HTF package, 134
CENTERCLOSE procedure
of HTP package, 139
CENTEROPEN function
of HTF package, 134
CENTEROPEN procedure
of HTP package, 139
CFG_GET function, 120
CFG_REFRESH procedure, 120
CFG_UPDATE procedure, 120
Change Data Capture
DBMS_CDC_PUBLISH package, 21
CHANGE functions and procedures, 145
CHANGE procedure, 48
change tables
tablespaces created in, 21
CHANGE_JOIN_POS procedure, 67
CHARARR Table Type, 68
CHECK_OBJECT procedure, 79
CHECKIN function, 121
CHECKOUT procedure, 121
CHECKPRIVILEGES function, 120
CHECKSUM functions, 144
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, 148
CITE function
of HTF package, 134
CITE procedure
of HTP package, 139
CLEANUP_GATEWAY Procedure, 58
CLEANUP_INSTANTIATION_SETUP procedure, 106
CLEAR_ALL_CONTEXT Procedure, 96
CLEAR_CONTEXT Procedure, 96
CLEAR_COOKIES procedure, 168
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, 128, 130
CLEARUPDATECOLUMNLIST procedure, 128, 130
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, 132
CLONE_SIMPLE_TABLESPACE procedure, 109
CLONE_TABLESPACES procedure, 109
CLONENODE function, 124
CLOSE Procedure, 52
CLOSE_ALL_CONNECTIONS procedure, 178
CLOSE_CONNECTION procedure, 178
CLOSE_CURSOR Procedure, 45
CLOSE_CURSOR procedure, 100
CLOSE_ITERATOR procedure, 91
CLOSE_PERSISTENT_CONN procedure, 168
CLOSE_PERSISTENT_CONNS procedure, 168
CLOSECONTEXT procedure, 125, 127, 128, 130
CODE function
of HTF package, 134
CODE procedure
of HTP package, 139
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, 177
COMMAND_REPLIES function, 177
COMMENT function
of HTF package, 134
COMMENT procedure
of HTP package, 139
COMMIT procedure, 111
COMMIT_COMMENT procedure, 111
COMMIT_FORCE procedure, 111
COMPARE function, 174
COMPARE Functions, 52
COMPARE_OLD_VALUES procedure, 15
COMPATIBLE_10_1 function, 105, 188
COMPATIBLE_10_2 function, 105, 188
COMPATIBLE_9_2 function, 105, 188
COMPILE_FROM_REMOTE procedure, 51
COMPILE_SCHEMA procedure, 116
COMPILESCHEMA procedure, 129
COMPUTE_CONFUSION_MATRIX procedure, 25
COMPUTE_LIFT procedure, 25
COMPUTE_ROC procedure, 25
CONCAT function, 174
CONFIGUREAUTOSYNC procedure, 122
conflicts
detection
stopping, 15
CONNECTION record type, 177
constants
DBMS_DATA_MINING, 25
DBMS_MGWMSG package, 59
CONSUME_EVENT procedure, 88
CONSUME_PRIM_EVENT procedure, 88
CONTINUE function, 30
CONVERT function, 53, 125, 174
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, 188
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, 174
COPY Procedures, 52
COPY_ATTRIBUTE_SET procedure, 39
COPY_FILE procedure, 42
COPY_TABLE_DEPENDENTS procedure, 77
COPYEVOLVE procedure, 129
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, 118
CREATE_BIN_CAT procedure, 26
CREATE_BIN_NUM procedure, 26
CREATE_CALL function, 165
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, 165
CREATE_SERVICE procedure, 95
CREATE_SIMPLE_PLAN procedure, 85
CREATE_SNAPSHOT function and procedure, 118
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, 124
CREATECDATASECTION function, 124
CREATECOMMENT function, 124
CREATEDATASTOREPREF procedure, 122
CREATEDOCUMENT function, 124
CREATEDOCUMENTFRAGMENT function, 124
CREATEELEMENT function, 124
CREATEENTITYREFERENCE function, 124
CREATEFILTERPREF procedure, 122
CREATEFOLDER function, 120
CREATEINDEX procedure, 122
CREATELEXERPREF procedure, 122
CREATENONSCHEMABASEDXML function, 197
CREATEOIDPATH function, 120
CREATEPREFERENCES procedure, 122
CREATEPROCESSINGINSTRUCTION function, 124
CREATERESOURCE function, 120
CREATESCHEMABASEDXML function, 197
CREATESECTIONGROUPPREF procedure, 122
CREATESTOPLISTPREF procedure, 122
CREATESTORAGEPREF procedure, 122
CREATETEMPORARY Procedures, 52
CREATETEXTNODE function, 124
CREATEURI function, 185, 185, 185
CREATEWORLDLISTPREF procedure, 122
CREATEXML function, 197
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, 177
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, 144
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, 124
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, 184
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, 119
DBMS_WORKLOAD_REPOSITORY package, 118
DBMS_XBD_VERSION package, 121
DBMS_XDB Constants, 120
DBMS_XDB Overview, 120
DBMS_XDB package, 120
ACLCHECKPRIVILEGES function, 120
CFG_GET function, 120
CFG_REFRESH procedure, 120
CFG_UPDATE procedure, 120
CHECKPRIVILEGES function, 120
CONFIGUREAUTOSYNC procedure, 122
constants, 120
ConText synchronization settings, 122
CREATEDATASTOREPREF procedure, 122
CREATEFILTERPREF procedure, 122
CREATEFOLDER function, 120
CREATEINDEX procedure, 122
CREATELEXERPREF procedure, 122
CREATEOIDPATH function, 120
CREATEPREFERENCES procedure, 122
CREATERESOURCE function, 120
CREATESECTIONGROUPPREF procedure, 122
CREATESTOPLISTPREF procedure, 122
CREATESTORAGEPREF procedure, 122
CREATEWORLDLISTPREF procedure, 122
DELETERESOURCE procedure, 120
DROPPREFERENCES procedure, 122
EXISTSRESOURCE function, 120
filtering settings, 122
general indexing settings, 122
GETACLDOCUMENT function, 120
GETLOCKTOKEN procedure, 120
GETRESOID function, 120
GETXDB_TABLESPACE function, 120
LINK procedure, 120
LOCKRESOURCE function, 120
methods, 120, 122
miscellaneous settings, 122
MOVEXDB_TABLESPACE procedure, 120
other index preference settings, 122
REBUILDHIERARCHICALINDEX procedure, 120
RENAMERESOURCE procedure, 120
sectioning and section group settings, 122
SETACL procedure, 120
stoplist settings, 122
SYNC settings, 122
UNLOCKRESOURCE function, 120
DBMS_XDB_VERSION package
CHECKIN function, 121
CHECKOUT procedure, 121
GETCONTENTSBLOBBYRESID function, 121
GETCONTENTSCLOBBYRESID function, 121
GETCONTENTSXMLBYRESID function, 121
GETPREDECESSORS function, 121
GETPREDSBYRESID function, 121
GETRESOURCEBYRESID function, 121
GETSUCCESSORS function, 121
GETSUCCSBYRESID function, 121
MAKEVERSIONED function, 121
UNCHECKOUT function, 121
DBMS_XDBZ package
DISABLE_HIERARCHY procedure, 123
ENABLE_HIERARCHY procedure, 123
GET_ACLOID function, 123
GET_USERID function, 123
IS_HIERARCHY_ENABLED function, 123
PURGELDAPCACHE function, 123
DBMS_XMLDOM Constants, 124
DBMS_XMLDOM package, 124
APPENDDATA procedure, 124
CREATEATTRIBUTE function, 124
CREATECDATASECTION function, 124
CREATECOMMENT function, 124
CREATEDOCUMENT function, 124
CREATEDOCUMENTFRAGMENT, 124
CREATEELEMENT function, 124
CREATEENTITYREFERENCE function, 124
CREATEPROCESSINGINSTRUCTION function, 124
CREATETEXTNODE function, 124
DELETEDATA procedure, 124
description, 124
exceptions, 124
FINDENTITY function, 124
FINDNOTATION function, 124
FREEDOCFRAG procedure, 124
FREEDOCUMENT procedure, 124
GETATTRIBUTE function, 124
GETATTRIBUTENODE function, 124
GETBUBLICID function, 124
GETCHARSET function, 124
GETCHILDRENBYTAGNAME function, 124
GETDATA function, 124
GETDOCTYPE function, 124
GETDOCUMENTELEMENT function, 124
GETELEMENTSBYTAGNAME function, 124, 124
GETENTITIES function, 124
GETEXPANDEDNAME function, 124, 124
GETIMPLEMENTATION function, 124
GETLENGTH function, 124, 124, 124
GETNAME function, 124, 124
GETNAMEDITEM function, 124
GETNAMESPACE function, 124, 124
GETNAMESPACE procedure, 124
GETNEXTSIBLING function, 124
GETNODENAME function, 124
GETNODETYPE function, 124
GETNODEVALUE function, 124
GETNOTATIONNAME function, 124
GETNOTATIONS function, 124
GETOWNERDOCUMENT function, 124
GETOWNERELEMENT function, 124
GETPARENTNODE function, 124
GETPREFIX function, 124
GETPREVIOUSSIBLING function, 124
GETPUBLICID function, 124, 124
GETQUALIFIEDNAME function, 124, 124
GETSCHEMANODE function, 124
GETSPECIFIED function, 124
GETSTANDALONE function, 124
GETSYSTEMID function, 124, 124, 124
GETTAGNAME function, 124
GETTARGET function, 124
GETVALUE function, 124
GETVERSION function, 124
GETXMLTYPE function, 124
HASATTRIBUTE function, 124
HASATTRIBUTES function, 124
HASCHILDNODES function, 124
HASFEATURE function, 124
IMPORTNODE function, 124
INSERTBEFORE function, 124
INSERTDATA procedure, 124
ISNULL function, 124
MAKEATTR function, 124
MAKECDATASECTION function, 124
MAKECHARACTERDATA function, 124
MAKECOMMENT function, 124
MAKEDOCUMENT function, 124
MAKEDOCUMENTFRAGMENT function, 124
MAKEDOCUMENTTYPE function, 124
MAKEELEMENT function, 124
MAKEENTITY function, 124
MAKEENTITYREFERENCE function, 124
MAKENODE function, 124, 124, 124, 124
MAKENOTATION function, 124
MAKEPROCESSINGINSTRUCTION function, 124
MAKETEXT function, 124
methods
APPENDCHILD function, 124
APPENDDATA procedure, 124
CLONENODE function, 124
CREATEATTRIBUTE function, 124
CREATECDATASECTION function, 124
CREATECOMMENT function, 124
CREATEDOCUMENT function, 124
CREATEDOCUMENTFRAGMENT function, 124
CREATEELEMENT function, 124
CREATEENTITYREFERENCE function, 124
CREATEPROCESSINGINSTRUCTION function, 124
CREATETEXTNODE function, 124
DELETEDATA procedure, 124
DOMAttr interface, 124
DOMCDataSection interface, 124
DOMCharacterData interface, 124
DOMComment interface, 124
DOMDocument interface, 124
DOMDocumentFragment interface, 124, 124
DOMDocumentType interface, 124, 124
DOMElement interface, 124, 124
DOMEntity interface, 124, 124
DOMEntityReference interface, 124
DOMImplementation interface, 124
DOMNamedNodeMap interface, 124
DOMNode, 124, 124, 124, 124, 124, 124, 124, 124, 124
DOMNodeList interface, 124
DOMNotation interface, 124
DOMProcessingInstruction interface, 124
DOMText interface, 124, 124
FINDENTITY function, 124
FINDNOTATION function, 124
FREEDOCFRAG procedure, 124
FREEDOCUMENT procedure, 124
FREENODE procedure, 124
GETATTRIBUTE function, 124
GETATTRIBUTENODE function, 124
GETATTRIBUTES function, 124
GETBUBLICID function, 124
GETCHARSET function, 124
GETCHILDNODES function, 124
GETCHILDRENBYTAGNAME function, 124
GETDATA function, 124
GETDOCTYPE function, 124
GETDOCUMENTELEMENT function, 124
GETELEMENTSBYTAGNAME function, 124, 124
GETENTITIES function, 124
GETEXPANDEDNAME function, 124, 124
GETEXPANDEDNAME procedure, 124
GETFIRSTCHILD function, 124
GETIMPLEMENTATION function, 124
GETLASTCHILD function, 124
GETLENGTH function, 124, 124, 124
GETLOCALNAME procedure, 124
GETNAME function, 124, 124
GETNAMEDITEM function, 124
GETNAMESPACE function, 124, 124
GETNAMESPACE procedure, 124
GETNEXTSIBLING function, 124
GETNODENAME function, 124
GETNODETYPE function, 124
GETNODEVALUE function, 124
GETNOTATIONNAME function, 124
GETNOTATIONS function, 124
GETOWNERDOCUMENT function, 124
GETOWNERELEMENT function, 124
GETPARENTNODE function, 124
GETPREFIX function, 124
GETPREVIOUSSIBLING function, 124
GETPUBLICID function, 124, 124
GETQUALIFIEDNAME function, 124, 124
GETSCHEMANODE function, 124
GETSPECIFIED function, 124
GETSTANDALONE function, 124
GETSYSTEMID function, 124, 124, 124
GETTAGNAME function, 124
GETTARGET function, 124
GETVALUE function, 124
GETVERSION function, 124
GETXMLTYPE function, 124
HASATTRIBUTE function, 124
HASATTRIBUTES function, 124
HASCHILDNODES function, 124
HASFEATURE function, 124
IMPORTNODE function, 124
INSERTBEFORE function, 124
INSERTDATA procedure, 124
ISNULL function, 124
MAKEATTR function, 124
MAKECDATASECTION function, 124
MAKECHARACTERDATA function, 124
MAKECOMMENT function, 124
MAKEDOCUMENT function, 124
MAKEDOCUMENTFRAGMENT function, 124
MAKEDOCUMENTTYPE function, 124
MAKEELEMENT function, 124
MAKEENTITY function, 124
MAKEENTITYREFERENCE function, 124
MAKENODE function, 124, 124, 124, 124
MAKENOTATION function, 124
MAKEPROCESSINGINSTRUCTION function, 124
MAKETEXT function, 124
NEWDOMDOCUMENT function, 124
NORMALIZE procedure, 124
REMOVEATTRIBUTE procedure, 124
REMOVEATTRIBUTENODE function, 124
REMOVENAMEDITEM function, 124
REPLACECHILD function, 124
REPLACEDATA procedure, 124
RESOLVENAMESPACEPREFIX function, 124
SETATTRIBUTE procedure, 124
SETATTRIBUTENODE function, 124
SETCHARSET procedure, 124
SETDATA procedure, 124
SETNAMEDITEM function, 124
SETNODEVALUE procedure, 124
SETPREFIX procedure, 124
SETSTANDALONE procedure, 124
SETVALUE procedure, 124
SETVERSION procedure, 124
SPLITTEXT function, 124
SUBSTRINGDATA function, 124
WRITETOBUFFER procedure, 124
WRITETOCLOB procedure, 124
WRITETOFILE procedure, 124
NEWDOMDOCUMENT function, 124
NORMALIZE procedure, 124
REMOVEATTRIBUTE procedure, 124
REMOVEATTRIBUTENODE function, 124
REMOVENAMEDITEM function, 124
REPLACECHILD function, 124
REPLACEDATA procedure, 124
RESOLVENAMESPACEPREFIX function, 124
SETATTRIBUTE procedure, 124
SETATTRIBUTENODE function, 124
SETCHARSET procedure, 124
SETDATA procedure, 124
SETNAMEDITEM function, 124
SETNODEVALUE procedure, 124
SETPREFIX procedure, 124
SETSTANDALONE procedure, 124
SETVALUE procedure, 124
SETVERSION procedure, 124
SPLITTEXT function, 124
SUBSTRINGDATA function, 124
types, 124
WRITETOBUFFER procedure, 124
WRITETOCLOB procedure, 124
WRITETOFILE procedure, 124
DBMS_XMLGEN package, 125
CLOSECONTEXT procedure, 125
CONVERT function, 125
GETNUMROWSPROCESSED function, 125
GETXML function, 125
GETXMLTYPE function, 125
NEWCONTEXT function, 125
RESTARTQUERY procedure, 125
SETCONVERTSPECIALCHARS procedure, 125
SETMAXROWS procedure, 125
SETROWSETTAG procedure, 125
SETROWTAG procedure, 125
SETSKIPROWS procedure, 125
USEITEMTAGSFORCOLL procedure, 125
USENULLATTRIBUTEINDICATOR procedure, 125
DBMS_XMLPARSER package, 126
FREEPARSER procedure, 126
GETDOCTYPE function, 126
GETDOCUMENT function, 126
GETRELEASEVERSION function, 126
GETVALIDATIONMODE function, 126
NEWPARSER function, 126
PARSE function, 126, 126
PARSE procedure, 126
PARSEBUFFER procedure, 126
PARSECLOB procedure, 126
PARSEDTD procedure, 126
PARSEDTDBUFFER procedure, 126
PARSEDTDCLOB procedure, 126
SETBASEDIR procedure, 126
SETDOCTYPE procedure, 126
SETERRORLOG procedure, 126
SETPRESERVEWHITESPACE procedure, 126
SETVALIDATIONMODE procedure, 126
SHOWWARNINGS procedure, 126
DBMS_XMLQUERY package, 127
CLOSECONTEXT procedure, 127
constants, 127
GETDTD function, 127
GETDTD procedure, 127
GETEXCEPTIONCONTENT procedure, 127
GETNUMROWSPROCESSED procedure, 127
GETVERSION procedure, 127
GETXML function, 127
GETXML procedure, 127
NEWCONTEXT function, 127
PROPAGATEORIGINALEXCEPTION procedure, 127
REMOVEXSLTPARAM procedure, 127
SETBINDVALUE procedure, 127
SETCOLLIDATTRNAME procedure, 127
SETDATAHEADER procedure, 127
SETDATEFORMAT procedure, 127
SETENCODINGTAG procedure, 127
SETERRORTAG procedure, 127
SETMAXROWS procedure, 127
SETMETAHEADER procedure, 127
SETRAISEEXCEPTION procedure, 127
SETRAISENOROWSEXCEPTION procedure, 127
SETROWIDATTRNAME procedure, 127
SETROWIDATTRVALUE procedure, 127
SETROWSETTAG procedure, 127
SETROWTAG procedure, 127
SETSKIPROWS procedure, 127
SETSQLTOXMLNAMEESCAPING procedure, 127
SETSTYLESHEETHEADER procedure, 127
SETTAGCASE procedure, 127
SETXSLT procedure, 127
SETXSLTPARAM procedure, 127
types, 127
USENULLATTRIBUTEINDICATOR procedure, 127
USETYPEFORCOLLELEMTAG procedure, 127
DBMS_XMLSAVE package, 128
CLEARKEYCOLUMNLIST procedure, 128
CLEARUPDATECOLUMNLIST procedure, 128
CLOSECONTEXT procedure, 128
constants, 128
DELETEXML function, 128
GETEXCEPTIONCONTENT procedure, 128
INSERTXML function, 128
NEWCONTEXT function, 128
PROPAGATEORIGINALEXCEPTION procedure, 128
REMOVEXSLTPARAM procedure, 128
SETBATCHSIZE procedure, 128
SETCOMMITBATCH procedure, 128
SETDATEFORMAT procedure, 128
SETIGNORECASE procedure, 128
SETKEYCOLUMN procedure, 128
SETPRESERVEWHITESPACE procedure, 128
SETROWTAG procedure, 128
SETSQLTOXMLNAMEESCAPING procedure, 128
SETUPDATECOLUMN procedure, 128
SETXSLT procedure, 128
SETXSLTPARAM procedure, 128
UPDATEXML function, 128
DBMS_XMLSCHEMA Constants, 129
DBMS_XMLSCHEMA package, 129
COMPILESCHEMA procedure, 129
COPYEVOLVE procedure, 129
DELETESCHEMA procedure, 129
GENERATEBEAN procedure, 129
GENERATESCHEMA function, 129
GENERATESCHEMAS function, 129
REGISTERSCHEMA procedure, 129
REGISTERURI procedure, 129
DBMS_XMLSCHEMA Views, 129
DBMS_XMLSTORE package, 130
CLEARKEYCOLUMNLIST procedure, 130
CLEARUPDATECOLUMNLIST procedure, 130
CLOSECONTEXT procedure, 130
DELETEXML function, 130
INSERTXML function, 130
NEWCONTEXT function, 130
SETKEYCOLUMN procedure, 130
SETROWTAG procedure, 130
SETUPDATECOLUMN procedure, 130
types, 130
UPDATEXML function, 130
DBMS_XPLAN package, 131
DBMS_XSLPROCESSOR Package, 132, 132
DBMS_XSLPROCESSOR package
CLOB2FILE procedure, 132
FREEPROCESSOR procedure, 132
FREESTYLESHEET procedure, 132
NEWPROCESSOR function, 132
NEWSTYLESHEET function, 132
PROCESSXSL function, 132
READ2CLOB function, 132
REMOVEPARAM procedure, 132
RESETPARAMS procedure, 132
SELECTNODES function, 132
SELECTSINGLENODE function, 132
SETERRORLOG procedure, 132
SETPARAM procedure, 132
SHOWWARNINGS procedure, 132
TRANSFORMNODE function, 132
VALUEOF procedure, 132
DBMSOUTPUT_LINESARRAY Object Type, 68
DBUriType, 185
DBURITYPE function, 185
DBUriType subtype, 185
CREATEURI function, 185
DBURITYPE function, 185
GETBLOB function, 185
GETCLOB function, 185
GETCONTENTTYPE function, 185
GETEXTERNALURL function, 185
GETURL function, 185
GETXML function, 185
methods, 185
DEAUTHORIZE_DAD Procedure, 37
DEBUG_EXPTOC package, 133
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_COLUMN member procedure, 188
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_FIXED_OBJECTS_STATS procedure, 103
DELETE_INDEX_STATS procedure, 103
DELETE_OBJECT procedure, 176
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, 124
DELETERESOURCE procedure, 120
DELETERESOURCEMETADATA Procedures, 120
DELETESCHEMA procedure, 129
DELETEXML function, 128, 130
DEQUEUE procedure, 108
DEQUEUE_ARRAY Function, 16
DEQUEUE_OPTIONS_T Type, 184
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, 134
DFN procedure
of HTP package, 139
DIRECTORY_OBJECT_SET type, 109
DIRLISTCLOSE function
of HTF package, 134
DIRLISTCLOSE procedure
of HTP package, 139
DIRLISTOPEN function
of HTF package, 134
DIRLISTOPEN procedure
of HTP package, 139
DISABLE procedure
of DBMS_FLASHBACK package, 43
of DBMS_OUTPUT package, 68
of OWA_CACHE package, 140
DISABLE_BREAKPOINT function, 30
DISABLE_HIERARCHY procedure, 123
DISABLE_PROPAGATION_SCHEDULE Procedure, 58
DISCONNECT_SESSION procedure, 95
DISPLAY function, 131
DISPLAY_AWR function, 131
DISPLAY_CURSOR function, 131
DISPLAY_SQLSET Function, 131
DIV function
of HTF package, 134
DIV procedure
of HTP package, 139
DLISTCLOSE function
of HTF package, 134
DLISTCLOSE procedure
of HTP package, 139
DLISTDEF function
of HTF package, 134
DLISTDEF procedure
of HTP package, 139
DLISTOPEN function
of HTF package, 134
DLISTOPEN procedure
of HTP package, 139
DLISTTERM function
of HTF package, 134
DLISTTERM procedure
of HTP package, 139
DOMAttr methods, 124
DOMCDataSection methods, 124
DOMCharacterData methods, 124
DOMComment methods, 124
DOMDocument methods, 124
DOMDocumentType methods, 124, 124
DOMEntity methods, 124
DOMNamedNodeMap methods, 124
DOMText methods, 124
DOWNGRADE procedure, 114
DOWNLOAD_FILE procedures, 180
DROP_ALL function, 104
DROP_APPLY procedure, 15
DROP_ATTRIBUTE_SET procedure, 39
DROP_BASELINE procedure, 118
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, 118
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, 122
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, 177
EM function
of HTF package, 134
EM procedure
of HTP package, 139
e-mail from PL/SQL (email), 178
EMPHASIS function
of HTF package, 134
EMPHASIS procedure
of HTP package, 139
ENABLE procedure, 68
ENABLE_AT_SYSTEM_CHANGE_NUMBER procedure, 43
ENABLE_AT_TIME procedure, 43
ENABLE_BREAKPOINT function, 30
ENABLE_HIERARCHY procedure, 123
ENABLE_PROPAGATION_SCHEDULE Procedure, 58
END_REQUEST procedure, 168
END_RESPONSE procedure, 168
ENDCREATE member procedure
of ANYDATA TYPE, 181
of ANYDATASET TYPE, 182
of ANYTYPE TYPE, 183
ENQUEUE procedure, 108
ENQUEUE_ARRAY Function, 16
ENQUEUE_OPTIONS_T Type, 184
ERASE Procedures, 52
error queue
deleting errors, 15, 15
executing errors, 15, 15
getting error messages, 15
errors
DBMS_DATA_MINING, 25
ESCAPE function, 179
ESCAPE_SC function
of HTF package, 134
ESCAPE_SC procedure
of HTP package, 139
ESCAPE_URL function
of HTF package, 134
ESCAPEURI function, 185
ESTIMATE_CPU_UNITS function, 63
ESTIMATE_MVIEW_SIZE Procedure, 61
ETINSTANCE member function
of ANYDATASET TYPE, 182
EVALUATE procedure, 91
EXACT_TEXT_SIGNATURES procedure, 66
EXEC_DDL_STATEMENT procedure, 116
EXECUTE function, 100
EXECUTE member procedure, 188, 188
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, 186
EXF$ATTRIBUTE_LIST object type, 186
EXF$INDEXOPER object type, 186
EXF$TABLE_ALIAS object type, 186
EXF$XPATH_TAG object type, 186
EXF$XPATH_TAGS object type, 186
EXISTSNODE function, 197
EXISTSRESOURCE function, 120
EXPAND_MESSAGE function, 94
EXPLAIN procedure, 72
EXPONENTIAL_DIST_FIT procedure, 102
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, 186
extend window
to create a new view, 22
EXTRACT function, 197

F

FCLOSE procedure, 167
FCLOSE_ALL procedure, 167
FCOPY procedure, 167
features, new, Preface
FETCH_ROW Function, 45
FETCH_ROWS function, 100
FFLUSH procedure, 167
FGETATTR procedure, 167
FGETPOS function, 167
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, 124
FINDNOTATION function, 124
fine-grained access control
DBMS_RLS package, 89
FINISH_REDEF_TABLE procedure, 77
FIX_CORRUPT_BLOCKS procedure, 79
FLUSH procedure, 178
FLUSH_DATA function and procedure, 73
FLUSH_DATABASE_MONITORING_INFO procedure, 103
FONTCLOSE function
of HTF package, 134
FONTCLOSE procedure
of HTP package, 139
FONTOPEN function
of HTF package, 134
FONTOPEN procedure
of HTP package, 139
FOPEN function, 167
FOPEN_NCHAR function, 167
FORCE parameter
and job-to-instance affinity, 48
FORMAT_CALL_STACK Function, 116
FORMAT_CELL function
of HTF package, 134
FORMAT_ERROR_BACKTRACE function, 116
FORMAT_ERROR_STACK function, 116
FORMCHECKBOX function
of HTF package, 134
FORMCHECKBOX procedure
of HTP package, 139
FORMCLOSE function
of HTF package, 134, 134
FORMCLOSE procedure
of HTP package, 139
FORMFILE function
of HTF package, 134
FORMFILE procedure
of HTP package, 139, 139
FORMHIDDEN function
of HTF package, 134
FORMHIDDEN procedure
of HTP package, 139
FORMIMAGE function
of HTF package, 134
FORMIMAGE procedure
of HTP package, 139
FORMOPEN function
of HTF package, 134
FORMOPEN procedure
of HTP package, 139
FORMPASSWORD function
of HTF package, 134
FORMPASSWORD procedure
of HTP package, 139
FORMRADIO function
of HTF package, 134
FORMRADIO procedure
of HTP package, 139
FORMRESET function
of HTF package, 134
FORMRESET procedure
of HTP package, 139
FORMSELECTCLOSE function
of HTF package, 134
FORMSELECTCLOSE procedure
of HTP package, 139
FORMSELECTOPEN function
of HTF package, 134
FORMSELECTOPEN procedure
of HTP package, 139
FORMSELECTOPTION function
of HTF package, 134
FORMSELECTOPTION procedure
of HTP package, 139
FORMSUBMIT function
of HTF package, 134
FORMSUBMIT procedure
of HTP package, 139
FORMTEXT function
of HTF package, 134
FORMTEXT procedure
of HTP package, 139
FORMTEXTAREA function
of HTF package, 134
FORMTEXTAREA procedure
of HTP package, 139
FORMTEXTAREA2 function
of HTF package, 134
FORMTEXTAREA2 procedure
of HTP package, 139
FORMTEXTAREACLOSE function
of HTF package, 134
FORMTEXTAREACLOSE procedure
of HTP package, 139
FORMTEXTAREAOPEN function
of HTF package, 134
FORMTEXTAREAOPEN procedure
of HTP package, 139
FORMTEXTAREAOPEN2 function
of HTF package, 134
FORMTEXTAREAOPEN2 procedure
of HTP package, 139
FRAME function
of HTF package, 134
FRAME procedure
of HTP package, 139
FRAMESETCLOSE function
of HTF package, 134
FRAMESETCLOSE procedure
of HTP package, 139
FRAMESETOPEN function
of HTF package, 134
FRAMESETOPEN procedure
of HTP package, 139
FREE_BLOCKS procedure, 98
FREEDOCFRAG procedure, 124
FREEDOCUMENT procedure, 124
FREENODE procedure, 124
FREEPARSER procedure, 126
FREEPROCESSOR procedure, 132
FREESTYLESHEET procedure, 132
FREETEMPORARY Procedures, 52
FREMOVE procedure, 167, 167
FRENAME procedure, 167
FSEEK procedure, 167
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, 129
GENERATESCHEMA function, 129
GENERATESCHEMAS function, 129
GET function
of OWA_COOKIE package, 141
GET* member functions
of ANYDATA TYPE, 181
of ANYDATASET TYPE, 182
GET_ACLOID function, 123
GET_ALL procedure, 141
GET_ALL_DAD_ATTRIBUTES Procedure, 37
GET_ALL_DAD_MAPPINGS Procedure, 37
GET_ALL_GLOBAL_ATTRIBUTES Procedure, 37
GET_ALL_NAMES member function, 196
GET_ASSOCIATION_RULES function, 25
GET_AUTHENTICATION procedure, 168
GET_BASE_TABLE_NAME member function, 188
GET_BASE_TABLE_OWNER member function, 188
GET_BODY_CHARSET procedure, 168
GET_CATEGORY function, 117
GET_CGI_ENV function, 148
GET_CLIENT_HOSTNAME function, 146
GET_CLIENT_IP function, 146
GET_COLUMN_STATS procedures, 103
GET_COMMAND_TYPE member function, 188
GET_COMMIT_SCN member function, 188
GET_COMMON_TIME_ZONES Function, 169
GET_COMPATIBLE member function, 188
GET_COOKIE_COUNT function, 168
GET_COOKIE_SUPPORT procedure, 168
GET_COOKIES function, 168
GET_CPU_TIME function, 116
GET_CURRENT_SCHEMA member function, 188
GET_DAD_ATTRIBUTE Procedure, 37
GET_DAD_LIST Procedure, 37
GET_DEFAULT_ISO_CURRENCY Function, 169
GET_DEFAULT_LINGUISTIC_SORT Function, 169
GET_DEFAULT_SETTINGS function, 25
GET_DEPENDENCY procedure, 116
GET_DETAILED_EXCP_SUPPORT procedure, 168
GET_DETAILED_SQLCODE function, 168
GET_DETAILED_SQLERRM function, 168
GET_ERROR_MESSAGE function, 15
GET_ETAG function, 140
GET_EXPRSET_STATS procedure, 39
GET_EXTRA_ATTRIBUTE member function, 188
GET_FILE procedure, 42
GET_FOLLOW_REDIRECT procedure, 168
GET_FREQUENT_ITEMSETS function, 25
GET_GLOBAL_ATTRIBUTE Function, 37
GET_HASH_VALUE function, 116
GET_HEADER procedure, 168
GET_HEADER_BY_NAME procedure, 168
GET_HEADER_COUNT function, 168
GET_HOST_ADDRESS function, 170
GET_HOST_NAME function, 170
GET_IN_PARAMETER_TYPES function, 165
GET_INDEX_STATS procedures, 103
GET_INDEXES function, 30
GET_INFORMATION function, 105
GET_LEVEL function, 140
GET_LINE function, 178
GET_LINE procedure, 68, 167
GET_LINE_MAP function, 30
GET_LINE_NCHAR procedure, 167
GET_LINES procedure, 68
GET_LOB_INFORMATION member function, 188
GET_LOB_OFFSET member function, 188
GET_LOB_OPERATION_SIZE member procedure, 188
GET_LOCAL_LINGUISTIC_SORTS Function, 169
GET_LOGON_USER member function, 188
GET_LONG_INFORMATION member function, 188
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, 188
GET_OBJECT_OWNER member function, 188
GET_OBJECT_TYPE member function, 188
GET_OUT_PARAMETER_TYPES function, 165
GET_OUTPUT_VALUES function, 165
GET_OWA_SERVICE_PATH function, 148
GET_PARAM function, 103
GET_PARAMETER_VALUE function, 116
GET_PASSWORD function, 146
GET_PERSISTENT_CONN_COUNT function, 168
GET_PERSISTENT_CONN_SUPPORT procedure, 168
GET_PERSISTENT_CONNS procedure, 168
GET_PORTS function, 165
GET_POST_PROCESSED_SOURCE Procedure, 71
GET_PROCEDURE function, 148
GET_PROPERTY function, 165
GET_PROXY procedure, 168
GET_RAW function, 167, 178
GET_REC_ATTRIBUTES Procedure, 12
GET_RESPONSE function, 168
GET_RESPONSE_ERROR_CHECK procedure, 168
GET_RETURN_TYPE function, 165
GET_ROWID function, 144
GET_RUNTIME_INFO function, 30
GET_SCN member function, 188
GET_SCN_MAPPING procedure, 106
GET_SERVICES function, 165
GET_SESSION_TIMEOUT function, 87
GET_SOURCE_DATABASE_NAME member function, 188
GET_SOURCE_TIME member function, 188
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, 188
GET_TASK_REPORT Procedure, 12
GET_TASK_SCRIPT Procedure, 12
GET_TEXT function, 178
GET_THRESHOLD procedure, 94
GET_TIME function, 116
GET_TIMEOUT function, 87
GET_TIMEOUT_BEHAVIOUR function, 30
GET_TRANSACTION_ID member function, 188
GET_TRANSFER_TIMEOUT procedure, 168
GET_USER_ID function, 146
GET_USERID function, 123
GET_VALUE function, 30
GET_VALUE member function, 188, 196
GET_VALUE Procedure, 45
GET_VALUE_RAW Procedure, 45
GET_VALUES member function, 188
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, 143
GET_Y function, 143
GETACLDOCUMENT function, 120
GETATTRELEMINFO member function
of ANYTYPE TYPE, 183
GETATTRIBUTE function, 124
GETATTRIBUTENODE function, 124
GETATTRIBUTES function, 124
GETBLOB function, 185, 185, 185, 185
GETBLOBVAL function, 197
GETBUBLICID function, 124
GETCHILDNODES function, 124
GETCHILDRENBYTAGNAME function, 124
GETCHUNKSIZE Functions, 52
GETCLOB function, 185, 185, 185, 185
GETCLOBVAL function, 197
GETCONTENTSBLOBBYRESID function, 121
GETCONTENTSCLOBBYRESID function, 121, 121
GETCONTENTSXMLBYRESID function, 121
GETCONTENTTYPE function, 185, 185, 185, 185
GETCOUNT member function
of ANYDATASET TYPE, 182
GETDATA function, 124
GETDCHARSET function, 124
GETDOCTYPE function, 124, 126
GETDOCUMENT function, 126
GETDOCUMENTELEMENT function, 124
GETDTD function, 127
GETDTD procedure, 127
GETELEMENTSBYTAGNAME function, 124, 124
GETENTITIES function, 124
GETEXCEPTIONCONTENT procedure, 127, 128
GETEXPANDEDNAME function, 124, 124
GETEXPANDEDNAME procedure, 124
GETEXTERNALURL function, 185, 185, 185, 185
GETFIRSTCHILD function, 124
GETFTPPORT Function, 120
GETHTTPPORT Function, 120
GETIMPLEMENTATION function, 124
GETINFO member function
of ANYTYPE TYPE, 183
GETLASTCHILD function, 124
GETLENGTH function, 124, 124, 124
GETLENGTH Functions, 52
GETLOCKTOKEN procedure, 120
GETNAME function, 124, 124
GETNAMEDITEM function, 124
GETNAMESPACE function, 124, 124
GETNAMESPACE procedure, 124
GETNEXTSIBLING function, 124
GETNODENAME function, 124
GETNODETYPE function, 124
GETNODEVALUE function, 124
GETNOTATIONNAME function, 124
GETNOTATIONS function, 124
GETNUMBERVAL function, 197
GETNUMROWSPROCESSED function, 125
GETNUMROWSPROCESSED procedure, 127
GETOWNERDOCUMENT function, 124
GETOWNERELEMENT function, 124
GETPARENTNODE function, 124
GETPAT procedure, 145
GETPERSISTENT static function
of ANYTYPE TYPE, 183
GETPREDECESSORS function, 121
GETPREDSBYRESID function, 121
GETPREFIX function, 124
GETPREVIOUSSIBLING function, 124
GETPRIVILEGES function, 120
GETPUBLICID function, 124, 124
GETQUALIFIEDNAME function, 124, 124
GETRELEASEVERSION function, 126
GETRESOID function, 120
GETRESOURCEBYRESID function, 121
GETROOTELEMENT function, 197
GETRUL function, 185
GETSCHEMANODE function, 124
GETSCHEMAURL function, 197
GETSPECIFIED function, 124
GETSTANDALONE function, 124
GETSTRINGVAL function, 197
GETSUCCESSORS function, 121
GETSUCCSBYRESID function, 121
GETSYSTEMID function, 124, 124, 124
GETTAGNAME function, 124
GETTARGET function, 124
GETTYPE member function
of ANYDATA TYPE, 181
of ANYDATASET TYPE, 182
GETTYPENAME member function
of ANYDATA TYPE, 181
of ANYDATASET TYPE, 182
GETURL function, 185, 185, 185, 185
GETVALIDATIONMODE function, 126
GETVALUE function, 124
GETVERSION function, 124
GETVERSION procedure, 127
GETXDB_TABLESPACE function, 120
GETXML function, 125, 127, 185, 185, 185, 185
GETXML procedure, 127
GETXMLTYPE function, 124, 125
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, 124
HASCHILDNODES function, 124
HASFEATURE function, 124
HEADCLOSE function
of HTF package, 134
HEADCLOSE procedure
of HTP package, 139
HEADER function
of HTF package, 134
HEADER procedure
of HTP package, 139
HEADOPEN function
of HTF package, 134
HEADOPEN procedure
of HTP package, 139
HELO function and procedure, 177
HELP function, 177
HR function
of HTF package, 134
HR procedure
of HTP package, 139
HTF package, 134
HTML tags
applet tags
functions, 134
procedures, 139
atags tags
procedures, 139
character formatting tags
functions, 134
procedures, 139
form tags
functions, 134
procedures, 139
frame tags
functions, 134
procedures, 139
list tags
functions, 134
procedures, 139
paragraph formatting tags
functions, 134
procedures, 139
table tags
functions, 134
HTMLCLOSE function
of HTF package, 134
HTMLCLOSE procedure
of HTP package, 139
HTMLDB_APPLICATION package documentation, 136
HTMLDB_CUSTOM_AUTH package documentation, 135
HTMLDB_ITEM package documentation, 137
HTMLDB_UTIL package documentation, 138
HTMLOPEN function
of HTF package, 134
HTMLOPEN procedure
of HTP package, 139
HTP package, 139
HTTP_HEADER_CLOSE procedure, 148
HttpUriType, 185
HTTPURITYPE function, 185
HttpUriType subtype, 185
CREATEURI function, 185
GETBLOB function, 185
GETCLOB function, 185
GETCONTENTTYPE function, 185
GETEXTERNALURL function, 185
GETRUL function, 185
GETXML function, 185
HTTPURITYPE function, 185
methods, 185

I

IMG function
of HTF package, 134
IMG procedure
of HTP package, 139
IMG2 procedure
of HTP package, 139
IMPLEMENT_TASK Procedure, 12
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, 124
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, 124
INSERTDATA procedure, 124
INSERTXML function, 128, 130
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, 170
INTERRUPT_TASK Procedure, 12
INTERRUPT_TUNING_TASK procedure, 101
INTERVAL procedure, 48
INVALIDATE Procedure, 116
INVOKE function, 165
IS_CLUSTER_DATABASE function, 116
IS_HIERARCHY_ENABLED function, 123
IS_LOCATOR function, 163
IS_NULL_TAG member function, 188
IS_OPEN function, 100, 167
IS_TRIGGER_FIRE_ONCE function, 29
ISFRAGMENT function, 197
ISINDEX function
of HTF package, 134
ISINDEX procedure
of HTP package, 139
ISNULL function, 124
ISOPEN function, 164
ISOPEN Functions, 52
ISSCHEMABASED function, 197
ISSCHEMAVALID function, 197
ISSCHEMAVALIDATED function, 197
ISTEMPORARY Functions, 52
ITALIC function
of HTF package, 134
ITALIC procedure
of HTP package, 139
ITEM Functions, 124

K

KBD function
of HTF package, 134
KBD procedure
of HTP package, 139
KEEP procedure, 97
KEYBOARD function
of HTF package, 134
KEYBOARD procedure
of HTP package, 139

L

LAPACK Driver Routines (Linear Equations) Subprograms, 173
LAPACK Driver Routines (LLS and Eigenvalue Problems), 173
LAPACK_GBSV Procedures, 173
LAPACK_GEES Procedures, 173
LAPACK_GEEV Procedures, 173
LAPACK_GELS Procedures, 173
LAPACK_GESDD Procedures, 173
LAPACK_GESV Procedures, 173
LAPACK_GESVD Procedures, 173
LAPACK_GTSV Procedures, 173
LAPACK_PBSV Procedures, 173
LAPACK_POSV Procedures, 173
LAPACK_PPSV Procedures, 173
LAPACK_PTSV Procedures, 173
LAPACK_SBEV Procedures, 173
LAPACK_SBEVD Procedures, 173
LAPACK_SPEV Procedures, 173
LAPACK_SPEVD Procedures, 173
LAPACK_SPSV Procedures, 173
LAPACK_STEV Procedures, 173
LAPACK_STEVD Procedures, 173
LAPACK_SYEV Procedures, 173
LAPACK_SYEVD Procedures, 173
LAPACK_SYSV Procedures, 173
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, 188
LCR$_ROW_LIST type, 188
LCR$_ROW_RECORD type, 188
LCR$_ROW_UNIT type, 188
GET_LOB_INFORMATION member function, 188
GET_LOB_OPERATION_SIZE member procedure, 188
GET_LONG_INFORMATION member function, 188
SET_LOB_INFORMATION member procedure, 188
SET_LOB_OPERATION_SIZE member procedure, 188
LCR_TO_XML Function, 59
LENGTH function, 174
LINE function
of HTF package, 134
LINE procedure
of HTP package, 139
LINK procedure, 120
LINKREL function
of HTF package, 134
LINKREL procedure
of HTP package, 139
LINKREV function
of HTF package, 134
LINKREV procedure
of HTP package, 139
LISTHEADER function
of HTF package, 134
LISTHEADER procedure
of HTP package, 139
LISTINGCLOSE function
of HTF package, 134
LISTINGCLOSE procedure
of HTP package, 139
LISTINGOPEN function
of HTF package, 134
LISTINGOPEN procedure
of HTP package, 139
LISTITEM function
of HTF package, 134
LISTITEM procedure
of HTP package, 139
LISTPRINT procedure, 148
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, 176
LOCK_SCHEMA_STATS procedure, 103
LOCK_TABLE_STATS procedure, 103
LOCKRESOURCE function, 120
log apply services
managing initialization parameters for logical standby databases, 56
logical change records (LCRs)
DDL LCRs, 188
getting base table name, 188
getting base table owner, 188
getting current schema, 188
getting logon user name, 188
getting object type, 188
setting base table name, 188
setting base table owner, 188
setting current schema, 188
setting DDL text, 188
setting logon user, 188
setting object type, 188
determining if tag is NULL, 188
executing, 188, 188
extra attributes
excluding, 20
including, 20
getting command type, 188
getting commit SCN, 188
getting compatibility information, 188
getting extra attributes, 188
getting LCR creation time, 188
getting object name, 188
getting object owner, 188
getting SCN, 188
getting source database name, 188
getting tag, 188
getting transaction identifier, 188
LCR$_DDL_RECORD type, 188
LCR$_ROW_LIST type, 188
LCR$_ROW_RECORD type, 188
LCR$_ROW_UNIT type, 188
row LCRs, 188
adding value to column, 188
converting LONG to LOB, 188
deleting value to column, 188
getting column value, 188
getting list of column values, 188
getting LOB offset, 188
renaming column, 188
setting column value, 188
setting list of column values, 188
setting LOB offset, 188
setting command type, 188
setting extra attributes, 188
setting object name, 188
setting object owner, 188
setting source database name, 188
setting tag, 188
types, 188
logical standby databases
managing with DBMS_LOGSTDBY package, 56
LOGSTDBY_ADMINISTRATOR role, 56
LZ_COMPRESS functions and procedures, 164
LZ_COMPRESS_ADD procedure, 164
LZ_COMPRESS_CLOSE procedure, 164
LZ_COMPRESS_OPEN function, 164
LZ_UNCOMPRESS functions and procedures, 164
LZ_UNCOMPRESS_CLOSE procedure, 164
LZ_UNCOMPRESS_EXTRACT procedure, 164
LZ_UNCOMPRESS_OPEN function, 164

M

MAIL function and procedure, 177
MAILTO function
of HTF package, 134
MAILTO procedure
of HTP package, 139
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, 124
MAKECDATASECTION function, 124
MAKECHARACTERDATA function, 124
MAKECOMMENT function, 124
MAKEDOCUMENT function, 124
MAKEDOCUMENTFRAGMENT function, 124
MAKEDOCUMENTTYPE function, 124
MAKEELEMENT function, 124
MAKEENTITY function, 124
MAKEENTITYREFERENCE function, 124
MAKENODE function, 124, 124, 124, 124
MAKENOTATION function, 124
MAKEPROCESSINGINSTRUCTION function, 124
MAKETEXT function, 124
MAKEVERSIONED function, 121
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, 134
MAPCLOSE procedure
of HTP package, 139
MAPOPEN function
of HTF package, 134
MAPOPEN procedure
of HTP package, 139
MARK_RECOMMENDATION Procedure, 12
MATCH function, 145
materialized view logs
master table
purging, 61, 61, 61
materialized views
refreshing, 61, 61, 61
MENULISTCLOSE function
of HTF package, 134
MENULISTCLOSE procedure
of HTP package, 139
MENULISTOPEN function
of HTF package, 134
MENULISTOPEN procedure
of HTP package, 139
MESSAGE_PROPERTIES_ARRAY_T Type, 184
MESSAGE_PROPERTIES_T Type, 184
messaging client
messaging client user, 106
rules
for LCRs, 106
for user messages, 106
META function
of HTF package, 134
META procedure
of HTP package, 139
methodology
transformation, 26
MG2 function
of HTF package, 134
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, 148
MIMEHEADER_DECODE function, 166
MIMEHEADER_ENCODE function, 166
min-max normalization, 26
missing value treatment, 26
MODIFY_OPERATOR_LIST procedure, 39
MODIFY_SERVICE Procedure, 95
MODIFY_SNAPSHOT_SETTINGS procedure, 118
MODIFY_TRANSFORMATION procedure, 112
MOVEXDB_TABLESPACE procedure, 120
MSGID_ARRAY_T Type, 184

N

NAME_RESOLVE procedure, 116
NAME_TOKENIZE procedure, 116
NAMESPACE function, 197
new features, Preface
NEW_LINE procedure, 68, 167
NEW_ROW_LIST function and procedure, 147
NEWCONTEXT function, 125, 127, 128, 130
NEWDOMDOCUMENT function, 124
NEWPARSER function, 126
NEWPROCESSOR function, 132
NEWSTYLESHEET function, 132
NEXT_DATE procedure, 48
NEXT_ITEM_TYPE function, 70
NL function
of HTF package, 134
NL procedure
of HTP package, 139
NOBR function
of HTF package, 134
NOBR procedure
of HTP package, 139
NOFRAMESCLOSE function
of HTF package, 134
NOFRAMESCLOSE procedure
of HTP package, 139
NOFRAMESOPEN function
of HTF package, 134
NOFRAMESOPEN procedure
of HTP package, 139
NOOP function and procedure, 177
NORMAL function, 75
NORMAL_DIST_FIT procedure, 102
normalization, 26
min-max, 26
z-score, 26
NORMALIZE procedure, 124
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, 134
OLISTCLOSE procedure
of HTP package, 139
OLISTOPEN function
of HTF package, 134
OLISTOPEN procedure
of HTP package, 139
One-Class SVM, 25, 25, 25, 25, 25, 25, 25
ONLINE_INDEX_CLEAN Function, 79
OPEN Procedures, 52
OPEN_CONNECTION function, 178
OPEN_CONNECTION functions, 177
OPEN_CURSOR Function, 45
OPEN_CURSOR function, 100
OPEN_DATA function and procedure, 177
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, 188
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, 188
rule types, 196
OVERLAY function, 174
OWA_CACHE package, 140
OWA_COOKIE package, 141
OWA_CUSTOM package, 142
OWA_IMAGE package, 143
OWA_OPT_LOCK package, 144
OWA_PATTERN package, 145
OWA_SEC package, 146
OWA_TEXT package, 147
OWA_UTIL package, 148

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, 120
DBMS_XMLDOM, 124
DBMS_XMLGEN, 125
DBMS_XMLPARSER, 126
DBMS_XMLQUERY, 127
DBMS_XMLSAVE, 128
DBMS_XMLSCHEMA, 129
UriFactory, 185
Package - UriFactory, 185
package overview, 1
package variables
i_am_a_refresh, 61
packages
creating, 1
referencing, 1
where documented, 1
PARA function
of HTF package, 134
PARA procedure
of HTP package, 139
PARAGRAPH function
of HTF package, 134
PARAGRAPH procedure
of HTP package, 139
PARAM function
of HTF package, 134
PARAM procedure
of HTP package, 139
PARSE Procedure, 45
PARSE procedure, 100, 126
PARSEBUFFER procedure, 126
PARSECLOB procedure, 126
PARSEDTD procedure, 126
PARSEDTDBUFFER procedure, 126
PARSEDTDCLOB procedure, 126
PAUSE_PROFILER function and procedure, 73
PIECEWISE member procedure
of ANYDATA TYPE, 181
of ANYDATASET TYPE, 182
PING procedure, 30
PLAINTEXT function
of HTF package, 134
PLAINTEXT procedure
of HTP package, 139
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, 134
PRECLOSE procedure
of HTP package, 139
PREDICT procedure, 72
PREOPEN function
of HTF package, 134
PREOPEN procedure
of HTP package, 139
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, 134
PRINT procedure
of HTP package, 139
PRINT_BACKTRACE procedure, 30
PRINT_CGI_ENV procedure, 148
PRINT_INSTANTIATIONS procedure, 30
PRINT_MULTI procedure, 147
PRINT_POST_PROCESSED_SOURCE Procedure, 71
PRINT_ROW_LIST procedure, 147
PRINTS procedure
of HTP package, 139
privileges
DBMS_LOGSTDBY package, 56
granting, 39
Oracle Streams administrator, 107, 107
revoking, 39
PRN function
of HTF package, 134
PRN procedure
of HTP package, 139
PROBE_VERSION procedure, 30
PROCESS_RULES procedure, 88
PROCESSXSL function, 132
PROGRAM_INFO Record Type, 30
PROPAGATEORIGINALEXCEPTION procedure, 127, 128
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, 139
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, 123
purging
the subscription window, 22
PUT procedure, 167
PUT procedures, 68
PUT_FILE procedure, 42
PUT_LINE procedure, 167
PUT_LINE procedures, 68
PUT_LINE_NCHAR procedure, 167
PUT_NCHAR procedure, 167
PUT_RAW function, 167
PUTF procedure, 167
PUTF_NCHAR procedure, 167

Q

quantile numerical binning, 26
query generation, 26
queues
AnyData
creating, 106
removing, 106
QUICK_TUNE Procedure, 12
QUIT function and procedure, 177
QUOTED_PRINTABLE_DECODE function, 166
QUOTED_PRINTABLE_ENCODE function, 166

R

RANDOM procedure, 75
RANK_APPLY procedure, 25
RCPT function, 177
RE$ATTRIBUTE_VALUE type, 196
RE$ATTRIBUTE_VALUE_LIST type, 196
RE$COLUMN_VALUE type, 196, 196
RE$COLUMN_VALUE_LIST type, 196
RE$NAME_ARRAY type, 196
RE$NV_ARRAY type, 196
RE$NV_LIST type, 196
ADD_PAIR member procedure, 196
GET_ALL_NAMES member function, 196
GET_VALUE member function, 196
REMOVE_PAIR member procedure, 196
RE$RULE_HIT type, 196
RE$RULE_HIT_LIST type, 196
RE$TABLE_ALIAS type, 196
RE$TABLE_ALIAS_LIST type, 196
RE$TABLE_VALUE type, 196
RE$TABLE_VALUE_LIST type, 196
RE$VARIABLE_TYPE type, 196
RE$VARIABLE_TYPE_LIST type, 196
RE$VARIABLE_VALUE type, 196
RE$VARIABLE_VALUE_LIST type, 196
READ Procedures, 52
READ_CLIENT_INFO procedure, 14
READ_LINE function, 178
READ_LINE procedure
of UTL_HTTP, 168
READ_MODULE procedure, 14
READ_ONLY procedure, 111
READ_RAW function, 178
READ_RAW procedure
of UTL_HTTP, 168
READ_TEXT function, 178
READ_TEXT procedure
of UTL_HTTP, 168
READ_WRITE procedure, 111
READ2CLOB function, 132
REBUILD_FREELISTS procedure, 79
RECEIVE_MESSAGE function, 70
RECOMP_PARALLEL procedure, 175
RECOMP_SERIAL procedure, 175
REDIRECT_URL procedure, 148
refresh
materialized views, 61, 61, 61
REFRESH_PRIVATE_OUTLINE procedure, 67
REGISTER procedure, 13
REGISTER_DEPENDENT_OBJECT procedure, 77
REGISTER_FOREIGN_QUEUE Procedure, 58
REGISTERSCHEMA procedure, 129
REGISTERURI procedure, 129
REGISTERURLHANDLER procedure, 185
RELEASE function, 53
RELEASE_ALL_SERVICES procedure, 165
RELEASE_CALL procedure, 165, 165
RELEASE_SERVICE procedure, 165
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, 141
REMOVE_FILE procedure, 41
REMOVE_MSGSYSTEM_LINK Procedure, 58
REMOVE_PAIR member procedure, 196
REMOVE_PIPE function, 70
REMOVE_PROPERTY procedure, 165
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, 124
REMOVEATTRIBUTENODE function, 124
REMOVENAMEDITEM function, 124
REMOVEPARAM procedure, 132
REMOVEXSLTPARAM procedure, 127, 128
RENAME_COLUMN member procedure, 188
RENAME_COLUMN procedure, 106
RENAME_MODEL procedure, 25
RENAME_SCHEMA procedure, 106
RENAME_TABLE procedure, 106
RENAMERESOURCE procedure, 120
REPLACECHILD function, 124
REPLACEDATA procedure, 124
replication
Oracle Streams
configuring, 106, 106, 106, 106, 106, 106, 106, 106
REPLY, REPLIES record types, 177
REPORT_TUNING_TASK function, 101
REQUEST function, 53, 168
REQUEST_PIECES function, 168
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, 132
RESOLVENAMESPACEPREFIX function, 124
RESTARTQUERY procedure, 125
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, 174
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, 195
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, 196
getting name-value pairs, 196
getting value for name, 196
removing name-value pairs, 196
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, 196
RE$ATTRIBUTE_VALUE_LIST type, 196
RE$COLUMN_VALUE type, 196, 196
RE$COLUMN_VALUE_LIST type, 196
RE$NAME_ARRAY type, 196
RE$NV_ARRAY type, 196
RE$NV_LIST type, 196
RE$RULE_HIT type, 196
RE$RULE_HIT_LIST type, 196
RE$TABLE_ALIAS type, 196
RE$TABLE_ALIAS_LIST type, 196
RE$TABLE_VALUE type, 196
RE$TABLE_VALUE_LIST type, 196
RE$VARIABLE_TYPE type, 196
RE$VARIABLE_TYPE_LIST type, 196
RE$VARIABLE_VALUE type, 196
RE$VARIABLE_VALUE_LIST type, 196
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, 196
Rules Manager object types, 195
RUN procedure, 48
RUNTIME_INFO Record Type, 30

S

S function
of HTF package, 134
S procedure
of HTP package, 139
SAMPLE function
of HTF package, 134
SAMPLE procedure
of HTP package, 139
SAVE function, 104
SAVEPOINT procedure, 111
SCHEDULE_PROPAGATION Procedure, 58
SCHEMAVALIDATE procedure, 197
SCN_TO_TIMESTAMP function, 43
SCRIPT function
of HTF package, 134
SCRIPT procedure
of HTP package, 139
SCRIPT_TUNING_TASK Function, 101
SDO_CS package documentation, 149
SDO_GCDR package documentation, 150
SDO_GEOM package documentation, 151
SDO_GEOR package documentation, 152
SDO_GEOR_UTL package documentation, 153
SDO_LRS package documentation, 154
SDO_MIGRATE package documentation, 155
SDO_NET package documentation, 156
SDO_NET_MEM package documentation, 157
SDO_SAM package documentation, 158
SDO_TOPO package documentation, 159
SDO_TOPO_MAP package documentation, 160
SDO_TUNE package documentation, 161
SDO_UTIL package documentation, 162
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, 176
SELECT_SQLSET function, 101, 101
SELECT_WORKLOAD_REPOSITORY functions, 101
SELECTNODES function, 132
SELECTSINGLENODE function, 132
SELF_CHECK procedure, 30
SEND procedure, 141, 172
SEND_ATTACH_RAW procedure, 172
SEND_ATTACH_VARCHAR2 procedure, 172
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, 181
of ANYDATASET TYPE, 182
SET_ACTION procedure, 14
SET_AUTHENTICATION procedure, 168
SET_AUTHORIZATION procedure, 146
SET_BASE_TABLE_NAME member procedure, 188
SET_BASE_TABLE_OWNER member procedure, 188
SET_BODY_CHARSET procedures, 168, 168
SET_BREAKPOINT function, 30
SET_CLIENT_INFO procedure, 14
SET_COLUMN_STATS procedures, 103
SET_COMMAND_TYPE member procedure, 188
SET_CONSUMER_GROUP_MAPPING procedure, 85
SET_CONSUMER_GROUP_MAPPING_PRI procedure, 85
SET_COOKIE_SUPPORT procedures, 168
SET_CURRENT_SCHEMA member procedure, 188
SET_DAD_ATTRIBUTE Procedure, 37
SET_DDL_TEXT member procedure, 188
SET_DEFAULT_SQLWKLD_PARAMETER Procedure, 12
SET_DEFAULT_TASK_PARAMETER Procedures, 12
SET_DEFAULTS procedure, 13
SET_DETAILED_EXCP_SUPPORT procedure, 168
SET_DML_HANDLER procedure, 15
SET_ENQUEUE_DESTINATION procedure, 15
SET_EXECUTE procedure, 15
SET_EXTRA_ATTRIBUTE member procedure, 188
SET_FOLLOW_REDIRECT procedures, 168
SET_GLOBAL_ATTRIBUTE Function, 37
SET_GLOBAL_INSTANTIATION procedure, 15
SET_HEADER procedure, 168
SET_INDEX_STATS procedures, 103
SET_INITIAL_CONSUMER_GROUP procedure, 85
SET_KEY_COLUMNS procedure, 15
SET_LOB_INFORMATION member procedure, 188
SET_LOB_OFFSET member procedure, 188
SET_LOB_OPERATION_SIZE member procedure, 188
SET_LOG_LEVEL Procedure, 58
SET_LOGON_USER member procedure, 188
SET_MAILHOST Procedure, 18
SET_MAILPORT Procedure, 18
SET_MESSAGE_NOTIFICATION procedure, 106
SET_MODULE procedure, 14
SET_OBJECT_NAME member procedure, 188
SET_OBJECT_OWNER member procedure, 188
SET_OBJECT_TYPE member procedure, 188
SET_OER_BREAKPOINT function, 30
SET_PARAM procedure, 103
SET_PARAMETER procedure, 20
apply process, 15
SET_PERSISTENT_CONN_SUPPORT procedure, 168
SET_PLSQL_TRACE procedure, 110
SET_PROPERTY procedure, 165
SET_PROTECTION_REALM procedure, 146
SET_PROXY procedure, 168
SET_RESPONSE_ERROR_CHECK procedure, 168
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, 188
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, 188
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, 168
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, 188
SET_VALUE_DEPENDENCY procedure, 15
SET_VALUES member procedure, 188
SET_WALLET procedure, 168
SET_WARNING_SETTING_STRING procedure, 117
SET_WATERMARK Procedure, 17
SETACL procedure, 120
SETATTRIBUTE procedure, 124
SETATTRIBUTENODE function, 124
SETBASEDIR procedure, 126
SETBATCHSIZE procedure, 128
SETBINDVALUE procedure, 127
SETCOLLIDATTRNAME procedure, 127
SETCOMMITBATCH procedure, 128
SETCONVERTSPECIALCHARS procedure, 125
SETDATA procedure, 124
SETDATAHEADER procedure, 127
SETDATEFORMAT procedure, 127, 128
SETDCHARSET procedure, 124
SETDOCTYPE Procedure, 124
SETDOCTYPE procedure, 126
SETDVERSION procedure, 124
SETENCODINGTAG procedure, 127
SETERRORLOG procedure, 126, 132
SETERRORTAG procedure, 127
SETFTPPORT Procedure, 120
SETHTTPPORT Procedure, 120
SETIGNORECASE procedure, 128
SETINFO member procedure
of ANYTYPE TYPE, 183
SETKEYCOLUMN procedure, 128, 130
SETMAXROWS procedure, 125, 127
SETMETAHEADER procedure, 127
SETNAMEDITEM function, 124
SETNODEVALUE procedure, 124
SETPARAM procedure, 132
SETPREFIX procedure, 124
SETPRESERVEWHITESPACE procedure, 126, 128
SETRAISEEXCEPTION procedure, 127
SETRAISENOROWSEXCEPTION procedure, 127
SETROWIDATTRNAME procedure, 127
SETROWIDATTRVALUE procedure, 127
SETROWSETTAG procedure, 125, 127
SETROWTAG procedure, 127, 128, 130
SETSCHEMAVALIDATED procedure, 197
SETSKIPROWS procedure, 125, 127
SETSQLTOXMLNAMEESCAPING procedure, 127, 128
SETSTANDALONE procedure, 124
SETSTYLESHEETHEADER procedure, 127
SETTAGCASE procedure, 127
SETUPDATECOLUMN procedure, 128, 130
SETVALIDATIONMODE procedure, 126
SETVALUE procedure, 124
SETXSLT procedure, 127, 128
SETXSLTPARAM procedure, 127, 128
SHOW_BREAKPOINTS procedures, 30
SHOW_FRAME_SOURCE procedure, 30
SHOW_SOURCE procedures, 30
SHOWPAGE procedure, 148
SHOWSOURCE procedure, 148
SHOWWARNINGS procedure, 126, 132
SHUTDOWN Procedure, 58
SIGNAL procedure, 13
SIGNATURE procedure, 148
SIZES procedure, 97
SKIP_CORRUPT_BLOCKS procedure, 79
SLEEP procedure, 53
SMALL function
of HTF package, 134
SMALL procedure
of HTP package, 139
snapshot. See DBMS_MVIEW, 61
SOURCE_LINES_T Table Type, 71
SPACE_ERROR_INFO function, 87
SPACE_USAGE procedure, 98
SPLITTEXT function, 124
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, 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, 133
STATUS_LINE procedure, 148
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, 144
stored outlines
DBMS_OUTLN, 66
OUTLN_PKG package, 66
STREAM2MULTI procedure, 147
Streams
removing configuration, 106
STREAMS$_TRANSFORM_FUNCTION, 106
STRIKE function
of HTF package, 134
STRIKE procedure
of HTP package, 139
STRING function, 75
STRING_TO_RAW Function, 169
STRONG function
of HTF package, 134
STRONG procedure
of HTP package, 139
STYLE function
of HTF package, 134
STYLE procedure
of HTP package, 139
SUB procedure
of HTP package, 139
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, 174
SUBSTR Functions, 52
SUBSTRINGDATA function, 124
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, 123
Summary of DBMS_XMLDOM Subprograms, 124
Summary of DBMS_XMLSCHEMA Subprograms, 129
Summary of UTL_LMS Subprograms, 171
SUMMARY procedure, 102
SUP function
of HTF package, 134
SUP procedure
of HTP package, 139
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, 186
TABLE_TO_COMMA procedures, 116
TABLECAPTION function
of HTF package, 134
TABLECAPTION procedure
of HTP package, 139
TABLECLOSE function
of HTF package, 134
TABLECLOSE procedure
of HTP package, 139
TABLEDATA function
of HTF package, 134
TABLEDATA procedure
of HTP package, 139
TABLEHEADER function
of HTF package, 134
TABLEHEADER procedure
of HTP package, 139
TABLEOPEN function
of HTF package, 134
TABLEOPEN procedure
of HTP package, 139
TABLEPRINT function, 148
TABLEROWCLOSE function
of HTF package, 134
TABLEROWCLOSE procedure
of HTP package, 139
TABLEROWOPEN function
of HTF package, 134
TABLEROWOPEN procedure
of HTP package, 139
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
tags
GET_TAG function, 105
SET_TAG procedure, 105
TARGET_PROGRAM_RUNNING procedure, 30
TELETYPE function
of HTF package, 134
TELETYPE procedure
of HTP package, 139
TERMINATE procedure, 75
TEXT_DECODE function, 166
TEXT_ENCODE function, 166
TIMESTAMP_TO_SCN function, 43
TITLE function
of HTF package, 134, 134
TITLE procedure
of HTP package, 139
TODATE function, 148
TOOBJECT procedure, 197
top-N frequency binning, 26
TRACETAB.SQL, 110
transform definition table, 26
TRANSFORM function, 197
transformations
binning, 26
equi-width binning, 26
missing value treatment, 26
normalization, 26
rule-based
adding a column, 106
custom, 106
deleting a column, 106
renaming a column, 106
renaming a schema, 106
renaming a table, 106
STREAMS$_TRANSFORM_FUNCTION, 106
sample, 26
steps in defining, 26
supported, 26
winsorizing, 26
TRANSFORMNODE function, 132
TRANSLATE function, 174
TRANSLITERATE Function, 169
TRANSPORT_SET_CHECK procedure, 114
TRIM Procedures, 52
trimming, 26
TUNE_MVIEW Procedure, 12
types
Expression Filter, 186
Rules Manager, 195

U

ULISTCLOSE function
of HTF package, 134
ULISTCLOSE procedure
of HTP package, 139
ULISTOPEN function
of HTF package, 134
ULISTOPEN procedure
of HTP package, 139
UNASSIGN_ATTRIBUTE_SET procedure, 39
UNCHECKOUT function, 121
UNDERLINE function
of HTF package, 134
UNDERLINE procedure
of HTP package, 139
UNESCAPE function, 179
UNESCAPEURI function, 185
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, 120
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, 185
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, 176
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, 120
UPDATEXML function, 128, 130
UPGRADE_STAT_TABLE procedure, 103
upgrading
post-upgrade actions, 62
URI Types
description, 185
UriFactory package, 185
ESCAPEURI function, 185
GETURL function, 185
methods, 185
REGISTERURLHANDLER procedure, 185
UNESCAPEURI function, 185
UNREGISTERURLHANDLER procedure, 185
UriType supertype, 185
GETBLOB function, 185
GETCLOB function, 185
GETCONTENTTYPE function, 185
GETEXTERNALURL function, 185
GETURL function, 185
GETXML function, 185
methods, 185
USE_ROLLBACK_SEGMENT procedure, 111
USEITEMTAGSFORCOLL procedure, 125
USENULLATTRIBUTEINDICATOR procedure, 125, 127
user views
DBMS_DATA_MINING, 25
USER_EXPORT procedures, 48
USETYPEFORCOLLELEMTAG procedure, 127
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, 124
Using DBMS_XMLSCHEMA, 129
Using UTL_HTTP, 168
UTL_COLL package, 163
UTL_COMPRESS package, 164
UTL_DBWS package, 165
UTL_ENCODE package, 166
UTL_FILE package, 167
UTL_HTTP package, 168
UTL_I18N package, 169
ESCAPE_REFERENCE function, 169, 169, 169, 169, 169, 169, 169
GET_DEFAULT_CHARSET function, 169
MAP_CHARSET function, 169
MAP_LANGUAGE_FROM_ISO function, 169
MAP_LOCALE_TO_ISO function, 169
MAP_TERRITORY_FROM_ISO function, 169
RAW_TO_CHAR function, 169
RAW_TO_NCHAR function, 169
UNESCAPE_REFERENCE function, 169
UTL_INADDR package, 170
UTL_LMS package, 171
FORMAT_MESSAGE function, 171
GET_MESSAGE function, 171
UTL_MAIL package, 172
UTL_NLA package, 173
UTL_RAW package, 174
UTL_RECOMP package, 175
UTL_REF package, 176
UTL_TCP package, 178
UTL_URL package, 179
UUDECODE function, 166
UUENCODE function, 166

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, 132
VARIABLE function
of HTF package, 134
VARIABLE procedure
of HTP package, 139
VARIABLE_VALUE procedures, 100
VERIFY_VALUES function, 144
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, 177

W

WAITANY procedure, 13
WAITONE procedure, 13
WBR function
of HTF package, 134
WBR procedure
of HTP package, 139
WEIBULL_DIST_FIT procedure, 102
WHAT procedure, 48
WHO_CALLED_ME procedure, 148
winsorizing, 26
WPG_DOCLOAD package, 180
WRAP Functions, 29
WRITE Procedures, 52
WRITE_DATA procedure, 177
WRITE_LINE function, 178
WRITE_LINE procedure, 168
WRITE_RAW function, 178
WRITE_RAW procedure, 168
WRITE_RAW_DATA procedure, 177
WRITE_TEXT function, 178
WRITE_TEXT procedure, 168
WRITEAPPEND Procedures, 52
WRITETOBUFFER procedure, 124
WRITETOCLOB procedure, 124
WRITETOFILE procedure, 124

X

XDBUriType, 185
XDBURITYPE function, 185
XDBUriType subtype, 185
CREATEURI function, 185
GETBLOB function, 185
GETCLOB function, 185
GETCONTENTTYPE function, 185
GETEXTERNALURL function, 185
GETURL function, 185
GETXML function, 185
methods, 185
XDBURITYPE function, 185
XDBZ Constants, 123
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, 186
XML_TO_LCR Function, 59
XMLType
CREATENONSCHEMABASEDXML function, 197
CREATESCHEMABASEDXML function, 197
CREATEXML function, 197
description, 197
EXISTSNODE function, 197
EXTRACT function, 197
GETBLOBVAL function, 197
GETCLOBVAL function, 197
GETNUMBERVAL function, 197
GETROOTELEMENT function, 197
GETSCHEMAURL function, 197
GETSTRINGVAL function, 197
ISFRAGMENT function, 197
ISSCHEMABASED function, 197
ISSCHEMAVALID function, 197
ISSCHEMAVALIDATED function, 197
NAMESPACE function, 197
SCHEMAVALIDATE procedure, 197
SETSCHEMAVALIDATED procedure, 197
TOOBJECT procedure, 197
TRANSFORM function, 197
XMLTYPE function, 197
XMLTYPE function, 197
XPath parameters
adding to attribute list, 39
dropping from attribute list, 39
XPath predicates
indexing set of
configuring XML element or XML attribute, 186
XPINDEX_PARAMETERS procedure, 39
XRANGE function, 174

Z

z-score normalization, 26