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

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

Go to previous page
Previous
View PDF

Index

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

A

ABORT procedure, 87
ABORT_GLOBAL_INSTANTIATION procedure, 20
ABORT_REDEF_TABLE procedure, 77
ABORT_SCHEMA_INSTANTIATION procedure, 20
ABORT_TABLE_INSTANTIATION procedure, 20
ABORTED_REQUEST_THRESHOLD procedure, 97
ACCEPT_SQL_PROFILE procedure, 101
ACLCHECKPRIVILEGES function, 121
ACTIVATE_SUBSCRIPTION Procedure, 22
ACTIVE_INSTANCES procedure, 116
ADD_COLUMN member procedure, 189
ADD_COLUMN procedure, 106
ADD_COOKIES procedure, 169
ADD_ELEMENTARY_ATTRIBUTE procedure, 39, 88
ADD_EVENT procedure, 88
ADD_FILE procedure, 41
ADD_FILTER Procedure, 118
ADD_FUNCTIONS procedure, 39, 88
ADD_GLOBAL_PROPAGATION_RULES procedure, 106
ADD_GLOBAL_RULES procedure, 106
ADD_MESSAGE_PROPAGATION_RULE procedure, 106
ADD_MESSAGE_RULE procedure, 106
ADD_PAIR member procedure, 197
ADD_RULE procedure, 88, 92
ADD_SCHEMA_PROPAGATION_RULES procedure, 106
ADD_SCHEMA_RULES procedure, 106
ADD_SQLSET_REFERENCE function, 101
ADD_SQLWKLD_REF Procedure, 12
ADD_SQLWKLD_STATEMENT Procedure, 12
ADD_SUBSCRIBER Procedure, 58
ADD_SUBSET_PROPAGATION_RULES procedure, 106
ADD_SUBSET_RULES procedure, 106
ADD_TABLE_PROPAGATION_RULES procedure, 106
ADD_TABLE_RULES procedure, 106
ADD_WARNING_SETTING_CAT procedure, 117
ADD_WARNING_SETTING_NUM procedure, 117
ADD2MULTI procedure, 148
ADDATTR member procedure
of ANYTYPE TYPE, 184
ADDINSTANCE member procedure
of ANYDATASET TYPE, 183
ADDRESS function
of HTF package, 135
ADDRESS procedure
of HTP package, 140
ADMIN_TABLES procedure, 79
ADVISE_COMMIT procedure, 111
ADVISE_NOTHING procedure, 111
ADVISE_ROLLBACK procedure, 111
ALLOCATE_UNIQUE procedure, 53
ALTER_AGENT Procedure, 58
ALTER_APPLY procedure, 15
ALTER_CAPTURE procedure, 20
ALTER_COMPILE procedure, 29
ALTER_DATABASE_TAB_MONITORING procedure, 103
ALTER_EVALUATION_CONTEXT procedure, 92
ALTER_FILE procedure, 41
ALTER_FILE_GROUP procedure, 41
ALTER_MSGSYSTEM_LINK Procedure for TIB/Rendezvous, 58
ALTER_MSGSYSTEM_LINK Procedure for WebSphere MQ, 58
ALTER_PROPAGATION procedure, 74
ALTER_PROPAGATION_SCHEDULE Procedure, 58
ALTER_REWRITE_EQUIVALENCE Procedure, 11
ALTER_RULE procedure, 92
ALTER_SCHEMA_TAB_MONITORING procedure, 103
ALTER_SQL_PROFILE procedure, 101
ALTER_STATS_HISTORY_RETENTION procedure, 103
ALTER_SUBSCRIBER Procedure, 58
ALTER_TABLE_NOT_REFERENCEABLE procedure, 29
ALTER_TABLE_REFERENCEABLE procedure, 29
ALTER_VERSION procedure, 41
AMATCH function, 146
ANALYZE_DATABASE procedure, 116
ANALYZE_PART_OBJECT procedure, 116
ANALYZE_SCHEMA procedure, 116
ANCHOR function
of HTF package, 135
ANCHOR procedure
of HTP package, 140
ANCHOR2 function
of HTF package, 135
ANCHOR2 procedure
of HTP package, 140
anomaly detection, 25, 25, 25, 25, 25, 25, 25, 25
anonymous PL/SQL blocks
dynamic SQL and, 100
AnyData datatype
queues
creating, 106
removing, 106
ANYDATA TYPE, 182
ANYDATASET TYPE, 183
ANYTYPE TYPE, 184
APPEND Procedures, 52
APPENDCHILD function, 125
APPENDDATA procedure, 125
APPENDRESOURCEMETADATA Procedure, 121
APPLETCLOSE function
of HTF package, 135
APPLETCLOSE procedure
of HTP package, 140
APPLETOPEN function
of HTF package, 135
APPLETOPEN procedure
of HTP package, 140
APPLY procedure, 25
apply process
altering, 15
apply user, 106
conflict handlers
setting, 15
creating, 15, 106, 106, 106, 106, 106
DBMS_APPLY_ADM package, 15
DDL handler
setting, 15, 15
DML handlers
setting, 15
dropping, 15
enqueuing events, 15
error handlers
setting, 15
error queue
deleting errors, 15, 15
executing errors, 15, 15
getting error messages, 15
instantiation
global SCN, 15
schema SCN, 15
table SCN, 15
message handler
setting, 15, 15
parameters
allow_duplicate_rows, 15
commit_serialization, 15
disable_on_error, 15
disable_on_limit, 15
maximum_scn, 15
parallelism, 15
setting, 15
startup_seconds, 15
time_limit, 15
trace_level, 15
transaction_limit, 15
txn_lcr_spill_threshold, 15
precommit handler
setting, 15, 15
rules
defining global, 106
defining message, 106
defining schema, 106
defining subset, 106
defining table, 106
for LCRs, 106
for user messages, 106
removing, 106
specifying execution, 15
starting, 15
stopping, 15
substitute key columns
setting, 15
APPLY$_ENQUEUE, 15
APPLY$_EXECUTE, 15
AQ$_AGENT Type, 185
AQ$_AGENT_LIST_T Type, 185
AQ$_DESCRIPTOR Type, 185, 185
AQ$_POST_INFO Type, 185
AQ$_POST_INFO_LIST Type, 185
AQ$_PURGE_OPTIONS_T Type, 185
AQ$_RECIPIENT_LIST_T Type, 185
AQ$_REG_INFO Type, 185
AQ$_REG_INFO_LIST Type, 185
AQ$_SUBSCRIBER_LIST_T Type, 185
AREA function
of HTF package, 135
AREA procedure
of HTP package, 140
arrays
BIND_ARRAY procedure, 100
bulk DML using DBMS_SQL, 100, 100
ASA_RECO_ROW Record Type, 98
ASA_RECO_ROW_TB Table Type, 98
ASA_RECOMMENDATIONS Function, 98
ASH_REPORT_HTML Function, 119
ASH_REPORT_TEXT Function, 119
ASSIGN_ATTRIBUTE_SET procedure, 39
ASSM_SEGMENT_VERIFY Procedure, 99
ASSM_TABLESPACE_VERIFY Procedure, 99
ATTACH_SESSION procedure, 30
ATTACH_SIMPLE_TABLESPACE procedure, 109
ATTACH_TABLESPACES procedure, 109
attribute sets
dropping, 39
AUTHORIZE function, 143
AUTHORIZE_DAD Procedure, 37
AVAILABLE function, 179
AWR_DIFF_REPORT_HTML Function, 119
AWR_DIFF_REPORT_TEXT Function, 119
AWR_REPORT_HTML function, 119
AWR_REPORT_TEXT function, 119
AWR_SQL_REPORT_HTML Function, 119
AWR_SQL_REPORT_TEXT Function, 119

B

BASE function
of HTF package, 135
BASE procedure
of HTP package, 140
BASE64_DECODE function, 167
BASE64_ENCODE function, 167
BASEFONT function
of HTF package, 135
BASEFONT procedure
of HTP package, 140
BEGIN_DISCRETE_TRANSACTION procedure, 111
BEGIN_REQUEST function, 169
BEGINCREATE static procedure
of ANYDATA TYPE, 182
of ANYDATASET TYPE, 183
of ANYTYPE TYPE, 184
BGSOUND function
of HTF package, 135
BGSOUND procedure
of HTP package, 140
BIG function
of HTF package, 135
BIG procedure
of HTP package, 140
BIND_ARRAY procedures, 100
BIND_INOUT_VARIABLE Procedure, 45
BIND_INOUT_VARIABLE_RAW Procedure, 45
BIND_OUT_VARIABLE Procedure, 45
BIND_OUT_VARIABLE_RAW Procedure, 45
BIND_VARIABLE Procedure, 45
BIND_VARIABLE procedures, 100
BIND_VARIABLE_RAW Procedure, 45
BIND_VARIABLES function, 149
binning, 26
categorical, 26
numerical, 26, 26
quantile, 26
BIT_AND function, 175
BIT_COMPLEMENT function, 175
BIT_OR function, 175
BIT_XOR function, 175
BLAS Level 1 (Vector-Vector Operations) Subprograms, 174
BLAS Level 2 (Matrix-Vector Operations) Subprograms, 174
BLAS Level 3 (Matrix-Matrix Operations) Subprograms, 174
BLAS_ASUM Functions, 174
BLAS_AXPY Procedures, 174
BLAS_COPY Procedures, 174
BLAS_DOT Functions, 174
BLAS_GBMV Procedures, 174
BLAS_GEMM Procedures, 174
BLAS_GEMV Procedures, 174
BLAS_GER Procedures, 174
BLAS_IAMAX Functions, 174
BLAS_NRM2 Functions, 174
BLAS_ROT Procedures, 174
BLAS_ROTG Procedures, 174
BLAS_SBMV Procedures, 174
BLAS_SCAL Procedure, 174
BLAS_SPMV Procedures, 174
BLAS_SPR Procedures, 174
BLAS_SPR2 Procedures, 174
BLAS_SWAP Procedure, 174
BLAS_SYMM Procedures, 174
BLAS_SYMV Procedures, 174
BLAS_SYR Procedures, 174
BLAS_SYR2 Procedures, 174
BLAS_SYRK Procedures, 174
BLAS_TBMV Procedures, 174
BLAS_TBSV Procedures, 174
BLAS_TPMV Procedures, 174
BLAS_TPSV Procedures, 174
BLAS_TRMM Procedures, 174
BLAS_TRMV Procedures, 174
BLAS_TRSM Procedures, 174
BLAS_TRSV Procedures, 174
BLOCKQUOTECLOSE function
of HTF package, 135
BLOCKQUOTECLOSE procedure
of HTP package, 140, 140
BLOCKQUOTEOPEN function
of HTF package, 135
BLOCKQUOTEOPEN procedure
of HTP package, 140
BODYCLOSE function
of HTF package, 135
BODYCLOSE procedure
of HTP package, 140
BODYOPEN function
of HTF package, 135
BODYOPEN procedure
of HTP package, 140
BOLD function
of HTF package, 135
BOLD procedure
of HTP package, 140
BR function
of HTF package, 135
BR procedure
of HTP package, 140
BREAKPOINT_INFO Record Type, 30
BROKEN procedure, 48
BUILD procedure, 20
BUILD_CHAIN_ROWS_TABLE procedure, 46
BUILD_EXCEPTIONS_TABLE procedure, 39, 46
BUILD_PART_INDEX procedure, 69
BUILD_SAFE_REWRITE_EQUIVALENCE Procedure, 11

C

CALENDARPRINT procedures, 149
CAN_REDEF_TABLE procedure, 77
CANCEL_TASK Procedure, 12
CANCEL_TUNING_TASK procedure, 101
CANONICALIZE procedure, 116
capture process
altering, 20
building a Streams data dictionary, 20
capture user, 106
creating, 106, 106, 106, 106
DBMS_CAPTURE_ADM package, 20
instantiation
aborting database preparation, 20
aborting schema preparation, 20
aborting table preparation, 20
preparing a database for, 20
preparing a schema for, 20
preparing a table for, 20
parameters
disable_on_limit, 20
downstream_real_time_mine, 20
maximum_scn, 20
message_limit, 20
parallelism, 20
setting, 20
startup_seconds, 20
time_limit, 20
trace_level, 20
write_alert_log, 20
rules, 106
defining global, 106
defining schema, 106
defining subset, 106
defining table, 106
removing, 106
starting, 20
stopping, 20
CAPTURE_CURSOR_CACHE_SQLSET Procedure, 101
CAST_FROM_BINARY_DOUBLE function, 175
CAST_FROM_BINARY_FLOAT function, 175
CAST_FROM_BINARY_INTEGER function, 175
CAST_FROM_NUMBER function, 175
CAST_TO_BINARY_DOUBLE function, 175
CAST_TO_BINARY_FLOAT function, 175
CAST_TO_BINARY_INTEGER function, 175
CAST_TO_NUMBER function, 175
CAST_TO_NVARCHAR2 function, 175
CAST_TO_RAW function, 175
CAST_TO_VARCHAR2 function, 175
categorical binning, 26
catproc.sql script, 1
CELLSPRINT procedures, 149
CENTER function
of HTF package, 135
CENTER procedure
of HTP package, 140
CENTERCLOSE function
of HTF package, 135
CENTERCLOSE procedure
of HTP package, 140
CENTEROPEN function
of HTF package, 135
CENTEROPEN procedure
of HTP package, 140
CFG_GET function, 121
CFG_REFRESH procedure, 121
CFG_UPDATE procedure, 121
Change Data Capture
DBMS_CDC_PUBLISH package, 21
CHANGE functions and procedures, 146
CHANGE procedure, 48
change tables
tablespaces created in, 21
CHANGE_JOIN_POS procedure, 67
CHARARR Table Type, 68
CHECK_OBJECT procedure, 79
CHECKIN function, 122
CHECKOUT procedure, 122
CHECKPRIVILEGES function, 121
CHECKSUM functions, 145
CHNF$_DESC Object Type, 23
CHNF$_RDESC Object Type, 23
CHNF$_RDESC_ARRAY Object Type, 23
CHNF$_REG_INFO Object Type, 23
CHNF$_TDESC Object Type, 23
CHNF$_TDESC_ARRAY Object (Array) Type, 23
CHOOSE_DATE procedure, 149
CITE function
of HTF package, 135
CITE procedure
of HTP package, 140
CLEANUP_GATEWAY Procedure, 58
CLEANUP_INSTANTIATION_SETUP procedure, 106
CLEAR_ALL_CONTEXT Procedure, 96
CLEAR_CONTEXT Procedure, 96
CLEAR_COOKIES procedure, 169
CLEAR_EXPRSET_STATS procedure, 39
CLEAR_IDENTIFIER Procedure, 96
CLEAR_PENDING_AREA procedure, 85
CLEAR_PLSQL_TRACE procedure, 110
CLEAR_USED procedure, 66
CLEARKEYCOLUMNLIST procedure, 129, 131
CLEARUPDATECOLUMNLIST procedure, 129, 131
CLIENT_ID_STAT_DISABLE procedure, 60
CLIENT_ID_STAT_ENABLE procedure, 60
CLIENT_ID_TRACE_DISABLE procedure, 60
CLIENT_ID_TRACE_ENABLE procedure, 60
clipping
see trimming, 26
CLOB2FILE procedure, 133
CLONE_SIMPLE_TABLESPACE procedure, 109
CLONE_TABLESPACES procedure, 109
CLONENODE function, 125
CLOSE Procedure, 52
CLOSE_ALL_CONNECTIONS procedure, 179
CLOSE_CONNECTION procedure, 179
CLOSE_CURSOR Procedure, 45
CLOSE_CURSOR procedure, 100
CLOSE_ITERATOR procedure, 91
CLOSE_PERSISTENT_CONN procedure, 169
CLOSE_PERSISTENT_CONNS procedure, 169
CLOSECONTEXT procedure, 126, 128, 129, 131
CODE function
of HTF package, 135
CODE procedure
of HTP package, 140
collections
table items, 100, 100
column masking for VPD, 89
COLUMN_VALUE procedure, 100
COLUMN_VALUE_LONG procedure, 100
column-level VPD, 89
COMMA_TO_TABLE procedures, 116
COMMAND function and procedure, 178
COMMAND_REPLIES function, 178
COMMENT function
of HTF package, 135
COMMENT procedure
of HTP package, 140
COMMIT procedure, 111
COMMIT_COMMENT procedure, 111
COMMIT_FORCE procedure, 111
COMPARE function, 175
COMPARE Functions, 52
COMPARE_OLD_VALUES procedure, 15
COMPATIBLE_10_1 function, 105, 189
COMPATIBLE_10_2 function, 105, 189
COMPATIBLE_9_2 function, 105, 189
COMPILE_FROM_REMOTE procedure, 51
COMPILE_SCHEMA procedure, 116
COMPILESCHEMA procedure, 130
COMPUTE_CONFUSION_MATRIX procedure, 25
COMPUTE_LIFT procedure, 25
COMPUTE_ROC procedure, 25
CONCAT function, 175
CONFIGUREAUTOSYNC procedure, 123
conflicts
detection
stopping, 15
CONNECTION record type, 178
constants
DBMS_DATA_MINING, 25
DBMS_MGWMSG package, 59
CONSUME_EVENT procedure, 88
CONSUME_PRIM_EVENT procedure, 88
CONTINUE function, 30
CONVERT function, 53, 126, 175
CONVERT_ANYDATA_TO_LCR_DDL function, 105
CONVERT_ANYDATA_TO_LCR_ROW function, 105
CONVERT_LCR_TO_XML function, 105
CONVERT_LONG_TO_LOB_CHUNK member procedure, 189
CONVERT_RAW_VALUE procedures, 103
CONVERT_RAW_VALUE_NVARCHAR procedure, 103
CONVERT_RAW_VALUE_ROWID procedure, 103
CONVERT_XML_TO_LCR function, 105
CONVERTTOBLOB procedure, 52
CONVERTTOCLOB procedure, 52
COPIES function, 175
COPY Procedures, 52
COPY_ATTRIBUTE_SET procedure, 39
COPY_FILE procedure, 42
COPY_TABLE_DEPENDENTS procedure, 77
COPYEVOLVE procedure, 130
CREATE PACKAGE BODY command, 1
CREATE PACKAGE command, 1
CREATE_ALTER_TYPE_ERROR_TABLE procedure, 116
CREATE_APPLY procedure, 15
CREATE_ATTRIBUTE_SET procedure, 39
CREATE_BASELINE function and procedure, 119
CREATE_BIN_CAT procedure, 26
CREATE_BIN_NUM procedure, 26
CREATE_CALL function, 166
CREATE_CAPTURE procedure
capture process
creating, 20
CREATE_CLIP procedure, 26
CREATE_CONSUMER_GROUP procedure, 85
CREATE_DAD Procedure, 37
CREATE_EDIT_TABLES procedure, 67
CREATE_ERROR_LOG Procedure, 38
CREATE_EVALUATION_CONTEXT procedure, 92
CREATE_EVENT_STRUCTURE procedure, 88
CREATE_FILE Procedure, 12
CREATE_FILE_GROUP procedure, 41
CREATE_INDEX_COST procedure, 98
CREATE_MISS_CAT Procedure, 26
CREATE_MISS_CAT procedure, 26
CREATE_MISS_NUM Procedure, 26
CREATE_MISS_NUM procedure, 26
CREATE_MODEL procedure, 25
CREATE_MSGSYSTEM_LINK Procedure for TIB/Rendezvous, 58
CREATE_MSGSYSTEM_LINK Procedure for WebSphere MQ, 58
CREATE_NORM_LIN procedure, 26
CREATE_OBJECT Procedure, 12
CREATE_OBJECT_DEPENDENCY procedure, 15
CREATE_OUTLINE procedure, 66
CREATE_PENDING_AREA procedure, 85
CREATE_PIPE function, 70
CREATE_PLAN procedure, 85
CREATE_PLAN_DIRECTIVE procedure, 85
CREATE_PROPAGATION procedure, 74
CREATE_RULE procedure, 92
CREATE_RULE_CLASS procedure, 88
CREATE_RULE_SET procedure, 92
CREATE_SERVICE function, 166
CREATE_SERVICE procedure, 95
CREATE_SIMPLE_PLAN procedure, 85
CREATE_SNAPSHOT function and procedure, 119
CREATE_SQLSET procedure, 101
CREATE_SQLWKLD Procedure, 12
CREATE_STAT_TABLE procedure, 103
CREATE_STGTAB_SQLPROF Procedure, 101
CREATE_STGTAB_SQSET Procedure, 101
CREATE_TABLE_COST procedures, 98
CREATE_TASK Procedures, 12
CREATE_TRANSFORMATION procedure, 112
CREATE_TUNING_TASK functions, 101
CREATE_VERSION procedure, 41
CREATE_WRAPPED Procedure, 29
CREATEATTRIBUTE function, 125
CREATECDATASECTION function, 125
CREATECOMMENT function, 125
CREATEDATASTOREPREF procedure, 123
CREATEDOCUMENT function, 125
CREATEDOCUMENTFRAGMENT function, 125
CREATEELEMENT function, 125
CREATEENTITYREFERENCE function, 125
CREATEFILTERPREF procedure, 123
CREATEFOLDER function, 121
CREATEINDEX procedure, 123
CREATELEXERPREF procedure, 123
CREATENONSCHEMABASEDXML function, 198
CREATEOIDPATH function, 121
CREATEPREFERENCES procedure, 123
CREATEPROCESSINGINSTRUCTION function, 125
CREATERESOURCE function, 121
CREATESCHEMABASEDXML function, 198
CREATESECTIONGROUPPREF procedure, 123
CREATESTOPLISTPREF procedure, 123
CREATESTORAGEPREF procedure, 123
CREATETEMPORARY Procedures, 52
CREATETEXTNODE function, 125
CREATEURI function, 186, 186, 186
CREATEWORLDLISTPREF procedure, 123
CREATEXML function, 198
creating
packages, 1
CTX_ADM package documentation, 2
CTX_CLS package documentation, 3
CTX_DDL package documentation, 4
CTX_DOC package documentation, 5
CTX_OUTPUT package documentation, 6
CTX_QUERY package documentation, 7
CTX_REPORT package documentation, 8
CTX_THES package documentation, 9
CTX_ULEXER package documentation, 10
CURRENT_INSTANCE function, 116
cursors
DBMS_SQL package, 100

D

data dictionary
removing Streams information, 106
DATA function and procedure, 178
data mining
automated, 72
overview, 25
transformations, 26
data types
table of, 25, 26
DATA_BLOCK_ADDRESS_BLOCK function, 116
DATA_BLOCK_ADDRESS_FILE function, 116
database
locking
OWA_OPT_LOCK package, 145
database tables
creating for DBMS_TRACE, 110
DATABASE_TRACE_DISABLE Procedure, 60
DATABASE_TRACE_ENABLE Procedure, 60
datatypes
DBMS_DESCRIBE, 34
PL/SQL
numeric codes for, 34
DB_CONNECT_INFO Procedure, 58
DB_VERSION procedure, 116
DBA privileges
for DBMS_LOGSTDBY packages, 56
DBA privileges for the DBMS_LOGSTDBY package, 56
DBMS, 125
DBMS_ALERT package, 13
DBMS_APPLICATION_INFO package, 14
DBMS_APPLY_ADM package, 15
DBMS_AQADM Constants, 17
DBMS_AQELM package, 18
DBMS_AQIN package, 19
DBMS_CAPTURE package, 185
DBMS_CAPTURE_ADM package, 20
DBMS_CDC_PUBLISH package, 21
ALTER_AUTOLOG_CHANGE_SOURCE procedure, 21
ALTER_CHANGE_SET procedure, 21
ALTER_CHANGE_TABLE procedure, 21
ALTER_HOTLOG_CHANGE_SOURCE procedure, 21
CREATE_AUTOLOG_CHANGE_SOURCE procedure, 21
CREATE_CHANGE_SET procedure, 21
CREATE_CHANGE_TABLE procedure, 21
CREATE_HOTLOG_CHANGE_SOURCE procedure, 21
DROP_CHANGE_SET procedure, 21
DROP_CHANGE_SOURCE procedure, 21
DROP_CHANGE_TABLE procedure, 21, 21
DROP_SUBSCRIPTION procedure, 21
PURGE procedure, 21
PURGE_CHANGE_SET procedure, 21
PURGE_CHANGE_TABLE procedure, 21
DBMS_CDC_SUBSCRIBE package, 22
ACTIVATE_SUB SCRIPTION procedure, 22
CREATE_SUBSCRIPTION procedure, 22, 22
DROP_SUBSCRIBER_VIEW procedure, 22
DROP_SUBSCRIPTION procedure, 22
EXTEND_WINDOW procedure, 22
GET_SUBSCRIPTION_HANDLE procedure, 22
PREPARE_SUBSCRIBER_VIEW procedure, 22
PURGE_WINDOW procedure, 22
SUBSCRIBE procedure, 22
DBMS_CHANGE_NOTIFICATION package, 23
DBMS_DATA_MINING
constants, 25
data types, 25
introduction, 25
package, 25
subprograms, 25
user views, 25
DBMS_DATA_MINING_TRANSFORM
introduction, 26
package, 26
subprograms, 26
DBMS_DATAPUMP Package
GET_DUMPFILE_INFO procedure, 27
WAIT_FOR_JOB procedure, 27
DBMS_DATAPUMP package, 27
ADD_FILE procedure, 27
ATTACH function, 27
DATA_FILTER procedure, 27
DETACH procedure, 27
GET_STATUS procedure, 27
LOG_ENTRY procedure, 27
METADATA_FILTER procedure, 27
METADATA_REMAP procedure, 27
METADATA_TRANSFORM procedure, 27
OPEN function, 27
roles used by, 27
SET_PARALLEL procedure, 27
SET_PARAMETER procedure, 27
START_JOB procedure, 27
STOP_JOB procedure, 27
types used by, 27
DBMS_DB_VERSION package, 28
DBMS_DDL package, 29
DBMS_DEBUG package, 30
DBMS_DEFER package documentation, 31
DBMS_DEFER_QUERY package documentation, 32
DBMS_DEFER_SYS package documentation, 33
DBMS_DESCRIBE package, 34
DBMS_DIMENSION package, 35
DBMS_DISTRIBUTED_TRUST_ADMIN package, 36
DBMS_EPG package, 37, 37
DBMS_EXPFIL package, 39
ADD_ELEMENTARY_ATTRIBUTE, 39
ADD_FUNCTIONS, 39
ASSIGN_ATTRIBUTE_SET, 39
BUILD_EXCEPTIONS_TABLE, 39
CLEAR_EXPRSET_STATS, 39
COPY_ATTRIBUTE_SET, 39
CREATE_ATTRIBUTE_SET, 39
DEFAULT_INDEX_PARAMETERS, 39
DEFAULT_XPINDEX_PARAMETERS, 39
DEFRAG_INDEX, 39
DROP_ATTRIBUTE_SET, 39
GET_EXPRSET_STATS, 39
GRANT_PRIVILEGE, 39
INDEX_PARAMETERS, 39
MODIFY_OPERATOR_LIST, 39
REVOKE_PRIVILEGE, 39
UNASSIGN_ATTRIBUTE_SET, 39
VALIDATE_EXPRESSIONS, 39
XPINDEX_PARAMETERS, 39
DBMS_FGA package, 40
DBMS_FILE_GROUP package, 41
constants, 41
DBMS_FILE_TRANSFER package, 42
DBMS_FLASHBACK package, 43
DBMS_FREQUENT_ITEMSET package, 44
DBMS_HS_PASSTHROUGH package, 45
DBMS_IOT package, 46
DBMS_JAVA package documentation, 47
DBMS_JOB package, 48
DBMS_LDAP package documentation, 49
DBMS_LDAP_UTL package documentation, 50
DBMS_LIBCACHE package, 51
DBMS_LOB package, 52
DBMS_LOCK package, 53
DBMS_LOGMNR package, 54
ADD_LOGFILE procedure, 54
COLUMN_PRESENT function, 54
END_LOGMNR procedure, 54
MINE_VALUE function, 54
REMOVE_LOGFILE procedure, 54
START_LOGMNR procedure, 54
DBMS_LOGMNR_CDC_PUBLISH
See DBMS_CDC_PUBLISH, 21
DBMS_LOGMNR_CDC_SUBSCRIBE
See DBMS_CDC_SUBSCRIBE, 22
DBMS_LOGMNR_D package, 55
BUILD procedure, 55
SET_TABLESPACE procedure, 55
DBMS_LOGSTDBY package, 56
APPLY_SET procedure, 56
APPLY_UNSET procedure, 56
BUILD procedure, 56
case sensitivity, 56
deprecated subprograms, 56
INSTANTIATE_TABLE procedure, 56
operational notes, 56
overview of managing SQL Apply, 56
PREPARE_FOR_NEW_PRIMARY procedure, 56
privileges and security, 56
SKIP procedure, 56
SKIP_ERROR procedure, 56
SKIP_TRANSACTION procedure, 56
UNSKIP procedure, 56
UNSKIP_ERROR procedure, 56
UNSKIP_TRANSACTION procedure, 56
using, 56
DBMS_METADATA package, 57
ADD_TRANSFORM function, 57
CLOSE procedure, 57
CONVERT functions and procedures, 57
GET_DDL function, 57
GET_QUERY function, 57
GET_XML function, 57
OPEN function, 57
OPENW function, 57
PUT function, 57
security, 57
SET_COUNT procedure, 57
SET_FILTER procedure, 57
SET_PARSE_ITEM procedure, 57
SET_REMAP_PARAM procedure, 57
SET_TRANSFORM_PARAM procedure, 57
DBMS_MGWADM package
summary of subprograms, 58
DBMS_MGWMSG package
constants, 59
summary of subprograms, 59
DBMS_MONITOR package
stastics tracing and gathering
DBMS_MONITOR package, 60
DBMS_MVIEW package
BEGIN_TABLE_REORGANIZATION procedure, 61
END_TABLE_REORGANIZATION procedure, 61
EXPLAIN_MVIEW procedure, 61
EXPLAIN_REWRITE procedure, 61
I_AM_A_REFRESH function, 61
PMARKER function, 61
PURGE_DIRECT_LOAD_LOG procedure, 61
PURGE_LOG procedure, 61
PURGE_MVIEW_FROM_LOG procedure, 61
REFRESH procedure, 61
REFRESH_ALL_MVIEWS procedure, 61
REFRESH_DEPENDENT procedure, 61
REGISTER_MVIEW procedure, 61
UNREGISTER_MVIEW procedure, 61
DBMS_OBFUSCATION_TOOLKIT package, 62
DBMS_ODCI package, 63
ESTIMATE_CPU_UNITS function, 63
methods, 63
DBMS_OFFLINE_OG package documentation, 64
DBMS_OLAP package, 65
DBMS_OUTLN package, 66
DBMS_OUTLN_EDIT package, 67
DBMS_OUTPUT package, 68
DBMS_PCLXUTIL package, 69
DBMS_PIPE package, 70
DBMS_PREDICTIVE_ANALYTICS package, 72
DBMS_PREPROCESSOR package, 71
DBMS_PROFILER package, 73
DBMS_PROPAGATION_ADM package, 74
DBMS_RANDOM package, 75
DBMS_RECTIFIER_DIFF package documentation, 76
DBMS_REDEFINITION package, 77
DBMS_REFRESH package documentation, 78
DBMS_REPAIR package, 79
DBMS_REPCAT package documentation, 80
DBMS_REPCAT_ADMIN package documentation, 81
DBMS_REPCAT_INSTANTIATE package documentation, 82
DBMS_REPCAT_RGT package documentation, 83
DBMS_REPUTIL package documentation, 84
DBMS_RESOURCE_MANAGER package, 85
DBMS_RESOURCE_MANAGER_PRIVS package, 86
DBMS_RESUMABLE package, 87
DBMS_RLMGR package, 88
ADD_ELEMENTARY_ATTRIBUTE, 88
ADD_EVENT, 88
ADD_FUNCTIONS, 88
ADD_RULE, 88
CONSUME_EVENT, 88
CONSUME_PRIM_EVENT, 88
CREATE_EVENT_STRUCTURE, 88
CREATE_RULE_CLASS, 88
DELETE_RULE, 88
DROP_EVENT_STRUCTURE, 88
DROP_RULE_CLASS, 88
GRANT_PRIVILEGE, 88
PROCESS_RULES, 88
RESET_SESSION, 88
REVOKE_PRIVILEGE, 88
DBMS_RLS package, 89
DBMS_RLS.ADD_GROUPED_POLICY parameters
enable, 89
function_schema, 89
long_predicate, 89
object_name, 89
object_schema, 89
policy_function, 89
policy_group, 89
policy_name, 89
policy_type, 89
sec_relevant_cols, 89
statement_types, 89
static_policy, 89
update_check, 89
DBMS_RLS.ADD_POLICY parameters
enable, 89
function_schema, 89
long_predicate, 89
object_name, 89
object_schema, 89
policy_function, 89
policy_name, 89
policy_type, 89
sec_relevant_cols, 89
sec_relevant_cols_opt, 89
statement_types, 89
static_policy, 89
update_check, 89
DBMS_RLS.ADD_POLICY policy types
CONTEXT_SENSITIVE, 89
DYNAMIC, 89
SHARED_CONTEXT_SENSITIVE, 89
SHARED_STATIC, 89
STATIC, 89
DBMS_RLS.ADD_POLICY_CONTEXT parameters
attribute, 89
namespace, 89
object_name, 89
object_schema, 89
DBMS_RLS.CREATE_POLICY_GROUP parameters
object_name, 89
object_schema, 89
policy_group, 89
DBMS_RLS.DELETE_POLICY_GROUP parameters
object_name, 89
object_schema, 89
policy_group, 89
DBMS_RLS.DISABLE_GROUPED_POLICY parameters
group_name, 89
object_name, 89
object_schema, 89
policy_name, 89
DBMS_RLS.DROP_GROUPED_POLICY parameters
object_name, 89, 89
object_schema, 89, 89
policy_group, 89
policy_name, 89, 89
DBMS_RLS.DROP_POLICY_CONTEXT parameters
attribute, 89
namespace, 89
object_name, 89
object_schema, 89
DBMS_RLS.ENABLE_GROUPED_POLICY parameters
enable, 89
group_name, 89
object_name, 89
object_schema, 89
policy_name, 89
DBMS_RLS.ENABLE_POLICY parameters
enable, 89
object_name, 89
object_schema, 89
policy_name, 89
DBMS_RLS.REFRESH_GROUPED_POLICY parameters
group_name, 89
object_name, 89
object_schema, 89
policy_name, 89
DBMS_RLS.REFRESH_POLICY parameters
object_name, 89
object_schema, 89
policy_name, 89
DBMS_ROWID package, 90
DBMS_RULE package, 91
DBMS_RULE_ADM package, 92
DBMS_SCHEDULER package, 93
DBMS_SERVER_ALERT package, 94
DBMS_SERVICE package, 95
DBMS_SESSION package, 96
DBMS_SHARED_POOL package, 97
DBMS_SPACE package, 98
DBMS_SPACE_ADMIN package, 99
DBMS_SQL package, 100
DBMS_SQLTUNE package, 101
DBMS_STAT_FUNCS package, 102
DBMS_STATS package, 103
DBMS_STORAGE_MAP package, 104
DBMS_STREAMS package, 105
DBMS_STREAMS_ADM package, 106
deprecated subprograms, 106
DBMS_STREAMS_AUTH package, 107
DBMS_STREAMS_MESSAGING package, 108
DBMS_STREAMS_TABLESPACE package, 109
DBMS_TDB package, 113
DBMS_TDB.CHECK_DB procedure, 113, 113
DBMS_TRACE package, 110
DBMS_TRANSACTION package, 111
DBMS_TRANSFORM package, 112
DBMS_TTS package, 114
DBMS_TYPES package, 115
DBMS_UTILITY package, 116
DBMS_WARNING package, 117
DBMS_WM package documentation, 120
DBMS_WORKLOAD_RECORD package, 118
DBMS_WORKLOAD_REPOSITORY package, 119
DBMS_XBD_VERSION package, 122
DBMS_XDB Constants, 121
DBMS_XDB Overview, 121
DBMS_XDB package, 121
ACLCHECKPRIVILEGES function, 121
CFG_GET function, 121
CFG_REFRESH procedure, 121
CFG_UPDATE procedure, 121
CHECKPRIVILEGES function, 121
CONFIGUREAUTOSYNC procedure, 123
constants, 121
ConText synchronization settings, 123
CREATEDATASTOREPREF procedure, 123
CREATEFILTERPREF procedure, 123
CREATEFOLDER function, 121
CREATEINDEX procedure, 123
CREATELEXERPREF procedure, 123
CREATEOIDPATH function, 121
CREATEPREFERENCES procedure, 123
CREATERESOURCE function, 121
CREATESECTIONGROUPPREF procedure, 123
CREATESTOPLISTPREF procedure, 123
CREATESTORAGEPREF procedure, 123
CREATEWORLDLISTPREF procedure, 123
DELETERESOURCE procedure, 121
DROPPREFERENCES procedure, 123
EXISTSRESOURCE function, 121
filtering settings, 123
general indexing settings, 123
GETACLDOCUMENT function, 121
GETLOCKTOKEN procedure, 121
GETRESOID function, 121
GETXDB_TABLESPACE function, 121
LINK procedure, 121
LOCKRESOURCE function, 121
methods, 121, 123
miscellaneous settings, 123
MOVEXDB_TABLESPACE procedure, 121
other index preference settings, 123
REBUILDHIERARCHICALINDEX procedure, 121
RENAMERESOURCE procedure, 121
sectioning and section group settings, 123
SETACL procedure, 121
stoplist settings, 123
SYNC settings, 123
UNLOCKRESOURCE function, 121
DBMS_XDB_VERSION package
CHECKIN function, 122
CHECKOUT procedure, 122
GETCONTENTSBLOBBYRESID function, 122
GETCONTENTSCLOBBYRESID function, 122
GETCONTENTSXMLBYRESID function, 122
GETPREDECESSORS function, 122
GETPREDSBYRESID function, 122
GETRESOURCEBYRESID function, 122
GETSUCCESSORS function, 122
GETSUCCSBYRESID function, 122
MAKEVERSIONED function, 122
UNCHECKOUT function, 122
DBMS_XDBZ package
DISABLE_HIERARCHY procedure, 124
ENABLE_HIERARCHY procedure, 124
GET_ACLOID function, 124
GET_USERID function, 124
IS_HIERARCHY_ENABLED function, 124
PURGELDAPCACHE function, 124
DBMS_XMLDOM Constants, 125
DBMS_XMLDOM package, 125
APPENDDATA procedure, 125
CREATEATTRIBUTE function, 125
CREATECDATASECTION function, 125
CREATECOMMENT function, 125
CREATEDOCUMENT function, 125
CREATEDOCUMENTFRAGMENT, 125
CREATEELEMENT function, 125
CREATEENTITYREFERENCE function, 125
CREATEPROCESSINGINSTRUCTION function, 125
CREATETEXTNODE function, 125
DELETEDATA procedure, 125
description, 125
exceptions, 125
FINDENTITY function, 125
FINDNOTATION function, 125
FREEDOCFRAG procedure, 125
FREEDOCUMENT procedure, 125
GETATTRIBUTE function, 125
GETATTRIBUTENODE function, 125
GETBUBLICID function, 125
GETCHARSET function, 125
GETCHILDRENBYTAGNAME function, 125
GETDATA function, 125
GETDOCTYPE function, 125
GETDOCUMENTELEMENT function, 125
GETELEMENTSBYTAGNAME function, 125, 125
GETENTITIES function, 125
GETEXPANDEDNAME function, 125, 125
GETIMPLEMENTATION function, 125
GETLENGTH function, 125, 125, 125
GETNAME function, 125, 125
GETNAMEDITEM function, 125
GETNAMESPACE function, 125, 125
GETNAMESPACE procedure, 125
GETNEXTSIBLING function, 125
GETNODENAME function, 125
GETNODETYPE function, 125
GETNODEVALUE function, 125
GETNOTATIONNAME function, 125
GETNOTATIONS function, 125
GETOWNERDOCUMENT function, 125
GETOWNERELEMENT function, 125
GETPARENTNODE function, 125
GETPREFIX function, 125
GETPREVIOUSSIBLING function, 125
GETPUBLICID function, 125, 125
GETQUALIFIEDNAME function, 125, 125
GETSCHEMANODE function, 125
GETSPECIFIED function, 125
GETSTANDALONE function, 125
GETSYSTEMID function, 125, 125, 125
GETTAGNAME function, 125
GETTARGET function, 125
GETVALUE function, 125
GETVERSION function, 125
GETXMLTYPE function, 125
HASATTRIBUTE function, 125
HASATTRIBUTES function, 125
HASCHILDNODES function, 125
HASFEATURE function, 125
IMPORTNODE function, 125
INSERTBEFORE function, 125
INSERTDATA procedure, 125
ISNULL function, 125
MAKEATTR function, 125
MAKECDATASECTION function, 125
MAKECHARACTERDATA function, 125
MAKECOMMENT function, 125
MAKEDOCUMENT function, 125
MAKEDOCUMENTFRAGMENT function, 125
MAKEDOCUMENTTYPE function, 125
MAKEELEMENT function, 125
MAKEENTITY function, 125
MAKEENTITYREFERENCE function, 125
MAKENODE function, 125, 125, 125, 125
MAKENOTATION function, 125
MAKEPROCESSINGINSTRUCTION function, 125
MAKETEXT function, 125
methods
APPENDCHILD function, 125
APPENDDATA procedure, 125
CLONENODE function, 125
CREATEATTRIBUTE function, 125
CREATECDATASECTION function, 125
CREATECOMMENT function, 125
CREATEDOCUMENT function, 125
CREATEDOCUMENTFRAGMENT function, 125
CREATEELEMENT function, 125
CREATEENTITYREFERENCE function, 125
CREATEPROCESSINGINSTRUCTION function, 125
CREATETEXTNODE function, 125
DELETEDATA procedure, 125
DOMAttr interface, 125
DOMCDataSection interface, 125
DOMCharacterData interface, 125
DOMComment interface, 125
DOMDocument interface, 125
DOMDocumentFragment interface, 125, 125
DOMDocumentType interface, 125, 125
DOMElement interface, 125, 125
DOMEntity interface, 125, 125
DOMEntityReference interface, 125
DOMImplementation interface, 125
DOMNamedNodeMap interface, 125
DOMNode, 125, 125, 125, 125, 125, 125, 125, 125, 125
DOMNodeList interface, 125
DOMNotation interface, 125
DOMProcessingInstruction interface, 125
DOMText interface, 125, 125
FINDENTITY function, 125
FINDNOTATION function, 125
FREEDOCFRAG procedure, 125
FREEDOCUMENT procedure, 125
FREENODE procedure, 125
GETATTRIBUTE function, 125
GETATTRIBUTENODE function, 125
GETATTRIBUTES function, 125
GETBUBLICID function, 125
GETCHARSET function, 125
GETCHILDNODES function, 125
GETCHILDRENBYTAGNAME function, 125
GETDATA function, 125
GETDOCTYPE function, 125
GETDOCUMENTELEMENT function, 125
GETELEMENTSBYTAGNAME function, 125, 125
GETENTITIES function, 125
GETEXPANDEDNAME function, 125, 125
GETEXPANDEDNAME procedure, 125
GETFIRSTCHILD function, 125
GETIMPLEMENTATION function, 125
GETLASTCHILD function, 125
GETLENGTH function, 125, 125, 125
GETLOCALNAME procedure, 125
GETNAME function, 125, 125
GETNAMEDITEM function, 125
GETNAMESPACE function, 125, 125
GETNAMESPACE procedure, 125
GETNEXTSIBLING function, 125
GETNODENAME function, 125
GETNODETYPE function, 125
GETNODEVALUE function, 125
GETNOTATIONNAME function, 125
GETNOTATIONS function, 125
GETOWNERDOCUMENT function, 125
GETOWNERELEMENT function, 125
GETPARENTNODE function, 125
GETPREFIX function, 125
GETPREVIOUSSIBLING function, 125
GETPUBLICID function, 125, 125
GETQUALIFIEDNAME function, 125, 125
GETSCHEMANODE function, 125
GETSPECIFIED function, 125
GETSTANDALONE function, 125
GETSYSTEMID function, 125, 125, 125
GETTAGNAME function, 125
GETTARGET function, 125
GETVALUE function, 125
GETVERSION function, 125
GETXMLTYPE function, 125
HASATTRIBUTE function, 125
HASATTRIBUTES function, 125
HASCHILDNODES function, 125
HASFEATURE function, 125
IMPORTNODE function, 125
INSERTBEFORE function, 125
INSERTDATA procedure, 125
ISNULL function, 125
MAKEATTR function, 125
MAKECDATASECTION function, 125
MAKECHARACTERDATA function, 125
MAKECOMMENT function, 125
MAKEDOCUMENT function, 125
MAKEDOCUMENTFRAGMENT function, 125
MAKEDOCUMENTTYPE function, 125
MAKEELEMENT function, 125
MAKEENTITY function, 125
MAKEENTITYREFERENCE function, 125
MAKENODE function, 125, 125, 125, 125
MAKENOTATION function, 125
MAKEPROCESSINGINSTRUCTION function, 125
MAKETEXT function, 125
NEWDOMDOCUMENT function, 125
NORMALIZE procedure, 125
REMOVEATTRIBUTE procedure, 125
REMOVEATTRIBUTENODE function, 125
REMOVENAMEDITEM function, 125
REPLACECHILD function, 125
REPLACEDATA procedure, 125
RESOLVENAMESPACEPREFIX function, 125
SETATTRIBUTE procedure, 125
SETATTRIBUTENODE function, 125
SETCHARSET procedure, 125
SETDATA procedure, 125
SETNAMEDITEM function, 125
SETNODEVALUE procedure, 125
SETPREFIX procedure, 125
SETSTANDALONE procedure, 125
SETVALUE procedure, 125
SETVERSION procedure, 125
SPLITTEXT function, 125
SUBSTRINGDATA function, 125
WRITETOBUFFER procedure, 125
WRITETOCLOB procedure, 125
WRITETOFILE procedure, 125
NEWDOMDOCUMENT function, 125
NORMALIZE procedure, 125
REMOVEATTRIBUTE procedure, 125
REMOVEATTRIBUTENODE function, 125
REMOVENAMEDITEM function, 125
REPLACECHILD function, 125
REPLACEDATA procedure, 125
RESOLVENAMESPACEPREFIX function, 125
SETATTRIBUTE procedure, 125
SETATTRIBUTENODE function, 125
SETCHARSET procedure, 125
SETDATA procedure, 125
SETNAMEDITEM function, 125
SETNODEVALUE procedure, 125
SETPREFIX procedure, 125
SETSTANDALONE procedure, 125
SETVALUE procedure, 125
SETVERSION procedure, 125
SPLITTEXT function, 125
SUBSTRINGDATA function, 125
types, 125
WRITETOBUFFER procedure, 125
WRITETOCLOB procedure, 125
WRITETOFILE procedure, 125
DBMS_XMLGEN package, 126
CLOSECONTEXT procedure, 126
CONVERT function, 126
GETNUMROWSPROCESSED function, 126
GETXML function, 126
GETXMLTYPE function, 126
NEWCONTEXT function, 126
RESTARTQUERY procedure, 126
SETCONVERTSPECIALCHARS procedure, 126
SETMAXROWS procedure, 126
SETROWSETTAG procedure, 126
SETROWTAG procedure, 126
SETSKIPROWS procedure, 126
USEITEMTAGSFORCOLL procedure, 126
USENULLATTRIBUTEINDICATOR procedure, 126
DBMS_XMLPARSER package, 127
FREEPARSER procedure, 127
GETDOCTYPE function, 127
GETDOCUMENT function, 127
GETRELEASEVERSION function, 127
GETVALIDATIONMODE function, 127
NEWPARSER function, 127
PARSE function, 127, 127
PARSE procedure, 127
PARSEBUFFER procedure, 127
PARSECLOB procedure, 127
PARSEDTD procedure, 127
PARSEDTDBUFFER procedure, 127
PARSEDTDCLOB procedure, 127
SETBASEDIR procedure, 127
SETDOCTYPE procedure, 127
SETERRORLOG procedure, 127
SETPRESERVEWHITESPACE procedure, 127
SETVALIDATIONMODE procedure, 127
SHOWWARNINGS procedure, 127
DBMS_XMLQUERY package, 128
CLOSECONTEXT procedure, 128
constants, 128
GETDTD function, 128
GETDTD procedure, 128
GETEXCEPTIONCONTENT procedure, 128
GETNUMROWSPROCESSED procedure, 128
GETVERSION procedure, 128
GETXML function, 128
GETXML procedure, 128
NEWCONTEXT function, 128
PROPAGATEORIGINALEXCEPTION procedure, 128
REMOVEXSLTPARAM procedure, 128
SETBINDVALUE procedure, 128
SETCOLLIDATTRNAME procedure, 128
SETDATAHEADER procedure, 128
SETDATEFORMAT procedure, 128
SETENCODINGTAG procedure, 128
SETERRORTAG procedure, 128
SETMAXROWS procedure, 128
SETMETAHEADER procedure, 128
SETRAISEEXCEPTION procedure, 128
SETRAISENOROWSEXCEPTION procedure, 128
SETROWIDATTRNAME procedure, 128
SETROWIDATTRVALUE procedure, 128
SETROWSETTAG procedure, 128
SETROWTAG procedure, 128
SETSKIPROWS procedure, 128
SETSQLTOXMLNAMEESCAPING procedure, 128
SETSTYLESHEETHEADER procedure, 128
SETTAGCASE procedure, 128
SETXSLT procedure, 128
SETXSLTPARAM procedure, 128
types, 128
USENULLATTRIBUTEINDICATOR procedure, 128
USETYPEFORCOLLELEMTAG procedure, 128
DBMS_XMLSAVE package, 129
CLEARKEYCOLUMNLIST procedure, 129
CLEARUPDATECOLUMNLIST procedure, 129
CLOSECONTEXT procedure, 129
constants, 129
DELETEXML function, 129
GETEXCEPTIONCONTENT procedure, 129
INSERTXML function, 129
NEWCONTEXT function, 129
PROPAGATEORIGINALEXCEPTION procedure, 129
REMOVEXSLTPARAM procedure, 129
SETBATCHSIZE procedure, 129
SETCOMMITBATCH procedure, 129
SETDATEFORMAT procedure, 129
SETIGNORECASE procedure, 129
SETKEYCOLUMN procedure, 129
SETPRESERVEWHITESPACE procedure, 129
SETROWTAG procedure, 129
SETSQLTOXMLNAMEESCAPING procedure, 129
SETUPDATECOLUMN procedure, 129
SETXSLT procedure, 129
SETXSLTPARAM procedure, 129
UPDATEXML function, 129
DBMS_XMLSCHEMA Constants, 130
DBMS_XMLSCHEMA package, 130
COMPILESCHEMA procedure, 130
COPYEVOLVE procedure, 130
DELETESCHEMA procedure, 130
GENERATEBEAN procedure, 130
GENERATESCHEMA function, 130
GENERATESCHEMAS function, 130
REGISTERSCHEMA procedure, 130
REGISTERURI procedure, 130
DBMS_XMLSCHEMA Views, 130
DBMS_XMLSTORE package, 131
CLEARKEYCOLUMNLIST procedure, 131
CLEARUPDATECOLUMNLIST procedure, 131
CLOSECONTEXT procedure, 131
DELETEXML function, 131
INSERTXML function, 131
NEWCONTEXT function, 131
SETKEYCOLUMN procedure, 131
SETROWTAG procedure, 131
SETUPDATECOLUMN procedure, 131
types, 131
UPDATEXML function, 131
DBMS_XPLAN package, 132
DBMS_XSLPROCESSOR Package, 133, 133
DBMS_XSLPROCESSOR package
CLOB2FILE procedure, 133
FREEPROCESSOR procedure, 133
FREESTYLESHEET procedure, 133
NEWPROCESSOR function, 133
NEWSTYLESHEET function, 133
PROCESSXSL function, 133
READ2CLOB function, 133
REMOVEPARAM procedure, 133
RESETPARAMS procedure, 133
SELECTNODES function, 133
SELECTSINGLENODE function, 133
SETERRORLOG procedure, 133
SETPARAM procedure, 133
SHOWWARNINGS procedure, 133
TRANSFORMNODE function, 133
VALUEOF procedure, 133
DBMSOUTPUT_LINESARRAY Object Type, 68
DBUriType, 186
DBURITYPE function, 186
DBUriType subtype, 186
CREATEURI function, 186
DBURITYPE function, 186
GETBLOB function, 186
GETCLOB function, 186
GETCONTENTTYPE function, 186
GETEXTERNALURL function, 186
GETURL function, 186
GETXML function, 186
methods, 186
DEAUTHORIZE_DAD Procedure, 37
DEBUG_EXPTOC package, 134
DEBUG_ON procedure, 30
DECLARE_REWRITE_EQUIVALENCE Procedures, 11
DEFAULT_INDEX_PARAMETERS procedure, 39
DEFAULT_XPINDEX_PARAMETERS procedure, 39
DEFINE_ARRAY procedure, 100
DEFINE_COLUMN procedure, 100
DEFINE_COLUMN_LONG procedure, 100
DEFRAG_INDEX procedure, 39
DELETE_ALL_ERRORS procedure, 15
DELETE_BREAKPOINT function, 30
DELETE_CAPTURE_INFO Procedure, 118
DELETE_COLUMN member procedure, 189
DELETE_COLUMN procedure, 106
DELETE_COLUMN_STATS pocedure, 103
DELETE_CONSUMER_GROUP procedure, 85
DELETE_DAD_ATTRIBUTE Procedure, 37, 37
DELETE_DATABASE_STATS procedure, 103
DELETE_DICTIONARY_STATS procedure, 103
DELETE_ERROR procedure, 15
DELETE_FILTER Procedure, 118
DELETE_FIXED_OBJECTS_STATS procedure, 103
DELETE_INDEX_STATS procedure, 103
DELETE_OBJECT procedure, 177
DELETE_OER_BREAKPOINT function, 30
DELETE_PLAN procedure, 85
DELETE_PLAN_CASCADE procedure, 85
DELETE_PLAN_DIRECTIVE procedure, 85
DELETE_RULE procedure, 88
DELETE_SCHEMA_STATS Procedure, 103
DELETE_SERVICE procedure, 95
DELETE_SQLSET procedure, 101
DELETE_SQLWKLD Procedure, 12
DELETE_SQLWKLD_REF Procedure, 12
DELETE_SQLWKLD_STATEMENT Procedure, 12
DELETE_SYSTEM_STATS procedure, 103
DELETE_TABLE_STATS procedure, 103
DELETE_TASK Procedure, 12
DELETEDATA procedure, 125
DELETERESOURCE procedure, 121
DELETERESOURCEMETADATA Procedures, 121
DELETESCHEMA procedure, 130
DELETEXML function, 129, 131
DEQUEUE procedure, 108
DEQUEUE_ARRAY Function, 16
DEQUEUE_OPTIONS_T Type, 185
DEREGISTER Procedure, 23
DESCRIBE_COLUMNS procedure, 100
DESCRIBE_COLUMNS2 procedure, 100
DESCRIBE_DIMENSION procedure, 35
DESCRIBE_PROCEDURE procedure, 34
DESDecrypt procedure, 62, 62
DESEncrypt procedure, 62
DETACH_SESSION procedure, 30
DETACH_SIMPLE_TABLESPACE procedure, 109
DETACH_TABLESPACES procedure, 109
DFN function
of HTF package, 135
DFN procedure
of HTP package, 140
DIRECTORY_OBJECT_SET type, 109
DIRLISTCLOSE function
of HTF package, 135
DIRLISTCLOSE procedure
of HTP package, 140
DIRLISTOPEN function
of HTF package, 135
DIRLISTOPEN procedure
of HTP package, 140
DISABLE procedure
of DBMS_FLASHBACK package, 43
of DBMS_OUTPUT package, 68
of OWA_CACHE package, 141
DISABLE_BREAKPOINT function, 30
DISABLE_HIERARCHY procedure, 124
DISABLE_PROPAGATION_SCHEDULE Procedure, 58
DISCONNECT_SESSION procedure, 95
DISPLAY function, 132
DISPLAY_AWR function, 132
DISPLAY_CURSOR function, 132
DISPLAY_SQLSET Function, 132
DIV function
of HTF package, 135
DIV procedure
of HTP package, 140
DLISTCLOSE function
of HTF package, 135
DLISTCLOSE procedure
of HTP package, 140
DLISTDEF function
of HTF package, 135
DLISTDEF procedure
of HTP package, 140
DLISTOPEN function
of HTF package, 135
DLISTOPEN procedure
of HTP package, 140
DLISTTERM function
of HTF package, 135
DLISTTERM procedure
of HTP package, 140
DOMAttr methods, 125
DOMCDataSection methods, 125
DOMCharacterData methods, 125
DOMComment methods, 125
DOMDocument methods, 125
DOMDocumentType methods, 125, 125
DOMEntity methods, 125
DOMNamedNodeMap methods, 125
DOMText methods, 125
DOWNGRADE procedure, 114
DOWNLOAD_FILE procedures, 181
DROP_ALL function, 104
DROP_APPLY procedure, 15
DROP_ATTRIBUTE_SET procedure, 39
DROP_BASELINE procedure, 119
DROP_BY_CAT procedure, 66
DROP_CAPTURE procedure
capture process
dropping, 20
DROP_DAD Procedure, 37
DROP_EDIT_TABLES procedure, 67
DROP_EVALUATION_CONTEXT procedure, 92
DROP_EVENT_STRUCTURE procedure, 88
DROP_FILE function, 104
DROP_FILE_GROUP procedure, 41
DROP_MODEL procedure, 25
DROP_OBJECT_DEPENDENCY procedure, 15
DROP_PROPAGATION procedure, 74
DROP_REWRITE_EQUIVALENCE Procedure, 11
DROP_RULE procedure, 92
DROP_RULE_CLASS procedure, 88
DROP_RULE_SET procedure, 92
DROP_SNAPSHOT_RANGE procedure, 119
DROP_SQL_PROFILE procedure, 101
DROP_SQLSETprocedure, 101
DROP_STAT_TABLE procedure, 103
DROP_TRANSFORMATION procedure, 112
DROP_TUNING_TASK procedure, 101
DROP_UNUSED procedure, 66
DROP_VERSION procedure, 41
DROPPREFERENCES procedure, 123
DUMP_ORPHAN_KEYS procedure, 79
dynamic SQL
anonymous blocks and, 100
DBMS_SQL functions, using, 100
execution flow in, 100

E

EHLO function and procedure, 178
EM function
of HTF package, 135
EM procedure
of HTP package, 140
e-mail from PL/SQL (email), 179
EMPHASIS function
of HTF package, 135
EMPHASIS procedure
of HTP package, 140
ENABLE procedure, 68
ENABLE_AT_SYSTEM_CHANGE_NUMBER procedure, 43
ENABLE_AT_TIME procedure, 43
ENABLE_BREAKPOINT function, 30
ENABLE_HIERARCHY procedure, 124
ENABLE_PROPAGATION_SCHEDULE Procedure, 58
END_REQUEST procedure, 169
END_RESPONSE procedure, 169
ENDCREATE member procedure
of ANYDATA TYPE, 182
of ANYDATASET TYPE, 183
of ANYTYPE TYPE, 184
ENQUEUE procedure, 108
ENQUEUE_ARRAY Function, 16
ENQUEUE_OPTIONS_T Type, 185
ERASE Procedures, 52
error queue
deleting errors, 15, 15
executing errors, 15, 15
getting error messages, 15
errors
DBMS_DATA_MINING, 25
ESCAPE function, 180
ESCAPE_SC function
of HTF package, 135
ESCAPE_SC procedure
of HTP package, 140
ESCAPE_URL function
of HTF package, 135
ESCAPEURI function, 186
ESTIMATE_CPU_UNITS function, 63
ESTIMATE_MVIEW_SIZE Procedure, 61
ETINSTANCE member function
of ANYDATASET TYPE, 183
EVALUATE procedure, 91
EXACT_TEXT_SIGNATURES procedure, 66
EXEC_DDL_STATEMENT procedure, 116
EXECUTE function, 100
EXECUTE member procedure, 189, 189
EXECUTE procedure, 30
EXECUTE_ALL_ERRORS procedure, 15
EXECUTE_AND_FETCH function, 100
EXECUTE_ERROR procedure, 15
EXECUTE_IMMEDIATE Procedure, 45
EXECUTE_NON_QUERY Function, 45
EXECUTE_TASK Procedure, 12
EXECUTE_TUNING_TASK procedure, 101
execution flow
in dynamic SQL, 100
EXF$ATTRIBUTE object type, 187
EXF$ATTRIBUTE_LIST object type, 187
EXF$INDEXOPER object type, 187
EXF$TABLE_ALIAS object type, 187
EXF$XPATH_TAG object type, 187
EXF$XPATH_TAGS object type, 187
EXISTSNODE function, 198
EXISTSRESOURCE function, 121
EXPAND_MESSAGE function, 94
EXPLAIN procedure, 72
EXPONENTIAL_DIST_FIT procedure, 102
EXPORT_AWR Procedure, 118
EXPORT_COLUMN_STATS procedure, 103
EXPORT_DATABASE_STATS procedure, 103
EXPORT_DICTIONARY_STATS procedure, 103
EXPORT_FIXED_OBJECTS_STATS procedure, 103
EXPORT_INDEX_STATS procedure, 103
EXPORT_MODEL procedure, 25
EXPORT_SCHEMA_STATS procedure, 103
EXPORT_SYSTEM_STATS procedure, 103
EXPORT_TABLE_STATS procedure, 103
Expression Filter object types, 187
extend window
to create a new view, 22
EXTRACT function, 198

F

FCLOSE procedure, 168
FCLOSE_ALL procedure, 168
FCOPY procedure, 168
features, new, Preface
FETCH_ROW Function, 45
FETCH_ROWS function, 100
FFLUSH procedure, 168
FGETATTR procedure, 168
FGETPOS function, 168
FI_HORIZONTAL function, 44
FI_TRANSACTIONAL function, 44
file groups, 41
adding files, 41
altering, 41
altering files, 41
altering versions, 41
creating, 41
creating versions, 41
dropping, 41
dropping versions, 41
granting object privileges, 41
granting system privileges, 41
purging, 41
removing files, 41
revoking object privileges, 41
revoking system privileges, 41
FILE type, 109
FILE_SET type, 109
FILECLOSE Procedure, 52
FILECLOSEALL Procedure, 52
FILEEXISTS Function, 52
FILEGETNAME Procedure, 52
FILEISOPEN Function, 52
FILEOPEN Procedure, 52
FINDENTITY function, 125
FINDNOTATION function, 125
fine-grained access control
DBMS_RLS package, 89
FINISH_CAPTURE Procedure, 118
FINISH_REDEF_TABLE procedure, 77
FIX_CORRUPT_BLOCKS procedure, 79
FLUSH procedure, 179
FLUSH_DATA function and procedure, 73
FLUSH_DATABASE_MONITORING_INFO procedure, 103
FONTCLOSE function
of HTF package, 135
FONTCLOSE procedure
of HTP package, 140
FONTOPEN function
of HTF package, 135
FONTOPEN procedure
of HTP package, 140
FOPEN function, 168
FOPEN_NCHAR function, 168
FORCE parameter
and job-to-instance affinity, 48
FORMAT_CALL_STACK Function, 116
FORMAT_CELL function
of HTF package, 135
FORMAT_ERROR_BACKTRACE function, 116
FORMAT_ERROR_STACK function, 116
FORMCHECKBOX function
of HTF package, 135
FORMCHECKBOX procedure
of HTP package, 140
FORMCLOSE function
of HTF package, 135, 135
FORMCLOSE procedure
of HTP package, 140
FORMFILE function
of HTF package, 135
FORMFILE procedure
of HTP package, 140, 140
FORMHIDDEN function
of HTF package, 135
FORMHIDDEN procedure
of HTP package, 140
FORMIMAGE function
of HTF package, 135
FORMIMAGE procedure
of HTP package, 140
FORMOPEN function
of HTF package, 135
FORMOPEN procedure
of HTP package, 140
FORMPASSWORD function
of HTF package, 135
FORMPASSWORD procedure
of HTP package, 140
FORMRADIO function
of HTF package, 135
FORMRADIO procedure
of HTP package, 140
FORMRESET function
of HTF package, 135
FORMRESET procedure
of HTP package, 140
FORMSELECTCLOSE function
of HTF package, 135
FORMSELECTCLOSE procedure
of HTP package, 140
FORMSELECTOPEN function
of HTF package, 135
FORMSELECTOPEN procedure
of HTP package, 140
FORMSELECTOPTION function
of HTF package, 135
FORMSELECTOPTION procedure
of HTP package, 140
FORMSUBMIT function
of HTF package, 135
FORMSUBMIT procedure
of HTP package, 140
FORMTEXT function
of HTF package, 135
FORMTEXT procedure
of HTP package, 140
FORMTEXTAREA function
of HTF package, 135
FORMTEXTAREA procedure
of HTP package, 140
FORMTEXTAREA2 function
of HTF package, 135
FORMTEXTAREA2 procedure
of HTP package, 140
FORMTEXTAREACLOSE function
of HTF package, 135
FORMTEXTAREACLOSE procedure
of HTP package, 140
FORMTEXTAREAOPEN function
of HTF package, 135
FORMTEXTAREAOPEN procedure
of HTP package, 140
FORMTEXTAREAOPEN2 function
of HTF package, 135
FORMTEXTAREAOPEN2 procedure
of HTP package, 140
FRAME function
of HTF package, 135
FRAME procedure
of HTP package, 140
FRAMESETCLOSE function
of HTF package, 135
FRAMESETCLOSE procedure
of HTP package, 140
FRAMESETOPEN function
of HTF package, 135
FRAMESETOPEN procedure
of HTP package, 140
FREE_BLOCKS procedure, 98
FREEDOCFRAG procedure, 125
FREEDOCUMENT procedure, 125
FREENODE procedure, 125
FREEPARSER procedure, 127
FREEPROCESSOR procedure, 133
FREESTYLESHEET procedure, 133
FREETEMPORARY Procedures, 52
FREMOVE procedure, 168, 168
FRENAME procedure, 168
FSEEK procedure, 168
functions
adding to attribute sets, 39, 88

G

GATHER_DATABASE_STATS procedures, 103
GATHER_DICTIONARY_STATS procedure, 103
GATHER_FIXED_OBJECTS_STATS procedure, 103
GATHER_INDEX_STATS Procedure, 103
GATHER_SCHEMA_STATS procedures, 103
GATHER_SYSTEM_STATS procedure, 103
GATHER_TABLE_STATS procedure, 103
GENERATE_SIGNATURE procedure, 67
GENERATE_STATS procedure, 103
GENERATEBEAN procedure, 130
GENERATESCHEMA function, 130
GENERATESCHEMAS function, 130
GET function
of OWA_COOKIE package, 142
GET* member functions
of ANYDATA TYPE, 182
of ANYDATASET TYPE, 183
GET_ACLOID function, 124
GET_ALL procedure, 142
GET_ALL_DAD_ATTRIBUTES Procedure, 37
GET_ALL_DAD_MAPPINGS Procedure, 37
GET_ALL_GLOBAL_ATTRIBUTES Procedure, 37
GET_ALL_NAMES member function, 197
GET_ASSOCIATION_RULES function, 25
GET_AUTHENTICATION procedure, 169
GET_BASE_TABLE_NAME member function, 189
GET_BASE_TABLE_OWNER member function, 189
GET_BODY_CHARSET procedure, 169
GET_CAPTURE_INFO Procedure, 118
GET_CATEGORY function, 117
GET_CGI_ENV function, 149
GET_CLIENT_HOSTNAME function, 147
GET_CLIENT_IP function, 147
GET_COLUMN_STATS procedures, 103
GET_COMMAND_TYPE member function, 189
GET_COMMIT_SCN member function, 189
GET_COMMON_TIME_ZONES Function, 170
GET_COMPATIBLE member function, 189
GET_COOKIE_COUNT function, 169
GET_COOKIE_SUPPORT procedure, 169
GET_COOKIES function, 169
GET_CPU_TIME function, 116
GET_CURRENT_SCHEMA member function, 189
GET_DAD_ATTRIBUTE Procedure, 37
GET_DAD_LIST Procedure, 37
GET_DEFAULT_ISO_CURRENCY Function, 170
GET_DEFAULT_LINGUISTIC_SORT Function, 170
GET_DEFAULT_SETTINGS function, 25
GET_DEPENDENCY procedure, 116
GET_DETAILED_EXCP_SUPPORT procedure, 169
GET_DETAILED_SQLCODE function, 169
GET_DETAILED_SQLERRM function, 169
GET_ERROR_MESSAGE function, 15
GET_ETAG function, 141
GET_EXPRSET_STATS procedure, 39
GET_EXTRA_ATTRIBUTE member function, 189
GET_FILE procedure, 42
GET_FOLLOW_REDIRECT procedure, 169
GET_FREQUENT_ITEMSETS function, 25
GET_GLOBAL_ATTRIBUTE Function, 37
GET_HASH_VALUE function, 116
GET_HEADER procedure, 169
GET_HEADER_BY_NAME procedure, 169
GET_HEADER_COUNT function, 169
GET_HOST_ADDRESS function, 171
GET_HOST_NAME function, 171
GET_IN_PARAMETER_TYPES function, 166
GET_INDEX_STATS procedures, 103
GET_INDEXES function, 30
GET_INFORMATION function, 105
GET_LEVEL function, 141
GET_LINE function, 179
GET_LINE procedure, 68, 168
GET_LINE_MAP function, 30
GET_LINE_NCHAR procedure, 168
GET_LINES procedure, 68
GET_LOB_INFORMATION member function, 189
GET_LOB_OFFSET member function, 189
GET_LOB_OPERATION_SIZE member procedure, 189
GET_LOCAL_LINGUISTIC_SORTS Function, 170
GET_LOGON_USER member function, 189
GET_LONG_INFORMATION member function, 189
GET_MODEL_DETAILS_ABN function, 25
GET_MODEL_DETAILS_AI Function, 25
GET_MODEL_DETAILS_AI function, 25
GET_MODEL_DETAILS_KM function, 25
GET_MODEL_DETAILS_NB function, 25
GET_MODEL_DETAILS_NMF function, 25
GET_MODEL_DETAILS_OC function, 25
GET_MODEL_DETAILS_SVM function, 25
GET_MODEL_DETAILS_XML function, 25
GET_MODEL_SETTINGS function, 25
GET_MODEL_SIGNATURE function, 25
GET_MORE_SOURCE procedure, 30
GET_NEXT_HIT function, 91
GET_OBJECT_NAME member function, 189
GET_OBJECT_OWNER member function, 189
GET_OBJECT_TYPE member function, 189
GET_OUT_PARAMETER_TYPES function, 166
GET_OUTPUT_VALUES function, 166
GET_OWA_SERVICE_PATH function, 149
GET_PARAM function, 103
GET_PARAMETER_VALUE function, 116
GET_PASSWORD function, 147
GET_PERSISTENT_CONN_COUNT function, 169
GET_PERSISTENT_CONN_SUPPORT procedure, 169
GET_PERSISTENT_CONNS procedure, 169
GET_PORTS function, 166
GET_POST_PROCESSED_SOURCE Procedure, 71
GET_PROCEDURE function, 149
GET_PROPERTY function, 166
GET_PROXY procedure, 169
GET_RAW function, 168, 179
GET_REC_ATTRIBUTES Procedure, 12
GET_RESPONSE function, 169
GET_RESPONSE_ERROR_CHECK procedure, 169
GET_RETURN_TYPE function, 166
GET_ROWID function, 145
GET_RUNTIME_INFO function, 30
GET_SCN member function, 189
GET_SCN_MAPPING procedure, 106
GET_SERVICES function, 166
GET_SESSION_TIMEOUT function, 87
GET_SOURCE_DATABASE_NAME member function, 189
GET_SOURCE_TIME member function, 189
GET_STATS_HISTORY_AVAILABILITY function, 103
GET_STATS_HISTORY_RETENTION function, 103
GET_STREAMS_NAME function, 105
GET_STREAMS_TYPE function, 105
GET_SYSTEM_STATS procedure, 103
GET_TABLE_STATS procedure, 103
GET_TAG function, 105
GET_TAG member function, 189
GET_TASK_REPORT Procedure, 12
GET_TASK_SCRIPT Procedure, 12
GET_TEXT function, 179
GET_THRESHOLD procedure, 94
GET_TIME function, 116
GET_TIMEOUT function, 87
GET_TIMEOUT_BEHAVIOUR function, 30
GET_TRANSACTION_ID member function, 189
GET_TRANSFER_TIMEOUT procedure, 169
GET_USER_ID function, 147
GET_USERID function, 124
GET_VALUE function, 30
GET_VALUE member function, 189, 197
GET_VALUE Procedure, 45
GET_VALUE_RAW Procedure, 45
GET_VALUES member function, 189
GET_VERSION procedure, 73
GET_WARNING_SETTING_CAT function, 117
GET_WARNING_SETTING_NUM function, 117
GET_WARNING_SETTING_STRING function, 117
GET_X function, 144
GET_Y function, 144
GETACLDOCUMENT function, 121
GETATTRELEMINFO member function
of ANYTYPE TYPE, 184
GETATTRIBUTE function, 125
GETATTRIBUTENODE function, 125
GETATTRIBUTES function, 125
GETBLOB function, 186, 186, 186, 186
GETBLOBVAL function, 198
GETBUBLICID function, 125
GETCHILDNODES function, 125
GETCHILDRENBYTAGNAME function, 125
GETCHUNKSIZE Functions, 52
GETCLOB function, 186, 186, 186, 186
GETCLOBVAL function, 198
GETCONTENTSBLOBBYRESID function, 122
GETCONTENTSCLOBBYRESID function, 122, 122
GETCONTENTSXMLBYRESID function, 122
GETCONTENTTYPE function, 186, 186, 186, 186
GETCOUNT member function
of ANYDATASET TYPE, 183
GETDATA function, 125
GETDCHARSET function, 125
GETDOCTYPE function, 125, 127
GETDOCUMENT function, 127
GETDOCUMENTELEMENT function, 125
GETDTD function, 128
GETDTD procedure, 128
GETELEMENTSBYTAGNAME function, 125, 125
GETENTITIES function, 125
GETEXCEPTIONCONTENT procedure, 128, 129
GETEXPANDEDNAME function, 125, 125
GETEXPANDEDNAME procedure, 125
GETEXTERNALURL function, 186, 186, 186, 186
GETFIRSTCHILD function, 125
GETFTPPORT Function, 121
GETHTTPPORT Function, 121
GETIMPLEMENTATION function, 125
GETINFO member function
of ANYTYPE TYPE, 184
GETLASTCHILD function, 125
GETLENGTH function, 125, 125, 125
GETLENGTH Functions, 52
GETLOCKTOKEN procedure, 121
GETNAME function, 125, 125
GETNAMEDITEM function, 125
GETNAMESPACE function, 125, 125
GETNAMESPACE procedure, 125
GETNEXTSIBLING function, 125
GETNODENAME function, 125
GETNODETYPE function, 125
GETNODEVALUE function, 125
GETNOTATIONNAME function, 125
GETNOTATIONS function, 125
GETNUMBERVAL function, 198
GETNUMROWSPROCESSED function, 126
GETNUMROWSPROCESSED procedure, 128
GETOWNERDOCUMENT function, 125
GETOWNERELEMENT function, 125
GETPARENTNODE function, 125
GETPAT procedure, 146
GETPERSISTENT static function
of ANYTYPE TYPE, 184
GETPREDECESSORS function, 122
GETPREDSBYRESID function, 122
GETPREFIX function, 125
GETPREVIOUSSIBLING function, 125
GETPRIVILEGES function, 121
GETPUBLICID function, 125, 125
GETQUALIFIEDNAME function, 125, 125
GETRELEASEVERSION function, 127
GETRESOID function, 121
GETRESOURCEBYRESID function, 122
GETROOTELEMENT function, 198
GETRUL function, 186
GETSCHEMANODE function, 125
GETSCHEMAURL function, 198
GETSPECIFIED function, 125
GETSTANDALONE function, 125
GETSTRINGVAL function, 198
GETSUCCESSORS function, 122
GETSUCCSBYRESID function, 122
GETSYSTEMID function, 125, 125, 125
GETTAGNAME function, 125
GETTARGET function, 125
GETTYPE member function
of ANYDATA TYPE, 182
of ANYDATASET TYPE, 183
GETTYPENAME member function
of ANYDATA TYPE, 182
of ANYDATASET TYPE, 183
GETURL function, 186, 186, 186, 186
GETVALIDATIONMODE function, 127
GETVALUE function, 125
GETVERSION function, 125
GETVERSION procedure, 128
GETXDB_TABLESPACE function, 121
GETXML function, 126, 128, 186, 186, 186, 186
GETXML procedure, 128
GETXMLTYPE function, 125, 126
GRANT_ADMIN_PRIVILEGE procedure, 107
GRANT_OBJECT_PRIVILEGE procedure, 92
GRANT_PRIVILEGE procedure, 39, 88
GRANT_REMOTE_ADMIN_ACCESS procedure, 107
GRANT_SWITCH_CONSUMER_GROUP procedure, 86
GRANT_SYSTEM_PRIVILEGE procedure, 41, 86, 92
GRANTING_OBJECT_PRIVILEGE procedure, 41

H

HASATTRIBUTE function, 125
HASCHILDNODES function, 125
HASFEATURE function, 125
HEADCLOSE function
of HTF package, 135
HEADCLOSE procedure
of HTP package, 140
HEADER function
of HTF package, 135
HEADER procedure
of HTP package, 140
HEADOPEN function
of HTF package, 135
HEADOPEN procedure
of HTP package, 140
HELO function and procedure, 178
HELP function, 178
HR function
of HTF package, 135
HR procedure
of HTP package, 140
HTF package, 135
HTML tags
applet tags
functions, 135
procedures, 140
atags tags
procedures, 140
character formatting tags
functions, 135
procedures, 140
form tags
functions, 135
procedures, 140
frame tags
functions, 135
procedures, 140
list tags
functions, 135
procedures, 140
paragraph formatting tags
functions, 135
procedures, 140
table tags
functions, 135
HTMLCLOSE function
of HTF package, 135
HTMLCLOSE procedure
of HTP package, 140
HTMLDB_APPLICATION package documentation, 137
HTMLDB_CUSTOM_AUTH package documentation, 136
HTMLDB_ITEM package documentation, 138
HTMLDB_UTIL package documentation, 139
HTMLOPEN function
of HTF package, 135
HTMLOPEN procedure
of HTP package, 140
HTP package, 140
HTTP_HEADER_CLOSE procedure, 149
HttpUriType, 186
HTTPURITYPE function, 186
HttpUriType subtype, 186
CREATEURI function, 186
GETBLOB function, 186
GETCLOB function, 186
GETCONTENTTYPE function, 186
GETEXTERNALURL function, 186
GETRUL function, 186
GETXML function, 186
HTTPURITYPE function, 186
methods, 186

I

IMG function
of HTF package, 135
IMG procedure
of HTP package, 140
IMG2 procedure
of HTP package, 140
IMPLEMENT_TASK Procedure, 12
IMPORT_AWR Procedure, 118
IMPORT_COLUMN_STATS procedure, 103
IMPORT_DATABASE_STATS procedure, 103
IMPORT_DICTIONARY_STATS procedure, 103
IMPORT_FIXED_OBJECTS_STATS procedure, 103
IMPORT_INDEX_STATS procedure, 103
IMPORT_MODEL procedure, 25
IMPORT_SCHEMA_STATS procedure, 103
IMPORT_SQLWKLD_SCHEMA Procedure, 12
IMPORT_SQLWKLD_SQLCACHE Procedur, 12
IMPORT_SQLWKLD_STS Procedure, 12
IMPORT_SQLWKLD_SUMADV Procedure, 12
IMPORT_SQLWKLD_USER Procedure, 12
IMPORT_SYSTEM_STATS procedure, 103
IMPORT_TABLE_STATS procedure, 103
IMPORTNODE function, 125
INCLUDE_EXTRA_ATTRIBUTES procedure, 20
INDEX_PARAMETERS procedure, 39
INITIALIZE function, 30
INITIALIZE procedure, 75
INSERT_AUTOBIN_NUM_EQWIDTH procedure, 26
INSERT_BIN_CAT_FREQ procedure, 26
INSERT_BIN_NUM_EQWIDTH procedure, 26
INSERT_BIN_NUM_QTILE procedure, 26
INSERT_CLIP_TRIM_TAIL procedure, 26
INSERT_CLIP_WINSOR_TAIL procedure, 26
INSERT_MISS_CAT_MODE procedure, 26
INSERT_MISS_NUM_MEAN procedure, 26
INSERT_NORM_LIN_MINMAX procedure, 26
INSERT_NORM_LIN_SCALE Procedure, 26
INSERT_NORM_LIN_SCALE procedure, 26
INSERT_NORM_LIN_ZSCORE procedure, 26
INSERTBEFORE function, 125
INSERTDATA procedure, 125
INSERTXML function, 129, 131
INSTANCE procedure, 48
instantiation
aborting database preparation, 20
aborting schema preparation, 20
aborting table preparation, 20
global SCN, 15
preparing a database for, 20
preparing a schema for, 20
preparing a table for, 20
schema SCN, 15
table SCN, 15
INSTR Functions, 52
INTERNAL_VERSION_CHECK function, 73
internet addressing
using UTL_INADDR, 171
INTERRUPT_TASK Procedure, 12
INTERRUPT_TUNING_TASK procedure, 101
INTERVAL procedure, 48
INVALIDATE Procedure, 116
INVOKE function, 166
IS_CLUSTER_DATABASE function, 116
IS_HIERARCHY_ENABLED function, 124
IS_LOCATOR function, 164
IS_NULL_TAG member function, 189
IS_OPEN function, 100, 168
IS_TRIGGER_FIRE_ONCE function, 29
ISFRAGMENT function, 198
ISINDEX function
of HTF package, 135
ISINDEX procedure
of HTP package, 140
ISNULL function, 125
ISOPEN function, 165
ISOPEN Functions, 52
ISSCHEMABASED function, 198
ISSCHEMAVALID function, 198
ISSCHEMAVALIDATED function, 198
ISTEMPORARY Functions, 52
ITALIC function
of HTF package, 135
ITALIC procedure
of HTP package, 140
ITEM Functions, 125

K

KBD function
of HTF package, 135
KBD procedure
of HTP package, 140
KEEP procedure, 97
KEYBOARD function
of HTF package, 135
KEYBOARD procedure
of HTP package, 140

L

LAPACK Driver Routines (Linear Equations) Subprograms, 174
LAPACK Driver Routines (LLS and Eigenvalue Problems), 174
LAPACK_GBSV Procedures, 174
LAPACK_GEES Procedures, 174
LAPACK_GEEV Procedures, 174
LAPACK_GELS Procedures, 174
LAPACK_GESDD Procedures, 174
LAPACK_GESV Procedures, 174
LAPACK_GESVD Procedures, 174
LAPACK_GTSV Procedures, 174
LAPACK_PBSV Procedures, 174
LAPACK_POSV Procedures, 174
LAPACK_PPSV Procedures, 174
LAPACK_PTSV Procedures, 174
LAPACK_SBEV Procedures, 174
LAPACK_SBEVD Procedures, 174
LAPACK_SPEV Procedures, 174
LAPACK_SPEVD Procedures, 174
LAPACK_SPSV Procedures, 174
LAPACK_STEV Procedures, 174
LAPACK_STEVD Procedures, 174
LAPACK_SYEV Procedures, 174
LAPACK_SYEVD Procedures, 174
LAPACK_SYSV Procedures, 174
LAST_ERROR_POSITION function, 100
LAST_ROW_COUNT function, 100
LAST_ROW_ID function, 100
LAST_SQL_FUNCTION_CODE function, 100
LCR$_DDL_RECORD type, 189
LCR$_ROW_LIST type, 189
LCR$_ROW_RECORD type, 189
LCR$_ROW_UNIT type, 189
GET_LOB_INFORMATION member function, 189
GET_LOB_OPERATION_SIZE member procedure, 189
GET_LONG_INFORMATION member function, 189
SET_LOB_INFORMATION member procedure, 189
SET_LOB_OPERATION_SIZE member procedure, 189
LCR_TO_XML Function, 59
LENGTH function, 175
LINE function
of HTF package, 135
LINE procedure
of HTP package, 140
LINK procedure, 121
LINKREL function
of HTF package, 135
LINKREL procedure
of HTP package, 140
LINKREV function
of HTF package, 135
LINKREV procedure
of HTP package, 140
LISTHEADER function
of HTF package, 135
LISTHEADER procedure
of HTP package, 140
LISTINGCLOSE function
of HTF package, 135
LISTINGCLOSE procedure
of HTP package, 140
LISTINGOPEN function
of HTF package, 135
LISTINGOPEN procedure
of HTP package, 140
LISTITEM function
of HTF package, 135
LISTITEM procedure
of HTP package, 140
LISTPRINT procedure, 149
LOAD_SQLSET procedure, 101
LOADBLOBFROMFILE Procedure, 52
LOADCLOBFROMFILE Procedure, 52
LOADFROMFILE Procedure, 52
LOBs
DBMS_LOB package, 52
LOCAL_TRANSACTION_ID function, 111
LOCK_MAP procedure, 104
LOCK_OBJECT procedure, 177
LOCK_SCHEMA_STATS procedure, 103
LOCK_TABLE_STATS procedure, 103
LOCKRESOURCE function, 121
log apply services
managing initialization parameters for logical standby databases, 56
logical change records (LCRs)
DDL LCRs, 189
getting base table name, 189
getting base table owner, 189
getting current schema, 189
getting logon user name, 189
getting object type, 189
setting base table name, 189
setting base table owner, 189
setting current schema, 189
setting DDL text, 189
setting logon user, 189
setting object type, 189
determining if tag is NULL, 189
executing, 189, 189
extra attributes
excluding, 20
including, 20
getting command type, 189
getting commit SCN, 189
getting compatibility information, 189
getting extra attributes, 189
getting LCR creation time, 189
getting object name, 189
getting object owner, 189
getting SCN, 189
getting source database name, 189
getting tag, 189
getting transaction identifier, 189
LCR$_DDL_RECORD type, 189
LCR$_ROW_LIST type, 189
LCR$_ROW_RECORD type, 189
LCR$_ROW_UNIT type, 189
row LCRs, 189
adding value to column, 189
converting LONG to LOB, 189
deleting value to column, 189
getting column value, 189
getting list of column values, 189
getting LOB offset, 189
renaming column, 189
setting column value, 189
setting list of column values, 189
setting LOB offset, 189
setting command type, 189
setting extra attributes, 189
setting object name, 189
setting object owner, 189
setting source database name, 189
setting tag, 189
types, 189
logical standby databases
managing with DBMS_LOGSTDBY package, 56
LOGSTDBY_ADMINISTRATOR role, 56
LZ_COMPRESS functions and procedures, 165
LZ_COMPRESS_ADD procedure, 165
LZ_COMPRESS_CLOSE procedure, 165
LZ_COMPRESS_OPEN function, 165
LZ_UNCOMPRESS functions and procedures, 165
LZ_UNCOMPRESS_CLOSE procedure, 165
LZ_UNCOMPRESS_EXTRACT procedure, 165
LZ_UNCOMPRESS_OPEN function, 165

M

MAIL function and procedure, 178
MAILTO function
of HTF package, 135
MAILTO procedure
of HTP package, 140
MAINTAIN_GLOBAL procedure, 106
MAINTAIN_SCHEMAS procedure, 106
MAINTAIN_SIMPLE_TABLESPACE procedure, 106
MAINTAIN_SIMPLE_TTS procedure, 106
MAINTAIN_TABLES procedure, 106
MAINTAIN_TABLESPACES procedure, 106
MAINTAIN_TTS procedure, 106
MAKE_DATA_BLOCK_ADDRESS function, 116
MAKEATTR function, 125
MAKECDATASECTION function, 125
MAKECHARACTERDATA function, 125
MAKECOMMENT function, 125
MAKEDOCUMENT function, 125
MAKEDOCUMENTFRAGMENT function, 125
MAKEDOCUMENTTYPE function, 125
MAKEELEMENT function, 125
MAKEENTITY function, 125
MAKEENTITYREFERENCE function, 125
MAKENODE function, 125, 125, 125, 125
MAKENOTATION function, 125
MAKEPROCESSINGINSTRUCTION function, 125
MAKETEXT function, 125
MAKEVERSIONED function, 122
MAP_ALL function, 104
MAP_DAD Procedure, 37
MAP_ELEMENT function, 104
MAP_FILE function, 104
MAP_OBJECT function, 104
MAPCLOSE function
of HTF package, 135
MAPCLOSE procedure
of HTP package, 140
MAPOPEN function
of HTF package, 135
MAPOPEN procedure
of HTP package, 140
MARK_RECOMMENDATION Procedure, 12
MATCH function, 146
materialized view logs
master table
purging, 61, 61, 61
materialized views
refreshing, 61, 61, 61
MENULISTCLOSE function
of HTF package, 135
MENULISTCLOSE procedure
of HTP package, 140
MENULISTOPEN function
of HTF package, 135
MENULISTOPEN procedure
of HTP package, 140
MESSAGE_PROPERTIES_ARRAY_T Type, 185
MESSAGE_PROPERTIES_T Type, 185
messaging client
messaging client user, 106
rules
for LCRs, 106
for user messages, 106
META function
of HTF package, 135
META procedure
of HTP package, 140
methodology
transformation, 26
MG2 function
of HTF package, 135
MGW_FOREIGN_QUEUES View, 58
MGW_GATEWAY View, 58
MGW_LINKS View, 58
MGW_MQSERIES_LINKS View, 58
MGW_SCHEDULES View, 58
MGW_SUBSCRIBERS View, 58
MGW_TIBRV_LINKS View, 58
migration
post-migration actions, 62
MIME_HEADER procedure, 149
MIMEHEADER_DECODE function, 167
MIMEHEADER_ENCODE function, 167
min-max normalization, 26
missing value treatment, 26
MODIFY_OPERATOR_LIST procedure, 39
MODIFY_SERVICE Procedure, 95
MODIFY_SNAPSHOT_SETTINGS procedure, 119
MODIFY_TRANSFORMATION procedure, 112
MOVEXDB_TABLESPACE procedure, 121
MSGID_ARRAY_T Type, 185

N

NAME_RESOLVE procedure, 116
NAME_TOKENIZE procedure, 116
NAMESPACE function, 198
new features, Preface
NEW_LINE procedure, 68, 168
NEW_ROW_LIST function and procedure, 148
NEWCONTEXT function, 126, 128, 129, 131
NEWDOMDOCUMENT function, 125
NEWPARSER function, 127
NEWPROCESSOR function, 133
NEWSTYLESHEET function, 133
NEXT_DATE procedure, 48
NEXT_ITEM_TYPE function, 70
NL function
of HTF package, 135
NL procedure
of HTP package, 140
NOBR function
of HTF package, 135
NOBR procedure
of HTP package, 140
NOFRAMESCLOSE function
of HTF package, 135
NOFRAMESCLOSE procedure
of HTP package, 140
NOFRAMESOPEN function
of HTF package, 135
NOFRAMESOPEN procedure
of HTP package, 140
NOOP function and procedure, 178
NORMAL function, 75
NORMAL_DIST_FIT procedure, 102
normalization, 26
min-max, 26
z-score, 26
NORMALIZE procedure, 125
numerical binning, 26
NVARRAY_ADD Procedure, 59
NVARRAY_FIND_NAME Function, 59
NVARRAY_FIND_NAME_TYPE Function, 59
NVARRAY_GET Function, 59
NVARRAY_GET_BOOLEAN, 59
NVARRAY_GET_BYTE, 59
NVARRAY_GET_DATE Function, 59
NVARRAY_GET_DOUBLE Function, 59
NVARRAY_GET_FLOAT Function, 59
NVARRAY_GET_INTEGER, 59
NVARRAY_GET_LONG Function, 59
NVARRAY_GET_RAW Function, 59
NVARRAY_GET_SHORT, 59
NVARRAY_GET_TEXT Function, 59

O

OBJECT_DEPENDENT_SEGMENTS function, 98
OBJECT_GROWTH_TREND function, 98
OLISTCLOSE function
of HTF package, 135
OLISTCLOSE procedure
of HTP package, 140
OLISTOPEN function
of HTF package, 135
OLISTOPEN procedure
of HTP package, 140
One-Class SVM, 25, 25, 25, 25, 25, 25, 25
ONLINE_INDEX_CLEAN Function, 79
OPEN Procedures, 52
OPEN_CONNECTION function, 179
OPEN_CONNECTION functions, 178
OPEN_CURSOR Function, 45
OPEN_CURSOR function, 100
OPEN_DATA function and procedure, 178
operational notes
DBMS_LOGSTDBY package, 56
OR REPLACE clause
for creating packages, 1
Oracle Streams
administrator
granting privileges, 107
revoking privileges, 107
compatibility, 105, 105, 105, 189
creating queues, 106
data dictionary
removing information, 106
messaging
notification, 106
privileges, 107
replication
configuring, 106, 106, 106, 106, 106, 106, 106, 106
Oracle-supplied types
logical change record (LCR) types, 189
rule types, 197
OVERLAY function, 175
OWA_CACHE package, 141
OWA_COOKIE package, 142
OWA_CUSTOM package, 143
OWA_IMAGE package, 144
OWA_OPT_LOCK package, 145
OWA_PATTERN package, 146
OWA_SEC package, 147
OWA_TEXT package, 148
OWA_UTIL package, 149

P

PACK_MESSAGE procedures, 70
PACK_STGTAB_SQLPROF Procedure, 101
PACK_STGTAB_SQLSET Procedure, 101
package
DBMS_EXPFIL, 39
DBMS_ODCI, 63
DBMS_RLMGR, 88
DBMS_XDB, 121
DBMS_XMLDOM, 125
DBMS_XMLGEN, 126
DBMS_XMLPARSER, 127
DBMS_XMLQUERY, 128
DBMS_XMLSAVE, 129
DBMS_XMLSCHEMA, 130
UriFactory, 186
Package - UriFactory, 186
package overview, 1
package variables
i_am_a_refresh, 61
packages
creating, 1
referencing, 1
where documented, 1
PARA function
of HTF package, 135
PARA procedure
of HTP package, 140
PARAGRAPH function
of HTF package, 135
PARAGRAPH procedure
of HTP package, 140
PARAM function
of HTF package, 135
PARAM procedure
of HTP package, 140
PARSE Procedure, 45
PARSE procedure, 100, 127
PARSEBUFFER procedure, 127
PARSECLOB procedure, 127
PARSEDTD procedure, 127
PARSEDTDBUFFER procedure, 127
PARSEDTDCLOB procedure, 127
PAUSE_PROFILER function and procedure, 73
PIECEWISE member procedure
of ANYDATA TYPE, 182
of ANYDATASET TYPE, 183
PING procedure, 30
PLAINTEXT function
of HTF package, 135
PLAINTEXT procedure
of HTP package, 140
plan stability, 66
PL/SQL
datatypes, 34
numeric codes for, 34
functions
DBMS_MGWADM package subprograms, 58
DBMS_MGWMSG package subprograms, 59
procedures
DBMS_MGWADM package subprograms, 58
DBMS_MGWMSG package subprograms, 59
PLSQL_TRACE_VERSION procedure, 110
pointer to
CTX_ADM package, 2
point-in-time recovery
Oracle Streams, 106
POISSON_DIST_FIT procedure, 102
PORT_STRING function, 116
POST_INSTANTIATION_SETUP procedure, 106
PRE_INSTANTIATION_SETUP procedure, 106
PRECLOSE function
of HTF package, 135
PRECLOSE procedure
of HTP package, 140
PREDICT procedure, 72
PREOPEN function
of HTF package, 135
PREOPEN procedure
of HTP package, 140
PREPARE_COLUMN_VALUES procedures, 103, 103
PREPARE_COLUMN_VALUES_NVARCHAR2 procedure, 103
PREPARE_COLUMN_VALUES_ROWID procedure, 103
PREPARE_FOR_NEW_PRIMARY subprogram, 56
PREPARE_GLOBAL_INSTANTIATION procedure, 20
PREPARE_SCHEMA_INSTANTIATION procedure, 20
PREPARE_TABLE_INSTANTIATION procedure, 20
PRINT function
of HTF package, 135
PRINT procedure
of HTP package, 140
PRINT_BACKTRACE procedure, 30
PRINT_CGI_ENV procedure, 149
PRINT_INSTANTIATIONS procedure, 30
PRINT_MULTI procedure, 148
PRINT_POST_PROCESSED_SOURCE Procedure, 71
PRINT_ROW_LIST procedure, 148
PRINTS procedure
of HTP package, 140
privileges
DBMS_LOGSTDBY package, 56
granting, 39
Oracle Streams administrator, 107, 107
revoking, 39
PRN function
of HTF package, 135
PRN procedure
of HTP package, 140
PROBE_VERSION procedure, 30
PROCESS_RULES procedure, 88
PROCESSXSL function, 133
PROGRAM_INFO Record Type, 30
PROPAGATEORIGINALEXCEPTION procedure, 128, 129
propagations
altering, 74
creating, 74, 106, 106, 106, 106, 106
DBMS_PROPAGATION_ADM package, 74
dropping, 74
propagation user, 106
rules
defining global, 106
defining message, 106
defining schema, 106
defining subset, 106
defining table, 106
for LCRs, 106
for user messages, 106
starting, 74
stopping, 74
PS procedure
of HTP package, 140
PULL_SIMPLE_TABLESPACE procedure, 109
PULL_TABLESPACES procedure, 109
PURGE procedure, 70
PURGE_FILE_GROUP procedure, 41
PURGE_LOST_DB_ENTRY procedure, 111
PURGE_MIXED procedure, 111
PURGE_QUEUE_TABLE Procedure, 17
PURGE_SESSION Subprogram, 56
PURGE_SOURCE_CATALOG procedure, 106
PURGE_STATS procedure, 103
PURGELDAPCACHE function, 124
purging
the subscription window, 22
PUT procedure, 168
PUT procedures, 68
PUT_FILE procedure, 42
PUT_LINE procedure, 168
PUT_LINE procedures, 68
PUT_LINE_NCHAR procedure, 168
PUT_NCHAR procedure, 168
PUT_RAW function, 168
PUTF procedure, 168
PUTF_NCHAR procedure, 168

Q

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

R

RANDOM procedure, 75
RANK_APPLY procedure, 25
RCPT function, 178
RE$ATTRIBUTE_VALUE type, 197
RE$ATTRIBUTE_VALUE_LIST type, 197
RE$COLUMN_VALUE type, 197, 197
RE$COLUMN_VALUE_LIST type, 197
RE$NAME_ARRAY type, 197
RE$NV_ARRAY type, 197
RE$NV_LIST type, 197
ADD_PAIR member procedure, 197
GET_ALL_NAMES member function, 197
GET_VALUE member function, 197
REMOVE_PAIR member procedure, 197
RE$RULE_HIT type, 197
RE$RULE_HIT_LIST type, 197
RE$TABLE_ALIAS type, 197
RE$TABLE_ALIAS_LIST type, 197
RE$TABLE_VALUE type, 197
RE$TABLE_VALUE_LIST type, 197
RE$VARIABLE_TYPE type, 197
RE$VARIABLE_TYPE_LIST type, 197
RE$VARIABLE_VALUE type, 197
RE$VARIABLE_VALUE_LIST type, 197
READ Procedures, 52
READ_CLIENT_INFO procedure, 14
READ_LINE function, 179
READ_LINE procedure
of UTL_HTTP, 169
READ_MODULE procedure, 14
READ_ONLY procedure, 111
READ_RAW function, 179
READ_RAW procedure
of UTL_HTTP, 169
READ_TEXT function, 179
READ_TEXT procedure
of UTL_HTTP, 169
READ_WRITE procedure, 111
READ2CLOB function, 133
REBUILD_FREELISTS procedure, 79
RECEIVE_MESSAGE function, 70
RECOMP_PARALLEL procedure, 176
RECOMP_SERIAL procedure, 176
REDIRECT_URL procedure, 149
refresh
materialized views, 61, 61, 61
REFRESH_PRIVATE_OUTLINE procedure, 67
REGISTER procedure, 13
REGISTER_DEPENDENT_OBJECT procedure, 77
REGISTER_FOREIGN_QUEUE Procedure, 58
REGISTERSCHEMA procedure, 130
REGISTERURI procedure, 130
REGISTERURLHANDLER procedure, 186
RELEASE function, 53
RELEASE_ALL_SERVICES procedure, 166
RELEASE_CALL procedure, 166, 166
RELEASE_SERVICE procedure, 166
REMAP_STGTAB_SQLPROF Procedure, 101
REMAP_STGTAB_SQLSET Procedure, 101
REMOVE procedure
of DBMS_ALERT package, 13
of DBMS_JOB package, 48
of OWA_COOKIE package, 142
REMOVE_FILE procedure, 41
REMOVE_MSGSYSTEM_LINK Procedure, 58
REMOVE_PAIR member procedure, 197
REMOVE_PIPE function, 70
REMOVE_PROPERTY procedure, 166
REMOVE_QUEUE procedure, 106
REMOVE_RULE procedure, 92, 106
REMOVE_SQLSET_REFERENCE procedure, 101
REMOVE_STREAMS_CONFIGURATION procedure, 106
REMOVE_SUBSCRIBER Procedure, 58
REMOVEALL procedure, 13
REMOVEATTRIBUTE procedure, 125
REMOVEATTRIBUTENODE function, 125
REMOVENAMEDITEM function, 125
REMOVEPARAM procedure, 133
REMOVEXSLTPARAM procedure, 128, 129
RENAME_COLUMN member procedure, 189
RENAME_COLUMN procedure, 106
RENAME_MODEL procedure, 25
RENAME_SCHEMA procedure, 106
RENAME_TABLE procedure, 106
RENAMERESOURCE procedure, 121
REPLACECHILD function, 125
REPLACEDATA procedure, 125
replication
Oracle Streams
configuring, 106, 106, 106, 106, 106, 106, 106, 106
REPLY, REPLIES record types, 178
REPORT Function, 118
REPORT_TUNING_TASK function, 101
REQUEST function, 53, 169
REQUEST_PIECES function, 169
RESET_BUFFER procedure, 70
RESET_PARAM_DEFAULTS Procedure, 103
RESET_SESSION procedure, 88
RESET_SQLWKLD Procedure, 12
RESET_SUBSCRIBER Procedure, 58
RESET_TASK Procedure, 12
RESET_TUNING_TASK procedure, 101
RESETPARAMS procedure, 133
RESOLVENAMESPACEPREFIX function, 125
RESTARTQUERY procedure, 126
RESTORE function, 104
RESTORE_DATBASE_STATS procedure, 103
RESTORE_DICTIONARY_STATS procedure, 103
RESTORE_FIXED_OBJECTS_STATS procedure, 103
RESTORE_SCHEMA_STATS procedure, 103
RESTORE_SYSTEM_STATS procedure, 103
RESTORE_TABLE_STATS procedure, 103
RESUME_PROFILER function and procedure, 73
RESUME_TUNING_TASK Procedure, 101
REVERSE function, 175
REVOKE_ADMIN_PRIVILEGE procedure, 107
REVOKE_OBJECT_PRIVILEGE procedure, 41, 92
REVOKE_PRIVILEGE procedure, 39, 88
REVOKE_REMOTE_ADMIN_ACCESS procedure, 107
REVOKE_SWITCH_CONSUMER_GROUP procedure, 86
REVOKE_SYSTEM_PRIVILEGE procedure, 41, 86, 92
RLM$EVENTIDS object type, 196
ROLLBACK procedure, 111
ROLLBACK_FORCE procedure, 111
ROLLBACK_SAVEPOINT procedure, 111
row migration, 106, 106
ROWID datatype
extended format, 90
ROWID_BLOCK_NUMBER function, 90
ROWID_CREATE function, 90
ROWID_INFO procedure, 90
ROWID_OBJECT function, 90
ROWID_RELATIVE_FNO function, 90
ROWID_ROW_NUMBER function, 90
ROWID_TO_ABSOLUTE_FNO function, 90
ROWID_TO_EXTENDED function, 90
ROWID_TO_RESTRICTED function, 90
ROWID_TYPE function, 90
ROWID_VERIFY function, 90
rule sets
adding rules to, 92
creating, 92
dropping, 92
removing rules from, 92
rule-based transformations
setting, 106
rules
action contexts
adding name-value pairs, 197
getting name-value pairs, 197
getting value for name, 197
removing name-value pairs, 197
transformations, 106
altering, 92
creating, 92
DBMS_RULE package, 91
DBMS_RULE_ADM package, 92
dropping, 92
evaluation, 91
iterators, 91, 91
evaluation contexts
altering, 92
creating, 92
dropping, 92
object privileges
granting, 92
revoking, 92
propagations
removing, 106
RE$ATTRIBUTE_VALUE type, 197
RE$ATTRIBUTE_VALUE_LIST type, 197
RE$COLUMN_VALUE type, 197, 197
RE$COLUMN_VALUE_LIST type, 197
RE$NAME_ARRAY type, 197
RE$NV_ARRAY type, 197
RE$NV_LIST type, 197
RE$RULE_HIT type, 197
RE$RULE_HIT_LIST type, 197
RE$TABLE_ALIAS type, 197
RE$TABLE_ALIAS_LIST type, 197
RE$TABLE_VALUE type, 197
RE$TABLE_VALUE_LIST type, 197
RE$VARIABLE_TYPE type, 197
RE$VARIABLE_TYPE_LIST type, 197
RE$VARIABLE_VALUE type, 197
RE$VARIABLE_VALUE_LIST type, 197
subset
defining, 106, 106
system privileges
granting, 92
revoking, 92
system-created, 106
global apply, 106
global capture, 106
global propagation, 106
global schema, 106
message, 106, 106
message propagation, 106
removing, 106
schema capture, 106
schema propagation, 106
subset apply, 106
subset capture, 106
subset propagation, 106
table apply, 106
table capture, 106
table propagation, 106
types, 197
Rules Manager object types, 196
RUN procedure, 48
RUNTIME_INFO Record Type, 30

S

S function
of HTF package, 135
S procedure
of HTP package, 140
SAMPLE function
of HTF package, 135
SAMPLE procedure
of HTP package, 140
SAVE function, 104
SAVEPOINT procedure, 111
SCHEDULE_PROPAGATION Procedure, 58
SCHEMAVALIDATE procedure, 198
SCN_TO_TIMESTAMP function, 43
SCRIPT function
of HTF package, 135
SCRIPT procedure
of HTP package, 140
SCRIPT_TUNING_TASK Function, 101
SDO_CS package documentation, 150
SDO_GCDR package documentation, 151
SDO_GEOM package documentation, 152
SDO_GEOR package documentation, 153
SDO_GEOR_UTL package documentation, 154
SDO_LRS package documentation, 155
SDO_MIGRATE package documentation, 156
SDO_NET package documentation, 157
SDO_NET_MEM package documentation, 158
SDO_SAM package documentation, 159
SDO_TOPO package documentation, 160
SDO_TOPO_MAP package documentation, 161
SDO_TUNE package documentation, 162
SDO_UTIL package documentation, 163
security
DBMS_LOGSTDBY package, 56
SEED procedures, 75
SEGMENT_CORRUPT procedure, 99
SEGMENT_DROP_CORRUPT procedure, 99
SEGMENT_DUMP procedure, 99
SEGMENT_FIX_STATUS procedure, 79
SEGMENT_VERIFY procedure, 99
SELECT_CURSOR_CACHE Function, 101
SELECT_OBJECT procedure, 177
SELECT_SQLSET function, 101, 101
SELECT_WORKLOAD_REPOSITORY functions, 101
SELECTNODES function, 133
SELECTSINGLENODE function, 133
SELF_CHECK procedure, 30
SEND procedure, 142, 173
SEND_ATTACH_RAW procedure, 173
SEND_ATTACH_VARCHAR2 procedure, 173
SEND_MESSAGE function, 70
SERV_MOD_ACT_STAT_DISABLE procedure, 60
SERV_MOD_ACT_STAT_ENABLE procedure, 60
SERV_MOD_ACT_TRACE_DISABLE procedure, 60
SERV_MOD_ACT_TRACE_ENABLE procedure, 60
SESSION _TRACE_DISABLE Procedure, 96
SESSION _TRACE_ENABLE Procedur, 96
SESSION_TRACE_DISABLE procedure, 60
SESSION_TRACE_ENABLE procedure, 60
SET* member procedures
of ANYDATA TYPE, 182
of ANYDATASET TYPE, 183
SET_ACTION procedure, 14
SET_AUTHENTICATION procedure, 169
SET_AUTHORIZATION procedure, 147
SET_BASE_TABLE_NAME member procedure, 189
SET_BASE_TABLE_OWNER member procedure, 189
SET_BODY_CHARSET procedures, 169, 169
SET_BREAKPOINT function, 30
SET_CLIENT_INFO procedure, 14
SET_COLUMN_STATS procedures, 103
SET_COMMAND_TYPE member procedure, 189
SET_CONSUMER_GROUP_MAPPING procedure, 85
SET_CONSUMER_GROUP_MAPPING_PRI procedure, 85
SET_COOKIE_SUPPORT procedures, 169
SET_CURRENT_SCHEMA member procedure, 189
SET_DAD_ATTRIBUTE Procedure, 37
SET_DDL_TEXT member procedure, 189
SET_DEFAULT_SQLWKLD_PARAMETER Procedure, 12
SET_DEFAULT_TASK_PARAMETER Procedures, 12
SET_DEFAULTS procedure, 13
SET_DETAILED_EXCP_SUPPORT procedure, 169
SET_DML_HANDLER procedure, 15
SET_ENQUEUE_DESTINATION procedure, 15
SET_EXECUTE procedure, 15
SET_EXTRA_ATTRIBUTE member procedure, 189
SET_FOLLOW_REDIRECT procedures, 169
SET_GLOBAL_ATTRIBUTE Function, 37
SET_GLOBAL_INSTANTIATION procedure, 15
SET_HEADER procedure, 169
SET_INDEX_STATS procedures, 103
SET_INITIAL_CONSUMER_GROUP procedure, 85
SET_KEY_COLUMNS procedure, 15
SET_LOB_INFORMATION member procedure, 189
SET_LOB_OFFSET member procedure, 189
SET_LOB_OPERATION_SIZE member procedure, 189
SET_LOG_LEVEL Procedure, 58
SET_LOGON_USER member procedure, 189
SET_MAILHOST Procedure, 18
SET_MAILPORT Procedure, 18
SET_MESSAGE_NOTIFICATION procedure, 106
SET_MODULE procedure, 14
SET_OBJECT_NAME member procedure, 189
SET_OBJECT_OWNER member procedure, 189
SET_OBJECT_TYPE member procedure, 189
SET_OER_BREAKPOINT function, 30
SET_PARAM procedure, 103
SET_PARAMETER procedure, 20
apply process, 15
SET_PERSISTENT_CONN_SUPPORT procedure, 169
SET_PLSQL_TRACE procedure, 110
SET_PROPERTY procedure, 166
SET_PROTECTION_REALM procedure, 147
SET_PROXY procedure, 169
SET_RESPONSE_ERROR_CHECK procedure, 169
SET_RULE_TRANSFORM_FUNCTION procedure, 106
SET_SCHEMA_INSTANTIATION procedure, 15
SET_SENDFROM Procedure, 18
SET_SESSION_LONGOPS procedure, 14
SET_SESSION_TIMEOUT procedure, 87
SET_SOURCE_DATABASE_NAME member procedure, 189
SET_SQLWKLD_PARAMETER Procedure, 12
SET_SYSTEM_STATS procedure, 103
SET_TABLE_INSTANTIATION procedure, 15
SET_TABLE_STATS procedure, 103
SET_TABLESPACE Subprogram, 56
SET_TAG member procedure, 189
SET_TAG procedure, 105
SET_TASK_PARAMETER Procedure, 12
SET_THRESHOLD procedure, 94
SET_TIMEOUT function, 30
SET_TIMEOUT procedure, 87
SET_TIMEOUT_BEHAVIOUR procedure, 30
SET_TRANSFER_TIMEOUT procedure, 169
SET_TRIGGER_FIRING_PROPERTY procedure, 29
SET_UP_QUEUE procedure, 106
SET_UPDATE_CONFLICT_HANDLER procedure, 15
SET_VALUE function, 30
SET_VALUE member procedure, 189
SET_VALUE_DEPENDENCY procedure, 15
SET_VALUES member procedure, 189
SET_WALLET procedure, 169
SET_WARNING_SETTING_STRING procedure, 117
SET_WATERMARK Procedure, 17
SETACL procedure, 121
SETATTRIBUTE procedure, 125
SETATTRIBUTENODE function, 125
SETBASEDIR procedure, 127
SETBATCHSIZE procedure, 129
SETBINDVALUE procedure, 128
SETCOLLIDATTRNAME procedure, 128
SETCOMMITBATCH procedure, 129
SETCONVERTSPECIALCHARS procedure, 126
SETDATA procedure, 125
SETDATAHEADER procedure, 128
SETDATEFORMAT procedure, 128, 129
SETDCHARSET procedure, 125
SETDOCTYPE Procedure, 125
SETDOCTYPE procedure, 127
SETDVERSION procedure, 125
SETENCODINGTAG procedure, 128
SETERRORLOG procedure, 127, 133
SETERRORTAG procedure, 128
SETFTPPORT Procedure, 121
SETHTTPPORT Procedure, 121
SETIGNORECASE procedure, 129
SETINFO member procedure
of ANYTYPE TYPE, 184
SETKEYCOLUMN procedure, 129, 131
SETMAXROWS procedure, 126, 128
SETMETAHEADER procedure, 128
SETNAMEDITEM function, 125
SETNODEVALUE procedure, 125
SETPARAM procedure, 133
SETPREFIX procedure, 125
SETPRESERVEWHITESPACE procedure, 127, 129
SETRAISEEXCEPTION procedure, 128
SETRAISENOROWSEXCEPTION procedure, 128
SETROWIDATTRNAME procedure, 128
SETROWIDATTRVALUE procedure, 128
SETROWSETTAG procedure, 126, 128
SETROWTAG procedure, 128, 129, 131
SETSCHEMAVALIDATED procedure, 198
SETSKIPROWS procedure, 126, 128
SETSQLTOXMLNAMEESCAPING procedure, 128, 129
SETSTANDALONE procedure, 125
SETSTYLESHEETHEADER procedure, 128
SETTAGCASE procedure, 128
SETUPDATECOLUMN procedure, 129, 131
SETVALIDATIONMODE procedure, 127
SETVALUE procedure, 125
SETXSLT procedure, 128, 129
SETXSLTPARAM procedure, 128, 129
SHOW_BREAKPOINTS procedures, 30
SHOW_FRAME_SOURCE procedure, 30
SHOW_SOURCE procedures, 30
SHOWPAGE procedure, 149
SHOWSOURCE procedure, 149
SHOWWARNINGS procedure, 127, 133
SHUTDOWN Procedure, 58
SIGNAL procedure, 13
SIGNATURE procedure, 149
SIZES procedure, 97
SKIP_CORRUPT_BLOCKS procedure, 79
SLEEP procedure, 53
SMALL function
of HTF package, 135
SMALL procedure
of HTP package, 140
snapshot. See DBMS_MVIEW, 61
SOURCE_LINES_T Table Type, 71
SPACE_ERROR_INFO function, 87
SPACE_USAGE procedure, 98
SPLITTEXT function, 125
SQL Apply
managing logical standby databases, 56
managing with DBMS_LOGSTDBY package, 56
SQL statements
larger than 32 KB, 100
SQL*Plus
creating a sequence, 1
SQLSET_ROW Object Type, 101
SQLTEXT_TO_SIGNATURE Function, 101
staging
queues
creating, 106
removing, 106
START_APPLY procedure, 15
START_CAPTURE Procedure, 118
START_CAPTURE procedure, 20
START_PROFILER functions and procedures, 73
START_PROPAGATION procedure, 74
START_REDEF_TABLE procedure, 77
START_SERVICE procedure, 95
STARTUP Procedure, 58
STARTUP_EXTPROC_AGENT procedure, 134
STATUS_LINE procedure, 149
STEP_ID function, 111
STOP_APPLY procedure, 15
STOP_CAPTURE procedure, 20
STOP_PROFILER function and procedure, 73
STOP_PROPAGATION procedure, 74
STOP_SERVICE procedure, 95
STORE_VALUES procedure, 145
stored outlines
DBMS_OUTLN, 66
OUTLN_PKG package, 66
STREAM2MULTI procedure, 148
Streams
removing configuration, 106
STREAMS$_TRANSFORM_FUNCTION, 106
STRIKE function
of HTF package, 135
STRIKE procedure
of HTP package, 140
STRING function, 75
STRING_TO_RAW Function, 170
STRONG function
of HTF package, 135
STRONG procedure
of HTP package, 140
STYLE function
of HTF package, 135
STYLE procedure
of HTP package, 140
SUB procedure
of HTP package, 140
SUBMIT procedure, 48
SUBMIT_PENDING_AREA procedure, 85
subscribers
drop the subscription, 22
extend the window to create a new view, 22
purging the subscription window, 22
retrieve change data from the subscriber views, 22
subscription window
purging, 22
SUBSTR function, 175
SUBSTR Functions, 52
SUBSTRINGDATA function, 125
Summary of DBMS_AQELM Subprograms, 18
Summary of DBMS_DIMENSION Subprograms, 35
Summary of DBMS_ERRLOG Subprograms, 38
Summary of DBMS_MVIEW Subprograms, 61
Summary of DBMS_OLAP Subprograms, 65
Summary of DBMS_PREDICTIVE_ANALYTICS Subprograms, 72
Summary of DBMS_XDBZ Subprograms, 124
Summary of DBMS_XMLDOM Subprograms, 125
Summary of DBMS_XMLSCHEMA Subprograms, 130
Summary of UTL_LMS Subprograms, 172
SUMMARY procedure, 102
SUP function
of HTF package, 135
SUP procedure
of HTP package, 140
SWITCH_CONSUMER_GROUP_FOR_SESS procedure, 85
SWITCH_CONSUMER_GROUP_FOR_USER procedure, 85
SWITCH_PLAN procedure, 85
SYNC_INTERIM_TABLE procedure, 77
SYNCHRONIZE function, 30
SYS.MGW_MQSERIES_PROPERTIES Object Type, 58
SYS.MGW_PROPERTIES Object Type, 58
SYS.MGW_PROPERTY Object Type, 58
SYS.MGW_TIBRV_PROPERTIES Object Type, 58

T

table alias
attributes, 187
TABLE_TO_COMMA procedures, 116
TABLECAPTION function
of HTF package, 135
TABLECAPTION procedure
of HTP package, 140
TABLECLOSE function
of HTF package, 135
TABLECLOSE procedure
of HTP package, 140
TABLEDATA function
of HTF package, 135
TABLEDATA procedure
of HTP package, 140
TABLEHEADER function
of HTF package, 135
TABLEHEADER procedure
of HTP package, 140
TABLEOPEN function
of HTF package, 135
TABLEOPEN procedure
of HTP package, 140
TABLEPRINT function, 149
TABLEROWCLOSE function
of HTF package, 135
TABLEROWCLOSE procedure
of HTP package, 140
TABLEROWOPEN function
of HTF package, 135
TABLEROWOPEN procedure
of HTP package, 140
tables
table items as arrays, 100, 100
tablespace repositories
attaching tablespaces, 109
cloning tablespaces, 109
detaching tablespaces, 109
TABLESPACE_FIX_BITMAPS procedure, 99
TABLESPACE_FIX_SEGMENT_STATES procedure, 99
TABLESPACE_MIGRATE_FROM_LOCAL procedure, 99
TABLESPACE_MIGRATE_TO_LOCAL procedure, 99
TABLESPACE_REBUILD_BITMAPS procedure, 99
TABLESPACE_REBUILD_QUOTAS procedure, 99
TABLESPACE_RELOCATE_BITMAPS procedure, 99
TABLESPACE_SET type, 109
TABLESPACE_VERIFY procedure, 99
tablespaces
change tables and, 21
tags
GET_TAG function, 105
SET_TAG procedure, 105
TARGET_PROGRAM_RUNNING procedure, 30
TELETYPE function
of HTF package, 135
TELETYPE procedure
of HTP package, 140
TERMINATE procedure, 75
TEXT_DECODE function, 167
TEXT_ENCODE function, 167
TIMESTAMP_TO_SCN function, 43
TITLE function
of HTF package, 135, 135
TITLE procedure
of HTP package, 140
TODATE function, 149
TOOBJECT procedure, 198
top-N frequency binning, 26
TRACETAB.SQL, 110
transform definition table, 26
TRANSFORM function, 198
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, 133
TRANSLATE function, 175
TRANSLITERATE Function, 170
TRANSPORT_SET_CHECK procedure, 114
TRIM Procedures, 52
trimming, 26
TUNE_MVIEW Procedure, 12
types
Expression Filter, 187
Rules Manager, 196

U

ULISTCLOSE function
of HTF package, 135
ULISTCLOSE procedure
of HTP package, 140
ULISTOPEN function
of HTF package, 135
ULISTOPEN procedure
of HTP package, 140
UNASSIGN_ATTRIBUTE_SET procedure, 39
UNCHECKOUT function, 122
UNDERLINE function
of HTF package, 135
UNDERLINE procedure
of HTP package, 140
UNESCAPE function, 180
UNESCAPEURI function, 186
UNIFORM_DIST_FIT procedure, 102
UNIQUE_SESSION_NAME function, 70
UNKEEP procedure, 97
UNLOCK_MAP procedure, 104
UNLOCK_SCHEMA_STATS procedure, 103
UNLOCK_TABLE_STATS procedure, 103
UNLOCKRESOURCE function, 121
UNMAP_DAD Procedure, 37
UNPACK_MESSAGE procedures, 70
UNPACK_STGTAB_SQLPROF Procedure, 101
UNPACK_STGTAB_SQLSET Procedure, 101
UNREGISTER_DEPENDENT_OBJECT procedure, 77
UNREGISTER_FOREIGN_QUEUE Procedure, 58
UNREGISTERURLHANDLER procedure, 186
UNSCHEDULE_PROPAGATION Procedure, 58
UNUSED_SPACE procedure, 98
UPDATE_BY_CAT procedure, 66
UPDATE_CONSUMER_GROUP procedure, 85
UPDATE_OBJECT Procedure, 12
UPDATE_OBJECT procedure, 177
UPDATE_PLAN procedure, 85
UPDATE_PLAN_DIRECTIVE procedure, 85
UPDATE_REC_ATTRIBUTES Procedure, 12
UPDATE_SIGNATURES procedure, 66
UPDATE_SQLSET procedures, 101
UPDATE_SQLWKLD_ATTRIBUTES Procedure, 12
UPDATE_SQLWKLD_STATEMENT Procedure, 12
UPDATE_TASK_ATTRIBUTES Procedure, 12
UPDATERESOURCEMETADATA Procedures, 121
UPDATEXML function, 129, 131
UPGRADE_STAT_TABLE procedure, 103
upgrading
post-upgrade actions, 62
URI Types
description, 186
UriFactory package, 186
ESCAPEURI function, 186
GETURL function, 186
methods, 186
REGISTERURLHANDLER procedure, 186
UNESCAPEURI function, 186
UNREGISTERURLHANDLER procedure, 186
UriType supertype, 186
GETBLOB function, 186
GETCLOB function, 186
GETCONTENTTYPE function, 186
GETEXTERNALURL function, 186
GETURL function, 186
GETXML function, 186
methods, 186
USE_ROLLBACK_SEGMENT procedure, 111
USEITEMTAGSFORCOLL procedure, 126
USENULLATTRIBUTEINDICATOR procedure, 126, 128
user views
DBMS_DATA_MINING, 25
USER_EXPORT procedures, 48
USETYPEFORCOLLELEMTAG procedure, 128
Using DBMS_ADVISOR, 12
Using DBMS_AQIN, 19, 19
Using DBMS_FILE_GROUP, 41
Using DBMS_MVIEW, 61
Using DBMS_PREDICTIVE_ANALYTICS, 72
Using DBMS_RULE, 91
Using DBMS_RULE_ADM, 92
Using DBMS_STREAMS, 105
Using DBMS_STREAMS_ADM, 106
Using DBMS_STREAMS_TABLESPACE_ADM, 109
Using DBMS_XMLDOM, 125
Using DBMS_XMLSCHEMA, 130
Using UTL_HTTP, 169
UTL_COLL package, 164
UTL_COMPRESS package, 165
UTL_DBWS package, 166
UTL_ENCODE package, 167
UTL_FILE package, 168
UTL_HTTP package, 169
UTL_I18N package, 170
ESCAPE_REFERENCE function, 170, 170, 170, 170, 170, 170, 170
GET_DEFAULT_CHARSET function, 170
MAP_CHARSET function, 170
MAP_LANGUAGE_FROM_ISO function, 170
MAP_LOCALE_TO_ISO function, 170
MAP_TERRITORY_FROM_ISO function, 170
RAW_TO_CHAR function, 170
RAW_TO_NCHAR function, 170
UNESCAPE_REFERENCE function, 170
UTL_INADDR package, 171
UTL_LMS package, 172
FORMAT_MESSAGE function, 172
GET_MESSAGE function, 172
UTL_MAIL package, 173
UTL_NLA package, 174
UTL_RAW package, 175
UTL_RECOMP package, 176
UTL_REF package, 177
UTL_TCP package, 179
UTL_URL package, 180
UUDECODE function, 167
UUENCODE function, 167

V

v$vpd_policies, 89
VALIDATE procedure, 116
VALIDATE_DIMENSION procedure, 35
VALIDATE_EXPRESSIONS procedure, 39
VALIDATE_PENDING_AREA procedure, 85
VALIDATE_REWRITE_EQUIVALENCE Procedure, 11
VALUE functions, 75
VALUEOF procedure, 133
VARIABLE function
of HTF package, 135
VARIABLE procedure
of HTP package, 140
VARIABLE_VALUE procedures, 100
VERIFY_VALUES function, 145
views
summary, 58
virtual dependency definitions
object dependencies
creating, 15
dropping, 15
value dependencies, 15
Virtual Private Database. See VPD
VPD
column masking, 89
enabling column-level, 89
viewing current cursors and policy predicates, 89
VPD use of DBMS_RLS, 89
VRFY function, 178

W

WAITANY procedure, 13
WAITONE procedure, 13
WBR function
of HTF package, 135
WBR procedure
of HTP package, 140
WEIBULL_DIST_FIT procedure, 102
WHAT procedure, 48
WHO_CALLED_ME procedure, 149
winsorizing, 26
WPG_DOCLOAD package, 181
WRAP Functions, 29
WRITE Procedures, 52
WRITE_DATA procedure, 178
WRITE_LINE function, 179
WRITE_LINE procedure, 169
WRITE_RAW function, 179
WRITE_RAW procedure, 169
WRITE_RAW_DATA procedure, 178
WRITE_TEXT function, 179
WRITE_TEXT procedure, 169
WRITEAPPEND Procedures, 52
WRITETOBUFFER procedure, 125
WRITETOCLOB procedure, 125
WRITETOFILE procedure, 125

X

XDBUriType, 186
XDBURITYPE function, 186
XDBUriType subtype, 186
CREATEURI function, 186
GETBLOB function, 186
GETCLOB function, 186
GETCONTENTTYPE function, 186
GETEXTERNALURL function, 186
GETURL function, 186
GETXML function, 186
methods, 186
XDBURITYPE function, 186
XDBZ Constants, 124
XFORM_BIN_CAT procedure, 26
XFORM_BIN_NUM procedure, 26
XFORM_CLIP procedure, 26
XFORM_MISS_CAT procedure, 26
XFORM_MISS_NUM procedure, 26
XFORM_NORM_LIN procedure, 26
XML tags
specifying list of
configuring index parameters, 187
XML_TO_LCR Function, 59
XMLType
CREATENONSCHEMABASEDXML function, 198
CREATESCHEMABASEDXML function, 198
CREATEXML function, 198
description, 198
EXISTSNODE function, 198
EXTRACT function, 198
GETBLOBVAL function, 198
GETCLOBVAL function, 198
GETNUMBERVAL function, 198
GETROOTELEMENT function, 198
GETSCHEMAURL function, 198
GETSTRINGVAL function, 198
ISFRAGMENT function, 198
ISSCHEMABASED function, 198
ISSCHEMAVALID function, 198
ISSCHEMAVALIDATED function, 198
NAMESPACE function, 198
SCHEMAVALIDATE procedure, 198
SETSCHEMAVALIDATED procedure, 198
TOOBJECT procedure, 198
TRANSFORM function, 198
XMLTYPE function, 198
XMLTYPE function, 198
XPath parameters
adding to attribute list, 39
dropping from attribute list, 39
XPath predicates
indexing set of
configuring XML element or XML attribute, 187
XPINDEX_PARAMETERS procedure, 39
XRANGE function, 175

Z

z-score normalization, 26