Index
A B C D E F G H I K L M N O P Q R S T U V W X Z
A
- ABORT procedure, 87
- ABORT_GLOBAL_INSTANTIATION procedure, 20
- ABORT_REDEF_TABLE procedure, 77
- ABORT_SCHEMA_INSTANTIATION procedure, 20
- ABORT_TABLE_INSTANTIATION procedure, 20
- ABORTED_REQUEST_THRESHOLD procedure, 97
- ACCEPT_SQL_PROFILE procedure, 101
- ACLCHECKPRIVILEGES function, 120
- ACTIVATE_SUBSCRIPTION Procedure, 22
- ACTIVE_INSTANCES procedure, 116
- ADD_COLUMN member procedure, 188
- ADD_COLUMN procedure, 106
- ADD_COOKIES procedure, 168
- ADD_ELEMENTARY_ATTRIBUTE procedure, 39, 88
- ADD_EVENT procedure, 88
- ADD_FILE procedure, 41
- ADD_FUNCTIONS procedure, 39, 88
- ADD_GLOBAL_PROPAGATION_RULES procedure, 106
- ADD_GLOBAL_RULES procedure, 106
- ADD_MESSAGE_PROPAGATION_RULE procedure, 106
- ADD_MESSAGE_RULE procedure, 106
- ADD_PAIR member procedure, 196
- ADD_RULE procedure, 88, 92
- ADD_SCHEMA_PROPAGATION_RULES procedure, 106
- ADD_SCHEMA_RULES procedure, 106
- ADD_SQLSET_REFERENCE function, 101
- ADD_SQLWKLD_REF Procedure, 12
- ADD_SQLWKLD_STATEMENT Procedure, 12
- ADD_SUBSCRIBER Procedure, 58
- ADD_SUBSET_PROPAGATION_RULES procedure, 106
- ADD_SUBSET_RULES procedure, 106
- ADD_TABLE_PROPAGATION_RULES procedure, 106
- ADD_TABLE_RULES procedure, 106
- ADD_WARNING_SETTING_CAT procedure, 117
- ADD_WARNING_SETTING_NUM procedure, 117
- ADD2MULTI procedure, 147
- ADDATTR member procedure
-
- of ANYTYPE TYPE, 183
- ADDINSTANCE member procedure
-
- of ANYDATASET TYPE, 182
- ADDRESS function
-
- of HTF package, 134
- ADDRESS procedure
-
- of HTP package, 139
- ADMIN_TABLES procedure, 79
- ADVISE_COMMIT procedure, 111
- ADVISE_NOTHING procedure, 111
- ADVISE_ROLLBACK procedure, 111
- ALLOCATE_UNIQUE procedure, 53
- ALTER_AGENT Procedure, 58
- ALTER_APPLY procedure, 15
- ALTER_CAPTURE procedure, 20
- ALTER_COMPILE procedure, 29
- ALTER_DATABASE_TAB_MONITORING procedure, 103
- ALTER_EVALUATION_CONTEXT procedure, 92
- ALTER_FILE procedure, 41
- ALTER_FILE_GROUP procedure, 41
- ALTER_MSGSYSTEM_LINK Procedure for TIB/Rendezvous, 58
- ALTER_MSGSYSTEM_LINK Procedure for WebSphere MQ, 58
- ALTER_PROPAGATION procedure, 74
- ALTER_PROPAGATION_SCHEDULE Procedure, 58
- ALTER_REWRITE_EQUIVALENCE Procedure, 11
- ALTER_RULE procedure, 92
- ALTER_SCHEMA_TAB_MONITORING procedure, 103
- ALTER_SQL_PROFILE procedure, 101
- ALTER_STATS_HISTORY_RETENTION procedure, 103
- ALTER_SUBSCRIBER Procedure, 58
- ALTER_TABLE_NOT_REFERENCEABLE procedure, 29
- ALTER_TABLE_REFERENCEABLE procedure, 29
- ALTER_VERSION procedure, 41
- AMATCH function, 145
- ANALYZE_DATABASE procedure, 116
- ANALYZE_PART_OBJECT procedure, 116
- ANALYZE_SCHEMA procedure, 116
- ANCHOR function
-
- of HTF package, 134
- ANCHOR procedure
-
- of HTP package, 139
- ANCHOR2 function
-
- of HTF package, 134
- ANCHOR2 procedure
-
- of HTP package, 139
- anomaly detection, 25, 25, 25, 25, 25, 25, 25, 25
- anonymous PL/SQL blocks
-
- dynamic SQL and, 100
- AnyData datatype
-
- queues
-
- creating, 106
- removing, 106
- ANYDATA TYPE, 181
- ANYDATASET TYPE, 182
- ANYTYPE TYPE, 183
- APPEND Procedures, 52
- APPENDCHILD function, 124
- APPENDDATA procedure, 124
- APPENDRESOURCEMETADATA Procedure, 120
- APPLETCLOSE function
-
- of HTF package, 134
- APPLETCLOSE procedure
-
- of HTP package, 139
- APPLETOPEN function
-
- of HTF package, 134
- APPLETOPEN procedure
-
- of HTP package, 139
- APPLY procedure, 25
- apply process
-
- altering, 15
- apply user, 106
- conflict handlers
-
- setting, 15
- creating, 15, 106, 106, 106, 106, 106
- DBMS_APPLY_ADM package, 15
- DDL handler
-
- setting, 15, 15
- DML handlers
-
- setting, 15
- dropping, 15
- enqueuing events, 15
- error handlers
-
- setting, 15
- error queue
-
- deleting errors, 15, 15
- executing errors, 15, 15
- getting error messages, 15
- instantiation
-
- global SCN, 15
- schema SCN, 15
- table SCN, 15
- message handler
-
- setting, 15, 15
- parameters
-
- allow_duplicate_rows, 15
- commit_serialization, 15
- disable_on_error, 15
- disable_on_limit, 15
- maximum_scn, 15
- parallelism, 15
- setting, 15
- startup_seconds, 15
- time_limit, 15
- trace_level, 15
- transaction_limit, 15
- txn_lcr_spill_threshold, 15
- precommit handler
-
- setting, 15, 15
- rules
-
- defining global, 106
- defining message, 106
- defining schema, 106
- defining subset, 106
- defining table, 106
- for LCRs, 106
- for user messages, 106
- removing, 106
- specifying execution, 15
- starting, 15
- stopping, 15
- substitute key columns
-
- setting, 15
- APPLY$_ENQUEUE, 15
- APPLY$_EXECUTE, 15
- AQ$_AGENT Type, 184
- AQ$_AGENT_LIST_T Type, 184
- AQ$_DESCRIPTOR Type, 184, 184
- AQ$_POST_INFO Type, 184
- AQ$_POST_INFO_LIST Type, 184
- AQ$_PURGE_OPTIONS_T Type, 184
- AQ$_RECIPIENT_LIST_T Type, 184
- AQ$_REG_INFO Type, 184
- AQ$_REG_INFO_LIST Type, 184
- AQ$_SUBSCRIBER_LIST_T Type, 184
- AREA function
-
- of HTF package, 134
- AREA procedure
-
- of HTP package, 139
- arrays
-
- BIND_ARRAY procedure, 100
- bulk DML using DBMS_SQL, 100, 100
- ASA_RECO_ROW Record Type, 98
- ASA_RECO_ROW_TB Table Type, 98
- ASA_RECOMMENDATIONS Function, 98
- ASH_REPORT_HTML Function, 118
- ASH_REPORT_TEXT Function, 118
- ASSIGN_ATTRIBUTE_SET procedure, 39
- ASSM_SEGMENT_VERIFY Procedure, 99
- ASSM_TABLESPACE_VERIFY Procedure, 99
- ATTACH_SESSION procedure, 30
- ATTACH_SIMPLE_TABLESPACE procedure, 109
- ATTACH_TABLESPACES procedure, 109
- attribute sets
-
- dropping, 39
- AUTHORIZE function, 142
- AUTHORIZE_DAD Procedure, 37
- AVAILABLE function, 178
- AWR_DIFF_REPORT_HTML Function, 118
- AWR_DIFF_REPORT_TEXT Function, 118
- AWR_REPORT_HTML function, 118
- AWR_REPORT_TEXT function, 118
- AWR_SQL_REPORT_HTML Function, 118
- AWR_SQL_REPORT_TEXT Function, 118
B
- BASE function
-
- of HTF package, 134
- BASE procedure
-
- of HTP package, 139
- BASE64_DECODE function, 166
- BASE64_ENCODE function, 166
- BASEFONT function
-
- of HTF package, 134
- BASEFONT procedure
-
- of HTP package, 139
- BEGIN_DISCRETE_TRANSACTION procedure, 111
- BEGIN_REQUEST function, 168
- BEGINCREATE static procedure
-
- of ANYDATA TYPE, 181
- of ANYDATASET TYPE, 182
- of ANYTYPE TYPE, 183
- BGSOUND function
-
- of HTF package, 134
- BGSOUND procedure
-
- of HTP package, 139
- BIG function
-
- of HTF package, 134
- BIG procedure
-
- of HTP package, 139
- BIND_ARRAY procedures, 100
- BIND_INOUT_VARIABLE Procedure, 45
- BIND_INOUT_VARIABLE_RAW Procedure, 45
- BIND_OUT_VARIABLE Procedure, 45
- BIND_OUT_VARIABLE_RAW Procedure, 45
- BIND_VARIABLE Procedure, 45
- BIND_VARIABLE procedures, 100
- BIND_VARIABLE_RAW Procedure, 45
- BIND_VARIABLES function, 148
- binning, 26
-
- categorical, 26
- numerical, 26, 26
- quantile, 26
- BIT_AND function, 174
- BIT_COMPLEMENT function, 174
- BIT_OR function, 174
- BIT_XOR function, 174
- BLAS Level 1 (Vector-Vector Operations) Subprograms, 173
- BLAS Level 2 (Matrix-Vector Operations) Subprograms, 173
- BLAS Level 3 (Matrix-Matrix Operations) Subprograms, 173
- BLAS_ASUM Functions, 173
- BLAS_AXPY Procedures, 173
- BLAS_COPY Procedures, 173
- BLAS_DOT Functions, 173
- BLAS_GBMV Procedures, 173
- BLAS_GEMM Procedures, 173
- BLAS_GEMV Procedures, 173
- BLAS_GER Procedures, 173
- BLAS_IAMAX Functions, 173
- BLAS_NRM2 Functions, 173
- BLAS_ROT Procedures, 173
- BLAS_ROTG Procedures, 173
- BLAS_SBMV Procedures, 173
- BLAS_SCAL Procedure, 173
- BLAS_SPMV Procedures, 173
- BLAS_SPR Procedures, 173
- BLAS_SPR2 Procedures, 173
- BLAS_SWAP Procedure, 173
- BLAS_SYMM Procedures, 173
- BLAS_SYMV Procedures, 173
- BLAS_SYR Procedures, 173
- BLAS_SYR2 Procedures, 173
- BLAS_SYRK Procedures, 173
- BLAS_TBMV Procedures, 173
- BLAS_TBSV Procedures, 173
- BLAS_TPMV Procedures, 173
- BLAS_TPSV Procedures, 173
- BLAS_TRMM Procedures, 173
- BLAS_TRMV Procedures, 173
- BLAS_TRSM Procedures, 173
- BLAS_TRSV Procedures, 173
- BLOCKQUOTECLOSE function
-
- of HTF package, 134
- BLOCKQUOTECLOSE procedure
-
- of HTP package, 139, 139
- BLOCKQUOTEOPEN function
-
- of HTF package, 134
- BLOCKQUOTEOPEN procedure
-
- of HTP package, 139
- BODYCLOSE function
-
- of HTF package, 134
- BODYCLOSE procedure
-
- of HTP package, 139
- BODYOPEN function
-
- of HTF package, 134
- BODYOPEN procedure
-
- of HTP package, 139
- BOLD function
-
- of HTF package, 134
- BOLD procedure
-
- of HTP package, 139
- BR function
-
- of HTF package, 134
- BR procedure
-
- of HTP package, 139
- BREAKPOINT_INFO Record Type, 30
- BROKEN procedure, 48
- BUILD procedure, 20
- BUILD_CHAIN_ROWS_TABLE procedure, 46
- BUILD_EXCEPTIONS_TABLE procedure, 39, 46
- BUILD_PART_INDEX procedure, 69
- BUILD_SAFE_REWRITE_EQUIVALENCE Procedure, 11
C
- CALENDARPRINT procedures, 148
- CAN_REDEF_TABLE procedure, 77
- CANCEL_TASK Procedure, 12
- CANCEL_TUNING_TASK procedure, 101
- CANONICALIZE procedure, 116
- capture process
-
- altering, 20
- building a Streams data dictionary, 20
- capture user, 106
- creating, 106, 106, 106, 106
- DBMS_CAPTURE_ADM package, 20
- instantiation
-
- aborting database preparation, 20
- aborting schema preparation, 20
- aborting table preparation, 20
- preparing a database for, 20
- preparing a schema for, 20
- preparing a table for, 20
- parameters
-
- disable_on_limit, 20
- downstream_real_time_mine, 20
- maximum_scn, 20
- message_limit, 20
- parallelism, 20
- setting, 20
- startup_seconds, 20
- time_limit, 20
- trace_level, 20
- write_alert_log, 20
- rules, 106
-
- defining global, 106
- defining schema, 106
- defining subset, 106
- defining table, 106
- removing, 106
- starting, 20
- stopping, 20
- CAPTURE_CURSOR_CACHE_SQLSET Procedure, 101
- CAST_FROM_BINARY_DOUBLE function, 174
- CAST_FROM_BINARY_FLOAT function, 174
- CAST_FROM_BINARY_INTEGER function, 174
- CAST_FROM_NUMBER function, 174
- CAST_TO_BINARY_DOUBLE function, 174
- CAST_TO_BINARY_FLOAT function, 174
- CAST_TO_BINARY_INTEGER function, 174
- CAST_TO_NUMBER function, 174
- CAST_TO_NVARCHAR2 function, 174
- CAST_TO_RAW function, 174
- CAST_TO_VARCHAR2 function, 174
- categorical binning, 26
- catproc.sql script, 1
- CELLSPRINT procedures, 148
- CENTER function
-
- of HTF package, 134
- CENTER procedure
-
- of HTP package, 139
- CENTERCLOSE function
-
- of HTF package, 134
- CENTERCLOSE procedure
-
- of HTP package, 139
- CENTEROPEN function
-
- of HTF package, 134
- CENTEROPEN procedure
-
- of HTP package, 139
- CFG_GET function, 120
- CFG_REFRESH procedure, 120
- CFG_UPDATE procedure, 120
- Change Data Capture
-
- DBMS_CDC_PUBLISH package, 21
- CHANGE functions and procedures, 145
- CHANGE procedure, 48
- change tables
-
- tablespaces created in, 21
- CHANGE_JOIN_POS procedure, 67
- CHARARR Table Type, 68
- CHECK_OBJECT procedure, 79
- CHECKIN function, 121
- CHECKOUT procedure, 121
- CHECKPRIVILEGES function, 120
- CHECKSUM functions, 144
- CHNF$_DESC Object Type, 23
- CHNF$_RDESC Object Type, 23
- CHNF$_RDESC_ARRAY Object Type, 23
- CHNF$_REG_INFO Object Type, 23
- CHNF$_TDESC Object Type, 23
- CHNF$_TDESC_ARRAY Object (Array) Type, 23
- CHOOSE_DATE procedure, 148
- CITE function
-
- of HTF package, 134
- CITE procedure
-
- of HTP package, 139
- CLEANUP_GATEWAY Procedure, 58
- CLEANUP_INSTANTIATION_SETUP procedure, 106
- CLEAR_ALL_CONTEXT Procedure, 96
- CLEAR_CONTEXT Procedure, 96
- CLEAR_COOKIES procedure, 168
- CLEAR_EXPRSET_STATS procedure, 39
- CLEAR_IDENTIFIER Procedure, 96
- CLEAR_PENDING_AREA procedure, 85
- CLEAR_PLSQL_TRACE procedure, 110
- CLEAR_USED procedure, 66
- CLEARKEYCOLUMNLIST procedure, 128, 130
- CLEARUPDATECOLUMNLIST procedure, 128, 130
- CLIENT_ID_STAT_DISABLE procedure, 60
- CLIENT_ID_STAT_ENABLE procedure, 60
- CLIENT_ID_TRACE_DISABLE procedure, 60
- CLIENT_ID_TRACE_ENABLE procedure, 60
- clipping
-
- see trimming, 26
- CLOB2FILE procedure, 132
- CLONE_SIMPLE_TABLESPACE procedure, 109
- CLONE_TABLESPACES procedure, 109
- CLONENODE function, 124
- CLOSE Procedure, 52
- CLOSE_ALL_CONNECTIONS procedure, 178
- CLOSE_CONNECTION procedure, 178
- CLOSE_CURSOR Procedure, 45
- CLOSE_CURSOR procedure, 100
- CLOSE_ITERATOR procedure, 91
- CLOSE_PERSISTENT_CONN procedure, 168
- CLOSE_PERSISTENT_CONNS procedure, 168
- CLOSECONTEXT procedure, 125, 127, 128, 130
- CODE function
-
- of HTF package, 134
- CODE procedure
-
- of HTP package, 139
- collections
-
- table items, 100, 100
- column masking for VPD, 89
- COLUMN_VALUE procedure, 100
- COLUMN_VALUE_LONG procedure, 100
- column-level VPD, 89
- COMMA_TO_TABLE procedures, 116
- COMMAND function and procedure, 177
- COMMAND_REPLIES function, 177
- COMMENT function
-
- of HTF package, 134
- COMMENT procedure
-
- of HTP package, 139
- COMMIT procedure, 111
- COMMIT_COMMENT procedure, 111
- COMMIT_FORCE procedure, 111
- COMPARE function, 174
- COMPARE Functions, 52
- COMPARE_OLD_VALUES procedure, 15
- COMPATIBLE_10_1 function, 105, 188
- COMPATIBLE_10_2 function, 105, 188
- COMPATIBLE_9_2 function, 105, 188
- COMPILE_FROM_REMOTE procedure, 51
- COMPILE_SCHEMA procedure, 116
- COMPILESCHEMA procedure, 129
- COMPUTE_CONFUSION_MATRIX procedure, 25
- COMPUTE_LIFT procedure, 25
- COMPUTE_ROC procedure, 25
- CONCAT function, 174
- CONFIGUREAUTOSYNC procedure, 122
- conflicts
-
- detection
-
- stopping, 15
- CONNECTION record type, 177
- constants
-
- DBMS_DATA_MINING, 25
- DBMS_MGWMSG package, 59
- CONSUME_EVENT procedure, 88
- CONSUME_PRIM_EVENT procedure, 88
- CONTINUE function, 30
- CONVERT function, 53, 125, 174
- CONVERT_ANYDATA_TO_LCR_DDL function, 105
- CONVERT_ANYDATA_TO_LCR_ROW function, 105
- CONVERT_LCR_TO_XML function, 105
- CONVERT_LONG_TO_LOB_CHUNK member procedure, 188
- CONVERT_RAW_VALUE procedures, 103
- CONVERT_RAW_VALUE_NVARCHAR procedure, 103
- CONVERT_RAW_VALUE_ROWID procedure, 103
- CONVERT_XML_TO_LCR function, 105
- CONVERTTOBLOB procedure, 52
- CONVERTTOCLOB procedure, 52
- COPIES function, 174
- COPY Procedures, 52
- COPY_ATTRIBUTE_SET procedure, 39
- COPY_FILE procedure, 42
- COPY_TABLE_DEPENDENTS procedure, 77
- COPYEVOLVE procedure, 129
- CREATE PACKAGE BODY command, 1
- CREATE PACKAGE command, 1
- CREATE_ALTER_TYPE_ERROR_TABLE procedure, 116
- CREATE_APPLY procedure, 15
- CREATE_ATTRIBUTE_SET procedure, 39
- CREATE_BASELINE function and procedure, 118
- CREATE_BIN_CAT procedure, 26
- CREATE_BIN_NUM procedure, 26
- CREATE_CALL function, 165
- CREATE_CAPTURE procedure
-
- capture process
-
- creating, 20
- CREATE_CLIP procedure, 26
- CREATE_CONSUMER_GROUP procedure, 85
- CREATE_DAD Procedure, 37
- CREATE_EDIT_TABLES procedure, 67
- CREATE_ERROR_LOG Procedure, 38
- CREATE_EVALUATION_CONTEXT procedure, 92
- CREATE_EVENT_STRUCTURE procedure, 88
- CREATE_FILE Procedure, 12
- CREATE_FILE_GROUP procedure, 41
- CREATE_INDEX_COST procedure, 98
- CREATE_MISS_CAT Procedure, 26
- CREATE_MISS_CAT procedure, 26
- CREATE_MISS_NUM Procedure, 26
- CREATE_MISS_NUM procedure, 26
- CREATE_MODEL procedure, 25
- CREATE_MSGSYSTEM_LINK Procedure for TIB/Rendezvous, 58
- CREATE_MSGSYSTEM_LINK Procedure for WebSphere MQ, 58
- CREATE_NORM_LIN procedure, 26
- CREATE_OBJECT Procedure, 12
- CREATE_OBJECT_DEPENDENCY procedure, 15
- CREATE_OUTLINE procedure, 66
- CREATE_PENDING_AREA procedure, 85
- CREATE_PIPE function, 70
- CREATE_PLAN procedure, 85
- CREATE_PLAN_DIRECTIVE procedure, 85
- CREATE_PROPAGATION procedure, 74
- CREATE_RULE procedure, 92
- CREATE_RULE_CLASS procedure, 88
- CREATE_RULE_SET procedure, 92
- CREATE_SERVICE function, 165
- CREATE_SERVICE procedure, 95
- CREATE_SIMPLE_PLAN procedure, 85
- CREATE_SNAPSHOT function and procedure, 118
- CREATE_SQLSET procedure, 101
- CREATE_SQLWKLD Procedure, 12
- CREATE_STAT_TABLE procedure, 103
- CREATE_STGTAB_SQLPROF Procedure, 101
- CREATE_STGTAB_SQSET Procedure, 101
- CREATE_TABLE_COST procedures, 98
- CREATE_TASK Procedures, 12
- CREATE_TRANSFORMATION procedure, 112
- CREATE_TUNING_TASK functions, 101
- CREATE_VERSION procedure, 41
- CREATE_WRAPPED Procedure, 29
- CREATEATTRIBUTE function, 124
- CREATECDATASECTION function, 124
- CREATECOMMENT function, 124
- CREATEDATASTOREPREF procedure, 122
- CREATEDOCUMENT function, 124
- CREATEDOCUMENTFRAGMENT function, 124
- CREATEELEMENT function, 124
- CREATEENTITYREFERENCE function, 124
- CREATEFILTERPREF procedure, 122
- CREATEFOLDER function, 120
- CREATEINDEX procedure, 122
- CREATELEXERPREF procedure, 122
- CREATENONSCHEMABASEDXML function, 197
- CREATEOIDPATH function, 120
- CREATEPREFERENCES procedure, 122
- CREATEPROCESSINGINSTRUCTION function, 124
- CREATERESOURCE function, 120
- CREATESCHEMABASEDXML function, 197
- CREATESECTIONGROUPPREF procedure, 122
- CREATESTOPLISTPREF procedure, 122
- CREATESTORAGEPREF procedure, 122
- CREATETEMPORARY Procedures, 52
- CREATETEXTNODE function, 124
- CREATEURI function, 185, 185, 185
- CREATEWORLDLISTPREF procedure, 122
- CREATEXML function, 197
- creating
-
- packages, 1
- CTX_ADM package documentation, 2
- CTX_CLS package documentation, 3
- CTX_DDL package documentation, 4
- CTX_DOC package documentation, 5
- CTX_OUTPUT package documentation, 6
- CTX_QUERY package documentation, 7
- CTX_REPORT package documentation, 8
- CTX_THES package documentation, 9
- CTX_ULEXER package documentation, 10
- CURRENT_INSTANCE function, 116
- cursors
-
- DBMS_SQL package, 100
D
- data dictionary
-
- removing Streams information, 106
- DATA function and procedure, 177
- data mining
-
- automated, 72
- overview, 25
- transformations, 26
- data types
-
- table of, 25, 26
- DATA_BLOCK_ADDRESS_BLOCK function, 116
- DATA_BLOCK_ADDRESS_FILE function, 116
- database
-
- locking
-
- OWA_OPT_LOCK package, 144
- database tables
-
- creating for DBMS_TRACE, 110
- DATABASE_TRACE_DISABLE Procedure, 60
- DATABASE_TRACE_ENABLE Procedure, 60
- datatypes
-
- DBMS_DESCRIBE, 34
- PL/SQL
-
- numeric codes for, 34
- DB_CONNECT_INFO Procedure, 58
- DB_VERSION procedure, 116
- DBA privileges
-
- for DBMS_LOGSTDBY packages, 56
- DBA privileges for the DBMS_LOGSTDBY package, 56
- DBMS, 124
- DBMS_ALERT package, 13
- DBMS_APPLICATION_INFO package, 14
- DBMS_APPLY_ADM package, 15
- DBMS_AQADM Constants, 17
- DBMS_AQELM package, 18
- DBMS_AQIN package, 19
- DBMS_CAPTURE package, 184
- DBMS_CAPTURE_ADM package, 20
- DBMS_CDC_PUBLISH package, 21
-
- ALTER_AUTOLOG_CHANGE_SOURCE procedure, 21
- ALTER_CHANGE_SET procedure, 21
- ALTER_CHANGE_TABLE procedure, 21
- ALTER_HOTLOG_CHANGE_SOURCE procedure, 21
- CREATE_AUTOLOG_CHANGE_SOURCE procedure, 21
- CREATE_CHANGE_SET procedure, 21
- CREATE_CHANGE_TABLE procedure, 21
- CREATE_HOTLOG_CHANGE_SOURCE procedure, 21
- DROP_CHANGE_SET procedure, 21
- DROP_CHANGE_SOURCE procedure, 21
- DROP_CHANGE_TABLE procedure, 21, 21
- DROP_SUBSCRIPTION procedure, 21
- PURGE procedure, 21
- PURGE_CHANGE_SET procedure, 21
- PURGE_CHANGE_TABLE procedure, 21
- DBMS_CDC_SUBSCRIBE package, 22
-
- ACTIVATE_SUB SCRIPTION procedure, 22
- CREATE_SUBSCRIPTION procedure, 22, 22
- DROP_SUBSCRIBER_VIEW procedure, 22
- DROP_SUBSCRIPTION procedure, 22
- EXTEND_WINDOW procedure, 22
- GET_SUBSCRIPTION_HANDLE procedure, 22
- PREPARE_SUBSCRIBER_VIEW procedure, 22
- PURGE_WINDOW procedure, 22
- SUBSCRIBE procedure, 22
- DBMS_CHANGE_NOTIFICATION package, 23
- DBMS_DATA_MINING
-
- constants, 25
- data types, 25
- introduction, 25
- package, 25
- subprograms, 25
- user views, 25
- DBMS_DATA_MINING_TRANSFORM
-
- introduction, 26
- package, 26
- subprograms, 26
- DBMS_DATAPUMP Package
-
- GET_DUMPFILE_INFO procedure, 27
- WAIT_FOR_JOB procedure, 27
- DBMS_DATAPUMP package, 27
-
- ADD_FILE procedure, 27
- ATTACH function, 27
- DATA_FILTER procedure, 27
- DETACH procedure, 27
- GET_STATUS procedure, 27
- LOG_ENTRY procedure, 27
- METADATA_FILTER procedure, 27
- METADATA_REMAP procedure, 27
- METADATA_TRANSFORM procedure, 27
- OPEN function, 27
- roles used by, 27
- SET_PARALLEL procedure, 27
- SET_PARAMETER procedure, 27
- START_JOB procedure, 27
- STOP_JOB procedure, 27
- types used by, 27
- DBMS_DB_VERSION package, 28
- DBMS_DDL package, 29
- DBMS_DEBUG package, 30
- DBMS_DEFER package documentation, 31
- DBMS_DEFER_QUERY package documentation, 32
- DBMS_DEFER_SYS package documentation, 33
- DBMS_DESCRIBE package, 34
- DBMS_DIMENSION package, 35
- DBMS_DISTRIBUTED_TRUST_ADMIN package, 36
- DBMS_EPG package, 37, 37
- DBMS_EXPFIL package, 39
-
- ADD_ELEMENTARY_ATTRIBUTE, 39
- ADD_FUNCTIONS, 39
- ASSIGN_ATTRIBUTE_SET, 39
- BUILD_EXCEPTIONS_TABLE, 39
- CLEAR_EXPRSET_STATS, 39
- COPY_ATTRIBUTE_SET, 39
- CREATE_ATTRIBUTE_SET, 39
- DEFAULT_INDEX_PARAMETERS, 39
- DEFAULT_XPINDEX_PARAMETERS, 39
- DEFRAG_INDEX, 39
- DROP_ATTRIBUTE_SET, 39
- GET_EXPRSET_STATS, 39
- GRANT_PRIVILEGE, 39
- INDEX_PARAMETERS, 39
- MODIFY_OPERATOR_LIST, 39
- REVOKE_PRIVILEGE, 39
- UNASSIGN_ATTRIBUTE_SET, 39
- VALIDATE_EXPRESSIONS, 39
- XPINDEX_PARAMETERS, 39
- DBMS_FGA package, 40
- DBMS_FILE_GROUP package, 41
-
- constants, 41
- DBMS_FILE_TRANSFER package, 42
- DBMS_FLASHBACK package, 43
- DBMS_FREQUENT_ITEMSET package, 44
- DBMS_HS_PASSTHROUGH package, 45
- DBMS_IOT package, 46
- DBMS_JAVA package documentation, 47
- DBMS_JOB package, 48
- DBMS_LDAP package documentation, 49
- DBMS_LDAP_UTL package documentation, 50
- DBMS_LIBCACHE package, 51
- DBMS_LOB package, 52
- DBMS_LOCK package, 53
- DBMS_LOGMNR package, 54
-
- ADD_LOGFILE procedure, 54
- COLUMN_PRESENT function, 54
- END_LOGMNR procedure, 54
- MINE_VALUE function, 54
- REMOVE_LOGFILE procedure, 54
- START_LOGMNR procedure, 54
- DBMS_LOGMNR_CDC_PUBLISH
-
- See DBMS_CDC_PUBLISH, 21
- DBMS_LOGMNR_CDC_SUBSCRIBE
-
- See DBMS_CDC_SUBSCRIBE, 22
- DBMS_LOGMNR_D package, 55
-
- BUILD procedure, 55
- SET_TABLESPACE procedure, 55
- DBMS_LOGSTDBY package, 56
-
- APPLY_SET procedure, 56
- APPLY_UNSET procedure, 56
- BUILD procedure, 56
- case sensitivity, 56
- deprecated subprograms, 56
- INSTANTIATE_TABLE procedure, 56
- operational notes, 56
- overview of managing SQL Apply, 56
- PREPARE_FOR_NEW_PRIMARY procedure, 56
- privileges and security, 56
- SKIP procedure, 56
- SKIP_ERROR procedure, 56
- SKIP_TRANSACTION procedure, 56
- UNSKIP procedure, 56
- UNSKIP_ERROR procedure, 56
- UNSKIP_TRANSACTION procedure, 56
- using, 56
- DBMS_METADATA package, 57
-
- ADD_TRANSFORM function, 57
- CLOSE procedure, 57
- CONVERT functions and procedures, 57
- GET_DDL function, 57
- GET_QUERY function, 57
- GET_XML function, 57
- OPEN function, 57
- OPENW function, 57
- PUT function, 57
- security, 57
- SET_COUNT procedure, 57
- SET_FILTER procedure, 57
- SET_PARSE_ITEM procedure, 57
- SET_REMAP_PARAM procedure, 57
- SET_TRANSFORM_PARAM procedure, 57
- DBMS_MGWADM package
-
- summary of subprograms, 58
- DBMS_MGWMSG package
-
- constants, 59
- summary of subprograms, 59
- DBMS_MONITOR package
-
- stastics tracing and gathering
-
- DBMS_MONITOR package, 60
- DBMS_MVIEW package
-
- BEGIN_TABLE_REORGANIZATION procedure, 61
- END_TABLE_REORGANIZATION procedure, 61
- EXPLAIN_MVIEW procedure, 61
- EXPLAIN_REWRITE procedure, 61
- I_AM_A_REFRESH function, 61
- PMARKER function, 61
- PURGE_DIRECT_LOAD_LOG procedure, 61
- PURGE_LOG procedure, 61
- PURGE_MVIEW_FROM_LOG procedure, 61
- REFRESH procedure, 61
- REFRESH_ALL_MVIEWS procedure, 61
- REFRESH_DEPENDENT procedure, 61
- REGISTER_MVIEW procedure, 61
- UNREGISTER_MVIEW procedure, 61
- DBMS_OBFUSCATION_TOOLKIT package, 62
- DBMS_ODCI package, 63
-
- ESTIMATE_CPU_UNITS function, 63
- methods, 63
- DBMS_OFFLINE_OG package documentation, 64
- DBMS_OLAP package, 65
- DBMS_OUTLN package, 66
- DBMS_OUTLN_EDIT package, 67
- DBMS_OUTPUT package, 68
- DBMS_PCLXUTIL package, 69
- DBMS_PIPE package, 70
- DBMS_PREDICTIVE_ANALYTICS package, 72
- DBMS_PREPROCESSOR package, 71
- DBMS_PROFILER package, 73
- DBMS_PROPAGATION_ADM package, 74
- DBMS_RANDOM package, 75
- DBMS_RECTIFIER_DIFF package documentation, 76
- DBMS_REDEFINITION package, 77
- DBMS_REFRESH package documentation, 78
- DBMS_REPAIR package, 79
- DBMS_REPCAT package documentation, 80
- DBMS_REPCAT_ADMIN package documentation, 81
- DBMS_REPCAT_INSTANTIATE package documentation, 82
- DBMS_REPCAT_RGT package documentation, 83
- DBMS_REPUTIL package documentation, 84
- DBMS_RESOURCE_MANAGER package, 85
- DBMS_RESOURCE_MANAGER_PRIVS package, 86
- DBMS_RESUMABLE package, 87
- DBMS_RLMGR package, 88
-
- ADD_ELEMENTARY_ATTRIBUTE, 88
- ADD_EVENT, 88
- ADD_FUNCTIONS, 88
- ADD_RULE, 88
- CONSUME_EVENT, 88
- CONSUME_PRIM_EVENT, 88
- CREATE_EVENT_STRUCTURE, 88
- CREATE_RULE_CLASS, 88
- DELETE_RULE, 88
- DROP_EVENT_STRUCTURE, 88
- DROP_RULE_CLASS, 88
- GRANT_PRIVILEGE, 88
- PROCESS_RULES, 88
- RESET_SESSION, 88
- REVOKE_PRIVILEGE, 88
- DBMS_RLS package, 89
- DBMS_RLS.ADD_GROUPED_POLICY parameters
-
- enable, 89
- function_schema, 89
- long_predicate, 89
- object_name, 89
- object_schema, 89
- policy_function, 89
- policy_group, 89
- policy_name, 89
- policy_type, 89
- sec_relevant_cols, 89
- statement_types, 89
- static_policy, 89
- update_check, 89
- DBMS_RLS.ADD_POLICY parameters
-
- enable, 89
- function_schema, 89
- long_predicate, 89
- object_name, 89
- object_schema, 89
- policy_function, 89
- policy_name, 89
- policy_type, 89
- sec_relevant_cols, 89
- sec_relevant_cols_opt, 89
- statement_types, 89
- static_policy, 89
- update_check, 89
- DBMS_RLS.ADD_POLICY policy types
-
- CONTEXT_SENSITIVE, 89
- DYNAMIC, 89
- SHARED_CONTEXT_SENSITIVE, 89
- SHARED_STATIC, 89
- STATIC, 89
- DBMS_RLS.ADD_POLICY_CONTEXT parameters
-
- attribute, 89
- namespace, 89
- object_name, 89
- object_schema, 89
- DBMS_RLS.CREATE_POLICY_GROUP parameters
-
- object_name, 89
- object_schema, 89
- policy_group, 89
- DBMS_RLS.DELETE_POLICY_GROUP parameters
-
- object_name, 89
- object_schema, 89
- policy_group, 89
- DBMS_RLS.DISABLE_GROUPED_POLICY parameters
-
- group_name, 89
- object_name, 89
- object_schema, 89
- policy_name, 89
- DBMS_RLS.DROP_GROUPED_POLICY parameters
-
- object_name, 89, 89
- object_schema, 89, 89
- policy_group, 89
- policy_name, 89, 89
- DBMS_RLS.DROP_POLICY_CONTEXT parameters
-
- attribute, 89
- namespace, 89
- object_name, 89
- object_schema, 89
- DBMS_RLS.ENABLE_GROUPED_POLICY parameters
-
- enable, 89
- group_name, 89
- object_name, 89
- object_schema, 89
- policy_name, 89
- DBMS_RLS.ENABLE_POLICY parameters
-
- enable, 89
- object_name, 89
- object_schema, 89
- policy_name, 89
- DBMS_RLS.REFRESH_GROUPED_POLICY parameters
-
- group_name, 89
- object_name, 89
- object_schema, 89
- policy_name, 89
- DBMS_RLS.REFRESH_POLICY parameters
-
- object_name, 89
- object_schema, 89
- policy_name, 89
- DBMS_ROWID package, 90
- DBMS_RULE package, 91
- DBMS_RULE_ADM package, 92
- DBMS_SCHEDULER package, 93
- DBMS_SERVER_ALERT package, 94
- DBMS_SERVICE package, 95
- DBMS_SESSION package, 96
- DBMS_SHARED_POOL package, 97
- DBMS_SPACE package, 98
- DBMS_SPACE_ADMIN package, 99
- DBMS_SQL package, 100
- DBMS_SQLTUNE package, 101
- DBMS_STAT_FUNCS package, 102
- DBMS_STATS package, 103
- DBMS_STORAGE_MAP package, 104
- DBMS_STREAMS package, 105
- DBMS_STREAMS_ADM package, 106
-
- deprecated subprograms, 106
- DBMS_STREAMS_AUTH package, 107
- DBMS_STREAMS_MESSAGING package, 108
- DBMS_STREAMS_TABLESPACE package, 109
- DBMS_TDB package, 113
- DBMS_TDB.CHECK_DB procedure, 113, 113
- DBMS_TRACE package, 110
- DBMS_TRANSACTION package, 111
- DBMS_TRANSFORM package, 112
- DBMS_TTS package, 114
- DBMS_TYPES package, 115
- DBMS_UTILITY package, 116
- DBMS_WARNING package, 117
- DBMS_WM package documentation, 119
- DBMS_WORKLOAD_REPOSITORY package, 118
- DBMS_XBD_VERSION package, 121
- DBMS_XDB Constants, 120
- DBMS_XDB Overview, 120
- DBMS_XDB package, 120
-
- ACLCHECKPRIVILEGES function, 120
- CFG_GET function, 120
- CFG_REFRESH procedure, 120
- CFG_UPDATE procedure, 120
- CHECKPRIVILEGES function, 120
- CONFIGUREAUTOSYNC procedure, 122
- constants, 120
- ConText synchronization settings, 122
- CREATEDATASTOREPREF procedure, 122
- CREATEFILTERPREF procedure, 122
- CREATEFOLDER function, 120
- CREATEINDEX procedure, 122
- CREATELEXERPREF procedure, 122
- CREATEOIDPATH function, 120
- CREATEPREFERENCES procedure, 122
- CREATERESOURCE function, 120
- CREATESECTIONGROUPPREF procedure, 122
- CREATESTOPLISTPREF procedure, 122
- CREATESTORAGEPREF procedure, 122
- CREATEWORLDLISTPREF procedure, 122
- DELETERESOURCE procedure, 120
- DROPPREFERENCES procedure, 122
- EXISTSRESOURCE function, 120
- filtering settings, 122
- general indexing settings, 122
- GETACLDOCUMENT function, 120
- GETLOCKTOKEN procedure, 120
- GETRESOID function, 120
- GETXDB_TABLESPACE function, 120
- LINK procedure, 120
- LOCKRESOURCE function, 120
- methods, 120, 122
- miscellaneous settings, 122
- MOVEXDB_TABLESPACE procedure, 120
- other index preference settings, 122
- REBUILDHIERARCHICALINDEX procedure, 120
- RENAMERESOURCE procedure, 120
- sectioning and section group settings, 122
- SETACL procedure, 120
- stoplist settings, 122
- SYNC settings, 122
- UNLOCKRESOURCE function, 120
- DBMS_XDB_VERSION package
-
- CHECKIN function, 121
- CHECKOUT procedure, 121
- GETCONTENTSBLOBBYRESID function, 121
- GETCONTENTSCLOBBYRESID function, 121
- GETCONTENTSXMLBYRESID function, 121
- GETPREDECESSORS function, 121
- GETPREDSBYRESID function, 121
- GETRESOURCEBYRESID function, 121
- GETSUCCESSORS function, 121
- GETSUCCSBYRESID function, 121
- MAKEVERSIONED function, 121
- UNCHECKOUT function, 121
- DBMS_XDBZ package
-
- DISABLE_HIERARCHY procedure, 123
- ENABLE_HIERARCHY procedure, 123
- GET_ACLOID function, 123
- GET_USERID function, 123
- IS_HIERARCHY_ENABLED function, 123
- PURGELDAPCACHE function, 123
- DBMS_XMLDOM Constants, 124
- DBMS_XMLDOM package, 124
-
- APPENDDATA procedure, 124
- CREATEATTRIBUTE function, 124
- CREATECDATASECTION function, 124
- CREATECOMMENT function, 124
- CREATEDOCUMENT function, 124
- CREATEDOCUMENTFRAGMENT, 124
- CREATEELEMENT function, 124
- CREATEENTITYREFERENCE function, 124
- CREATEPROCESSINGINSTRUCTION function, 124
- CREATETEXTNODE function, 124
- DELETEDATA procedure, 124
- description, 124
- exceptions, 124
- FINDENTITY function, 124
- FINDNOTATION function, 124
- FREEDOCFRAG procedure, 124
- FREEDOCUMENT procedure, 124
- GETATTRIBUTE function, 124
- GETATTRIBUTENODE function, 124
- GETBUBLICID function, 124
- GETCHARSET function, 124
- GETCHILDRENBYTAGNAME function, 124
- GETDATA function, 124
- GETDOCTYPE function, 124
- GETDOCUMENTELEMENT function, 124
- GETELEMENTSBYTAGNAME function, 124, 124
- GETENTITIES function, 124
- GETEXPANDEDNAME function, 124, 124
- GETIMPLEMENTATION function, 124
- GETLENGTH function, 124, 124, 124
- GETNAME function, 124, 124
- GETNAMEDITEM function, 124
- GETNAMESPACE function, 124, 124
- GETNAMESPACE procedure, 124
- GETNEXTSIBLING function, 124
- GETNODENAME function, 124
- GETNODETYPE function, 124
- GETNODEVALUE function, 124
- GETNOTATIONNAME function, 124
- GETNOTATIONS function, 124
- GETOWNERDOCUMENT function, 124
- GETOWNERELEMENT function, 124
- GETPARENTNODE function, 124
- GETPREFIX function, 124
- GETPREVIOUSSIBLING function, 124
- GETPUBLICID function, 124, 124
- GETQUALIFIEDNAME function, 124, 124
- GETSCHEMANODE function, 124
- GETSPECIFIED function, 124
- GETSTANDALONE function, 124
- GETSYSTEMID function, 124, 124, 124
- GETTAGNAME function, 124
- GETTARGET function, 124
- GETVALUE function, 124
- GETVERSION function, 124
- GETXMLTYPE function, 124
- HASATTRIBUTE function, 124
- HASATTRIBUTES function, 124
- HASCHILDNODES function, 124
- HASFEATURE function, 124
- IMPORTNODE function, 124
- INSERTBEFORE function, 124
- INSERTDATA procedure, 124
- ISNULL function, 124
- MAKEATTR function, 124
- MAKECDATASECTION function, 124
- MAKECHARACTERDATA function, 124
- MAKECOMMENT function, 124
- MAKEDOCUMENT function, 124
- MAKEDOCUMENTFRAGMENT function, 124
- MAKEDOCUMENTTYPE function, 124
- MAKEELEMENT function, 124
- MAKEENTITY function, 124
- MAKEENTITYREFERENCE function, 124
- MAKENODE function, 124, 124, 124, 124
- MAKENOTATION function, 124
- MAKEPROCESSINGINSTRUCTION function, 124
- MAKETEXT function, 124
- methods
-
- APPENDCHILD function, 124
- APPENDDATA procedure, 124
- CLONENODE function, 124
- CREATEATTRIBUTE function, 124
- CREATECDATASECTION function, 124
- CREATECOMMENT function, 124
- CREATEDOCUMENT function, 124
- CREATEDOCUMENTFRAGMENT function, 124
- CREATEELEMENT function, 124
- CREATEENTITYREFERENCE function, 124
- CREATEPROCESSINGINSTRUCTION function, 124
- CREATETEXTNODE function, 124
- DELETEDATA procedure, 124
- DOMAttr interface, 124
- DOMCDataSection interface, 124
- DOMCharacterData interface, 124
- DOMComment interface, 124
- DOMDocument interface, 124
- DOMDocumentFragment interface, 124, 124
- DOMDocumentType interface, 124, 124
- DOMElement interface, 124, 124
- DOMEntity interface, 124, 124
- DOMEntityReference interface, 124
- DOMImplementation interface, 124
- DOMNamedNodeMap interface, 124
- DOMNode, 124, 124, 124, 124, 124, 124, 124, 124, 124
- DOMNodeList interface, 124
- DOMNotation interface, 124
- DOMProcessingInstruction interface, 124
- DOMText interface, 124, 124
- FINDENTITY function, 124
- FINDNOTATION function, 124
- FREEDOCFRAG procedure, 124
- FREEDOCUMENT procedure, 124
- FREENODE procedure, 124
- GETATTRIBUTE function, 124
- GETATTRIBUTENODE function, 124
- GETATTRIBUTES function, 124
- GETBUBLICID function, 124
- GETCHARSET function, 124
- GETCHILDNODES function, 124
- GETCHILDRENBYTAGNAME function, 124
- GETDATA function, 124
- GETDOCTYPE function, 124
- GETDOCUMENTELEMENT function, 124
- GETELEMENTSBYTAGNAME function, 124, 124
- GETENTITIES function, 124
- GETEXPANDEDNAME function, 124, 124
- GETEXPANDEDNAME procedure, 124
- GETFIRSTCHILD function, 124
- GETIMPLEMENTATION function, 124
- GETLASTCHILD function, 124
- GETLENGTH function, 124, 124, 124
- GETLOCALNAME procedure, 124
- GETNAME function, 124, 124
- GETNAMEDITEM function, 124
- GETNAMESPACE function, 124, 124
- GETNAMESPACE procedure, 124
- GETNEXTSIBLING function, 124
- GETNODENAME function, 124
- GETNODETYPE function, 124
- GETNODEVALUE function, 124
- GETNOTATIONNAME function, 124
- GETNOTATIONS function, 124
- GETOWNERDOCUMENT function, 124
- GETOWNERELEMENT function, 124
- GETPARENTNODE function, 124
- GETPREFIX function, 124
- GETPREVIOUSSIBLING function, 124
- GETPUBLICID function, 124, 124
- GETQUALIFIEDNAME function, 124, 124
- GETSCHEMANODE function, 124
- GETSPECIFIED function, 124
- GETSTANDALONE function, 124
- GETSYSTEMID function, 124, 124, 124
- GETTAGNAME function, 124
- GETTARGET function, 124
- GETVALUE function, 124
- GETVERSION function, 124
- GETXMLTYPE function, 124
- HASATTRIBUTE function, 124
- HASATTRIBUTES function, 124
- HASCHILDNODES function, 124
- HASFEATURE function, 124
- IMPORTNODE function, 124
- INSERTBEFORE function, 124
- INSERTDATA procedure, 124
- ISNULL function, 124
- MAKEATTR function, 124
- MAKECDATASECTION function, 124
- MAKECHARACTERDATA function, 124
- MAKECOMMENT function, 124
- MAKEDOCUMENT function, 124
- MAKEDOCUMENTFRAGMENT function, 124
- MAKEDOCUMENTTYPE function, 124
- MAKEELEMENT function, 124
- MAKEENTITY function, 124
- MAKEENTITYREFERENCE function, 124
- MAKENODE function, 124, 124, 124, 124
- MAKENOTATION function, 124
- MAKEPROCESSINGINSTRUCTION function, 124
- MAKETEXT function, 124
- NEWDOMDOCUMENT function, 124
- NORMALIZE procedure, 124
- REMOVEATTRIBUTE procedure, 124
- REMOVEATTRIBUTENODE function, 124
- REMOVENAMEDITEM function, 124
- REPLACECHILD function, 124
- REPLACEDATA procedure, 124
- RESOLVENAMESPACEPREFIX function, 124
- SETATTRIBUTE procedure, 124
- SETATTRIBUTENODE function, 124
- SETCHARSET procedure, 124
- SETDATA procedure, 124
- SETNAMEDITEM function, 124
- SETNODEVALUE procedure, 124
- SETPREFIX procedure, 124
- SETSTANDALONE procedure, 124
- SETVALUE procedure, 124
- SETVERSION procedure, 124
- SPLITTEXT function, 124
- SUBSTRINGDATA function, 124
- WRITETOBUFFER procedure, 124
- WRITETOCLOB procedure, 124
- WRITETOFILE procedure, 124
- NEWDOMDOCUMENT function, 124
- NORMALIZE procedure, 124
- REMOVEATTRIBUTE procedure, 124
- REMOVEATTRIBUTENODE function, 124
- REMOVENAMEDITEM function, 124
- REPLACECHILD function, 124
- REPLACEDATA procedure, 124
- RESOLVENAMESPACEPREFIX function, 124
- SETATTRIBUTE procedure, 124
- SETATTRIBUTENODE function, 124
- SETCHARSET procedure, 124
- SETDATA procedure, 124
- SETNAMEDITEM function, 124
- SETNODEVALUE procedure, 124
- SETPREFIX procedure, 124
- SETSTANDALONE procedure, 124
- SETVALUE procedure, 124
- SETVERSION procedure, 124
- SPLITTEXT function, 124
- SUBSTRINGDATA function, 124
- types, 124
- WRITETOBUFFER procedure, 124
- WRITETOCLOB procedure, 124
- WRITETOFILE procedure, 124
- DBMS_XMLGEN package, 125
-
- CLOSECONTEXT procedure, 125
- CONVERT function, 125
- GETNUMROWSPROCESSED function, 125
- GETXML function, 125
- GETXMLTYPE function, 125
- NEWCONTEXT function, 125
- RESTARTQUERY procedure, 125
- SETCONVERTSPECIALCHARS procedure, 125
- SETMAXROWS procedure, 125
- SETROWSETTAG procedure, 125
- SETROWTAG procedure, 125
- SETSKIPROWS procedure, 125
- USEITEMTAGSFORCOLL procedure, 125
- USENULLATTRIBUTEINDICATOR procedure, 125
- DBMS_XMLPARSER package, 126
-
- FREEPARSER procedure, 126
- GETDOCTYPE function, 126
- GETDOCUMENT function, 126
- GETRELEASEVERSION function, 126
- GETVALIDATIONMODE function, 126
- NEWPARSER function, 126
- PARSE function, 126, 126
- PARSE procedure, 126
- PARSEBUFFER procedure, 126
- PARSECLOB procedure, 126
- PARSEDTD procedure, 126
- PARSEDTDBUFFER procedure, 126
- PARSEDTDCLOB procedure, 126
- SETBASEDIR procedure, 126
- SETDOCTYPE procedure, 126
- SETERRORLOG procedure, 126
- SETPRESERVEWHITESPACE procedure, 126
- SETVALIDATIONMODE procedure, 126
- SHOWWARNINGS procedure, 126
- DBMS_XMLQUERY package, 127
-
- CLOSECONTEXT procedure, 127
- constants, 127
- GETDTD function, 127
- GETDTD procedure, 127
- GETEXCEPTIONCONTENT procedure, 127
- GETNUMROWSPROCESSED procedure, 127
- GETVERSION procedure, 127
- GETXML function, 127
- GETXML procedure, 127
- NEWCONTEXT function, 127
- PROPAGATEORIGINALEXCEPTION procedure, 127
- REMOVEXSLTPARAM procedure, 127
- SETBINDVALUE procedure, 127
- SETCOLLIDATTRNAME procedure, 127
- SETDATAHEADER procedure, 127
- SETDATEFORMAT procedure, 127
- SETENCODINGTAG procedure, 127
- SETERRORTAG procedure, 127
- SETMAXROWS procedure, 127
- SETMETAHEADER procedure, 127
- SETRAISEEXCEPTION procedure, 127
- SETRAISENOROWSEXCEPTION procedure, 127
- SETROWIDATTRNAME procedure, 127
- SETROWIDATTRVALUE procedure, 127
- SETROWSETTAG procedure, 127
- SETROWTAG procedure, 127
- SETSKIPROWS procedure, 127
- SETSQLTOXMLNAMEESCAPING procedure, 127
- SETSTYLESHEETHEADER procedure, 127
- SETTAGCASE procedure, 127
- SETXSLT procedure, 127
- SETXSLTPARAM procedure, 127
- types, 127
- USENULLATTRIBUTEINDICATOR procedure, 127
- USETYPEFORCOLLELEMTAG procedure, 127
- DBMS_XMLSAVE package, 128
-
- CLEARKEYCOLUMNLIST procedure, 128
- CLEARUPDATECOLUMNLIST procedure, 128
- CLOSECONTEXT procedure, 128
- constants, 128
- DELETEXML function, 128
- GETEXCEPTIONCONTENT procedure, 128
- INSERTXML function, 128
- NEWCONTEXT function, 128
- PROPAGATEORIGINALEXCEPTION procedure, 128
- REMOVEXSLTPARAM procedure, 128
- SETBATCHSIZE procedure, 128
- SETCOMMITBATCH procedure, 128
- SETDATEFORMAT procedure, 128
- SETIGNORECASE procedure, 128
- SETKEYCOLUMN procedure, 128
- SETPRESERVEWHITESPACE procedure, 128
- SETROWTAG procedure, 128
- SETSQLTOXMLNAMEESCAPING procedure, 128
- SETUPDATECOLUMN procedure, 128
- SETXSLT procedure, 128
- SETXSLTPARAM procedure, 128
- UPDATEXML function, 128
- DBMS_XMLSCHEMA Constants, 129
- DBMS_XMLSCHEMA package, 129
-
- COMPILESCHEMA procedure, 129
- COPYEVOLVE procedure, 129
- DELETESCHEMA procedure, 129
- GENERATEBEAN procedure, 129
- GENERATESCHEMA function, 129
- GENERATESCHEMAS function, 129
- REGISTERSCHEMA procedure, 129
- REGISTERURI procedure, 129
- DBMS_XMLSCHEMA Views, 129
- DBMS_XMLSTORE package, 130
-
- CLEARKEYCOLUMNLIST procedure, 130
- CLEARUPDATECOLUMNLIST procedure, 130
- CLOSECONTEXT procedure, 130
- DELETEXML function, 130
- INSERTXML function, 130
- NEWCONTEXT function, 130
- SETKEYCOLUMN procedure, 130
- SETROWTAG procedure, 130
- SETUPDATECOLUMN procedure, 130
- types, 130
- UPDATEXML function, 130
- DBMS_XPLAN package, 131
- DBMS_XSLPROCESSOR Package, 132, 132
- DBMS_XSLPROCESSOR package
-
- CLOB2FILE procedure, 132
- FREEPROCESSOR procedure, 132
- FREESTYLESHEET procedure, 132
- NEWPROCESSOR function, 132
- NEWSTYLESHEET function, 132
- PROCESSXSL function, 132
- READ2CLOB function, 132
- REMOVEPARAM procedure, 132
- RESETPARAMS procedure, 132
- SELECTNODES function, 132
- SELECTSINGLENODE function, 132
- SETERRORLOG procedure, 132
- SETPARAM procedure, 132
- SHOWWARNINGS procedure, 132
- TRANSFORMNODE function, 132
- VALUEOF procedure, 132
- DBMSOUTPUT_LINESARRAY Object Type, 68
- DBUriType, 185
- DBURITYPE function, 185
- DBUriType subtype, 185
-
- CREATEURI function, 185
- DBURITYPE function, 185
- GETBLOB function, 185
- GETCLOB function, 185
- GETCONTENTTYPE function, 185
- GETEXTERNALURL function, 185
- GETURL function, 185
- GETXML function, 185
- methods, 185
- DEAUTHORIZE_DAD Procedure, 37
- DEBUG_EXPTOC package, 133
- DEBUG_ON procedure, 30
- DECLARE_REWRITE_EQUIVALENCE Procedures, 11
- DEFAULT_INDEX_PARAMETERS procedure, 39
- DEFAULT_XPINDEX_PARAMETERS procedure, 39
- DEFINE_ARRAY procedure, 100
- DEFINE_COLUMN procedure, 100
- DEFINE_COLUMN_LONG procedure, 100
- DEFRAG_INDEX procedure, 39
- DELETE_ALL_ERRORS procedure, 15
- DELETE_BREAKPOINT function, 30
- DELETE_COLUMN member procedure, 188
- DELETE_COLUMN procedure, 106
- DELETE_COLUMN_STATS pocedure, 103
- DELETE_CONSUMER_GROUP procedure, 85
- DELETE_DAD_ATTRIBUTE Procedure, 37, 37
- DELETE_DATABASE_STATS procedure, 103
- DELETE_DICTIONARY_STATS procedure, 103
- DELETE_ERROR procedure, 15
- DELETE_FIXED_OBJECTS_STATS procedure, 103
- DELETE_INDEX_STATS procedure, 103
- DELETE_OBJECT procedure, 176
- DELETE_OER_BREAKPOINT function, 30
- DELETE_PLAN procedure, 85
- DELETE_PLAN_CASCADE procedure, 85
- DELETE_PLAN_DIRECTIVE procedure, 85
- DELETE_RULE procedure, 88
- DELETE_SCHEMA_STATS Procedure, 103
- DELETE_SERVICE procedure, 95
- DELETE_SQLSET procedure, 101
- DELETE_SQLWKLD Procedure, 12
- DELETE_SQLWKLD_REF Procedure, 12
- DELETE_SQLWKLD_STATEMENT Procedure, 12
- DELETE_SYSTEM_STATS procedure, 103
- DELETE_TABLE_STATS procedure, 103
- DELETE_TASK Procedure, 12
- DELETEDATA procedure, 124
- DELETERESOURCE procedure, 120
- DELETERESOURCEMETADATA Procedures, 120
- DELETESCHEMA procedure, 129
- DELETEXML function, 128, 130
- DEQUEUE procedure, 108
- DEQUEUE_ARRAY Function, 16
- DEQUEUE_OPTIONS_T Type, 184
- DEREGISTER Procedure, 23
- DESCRIBE_COLUMNS procedure, 100
- DESCRIBE_COLUMNS2 procedure, 100
- DESCRIBE_DIMENSION procedure, 35
- DESCRIBE_PROCEDURE procedure, 34
- DESDecrypt procedure, 62, 62
- DESEncrypt procedure, 62
- DETACH_SESSION procedure, 30
- DETACH_SIMPLE_TABLESPACE procedure, 109
- DETACH_TABLESPACES procedure, 109
- DFN function
-
- of HTF package, 134
- DFN procedure
-
- of HTP package, 139
- DIRECTORY_OBJECT_SET type, 109
- DIRLISTCLOSE function
-
- of HTF package, 134
- DIRLISTCLOSE procedure
-
- of HTP package, 139
- DIRLISTOPEN function
-
- of HTF package, 134
- DIRLISTOPEN procedure
-
- of HTP package, 139
- DISABLE procedure
-
- of DBMS_FLASHBACK package, 43
- of DBMS_OUTPUT package, 68
- of OWA_CACHE package, 140
- DISABLE_BREAKPOINT function, 30
- DISABLE_HIERARCHY procedure, 123
- DISABLE_PROPAGATION_SCHEDULE Procedure, 58
- DISCONNECT_SESSION procedure, 95
- DISPLAY function, 131
- DISPLAY_AWR function, 131
- DISPLAY_CURSOR function, 131
- DISPLAY_SQLSET Function, 131
- DIV function
-
- of HTF package, 134
- DIV procedure
-
- of HTP package, 139
- DLISTCLOSE function
-
- of HTF package, 134
- DLISTCLOSE procedure
-
- of HTP package, 139
- DLISTDEF function
-
- of HTF package, 134
- DLISTDEF procedure
-
- of HTP package, 139
- DLISTOPEN function
-
- of HTF package, 134
- DLISTOPEN procedure
-
- of HTP package, 139
- DLISTTERM function
-
- of HTF package, 134
- DLISTTERM procedure
-
- of HTP package, 139
- DOMAttr methods, 124
- DOMCDataSection methods, 124
- DOMCharacterData methods, 124
- DOMComment methods, 124
- DOMDocument methods, 124
- DOMDocumentType methods, 124, 124
- DOMEntity methods, 124
- DOMNamedNodeMap methods, 124
- DOMText methods, 124
- DOWNGRADE procedure, 114
- DOWNLOAD_FILE procedures, 180
- DROP_ALL function, 104
- DROP_APPLY procedure, 15
- DROP_ATTRIBUTE_SET procedure, 39
- DROP_BASELINE procedure, 118
- DROP_BY_CAT procedure, 66
- DROP_CAPTURE procedure
-
- capture process
-
- dropping, 20
- DROP_DAD Procedure, 37
- DROP_EDIT_TABLES procedure, 67
- DROP_EVALUATION_CONTEXT procedure, 92
- DROP_EVENT_STRUCTURE procedure, 88
- DROP_FILE function, 104
- DROP_FILE_GROUP procedure, 41
- DROP_MODEL procedure, 25
- DROP_OBJECT_DEPENDENCY procedure, 15
- DROP_PROPAGATION procedure, 74
- DROP_REWRITE_EQUIVALENCE Procedure, 11
- DROP_RULE procedure, 92
- DROP_RULE_CLASS procedure, 88
- DROP_RULE_SET procedure, 92
- DROP_SNAPSHOT_RANGE procedure, 118
- DROP_SQL_PROFILE procedure, 101
- DROP_SQLSETprocedure, 101
- DROP_STAT_TABLE procedure, 103
- DROP_TRANSFORMATION procedure, 112
- DROP_TUNING_TASK procedure, 101
- DROP_UNUSED procedure, 66
- DROP_VERSION procedure, 41
- DROPPREFERENCES procedure, 122
- DUMP_ORPHAN_KEYS procedure, 79
- dynamic SQL
-
- anonymous blocks and, 100
- DBMS_SQL functions, using, 100
- execution flow in, 100
E
- EHLO function and procedure, 177
- EM function
-
- of HTF package, 134
- EM procedure
-
- of HTP package, 139
- e-mail from PL/SQL (email), 178
- EMPHASIS function
-
- of HTF package, 134
- EMPHASIS procedure
-
- of HTP package, 139
- ENABLE procedure, 68
- ENABLE_AT_SYSTEM_CHANGE_NUMBER procedure, 43
- ENABLE_AT_TIME procedure, 43
- ENABLE_BREAKPOINT function, 30
- ENABLE_HIERARCHY procedure, 123
- ENABLE_PROPAGATION_SCHEDULE Procedure, 58
- END_REQUEST procedure, 168
- END_RESPONSE procedure, 168
- ENDCREATE member procedure
-
- of ANYDATA TYPE, 181
- of ANYDATASET TYPE, 182
- of ANYTYPE TYPE, 183
- ENQUEUE procedure, 108
- ENQUEUE_ARRAY Function, 16
- ENQUEUE_OPTIONS_T Type, 184
- ERASE Procedures, 52
- error queue
-
- deleting errors, 15, 15
- executing errors, 15, 15
- getting error messages, 15
- errors
-
- DBMS_DATA_MINING, 25
- ESCAPE function, 179
- ESCAPE_SC function
-
- of HTF package, 134
- ESCAPE_SC procedure
-
- of HTP package, 139
- ESCAPE_URL function
-
- of HTF package, 134
- ESCAPEURI function, 185
- ESTIMATE_CPU_UNITS function, 63
- ESTIMATE_MVIEW_SIZE Procedure, 61
- ETINSTANCE member function
-
- of ANYDATASET TYPE, 182
- EVALUATE procedure, 91
- EXACT_TEXT_SIGNATURES procedure, 66
- EXEC_DDL_STATEMENT procedure, 116
- EXECUTE function, 100
- EXECUTE member procedure, 188, 188
- EXECUTE procedure, 30
- EXECUTE_ALL_ERRORS procedure, 15
- EXECUTE_AND_FETCH function, 100
- EXECUTE_ERROR procedure, 15
- EXECUTE_IMMEDIATE Procedure, 45
- EXECUTE_NON_QUERY Function, 45
- EXECUTE_TASK Procedure, 12
- EXECUTE_TUNING_TASK procedure, 101
- execution flow
-
- in dynamic SQL, 100
- EXF$ATTRIBUTE object type, 186
- EXF$ATTRIBUTE_LIST object type, 186
- EXF$INDEXOPER object type, 186
- EXF$TABLE_ALIAS object type, 186
- EXF$XPATH_TAG object type, 186
- EXF$XPATH_TAGS object type, 186
- EXISTSNODE function, 197
- EXISTSRESOURCE function, 120
- EXPAND_MESSAGE function, 94
- EXPLAIN procedure, 72
- EXPONENTIAL_DIST_FIT procedure, 102
- EXPORT_COLUMN_STATS procedure, 103
- EXPORT_DATABASE_STATS procedure, 103
- EXPORT_DICTIONARY_STATS procedure, 103
- EXPORT_FIXED_OBJECTS_STATS procedure, 103
- EXPORT_INDEX_STATS procedure, 103
- EXPORT_MODEL procedure, 25
- EXPORT_SCHEMA_STATS procedure, 103
- EXPORT_SYSTEM_STATS procedure, 103
- EXPORT_TABLE_STATS procedure, 103
- Expression Filter object types, 186
- extend window
-
- to create a new view, 22
- EXTRACT function, 197
F
- FCLOSE procedure, 167
- FCLOSE_ALL procedure, 167
- FCOPY procedure, 167
- features, new, Preface
- FETCH_ROW Function, 45
- FETCH_ROWS function, 100
- FFLUSH procedure, 167
- FGETATTR procedure, 167
- FGETPOS function, 167
- FI_HORIZONTAL function, 44
- FI_TRANSACTIONAL function, 44
- file groups, 41
-
- adding files, 41
- altering, 41
- altering files, 41
- altering versions, 41
- creating, 41
- creating versions, 41
- dropping, 41
- dropping versions, 41
- granting object privileges, 41
- granting system privileges, 41
- purging, 41
- removing files, 41
- revoking object privileges, 41
- revoking system privileges, 41
- FILE type, 109
- FILE_SET type, 109
- FILECLOSE Procedure, 52
- FILECLOSEALL Procedure, 52
- FILEEXISTS Function, 52
- FILEGETNAME Procedure, 52
- FILEISOPEN Function, 52
- FILEOPEN Procedure, 52
- FINDENTITY function, 124
- FINDNOTATION function, 124
- fine-grained access control
-
- DBMS_RLS package, 89
- FINISH_REDEF_TABLE procedure, 77
- FIX_CORRUPT_BLOCKS procedure, 79
- FLUSH procedure, 178
- FLUSH_DATA function and procedure, 73
- FLUSH_DATABASE_MONITORING_INFO procedure, 103
- FONTCLOSE function
-
- of HTF package, 134
- FONTCLOSE procedure
-
- of HTP package, 139
- FONTOPEN function
-
- of HTF package, 134
- FONTOPEN procedure
-
- of HTP package, 139
- FOPEN function, 167
- FOPEN_NCHAR function, 167
- FORCE parameter
-
- and job-to-instance affinity, 48
- FORMAT_CALL_STACK Function, 116
- FORMAT_CELL function
-
- of HTF package, 134
- FORMAT_ERROR_BACKTRACE function, 116
- FORMAT_ERROR_STACK function, 116
- FORMCHECKBOX function
-
- of HTF package, 134
- FORMCHECKBOX procedure
-
- of HTP package, 139
- FORMCLOSE function
-
- of HTF package, 134, 134
- FORMCLOSE procedure
-
- of HTP package, 139
- FORMFILE function
-
- of HTF package, 134
- FORMFILE procedure
-
- of HTP package, 139, 139
- FORMHIDDEN function
-
- of HTF package, 134
- FORMHIDDEN procedure
-
- of HTP package, 139
- FORMIMAGE function
-
- of HTF package, 134
- FORMIMAGE procedure
-
- of HTP package, 139
- FORMOPEN function
-
- of HTF package, 134
- FORMOPEN procedure
-
- of HTP package, 139
- FORMPASSWORD function
-
- of HTF package, 134
- FORMPASSWORD procedure
-
- of HTP package, 139
- FORMRADIO function
-
- of HTF package, 134
- FORMRADIO procedure
-
- of HTP package, 139
- FORMRESET function
-
- of HTF package, 134
- FORMRESET procedure
-
- of HTP package, 139
- FORMSELECTCLOSE function
-
- of HTF package, 134
- FORMSELECTCLOSE procedure
-
- of HTP package, 139
- FORMSELECTOPEN function
-
- of HTF package, 134
- FORMSELECTOPEN procedure
-
- of HTP package, 139
- FORMSELECTOPTION function
-
- of HTF package, 134
- FORMSELECTOPTION procedure
-
- of HTP package, 139
- FORMSUBMIT function
-
- of HTF package, 134
- FORMSUBMIT procedure
-
- of HTP package, 139
- FORMTEXT function
-
- of HTF package, 134
- FORMTEXT procedure
-
- of HTP package, 139
- FORMTEXTAREA function
-
- of HTF package, 134
- FORMTEXTAREA procedure
-
- of HTP package, 139
- FORMTEXTAREA2 function
-
- of HTF package, 134
- FORMTEXTAREA2 procedure
-
- of HTP package, 139
- FORMTEXTAREACLOSE function
-
- of HTF package, 134
- FORMTEXTAREACLOSE procedure
-
- of HTP package, 139
- FORMTEXTAREAOPEN function
-
- of HTF package, 134
- FORMTEXTAREAOPEN procedure
-
- of HTP package, 139
- FORMTEXTAREAOPEN2 function
-
- of HTF package, 134
- FORMTEXTAREAOPEN2 procedure
-
- of HTP package, 139
- FRAME function
-
- of HTF package, 134
- FRAME procedure
-
- of HTP package, 139
- FRAMESETCLOSE function
-
- of HTF package, 134
- FRAMESETCLOSE procedure
-
- of HTP package, 139
- FRAMESETOPEN function
-
- of HTF package, 134
- FRAMESETOPEN procedure
-
- of HTP package, 139
- FREE_BLOCKS procedure, 98
- FREEDOCFRAG procedure, 124
- FREEDOCUMENT procedure, 124
- FREENODE procedure, 124
- FREEPARSER procedure, 126
- FREEPROCESSOR procedure, 132
- FREESTYLESHEET procedure, 132
- FREETEMPORARY Procedures, 52
- FREMOVE procedure, 167, 167
- FRENAME procedure, 167
- FSEEK procedure, 167
- functions
-
- adding to attribute sets, 39, 88
G
- GATHER_DATABASE_STATS procedures, 103
- GATHER_DICTIONARY_STATS procedure, 103
- GATHER_FIXED_OBJECTS_STATS procedure, 103
- GATHER_INDEX_STATS Procedure, 103
- GATHER_SCHEMA_STATS procedures, 103
- GATHER_SYSTEM_STATS procedure, 103
- GATHER_TABLE_STATS procedure, 103
- GENERATE_SIGNATURE procedure, 67
- GENERATE_STATS procedure, 103
- GENERATEBEAN procedure, 129
- GENERATESCHEMA function, 129
- GENERATESCHEMAS function, 129
- GET function
-
- of OWA_COOKIE package, 141
- GET* member functions
-
- of ANYDATA TYPE, 181
- of ANYDATASET TYPE, 182
- GET_ACLOID function, 123
- GET_ALL procedure, 141
- GET_ALL_DAD_ATTRIBUTES Procedure, 37
- GET_ALL_DAD_MAPPINGS Procedure, 37
- GET_ALL_GLOBAL_ATTRIBUTES Procedure, 37
- GET_ALL_NAMES member function, 196
- GET_ASSOCIATION_RULES function, 25
- GET_AUTHENTICATION procedure, 168
- GET_BASE_TABLE_NAME member function, 188
- GET_BASE_TABLE_OWNER member function, 188
- GET_BODY_CHARSET procedure, 168
- GET_CATEGORY function, 117
- GET_CGI_ENV function, 148
- GET_CLIENT_HOSTNAME function, 146
- GET_CLIENT_IP function, 146
- GET_COLUMN_STATS procedures, 103
- GET_COMMAND_TYPE member function, 188
- GET_COMMIT_SCN member function, 188
- GET_COMMON_TIME_ZONES Function, 169
- GET_COMPATIBLE member function, 188
- GET_COOKIE_COUNT function, 168
- GET_COOKIE_SUPPORT procedure, 168
- GET_COOKIES function, 168
- GET_CPU_TIME function, 116
- GET_CURRENT_SCHEMA member function, 188
- GET_DAD_ATTRIBUTE Procedure, 37
- GET_DAD_LIST Procedure, 37
- GET_DEFAULT_ISO_CURRENCY Function, 169
- GET_DEFAULT_LINGUISTIC_SORT Function, 169
- GET_DEFAULT_SETTINGS function, 25
- GET_DEPENDENCY procedure, 116
- GET_DETAILED_EXCP_SUPPORT procedure, 168
- GET_DETAILED_SQLCODE function, 168
- GET_DETAILED_SQLERRM function, 168
- GET_ERROR_MESSAGE function, 15
- GET_ETAG function, 140
- GET_EXPRSET_STATS procedure, 39
- GET_EXTRA_ATTRIBUTE member function, 188
- GET_FILE procedure, 42
- GET_FOLLOW_REDIRECT procedure, 168
- GET_FREQUENT_ITEMSETS function, 25
- GET_GLOBAL_ATTRIBUTE Function, 37
- GET_HASH_VALUE function, 116
- GET_HEADER procedure, 168
- GET_HEADER_BY_NAME procedure, 168
- GET_HEADER_COUNT function, 168
- GET_HOST_ADDRESS function, 170
- GET_HOST_NAME function, 170
- GET_IN_PARAMETER_TYPES function, 165
- GET_INDEX_STATS procedures, 103
- GET_INDEXES function, 30
- GET_INFORMATION function, 105
- GET_LEVEL function, 140
- GET_LINE function, 178
- GET_LINE procedure, 68, 167
- GET_LINE_MAP function, 30
- GET_LINE_NCHAR procedure, 167
- GET_LINES procedure, 68
- GET_LOB_INFORMATION member function, 188
- GET_LOB_OFFSET member function, 188
- GET_LOB_OPERATION_SIZE member procedure, 188
- GET_LOCAL_LINGUISTIC_SORTS Function, 169
- GET_LOGON_USER member function, 188
- GET_LONG_INFORMATION member function, 188
- GET_MODEL_DETAILS_ABN function, 25
- GET_MODEL_DETAILS_AI Function, 25
- GET_MODEL_DETAILS_AI function, 25
- GET_MODEL_DETAILS_KM function, 25
- GET_MODEL_DETAILS_NB function, 25
- GET_MODEL_DETAILS_NMF function, 25
- GET_MODEL_DETAILS_OC function, 25
- GET_MODEL_DETAILS_SVM function, 25
- GET_MODEL_DETAILS_XML function, 25
- GET_MODEL_SETTINGS function, 25
- GET_MODEL_SIGNATURE function, 25
- GET_MORE_SOURCE procedure, 30
- GET_NEXT_HIT function, 91
- GET_OBJECT_NAME member function, 188
- GET_OBJECT_OWNER member function, 188
- GET_OBJECT_TYPE member function, 188
- GET_OUT_PARAMETER_TYPES function, 165
- GET_OUTPUT_VALUES function, 165
- GET_OWA_SERVICE_PATH function, 148
- GET_PARAM function, 103
- GET_PARAMETER_VALUE function, 116
- GET_PASSWORD function, 146
- GET_PERSISTENT_CONN_COUNT function, 168
- GET_PERSISTENT_CONN_SUPPORT procedure, 168
- GET_PERSISTENT_CONNS procedure, 168
- GET_PORTS function, 165
- GET_POST_PROCESSED_SOURCE Procedure, 71
- GET_PROCEDURE function, 148
- GET_PROPERTY function, 165
- GET_PROXY procedure, 168
- GET_RAW function, 167, 178
- GET_REC_ATTRIBUTES Procedure, 12
- GET_RESPONSE function, 168
- GET_RESPONSE_ERROR_CHECK procedure, 168
- GET_RETURN_TYPE function, 165
- GET_ROWID function, 144
- GET_RUNTIME_INFO function, 30
- GET_SCN member function, 188
- GET_SCN_MAPPING procedure, 106
- GET_SERVICES function, 165
- GET_SESSION_TIMEOUT function, 87
- GET_SOURCE_DATABASE_NAME member function, 188
- GET_SOURCE_TIME member function, 188
- GET_STATS_HISTORY_AVAILABILITY function, 103
- GET_STATS_HISTORY_RETENTION function, 103
- GET_STREAMS_NAME function, 105
- GET_STREAMS_TYPE function, 105
- GET_SYSTEM_STATS procedure, 103
- GET_TABLE_STATS procedure, 103
- GET_TAG function, 105
- GET_TAG member function, 188
- GET_TASK_REPORT Procedure, 12
- GET_TASK_SCRIPT Procedure, 12
- GET_TEXT function, 178
- GET_THRESHOLD procedure, 94
- GET_TIME function, 116
- GET_TIMEOUT function, 87
- GET_TIMEOUT_BEHAVIOUR function, 30
- GET_TRANSACTION_ID member function, 188
- GET_TRANSFER_TIMEOUT procedure, 168
- GET_USER_ID function, 146
- GET_USERID function, 123
- GET_VALUE function, 30
- GET_VALUE member function, 188, 196
- GET_VALUE Procedure, 45
- GET_VALUE_RAW Procedure, 45
- GET_VALUES member function, 188
- GET_VERSION procedure, 73
- GET_WARNING_SETTING_CAT function, 117
- GET_WARNING_SETTING_NUM function, 117
- GET_WARNING_SETTING_STRING function, 117
- GET_X function, 143
- GET_Y function, 143
- GETACLDOCUMENT function, 120
- GETATTRELEMINFO member function
-
- of ANYTYPE TYPE, 183
- GETATTRIBUTE function, 124
- GETATTRIBUTENODE function, 124
- GETATTRIBUTES function, 124
- GETBLOB function, 185, 185, 185, 185
- GETBLOBVAL function, 197
- GETBUBLICID function, 124
- GETCHILDNODES function, 124
- GETCHILDRENBYTAGNAME function, 124
- GETCHUNKSIZE Functions, 52
- GETCLOB function, 185, 185, 185, 185
- GETCLOBVAL function, 197
- GETCONTENTSBLOBBYRESID function, 121
- GETCONTENTSCLOBBYRESID function, 121, 121
- GETCONTENTSXMLBYRESID function, 121
- GETCONTENTTYPE function, 185, 185, 185, 185
- GETCOUNT member function
-
- of ANYDATASET TYPE, 182
- GETDATA function, 124
- GETDCHARSET function, 124
- GETDOCTYPE function, 124, 126
- GETDOCUMENT function, 126
- GETDOCUMENTELEMENT function, 124
- GETDTD function, 127
- GETDTD procedure, 127
- GETELEMENTSBYTAGNAME function, 124, 124
- GETENTITIES function, 124
- GETEXCEPTIONCONTENT procedure, 127, 128
- GETEXPANDEDNAME function, 124, 124
- GETEXPANDEDNAME procedure, 124
- GETEXTERNALURL function, 185, 185, 185, 185
- GETFIRSTCHILD function, 124
- GETFTPPORT Function, 120
- GETHTTPPORT Function, 120
- GETIMPLEMENTATION function, 124
- GETINFO member function
-
- of ANYTYPE TYPE, 183
- GETLASTCHILD function, 124
- GETLENGTH function, 124, 124, 124
- GETLENGTH Functions, 52
- GETLOCKTOKEN procedure, 120
- GETNAME function, 124, 124
- GETNAMEDITEM function, 124
- GETNAMESPACE function, 124, 124
- GETNAMESPACE procedure, 124
- GETNEXTSIBLING function, 124
- GETNODENAME function, 124
- GETNODETYPE function, 124
- GETNODEVALUE function, 124
- GETNOTATIONNAME function, 124
- GETNOTATIONS function, 124
- GETNUMBERVAL function, 197
- GETNUMROWSPROCESSED function, 125
- GETNUMROWSPROCESSED procedure, 127
- GETOWNERDOCUMENT function, 124
- GETOWNERELEMENT function, 124
- GETPARENTNODE function, 124
- GETPAT procedure, 145
- GETPERSISTENT static function
-
- of ANYTYPE TYPE, 183
- GETPREDECESSORS function, 121
- GETPREDSBYRESID function, 121
- GETPREFIX function, 124
- GETPREVIOUSSIBLING function, 124
- GETPRIVILEGES function, 120
- GETPUBLICID function, 124, 124
- GETQUALIFIEDNAME function, 124, 124
- GETRELEASEVERSION function, 126
- GETRESOID function, 120
- GETRESOURCEBYRESID function, 121
- GETROOTELEMENT function, 197
- GETRUL function, 185
- GETSCHEMANODE function, 124
- GETSCHEMAURL function, 197
- GETSPECIFIED function, 124
- GETSTANDALONE function, 124
- GETSTRINGVAL function, 197
- GETSUCCESSORS function, 121
- GETSUCCSBYRESID function, 121
- GETSYSTEMID function, 124, 124, 124
- GETTAGNAME function, 124
- GETTARGET function, 124
- GETTYPE member function
-
- of ANYDATA TYPE, 181
- of ANYDATASET TYPE, 182
- GETTYPENAME member function
-
- of ANYDATA TYPE, 181
- of ANYDATASET TYPE, 182
- GETURL function, 185, 185, 185, 185
- GETVALIDATIONMODE function, 126
- GETVALUE function, 124
- GETVERSION function, 124
- GETVERSION procedure, 127
- GETXDB_TABLESPACE function, 120
- GETXML function, 125, 127, 185, 185, 185, 185
- GETXML procedure, 127
- GETXMLTYPE function, 124, 125
- GRANT_ADMIN_PRIVILEGE procedure, 107
- GRANT_OBJECT_PRIVILEGE procedure, 92
- GRANT_PRIVILEGE procedure, 39, 88
- GRANT_REMOTE_ADMIN_ACCESS procedure, 107
- GRANT_SWITCH_CONSUMER_GROUP procedure, 86
- GRANT_SYSTEM_PRIVILEGE procedure, 41, 86, 92
- GRANTING_OBJECT_PRIVILEGE procedure, 41
H
- HASATTRIBUTE function, 124
- HASCHILDNODES function, 124
- HASFEATURE function, 124
- HEADCLOSE function
-
- of HTF package, 134
- HEADCLOSE procedure
-
- of HTP package, 139
- HEADER function
-
- of HTF package, 134
- HEADER procedure
-
- of HTP package, 139
- HEADOPEN function
-
- of HTF package, 134
- HEADOPEN procedure
-
- of HTP package, 139
- HELO function and procedure, 177
- HELP function, 177
- HR function
-
- of HTF package, 134
- HR procedure
-
- of HTP package, 139
- HTF package, 134
- HTML tags
-
- applet tags
-
- functions, 134
- procedures, 139
- atags tags
-
- procedures, 139
- character formatting tags
-
- functions, 134
- procedures, 139
- form tags
-
- functions, 134
- procedures, 139
- frame tags
-
- functions, 134
- procedures, 139
- list tags
-
- functions, 134
- procedures, 139
- paragraph formatting tags
-
- functions, 134
- procedures, 139
- table tags
-
- functions, 134
- HTMLCLOSE function
-
- of HTF package, 134
- HTMLCLOSE procedure
-
- of HTP package, 139
- HTMLDB_APPLICATION package documentation, 136
- HTMLDB_CUSTOM_AUTH package documentation, 135
- HTMLDB_ITEM package documentation, 137
- HTMLDB_UTIL package documentation, 138
- HTMLOPEN function
-
- of HTF package, 134
- HTMLOPEN procedure
-
- of HTP package, 139
- HTP package, 139
- HTTP_HEADER_CLOSE procedure, 148
- HttpUriType, 185
- HTTPURITYPE function, 185
- HttpUriType subtype, 185
-
- CREATEURI function, 185
- GETBLOB function, 185
- GETCLOB function, 185
- GETCONTENTTYPE function, 185
- GETEXTERNALURL function, 185
- GETRUL function, 185
- GETXML function, 185
- HTTPURITYPE function, 185
- methods, 185
I
- IMG function
-
- of HTF package, 134
- IMG procedure
-
- of HTP package, 139
- IMG2 procedure
-
- of HTP package, 139
- IMPLEMENT_TASK Procedure, 12
- IMPORT_COLUMN_STATS procedure, 103
- IMPORT_DATABASE_STATS procedure, 103
- IMPORT_DICTIONARY_STATS procedure, 103
- IMPORT_FIXED_OBJECTS_STATS procedure, 103
- IMPORT_INDEX_STATS procedure, 103
- IMPORT_MODEL procedure, 25
- IMPORT_SCHEMA_STATS procedure, 103
- IMPORT_SQLWKLD_SCHEMA Procedure, 12
- IMPORT_SQLWKLD_SQLCACHE Procedur, 12
- IMPORT_SQLWKLD_STS Procedure, 12
- IMPORT_SQLWKLD_SUMADV Procedure, 12
- IMPORT_SQLWKLD_USER Procedure, 12
- IMPORT_SYSTEM_STATS procedure, 103
- IMPORT_TABLE_STATS procedure, 103
- IMPORTNODE function, 124
- INCLUDE_EXTRA_ATTRIBUTES procedure, 20
- INDEX_PARAMETERS procedure, 39
- INITIALIZE function, 30
- INITIALIZE procedure, 75
- INSERT_AUTOBIN_NUM_EQWIDTH procedure, 26
- INSERT_BIN_CAT_FREQ procedure, 26
- INSERT_BIN_NUM_EQWIDTH procedure, 26
- INSERT_BIN_NUM_QTILE procedure, 26
- INSERT_CLIP_TRIM_TAIL procedure, 26
- INSERT_CLIP_WINSOR_TAIL procedure, 26
- INSERT_MISS_CAT_MODE procedure, 26
- INSERT_MISS_NUM_MEAN procedure, 26
- INSERT_NORM_LIN_MINMAX procedure, 26
- INSERT_NORM_LIN_SCALE Procedure, 26
- INSERT_NORM_LIN_SCALE procedure, 26
- INSERT_NORM_LIN_ZSCORE procedure, 26
- INSERTBEFORE function, 124
- INSERTDATA procedure, 124
- INSERTXML function, 128, 130
- INSTANCE procedure, 48
- instantiation
-
- aborting database preparation, 20
- aborting schema preparation, 20
- aborting table preparation, 20
- global SCN, 15
- preparing a database for, 20
- preparing a schema for, 20
- preparing a table for, 20
- schema SCN, 15
- table SCN, 15
- INSTR Functions, 52
- INTERNAL_VERSION_CHECK function, 73
- internet addressing
-
- using UTL_INADDR, 170
- INTERRUPT_TASK Procedure, 12
- INTERRUPT_TUNING_TASK procedure, 101
- INTERVAL procedure, 48
- INVALIDATE Procedure, 116
- INVOKE function, 165
- IS_CLUSTER_DATABASE function, 116
- IS_HIERARCHY_ENABLED function, 123
- IS_LOCATOR function, 163
- IS_NULL_TAG member function, 188
- IS_OPEN function, 100, 167
- IS_TRIGGER_FIRE_ONCE function, 29
- ISFRAGMENT function, 197
- ISINDEX function
-
- of HTF package, 134
- ISINDEX procedure
-
- of HTP package, 139
- ISNULL function, 124
- ISOPEN function, 164
- ISOPEN Functions, 52
- ISSCHEMABASED function, 197
- ISSCHEMAVALID function, 197
- ISSCHEMAVALIDATED function, 197
- ISTEMPORARY Functions, 52
- ITALIC function
-
- of HTF package, 134
- ITALIC procedure
-
- of HTP package, 139
- ITEM Functions, 124
K
- KBD function
-
- of HTF package, 134
- KBD procedure
-
- of HTP package, 139
- KEEP procedure, 97
- KEYBOARD function
-
- of HTF package, 134
- KEYBOARD procedure
-
- of HTP package, 139
L
- LAPACK Driver Routines (Linear Equations) Subprograms, 173
- LAPACK Driver Routines (LLS and Eigenvalue Problems), 173
- LAPACK_GBSV Procedures, 173
- LAPACK_GEES Procedures, 173
- LAPACK_GEEV Procedures, 173
- LAPACK_GELS Procedures, 173
- LAPACK_GESDD Procedures, 173
- LAPACK_GESV Procedures, 173
- LAPACK_GESVD Procedures, 173
- LAPACK_GTSV Procedures, 173
- LAPACK_PBSV Procedures, 173
- LAPACK_POSV Procedures, 173
- LAPACK_PPSV Procedures, 173
- LAPACK_PTSV Procedures, 173
- LAPACK_SBEV Procedures, 173
- LAPACK_SBEVD Procedures, 173
- LAPACK_SPEV Procedures, 173
- LAPACK_SPEVD Procedures, 173
- LAPACK_SPSV Procedures, 173
- LAPACK_STEV Procedures, 173
- LAPACK_STEVD Procedures, 173
- LAPACK_SYEV Procedures, 173
- LAPACK_SYEVD Procedures, 173
- LAPACK_SYSV Procedures, 173
- LAST_ERROR_POSITION function, 100
- LAST_ROW_COUNT function, 100
- LAST_ROW_ID function, 100
- LAST_SQL_FUNCTION_CODE function, 100
- LCR$_DDL_RECORD type, 188
- LCR$_ROW_LIST type, 188
- LCR$_ROW_RECORD type, 188
- LCR$_ROW_UNIT type, 188
-
- GET_LOB_INFORMATION member function, 188
- GET_LOB_OPERATION_SIZE member procedure, 188
- GET_LONG_INFORMATION member function, 188
- SET_LOB_INFORMATION member procedure, 188
- SET_LOB_OPERATION_SIZE member procedure, 188
- LCR_TO_XML Function, 59
- LENGTH function, 174
- LINE function
-
- of HTF package, 134
- LINE procedure
-
- of HTP package, 139
- LINK procedure, 120
- LINKREL function
-
- of HTF package, 134
- LINKREL procedure
-
- of HTP package, 139
- LINKREV function
-
- of HTF package, 134
- LINKREV procedure
-
- of HTP package, 139
- LISTHEADER function
-
- of HTF package, 134
- LISTHEADER procedure
-
- of HTP package, 139
- LISTINGCLOSE function
-
- of HTF package, 134
- LISTINGCLOSE procedure
-
- of HTP package, 139
- LISTINGOPEN function
-
- of HTF package, 134
- LISTINGOPEN procedure
-
- of HTP package, 139
- LISTITEM function
-
- of HTF package, 134
- LISTITEM procedure
-
- of HTP package, 139
- LISTPRINT procedure, 148
- LOAD_SQLSET procedure, 101
- LOADBLOBFROMFILE Procedure, 52
- LOADCLOBFROMFILE Procedure, 52
- LOADFROMFILE Procedure, 52
- LOBs
-
- DBMS_LOB package, 52
- LOCAL_TRANSACTION_ID function, 111
- LOCK_MAP procedure, 104
- LOCK_OBJECT procedure, 176
- LOCK_SCHEMA_STATS procedure, 103
- LOCK_TABLE_STATS procedure, 103
- LOCKRESOURCE function, 120
- log apply services
-
- managing initialization parameters for logical standby databases, 56
- logical change records (LCRs)
-
- DDL LCRs, 188
-
- getting base table name, 188
- getting base table owner, 188
- getting current schema, 188
- getting logon user name, 188
- getting object type, 188
- setting base table name, 188
- setting base table owner, 188
- setting current schema, 188
- setting DDL text, 188
- setting logon user, 188
- setting object type, 188
- determining if tag is NULL, 188
- executing, 188, 188
- extra attributes
-
- excluding, 20
- including, 20
- getting command type, 188
- getting commit SCN, 188
- getting compatibility information, 188
- getting extra attributes, 188
- getting LCR creation time, 188
- getting object name, 188
- getting object owner, 188
- getting SCN, 188
- getting source database name, 188
- getting tag, 188
- getting transaction identifier, 188
- LCR$_DDL_RECORD type, 188
- LCR$_ROW_LIST type, 188
- LCR$_ROW_RECORD type, 188
- LCR$_ROW_UNIT type, 188
- row LCRs, 188
-
- adding value to column, 188
- converting LONG to LOB, 188
- deleting value to column, 188
- getting column value, 188
- getting list of column values, 188
- getting LOB offset, 188
- renaming column, 188
- setting column value, 188
- setting list of column values, 188
- setting LOB offset, 188
- setting command type, 188
- setting extra attributes, 188
- setting object name, 188
- setting object owner, 188
- setting source database name, 188
- setting tag, 188
- types, 188
- logical standby databases
-
- managing with DBMS_LOGSTDBY package, 56
- LOGSTDBY_ADMINISTRATOR role, 56
- LZ_COMPRESS functions and procedures, 164
- LZ_COMPRESS_ADD procedure, 164
- LZ_COMPRESS_CLOSE procedure, 164
- LZ_COMPRESS_OPEN function, 164
- LZ_UNCOMPRESS functions and procedures, 164
- LZ_UNCOMPRESS_CLOSE procedure, 164
- LZ_UNCOMPRESS_EXTRACT procedure, 164
- LZ_UNCOMPRESS_OPEN function, 164
M
- MAIL function and procedure, 177
- MAILTO function
-
- of HTF package, 134
- MAILTO procedure
-
- of HTP package, 139
- MAINTAIN_GLOBAL procedure, 106
- MAINTAIN_SCHEMAS procedure, 106
- MAINTAIN_SIMPLE_TABLESPACE procedure, 106
- MAINTAIN_SIMPLE_TTS procedure, 106
- MAINTAIN_TABLES procedure, 106
- MAINTAIN_TABLESPACES procedure, 106
- MAINTAIN_TTS procedure, 106
- MAKE_DATA_BLOCK_ADDRESS function, 116
- MAKEATTR function, 124
- MAKECDATASECTION function, 124
- MAKECHARACTERDATA function, 124
- MAKECOMMENT function, 124
- MAKEDOCUMENT function, 124
- MAKEDOCUMENTFRAGMENT function, 124
- MAKEDOCUMENTTYPE function, 124
- MAKEELEMENT function, 124
- MAKEENTITY function, 124
- MAKEENTITYREFERENCE function, 124
- MAKENODE function, 124, 124, 124, 124
- MAKENOTATION function, 124
- MAKEPROCESSINGINSTRUCTION function, 124
- MAKETEXT function, 124
- MAKEVERSIONED function, 121
- MAP_ALL function, 104
- MAP_DAD Procedure, 37
- MAP_ELEMENT function, 104
- MAP_FILE function, 104
- MAP_OBJECT function, 104
- MAPCLOSE function
-
- of HTF package, 134
- MAPCLOSE procedure
-
- of HTP package, 139
- MAPOPEN function
-
- of HTF package, 134
- MAPOPEN procedure
-
- of HTP package, 139
- MARK_RECOMMENDATION Procedure, 12
- MATCH function, 145
- materialized view logs
-
- master table
-
- purging, 61, 61, 61
- materialized views
-
- refreshing, 61, 61, 61
- MENULISTCLOSE function
-
- of HTF package, 134
- MENULISTCLOSE procedure
-
- of HTP package, 139
- MENULISTOPEN function
-
- of HTF package, 134
- MENULISTOPEN procedure
-
- of HTP package, 139
- MESSAGE_PROPERTIES_ARRAY_T Type, 184
- MESSAGE_PROPERTIES_T Type, 184
- messaging client
-
- messaging client user, 106
- rules
-
- for LCRs, 106
- for user messages, 106
- META function
-
- of HTF package, 134
- META procedure
-
- of HTP package, 139
- methodology
-
- transformation, 26
- MG2 function
-
- of HTF package, 134
- MGW_FOREIGN_QUEUES View, 58
- MGW_GATEWAY View, 58
- MGW_LINKS View, 58
- MGW_MQSERIES_LINKS View, 58
- MGW_SCHEDULES View, 58
- MGW_SUBSCRIBERS View, 58
- MGW_TIBRV_LINKS View, 58
- migration
-
- post-migration actions, 62
- MIME_HEADER procedure, 148
- MIMEHEADER_DECODE function, 166
- MIMEHEADER_ENCODE function, 166
- min-max normalization, 26
- missing value treatment, 26
- MODIFY_OPERATOR_LIST procedure, 39
- MODIFY_SERVICE Procedure, 95
- MODIFY_SNAPSHOT_SETTINGS procedure, 118
- MODIFY_TRANSFORMATION procedure, 112
- MOVEXDB_TABLESPACE procedure, 120
- MSGID_ARRAY_T Type, 184
N
- NAME_RESOLVE procedure, 116
- NAME_TOKENIZE procedure, 116
- NAMESPACE function, 197
- new features, Preface
- NEW_LINE procedure, 68, 167
- NEW_ROW_LIST function and procedure, 147
- NEWCONTEXT function, 125, 127, 128, 130
- NEWDOMDOCUMENT function, 124
- NEWPARSER function, 126
- NEWPROCESSOR function, 132
- NEWSTYLESHEET function, 132
- NEXT_DATE procedure, 48
- NEXT_ITEM_TYPE function, 70
- NL function
-
- of HTF package, 134
- NL procedure
-
- of HTP package, 139
- NOBR function
-
- of HTF package, 134
- NOBR procedure
-
- of HTP package, 139
- NOFRAMESCLOSE function
-
- of HTF package, 134
- NOFRAMESCLOSE procedure
-
- of HTP package, 139
- NOFRAMESOPEN function
-
- of HTF package, 134
- NOFRAMESOPEN procedure
-
- of HTP package, 139
- NOOP function and procedure, 177
- NORMAL function, 75
- NORMAL_DIST_FIT procedure, 102
- normalization, 26
-
- min-max, 26
- z-score, 26
- NORMALIZE procedure, 124
- numerical binning, 26
- NVARRAY_ADD Procedure, 59
- NVARRAY_FIND_NAME Function, 59
- NVARRAY_FIND_NAME_TYPE Function, 59
- NVARRAY_GET Function, 59
- NVARRAY_GET_BOOLEAN, 59
- NVARRAY_GET_BYTE, 59
- NVARRAY_GET_DATE Function, 59
- NVARRAY_GET_DOUBLE Function, 59
- NVARRAY_GET_FLOAT Function, 59
- NVARRAY_GET_INTEGER, 59
- NVARRAY_GET_LONG Function, 59
- NVARRAY_GET_RAW Function, 59
- NVARRAY_GET_SHORT, 59
- NVARRAY_GET_TEXT Function, 59
O
- OBJECT_DEPENDENT_SEGMENTS function, 98
- OBJECT_GROWTH_TREND function, 98
- OLISTCLOSE function
-
- of HTF package, 134
- OLISTCLOSE procedure
-
- of HTP package, 139
- OLISTOPEN function
-
- of HTF package, 134
- OLISTOPEN procedure
-
- of HTP package, 139
- One-Class SVM, 25, 25, 25, 25, 25, 25, 25
- ONLINE_INDEX_CLEAN Function, 79
- OPEN Procedures, 52
- OPEN_CONNECTION function, 178
- OPEN_CONNECTION functions, 177
- OPEN_CURSOR Function, 45
- OPEN_CURSOR function, 100
- OPEN_DATA function and procedure, 177
- operational notes
-
- DBMS_LOGSTDBY package, 56
- OR REPLACE clause
-
- for creating packages, 1
- Oracle Streams
-
- administrator
-
- granting privileges, 107
- revoking privileges, 107
- compatibility, 105, 105, 105, 188
- creating queues, 106
- data dictionary
-
- removing information, 106
- messaging
-
- notification, 106
- privileges, 107
- replication
-
- configuring, 106, 106, 106, 106, 106, 106, 106, 106
- Oracle-supplied types
-
- logical change record (LCR) types, 188
- rule types, 196
- OVERLAY function, 174
- OWA_CACHE package, 140
- OWA_COOKIE package, 141
- OWA_CUSTOM package, 142
- OWA_IMAGE package, 143
- OWA_OPT_LOCK package, 144
- OWA_PATTERN package, 145
- OWA_SEC package, 146
- OWA_TEXT package, 147
- OWA_UTIL package, 148
P
- PACK_MESSAGE procedures, 70
- PACK_STGTAB_SQLPROF Procedure, 101
- PACK_STGTAB_SQLSET Procedure, 101
- package
-
- DBMS_EXPFIL, 39
- DBMS_ODCI, 63
- DBMS_RLMGR, 88
- DBMS_XDB, 120
- DBMS_XMLDOM, 124
- DBMS_XMLGEN, 125
- DBMS_XMLPARSER, 126
- DBMS_XMLQUERY, 127
- DBMS_XMLSAVE, 128
- DBMS_XMLSCHEMA, 129
- UriFactory, 185
- Package - UriFactory, 185
- package overview, 1
- package variables
-
- i_am_a_refresh, 61
- packages
-
- creating, 1
- referencing, 1
- where documented, 1
- PARA function
-
- of HTF package, 134
- PARA procedure
-
- of HTP package, 139
- PARAGRAPH function
-
- of HTF package, 134
- PARAGRAPH procedure
-
- of HTP package, 139
- PARAM function
-
- of HTF package, 134
- PARAM procedure
-
- of HTP package, 139
- PARSE Procedure, 45
- PARSE procedure, 100, 126
- PARSEBUFFER procedure, 126
- PARSECLOB procedure, 126
- PARSEDTD procedure, 126
- PARSEDTDBUFFER procedure, 126
- PARSEDTDCLOB procedure, 126
- PAUSE_PROFILER function and procedure, 73
- PIECEWISE member procedure
-
- of ANYDATA TYPE, 181
- of ANYDATASET TYPE, 182
- PING procedure, 30
- PLAINTEXT function
-
- of HTF package, 134
- PLAINTEXT procedure
-
- of HTP package, 139
- plan stability, 66
- PL/SQL
-
- datatypes, 34
-
- numeric codes for, 34
- functions
-
- DBMS_MGWADM package subprograms, 58
- DBMS_MGWMSG package subprograms, 59
- procedures
-
- DBMS_MGWADM package subprograms, 58
- DBMS_MGWMSG package subprograms, 59
- PLSQL_TRACE_VERSION procedure, 110
- pointer to
-
- CTX_ADM package, 2
- point-in-time recovery
-
- Oracle Streams, 106
- POISSON_DIST_FIT procedure, 102
- PORT_STRING function, 116
- POST_INSTANTIATION_SETUP procedure, 106
- PRE_INSTANTIATION_SETUP procedure, 106
- PRECLOSE function
-
- of HTF package, 134
- PRECLOSE procedure
-
- of HTP package, 139
- PREDICT procedure, 72
- PREOPEN function
-
- of HTF package, 134
- PREOPEN procedure
-
- of HTP package, 139
- PREPARE_COLUMN_VALUES procedures, 103, 103
- PREPARE_COLUMN_VALUES_NVARCHAR2 procedure, 103
- PREPARE_COLUMN_VALUES_ROWID procedure, 103
- PREPARE_FOR_NEW_PRIMARY subprogram, 56
- PREPARE_GLOBAL_INSTANTIATION procedure, 20
- PREPARE_SCHEMA_INSTANTIATION procedure, 20
- PREPARE_TABLE_INSTANTIATION procedure, 20
- PRINT function
-
- of HTF package, 134
- PRINT procedure
-
- of HTP package, 139
- PRINT_BACKTRACE procedure, 30
- PRINT_CGI_ENV procedure, 148
- PRINT_INSTANTIATIONS procedure, 30
- PRINT_MULTI procedure, 147
- PRINT_POST_PROCESSED_SOURCE Procedure, 71
- PRINT_ROW_LIST procedure, 147
- PRINTS procedure
-
- of HTP package, 139
- privileges
-
- DBMS_LOGSTDBY package, 56
- granting, 39
- Oracle Streams administrator, 107, 107
- revoking, 39
- PRN function
-
- of HTF package, 134
- PRN procedure
-
- of HTP package, 139
- PROBE_VERSION procedure, 30
- PROCESS_RULES procedure, 88
- PROCESSXSL function, 132
- PROGRAM_INFO Record Type, 30
- PROPAGATEORIGINALEXCEPTION procedure, 127, 128
- propagations
-
- altering, 74
- creating, 74, 106, 106, 106, 106, 106
- DBMS_PROPAGATION_ADM package, 74
- dropping, 74
- propagation user, 106
- rules
-
- defining global, 106
- defining message, 106
- defining schema, 106
- defining subset, 106
- defining table, 106
- for LCRs, 106
- for user messages, 106
- starting, 74
- stopping, 74
- PS procedure
-
- of HTP package, 139
- PULL_SIMPLE_TABLESPACE procedure, 109
- PULL_TABLESPACES procedure, 109
- PURGE procedure, 70
- PURGE_FILE_GROUP procedure, 41
- PURGE_LOST_DB_ENTRY procedure, 111
- PURGE_MIXED procedure, 111
- PURGE_QUEUE_TABLE Procedure, 17
- PURGE_SESSION Subprogram, 56
- PURGE_SOURCE_CATALOG procedure, 106
- PURGE_STATS procedure, 103
- PURGELDAPCACHE function, 123
- purging
-
- the subscription window, 22
- PUT procedure, 167
- PUT procedures, 68
- PUT_FILE procedure, 42
- PUT_LINE procedure, 167
- PUT_LINE procedures, 68
- PUT_LINE_NCHAR procedure, 167
- PUT_NCHAR procedure, 167
- PUT_RAW function, 167
- PUTF procedure, 167
- PUTF_NCHAR procedure, 167
Q
- quantile numerical binning, 26
- query generation, 26
- queues
-
- AnyData
-
- creating, 106
- removing, 106
- QUICK_TUNE Procedure, 12
- QUIT function and procedure, 177
- QUOTED_PRINTABLE_DECODE function, 166
- QUOTED_PRINTABLE_ENCODE function, 166
R
- RANDOM procedure, 75
- RANK_APPLY procedure, 25
- RCPT function, 177
- RE$ATTRIBUTE_VALUE type, 196
- RE$ATTRIBUTE_VALUE_LIST type, 196
- RE$COLUMN_VALUE type, 196, 196
- RE$COLUMN_VALUE_LIST type, 196
- RE$NAME_ARRAY type, 196
- RE$NV_ARRAY type, 196
- RE$NV_LIST type, 196
-
- ADD_PAIR member procedure, 196
- GET_ALL_NAMES member function, 196
- GET_VALUE member function, 196
- REMOVE_PAIR member procedure, 196
- RE$RULE_HIT type, 196
- RE$RULE_HIT_LIST type, 196
- RE$TABLE_ALIAS type, 196
- RE$TABLE_ALIAS_LIST type, 196
- RE$TABLE_VALUE type, 196
- RE$TABLE_VALUE_LIST type, 196
- RE$VARIABLE_TYPE type, 196
- RE$VARIABLE_TYPE_LIST type, 196
- RE$VARIABLE_VALUE type, 196
- RE$VARIABLE_VALUE_LIST type, 196
- READ Procedures, 52
- READ_CLIENT_INFO procedure, 14
- READ_LINE function, 178
- READ_LINE procedure
-
- of UTL_HTTP, 168
- READ_MODULE procedure, 14
- READ_ONLY procedure, 111
- READ_RAW function, 178
- READ_RAW procedure
-
- of UTL_HTTP, 168
- READ_TEXT function, 178
- READ_TEXT procedure
-
- of UTL_HTTP, 168
- READ_WRITE procedure, 111
- READ2CLOB function, 132
- REBUILD_FREELISTS procedure, 79
- RECEIVE_MESSAGE function, 70
- RECOMP_PARALLEL procedure, 175
- RECOMP_SERIAL procedure, 175
- REDIRECT_URL procedure, 148
- refresh
-
- materialized views, 61, 61, 61
- REFRESH_PRIVATE_OUTLINE procedure, 67
- REGISTER procedure, 13
- REGISTER_DEPENDENT_OBJECT procedure, 77
- REGISTER_FOREIGN_QUEUE Procedure, 58
- REGISTERSCHEMA procedure, 129
- REGISTERURI procedure, 129
- REGISTERURLHANDLER procedure, 185
- RELEASE function, 53
- RELEASE_ALL_SERVICES procedure, 165
- RELEASE_CALL procedure, 165, 165
- RELEASE_SERVICE procedure, 165
- REMAP_STGTAB_SQLPROF Procedure, 101
- REMAP_STGTAB_SQLSET Procedure, 101
- REMOVE procedure
-
- of DBMS_ALERT package, 13
- of DBMS_JOB package, 48
- of OWA_COOKIE package, 141
- REMOVE_FILE procedure, 41
- REMOVE_MSGSYSTEM_LINK Procedure, 58
- REMOVE_PAIR member procedure, 196
- REMOVE_PIPE function, 70
- REMOVE_PROPERTY procedure, 165
- REMOVE_QUEUE procedure, 106
- REMOVE_RULE procedure, 92, 106
- REMOVE_SQLSET_REFERENCE procedure, 101
- REMOVE_STREAMS_CONFIGURATION procedure, 106
- REMOVE_SUBSCRIBER Procedure, 58
- REMOVEALL procedure, 13
- REMOVEATTRIBUTE procedure, 124
- REMOVEATTRIBUTENODE function, 124
- REMOVENAMEDITEM function, 124
- REMOVEPARAM procedure, 132
- REMOVEXSLTPARAM procedure, 127, 128
- RENAME_COLUMN member procedure, 188
- RENAME_COLUMN procedure, 106
- RENAME_MODEL procedure, 25
- RENAME_SCHEMA procedure, 106
- RENAME_TABLE procedure, 106
- RENAMERESOURCE procedure, 120
- REPLACECHILD function, 124
- REPLACEDATA procedure, 124
- replication
-
- Oracle Streams
-
- configuring, 106, 106, 106, 106, 106, 106, 106, 106
- REPLY, REPLIES record types, 177
- REPORT_TUNING_TASK function, 101
- REQUEST function, 53, 168
- REQUEST_PIECES function, 168
- RESET_BUFFER procedure, 70
- RESET_PARAM_DEFAULTS Procedure, 103
- RESET_SESSION procedure, 88
- RESET_SQLWKLD Procedure, 12
- RESET_SUBSCRIBER Procedure, 58
- RESET_TASK Procedure, 12
- RESET_TUNING_TASK procedure, 101
- RESETPARAMS procedure, 132
- RESOLVENAMESPACEPREFIX function, 124
- RESTARTQUERY procedure, 125
- RESTORE function, 104
- RESTORE_DATBASE_STATS procedure, 103
- RESTORE_DICTIONARY_STATS procedure, 103
- RESTORE_FIXED_OBJECTS_STATS procedure, 103
- RESTORE_SCHEMA_STATS procedure, 103
- RESTORE_SYSTEM_STATS procedure, 103
- RESTORE_TABLE_STATS procedure, 103
- RESUME_PROFILER function and procedure, 73
- RESUME_TUNING_TASK Procedure, 101
- REVERSE function, 174
- REVOKE_ADMIN_PRIVILEGE procedure, 107
- REVOKE_OBJECT_PRIVILEGE procedure, 41, 92
- REVOKE_PRIVILEGE procedure, 39, 88
- REVOKE_REMOTE_ADMIN_ACCESS procedure, 107
- REVOKE_SWITCH_CONSUMER_GROUP procedure, 86
- REVOKE_SYSTEM_PRIVILEGE procedure, 41, 86, 92
- RLM$EVENTIDS object type, 195
- ROLLBACK procedure, 111
- ROLLBACK_FORCE procedure, 111
- ROLLBACK_SAVEPOINT procedure, 111
- row migration, 106, 106
- ROWID datatype
-
- extended format, 90
- ROWID_BLOCK_NUMBER function, 90
- ROWID_CREATE function, 90
- ROWID_INFO procedure, 90
- ROWID_OBJECT function, 90
- ROWID_RELATIVE_FNO function, 90
- ROWID_ROW_NUMBER function, 90
- ROWID_TO_ABSOLUTE_FNO function, 90
- ROWID_TO_EXTENDED function, 90
- ROWID_TO_RESTRICTED function, 90
- ROWID_TYPE function, 90
- ROWID_VERIFY function, 90
- rule sets
-
- adding rules to, 92
- creating, 92
- dropping, 92
- removing rules from, 92
- rule-based transformations
-
- setting, 106
- rules
-
- action contexts
-
- adding name-value pairs, 196
- getting name-value pairs, 196
- getting value for name, 196
- removing name-value pairs, 196
- transformations, 106
- altering, 92
- creating, 92
- DBMS_RULE package, 91
- DBMS_RULE_ADM package, 92
- dropping, 92
- evaluation, 91
-
- iterators, 91, 91
- evaluation contexts
-
- altering, 92
- creating, 92
- dropping, 92
- object privileges
-
- granting, 92
- revoking, 92
- propagations
-
- removing, 106
- RE$ATTRIBUTE_VALUE type, 196
- RE$ATTRIBUTE_VALUE_LIST type, 196
- RE$COLUMN_VALUE type, 196, 196
- RE$COLUMN_VALUE_LIST type, 196
- RE$NAME_ARRAY type, 196
- RE$NV_ARRAY type, 196
- RE$NV_LIST type, 196
- RE$RULE_HIT type, 196
- RE$RULE_HIT_LIST type, 196
- RE$TABLE_ALIAS type, 196
- RE$TABLE_ALIAS_LIST type, 196
- RE$TABLE_VALUE type, 196
- RE$TABLE_VALUE_LIST type, 196
- RE$VARIABLE_TYPE type, 196
- RE$VARIABLE_TYPE_LIST type, 196
- RE$VARIABLE_VALUE type, 196
- RE$VARIABLE_VALUE_LIST type, 196
- subset
-
- defining, 106, 106
- system privileges
-
- granting, 92
- revoking, 92
- system-created, 106
-
- global apply, 106
- global capture, 106
- global propagation, 106
- global schema, 106
- message, 106, 106
- message propagation, 106
- removing, 106
- schema capture, 106
- schema propagation, 106
- subset apply, 106
- subset capture, 106
- subset propagation, 106
- table apply, 106
- table capture, 106
- table propagation, 106
- types, 196
- Rules Manager object types, 195
- RUN procedure, 48
- RUNTIME_INFO Record Type, 30
S
- S function
-
- of HTF package, 134
- S procedure
-
- of HTP package, 139
- SAMPLE function
-
- of HTF package, 134
- SAMPLE procedure
-
- of HTP package, 139
- SAVE function, 104
- SAVEPOINT procedure, 111
- SCHEDULE_PROPAGATION Procedure, 58
- SCHEMAVALIDATE procedure, 197
- SCN_TO_TIMESTAMP function, 43
- SCRIPT function
-
- of HTF package, 134
- SCRIPT procedure
-
- of HTP package, 139
- SCRIPT_TUNING_TASK Function, 101
- SDO_CS package documentation, 149
- SDO_GCDR package documentation, 150
- SDO_GEOM package documentation, 151
- SDO_GEOR package documentation, 152
- SDO_GEOR_UTL package documentation, 153
- SDO_LRS package documentation, 154
- SDO_MIGRATE package documentation, 155
- SDO_NET package documentation, 156
- SDO_NET_MEM package documentation, 157
- SDO_SAM package documentation, 158
- SDO_TOPO package documentation, 159
- SDO_TOPO_MAP package documentation, 160
- SDO_TUNE package documentation, 161
- SDO_UTIL package documentation, 162
- security
-
- DBMS_LOGSTDBY package, 56
- SEED procedures, 75
- SEGMENT_CORRUPT procedure, 99
- SEGMENT_DROP_CORRUPT procedure, 99
- SEGMENT_DUMP procedure, 99
- SEGMENT_FIX_STATUS procedure, 79
- SEGMENT_VERIFY procedure, 99
- SELECT_CURSOR_CACHE Function, 101
- SELECT_OBJECT procedure, 176
- SELECT_SQLSET function, 101, 101
- SELECT_WORKLOAD_REPOSITORY functions, 101
- SELECTNODES function, 132
- SELECTSINGLENODE function, 132
- SELF_CHECK procedure, 30
- SEND procedure, 141, 172
- SEND_ATTACH_RAW procedure, 172
- SEND_ATTACH_VARCHAR2 procedure, 172
- SEND_MESSAGE function, 70
- SERV_MOD_ACT_STAT_DISABLE procedure, 60
- SERV_MOD_ACT_STAT_ENABLE procedure, 60
- SERV_MOD_ACT_TRACE_DISABLE procedure, 60
- SERV_MOD_ACT_TRACE_ENABLE procedure, 60
- SESSION _TRACE_DISABLE Procedure, 96
- SESSION _TRACE_ENABLE Procedur, 96
- SESSION_TRACE_DISABLE procedure, 60
- SESSION_TRACE_ENABLE procedure, 60
- SET* member procedures
-
- of ANYDATA TYPE, 181
- of ANYDATASET TYPE, 182
- SET_ACTION procedure, 14
- SET_AUTHENTICATION procedure, 168
- SET_AUTHORIZATION procedure, 146
- SET_BASE_TABLE_NAME member procedure, 188
- SET_BASE_TABLE_OWNER member procedure, 188
- SET_BODY_CHARSET procedures, 168, 168
- SET_BREAKPOINT function, 30
- SET_CLIENT_INFO procedure, 14
- SET_COLUMN_STATS procedures, 103
- SET_COMMAND_TYPE member procedure, 188
- SET_CONSUMER_GROUP_MAPPING procedure, 85
- SET_CONSUMER_GROUP_MAPPING_PRI procedure, 85
- SET_COOKIE_SUPPORT procedures, 168
- SET_CURRENT_SCHEMA member procedure, 188
- SET_DAD_ATTRIBUTE Procedure, 37
- SET_DDL_TEXT member procedure, 188
- SET_DEFAULT_SQLWKLD_PARAMETER Procedure, 12
- SET_DEFAULT_TASK_PARAMETER Procedures, 12
- SET_DEFAULTS procedure, 13
- SET_DETAILED_EXCP_SUPPORT procedure, 168
- SET_DML_HANDLER procedure, 15
- SET_ENQUEUE_DESTINATION procedure, 15
- SET_EXECUTE procedure, 15
- SET_EXTRA_ATTRIBUTE member procedure, 188
- SET_FOLLOW_REDIRECT procedures, 168
- SET_GLOBAL_ATTRIBUTE Function, 37
- SET_GLOBAL_INSTANTIATION procedure, 15
- SET_HEADER procedure, 168
- SET_INDEX_STATS procedures, 103
- SET_INITIAL_CONSUMER_GROUP procedure, 85
- SET_KEY_COLUMNS procedure, 15
- SET_LOB_INFORMATION member procedure, 188
- SET_LOB_OFFSET member procedure, 188
- SET_LOB_OPERATION_SIZE member procedure, 188
- SET_LOG_LEVEL Procedure, 58
- SET_LOGON_USER member procedure, 188
- SET_MAILHOST Procedure, 18
- SET_MAILPORT Procedure, 18
- SET_MESSAGE_NOTIFICATION procedure, 106
- SET_MODULE procedure, 14
- SET_OBJECT_NAME member procedure, 188
- SET_OBJECT_OWNER member procedure, 188
- SET_OBJECT_TYPE member procedure, 188
- SET_OER_BREAKPOINT function, 30
- SET_PARAM procedure, 103
- SET_PARAMETER procedure, 20
-
- apply process, 15
- SET_PERSISTENT_CONN_SUPPORT procedure, 168
- SET_PLSQL_TRACE procedure, 110
- SET_PROPERTY procedure, 165
- SET_PROTECTION_REALM procedure, 146
- SET_PROXY procedure, 168
- SET_RESPONSE_ERROR_CHECK procedure, 168
- SET_RULE_TRANSFORM_FUNCTION procedure, 106
- SET_SCHEMA_INSTANTIATION procedure, 15
- SET_SENDFROM Procedure, 18
- SET_SESSION_LONGOPS procedure, 14
- SET_SESSION_TIMEOUT procedure, 87
- SET_SOURCE_DATABASE_NAME member procedure, 188
- SET_SQLWKLD_PARAMETER Procedure, 12
- SET_SYSTEM_STATS procedure, 103
- SET_TABLE_INSTANTIATION procedure, 15
- SET_TABLE_STATS procedure, 103
- SET_TABLESPACE Subprogram, 56
- SET_TAG member procedure, 188
- SET_TAG procedure, 105
- SET_TASK_PARAMETER Procedure, 12
- SET_THRESHOLD procedure, 94
- SET_TIMEOUT function, 30
- SET_TIMEOUT procedure, 87
- SET_TIMEOUT_BEHAVIOUR procedure, 30
- SET_TRANSFER_TIMEOUT procedure, 168
- SET_TRIGGER_FIRING_PROPERTY procedure, 29
- SET_UP_QUEUE procedure, 106
- SET_UPDATE_CONFLICT_HANDLER procedure, 15
- SET_VALUE function, 30
- SET_VALUE member procedure, 188
- SET_VALUE_DEPENDENCY procedure, 15
- SET_VALUES member procedure, 188
- SET_WALLET procedure, 168
- SET_WARNING_SETTING_STRING procedure, 117
- SET_WATERMARK Procedure, 17
- SETACL procedure, 120
- SETATTRIBUTE procedure, 124
- SETATTRIBUTENODE function, 124
- SETBASEDIR procedure, 126
- SETBATCHSIZE procedure, 128
- SETBINDVALUE procedure, 127
- SETCOLLIDATTRNAME procedure, 127
- SETCOMMITBATCH procedure, 128
- SETCONVERTSPECIALCHARS procedure, 125
- SETDATA procedure, 124
- SETDATAHEADER procedure, 127
- SETDATEFORMAT procedure, 127, 128
- SETDCHARSET procedure, 124
- SETDOCTYPE Procedure, 124
- SETDOCTYPE procedure, 126
- SETDVERSION procedure, 124
- SETENCODINGTAG procedure, 127
- SETERRORLOG procedure, 126, 132
- SETERRORTAG procedure, 127
- SETFTPPORT Procedure, 120
- SETHTTPPORT Procedure, 120
- SETIGNORECASE procedure, 128
- SETINFO member procedure
-
- of ANYTYPE TYPE, 183
- SETKEYCOLUMN procedure, 128, 130
- SETMAXROWS procedure, 125, 127
- SETMETAHEADER procedure, 127
- SETNAMEDITEM function, 124
- SETNODEVALUE procedure, 124
- SETPARAM procedure, 132
- SETPREFIX procedure, 124
- SETPRESERVEWHITESPACE procedure, 126, 128
- SETRAISEEXCEPTION procedure, 127
- SETRAISENOROWSEXCEPTION procedure, 127
- SETROWIDATTRNAME procedure, 127
- SETROWIDATTRVALUE procedure, 127
- SETROWSETTAG procedure, 125, 127
- SETROWTAG procedure, 127, 128, 130
- SETSCHEMAVALIDATED procedure, 197
- SETSKIPROWS procedure, 125, 127
- SETSQLTOXMLNAMEESCAPING procedure, 127, 128
- SETSTANDALONE procedure, 124
- SETSTYLESHEETHEADER procedure, 127
- SETTAGCASE procedure, 127
- SETUPDATECOLUMN procedure, 128, 130
- SETVALIDATIONMODE procedure, 126
- SETVALUE procedure, 124
- SETXSLT procedure, 127, 128
- SETXSLTPARAM procedure, 127, 128
- SHOW_BREAKPOINTS procedures, 30
- SHOW_FRAME_SOURCE procedure, 30
- SHOW_SOURCE procedures, 30
- SHOWPAGE procedure, 148
- SHOWSOURCE procedure, 148
- SHOWWARNINGS procedure, 126, 132
- SHUTDOWN Procedure, 58
- SIGNAL procedure, 13
- SIGNATURE procedure, 148
- SIZES procedure, 97
- SKIP_CORRUPT_BLOCKS procedure, 79
- SLEEP procedure, 53
- SMALL function
-
- of HTF package, 134
- SMALL procedure
-
- of HTP package, 139
- snapshot. See DBMS_MVIEW, 61
- SOURCE_LINES_T Table Type, 71
- SPACE_ERROR_INFO function, 87
- SPACE_USAGE procedure, 98
- SPLITTEXT function, 124
- SQL Apply
-
- managing logical standby databases, 56
- managing with DBMS_LOGSTDBY package, 56
- SQL statements
-
- larger than 32 KB, 100
- SQL*Plus
-
- creating a sequence, 1
- SQLSET_ROW Object Type, 101
- SQLTEXT_TO_SIGNATURE Function, 101
- staging
-
- queues
-
- creating, 106
- removing, 106
- START_APPLY procedure, 15
- START_CAPTURE procedure, 20
- START_PROFILER functions and procedures, 73
- START_PROPAGATION procedure, 74
- START_REDEF_TABLE procedure, 77
- START_SERVICE procedure, 95
- STARTUP Procedure, 58
- STARTUP_EXTPROC_AGENT procedure, 133
- STATUS_LINE procedure, 148
- STEP_ID function, 111
- STOP_APPLY procedure, 15
- STOP_CAPTURE procedure, 20
- STOP_PROFILER function and procedure, 73
- STOP_PROPAGATION procedure, 74
- STOP_SERVICE procedure, 95
- STORE_VALUES procedure, 144
- stored outlines
-
- DBMS_OUTLN, 66
- OUTLN_PKG package, 66
- STREAM2MULTI procedure, 147
- Streams
-
- removing configuration, 106
- STREAMS$_TRANSFORM_FUNCTION, 106
- STRIKE function
-
- of HTF package, 134
- STRIKE procedure
-
- of HTP package, 139
- STRING function, 75
- STRING_TO_RAW Function, 169
- STRONG function
-
- of HTF package, 134
- STRONG procedure
-
- of HTP package, 139
- STYLE function
-
- of HTF package, 134
- STYLE procedure
-
- of HTP package, 139
- SUB procedure
-
- of HTP package, 139
- SUBMIT procedure, 48
- SUBMIT_PENDING_AREA procedure, 85
- subscribers
-
- drop the subscription, 22
- extend the window to create a new view, 22
- purging the subscription window, 22
- retrieve change data from the subscriber views, 22
- subscription window
-
- purging, 22
- SUBSTR function, 174
- SUBSTR Functions, 52
- SUBSTRINGDATA function, 124
- Summary of DBMS_AQELM Subprograms, 18
- Summary of DBMS_DIMENSION Subprograms, 35
- Summary of DBMS_ERRLOG Subprograms, 38
- Summary of DBMS_MVIEW Subprograms, 61
- Summary of DBMS_OLAP Subprograms, 65
- Summary of DBMS_PREDICTIVE_ANALYTICS Subprograms, 72
- Summary of DBMS_XDBZ Subprograms, 123
- Summary of DBMS_XMLDOM Subprograms, 124
- Summary of DBMS_XMLSCHEMA Subprograms, 129
- Summary of UTL_LMS Subprograms, 171
- SUMMARY procedure, 102
- SUP function
-
- of HTF package, 134
- SUP procedure
-
- of HTP package, 139
- SWITCH_CONSUMER_GROUP_FOR_SESS procedure, 85
- SWITCH_CONSUMER_GROUP_FOR_USER procedure, 85
- SWITCH_PLAN procedure, 85
- SYNC_INTERIM_TABLE procedure, 77
- SYNCHRONIZE function, 30
- SYS.MGW_MQSERIES_PROPERTIES Object Type, 58
- SYS.MGW_PROPERTIES Object Type, 58
- SYS.MGW_PROPERTY Object Type, 58
- SYS.MGW_TIBRV_PROPERTIES Object Type, 58
T
- table alias
-
- attributes, 186
- TABLE_TO_COMMA procedures, 116
- TABLECAPTION function
-
- of HTF package, 134
- TABLECAPTION procedure
-
- of HTP package, 139
- TABLECLOSE function
-
- of HTF package, 134
- TABLECLOSE procedure
-
- of HTP package, 139
- TABLEDATA function
-
- of HTF package, 134
- TABLEDATA procedure
-
- of HTP package, 139
- TABLEHEADER function
-
- of HTF package, 134
- TABLEHEADER procedure
-
- of HTP package, 139
- TABLEOPEN function
-
- of HTF package, 134
- TABLEOPEN procedure
-
- of HTP package, 139
- TABLEPRINT function, 148
- TABLEROWCLOSE function
-
- of HTF package, 134
- TABLEROWCLOSE procedure
-
- of HTP package, 139
- TABLEROWOPEN function
-
- of HTF package, 134
- TABLEROWOPEN procedure
-
- of HTP package, 139
- tables
-
- table items as arrays, 100, 100
- tablespace repositories
-
- attaching tablespaces, 109
- cloning tablespaces, 109
- detaching tablespaces, 109
- TABLESPACE_FIX_BITMAPS procedure, 99
- TABLESPACE_FIX_SEGMENT_STATES procedure, 99
- TABLESPACE_MIGRATE_FROM_LOCAL procedure, 99
- TABLESPACE_MIGRATE_TO_LOCAL procedure, 99
- TABLESPACE_REBUILD_BITMAPS procedure, 99
- TABLESPACE_REBUILD_QUOTAS procedure, 99
- TABLESPACE_RELOCATE_BITMAPS procedure, 99
- TABLESPACE_SET type, 109
- TABLESPACE_VERIFY procedure, 99
- tablespaces
-
- change tables and, 21
- tags
-
- GET_TAG function, 105
- SET_TAG procedure, 105
- TARGET_PROGRAM_RUNNING procedure, 30
- TELETYPE function
-
- of HTF package, 134
- TELETYPE procedure
-
- of HTP package, 139
- TERMINATE procedure, 75
- TEXT_DECODE function, 166
- TEXT_ENCODE function, 166
- TIMESTAMP_TO_SCN function, 43
- TITLE function
-
- of HTF package, 134, 134
- TITLE procedure
-
- of HTP package, 139
- TODATE function, 148
- TOOBJECT procedure, 197
- top-N frequency binning, 26
- TRACETAB.SQL, 110
- transform definition table, 26
- TRANSFORM function, 197
- transformations
-
- binning, 26
- equi-width binning, 26
- missing value treatment, 26
- normalization, 26
- rule-based
-
- adding a column, 106
- custom, 106
- deleting a column, 106
- renaming a column, 106
- renaming a schema, 106
- renaming a table, 106
- STREAMS$_TRANSFORM_FUNCTION, 106
- sample, 26
- steps in defining, 26
- supported, 26
- winsorizing, 26
- TRANSFORMNODE function, 132
- TRANSLATE function, 174
- TRANSLITERATE Function, 169
- TRANSPORT_SET_CHECK procedure, 114
- TRIM Procedures, 52
- trimming, 26
- TUNE_MVIEW Procedure, 12
- types
-
- Expression Filter, 186
- Rules Manager, 195
U
- ULISTCLOSE function
-
- of HTF package, 134
- ULISTCLOSE procedure
-
- of HTP package, 139
- ULISTOPEN function
-
- of HTF package, 134
- ULISTOPEN procedure
-
- of HTP package, 139
- UNASSIGN_ATTRIBUTE_SET procedure, 39
- UNCHECKOUT function, 121
- UNDERLINE function
-
- of HTF package, 134
- UNDERLINE procedure
-
- of HTP package, 139
- UNESCAPE function, 179
- UNESCAPEURI function, 185
- UNIFORM_DIST_FIT procedure, 102
- UNIQUE_SESSION_NAME function, 70
- UNKEEP procedure, 97
- UNLOCK_MAP procedure, 104
- UNLOCK_SCHEMA_STATS procedure, 103
- UNLOCK_TABLE_STATS procedure, 103
- UNLOCKRESOURCE function, 120
- UNMAP_DAD Procedure, 37
- UNPACK_MESSAGE procedures, 70
- UNPACK_STGTAB_SQLPROF Procedure, 101
- UNPACK_STGTAB_SQLSET Procedure, 101
- UNREGISTER_DEPENDENT_OBJECT procedure, 77
- UNREGISTER_FOREIGN_QUEUE Procedure, 58
- UNREGISTERURLHANDLER procedure, 185
- UNSCHEDULE_PROPAGATION Procedure, 58
- UNUSED_SPACE procedure, 98
- UPDATE_BY_CAT procedure, 66
- UPDATE_CONSUMER_GROUP procedure, 85
- UPDATE_OBJECT Procedure, 12
- UPDATE_OBJECT procedure, 176
- UPDATE_PLAN procedure, 85
- UPDATE_PLAN_DIRECTIVE procedure, 85
- UPDATE_REC_ATTRIBUTES Procedure, 12
- UPDATE_SIGNATURES procedure, 66
- UPDATE_SQLSET procedures, 101
- UPDATE_SQLWKLD_ATTRIBUTES Procedure, 12
- UPDATE_SQLWKLD_STATEMENT Procedure, 12
- UPDATE_TASK_ATTRIBUTES Procedure, 12
- UPDATERESOURCEMETADATA Procedures, 120
- UPDATEXML function, 128, 130
- UPGRADE_STAT_TABLE procedure, 103
- upgrading
-
- post-upgrade actions, 62
- URI Types
-
- description, 185
- UriFactory package, 185
-
- ESCAPEURI function, 185
- GETURL function, 185
- methods, 185
- REGISTERURLHANDLER procedure, 185
- UNESCAPEURI function, 185
- UNREGISTERURLHANDLER procedure, 185
- UriType supertype, 185
-
- GETBLOB function, 185
- GETCLOB function, 185
- GETCONTENTTYPE function, 185
- GETEXTERNALURL function, 185
- GETURL function, 185
- GETXML function, 185
- methods, 185
- USE_ROLLBACK_SEGMENT procedure, 111
- USEITEMTAGSFORCOLL procedure, 125
- USENULLATTRIBUTEINDICATOR procedure, 125, 127
- user views
-
- DBMS_DATA_MINING, 25
- USER_EXPORT procedures, 48
- USETYPEFORCOLLELEMTAG procedure, 127
- Using DBMS_ADVISOR, 12
- Using DBMS_AQIN, 19, 19
- Using DBMS_FILE_GROUP, 41
- Using DBMS_MVIEW, 61
- Using DBMS_PREDICTIVE_ANALYTICS, 72
- Using DBMS_RULE, 91
- Using DBMS_RULE_ADM, 92
- Using DBMS_STREAMS, 105
- Using DBMS_STREAMS_ADM, 106
- Using DBMS_STREAMS_TABLESPACE_ADM, 109
- Using DBMS_XMLDOM, 124
- Using DBMS_XMLSCHEMA, 129
- Using UTL_HTTP, 168
- UTL_COLL package, 163
- UTL_COMPRESS package, 164
- UTL_DBWS package, 165
- UTL_ENCODE package, 166
- UTL_FILE package, 167
- UTL_HTTP package, 168
- UTL_I18N package, 169
-
- ESCAPE_REFERENCE function, 169, 169, 169, 169, 169, 169, 169
- GET_DEFAULT_CHARSET function, 169
- MAP_CHARSET function, 169
- MAP_LANGUAGE_FROM_ISO function, 169
- MAP_LOCALE_TO_ISO function, 169
- MAP_TERRITORY_FROM_ISO function, 169
- RAW_TO_CHAR function, 169
- RAW_TO_NCHAR function, 169
- UNESCAPE_REFERENCE function, 169
- UTL_INADDR package, 170
- UTL_LMS package, 171
-
- FORMAT_MESSAGE function, 171
- GET_MESSAGE function, 171
- UTL_MAIL package, 172
- UTL_NLA package, 173
- UTL_RAW package, 174
- UTL_RECOMP package, 175
- UTL_REF package, 176
- UTL_TCP package, 178
- UTL_URL package, 179
- UUDECODE function, 166
- UUENCODE function, 166
V
- v$vpd_policies, 89
- VALIDATE procedure, 116
- VALIDATE_DIMENSION procedure, 35
- VALIDATE_EXPRESSIONS procedure, 39
- VALIDATE_PENDING_AREA procedure, 85
- VALIDATE_REWRITE_EQUIVALENCE Procedure, 11
- VALUE functions, 75
- VALUEOF procedure, 132
- VARIABLE function
-
- of HTF package, 134
- VARIABLE procedure
-
- of HTP package, 139
- VARIABLE_VALUE procedures, 100
- VERIFY_VALUES function, 144
- views
-
- summary, 58
- virtual dependency definitions
-
- object dependencies
-
- creating, 15
- dropping, 15
- value dependencies, 15
- Virtual Private Database. See VPD
- VPD
-
- column masking, 89
- enabling column-level, 89
- viewing current cursors and policy predicates, 89
- VPD use of DBMS_RLS, 89
- VRFY function, 177
W
- WAITANY procedure, 13
- WAITONE procedure, 13
- WBR function
-
- of HTF package, 134
- WBR procedure
-
- of HTP package, 139
- WEIBULL_DIST_FIT procedure, 102
- WHAT procedure, 48
- WHO_CALLED_ME procedure, 148
- winsorizing, 26
- WPG_DOCLOAD package, 180
- WRAP Functions, 29
- WRITE Procedures, 52
- WRITE_DATA procedure, 177
- WRITE_LINE function, 178
- WRITE_LINE procedure, 168
- WRITE_RAW function, 178
- WRITE_RAW procedure, 168
- WRITE_RAW_DATA procedure, 177
- WRITE_TEXT function, 178
- WRITE_TEXT procedure, 168
- WRITEAPPEND Procedures, 52
- WRITETOBUFFER procedure, 124
- WRITETOCLOB procedure, 124
- WRITETOFILE procedure, 124
X
- XDBUriType, 185
- XDBURITYPE function, 185
- XDBUriType subtype, 185
-
- CREATEURI function, 185
- GETBLOB function, 185
- GETCLOB function, 185
- GETCONTENTTYPE function, 185
- GETEXTERNALURL function, 185
- GETURL function, 185
- GETXML function, 185
- methods, 185
- XDBURITYPE function, 185
- XDBZ Constants, 123
- XFORM_BIN_CAT procedure, 26
- XFORM_BIN_NUM procedure, 26
- XFORM_CLIP procedure, 26
- XFORM_MISS_CAT procedure, 26
- XFORM_MISS_NUM procedure, 26
- XFORM_NORM_LIN procedure, 26
- XML tags
-
- specifying list of
-
- configuring index parameters, 186
- XML_TO_LCR Function, 59
- XMLType
-
- CREATENONSCHEMABASEDXML function, 197
- CREATESCHEMABASEDXML function, 197
- CREATEXML function, 197
- description, 197
- EXISTSNODE function, 197
- EXTRACT function, 197
- GETBLOBVAL function, 197
- GETCLOBVAL function, 197
- GETNUMBERVAL function, 197
- GETROOTELEMENT function, 197
- GETSCHEMAURL function, 197
- GETSTRINGVAL function, 197
- ISFRAGMENT function, 197
- ISSCHEMABASED function, 197
- ISSCHEMAVALID function, 197
- ISSCHEMAVALIDATED function, 197
- NAMESPACE function, 197
- SCHEMAVALIDATE procedure, 197
- SETSCHEMAVALIDATED procedure, 197
- TOOBJECT procedure, 197
- TRANSFORM function, 197
- XMLTYPE function, 197
- XMLTYPE function, 197
- XPath parameters
-
- adding to attribute list, 39
- dropping from attribute list, 39
- XPath predicates
-
- indexing set of
-
- configuring XML element or XML attribute, 186
- XPINDEX_PARAMETERS procedure, 39
- XRANGE function, 174
Z
- z-score normalization, 26