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
- FORMOPEN function
- of HTF package, 123-60
- FORMOPEN procedure
- of HTP package, 128-55
- FORMPASSWORD function
- of HTF package, 123-61
- FORMPASSWORD procedure
- of HTP package, 128-59
- FORMRADIO function
- of HTF package, 123-62
- FORMRADIO procedure
- of HTP package, 128-60
- FORMRESET function
- of HTF package, 123-63
- FORMRESET procedure
- of HTP package, 128-61
- FORMSELECTCLOSE function
- of HTF package, 123-64
- FORMSELECTCLOSE procedure
- of HTP package, 128-62
- FORMSELECTOPEN function
- of HTF package, 123-65
- FORMSELECTOPEN procedure
- of HTP package, 128-63
- FORMSELECTOPTION function
- of HTF package, 123-67
- FORMSELECTOPTION procedure
- of HTP package, 128-65
- FORMSUBMIT function
- of HTF package, 123-68
- FORMSUBMIT procedure
- of HTP package, 128-66
- FORMTEXT function
- of HTF package, 123-69
- FORMTEXT procedure
- of HTP package, 128-67
- FORMTEXTAREA function
- of HTF package, 123-70
- FORMTEXTAREA procedure
- of HTP package, 128-68
- FORMTEXTAREA2 function
- of HTF package, 123-71
- FORMTEXTAREA2 procedure
- of HTP package, 128-69
- FORMTEXTAREACLOSE function
- of HTF package, 123-72
- FORMTEXTAREACLOSE procedure
- of HTP package, 128-70
- FORMTEXTAREAOPEN function
- of HTF package, 123-73
- FORMTEXTAREAOPEN procedure
- of HTP package, 128-71
- FORMTEXTAREAOPEN2 function
- of HTF package, 123-74
- FORMTEXTAREAOPEN2 procedure
- of HTP package, 128-72
- FRAME function
- of HTF package, 123-75
- FRAME procedure
- of HTP package, 128-73
- FRAMESETCLOSE function
- of HTF package, 123-76
- FRAMESETCLOSE procedure
- of HTP package, 128-74
- FRAMESETOPEN function
- of HTF package, 123-77
- FRAMESETOPEN procedure
- of HTP package, 128-75
- FREE_BLOCKS procedure, 88-7
- FREEDOCFRAG procedure, 113-57, 113-58
- FREEDOCUMENT procedure, 113-59
- FREENODE procedure, 113-60
- FREEPARSER procedure, 115-2
- FREEPROCESSOR procedure, 121-3
- FREESTYLESHEET procedure, 121-3
- FREMOVE procedure, 155-19
- FRENAME procedure, 155-20
- FSEEK procedure, 155-21
G
- GATHER_DATABASE_STATS procedures, 93-45
- GATHER_DICTIONARY_STATS procedure, 93-50
- GATHER_FIXED_OBJECTS_STATS procedure, 93-55
- GATHER_SCHEMA_STATS procedures, 93-59
- GATHER_SYSTEM_STATS procedure, 93-64
- GATHER_TABLE_STATS procedure, 93-67
- GENERATE_SIGNATURE procedure, 60-6
- GENERATE_STATS procedure, 93-71
- GENERATEBEAN procedure, 118-10
- GENERATESCHEMA function, 118-11
- GENERATESCHEMAS function, 118-12
- GET function
- of OWA_COOKIE package, 130-4
- GET* member functions
- of ANYDATA TYPE, 168-8
- of ANYDATASET TYPE, 169-7
- GET_ACLOID function, 112-5
- GET_ALL procedure, 130-5
- GET_ALL_NAMES member function, 181-8
- GET_ASSOCIATION_RULES function, 23-45
- GET_AUTHENTICATION procedure, 156-45
- GET_BASE_TABLE_NAME member function, 174-8
- GET_BASE_TABLE_OWNER member function, 174-9
- GET_BODY_CHARSET procedure, 156-47
- GET_CATEGORY function, 105-6
- GET_CGI_ENV function, 137-14
- GET_CLIENT_HOSTNAME function, 135-4
- GET_CLIENT_IP function, 135-5
- GET_COLUMN_STATS procedures, 93-72
- GET_COMMAND_TYPE member function, 174-34
- GET_COMMIT_SCN member function, 174-35
- GET_COMPATIBLE member function, 174-35
- GET_COOKIE_COUNT function, 156-48
- GET_COOKIE_SUPPORT procedure, 156-49
- GET_COOKIES function, 156-50
- GET_CPU_TIME function, 104-28
- GET_CURRENT_SCHEMA member function, 174-9
- GET_DEFAULT_SETTINGS function, 23-48
- GET_DEPENDENCY procedure, 104-29
- GET_DETAILED_EXCP_SUPPORT procedure, 156-51
- GET_DETAILED_SQLCODE function, 156-52
- GET_DETAILED_SQLERRM function, 156-53
- GET_ERROR_MESSAGE function, 15-28
- GET_ETAG function, 129-5
- GET_EXTRA_ATTRIBUTE member function, 174-36
- GET_FILE procedure, 35-5
- GET_FOLLOW_REDIRECT procedure, 156-54
- GET_FREQUENT_ITEMSETS function, 23-50
- GET_HASH_VALUE function, 104-30
- GET_HEADER procedure, 156-55
- GET_HEADER_BY_NAME procedure, 156-56
- GET_HEADER_COUNT function, 156-57
- GET_HOST_ADDRESS function, 158-4
- GET_HOST_NAME function, 158-5
- GET_IN_PARAMETER_TYPES function, 153-6
- GET_INDEX_STATS procedures, 93-74
- GET_INDEXES function, 27-31
- GET_INFORMATION function, 95-8
- GET_LEVEL function, 129-6
- GET_LINE function, 165-13
- GET_LINE procedure, 61-10, 155-22
- GET_LINE_MAP function, 27-33
- GET_LINE_NCHAR procedure, 155-24
- GET_LINES procedure, 61-11
- GET_LOB_INFORMATION member function, 174-22
- GET_LOB_OFFSET member function, 174-23
- GET_LOB_OPERATION_SIZE member procedure, 174-23
- GET_LOGON_USER member function, 174-10
- GET_LONG_INFORMATION member function, 174-25
- GET_MODEL_DETAILS_ABN function, 23-52
- GET_MODEL_DETAILS_KM function, 23-54
- GET_MODEL_DETAILS_NB function, 23-58
- GET_MODEL_DETAILS_NMF function, 23-60
- GET_MODEL_DETAILS_SVM function, 23-62
- GET_MODEL_SETTINGS function, 23-64
- GET_MODEL_SIGNATURE function, 23-66
- GET_MORE_SOURCE procedure, 27-32
- GET_NEXT_HIT function, 81-10
- GET_OBJECT_NAME member function, 174-38
- GET_OBJECT_OWNER member function, 174-38
- GET_OBJECT_TYPE member function, 174-10
- GET_OUT_PARAMETER_TYPES function, 153-7
- GET_OUTPUT_VALUES function, 153-8
- GET_OWA_SERVICE_PATH function, 137-15
- GET_PARAM function, 93-78
- GET_PARAMETER_VALUE function, 104-31
- GET_PASSWORD function, 135-6
- GET_PERSISTENT_CONN_COUNT function, 156-58
- GET_PERSISTENT_CONN_SUPPORT procedure, 156-59
- GET_PERSISTENT_CONNS procedure, 156-60
- GET_PORTS function, 153-9
- GET_PROCEDURE function, 137-16
- GET_PROPERTY function, 153-10
- GET_PROXY procedure, 156-61
- GET_RAW function, 155-25, 165-14
- GET_RESPONSE function, 156-62
- GET_RESPONSE_ERROR_CHECK procedure, 156-63
- GET_RETURN_TYPE function, 153-11
- GET_ROWID function, 133-5
- GET_RUNTIME_INFO function, 27-34
- GET_SCN member function, 174-38
- GET_SCN_MAPPING procedure, 96-70
- GET_SERVICES function, 153-12
- GET_SESSION_TIMEOUT function, 78-5
- GET_SOURCE_DATABASE_NAME member function, 174-38
- GET_STATS_HISTORY_AVAILABILITY function, 93-79
- GET_STATS_HISTORY_RETENTION function, 93-80
- GET_STREAMS_NAME function, 95-9
- GET_STREAMS_TYPE function, 95-10
- GET_SYSTEM_STATS procedure, 93-81
- GET_TABLE_STATS procedure, 93-84
- GET_TAG function, 95-11
- GET_TAG member function, 174-38
- GET_TEXT function, 165-16
- GET_THRESHOLD procedure, 84-13
- GET_TIME function, 104-33
- GET_TIMEOUT function, 78-6
- GET_TIMEOUT_BEHAVIOUR function, 27-35
- GET_TRANSACTION_ID member function, 174-39
- GET_TRANSFER_TIMEOUT procedure, 156-64
- GET_USER_ID function, 135-7
- GET_USERID function, 112-6
- GET_VALUE function, 27-36
- GET_VALUE member function, 174-25, 181-8
- GET_VALUES member function, 174-26
- GET_VERSION procedure, 64-10
- GET_WARNING_SETTING_CAT function, 105-7
- GET_WARNING_SETTING_NUM function, 105-8
- GET_WARNING_SETTING_STRING function, 105-9
- GET_X function, 132-4
- GET_Y function, 132-5
- GETACLDOCUMENT function, 108-19
- GETATTRELEMINFO member function
- of ANYTYPE TYPE, 170-12
- GETATTRIBUTE function, 113-61
- GETATTRIBUTENODE function, 113-63
- GETATTRIBUTES function, 113-62
- GETBLOB function, 172-3, 172-11, 172-21, 172-29
- GETBLOBVAL function, 182-11
- GETBUBLICID function, 113-93
- GETCHILDNODES function, 113-64
- GETCHILDRENBYTAGNAME function, 113-65
- GETCLOB function, 172-4, 172-12, 172-22, 172-30
- GETCLOBVAL function, 182-12
- GETCONTENTSBLOBBYRESID function, 109-5
- GETCONTENTSCLOBBYRESID function, 109-6
- GETCONTENTSXMLBYRESID function, 109-7
- GETCONTENTTYPE function, 172-5, 172-13, 172-23, 172-31
- GETCOUNT member function
- of ANYDATASET TYPE, 169-11
- GETDATA function, 113-66
- GETDCHARSET function, 113-67
- GETDOCTYPE function, 113-67, 115-3
- GETDOCUMENT function, 115-3
- GETDOCUMENTELEMENT function, 113-68
- GETDTD function, 116-5
- GETDTD procedure, 116-5
- GETELEMENTSBYTAGNAME function, 113-69, 113-70
- GETENTITIES function, 113-70
- GETEXCEPTIONCONTENT procedure, 116-5, 117-6
- GETEXPANDEDNAME function, 113-72
- GETEXPANDEDNAME procedure, 113-71
- GETEXTERNALURL function, 172-6, 172-14, 172-24, 172-32
- GETFIRSTCHILD function, 113-72
- GETIMPLEMENTATION function, 113-73
- GETINFO member function
- of ANYTYPE TYPE, 170-10
- GETLASTCHILD function, 113-74
- GETLENGTH function, 113-75, 113-76
- GETLOCKTOKEN procedure, 108-20
- 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
- GETNUMBERVAL function, 182-14
- GETNUMROWSPROCESSED function, 114-6
- GETNUMROWSPROCESSED procedure, 116-6
- GETOWNERDOCUMENT function, 113-87
- GETOWNERELEMENT function, 113-88
- GETPARENTNODE function, 113-89
- GETPAT procedure, 134-10
- GETPERSISTENT static function
- of ANYTYPE TYPE, 170-9
- GETPREDECESSORS function, 109-8
- GETPREDSBYRESID function, 109-9
- GETPREFIX function, 113-90
- GETPREVIOUSSIBLING function, 113-91
- GETPRIVILEGES function, 108-21
- GETPUBLICID function, 113-92, 113-93
- GETQUALIFIEDNAME function, 113-93, 113-94
- GETRELEASEVERSION function, 115-4
- GETRESOID function, 108-22
- GETRESOURCEBYRESID function, 109-10
- GETROOTELEMENT function, 182-15
- GETRUL function, 172-15
- GETSCHEMANODE function, 113-94
- GETSCHEMAURL function, 182-16
- GETSPECIFIED function, 113-95
- GETSTANDALONE function, 113-96
- GETSTRINGVAL function, 182-17
- GETSUCCESSORS function, 109-11
- GETSUCCSBYRESID function, 109-12
- GETSYSTEMID function, 113-97, 113-98
- GETTAGNAME function, 113-98
- GETTARGET function, 113-86
- GETTYPE member function
- of ANYDATA TYPE, 168-12
- of ANYDATASET TYPE, 169-13
- GETTYPENAME member function
- of ANYDATA TYPE, 168-13
- of ANYDATASET TYPE, 169-14
- GETURL function, 172-7, 172-25, 172-33, 172-37
- GETVALIDATIONMODE function, 115-4
- GETVALUE function, 113-99
- GETVERSION function, 113-100
- GETVERSION procedure, 116-6
- GETXDB_TABLESPACE function, 108-23
- GETXML function, 114-7, 116-7, 172-8, 172-16, 172-26, 172-34
- GETXML procedure, 116-7
- GETXMLTYPE function, 113-101, 114-9
- GRANT_ADMIN_PRIVILEGE procedure, 97-3
- GRANT_OBJECT_PRIVILEGE procedure, 82-18
- GRANT_REMOTE_ADMIN_ACCESS procedure, 97-6
- GRANT_SWITCH_CONSUMER_GROUP procedure, 77-3
- GRANT_SYSTEM_PRIVILEGE procedure, 77-5, 82-20
H
- HASATTRIBUTE function, 113-102
- HASCHILDNODES function, 113-104
- HASFEATURE function, 113-105
- HEADCLOSE function
- of HTF package, 123-78
- HEADCLOSE procedure
- of HTP package, 128-76
- HEADER function
- of HTF package, 123-80
- HEADER procedure
- of HTP package, 128-78
- HEADOPEN function
- of HTF package, 123-79
- HEADOPEN procedure
- of HTP package, 128-77
- HELO function and procedure, 164-20
- HELP function, 164-22
- HR function
- of HTF package, 123-81
- HR procedure
- of HTP package, 128-79
- HTF package, 123-1
- HTML tags
- applet tags
- functions, 123-4
- procedures, 128-4
- atags tags
- procedures, 128-5
- character formatting tags
- functions, 123-7
- procedures, 128-7
- form tags
- functions, 123-5
- procedures, 128-5
- frame tags
- functions, 123-7
- procedures, 128-7
- list tags
- functions, 123-4
- procedures, 128-4
- paragraph formatting tags
- functions, 123-6
- procedures, 128-6
- table tags
- functions, 123-5
- HTMLCLOSE function
- of HTF package, 123-82
- HTMLCLOSE procedure
- of HTP package, 128-80
- HTMLDB_APPLICATION package documentation, 125-2
- HTMLDB_CUSTOM_AUTH package documentation, 124-2
- HTMLDB_ITEM package documentation, 126-2
- HTMLDB_UTIL package documentation, 127-2
- HTMLOPEN function
- of HTF package, 123-83
- HTMLOPEN procedure
- of HTP package, 128-81
- HTP package, 128-1
- HTTP_HEADER_CLOSE procedure, 137-17
- HttpUriType, 172-9
- HTTPURITYPE function, 172-17
- HttpUriType subtype, 172-9
- CREATEURI function, 172-10
- GETBLOB function, 172-11
- GETCLOB function, 172-12
- GETCONTENTTYPE function, 172-13
- GETEXTERNALURL function, 172-14
- GETRUL function, 172-15
- GETXML function, 172-16
- HTTPURITYPE function, 172-17
- methods, 172-9
I
- IMG function
- of HTF package, 123-84
- IMG procedure
- of HTP package, 128-82
- IMG2 procedure
- of HTP package, 128-83
- IMPORT_COLUMN_STATS procedure, 93-86
- IMPORT_DATABASE_STATS procedure, 93-88
- IMPORT_DICTIONARY_STATS procedure, 93-90
- IMPORT_FIXED_OBJECTS_STATS procedure, 93-92
- IMPORT_INDEX_STATS procedure, 93-94
- IMPORT_MODEL procedure, 23-68
- IMPORT_SCHEMA_STATS procedure, 93-96
- IMPORT_SYSTEM_STATS procedure, 93-98
- IMPORT_TABLE_STATS procedure, 93-99
- IMPORTNODE function, 113-41, 113-106
- INCLUDE_EXTRA_ATTRIBUTES procedure, 19-25
- INITIALIZE function, 27-39
- INITIALIZE procedure, 66-4
- INSERT_BIN_CAT_FREQ procedure, 24-14
- INSERT_BIN_NUM_EQWIDTH procedure, 24-16
- INSERT_BIN_NUM_QTILE procedure, 24-18
- INSERT_CLIP_TRIM_TAIL procedure, 24-20
- INSERT_CLIP_WINSOR_TAIL procedure, 24-22
- INSERT_NORM_LIN_MINMAX procedure, 24-26
- INSERT_NORM_LIN_ZSCORE procedure, 24-24
- INSERTBEFORE function, 113-107
- INSERTDATA procedure, 113-108
- INSERTXML function, 117-6, 119-8
- INSTANCE procedure, 41-9
- instantiation
- aborting database preparation, 19-4
- aborting schema preparation, 19-5
- aborting table preparation, 19-6
- global SCN, 15-40
- preparing a database for, 19-27
- preparing a schema for, 19-28
- preparing a table for, 19-29
- schema SCN, 15-49
- table SCN, 15-52
- INTERNAL_VERSION_CHECK function, 64-11
- internet addressing
- using UTL_INADDR, 158-1
- INTERRUPT_TUNING_TASK procedure, 91-20
- INTERVAL procedure, 41-10
- INVOKE function, 153-13
- IS_CLUSTER_DATABASE function, 104-34
- IS_HIERARCHY_ENABLED function, 112-7
- IS_LOCATOR function, 151-3
- IS_NULL_TAG member function, 174-39
- IS_OPEN function, 90-51, 155-26
- IS_TRIGGER_FIRE_ONCE function, 26-8
- ISFRAGMENT function, 182-18
- ISINDEX function
- of HTF package, 123-86
- ISINDEX procedure
- of HTP package, 128-84
- ISNULL function, 113-109, 113-113
- ISOPEN function, 152-5
- ISSCHEMABASED function, 182-19
- ISSCHEMAVALID function, 182-20
- ISSCHEMAVALIDATED function, 182-21
- ITALIC function
- of HTF package, 123-87
- ITALIC procedure
- of HTP package, 128-85
- ITEM function, 113-113
K
- KBD function
- of HTF package, 123-88
- KBD procedure
- of HTP package, 128-86
- KEEP procedure, 87-5
- KEYBOARD function
- of HTF package, 123-89
- KEYBOARD procedure
- of HTP package, 128-87
L
- LAST_ERROR_POSITION function, 90-52
- LAST_ROW_COUNT function, 90-53
- LAST_ROW_ID function, 90-54
- LAST_SQL_FUNCTION_CODE function, 90-55
- LCR$_DDL_RECORD type, 174-3
- LCR$_ROW_LIST type, 174-44
- LCR$_ROW_RECORD type, 174-14
- LCR$_ROW_UNIT type, 174-45
- GET_LOB_INFORMATION member function, 174-22
- GET_LOB_OPERATION_SIZE member procedure, 174-23
- GET_LONG_INFORMATION member function, 174-25
- SET_LOB_INFORMATION member procedure, 174-28
- SET_LOB_OPERATION_SIZE member procedure, 174-30
- LENGTH function, 161-29
- LINE function
- of HTF package, 123-90
- LINE procedure
- of HTP package, 128-88
- LINK procedure, 108-24
- LINKREL function
- of HTF package, 123-91
- LINKREL procedure
- of HTP package, 128-89
- LINKREV function
- of HTF package, 123-92
- LINKREV procedure
- of HTP package, 128-90
- LISTHEADER function
- of HTF package, 123-93
- LISTHEADER procedure
- of HTP package, 128-91
- LISTINGCLOSE function
- of HTF package, 123-94
- LISTINGCLOSE procedure
- of HTP package, 128-92
- LISTINGOPEN function
- of HTF package, 123-95
- LISTINGOPEN procedure
- of HTP package, 128-93
- LISTITEM function
- of HTF package, 123-96
- LISTITEM procedure
- of HTP package, 128-94
- LISTPRINT procedure, 137-18
- LOAD_SQLSET procedure, 91-21
- LOBs
- DBMS_LOB package, 45-1
- LOCAL_TRANSACTION_ID function, 101-12
- LOCK_MAP procedure, 94-8
- LOCK_OBJECT procedure, 163-9
- LOCK_SCHEMA_STATS procedure, 93-101
- LOCK_TABLE_STATS procedure, 93-102
- LOCKRESOURCE function, 108-25
- log apply services
- managing initialization parameters for logical standby databases, 49-2
- logical change records (LCRs)
- DDL LCRs, 174-3
- getting base table name, 174-8
- getting base table owner, 174-9
- getting current schema, 174-9
- getting logon user name, 174-10
- getting object type, 174-10
- setting base table name, 174-10
- setting base table owner, 174-11
- setting current schema, 174-11
- setting DDL text, 174-12
- setting logon user, 174-12
- setting object type, 174-13
- determining if tag is NULL, 174-39
- executing, 174-8, 174-21
- extra attributes
- excluding, 19-25
- including, 19-25
- getting command type, 174-34
- getting commit SCN, 174-35
- getting compatibility information, 174-35
- getting extra attributes, 174-36
- getting object name, 174-38
- getting object owner, 174-38
- getting SCN, 174-38
- getting source database name, 174-38
- getting tag, 174-38
- getting transaction identifier, 174-39
- LCR$_DDL_RECORD type, 174-3
- LCR$_ROW_LIST type, 174-44
- LCR$_ROW_RECORD type, 174-14
- LCR$_ROW_UNIT type, 174-45
- row LCRs, 174-14
- adding value to column, 174-19
- converting LONG to LOB, 174-20
- deleting value to column, 174-20
- getting column value, 174-25
- getting list of column values, 174-26
- getting LOB offset, 174-23
- renaming column, 174-28
- setting column value, 174-31
- setting list of column values, 174-32
- setting LOB offset, 174-29
- setting command type, 174-40
- setting extra attributes, 174-40
- setting object name, 174-41
- setting object owner, 174-42
- setting source database name, 174-42
- setting tag, 174-43
- types, 174-1
- LZ_COMPRESS functions and procedures, 152-6
- LZ_COMPRESS_ADD procedure, 152-8
- LZ_COMPRESS_CLOSE procedure, 152-9
- LZ_COMPRESS_OPEN function, 152-10
- LZ_UNCOMPRESS functions and procedures, 152-11
- LZ_UNCOMPRESS_CLOSE procedure, 152-15
- LZ_UNCOMPRESS_EXTRACT procedure, 152-13
- LZ_UNCOMPRESS_OPEN function, 152-14
M
- MAIL function and procedure, 164-23
- MAILTO function
- of HTF package, 123-97
- MAILTO procedure
- of HTP package, 128-95
- MAINTAIN_SIMPLE_TABLESPACE procedure, 96-72
- MAINTAIN_TABLESPACES procedure, 96-78
- MAKE_DATA_BLOCK_ADDRESS function, 104-35
- 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
- MAKEVERSIONED function, 109-13
- MAP_ALL function, 94-9
- MAP_ELEMENT function, 94-10
- MAP_FILE function, 94-11
- MAP_OBJECT function, 94-13
- MAPCLOSE function
- of HTF package, 123-98
- MAPCLOSE procedure
- of HTP package, 128-96
- MAPOPEN function
- of HTF package, 123-99
- MAPOPEN procedure
- of HTP package, 128-97
- MATCH function, 134-11
- materialized view logs
- master table
- purging, 54-14, 54-15, 54-16
- materialized views
- refreshing, 54-18, 54-21, 54-23
- MENULISTCLOSE function
- of HTF package, 123-100
- MENULISTCLOSE procedure
- of HTP package, 128-98
- MENULISTOPEN function
- of HTF package, 123-101
- MENULISTOPEN procedure
- of HTP package, 128-99
- META function
- of HTF package, 123-102
- META procedure
- of HTP package, 128-100
- methodology
- transformation, 24-6
- MG2 function
- of HTF package, 123-85
- migration
- post-migration actions, 55-1
- MIME_HEADER procedure, 137-20
- MIMEHEADER_DECODE function, 154-5
- MIMEHEADER_ENCODE function, 154-7
- min-max normalization, 24-4
- MODIFY_SNAPSHOT_SETTINGS procedure, 106-9
- MODIFY_TRANSFORMATION procedure, 102-6
- MOVEXDB_TABLESPACE procedure, 108-26
N
- NAME_RESOLVE procedure, 104-36
- NAME_TOKENIZE procedure, 104-38
- NAMESPACE function, 182-13
- new features, 1-xxxiii
- NEW_LINE procedure, 61-12, 155-27
- NEW_ROW_LIST function and procedure, 136-5
- NEWCONTEXT function, 114-10, 116-8, 117-7, 119-9
- NEWDOMDOCUMENT function, 113-130
- NEWPARSER function, 115-4
- NEWPROCESSOR function, 121-4
- NEWSTYLESHEET function, 121-4
- NEXT_DATE procedure, 41-11
- NEXT_ITEM_TYPE function, 63-28
- NL function
- of HTF package, 123-103
- NL procedure
- of HTP package, 128-101
- NOBR function
- of HTF package, 123-104
- NOBR procedure
- of HTP package, 128-102
- NOFRAMESCLOSE function
- of HTF package, 123-105
- NOFRAMESCLOSE procedure
- of HTP package, 128-103
- NOFRAMESOPEN function
- of HTF package, 123-106
- NOFRAMESOPEN procedure
- of HTP package, 128-104
- NOOP function and procedure, 164-25
- NORMAL function, 66-5
- NORMAL_DIST_FIT procedure, 92-4
- normalization, 24-4
- min-max, 24-4
- z-score, 24-4
- NORMALIZE procedure, 113-131
- numerical binning, 24-3
O
- OBJECT_DEPENDENT_SEGMENTS function, 88-10
- OBJECT_GROWTH_TREND function, 88-13
- OLISTCLOSE function
- of HTF package, 123-107
- OLISTCLOSE procedure
- of HTP package, 128-105
- OLISTOPEN function
- of HTF package, 123-108
- OLISTOPEN procedure
- of HTP package, 128-106
- OPEN_CONNECTION function, 165-18
- OPEN_CONNECTION functions, 164-26
- OPEN_CURSOR function, 90-56
- OPEN_DATA function and procedure, 164-28
- OR REPLACE clause
- for creating packages, 1-3
- Oracle Streams
- administrator
- granting privileges, 97-3
- revoking privileges, 97-7
- compatibility, 95-4, 95-5, 174-35
- creating queues, 96-107
- data dictionary
- removing information, 96-92
- messaging
- notification, 96-100
- Oracle-supplied types
- logical change record (LCR) types, 174-1
- rule types, 181-1
- ORMAT_CALL_STACK function, 104-27
- OUTLN_PKG package, 59-1
- OVERLAY function, 161-30
- OWA_CACHE package, 129-1
- OWA_COOKIE package, 130-1
- OWA_CUSTOM package, 131-1
- OWA_IMAGE package, 132-1
- OWA_OPT_LOCK package, 133-1
- OWA_PATTERN package, 134-1
- OWA_SEC package, 135-1
- OWA_TEXT package, 136-1
- OWA_UTIL package, 137-1
P
- PACK_MESSAGE procedures, 63-21
- package
- DBMS_ODCI, 56-1
- DBMS_XDB, 108-1
- DBMS_XDB_VERSION, 109-1
- DBMS_XDBT, 111-1
- DBMS_XMLDOM, 113-1
- DBMS_XMLGEN, 114-1
- DBMS_XMLPARSER, 115-1
- DBMS_XMLQUERY, 116-1
- DBMS_XMLSAVE, 117-1
- DBMS_XMLSCHEMA, 118-1
- DBMS_XMLSTORE, 119-1
- DBMS_XSLPROCESSOR, 121-1
- UriFactory, 172-36
- Package - UriFactory, 172-36
- package DBMS_XDBZ, 112-1
- package overview, 1-2
- package variables
- i_am_a_refresh, 54-12
- packages
- creating, 1-3
- referencing, 1-6
- where documented, 1-7
- PARA function
- of HTF package, 123-109
- PARA procedure
- of HTP package, 128-107
- PARAGRAPH function
- of HTF package, 123-110
- PARAGRAPH procedure
- of HTP package, 128-108
- PARAM function
- of HTF package, 123-111
- PARAM procedure
- of HTP package, 128-109
- PARSE procedure, 90-57, 115-4
- PARSEBUFFER procedure, 115-5
- PARSECLOB procedure, 115-6
- PARSEDTD procedure, 115-6
- PARSEDTDBUFFER procedure, 115-7
- PARSEDTDCLOB procedure, 115-7
- PAUSE_PROFILER function and procedure, 64-12
- PGRADE_STAT_TABLE procedure, 93-134
- PIECEWISE member procedure
- of ANYDATA TYPE, 168-14
- of ANYDATASET TYPE, 169-15
- PING procedure, 27-41
- PLAINTEXT function
- of HTF package, 123-112
- PLAINTEXT procedure
- of HTP package, 128-110
- plan stability, 59-2
- PL/SQL
- datatypes, 31-4
- numeric codes for, 31-7
- functions
- DBMS_MGWADM package subprograms, 51-29
- DBMS_MGWMSG package subprograms, 52-24
- procedures
- DBMS_MGWADM package subprograms, 51-29
- DBMS_MGWMSG package subprograms, 52-24
- PLSQL_TRACE_VERSION procedure, 100-9
- pointer to
- CTX_ADM package, 2-1
- point-in-time recovery
- Oracle Streams, 96-70
- POISSON_DIST_FIT procedure, 92-5
- PORT_STRING function, 104-39
- PRECLOSE function
- of HTF package, 123-113
- PRECLOSE procedure
- of HTP package, 128-111
- PREOPEN function
- of HTF package, 123-114
- PREOPEN procedure
- of HTP package, 128-112
- PREPARE_COLUMN_VALUES procedures, 93-103
- PREPARE_COLUMN_VALUES_NVARCHAR2 procedure, 93-106
- PREPARE_COLUMN_VALUES_ROWID procedure, 93-108
- PREPARE_GLOBAL_INSTANTIATION procedure, 19-27
- PREPARE_SCHEMA_INSTANTIATION procedure, 19-28
- PREPARE_TABLE_INSTANTIATION procedure, 19-29
- PRINT function
- of HTF package, 123-115
- PRINT procedure
- of HTP package, 128-113
- PRINT_BACKTRACE procedure, 27-42
- PRINT_CGI_ENV procedure, 137-21
- PRINT_INSTANTIATIONS procedure, 27-43
- PRINT_MULTI procedure, 136-6
- PRINT_ROW_LIST procedure, 136-7
- PRINTS procedure
- of HTP package, 128-114
- prior probabilities, 23-17
- privileges
- Oracle Streams administrator, 97-3, 97-7
- PRN function
- of HTF package, 123-116
- PRN procedure
- of HTP package, 128-115
- PROBE_VERSION procedure, 27-44
- PROCESSXSL function, 121-5
- PROPAGATEORIGINALEXCEPTION procedure, 116-8, 117-7
- propagations
- altering, 65-3
- creating, 65-6, 96-14, 96-34, 96-46, 96-58
- DBMS_PROPAGATION_ADM package, 65-1
- dropping, 65-11
- rules
- defining global, 96-14
- defining schema, 96-34
- defining subset, 96-46
- defining table, 96-58
- PS procedure
- of HTP package, 128-116
- PULL_SIMPLE_TABLESPACE procedure, 99-22
- PULL_TABLESPACES procedure, 99-25
- PURGE procedure, 63-33
- PURGE_LOST_DB_ENTRY procedure, 101-13
- PURGE_MIXED procedure, 101-16
- PURGE_SOURCE_CATALOG procedure, 96-92
- PURGE_STATS procedure, 93-110
- PURGELDAPCACHE function, 112-8
- purging
- the subscription window, 21-2
- PUT procedure, 155-28
- PUT procedures, 61-13
- PUT_FILE procedure, 35-7
- PUT_LINE procedure, 155-33
- PUT_LINE procedures, 61-15
- PUT_LINE_NCHAR procedure, 155-34
- PUT_NCHAR procedure, 155-31
- PUT_RAW function, 155-32
- PUTF procedure, 155-29
- PUTF_NCHAR procedure, 155-35
Q
- quantile numerical binning, 24-3
- query generation, 24-6
- queues
- AnyData
- creating, 96-107
- removing, 96-94
- QUIT function and procedure, 164-30
- QUOTED_PRINTABLE_DECODE function, 154-9
- QUOTED_PRINTABLE_ENCODE function, 154-10
R
- RANDOM procedure, 66-6
- RANK_APPLY procedure, 23-72
- RCPT function, 164-32
- RE$ATTRIBUTE_VALUE type, 181-4
- RE$ATTRIBUTE_VALUE_LIST type, 181-4
- RE$COLUMN_VALUE type, 181-5, 181-9
- RE$COLUMN_VALUE_LIST type, 181-6
- RE$NAME_ARRAY type, 181-6
- RE$NV_ARRAY type, 181-6
- RE$NV_LIST type, 181-6
- ADD_PAIR member procedure, 181-7
- GET_ALL_NAMES member function, 181-8
- GET_VALUE member function, 181-8
- REMOVE_PAIR member procedure, 181-8
- RE$RULE_HIT type, 181-10
- RE$RULE_HIT_LIST type, 181-10
- RE$TABLE_ALIAS type, 181-11
- RE$TABLE_ALIAS_LIST type, 181-12
- RE$TABLE_VALUE type, 181-12
- RE$TABLE_VALUE_LIST type, 181-12
- RE$VARIABLE_TYPE type, 181-13
- RE$VARIABLE_TYPE_LIST type, 181-15
- RE$VARIABLE_VALUE type, 181-16
- RE$VARIABLE_VALUE_LIST type, 181-16
- READ_CLIENT_INFO procedure, 14-5
- READ_LINE function, 165-21
- READ_LINE procedure
- of UTL_HTTP, 156-65
- READ_MODULE procedure, 14-6
- READ_ONLY procedure, 101-17
- READ_RAW function, 165-23
- READ_RAW procedure
- of UTL_HTTP, 156-67
- READ_TEXT function, 165-25
- READ_TEXT procedure
- of UTL_HTTP, 156-68
- READ_WRITE procedure, 101-18
- READ2CLOB function, 121-7
- REBUILD_FREELISTS procedure, 70-14
- REBUILDHIERARCHICALINDEX procedure, 108-27
- RECEIVE_MESSAGE function, 63-26
- RECOMP_PARALLEL procedure, 162-5
- RECOMP_SERIAL procedure, 162-6
- REDIRECT_URL procedure, 137-22
- refresh
- materialized views, 54-18, 54-21, 54-23
- REFRESH_PRIVATE_OUTLINE procedure, 60-7
- REGISTER procedure, 13-7
- REGISTER_DEPENDENT_OBJECT procedure, 68-10
- REGISTERSCHEMA procedure, 118-13
- REGISTERURI procedure, 118-16
- REGISTERURLHANDLER procedure, 172-40
- RELEASE function, 46-10
- RELEASE_ALL_SERVICES procedure, 153-14
- RELEASE_CALL procedure, 153-15
- RELEASE_SERVICE procedure, 153-16
- REMOVE procedure
- of DBMS_ALERT package, 13-8
- of DBMS_JOB package, 41-12
- of OWA_COOKIE package, 130-6
- REMOVE_PAIR member procedure, 181-8
- REMOVE_PIPE function, 63-31
- REMOVE_PROPERTY procedure, 153-17
- REMOVE_QUEUE procedure, 96-94
- REMOVE_RULE procedure, 82-22, 96-96
- REMOVE_SQLSET_REFERENCE procedure, 91-22
- REMOVE_STREAMS_CONFIGURATION procedure, 96-98
- REMOVEALL procedure, 13-9
- REMOVEATTRIBUTE procedure, 113-132
- REMOVEATTRIBUTENODE function, 113-133
- REMOVENAMEDITEM function, 113-135
- REMOVEPARAM procedure, 121-7
- REMOVEXSLTPARAM procedure, 116-9, 117-8
- RENAME_COLUMN member procedure, 174-28
- RENAME_MODEL procedure, 23-75
- RENAMERESOURCE procedure, 108-28
- REPLACECHILD function, 113-136
- REPLACEDATA procedure, 113-137
- replication
- datetime datatypes
- abbreviations, 1-7
- interval datatypes
- abbreviations, 1-7
- REPLY, REPLIES record types, 164-4
- REPORT_TUNING_TASK function, 91-23
- REQUEST function, 46-11, 156-70
- REQUEST_PIECES function, 156-73
- RESET_BUFFER procedure, 63-34
- RESET_TUNING_TASK procedure, 91-24
- RESETPARAMS procedure, 121-8
- RESOLVENAMESPACEPREFIX function, 113-138
- RESTARTQUERY procedure, 114-11
- RESTORE function, 94-14
- RESTORE_DATBASE_STATS procedure, 93-111
- RESTORE_DICTIONARY_STATS procedure, 93-112
- RESTORE_FIXED_OBJECTS_STATS procedure, 93-113
- RESTORE_SCHEMA_STATS procedure, 93-114
- RESTORE_SYSTEM_STATS procedure, 93-115
- RESTORE_TABLE_STATS procedure, 93-116
- RESUME_PROFILER function and procedure, 64-13
- RESUME_TUNING_TASK procedure, 91-25
- REVERSE function, 161-32
- REVOKE_ADMIN_PRIVILEGE procedure, 97-7
- REVOKE_OBJECT_PRIVILEGE procedure, 82-24
- REVOKE_REMOTE_ADMIN_ACCESS procedure, 97-9
- REVOKE_SWITCH_CONSUMER_GROUP procedure, 77-6
- REVOKE_SYSTEM_PRIVILEGE procedure, 77-8, 82-25
- ROLLBACK procedure, 101-19
- ROLLBACK_FORCE procedure, 101-20
- ROLLBACK_SAVEPOINT procedure, 101-21
- row migration, 96-46, 96-52
- ROWID datatype
- extended format, 80-17
- ROWID_BLOCK_NUMBER function, 80-7
- ROWID_CREATE function, 80-8
- ROWID_INFO procedure, 80-10
- ROWID_OBJECT function, 80-12
- ROWID_RELATIVE_FNO function, 80-13
- ROWID_ROW_NUMBER function, 80-14
- ROWID_TO_ABSOLUTE_FNO function, 80-15
- ROWID_TO_EXTENDED function, 80-17
- ROWID_TO_RESTRICTED function, 80-19
- ROWID_TYPE function, 80-20
- ROWID_VERIFY function, 80-21
- rule sets
- adding rules to, 82-4
- creating, 82-13
- dropping, 82-17
- removing rules from, 82-22
- rule-based transformations
- setting, 96-105
- rules
- action contexts
- adding name-value pairs, 181-7
- getting name-value pairs, 181-8
- getting value for name, 181-8
- removing name-value pairs, 181-8
- transformations, 96-105
- altering, 82-6
- creating, 82-11
- DBMS_RULE package, 81-1
- DBMS_RULE_ADM package, 82-1
- dropping, 82-16
- evaluation, 81-5
- iterators, 81-4, 81-10
- evaluation contexts
- creating, 82-9
- dropping, 82-15
- object privileges
- granting, 82-18
- revoking, 82-24
- propagations
- removing, 96-96
- RE$ATTRIBUTE_VALUE type, 181-4
- RE$ATTRIBUTE_VALUE_LIST type, 181-4
- RE$COLUMN_VALUE type, 181-5, 181-9
- RE$COLUMN_VALUE_LIST type, 181-6
- RE$NAME_ARRAY type, 181-6
- RE$NV_ARRAY type, 181-6
- RE$NV_LIST type, 181-6
- RE$RULE_HIT type, 181-10
- RE$RULE_HIT_LIST type, 181-10
- RE$TABLE_ALIAS type, 181-11
- RE$TABLE_ALIAS_LIST type, 181-12
- RE$TABLE_VALUE type, 181-12
- RE$TABLE_VALUE_LIST type, 181-12
- RE$VARIABLE_TYPE type, 181-13
- RE$VARIABLE_TYPE_LIST type, 181-15
- RE$VARIABLE_VALUE type, 181-16
- RE$VARIABLE_VALUE_LIST type, 181-16
- subset
- defining, 96-46, 96-52
- system privileges
- granting, 82-20
- revoking, 82-25
- system-created
- global apply, 96-19
- global capture, 96-19
- global propagation, 96-14
- global schema, 96-39
- removing, 96-96
- schema capture, 96-39
- schema propagation, 96-34
- subset apply, 96-52
- subset capture, 96-52
- subset propagation, 96-46
- table apply, 96-63
- table capture, 96-63
- table propagation, 96-58
- types, 181-1
- RUN procedure, 41-13
S
- S function
- of HTF package, 123-117
- S procedure
- of HTP package, 128-117
- SAMPLE function
- of HTF package, 123-118
- SAMPLE procedure
- of HTP package, 128-118
- SAVE function, 94-15
- SAVEPOINT procedure, 101-22
- SCHEMAVALIDATE procedure, 182-22
- SCN_TO_TIMESTAMP function, 36-13
- SCRIPT function
- of HTF package, 123-119
- SCRIPT procedure
- of HTP package, 128-119
- SDO_CS package documentation, 138-2
- SDO_GCDR package documentation, 139-2
- SDO_GEOM package documentation, 140-2
- SDO_GEOR package documentation, 141-2
- SDO_GEOR_UTL package documentation, 142-2
- SDO_LRS package documentation, 143-2
- SDO_MIGRATE package documentation, 144-2
- SDO_NET package documentation, 145-2
- SDO_SAM package documentation, 146-2
- SDO_TOPO package documentation, 147-2
- SDO_TOPO_MAP package documentation, 148-2
- SDO_TUNE package documentation, 149-2
- SDO_UTIL package documentation, 150-2
- SEED procedures, 66-7
- SEGMENT_CORRUPT procedure, 89-5
- SEGMENT_DROP_CORRUPT procedure, 89-6
- SEGMENT_DUMP procedure, 89-7
- SEGMENT_FIX_STATUS procedure, 70-15
- SEGMENT_VERIFY procedure, 89-8
- SELECT_OBJECT procedure, 163-10
- SELECT_SQLSET function, 91-26
- SELECT_WORKLOAD_REPOSITORY functions, 91-27
- SELECTNODES function, 121-8
- SELECTSINGLENODE function, 121-8
- SELF_CHECK procedure, 27-45
- SEND procedure, 130-7, 160-4
- SEND_ATTACH_RAW procedure, 160-5
- SEND_ATTACH_VARCHAR2 procedure, 160-7
- SEND_MESSAGE function, 63-23
- SERV_MOD_ACT_STAT_DISABLE procedure, 53-7
- SERV_MOD_ACT_STAT_ENABLE procedure, 53-8
- SERV_MOD_ACT_TRACE_DISABLE procedure, 53-10
- SERV_MOD_ACT_TRACE_ENABLE procedure, 53-12
- SESSION_TRACE_DISABLE procedure, 53-14
- SESSION_TRACE_ENABLE procedure, 53-15
- SET* member procedures
- of ANYDATA TYPE, 168-15
- of ANYDATASET TYPE, 169-16
- SET_ACTION procedure, 14-8
- SET_AUTHENTICATION procedure, 156-77
- SET_AUTHORIZATION procedure, 135-8
- SET_BASE_TABLE_NAME member procedure, 174-10
- SET_BASE_TABLE_OWNER member procedure, 174-11
- SET_BODY_CHARSET procedures, 156-78
- SET_BREAKPOINT function, 27-46
- SET_CLIENT_INFO procedure, 14-10
- SET_COLUMN_STATS procedures, 93-117
- SET_COMMAND_TYPE member procedure, 174-40
- SET_CONSUMER_GROUP_MAPPING procedure, 76-24
- SET_CONSUMER_GROUP_MAPPING_PRI procedure, 76-25
- SET_COOKIE_SUPPORT procedures, 156-80
- SET_CURRENT_SCHEMA member procedure, 174-11
- SET_DDL_TEXT member procedure, 174-12
- SET_DEFAULTS procedure, 13-10
- SET_DETAILED_EXCP_SUPPORT procedure, 156-82
- SET_DML_HANDLER procedure, 15-30
- SET_ENQUEUE_DESTINATION procedure, 15-36
- SET_EXECUTE procedure, 15-38
- SET_EXTRA_ATTRIBUTE member procedure, 174-40
- SET_FOLLOW_REDIRECT procedures, 156-83
- SET_GLOBAL_INSTANTIATION procedure, 15-40
- SET_HEADER procedure, 156-85
- SET_INDEX_STATS procedures, 93-120
- SET_INITIAL_CONSUMER_GROUP procedure, 76-27
- SET_KEY_COLUMNS procedure, 15-43
- SET_LOB_INFORMATION member procedure, 174-28
- SET_LOB_OFFSET member procedure, 174-29
- SET_LOB_OPERATION_SIZE member procedure, 174-30
- SET_LOGON_USER member procedure, 174-12
- SET_MESSAGE_NOTIFICATION procedure, 96-100
- SET_MODULE procedure, 14-11
- SET_OBJECT_NAME member procedure, 174-41
- SET_OBJECT_OWNER member procedure, 174-42
- SET_OBJECT_TYPE member procedure, 174-13
- SET_OER_BREAKPOINT function, 27-48
- SET_PARAM procedure, 93-124
- SET_PARAMETER procedure, 19-30
- apply process, 15-45
- SET_PERSISTENT_CONN_SUPPORT procedure, 156-87
- SET_PLSQL_TRACE procedure, 100-10
- SET_PROPERTY procedure, 153-18
- SET_PROTECTION_REALM procedure, 135-10
- SET_PROXY procedure, 156-90
- SET_RESPONSE_ERROR_CHECK procedure, 156-92
- SET_RULE_TRANSFORM_FUNCTION procedure, 96-105
- SET_SCHEMA_INSTANTIATION procedure, 15-49
- SET_SESSION_LONGOPS procedure, 14-13
- SET_SESSION_TIMEOUT procedure, 78-7
- SET_SOURCE_DATABASE_NAME member procedure, 174-42
- SET_SYSTEM_STATS procedure, 93-126
- SET_TABLE_INSTANTIATION procedure, 15-52
- SET_TABLE_STATS procedure, 93-129
- SET_TAG member procedure, 174-43
- SET_TAG procedure, 95-12
- SET_THRESHOLD procedure, 84-14
- SET_TIMEOUT function, 27-49
- SET_TIMEOUT procedure, 78-8
- SET_TIMEOUT_BEHAVIOUR procedure, 27-50
- SET_TRANSFER_TIMEOUT procedure, 156-93
- SET_TRIGGER_FIRING_PROPERTY procedure, 26-9
- SET_UP_QUEUE procedure, 96-107
- SET_UPDATE_CONFLICT_HANDLER procedure, 15-54
- SET_VALUE function, 27-51
- SET_VALUE member procedure, 174-31
- SET_VALUES member procedure, 174-32
- SET_WALLET procedure, 156-94
- SET_WARNING_SETTING_STRING procedure, 105-10
- SETACL procedure, 108-29
- SETATTRIBUTE procedure, 113-139
- SETATTRIBUTENODE function, 113-140
- SETBASEDIR procedure, 115-8
- SETBATCHSIZE procedure, 117-8
- SETBINDVALUE procedure, 116-9
- SETCOLLIDATTRNAME procedure, 116-10
- SETCOMMITBATCH procedure, 117-9
- SETCONVERTSPECIALCHARS procedure, 114-12
- SETDATA procedure, 113-141
- SETDATAHEADER procedure, 116-10
- SETDATEFORMAT procedure, 116-11, 117-9
- SETDCHARSET procedure, 113-145
- SETDOCTYPE procedure, 115-8
- SETDVERSION procedure, 113-147
- SETENCODINGTAG procedure, 116-11
- SETERRORLOG procedure, 115-8, 121-9
- SETERRORTAG procedure, 116-12
- SETIGNORECASE procedure, 117-10
- SETINFO member procedure
- of ANYTYPE TYPE, 170-4
- SETKEYCOLUMN procedure, 117-10, 119-10
- SETMAXROWS procedure, 114-13, 116-12
- SETMETAHEADER procedure, 116-13
- SETNAMEDITEM function, 113-142
- SETNODEVALUE procedure, 113-143
- SETPARAM procedure, 121-9
- SETPREFIX procedure, 113-144
- SETPRESERVEWHITESPACE procedure, 115-9, 117-11
- SETRAISEEXCEPTION procedure, 116-13
- SETRAISENOROWSEXCEPTION procedure, 116-14
- SETROWIDATTRNAME procedure, 116-14
- SETROWIDATTRVALUE procedure, 116-15
- SETROWSETTAG procedure, 114-15, 116-15
- SETROWTAG procedure, 116-15, 117-11, 119-11
- SETSCHEMAVALIDATED procedure, 182-23
- SETSKIPROWS procedure, 114-17, 116-16
- SETSQLTOXMLNAMEESCAPING procedure, 116-16, 117-11
- SETSTANDALONE procedure, 113-145
- SETSTYLESHEETHEADER procedure, 116-17
- SETTAGCASE procedure, 116-17
- SETUPDATECOLUMN procedure, 117-12, 119-12
- SETVALIDATIONMODE procedure, 115-9
- SETVALUE procedure, 113-146
- SETXSLT procedure, 116-18, 117-12
- SETXSLTPARAM procedure, 116-19, 117-13
- SHOW_BREAKPOINTS procedures, 27-53
- SHOW_FRAME_SOURCE procedure, 27-54
- SHOW_SOURCE procedures, 27-55
- SHOWPAGE procedure, 137-23
- SHOWSOURCE procedure, 137-24
- SHOWWARNINGS procedure, 115-10, 121-10
- SIGNAL procedure, 13-11
- SIGNATURE procedure, 137-25
- SIZES procedure, 87-7
- SKIP_CORRUPT_BLOCKS procedure, 70-17
- SLEEP procedure, 46-13
- SMALL function
- of HTF package, 123-120
- SMALL procedure
- of HTP package, 128-120
- snapshot. See DBMS_MVIEW, 54-1
- SPACE_ERROR_INFO function, 78-9
- SPACE_USAGE procedure, 88-15
- SPLITTEXT function, 113-148
- SQL statements
- larger than 32 KB, 90-59
- SQL*Plus
- creating a sequence, 1-6
- staging
- queues
- creating, 96-107
- removing, 96-94
- START_APPLY procedure, 15-58
- START_CAPTURE procedure, 19-33
- START_PROFILER functions and procedures, 64-14
- START_REDEF_TABLE procedure, 68-11
- START_SERVICE procedure, 85-7
- STARTUP_EXTPROC_AGENT procedure, 122-5
- STATUS_LINE procedure, 137-26
- STEP_ID function, 101-23
- STOP_APPLY procedure, 15-59
- STOP_CAPTURE procedure, 19-34
- STOP_PROFILER function and procedure, 64-15
- STOP_SERVICE procedure, 85-8
- STORE_VALUES procedure, 133-6
- stored outlines
- DBMS_OUTLN, 59-1
- OUTLN_PKG package, 59-1
- STREAM2MULTI procedure, 136-8
- Streams
- removing configuration, 96-98
- STREAMS$_TRANSFORM_FUNCTION, 15-36, 15-38, 96-106
- STRIKE function
- of HTF package, 123-121
- STRIKE procedure
- of HTP package, 128-121
- STRING function, 66-8
- STRONG function
- of HTF package, 123-122
- STRONG procedure
- of HTP package, 128-122
- STYLE function
- of HTF package, 123-123
- STYLE procedure
- of HTP package, 128-123
- SUB procedure
- of HTP package, 128-124
- SUBMIT procedure, 41-14
- SUBMIT_PENDING_AREA procedure, 76-29
- subscribers
- drop the subscription, 21-2
- extend the window to create a new view, 21-2
- purging the subscription window, 21-2
- retrieve change data from the subscriber views, 21-2
- subscription window
- purging, 21-2
- SUBSTR function, 161-33
- SUBSTRINGDATA function, 113-149
- SUMMARY procedure, 92-6
- SUP function
- of HTF package, 123-125
- SUP procedure
- of HTP package, 128-125
- SWITCH_CONSUMER_GROUP_FOR_SESS procedure, 76-30
- SWITCH_CONSUMER_GROUP_FOR_USER procedure, 76-31
- SWITCH_PLAN procedure, 76-32
- SYNC_INTERIM_TABLE procedure, 68-13
- SYNCHRONIZE function, 27-57
T
- TABLE_TO_COMMA procedures, 104-40
- TABLECAPTION function
- of HTF package, 123-126
- TABLECAPTION procedure
- of HTP package, 128-126
- TABLECLOSE function
- of HTF package, 123-129
- TABLECLOSE procedure
- of HTP package, 128-129
- TABLEDATA function
- of HTF package, 123-127
- TABLEDATA procedure
- of HTP package, 128-127
- TABLEHEADER function
- of HTF package, 123-128
- TABLEHEADER procedure
- of HTP package, 128-128
- TABLEOPEN function
- of HTF package, 123-130
- TABLEOPEN procedure
- of HTP package, 128-130
- TABLEPRINT function, 137-27
- TABLEROWCLOSE function
- of HTF package, 123-131
- TABLEROWCLOSE procedure
- of HTP package, 128-131
- TABLEROWOPEN function
- of HTF package, 123-132
- TABLEROWOPEN procedure
- of HTP package, 128-132
- tables
- table items as arrays, 90-28, 90-32
- TABLESPACE_FIX_BITMAPS procedure, 89-10
- TABLESPACE_FIX_SEGMENT_STATES procedure, 89-11
- TABLESPACE_MIGRATE_FROM_LOCAL procedure, 89-12
- TABLESPACE_MIGRATE_TO_LOCAL procedure, 89-13
- TABLESPACE_REBUILD_BITMAPS procedure, 89-15
- TABLESPACE_REBUILD_QUOTAS procedure, 89-16
- TABLESPACE_RELOCATE_BITMAPS procedure, 89-17
- TABLESPACE_SET type, 99-4
- TABLESPACE_VERIFY procedure, 89-19
- tablespaces
- change tables and, 20-25
- tags
- GET_TAG function, 95-11
- SET_TAG procedure, 95-12
- TARGET_PROGRAM_RUNNING procedure, 27-58
- TELETYPE function
- of HTF package, 123-133
- TELETYPE procedure
- of HTP package, 128-133
- TERMINATE procedure, 66-9
- TEXT_DECODE function, 154-11
- TEXT_ENCODE function, 154-13
- TIMESTAMP_TO_SCN function, 36-14
- TITLE function
- of HTF package, 123-134
- TITLE procedure
- of HTP package, 128-134
- TODATE function, 137-31
- TOOBJECT procedure, 182-24
- top-N frequency binning, 24-3
- TRACETAB.SQL, 100-4
- transform definition table, 24-5
- TRANSFORM function, 182-25
- transformation methodology, 24-6
- transformations
- binning, 24-3
- equi-width binning, 24-3
- normalization, 24-4
- Oracle Streams
- setting, 96-105
- rule-based
- setting, 96-105
- STREAMS$_TRANSFORM_FUNCTION, 15-36, 15-38, 96-106
- supported, 24-3
- trimming, 24-4
- winsorizing, 24-4
- TRANSFORMNODE function, 121-10
- TRANSLATE function, 161-35
- TRANSPORT_SET_CHECK procedure, 110-5
- trimming, 24-4
U
- ULISTCLOSE function
- of HTF package, 123-135
- ULISTCLOSE procedure
- of HTP package, 128-135
- ULISTOPEN function
- of HTF package, 123-136
- ULISTOPEN procedure
- of HTP package, 128-136
- UNCHECKOUT function, 109-14
- UNDERLINE function
- of HTF package, 123-137
- UNDERLINE procedure
- of HTP package, 128-137
- UNESCAPE function, 166-7
- UNESCAPEURI function, 172-39
- UNIFORM_DIST_FIT procedure, 92-8
- UNIQUE_SESSION_NAME function, 63-35
- UNKEEP procedure, 87-8
- UNLOCK_MAP procedure, 94-16
- UNLOCK_SCHEMA_STATS procedure, 93-132
- UNLOCK_TABLE_STATS procedure, 93-133
- UNLOCKRESOURCE function, 108-30
- UNPACK_MESSAGE procedures, 63-29
- UNREGISTER_DEPENDENT_OBJECT procedure, 68-14
- UNREGISTERURLHANDLER procedure, 172-41
- UNUSED_SPACE procedure, 88-18
- UPDATE_BY_CAT procedure, 59-9
- UPDATE_CONSUMER_GROUP procedure, 76-33
- UPDATE_OBJECT procedure, 163-11
- UPDATE_PLAN procedure, 76-34
- UPDATE_PLAN_DIRECTIVE procedure, 76-35
- UPDATE_SIGNATURES procedure, 59-10
- UPDATE_SQLSET procedures, 91-29
- UPDATEXML function, 117-14, 119-13
- upgrading
- post-upgrade actions, 55-1
- URI Types
- description, 172-1
- UriFactory package, 172-36
- ESCAPEURI function, 172-38
- GETURL function, 172-37
- methods, 172-36
- REGISTERURLHANDLER procedure, 172-40
- UNESCAPEURI function, 172-39
- UNREGISTERURLHANDLER procedure, 172-41
- UriType supertype, 172-2
- GETBLOB function, 172-3
- GETCLOB function, 172-4
- GETCONTENTTYPE function, 172-5
- GETEXTERNALURL function, 172-6
- GETURL function, 172-7
- GETXML function, 172-8
- methods, 172-2
- USE_ROLLBACK_SEGMENT procedure, 101-24
- USEITEMTAGSFORCOLL procedure, 114-18
- USENULLATTRIBUTEINDICATOR procedure, 114-19, 116-19
- user views
- DBMS_DATA_MINING, 23-10
- USER_EXPORT procedures, 41-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
- USETYPEFORCOLLELEMTAG procedure, 116-20
- UTL_COLL package, 151-1
- UTL_COMPRESS package, 152-1
- UTL_DBWS package, 153-1
- UTL_ENCODE package, 154-1
- UTL_FILE package, 155-1
- UTL_HTTP package, 156-1
- UTL_I18N package, 157-1
- ESCAPE_REFERENCE function, 157-4
- GET_DEFAULT_CHARSET function, 157-5
- MAP_CHARSET function, 157-7
- MAP_LANGUAGE_FROM_ISO function, 157-10
- MAP_LOCALE_TO_ISO function, 157-11
- MAP_TERRITORY_FROM_ISO function, 157-12
- RAW_TO_CHAR function, 157-13
- RAW_TO_NCHAR function, 157-16
- UNESCAPE_REFERENCE function, 157-20
- UTL_INADDR package, 158-1
- UTL_LMS package, 159-1
- FORMAT_MESSAGE function, 159-4
- GET_MESSAGE function, 159-6
- UTL_MAIL package, 160-1
- UTL_RAW package, 161-1
- UTL_RECOMP package, 162-1
- UTL_REF package, 163-1
- UTL_TCP package, 165-1
- UTL_URL package, 166-1
- UUDECODE function, 154-15
- UUENCODE function, 154-16
V
- v$vpd_policies, 79-3
- VALIDATE procedure, 104-41
- VALIDATE_DIMENSION procedure, 32-5
- VALIDATE_PENDING_AREA procedure, 76-38
- VALUE functions, 66-10
- VALUEOF procedure, 121-11
- VARIABLE function
- of HTF package, 123-138
- VARIABLE procedure
- of HTP package, 128-138
- VARIABLE_VALUE procedures, 90-60
- VERIFY_VALUES function, 133-7
- views
- summary, 51-22
- Virtual Private Database. See VPD
- VPD
- column masking, 79-6
- enabling column-level, 79-6
- viewing current cursors and policy predicates, 79-3
- VPD use of DBMS_RLS, 79-1
- VRFY function, 164-36
W
- WAITANY procedure, 13-12
- WAITONE procedure, 13-13
- WBR function
- of HTF package, 123-139
- WBR procedure
- of HTP package, 128-139
- WEIBULL_DIST_FIT procedure, 92-9
- WHAT procedure, 41-17
- WHO_CALLED_ME procedure, 137-32
- winsorizing, 24-4
- WPG_DOCLOAD package, 167-1
- WRITE_DATA procedure, 164-37
- WRITE_LINE function, 165-27
- WRITE_LINE procedure, 156-96
- WRITE_RAW function, 165-28
- WRITE_RAW procedure, 156-98
- WRITE_RAW_DATA procedure, 164-39
- WRITE_TEXT function, 165-29
- WRITE_TEXT procedure, 156-99
- WRITETOBUFFER procedure, 113-150
- WRITETOCLOB procedure, 113-151
- WRITETOFILE procedure, 113-152
X
- XDBUriType, 172-27
- XDBURITYPE function, 172-35
- XDBUriType subtype, 172-27
- CREATEURI function, 172-28
- GETBLOB function, 172-29
- GETCLOB function, 172-30
- GETCONTENTTYPE function, 172-31
- GETEXTERNALURL function, 172-32
- GETURL function, 172-33
- GETXML function, 172-34
- methods, 172-27
- XDBURITYPE function, 172-35
- XFORM_BIN_CAT procedure, 24-28
- XFORM_BIN_NUM procedure, 24-31
- XFORM_CLIP procedure, 24-34
- XFORM_NORM_LIN procedure, 24-36
- XMLType
- CREATENONSCHEMABASEDXML function, 182-4
- CREATESCHEMABASEDXML function, 182-5
- CREATEXML function, 182-6
- description, 182-1
- EXISTSNODE function, 182-9
- EXTRACT function, 182-10
- GETBLOBVAL function, 182-11
- GETCLOBVAL function, 182-12
- GETNUMBERVAL function, 182-14
- GETROOTELEMENT function, 182-15
- GETSCHEMAURL function, 182-16
- GETSTRINGVAL function, 182-17
- ISFRAGMENT function, 182-18
- ISSCHEMABASED function, 182-19
- ISSCHEMAVALID function, 182-20
- ISSCHEMAVALIDATED function, 182-21
- NAMESPACE function, 182-13
- SCHEMAVALIDATE procedure, 182-22
- SETSCHEMAVALIDATED procedure, 182-23
- TOOBJECT procedure, 182-24
- TRANSFORM function, 182-25
- XMLTYPE function, 182-26
- XMLTYPE function, 182-26
- XRANGE function, 161-39
Z
- z-score normalization, 24-4