Skip Headers

PL/SQL Packages and Types Reference
10g Release 1 (10.1)

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

Go to previous page
Previous
View PDF

Index

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


A

ABORT procedure, 78-4
ABORT_GLOBAL_INSTANTIATION procedure, 19-4
ABORT_REDEF_TABLE procedure, 68-5
ABORT_SCHEMA_INSTANTIATION procedure, 19-5
ABORT_TABLE_INSTANTIATION procedure, 19-6
ABORTED_REQUEST_THRESHOLD procedure, 87-4
ACCEPT_SQL_PROFILE procedure, 91-6
ACLCHECKPRIVILEGES function, 108-6
ACTIVE_INSTANCES procedure, 104-8
ADD_COLUMN member procedure, 174-19
ADD_COOKIES procedure, 156-36
ADD_GLOBAL_PROPAGATION_RULES procedure, 96-14
ADD_GLOBAL_RULES procedure, 96-19
ADD_PAIR member procedure, 181-7
ADD_RULE procedure, 82-4
ADD_SCHEMA_PROPAGATION_RULES procedure, 96-34
ADD_SCHEMA_RULES procedure, 96-39
ADD_SQLSET_REFERENCE function, 91-8
ADD_SUBSET_PROPAGATION_RULES procedure, 96-46
ADD_SUBSET_RULES procedure, 96-52
ADD_TABLE_PROPAGATION_RULES procedure, 96-58
ADD_TABLE_RULES procedure, 96-63
ADD_WARNING_SETTING_CAT procedure, 105-4
ADD_WARNING_SETTING_NUM procedure, 105-5
ADD2MULTI procedure, 136-4
ADDATTR member procedure
of ANYTYPE TYPE, 170-6
ADDINSTANCE member procedure
of ANYDATASET TYPE, 169-4
ADDRESS function
of HTF package, 123-17
ADDRESS procedure
of HTP package, 128-17
ADMIN_TABLES procedure, 70-6
ADVISE_COMMIT procedure, 101-5
ADVISE_NOTHING procedure, 101-6
ADVISE_ROLLBACK procedure, 101-7
ALL_XML_SCHEMAS catalog view, 118-20
ALL_XML_TAB_COLS catalog view, 118-27
ALL_XML_TABLES catalog view, 118-24
ALL_XML_VIEW_COLS catalog view, 118-33
ALL_XML_VIEWS catalog view, 118-30
ALLOCATE_UNIQUE procedure, 46-6
ALTER_APPLY procedure, 15-4
ALTER_CAPTURE procedure, 19-7
ALTER_COMPILE procedure, 26-4
ALTER_DATABASE_TAB_MONITORING procedure, 93-16
ALTER_PROPAGATION procedure, 65-3
ALTER_RULE procedure, 82-6
ALTER_SCHEMA_TAB_MONITORING procedure, 93-17
ALTER_SQL_PROFILE procedure, 91-9
ALTER_STATS_HISTORY_RETENTION procedure, 93-18
ALTER_TABLE_NOT_REFERENCEABLE procedure, 26-5
ALTER_TABLE_REFERENCEABLE procedure, 26-7
AMATCH function, 134-6
ANALYZE_DATABASE procedure, 104-6
ANALYZE_PART_OBJECT procedure, 104-9
ANALYZE_SCHEMA procedure, 104-10
ANCHOR function
of HTF package, 123-18
ANCHOR procedure
of HTP package, 128-18
ANCHOR2 function
of HTF package, 123-19
ANCHOR2 procedure
of HTP package, 128-19
anonymous PL/SQL blocks
dynamic SQL and, 90-3
AnyData datatype
queues
creating, 96-107
removing, 96-94
ANYDATA TYPE, 168-1
ANYDATASET TYPE, 169-1
ANYTYPE TYPE, 170-1
APPENDCHILD function, 113-42
APPENDDATA procedure, 113-43
APPLETCLOSE function
of HTF package, 123-20
APPLETCLOSE procedure
of HTP package, 128-20
APPLETOPEN function
of HTF package, 123-21
APPLETOPEN procedure
of HTP package, 128-21
APPLY procedure, 23-21
apply process
altering, 15-4
conflict handlers
setting, 15-54
creating, 15-14, 96-19, 96-39, 96-52, 96-63
DBMS_APPLY_ADM package, 15-1
DDL handler
setting, 15-4, 15-14
DML handlers
setting, 15-30
dropping, 15-24
enqueuing events, 15-36
error handlers
setting, 15-30
error queue
deleting errors, 15-22, 15-23
executing errors, 15-26, 15-27
getting error messages, 15-28
instantiation
global SCN, 15-40
schema SCN, 15-49
table SCN, 15-52
message handler
setting, 15-4, 15-14
parameters
commit_serialization, 15-46
disable_on_error, 15-46
disable_on_limit, 15-46
maximum_scn, 15-46
parallelism, 15-47
setting, 15-45
time_limit, 15-47
trace_level, 15-48
transaction_limit, 15-48
precommit handler
setting, 15-4, 15-14
rules
defining global, 96-19
defining schema, 96-39
defining subset, 96-52
defining table, 96-63
removing, 96-96
specifying execution, 15-38
starting, 15-58
stopping, 15-59
substitute key columns
setting, 15-43
AREA function
of HTF package, 123-23
AREA procedure
of HTP package, 128-23
arrays
BIND_ARRAY procedure, 90-9
bulk DML using DBMS_SQL, 90-28, 90-32
ATTACH_SESSION procedure, 27-19
ATTACH_SIMPLE_TABLESPACE procedure, 99-6
ATTACH_TABLESPACES procedure, 99-8
AUTHORIZE function, 131-4
AVAILABLE function, 165-8
AWR_REPORT_HTML function, 106-3
AWR_REPORT_TEXT function, 106-4

B

BASE function
of HTF package, 123-24
BASE procedure
of HTP package, 128-24
BASE64_DECODE function, 154-3
BASE64_ENCODE function, 154-4
BASEFONT function
of HTF package, 123-25
BASEFONT procedure
of HTP package, 128-25
BEGIN_DISCRETE_TRANSACTION procedure, 101-8
BEGIN_REQUEST function, 156-37
BEGINCREATE static procedure
of ANYDATA TYPE, 168-6
of ANYDATASET TYPE, 169-5
of ANYTYPE TYPE, 170-3
BGSOUND function
of HTF package, 123-26
BGSOUND procedure
of HTP package, 128-26
BIG function
of HTF package, 123-27
BIG procedure
of HTP package, 128-27
BIND_ARRAY procedures, 90-27
BIND_VARIABLE procedures, 90-30
BIND_VARIABLES function, 137-6
binning, 24-3
categorical, 24-3
numerical, 24-3
quantile, 24-3
BIT_AND function, 161-5
BIT_COMPLEMENT function, 161-6
BIT_OR function, 161-7
BIT_XOR function, 161-8
BLOCKQUOTECLOSE function
of HTF package, 123-28
BLOCKQUOTECLOSE procedure
of HTP package, 128-28
BLOCKQUOTEOPEN function
of HTF package, 123-29
BLOCKQUOTEOPEN procedure
of HTP package, 128-29
BODYCLOSE function
of HTF package, 123-30
BODYCLOSE procedure
of HTP package, 128-30
BODYOPEN function
of HTF package, 123-31
BODYOPEN procedure
of HTP package, 128-31
BOLD function
of HTF package, 123-32
BOLD procedure
of HTP package, 128-32
BR function
of HTF package, 123-33
BR procedure
of HTP package, 128-33
BROKEN procedure, 41-6
BUILD procedure, 19-14
BUILD_CHAIN_ROWS_TABLE procedure, 39-3
BUILD_EXCEPTIONS_TABLE procedure, 39-5
BUILD_PART_INDEX procedure, 62-6

C

CALENDARPRINT procedures, 137-7
CAN_REDEF_TABLE procedure, 68-6
CANCEL_TUNING_TASK procedure, 91-10
CANONICALIZE procedure, 104-12
capture process
altering, 19-7
building a Streams data dictionary, 19-14
creating, 96-19, 96-39, 96-52, 96-63
instantiation
aborting database preparation, 19-4
aborting schema preparation, 19-5
aborting table preparation, 19-6
preparing a database for, 19-27
preparing a schema for, 19-28
preparing a table for, 19-29
parameters
disable_on_limit, 19-31
maximum_scn, 19-31
message_limit, 19-31
parallelism, 19-31
setting, 19-30
startup_seconds, 19-32
time_limit, 19-32
trace_level, 19-32
write_alert_log, 19-32
rules
defining global, 96-19
defining schema, 96-39
defining subset, 96-52
defining table, 96-63
removing, 96-96
starting, 19-33
stopping, 19-34
CAST_FROM_BINARY_DOUBLE function, 161-9
CAST_FROM_BINARY_FLOAT function, 161-11
CAST_FROM_BINARY_INTEGER function, 161-13
CAST_FROM_NUMBER function, 161-14
CAST_TO_BINARY_DOUBLE function, 161-15
CAST_TO_BINARY_FLOAT function, 161-17
CAST_TO_BINARY_INTEGER function, 161-19
CAST_TO_NUMBER function, 161-20
CAST_TO_NVARCHAR2 function, 161-23
CAST_TO_RAW function, 161-21
CAST_TO_VARCHAR2 function, 161-22
categorical binning, 24-3
catproc.sql script, 1-3
CELLSPRINT procedures, 137-9
CENTER function
of HTF package, 123-34
CENTER procedure
of HTP package, 128-34
CENTERCLOSE function
of HTF package, 123-35
CENTERCLOSE procedure
of HTP package, 128-35
CENTEROPEN function
of HTF package, 123-36
CENTEROPEN procedure
of HTP package, 128-36
CFG_GET function, 108-7
CFG_REFRESH procedure, 108-8
CFG_UPDATE procedure, 108-9
Change Data Capture
DBMS_CDC_PUBLISH package, 20-1
DBMS_CDC_SUBSCRIBE package, 21-1
CHANGE functions and procedures, 134-8
CHANGE procedure, 41-7
change tables
tablespaces created in, 20-25
CHANGE_JOIN_POS procedure, 60-3
CHECK_OBJECT procedure, 70-8
CHECKIN function, 109-3
CHECKOUT procedure, 109-4
CHECKPRIVILEGES function, 108-11
CHECKSUM functions, 133-4
CHOOSE_DATE procedure, 137-12
CITE function
of HTF package, 123-37
CITE procedure
of HTP package, 128-37
CLEAR_COOKIES procedure, 156-39
CLEAR_PENDING_AREA procedure, 76-10
CLEAR_PLSQL_TRACE procedure, 100-8
CLEAR_USED procedure, 59-4
CLEARKEYCOLUMNLIST procedure, 117-4, 119-4
CLEARUPDATECOLUMNLIST procedure, 117-4, 119-5
CLIENT_ID_STAT_DISABLE procedure, 53-3
CLIENT_ID_STAT_ENABLE procedure, 53-4
CLIENT_ID_TRACE_DISABLE procedure, 53-5
CLIENT_ID_TRACE_ENABLE procedure, 53-6
clipping
see trimming, 24-4
CLOB2FILE procedure, 121-2
CLONE_SIMPLE_TABLESPACE procedure, 99-11
CLONE_TABLESPACES procedure, 99-14
CLONENODE function, 113-44
CLOSE_ALL_CONNECTIONS procedure, 165-10
CLOSE_CONNECTION procedure, 165-11
CLOSE_CURSOR procedure, 90-35
CLOSE_ITERATOR procedure, 81-4
CLOSE_PERSISTENT_CONN procedure, 156-40
CLOSE_PERSISTENT_CONNS procedure, 156-41
CLOSECONTEXT procedure, 114-4, 116-4, 117-5, 119-6
CODE function
of HTF package, 123-38
CODE procedure
of HTP package, 128-38
collections
table items, 90-28, 90-32
column masking for VPD, 79-6
COLUMN_VALUE procedure, 90-36
COLUMN_VALUE_LONG procedure, 90-39
column-level VPD, 79-15
COMMA_TO_TABLE procedures, 104-14
COMMAND function and procedure, 164-13
COMMAND_REPLIES function, 164-15
COMMENT function
of HTF package, 123-39
COMMENT procedure
of HTP package, 128-39
COMMIT procedure, 101-9
COMMIT_COMMENT procedure, 101-10
COMMIT_FORCE procedure, 101-11
COMPARE function, 161-24
COMPARE_OLD_VALUES procedure, 15-12
COMPATIBLE_10_1 function, 95-4, 174-35
COMPATIBLE_9_2 function, 95-5, 174-35
COMPILE_FROM_REMOTE procedure, 44-4
COMPILE_SCHEMA procedure, 104-15
COMPILESCHEMA procedure, 118-4
COMPUTE_CONFUSION_MATRIX procedure, 23-27
COMPUTE_LIFT procedure, 23-31
COMPUTE_ROC procedure, 23-35
CONCAT function, 161-25
CONFIGUREAUTOSYNC procedure, 111-6
CONNECTION record type, 164-3
constants
DBMS_DATA_MINING, 23-3
DBMS_MGWMSG package, 52-2
CONTINUE function, 27-20
CONVERT function, 46-8, 114-5, 161-26
CONVERT_ANYDATA_TO_LCR_DDL function, 95-6
CONVERT_ANYDATA_TO_LCR_ROW function, 95-7
CONVERT_LONG_TO_LOB_CHUNK member procedure, 174-20
CONVERT_RAW_VALUE procedures, 93-19
CONVERT_RAW_VALUE_NVARCHAR procedure, 93-20
CONVERT_RAW_VALUE_ROWID procedure, 93-21
CONVERTTOBLOB procedure, 45-24
CONVERTTOCLOB procedure, 45-28
COPIES function, 161-28
COPY_FILE procedure, 35-3
COPY_TABLE_DEPENDENTS procedure, 68-7
COPYEVOLVE procedure, 118-5
cost matrix, 23-18
CREATE PACKAGE BODY command, 1-3
CREATE PACKAGE command, 1-3
CREATE_ALTER_TYPE_ERROR_TABLE procedure, 104-16
CREATE_APPLY procedure, 15-14
CREATE_BASELINE function and procedure, 106-5
CREATE_BIN_CAT procedure, 24-10
CREATE_BIN_NUM procedure, 24-11
CREATE_CALL function, 153-4
CREATE_CAPTURE procedure
capture process
creating, 19-16
CREATE_CLIP procedure, 24-12
CREATE_CONSUMER_GROUP procedure, 76-11
CREATE_EDIT_TABLES procedure, 60-4
CREATE_EVALUATION_CONTEXT procedure, 82-9
CREATE_INDEX_COST procedure, 88-4
CREATE_MODEL procedure, 23-24
CREATE_NORM_LIN procedure, 24-13
CREATE_OUTLINE procedure, 59-5
CREATE_PENDING_AREA procedure, 76-12
CREATE_PIPE function, 63-19
CREATE_PLAN procedure, 76-14
CREATE_PLAN_DIRECTIVE procedure, 76-16
CREATE_PROPAGATION procedure, 65-6
CREATE_RULE procedure, 82-11
CREATE_RULE_SET procedure, 82-13
CREATE_SERVICE function, 153-5
CREATE_SERVICE procedure, 85-4
CREATE_SIMPLE_PLAN procedure, 76-19
CREATE_SNAPSHOT function and procedure, 106-6
CREATE_SQLSET procedure, 91-11
CREATE_STAT_TABLE procedure, 93-22
CREATE_TABLE_COST procedures, 88-5
CREATE_TRANSFORMATION procedure, 102-3
CREATE_TUNING_TASK functions, 91-12
CREATEATTRIBUTE function, 113-45
CREATECDATASECTION function, 113-46
CREATECOMMENT function, 113-47
CREATEDATASTOREPREF procedure, 111-7
CREATEDOCUMENT function, 113-48
CREATEDOCUMENTFRAGMENT function, 113-49
CREATEELEMENT function, 113-50
CREATEENTITYREFERENCE function, 113-51
CREATEFILTERPREF procedure, 111-8
CREATEFOLDER function, 108-12
CREATEINDEX procedure, 111-9
CREATELEXERPREF procedure, 111-10
CREATENONSCHEMABASEDXML function, 182-4
CREATEOIDPATH function, 108-13
CREATEPREFERENCES procedure, 111-11
CREATEPROCESSINGINSTRUCTION function, 113-52
CREATERESOURCE function, 108-14
CREATESCHEMABASEDXML function, 182-5
CREATESECTIONGROUPPREF procedure, 111-12
CREATESTOPLISTPREF procedure, 111-13
CREATESTORAGEPREF procedure, 111-14
CREATETEXTNODE function, 113-53
CREATEURI function, 172-10, 172-19, 172-28
CREATEWORLDLISTPREF procedure, 111-15
CREATEXML function, 182-6
creating
packages, 1-3
CTX_ADM package documentation, 2-2
CTX_CLS package documentation, 3-2
CTX_DDL package documentation, 4-2
CTX_DOC package documentation, 5-2
CTX_OUTPUT package documentation, 6-2
CTX_QUERY package documentation, 7-2
CTX_REPORT package documentation, 8-2
CTX_THES package documentation, 9-2
CTX_ULEXER package documentation, 10-2
CURRENT_INSTANCE function, 104-17
cursors
DBMS_SQL package, 90-7

D

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

E

EHLO function and procedure, 164-18
EM function
of HTF package, 123-48
EM procedure
of HTP package, 128-48
e-mail from PL/SQL (email), 165-5
EMPHASIS function
of HTF package, 123-49
EMPHASIS procedure
of HTP package, 128-49
ENABLE procedure, 61-9
ENABLE_AT_SYSTEM_CHANGE_NUMBER procedure, 36-10
ENABLE_AT_TIME procedure, 36-11
ENABLE_BREAKPOINT function, 27-27
ENABLE_HIERARCHY procedure, 112-4
END_REQUEST procedure, 156-43
END_RESPONSE procedure, 156-44
ENDCREATE member procedure
of ANYDATA TYPE, 168-7
of ANYDATASET TYPE, 169-6
of ANYTYPE TYPE, 170-8
ENQUEUE procedure, 98-6
error queue
deleting errors, 15-22, 15-23
executing errors, 15-26, 15-27
getting error messages, 15-28
errors
DBMS_DATA_MINING, 23-9
ESCAPE function, 166-5
ESCAPE_SC function
of HTF package, 123-50
ESCAPE_SC procedure
of HTP package, 128-50
ESCAPE_URL function
of HTF package, 123-51
ESCAPEURI function, 172-38
ESTIMATE_CPU_UNITS function, 56-3
ETINSTANCE member function
of ANYDATASET TYPE, 169-12
EVALUATE procedure, 81-5
EXACT_TEXT_SIGNATURES procedure, 59-8
EXEC_DDL_STATEMENT procedure, 104-21
EXECUTE function, 90-48
EXECUTE member procedure, 174-8, 174-21
EXECUTE procedure, 27-28
EXECUTE_ALL_ERRORS procedure, 15-26
EXECUTE_AND_FETCH function, 90-49
EXECUTE_ERROR procedure, 15-27
EXECUTE_TUNING_TASK procedure, 91-19
execution flow
in dynamic SQL, 90-7
EXISTSNODE function, 182-9
EXISTSRESOURCE function, 108-18
EXPAND_MESSAGE function, 84-12
EXPONENTIAL_DIST_FIT procedure, 92-3
EXPORT_COLUMN_STATS procedure, 93-36
EXPORT_DATABASE_STATS procedure, 93-37
EXPORT_DICTIONARY_STATS procedure, 93-38
EXPORT_FIXED_OBJECTS_STATS procedure, 93-39
EXPORT_INDEX_STATS procedure, 93-40
EXPORT_MODEL procedure, 23-41
EXPORT_SCHEMA_STATS procedure, 93-41
EXPORT_SYSTEM_STATS procedure, 93-42
EXPORT_TABLE_STATS procedure, 93-43
extend window
to create a new view, 21-2
EXTRACT function, 182-10

F

FCLOSE procedure, 155-10
FCLOSE_ALL procedure, 155-11
FCOPY procedure, 155-12
features, new, 1-xxxiii
FETCH_ROWS function, 90-50
FFLUSH procedure, 155-13
fga_log$, 34-5
FGETATTR procedure, 155-14
FGETPOS function, 155-15
FI_HORIZONTAL function, 37-8
FI_TRANSACTIONAL function, 37-3
FILE type, 99-3
FILE_SET type, 99-4
FINDENTITY function, 113-55
FINDNOTATION function, 113-56
fine-grained access control
DBMS_RLS package, 79-1
FINISH_REDEF_TABLE procedure, 68-9
FIX_CORRUPT_BLOCKS procedure, 70-12
FLUSH procedure, 165-12
FLUSH_DATA function and procedure, 64-9
FLUSH_DATABASE_MONITORING_INFO procedure, 93-44
FONTCLOSE function
of HTF package, 123-52
FONTCLOSE procedure
of HTP package, 128-51
FONTOPEN function
of HTF package, 123-53
FONTOPEN procedure
of HTP package, 128-52
FOPEN function, 155-16
FOPEN_NCHAR function, 155-18
FORCE parameter
and job-to-instance affinity, 41-3
FORMAT_CELL function
of HTF package, 123-54
FORMAT_ERROR_BACKTRACE function, 104-22
FORMAT_ERROR_STACK function, 104-26
FORMCHECKBOX function
of HTF package, 123-55
FORMCHECKBOX procedure
of HTP package, 128-53
FORMCLOSE function
of HTF package, 123-56
FORMCLOSE procedure
of HTP package, 128-54
FORMFILE function
of HTF package, 123-57
FORMFILE procedure
of HTP package, 128-56
FORMHIDDEN function
of HTF package, 123-58
FORMHIDDEN procedure
of HTP package, 128-57
FORMIMAGE function
of HTF package, 123-59
FORMIMAGE procedure
of HTP package, 128-58