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