Database PL/SQL Packages and Types Reference
http://docs.oracle.com/cd/B19306_01/appdev.102/b14258/toc.htm
Contents
List of Figures
List of Tables
Title and Copyright Information
Send Us Your Comments
Preface
What's New in PL/SQL Packages and Types Reference?
1 Introduction
2 CTX_ADM
3 CTX_CLS
4 CTX_DDL
5 CTX_DOC
6 CTX_OUTPUT
7 CTX_QUERY
8 CTX_REPORT
9 CTX_THES
10 CTX_ULEXER
11 DBMS_ADVANCED_REWRITE
12 DBMS_ADVISOR
- Using DBMS_ADVISOR
- Summary of DBMS_ADVISOR Subprograms
- ADD_SQLWKLD_REF Procedure
- ADD_SQLWKLD_STATEMENT Procedure
- CANCEL_TASK Procedure
- CREATE_FILE Procedure
- CREATE_OBJECT Procedure
- CREATE_SQLWKLD Procedure
- CREATE_TASK Procedures
- DELETE_SQLWKLD Procedure
- DELETE_SQLWKLD_REF Procedure
- DELETE_SQLWKLD_STATEMENT Procedure
- DELETE_TASK Procedure
- EXECUTE_TASK Procedure
- GET_REC_ATTRIBUTES Procedure
- GET_TASK_REPORT Function
- GET_TASK_SCRIPT Function
- IMPLEMENT_TASK Procedure
- IMPORT_SQLWKLD_SCHEMA Procedure
- IMPORT_SQLWKLD_SQLCACHE Procedure
- IMPORT_SQLWKLD_STS Procedure
- IMPORT_SQLWKLD_SUMADV Procedure
- IMPORT_SQLWKLD_USER Procedure
- INTERRUPT_TASK Procedure
- MARK_RECOMMENDATION Procedure
- QUICK_TUNE Procedure
- RESET_SQLWKLD Procedure
- RESET_TASK Procedure
- SET_DEFAULT_SQLWKLD_PARAMETER Procedure
- SET_DEFAULT_TASK_PARAMETER Procedures
- SET_SQLWKLD_PARAMETER Procedure
- SET_TASK_PARAMETER Procedure
- TUNE_MVIEW Procedure
- UPDATE_OBJECT Procedure
- UPDATE_REC_ATTRIBUTES Procedure
- UPDATE_SQLWKLD_ATTRIBUTES Procedure
- UPDATE_SQLWKLD_STATEMENT Procedure
- UPDATE_TASK_ATTRIBUTES Procedure
13 DBMS_ALERT
14 DBMS_APPLICATION_INFO
15 DBMS_APPLY_ADM
- Summary of DBMS_APPLY_ADM Subprograms
- ALTER_APPLY Procedure
- COMPARE_OLD_VALUES Procedure
- CREATE_APPLY Procedure
- CREATE_OBJECT_DEPENDENCY Procedure
- DELETE_ALL_ERRORS Procedure
- DELETE_ERROR Procedure
- DROP_APPLY Procedure
- DROP_OBJECT_DEPENDENCY
- EXECUTE_ALL_ERRORS Procedure
- EXECUTE_ERROR Procedure
- GET_ERROR_MESSAGE Function
- SET_DML_HANDLER Procedure
- SET_ENQUEUE_DESTINATION Procedure
- SET_EXECUTE Procedure
- SET_GLOBAL_INSTANTIATION_SCN Procedure
- SET_KEY_COLUMNS Procedures
- SET_PARAMETER Procedure
- SET_SCHEMA_INSTANTIATION_SCN Procedure
- SET_TABLE_INSTANTIATION_SCN Procedure
- SET_UPDATE_CONFLICT_HANDLER Procedure
- SET_VALUE_DEPENDENCY Procedure
- START_APPLY Procedure
- STOP_APPLY Procedure
16 DBMS_AQ
17 DBMS_AQADM
- Using DBMS_AQADM
- Subprogram Groups
- Summary of DBMS_AQADM Subprograms
- ADD_ALIAS_TO_LDAP Procedure
- ADD_SUBSCRIBER Procedure
- ALTER_AQ_AGENT Procedure
- ALTER_PROPAGATION_SCHEDULE Procedure
- ALTER_QUEUE Procedure
- ALTER_QUEUE_TABLE Procedure
- ALTER_SUBSCRIBER Procedure
- CREATE_AQ_AGENT Procedure
- CREATE_NP_QUEUE Procedure
- CREATE_QUEUE Procedure
- CREATE_QUEUE_TABLE Procedure
- DEL_ALIAS_FROM_LDAP Procedure
- DISABLE_DB_ACCESS Procedure
- DISABLE_PROPAGATION_SCHEDULE Procedure
- DROP_AQ_AGENT Procedure
- DROP_QUEUE Procedure
- DROP_QUEUE_TABLE Procedure
- ENABLE_DB_ACCESS Procedure
- ENABLE_JMS_TYPES Procedure
- ENABLE_PROPAGATION_SCHEDULE Procedure
- GET_WATERMARK Procedure
- GRANT_QUEUE_PRIVILEGE Procedure
- GRANT_SYSTEM_PRIVILEGE Procedure
- MIGRATE_QUEUE_TABLE Procedure
- PURGE_QUEUE_TABLE Procedure
- QUEUE_SUBSCRIBERS Function
- REMOVE_SUBSCRIBER Procedure
- REVOKE_QUEUE_PRIVILEGE Procedure
- REVOKE_SYSTEM_PRIVILEGE Procedure
- SCHEDULE_PROPAGATION Procedure
- SET_WATERMARK Procedure
- START_QUEUE Procedure
- STOP_QUEUE Procedure
- UNSCHEDULE_PROPAGATION Procedure
- VERIFY_QUEUE_TYPES Procedure
18 DBMS_AQELM
19 DBMS_AQIN
20 DBMS_CAPTURE_ADM
- Summary of DBMS_CAPTURE_ADM Subprograms
- ABORT_GLOBAL_INSTANTIATION Procedure
- ABORT_SCHEMA_INSTANTIATION Procedure
- ABORT_TABLE_INSTANTIATION Procedure
- ALTER_CAPTURE Procedure
- BUILD Procedure
- CREATE_CAPTURE Procedure
- DROP_CAPTURE Procedure
- INCLUDE_EXTRA_ATTRIBUTE Procedure
- PREPARE_GLOBAL_INSTANTIATION Procedure
- PREPARE_SCHEMA_INSTANTIATION Procedure
- PREPARE_TABLE_INSTANTIATION Procedure
- SET_PARAMETER Procedure
- START_CAPTURE Procedure
- STOP_CAPTURE Procedure
21 DBMS_CDC_PUBLISH
- Using DBMS_CDC_PUBLISH
- Summary of DBMS_CDC_PUBLISH Subprograms
- ALTER_AUTOLOG_CHANGE_SOURCE Procedure
- ALTER_CHANGE_SET Procedure
- ALTER_CHANGE_TABLE Procedure
- ALTER_HOTLOG_CHANGE_SOURCE Procedure
- CREATE_AUTOLOG_CHANGE_SOURCE Procedure
- CREATE_CHANGE_SET Procedure
- CREATE_CHANGE_TABLE Procedure
- CREATE_HOTLOG_CHANGE_SOURCE Procedure
- DROP_CHANGE_SET Procedure
- DROP_CHANGE_SOURCE Procedure
- DROP_CHANGE_TABLE Procedure
- DROP_SUBSCRIPTION Procedure
- PURGE Procedure
- PURGE_CHANGE_SET Procedure
- PURGE_CHANGE_TABLE Procedure
22 DBMS_CDC_SUBSCRIBE
23 DBMS_CHANGE_NOTIFICATION
24 DBMS_CRYPTO
25 DBMS_DATA_MINING
- Using DBMS_DATA_MINING
- Summary of DBMS_DATA_MINING Subprograms
- APPLY Procedure
- COMPUTE_CONFUSION_MATRIX Procedure
- COMPUTE_LIFT Procedure
- COMPUTE_ROC Procedure
- CREATE_MODEL Procedure
- DROP_MODEL Procedure
- EXPORT_MODEL Procedure
- GET_ASSOCIATION_RULES Function
- GET_DEFAULT_SETTINGS Function
- GET_FREQUENT_ITEMSETS Function
- GET_MODEL_DETAILS_ABN Function
- GET_MODEL_DETAILS_AI Function
- GET_MODEL_DETAILS_KM Function
- GET_MODEL_DETAILS_NB Function
- GET_MODEL_DETAILS_NMF Function
- GET_MODEL_DETAILS_OC Function
- GET_MODEL_DETAILS_SVM Function
- GET_MODEL_DETAILS_XML Function
- GET_MODEL_SETTINGS Function
- GET_MODEL_SIGNATURE Function
- IMPORT_MODEL Procedure
- RANK_APPLY Procedure
- RENAME_MODEL Procedure
26 DBMS_DATA_MINING_TRANSFORM
- Using DBMS_DATA_MINING_TRANSFORM
- Summary of DBMS_DATA_MINING_TRANSFORM Subprograms
- CREATE_BIN_CAT Procedure
- CREATE_BIN_NUM Procedure
- CREATE_CLIP Procedure
- CREATE_MISS_CAT Procedure
- CREATE_MISS_NUM Procedure
- CREATE_NORM_LIN Procedure
- INSERT_AUTOBIN_NUM_EQWIDTH Procedure
- INSERT_BIN_CAT_FREQ Procedure
- INSERT_BIN_NUM_EQWIDTH Procedure
- INSERT_BIN_NUM_QTILE Procedure
- INSERT_CLIP_TRIM_TAIL Procedure
- INSERT_CLIP_WINSOR_TAIL Procedure
- INSERT_MISS_CAT_MODE Procedure
- INSERT_MISS_NUM_MEAN Procedure
- INSERT_NORM_LIN_MINMAX Procedure
- INSERT_NORM_LIN_SCALE Procedure
- INSERT_NORM_LIN_ZSCORE Procedure
- XFORM_BIN_CAT Procedure
- XFORM_BIN_NUM Procedure
- XFORM_CLIP Procedure
- XFORM_MISS_CAT Procedure
- XFORM_MISS_NUM Procedure
- XFORM_NORM_LIN Procedure
27 DBMS_DATAPUMP
- Using DBMS_DATAPUMP
- Data Structures
- Summary of DBMS_DATAPUMP Subprograms
- ADD_FILE Procedure
- ATTACH Function
- DATA_FILTER Procedures
- DETACH Procedure
- GET_DUMPFILE_INFO Procedure
- GET_STATUS Procedure
- LOG_ENTRY Procedure
- METADATA_FILTER Procedure
- METADATA_REMAP Procedure
- METADATA_TRANSFORM Procedure
- OPEN Function
- SET_PARALLEL Procedure
- SET_PARAMETER Procedures
- START_JOB Procedure
- STOP_JOB Procedure
- WAIT_FOR_JOB Procedure
28 DBMS_DB_VERSION
29 DBMS_DDL
30 DBMS_DEBUG
- Using DBMS_DEBUG
- Data Structures
- Summary of DBMS_DEBUG Subprograms
- ATTACH_SESSION Procedure
- CONTINUE Function
- DEBUG_OFF Procedure
- DEBUG_ON Procedure
- DELETE_BREAKPOINT Function
- DELETE_OER_BREAKPOINT Function
- DETACH_SESSION Procedure
- DISABLE_BREAKPOINT Function
- ENABLE_BREAKPOINT Function
- EXECUTE Procedure
- GET_INDEXES Function
- GET_MORE_SOURCE Procedure
- GET_LINE_MAP Function
- GET_RUNTIME_INFO Function
- GET_TIMEOUT_BEHAVIOUR Function
- GET_VALUE Function
- INITIALIZE Function
- PING Procedure
- PRINT_BACKTRACE Procedure
- PRINT_INSTANTIATIONS Procedure
- PROBE_VERSION Procedure
- SELF_CHECK Procedure
- SET_BREAKPOINT Function
- SET_OER_BREAKPOINT Function
- SET_TIMEOUT Function
- SET_TIMEOUT_BEHAVIOUR Procedure
- SET_VALUE Function
- SHOW_BREAKPOINTS Procedures
- SHOW_FRAME_SOURCE Procedure
- SHOW_SOURCE Procedures
- SYNCHRONIZE Function
- TARGET_PROGRAM_RUNNING Procedure
31 DBMS_DEFER
32 DBMS_DEFER_QUERY
33 DBMS_DEFER_SYS
34 DBMS_DESCRIBE
35 DBMS_DIMENSION
36 DBMS_DISTRIBUTED_TRUST_ADMIN
37 DBMS_EPG
- Using DBMS_EPG
- Data Structures
- Subprogram Groups
- Summary of DBMS_EPG Subprograms
- AUTHORIZE_DAD Procedure
- CREATE_DAD Procedure
- DEAUTHORIZE_DAD Procedure
- DELETE_DAD_ATTRIBUTE Procedure
- DELETE_GLOBAL_ATTRIBUTE Procedure
- DROP_DAD Procedure
- GET_ALL_DAD_ATTRIBUTES Procedure
- GET_ALL_DAD_MAPPINGS Procedure
- GET_ALL_GLOBAL_ATTRIBUTES Procedure
- GET_DAD_ATTRIBUTE Function
- GET_DAD_LIST Procedure
- GET_GLOBAL_ATTRIBUTE Function
- MAP_DAD Procedure
- SET_DAD_ATTRIBUTE Procedure
- SET_GLOBAL_ATTRIBUTE Procedure
- UNMAP_DAD Procedure
38 DBMS_ERRLOG
39 DBMS_EXPFIL
- Summary of Expression Filter Subprograms
- ADD_ELEMENTARY_ATTRIBUTE Procedures
- ADD_FUNCTIONS Procedure
- ASSIGN_ATTRIBUTE_SET Procedure
- BUILD_EXCEPTIONS_TABLE Procedure
- CLEAR_EXPRSET_STATS Procedure
- COPY_ATTRIBUTE_SET Procedure
- CREATE_ATTRIBUTE_SET Procedure
- DEFAULT_INDEX_PARAMETERS Procedure
- DEFAULT_XPINDEX_PARAMETERS Procedure
- DEFRAG_INDEX Procedure
- DROP_ATTRIBUTE_SET Procedure
- GET_EXPRSET_STATS Procedure
- GRANT_PRIVILEGE Procedure
- INDEX_PARAMETERS Procedure
- MODIFY_OPERATOR_LIST Procedure
- REVOKE_PRIVILEGE Procedure
- UNASSIGN_ATTRIBUTE_SET Procedure
- VALIDATE_EXPRESSIONS Procedure
- XPINDEX_PARAMETERS Procedure
40 DBMS_FGA
41 DBMS_FILE_GROUP
- Using DBMS_FILE_GROUP
- Summary of DBMS_FILE_GROUP Subprograms
- ADD_FILE Procedure
- ALTER_FILE Procedure
- ALTER_FILE_GROUP Procedure
- ALTER_VERSION Procedure
- CREATE_FILE_GROUP Procedure
- CREATE_VERSION Procedure
- DROP_FILE_GROUP Procedure
- DROP_VERSION Procedure
- GRANT_OBJECT_PRIVILEGE Procedure
- GRANT_SYSTEM_PRIVILEGE Procedure
- PURGE_FILE_GROUP Procedure
- REMOVE_FILE Procedure
- REVOKE_OBJECT_PRIVILEGE Procedure
- REVOKE_SYSTEM_PRIVILEGE Procedure
42 DBMS_FILE_TRANSFER
43 DBMS_FLASHBACK
44 DBMS_FREQUENT_ITEMSET
45 DBMS_HS_PASSTHROUGH
- Summary of DBMS_HS_PASSTHROUGH Subprograms
- BIND_INOUT_VARIABLE Procedure
- BIND_INOUT_VARIABLE_RAW Procedure
- BIND_OUT_VARIABLE Procedure
- BIND_OUT_VARIABLE_RAW Procedure
- BIND_VARIABLE Procedure
- BIND_VARIABLE_RAW Procedure
- CLOSE_CURSOR Procedure
- EXECUTE_IMMEDIATE Procedure
- EXECUTE_NON_QUERY Function
- FETCH_ROW Function
- GET_VALUE Procedure
- GET_VALUE_RAW Procedure
- OPEN_CURSOR Function
- PARSE Procedure
46 DBMS_IOT
47 DBMS_JAVA
48 DBMS_JOB
49 DBMS_LDAP
50 DBMS_LDAP_UTL
51 DBMS_LIBCACHE
52 DBMS_LOB
- Using DBMS_LOB
- Summary of DBMS_LOB Subprograms
- APPEND Procedures
- CLOSE Procedure
- COMPARE Functions
- CONVERTTOBLOB Procedure
- CONVERTTOCLOB Procedure
- COPY Procedures
- CREATETEMPORARY Procedures
- ERASE Procedures
- FILECLOSE Procedure
- FILECLOSEALL Procedure
- FILEEXISTS Function
- FILEGETNAME Procedure
- FILEISOPEN Function
- FILEOPEN Procedure
- FREETEMPORARY Procedures
- GET_STORAGE_LIMIT
- GETCHUNKSIZE Functions
- GETLENGTH Functions
- INSTR Functions
- ISOPEN Functions
- ISTEMPORARY Functions
- LOADBLOBFROMFILE Procedure
- LOADCLOBFROMFILE Procedure
- LOADFROMFILE Procedure
- OPEN Procedures
- READ Procedures
- SUBSTR Functions
- TRIM Procedures
- WRITE Procedures
- WRITEAPPEND Procedures
53 DBMS_LOCK
54 DBMS_LOGMNR
55 DBMS_LOGMNR_D
56 DBMS_LOGSTDBY
- Using DBMS_LOGSTDBY
- Summary of DBMS_LOGSTDBY Subprograms
- APPLY_SET Procedure
- APPLY_UNSET Procedure
- BUILD Procedure
- INSTANTIATE_TABLE Procedure
- PREPARE_FOR_NEW_PRIMARY Procedure
- PURGE_SESSION Procedure
- REBUILD Procedure
- SET_TABLESPACE Procedure
- SKIP Procedure
- SKIP_ERROR Procedure
- SKIP_TRANSACTION Procedure
- UNSKIP Procedure
- UNSKIP_ERROR Procedure
- UNSKIP_TRANSACTION Procedure
57 DBMS_METADATA
- Using DBMS_METADATA
- Data Structures - Object and Table Types
- Subprogram Groupings
- Summary of All DBMS_METADATA Subprograms
58 DBMS_MGWADM
- Using DBMS_MGWADM
- Data Structures
- Summary of DBMS_MGWADM Subprograms
- ADD_SUBSCRIBER Procedure
- ALTER_AGENT Procedure
- ALTER_MSGSYSTEM_LINK Procedure for TIB/Rendezvous
- ALTER_MSGSYSTEM_LINK Procedure for WebSphere MQ
- ALTER_PROPAGATION_SCHEDULE Procedure
- ALTER_SUBSCRIBER Procedure
- CLEANUP_GATEWAY Procedure
- CREATE_MSGSYSTEM_LINK Procedure for TIB/Rendezvous
- CREATE_MSGSYSTEM_LINK Procedure for WebSphere MQ
- DB_CONNECT_INFO Procedure
- DISABLE_PROPAGATION_SCHEDULE Procedure
- ENABLE_PROPAGATION_SCHEDULE Procedure
- REGISTER_FOREIGN_QUEUE Procedure
- REMOVE_MSGSYSTEM_LINK Procedure
- REMOVE_SUBSCRIBER Procedure
- RESET_SUBSCRIBER Procedure
- SCHEDULE_PROPAGATION Procedure
- SET_LOG_LEVEL Procedure
- SHUTDOWN Procedure
- STARTUP Procedure
- UNREGISTER_FOREIGN_QUEUE Procedure
- UNSCHEDULE_PROPAGATION Procedure
59 DBMS_MGWMSG
- Using DBMS_MGWMSG
- Summary of DBMS_MGWMSG Subprograms
- LCR_TO_XML Function
- NVARRAY_ADD Procedure
- NVARRAY_FIND_NAME Function
- NVARRAY_FIND_NAME_TYPE Function
- NVARRAY_GET Function
- NVARRAY_GET_BOOLEAN Function
- NVARRAY_GET_BYTE Function
- NVARRAY_GET_DATE Function
- NVARRAY_GET_DOUBLE Function
- NVARRAY_GET_FLOAT Function
- NVARRAY_GET_INTEGER Function
- NVARRAY_GET_LONG Function
- NVARRAY_GET_RAW Function
- NVARRAY_GET_SHORT Function
- NVARRAY_GET_TEXT Function
- XML_TO_LCR Function
60 DBMS_MONITOR
- Summary of DBMS_MONITOR Subprograms
- CLIENT_ID_STAT_DISABLE Procedure
- CLIENT_ID_STAT_ENABLE Procedure
- CLIENT_ID_TRACE_DISABLE Procedure
- CLIENT_ID_TRACE_ENABLE Procedure
- DATABASE_TRACE_DISABLE Procedure
- DATABASE_TRACE_ENABLE Procedure
- SERV_MOD_ACT_STAT_DISABLE Procedure
- SERV_MOD_ACT_STAT_ENABLE Procedure
- SERV_MOD_ACT_TRACE_DISABLE Procedure
- SERV_MOD_ACT_TRACE_ENABLE Procedure
- SESSION_TRACE_DISABLE Procedure
- SESSION_TRACE_ENABLE Procedure
61 DBMS_MVIEW
- Using DBMS_MVIEW
- Summary of DBMS_MVIEW Subprograms
- BEGIN_TABLE_REORGANIZATION Procedure
- END_TABLE_REORGANIZATION Procedure
- ESTIMATE_MVIEW_SIZE Procedure
- EXPLAIN_MVIEW Procedure
- EXPLAIN_REWRITE Procedure
- I_AM_A_REFRESH Function
- PMARKER Function
- PURGE_DIRECT_LOAD_LOG Procedure
- PURGE_LOG Procedure
- PURGE_MVIEW_FROM_LOG Procedure
- REFRESH Procedures
- REFRESH_ALL_MVIEWS Procedure
- REFRESH_DEPENDENT Procedures
- REGISTER_MVIEW Procedure
- UNREGISTER_MVIEW Procedure
62 DBMS_OBFUSCATION_TOOLKIT
63 DBMS_ODCI
64 DBMS_OFFLINE_OG
65 DBMS_OLAP
- Using DBMS_OLAP
- Summary of DBMS_OLAP Subprograms
- ADD_FILTER_ITEM Procedure
- CREATE_ID Procedure
- ESTIMATE_MVIEW_SIZE Procedure
- EVALUATE_MVIEW_STRATEGY Procedure
- GENERATE_MVIEW_REPORT Procedure
- GENERATE_MVIEW_SCRIPT Procedure
- LOAD_WORKLOAD_CACHE Procedure
- LOAD_WORKLOAD_TRACE Procedure
- LOAD_WORKLOAD_USER Procedure
- PURGE_FILTER Procedure
- PURGE_RESULTS Procedure
- PURGE_WORKLOAD Procedure
- RECOMMEND_MVIEW_STRATEGY Procedure
- SET_CANCELLED Procedure
- VALIDATE_DIMENSION Procedure
- VALIDATE_WORKLOAD_CACHE Procedure
- VALIDATE_WORKLOAD_TRACE Procedure
- VALIDATE_WORKLOAD_USER Procedure
66 DBMS_OUTLN
67 DBMS_OUTLN_EDIT
68 DBMS_OUTPUT
69 DBMS_PCLXUTIL
70 DBMS_PIPE
71 DBMS_PREPROCESSOR
72 DBMS_PREDICTIVE_ANALYTICS
73 DBMS_PROFILER
74 DBMS_PROPAGATION_ADM
75 DBMS_RANDOM
76 DBMS_RECTIFIER_DIFF
77 DBMS_REDEFINITION
78 DBMS_REFRESH
79 DBMS_REPAIR
80 DBMS_REPCAT
81 DBMS_REPCAT_ADMIN
82 DBMS_REPCAT_INSTANTIATE
83 DBMS_REPCAT_RGT
84 DBMS_REPUTIL
85 DBMS_RESOURCE_MANAGER
- Using DBMS_RESOURCE_MANAGER
- Summary of DBMS_RESOURCE_MANAGER Subprograms
- CLEAR_PENDING_AREA Procedure
- CREATE_CONSUMER_GROUP Procedure
- CREATE_PENDING_AREA Procedure
- CREATE_PLAN Procedure
- CREATE_PLAN_DIRECTIVE Procedure
- CREATE_SIMPLE_PLAN Procedure
- DELETE_CONSUMER_GROUP Procedure
- DELETE_PLAN Procedure
- DELETE_PLAN_CASCADE Procedure
- DELETE_PLAN_DIRECTIVE Procedure
- SET_CONSUMER_GROUP_MAPPING Procedure
- SET_CONSUMER_GROUP_MAPPING_PRI Procedure
- SET_INITIAL_CONSUMER_GROUP Procedure
- SUBMIT_PENDING_AREA Procedure
- SWITCH_CONSUMER_GROUP_FOR_SESS Procedure
- SWITCH_CONSUMER_GROUP_FOR_USER Procedure
- SWITCH_PLAN Procedure
- UPDATE_CONSUMER_GROUP Procedure
- UPDATE_PLAN Procedure
- UPDATE_PLAN_DIRECTIVE Procedure
- VALIDATE_PENDING_AREA Procedure
86 DBMS_RESOURCE_MANAGER_PRIVS
87 DBMS_RESUMABLE
88 DBMS_RLMGR
- Summary of Rules Manager Subprograms
- ADD_ELEMENTARY_ATTRIBUTE Procedures
- ADD_EVENT Procedures
- ADD_FUNCTIONS Procedure
- ADD_RULE Procedure
- CONSUME_EVENT Function
- CONSUME_PRIM_EVENTS Function
- CREATE_EVENT_STRUCTURE Procedure
- CREATE_RULE_CLASS Procedure
- DELETE_RULE Procedure
- DROP_EVENT_STRUCTURE Procedure
- DROP_RULE_CLASS Procedure
- GRANT_PRIVILEGE Procedure
- PROCESS_RULES Procedure
- RESET_SESSION Procedure
- REVOKE_PRIVILEGE Procedure
89 DBMS_RLS
- Using DBMS_RLS
- Summary of DBMS_RLS Subprograms
- ADD_GROUPED_POLICY Procedure
- ADD_POLICY Procedure
- ADD_POLICY_CONTEXT Procedure
- CREATE_POLICY_GROUP Procedure
- DELETE_POLICY_GROUP Procedure
- DISABLE_GROUPED_POLICY Procedure
- DROP_GROUPED_POLICY Procedure
- DROP_POLICY Procedure
- DROP_POLICY_CONTEXT Procedure
- ENABLE_GROUPED_POLICY Procedure
- ENABLE_POLICY Procedure
- REFRESH_GROUPED_POLICY Procedure
- REFRESH_POLICY Procedure
90 DBMS_ROWID
91 DBMS_RULE
92 DBMS_RULE_ADM
- Using DBMS_RULE_ADM
- Summary of DBMS_RULE_ADM Subprograms
- ADD_RULE Procedure
- ALTER_EVALUATION_CONTEXT Procedure
- ALTER_RULE Procedure
- CREATE_EVALUATION_CONTEXT Procedure
- CREATE_RULE Procedure
- CREATE_RULE_SET Procedure
- DROP_EVALUATION_CONTEXT Procedure
- DROP_RULE Procedure
- DROP_RULE_SET Procedure
- GRANT_OBJECT_PRIVILEGE Procedure
- GRANT_SYSTEM_PRIVILEGE Procedure
- REMOVE_RULE Procedure
- REVOKE_OBJECT_PRIVILEGE Procedure
- REVOKE_SYSTEM_PRIVILEGE Procedure
93 DBMS_SCHEDULER
- Using DBMS_SCHEDULER
- Summary of DBMS_SCHEDULER Subprograms
- ADD_EVENT_QUEUE_SUBSCRIBER Procedure
- ADD_WINDOW_GROUP_MEMBER Procedure
- ALTER_CHAIN Procedure
- ALTER_RUNNING_CHAIN Procedure
- CLOSE_WINDOW Procedure
- COPY_JOB Procedure
- CREATE_CHAIN Procedure
- CREATE_EVENT_SCHEDULE Procedure
- CREATE_JOB Procedures
- CREATE_JOB_CLASS Procedure
- CREATE_PROGRAM Procedure
- CREATE_SCHEDULE Procedure
- CREATE_WINDOW Procedures
- CREATE_WINDOW_GROUP Procedure
- DEFINE_ANYDATA_ARGUMENT Procedure
- DEFINE_CHAIN_EVENT_STEP Procedure
- DEFINE_CHAIN_RULE Procedure
- DEFINE_CHAIN_STEP Procedure
- DEFINE_METADATA_ARGUMENT Procedure
- DEFINE_PROGRAM_ARGUMENT Procedures
- DISABLE Procedure
- DROP_CHAIN Procedure
- DROP_CHAIN_RULE Procedure
- DROP_CHAIN_STEP Procedure
- DROP_JOB Procedure
- DROP_JOB_CLASS Procedure
- DROP_PROGRAM Procedure
- DROP_PROGRAM_ARGUMENT Procedures
- DROP_SCHEDULE Procedure
- DROP_WINDOW Procedure
- DROP_WINDOW_GROUP Procedure
- ENABLE Procedure
- EVALUATE_CALENDAR_STRING Procedure
- EVALUATE_RUNNING_CHAIN Procedure
- GENERATE_JOB_NAME Function
- GET_ATTRIBUTE Procedure
- GET_SCHEDULER_ATTRIBUTE Procedure
- OPEN_WINDOW Procedure
- PURGE_LOG Procedure
- REMOVE_EVENT_QUEUE_SUBSCRIBER Procedure
- REMOVE_WINDOW_GROUP_MEMBER Procedure
- RESET_JOB_ARGUMENT_VALUE Procedures
- RUN_CHAIN Procedures
- RUN_JOB Procedure
- SET_ATTRIBUTE Procedure
- SET_ATTRIBUTE_NULL Procedure
- SET_JOB_ANYDATA_VALUE Procedures
- SET_JOB_ARGUMENT_VALUE Procedures
- SET_SCHEDULER_ATTRIBUTE Procedure
- STOP_JOB Procedure
94 DBMS_SERVER_ALERT
95 DBMS_SERVICE
96 DBMS_SESSION
- Using DBMS_SESSION
- Summary of DBMS_SESSION Subprograms
- CLEAR_ALL_CONTEXT Procedure
- CLEAR_CONTEXT Procedure
- CLEAR_IDENTIFIER Procedure
- CLOSE_DATABASE_LINK Procedure
- FREE_UNUSED_USER_MEMORY Procedure
- IS_ROLE_ENABLED Function
- IS_SESSION_ALIVE Function
- LIST_CONTEXT Procedures
- MODIFY_PACKAGE_STATE Procedure
- SESSION _TRACE_DISABLE Procedure
- SESSION _TRACE_ENABLE Procedure
- RESET_PACKAGE Procedure
- SET_CONTEXT Procedure
- SET_IDENTIFIER
- SET_NLS Procedure
- SET_ROLE Procedure
- SET_SQL_TRACE Procedure
- SWITCH_CURRENT_CONSUMER_GROUP Procedure
- UNIQUE_SESSION_ID Function
97 DBMS_SHARED_POOL
98 DBMS_SPACE
99 DBMS_SPACE_ADMIN
- Using DBMS_SPACE_ADMIN
- Summary of DBMS_SPACE_ADMIN Subprograms
- ASSM_SEGMENT_VERIFY Procedure
- ASSM_TABLESPACE_VERIFY Procedure
- SEGMENT_CORRUPT Procedure
- SEGMENT_DROP_CORRUPT Procedure
- SEGMENT_DUMP Procedure
- SEGMENT_VERIFY Procedure
- TABLESPACE_FIX_BITMAPS Procedure
- TABLESPACE_FIX_SEGMENT_STATES Procedure
- TABLESPACE_MIGRATE_FROM_LOCAL Procedure
- TABLESPACE_MIGRATE_TO_LOCAL Procedure
- TABLESPACE_REBUILD_BITMAPS Procedure
- TABLESPACE_REBUILD_QUOTAS Procedure
- TABLESPACE_RELOCATE_BITMAPS Procedure
- TABLESPACE_VERIFY Procedure
100 DBMS_SQL
- Using DBMS_SQL
- Summary of DBMS_SQL Subprograms
- BIND_ARRAY Procedures
- BIND_VARIABLE Procedures
- CLOSE_CURSOR Procedure
- COLUMN_VALUE Procedure
- COLUMN_VALUE_LONG Procedure
- DEFINE_ARRAY Procedure
- DEFINE_COLUMN Procedure
- DEFINE_COLUMN_LONG Procedure
- DESCRIBE_COLUMNS Procedure
- DESCRIBE_COLUMNS2 Procedure
- EXECUTE Function
- EXECUTE_AND_FETCH Function
- FETCH_ROWS Function
- IS_OPEN Function
- LAST_ERROR_POSITION Function
- LAST_ROW_COUNT Function
- LAST_ROW_ID Function
- LAST_SQL_FUNCTION_CODE Function
- OPEN_CURSOR Function
- PARSE Procedure
- VARIABLE_VALUE Procedures
101 DBMS_SQLTUNE
- Using DBMS_SQLTUNE
- Data Structures
- Subprogram Groups
- Summary of DBMS_SQLTUNE Subprograms
- ACCEPT_SQL_PROFILE Procedure and Function
- ADD_SQLSET_REFERENCE Function
- ALTER_SQL_PROFILE Procedure
- CANCEL_TUNING_TASK Procedure
- CAPTURE_CURSOR_CACHE_SQLSET Procedure
- CREATE_SQLSET Procedure and Function
- CREATE_STGTAB_SQLPROF Procedure
- CREATE_STGTAB_SQLSET Procedure
- CREATE_TUNING_TASK Functions
- DELETE_SQLSET Procedure
- DROP_SQL_PROFILE Procedure
- DROP_SQLSET Procedure
- DROP_TUNING_TASK Procedure
- EXECUTE_TUNING_TASK Procedure
- INTERRUPT_TUNING_TASK Procedure
- LOAD_SQLSET Procedure
- PACK_STGTAB_SQLPROF Procedure
- PACK_STGTAB_SQLSET Procedure
- REMAP_STGTAB_SQLPROF Procedure
- REMAP_STGTAB_SQLSET Procedure
- REMOVE_SQLSET_REFERENCE Procedure
- REPORT_TUNING_TASK Function
- RESET_TUNING_TASK Procedure
- RESUME_TUNING_TASK Procedure
- SCRIPT_TUNING_TASK Function
- SELECT_CURSOR_CACHE Function
- SELECT_SQLSET Function
- SELECT_WORKLOAD_REPOSITORY Functions
- SQLTEXT_TO_SIGNATURE Function
- UNPACK_STGTAB_SQLPROF Procedure
- UNPACK_STGTAB_SQLSET Procedure
- UPDATE_SQLSET Procedures
102 DBMS_STAT_FUNCS
103 DBMS_STATS
- Using DBMS_STATS
- Summary of DBMS_STATS Subprograms
- ALTER_DATABASE_TAB_MONITORING Procedure
- ALTER_SCHEMA_TAB_MONITORING Procedure
- ALTER_STATS_HISTORY_RETENTION Procedure
- CONVERT_RAW_VALUE Procedures
- CONVERT_RAW_VALUE_NVARCHAR Procedure
- CONVERT_RAW_VALUE_ROWID Procedure
- CREATE_STAT_TABLE Procedure
- DELETE_COLUMN_STATS Procedure
- DELETE_DATABASE_STATS Procedure
- DELETE_DICTIONARY_STATS Procedure
- DELETE_FIXED_OBJECTS_STATS Procedure
- DELETE_INDEX_STATS Procedure
- DELETE_SCHEMA_STATS Procedure
- DELETE_SYSTEM_STATS Procedure
- DELETE_TABLE_STATS Procedure
- DROP_STAT_TABLE Procedure
- EXPORT_COLUMN_STATS Procedure
- EXPORT_DATABASE_STATS Procedure
- EXPORT_DICTIONARY_STATS Procedure
- EXPORT_FIXED_OBJECTS_STATS Procedure
- EXPORT_INDEX_STATS Procedure
- EXPORT_SCHEMA_STATS Procedure
- EXPORT_SYSTEM_STATS Procedure
- EXPORT_TABLE_STATS Procedure
- FLUSH_DATABASE_MONITORING_INFO Procedure
- GATHER_DATABASE_STATS Procedures
- GATHER_DICTIONARY_STATS Procedure
- GATHER_FIXED_OBJECTS_STATS Procedure
- GATHER_INDEX_STATS Procedure
- GATHER_SCHEMA_STATS Procedures
- GATHER_SYSTEM_STATS Procedure
- GATHER_TABLE_STATS Procedure
- GENERATE_STATS Procedure
- GET_COLUMN_STATS Procedures
- GET_INDEX_STATS Procedures
- GET_PARAM Function
- GET_STATS_HISTORY_AVAILABILITY Function
- GET_STATS_HISTORY_RETENTION Function
- GET_SYSTEM_STATS Procedure
- GET_TABLE_STATS Procedure
- IMPORT_COLUMN_STATS Procedure
- IMPORT_DATABASE_STATS Procedure
- IMPORT_DICTIONARY_STATS Procedure
- IMPORT_FIXED_OBJECTS_STATS Procedure
- IMPORT_INDEX_STATS Procedure
- IMPORT_SCHEMA_STATS Procedure
- IMPORT_SYSTEM_STATS Procedure
- IMPORT_TABLE_STATS Procedure
- LOCK_SCHEMA_STATS Procedure
- LOCK_TABLE_STATS Procedure
- PREPARE_COLUMN_VALUES Procedures
- PREPARE_COLUMN_VALUES_NVARCHAR2 Procedure
- PREPARE_COLUMN_VALUES_ROWID Procedure
- PURGE_STATS Procedure
- RESET_PARAM_DEFAULTS Procedure
- RESTORE_DATABASE_STATS Procedure
- RESTORE_DICTIONARY_STATS Procedure
- RESTORE_FIXED_OBJECTS_STATS Procedure
- RESTORE_SCHEMA_STATS Procedure
- RESTORE_SYSTEM_STATS Procedure
- RESTORE_TABLE_STATS Procedure
- SET_COLUMN_STATS Procedures
- SET_INDEX_STATS Procedures
- SET_PARAM Procedure
- SET_SYSTEM_STATS Procedure
- SET_TABLE_STATS Procedure
- UNLOCK_SCHEMA_STATS Procedure
- UNLOCK_TABLE_STATS Procedure
- UPGRADE_STAT_TABLE Procedure
104 DBMS_STORAGE_MAP
105 DBMS_STREAMS
- Using DBMS_STREAMS
- Summary of DBMS_STREAMS Subprograms
- COMPATIBLE_10_2 Function
- COMPATIBLE_10_1 Function
- COMPATIBLE_9_2 Function
- CONVERT_ANYDATA_TO_LCR_DDL Function
- CONVERT_ANYDATA_TO_LCR_ROW Function
- CONVERT_LCR_TO_XML Function
- CONVERT_XML_TO_LCR Function
- GET_INFORMATION Function
- GET_STREAMS_NAME Function
- GET_STREAMS_TYPE Function
- GET_TAG Function
- SET_TAG Procedure
106 DBMS_STREAMS_ADM
- Using DBMS_STREAMS_ADM
- Summary of DBMS_STREAMS_ADM Subprograms
- ADD_COLUMN Procedure
- ADD_GLOBAL_PROPAGATION_RULES Procedure
- ADD_GLOBAL_RULES Procedure
- ADD_MESSAGE_PROPAGATION_RULE Procedure
- ADD_MESSAGE_RULE Procedure
- ADD_SCHEMA_PROPAGATION_RULES Procedure
- ADD_SCHEMA_RULES Procedure
- ADD_SUBSET_PROPAGATION_RULES Procedure
- ADD_SUBSET_RULES Procedure
- ADD_TABLE_PROPAGATION_RULES Procedure
- ADD_TABLE_RULES Procedure
- CLEANUP_INSTANTIATION_SETUP Procedure
- DELETE_COLUMN Procedure
- GET_SCN_MAPPING Procedure
- MAINTAIN_GLOBAL Procedure
- MAINTAIN_SCHEMAS Procedure
- MAINTAIN_SIMPLE_TABLESPACE Procedure
- MAINTAIN_SIMPLE_TTS Procedure
- MAINTAIN_TABLES Procedure
- MAINTAIN_TABLESPACES Procedure
- MAINTAIN_TTS Procedure
- POST_INSTANTIATION_SETUP Procedure
- PRE_INSTANTIATION_SETUP Procedure
- PURGE_SOURCE_CATALOG Procedure
- RECOVER_OPERATION Procedure
- REMOVE_QUEUE Procedure
- REMOVE_RULE Procedure
- REMOVE_STREAMS_CONFIGURATION Procedure
- RENAME_COLUMN Procedure
- RENAME_SCHEMA Procedure
- RENAME_TABLE Procedure
- SET_MESSAGE_NOTIFICATION Procedure
- SET_RULE_TRANSFORM_FUNCTION Procedure
- SET_UP_QUEUE Procedure
107 DBMS_STREAMS_AUTH
108 DBMS_STREAMS_MESSAGING
109 DBMS_STREAMS_TABLESPACE_ADM
110 DBMS_TRACE
111 DBMS_TRANSACTION
- Using DBMS_TRANSACTION
- Summary of DBMS_TRANSACTION Subprograms
- ADVISE_COMMIT Procedure
- ADVISE_NOTHING Procedure
- ADVISE_ROLLBACK Procedure
- BEGIN_DISCRETE_TRANSACTION Procedure
- COMMIT Procedure
- COMMIT_COMMENT Procedure
- COMMIT_FORCE Procedure
- LOCAL_TRANSACTION_ID Function
- PURGE_LOST_DB_ENTRY Procedure
- PURGE_MIXED Procedure
- READ_ONLY Procedure
- READ_WRITE Procedure
- ROLLBACK Procedure
- ROLLBACK_FORCE Procedure
- ROLLBACK_SAVEPOINT Procedure
- SAVEPOINT Procedure
- STEP_ID Function
- USE_ROLLBACK_SEGMENT Procedure
112 DBMS_TRANSFORM
113 DBMS_TDB
114 DBMS_TTS
115 DBMS_TYPES
116 DBMS_UTILITY
- Using DBMS_UTILITY
- Summary of DBMS_UTILITY Subprograms
- ACTIVE_INSTANCES Procedure
- ANALYZE_DATABASE Procedure
- ANALYZE_PART_OBJECT Procedure
- ANALYZE_SCHEMA Procedure
- CANONICALIZE Procedure
- COMMA_TO_TABLE Procedures
- COMPILE_SCHEMA Procedure
- CREATE_ALTER_TYPE_ERROR_TABLE Procedure
- CURRENT_INSTANCE Function
- DATA_BLOCK_ADDRESS_BLOCK Function
- DATA_BLOCK_ADDRESS_FILE Function
- DB_VERSION Procedure
- EXEC_DDL_STATEMENT Procedure
- FORMAT_CALL_STACK Function
- FORMAT_ERROR_BACKTRACE Function
- FORMAT_ERROR_STACK Function
- GET_CPU_TIME Function
- GET_DEPENDENCY Procedure
- GET_HASH_VALUE Function
- GET_PARAMETER_VALUE Function
- GET_TIME Function
- INVALIDATE Procedure
- IS_CLUSTER_DATABASE Function
- MAKE_DATA_BLOCK_ADDRESS Function
- NAME_RESOLVE Procedure
- NAME_TOKENIZE Procedure
- PORT_STRING Function
- TABLE_TO_COMMA Procedures
- VALIDATE Procedure
117 DBMS_WARNING
118 DBMS_WORKLOAD_CAPTURE
119 DBMS_WORKLOAD_REPOSITORY
- Using DBMS_WORKLOAD_REPOSITORY
- Summary of DBMS_WORKLOAD_REPOSITORY Subprograms
- ASH_REPORT_HTML Function
- ASH_REPORT_TEXT Function
- AWR_DIFF_REPORT_HTML Function
- AWR_DIFF_REPORT_TEXT Function
- AWR_REPORT_HTML Function
- AWR_REPORT_TEXT Function
- AWR_SQL_REPORT_HTML Function
- AWR_SQL_REPORT_TEXT Function
- CREATE_BASELINE Function and Procedure
- CREATE_SNAPSHOT Function and Procedure
- DROP_BASELINE Procedure
- DROP_SNAPSHOT_RANGE Procedure
- MODIFY_SNAPSHOT_SETTINGS Procedures
120 DBMS_WM
121 DBMS_XDB
- Using DBMS_XDB
- Summary of DBMS_XDB Subprograms
- ACLCHECKPRIVILEGES Function
- APPENDRESOURCEMETADATA Procedure
- CFG_GET Function
- CFG_REFRESH Procedure
- CFG_UPDATE Procedure
- CHANGEPRIVILEGES Function
- CHECKPRIVILEGES Function
- CREATEFOLDER Function
- CREATEOIDPATH Function
- CREATERESOURCE Functions
- DELETERESOURCE Procedure
- DELETERESOURCEMETADATA Procedures
- EXISTSRESOURCE Function
- GETACLDOCUMENT Function
- GETFTPPORT Function
- GETHTTPPORT Function
- GETLOCKTOKEN Procedure
- GETPRIVILEGES Function
- GETRESOID Function
- GETXDB_TABLESPACE Function
- LINK Procedure
- LOCKRESOURCE Function
- MOVEXDB_TABLESPACE Procedure
- PURGERESOURCEMETADATA Procedure
- REBUILDHIERARCHICALINDEX Procedure
- RENAMERESOURCE Procedure
- SETACL Procedure
- SETFTPPORT Procedure
- SETHTTPPORT Procedure
- UPDATERESOURCEMETADATA Procedures
- UNLOCKRESOURCE Function
122 DBMS_XDB_VERSION
123 DBMS_XDBT
124 DBMS_XDBZ
125 DBMS_XMLDOM
- Using DBMS_XMLDOM
- Subprogram Groups
- DOMNode Subprograms
- DOMAttr Subprograms
- DOMCDataSection Subprograms
- DOMCharacterData Subprograms
- DOMComment Subprograms
- DOMDocument Subprograms
- DOMDocumentFragment Subprograms
- DOMDocumentType Subprograms
- DOMElement Subprograms
- DOMEntity Subprograms
- DOMEntityReference Subprograms
- DOMImplementation Subprograms
- DOMNamedNodeMap Subprograms
- DOMNodeList Subprograms
- DOMNotation Subprograms
- DOMProcessingInstruction Subprograms
- DOMText Subprograms
- Summary of DBMS_XMLDOM Subprograms
- ADOPTNODE Function
- APPENDCHILD Function
- APPENDDATA Procedure
- CLONENODE Function
- CREATEATTRIBUTE Functions
- CREATECDATASECTION Function
- CREATECOMMENT Function
- CREATEDOCUMENT Function
- CREATEDOCUMENTFRAGMENT Function
- CREATEELEMENT Functions
- CREATEENTITYREFERENCE Function
- CREATEPROCESSINGINSTRUCTION Function
- CREATETEXTNODE Function
- DELETEDATA Procedure
- FINDENTITY Function
- FINDNOTATION Function
- FREEDOCFRAG Procedure
- FREEDOCUMENT Procedure
- FREENODE Procedure
- GETATTRIBUTE Functions
- GETATTRIBUTENODE Functions
- GETATTRIBUTES Function
- GETCHILDNODES Function
- GETCHILDRENBYTAGNAME Functions
- GETDATA Functions
- GETDOCTYPE Function
- GETDOCUMENTELEMENT Function
- GETELEMENTSBYTAGNAME Functions
- GETENTITIES Function
- GETEXPANDEDNAME Procedure and Functions
- GETFIRSTCHILD Function
- GETIMPLEMENTATION Function
- GETLASTCHILD Function
- GETLENGTH Functions
- GETLOCALNAME Procedure and Functions
- GETNAME Functions
- GETNAMEDITEM Function
- GETNAMESPACE Procedure and Functions
- GETNEXTSIBLING Function
- GETNODENAME Function
- GETNODETYPE Function
- GETNODEVALUE Function
- GETNOTATIONNAME Function
- GETNOTATIONS Function
- GETTARGET Function
- GETOWNERDOCUMENT Function
- GETOWNERELEMENT Function
- GETPARENTNODE Function
- GETPREFIX Function
- GETPREVIOUSSIBLING Function
- GETPUBLICID Functions
- GETQUALIFIEDNAME Functions
- GETSCHEMANODE Function
- GETSPECIFIED Function
- GETSTANDALONE Function
- GETSYSTEMID Functions
- GETTAGNAME Function
- GETVALUE Function
- GETVERSION Function
- GETXMLTYPE Function
- HASATTRIBUTE Functions
- HASATTRIBUTES Function
- HASCHILDNODES Function
- HASFEATURE Function
- IMPORTNODE Function
- INSERTBEFORE Function
- INSERTDATA Procedure
- ISNULL Functions
- ITEM Functions
- MAKEATTR Function
- MAKECDATASECTION Function
- MAKECHARACTERDATA Function
- MAKECOMMENT Function
- MAKEDOCUMENT Function
- MAKEDOCUMENTFRAGMENT Function
- MAKEDOCUMENTTYPE Function
- MAKEELEMENT Function
- MAKEENTITY Function
- MAKEENTITYREFERENCE Function
- MAKENODE Functions
- MAKENOTATION Function
- MAKEPROCESSINGINSTRUCTION Function
- MAKETEXT Function
- NEWDOMDOCUMENT Functions
- NORMALIZE Procedure
- REMOVEATTRIBUTE Procedures
- REMOVEATTRIBUTENODE Function
- REMOVECHILD Function
- REMOVENAMEDITEM Function
- REPLACECHILD Function
- REPLACEDATA Procedure
- RESOLVENAMESPACEPREFIX Function
- SETATTRIBUTE Procedures
- SETATTRIBUTENODE Functions
- SETDATA Procedures
- SETDOCTYPE Procedure
- SETNAMEDITEM Function
- SETNODEVALUE Procedure
- SETPREFIX Procedure
- SETSTANDALONE Procedure
- SETVALUE Procedure
- SETVERSION Procedure
- SPLITTEXT Function
- SUBSTRINGDATA Function
- WRITETOBUFFER Procedures
- WRITETOCLOB Procedures
- WRITETOFILE Procedures
126 DBMS_XMLGEN
- Summary of DBMS_XMLGEN Subprograms
- CLOSECONTEXT Procedure
- CONVERT Functions
- GETNUMROWSPROCESSED Function
- GETXML Functions
- GETXMLTYPE Functions
- NEWCONTEXT Functions
- RESTARTQUERY Procedure
- SETCONVERTSPECIALCHARS Procedure
- SETMAXROWS Procedure
- SETNULLHANDLING Procedure
- SETROWSETTAG Procedure
- SETROWTAG Procedure
- SETSKIPROWS Procedure
- USEITEMTAGSFORCOLL Procedure
- USENULLATTRIBUTEINDICATOR Procedure
127 DBMS_XMLPARSER
128 DBMS_XMLQUERY
- Using DBMS_XMLQUERY
- Summary of DBMS_XMLQUERY Subprograms
- CLOSECONTEXT
- GETDTD
- GETEXCEPTIONCONTENT
- GETNUMROWSPROCESSED
- GETVERSION
- GETXML
- NEWCONTEXT
- PROPAGATEORIGINALEXCEPTION
- REMOVEXSLTPARAM
- SETBINDVALUE
- SETCOLLIDATTRNAME
- SETDATAHEADER
- SETDATEFORMAT
- SETENCODINGTAG
- SETERRORTAG
- SETMAXROWS
- SETMETAHEADER
- SETRAISEEXCEPTION
- SETRAISENOROWSEXCEPTION
- SETROWIDATTRNAME
- SETROWIDATTRVALUE
- SETROWSETTAG
- SETROWTAG
- SETSKIPROWS
- SETSQLTOXMLNAMEESCAPING
- SETSTYLESHEETHEADER
- SETTAGCASE
- SETXSLT
- SETXSLTPARAM
- USENULLATTRIBUTEINDICATOR
- USETYPEFORCOLLELEMTAG
129 DBMS_XMLSAVE
130 DBMS_XMLSCHEMA
131 DBMS_XMLSTORE
132 DBMS_XPLAN
133 DBMS_XSLPROCESSOR
- Using DBMS_XSLPROCESSOR
- Summary of DBMS_XSLPROCESSOR Subprograms
- CLOB2FILE Procedure
- FREEPROCESSOR Procedure
- FREESTYLESHEET Procedure
- NEWPROCESSOR Function
- NEWSTYLESHEET Functions
- PROCESSXSL Functions and Procedures
- READ2CLOB Function
- REMOVEPARAM Procedure
- RESETPARAMS Procedure
- SELECTNODES Function
- SELECTSINGLENODE Function
- SETERRORLOG Procedure
- SETPARAM Procedure
- SHOWWARNINGS Procedure
- TRANSFORMNODE Function
- VALUEOF Function and Procedure
134 DEBUG_EXTPROC
135 HTF
- Using HTF
- Summary of Tags
- Summary of HTF Subprograms
- ADDRESS Function
- ANCHOR Function
- ANCHOR2 Function
- APPLETCLOSE Function
- APPLETOPEN Function
- AREA Function
- BASE Function
- BASEFONT Function
- BGSOUND Function
- BIG Function
- BLOCKQUOTECLOSE Function
- BLOCKQUOTEOPEN Function
- BODYCLOSE Function
- BODYOPEN Function
- BOLD Function
- BR Function
- CENTER Function
- CENTERCLOSE Function
- CENTEROPEN Function
- CITE Function
- CODE Function
- COMMENT Function
- DFN Function
- DIRLISTCLOSE Function
- DIRLISTOPEN Function
- DIV Function
- DLISTCLOSE Function
- DLISTDEF Function
- DLISTOPEN Function
- DLISTTERM Function
- EM Function
- EMPHASIS Function
- ESCAPE_SC Function
- ESCAPE_URL Function
- FONTCLOSE Function
- FONTOPEN Function
- FORMAT_CELL Function
- FORMCHECKBOX Function
- FORMCLOSE Function
- FORMFILE Function
- FORMHIDDEN Function
- FORMIMAGE Function
- FORMOPEN Function
- FORMPASSWORD Function
- FORMRADIO Function
- FORMRESET Function
- FORMSELECTCLOSE Function
- FORMSELECTOPEN Function
- FORMSELECTOPTION Function
- FORMSUBMIT Function
- FORMTEXT Function
- FORMTEXTAREA Function
- FORMTEXTAREA2 Function
- FORMTEXTAREACLOSE Function
- FORMTEXTAREAOPEN Function
- FORMTEXTAREAOPEN2 Function
- FRAME Function
- FRAMESETCLOSE Function
- FRAMESETOPEN Function
- HEADCLOSE Function
- HEADER Function
- HEADOPEN Function
- HR Function
- HTMLCLOSE Function
- HTMLOPEN Function
- IMG Function
- IMG2 Function
- ISINDEX Function
- ITALIC Function
- KBD Function
- KEYBOARD Function
- LINE Function
- LINKREL Function
- LINKREV Function
- LISTHEADER Function
- LISTINGCLOSE Function
- LISTINGOPEN Function
- LISTITEM Function
- MAILTO Function
- MAPCLOSE Function
- MAPOPEN Function
- MENULISTCLOSE Function
- MENULISTOPEN Function
- META Function
- NL Function
- NOBR Function
- NOFRAMESCLOSE Function
- NOFRAMESOPEN Function
- OLISTCLOSE Function
- OLISTOPEN Function
- PARA Function
- PARAGRAPH Function
- PARAM Function
- PLAINTEXT Function
- PRECLOSE Function
- PREOPEN Function
- PRINT Functions
- PRN Functions
- S Function
- SAMPLE Function
- SCRIPT Function
- SMALL Function
- STRIKE Function
- STRONG Function
- STYLE Function
- SUB Function
- SUP Function
- TABLECAPTION Function
- TABLECLOSE Function
- TABLEDATA Function
- TABLEHEADER Function
- TABLEOPEN Function
- TABLEROWCLOSE Function
- TABLEROWOPEN Function
- TELETYPE Function
- TITLE Function
- ULISTCLOSE Function
- ULISTOPEN Function
- UNDERLINE Function
- VARIABLE Function
- WBR Function
136 HTMLDB_CUSTOM_AUTH
137 HTMLDB_APPLICATION
138 HTMLDB_ITEM
139 HTMLDB_UTIL
140 HTP
- Using HTP
- Summary of Tags
- Summary of HTP Subprograms
- ADDRESS Procedure
- ANCHOR Procedure
- ANCHOR2 Procedure
- APPLETCLOSE Procedure
- APPLETOPEN Procedure
- AREA Procedure
- BASE Procedure
- BASEFONT Procedure
- BGSOUND Procedure
- BIG Procedure
- BLOCKQUOTECLOSE Procedure
- BLOCKQUOTEOPEN Procedure
- BODYCLOSE Procedure
- BODYOPEN Procedure
- BOLD Procedure
- BR Procedure
- CENTER Procedure
- CENTERCLOSE Procedure
- CENTEROPEN Procedure
- CITE Procedure
- CODE Procedure
- COMMENT Procedure
- DFN Procedure
- DIRLISTCLOSE Procedure
- DIRLISTOPEN Procedure
- DIV Procedure
- DLISTCLOSE Procedure
- DLISTDEF Procedure
- DLISTOPEN Procedure
- DLISTTERM Procedure
- EM Procedure
- EMPHASIS Procedure
- ESCAPE_SC Procedure
- FONTCLOSE Procedure
- FONTOPEN Procedure
- FORMCHECKBOX Procedure
- FORMCLOSE Procedure
- FORMOPEN Procedure
- FORMFILE Procedure
- FORMHIDDEN Procedure
- FORMIMAGE Procedure
- FORMPASSWORD Procedure
- FORMRADIO Procedure
- FORMRESET Procedure
- FORMSELECTCLOSE Procedure
- FORMSELECTOPEN Procedure
- FORMSELECTOPTION Procedure
- FORMSUBMIT Procedure
- FORMTEXT Procedure
- FORMTEXTAREA Procedure
- FORMTEXTAREA2 Procedure
- FORMTEXTAREACLOSE Procedure
- FORMTEXTAREAOPEN Procedure
- FORMTEXTAREAOPEN2 Procedure
- FRAME Procedure
- FRAMESETCLOSE Procedure
- FRAMESETOPEN Procedure
- HEADCLOSE Procedure
- HEADER Procedure
- HEADOPEN Procedure
- HR Procedure
- HTMLCLOSE Procedure
- HTMLOPEN Procedure
- IMG Procedure
- IMG2 Procedure
- ISINDEX Procedure
- ITALIC Procedure
- KBD Procedure
- KEYBOARD Procedure
- LINE Procedure
- LINKREL Procedure
- LINKREV Procedure
- LISTHEADER Procedure
- LISTINGCLOSE Procedure
- LISTINGOPEN Procedure
- LISTITEM Procedure
- MAILTO Procedure
- MAPCLOSE Procedure
- MAPOPEN Procedure
- MENULISTCLOSE Procedure
- MENULISTOPEN Procedure
- META Procedure
- NL Procedure
- NOBR Procedure
- NOFRAMESCLOSE Procedure
- NOFRAMESOPEN Procedure
- OLISTCLOSE Procedure
- OLISTOPEN Procedure
- PARA Procedure
- PARAGRAPH Procedure
- PARAM Procedure
- PLAINTEXT Procedure
- PRECLOSE Procedure
- PREOPEN Procedure
- PRINT Procedures
- PRINTS Procedure
- PRN Procedures
- PS Procedure
- S Procedure
- SAMPLE Procedure
- SCRIPT Procedure
- SMALL Procedure
- STRIKE Procedure
- STRONG Procedure
- STYLE Procedure
- SUB Procedure
- SUP Procedure
- TABLECAPTION Procedure
- TABLECLOSE Procedure
- TABLEDATA Procedure
- TABLEHEADER Procedure
- TABLEOPEN Procedure
- TABLEROWCLOSE Procedure
- TABLEROWOPEN Procedure
- TELETYPE Procedure
- TITLE Procedure
- ULISTCLOSE Procedure
- ULISTOPEN Procedure
- UNDERLINE Procedure
- VARIABLE Procedure
- WBR Procedure
141 OWA_CACHE
142 OWA_COOKIE
143 OWA_CUSTOM
144 OWA_IMAGE
145 OWA_OPT_LOCK
146 OWA_PATTERN
147 OWA_SEC
148 OWA_TEXT
149 OWA_UTIL
- Using OWA_UTIL
- Summary of OWA_UTIL Subprograms
- BIND_VARIABLES Function
- CALENDARPRINT Procedures
- CELLSPRINT Procedures
- CHOOSE_DATE Procedure
- GET_CGI_ENV Function
- GET_OWA_SERVICE_PATH Function
- GET_PROCEDURE Function
- HTTP_HEADER_CLOSE Procedure
- LISTPRINT Procedure
- MIME_HEADER Procedure
- PRINT_CGI_ENV Procedure
- REDIRECT_URL Procedure
- SHOWPAGE Procedure
- SHOWSOURCE Procedure
- SIGNATURE procedure
- STATUS_LINE Procedure
- TABLEPRINT Function
- TODATE Function
- WHO_CALLED_ME Procedure
150 SDO_CS
151 SDO_GCDR
152 SDO_GEOM
153 SDO_GEOR
154 SDO_GEOR_UTL
155 SDO_LRS
156 SDO_MIGRATE
157 SDO_NET
158 SDO_NET_MEM
159 SDO_SAM
160 SDO_TOPO
161 SDO_TOPO_MAP
162 SDO_TUNE
163 SDO_UTIL
164 UTL_COLL
165 UTL_COMPRESS
- Using UTL_COMPRESS
- Summary of UTL_COMPRESS Subprograms
166 UTL_DBWS
- Using UTL_DBWS
- Summary of UTL_DBWS Subprograms
- CREATE_CALL Function
- CREATE_SERVICE Function
- GET_IN_PARAMETER_TYPES Function
- GET_OUT_PARAMETER_TYPES Function
- GET_OUTPUT_VALUES Function
- GET_PORTS Function
- GET_PROPERTY Function
- GET_RETURN_TYPE Function
- GET_SERVICES Function
- INVOKE Function
- RELEASE_ALL_SERVICES Procedure
- RELEASE_CALL Procedure
- RELEASE_SERVICE Procedure
- REMOVE_PROPERTY Procedure
- SET_PROPERTY Procedure
167 UTL_ENCODE
168 UTL_FILE
- Using UTL_FILE
- Summary of UTL_FILE Subprograms
- FCLOSE Procedure
- FCLOSE_ALL Procedure
- FCOPY Procedure
- FFLUSH Procedure
- FGETATTR Procedure
- FGETPOS Function
- FOPEN Function
- FOPEN_NCHAR Function
- FREMOVE Procedure
- FRENAME Procedure
- FSEEK Procedure
- GET_LINE Procedure
- GET_LINE_NCHAR Procedure
- GET_RAW Function
- IS_OPEN Function
- NEW_LINE Procedure
- PUT Procedure
- PUT_LINE Procedure
- PUT_LINE_NCHAR Procedure
- PUT_NCHAR Procedure
- PUTF Procedure
- PUTF_NCHAR Procedure
- PUT_RAW Function
169 UTL_HTTP
- Using UTL_HTTP
- Subprogram Groups
- Summary of UTL_HTTP Subprograms
- ADD_COOKIES Procedure
- BEGIN_REQUEST Function
- CLEAR_COOKIES Procedure
- CLOSE_PERSISTENT_CONN Procedure
- CLOSE_PERSISTENT_CONNS Procedure
- END_REQUEST Procedure
- END_RESPONSE Procedure
- GET_AUTHENTICATION Procedure
- GET_BODY_CHARSET Procedure
- GET_COOKIE_COUNT Function
- GET_COOKIE_SUPPORT Procedure
- GET_COOKIES Function
- GET_DETAILED_EXCP_SUPPORT Procedure
- GET_DETAILED_SQLCODE Function
- GET_DETAILED_SQLERRM Function
- GET_FOLLOW_REDIRECT Procedure
- GET_HEADER Procedure
- GET_HEADER_BY_NAME Procedure
- GET_HEADER_COUNT Function
- GET_PERSISTENT_CONN_COUNT Function
- GET_PERSISTENT_CONN_SUPPORT Procedure
- GET_PERSISTENT_CONNS Procedure
- GET_PROXY Procedure
- GET_RESPONSE Function
- GET_RESPONSE_ERROR_CHECK Procedure
- GET_TRANSFER_TIMEOUT Procedure
- READ_LINE Procedure
- READ_RAW Procedure
- READ_TEXT Procedure
- REQUEST Function
- REQUEST_PIECES Function
- SET_AUTHENTICATION Procedure
- SET_BODY_CHARSET Procedures
- SET_COOKIE_SUPPORT Procedures
- SET_DETAILED_EXCP_SUPPORT Procedure
- SET_FOLLOW_REDIRECT Procedures
- SET_HEADER Procedure
- SET_PERSISTENT_CONN_SUPPORT Procedure
- SET_PROXY Procedure
- SET_RESPONSE_ERROR_CHECK Procedure
- SET_TRANSFER_TIMEOUT Procedure
- SET_WALLET Procedure
- WRITE_LINE Procedure
- WRITE_RAW Procedure
- WRITE_TEXT Procedure
170 UTL_I18N
- Using UTL_I18N
- Summary of UTL_I18N Subprograms
- ESCAPE_REFERENCE Function
- GET_COMMON_TIME_ZONES Function
- GET_DEFAULT_CHARSET Function
- GET_DEFAULT_ISO_CURRENCY Function
- GET_DEFAULT_LINGUISTIC_SORT Function
- GET_LOCAL_LANGUAGES Function
- GET_LOCAL_LINGUISTIC_SORTS Function
- GET_LOCAL_TERRITORIES Function
- GET_LOCAL_TIME_ZONES Function
- GET_TRANSLATION Function
- MAP_CHARSET Function
- MAP_FROM_SHORT_LANGUAGE Function
- MAP_LANGUAGE_FROM_ISO Function
- MAP_LOCALE_TO_ISO Function
- MAP_TERRITORY_FROM_ISO Function
- MAP_TO_SHORT_LANGUAGE Function
- RAW_TO_CHAR Functions
- RAW_TO_NCHAR Functions
- STRING_TO_RAW Function
- TRANSLITERATE Function
- UNESCAPE_REFERENCE Function
171 UTL_INADDR
172 UTL_LMS
173 UTL_MAIL
174 UTL_NLA
- Using UTL_NLA
- Subprogram Groups
- Summary of UTL_NLA Subprograms
- BLAS_ASUM Functions
- BLAS_AXPY Procedures
- BLAS_COPY Procedures
- BLAS_DOT Functions
- BLAS_GBMV Procedures
- BLAS_GEMM Procedures
- BLAS_GEMV Procedures
- BLAS_GER Procedures
- BLAS_IAMAX Functions
- BLAS_NRM2 Functions
- BLAS_ROT Procedures
- BLAS_ROTG Procedures
- BLAS_SCAL Procedures
- BLAS_SPMV Procedures
- BLAS_SPR Procedures
- BLAS_SPR2 Procedures
- BLAS_SBMV Procedures
- BLAS_SWAP Procedures
- BLAS_SYMM Procedures
- BLAS_SYMV Procedures
- BLAS_SYR Procedures
- BLAS_SYR2 Procedures
- BLAS_SYR2K Procedures
- BLAS_SYRK Procedures
- BLAS_TBMV Procedures
- BLAS_TBSV Procedures
- BLAS_TPMV Procedures
- BLAS_TPSV Procedures
- BLAS_TRMM Procedures
- BLAS_TRMV Procedures
- BLAS_TRSM Procedures
- BLAS_TRSV Procedures
- LAPACK_GBSV Procedures
- LAPACK_GEES Procedures
- LAPACK_GELS Procedures
- LAPACK_GESDD Procedures
- LAPACK_GESV Procedures
- LAPACK_GESVD Procedures
- LAPACK_GEEV Procedures
- LAPACK_GTSV Procedures
- LAPACK_PBSV Procedures
- LAPACK_POSV Procedures
- LAPACK_PPSV Procedures
- LAPACK_PTSV Procedures
- LAPACK_SBEV Procedures
- LAPACK_SBEVD Procedures
- LAPACK_SPEV Procedures
- LAPACK_SPEVD Procedures
- LAPACK_SPSV Procedures
- LAPACK_STEV Procedures
- LAPACK_STEVD Procedures
- LAPACK_SYEV Procedures
- LAPACK_SYEVD Procedures
- LAPACK_SYSV Procedures
175 UTL_RAW
- Using UTL_RAW
- Summary of UTL_RAW Subprograms
- BIT_AND Function
- BIT_COMPLEMENT Function
- BIT_OR Function
- BIT_XOR Function
- CAST_FROM_BINARY_DOUBLE Function
- CAST_FROM_BINARY_FLOAT Function
- CAST_FROM_BINARY_INTEGER Function
- CAST_FROM_NUMBER Function
- CAST_TO_BINARY_DOUBLE Function
- CAST_TO_BINARY_FLOAT Function
- CAST_TO_BINARY_INTEGER Function
- CAST_TO_NUMBER Function
- CAST_TO_RAW Function
- CAST_TO_VARCHAR2 Function
- CAST_TO_NVARCHAR2 Function
- COMPARE Function
- CONCAT Function
- CONVERT Function
- COPIES Function
- LENGTH Function
- OVERLAY Function
- REVERSE Function
- SUBSTR Function
- TRANSLATE Function
- TRANSLITERATE Function
- XRANGE Function
176 UTL_RECOMP
177 UTL_REF
178 UTL_SMTP
- Using UTL_SMTP
- Summary of UTL_SMTP Subprograms
- CLOSE_DATA Function and Procedure
- COMMAND Function and Procedure
- COMMAND_REPLIES Function
- DATA Function and Procedure
- EHLO Function and Procedure
- HELO Function and Procedure
- HELP Function
- MAIL Function and Procedure
- NOOP Function and Procedure
- OPEN_CONNECTION Functions
- OPEN_DATA Function and Procedure
- QUIT Function and Procedure
- RCPT Function
- RSET Function and Procedure
- VRFY Function
- WRITE_DATA Procedure
- WRITE_RAW_DATA Procedure
179 UTL_TCP
180 UTL_URL
181 WPG_DOCLOAD
182 ANYDATA TYPE
183 ANYDATASET TYPE
184 ANYTYPE TYPE
185 Oracle Streams AQ TYPEs
- Summary of Types
- AQ$_AGENT Type
- AQ$_AGENT_LIST_T Type
- AQ$_DESCRIPTOR Type
- AQ$_NTFN_DESCRIPTOR Type
- AQ$_POST_INFO Type
- AQ$_POST_INFO_LIST Type
- AQ$_PURGE_OPTIONS_T Type
- AQ$_RECIPIENT_LIST_T Type
- AQ$_REG_INFO Type
- AQ$_REG_INFO_LIST Type
- AQ$_SUBSCRIBER_LIST_T Type
- DEQUEUE_OPTIONS_T Type
- ENQUEUE_OPTIONS_T Type
- SYS.MSG_PROP_T Type
- MESSAGE_PROPERTIES_T Type
- MESSAGE_PROPERTIES_ARRAY_T Type
- MSGID_ARRAY_T Type
186 Database URI TYPEs
- Summary of URITYPE Supertype Subprograms
- Summary of HTTPURITYPE Subtype Subprograms
- Summary of DBURITYPE Subtype Subprogams
- Summary of XDBURITYPE Subtype Subprograms
- Summary of URIFACTORY Package Subprograms
187 Expression Filter Types
188 JMS Types
- Using JMS Types
- Overview
- Java Versus PL/SQL Data Types
- More on Bytes, Stream and Map Messages
- Using Java Stored Procedures to Encode and Decode Oracle Streams AQ Messages
- Initialize the Jserv Static Variable
- Get the Payload Data Back to PL/SQL
- Garbage Collect the Static Variable
- Use a Message Store: A Static Variable Collection
- Typical Calling Sequences
- Read-Only and Write-Only Modes Enforced for Stream and Bytes Messages
- Differences Between Bytes and Stream Messages
- Getting and Setting Bytes, Map, and Stream Messages as RAW Bytes
- Upcasting and Downcasting Between General and Specific Messages
- JMS Types Error Reporting
- Oracle JMS Type Constants
- CONVERT_JMS_SELECTOR
- Summary of JMS Types
189 Logical Change Record TYPEs
190 interMedia ORDAudio TYPE
191 interMedia ORDDoc TYPE
192 interMedia ORDImage TYPE
193 interMedia ORDImageSignature TYPE
194 interMedia SQL/MM Still Image TYPE
195 interMedia ORDVideo TYPE
196 Rules Manager Types
197 Rule TYPEs
- Summary of Rule Types
- RE$ATTRIBUTE_VALUE Type
- RE$ATTRIBUTE_VALUE_LIST Type
- RE$COLUMN_VALUE Type
- RE$COLUMN_VALUE_LIST Type
- RE$NAME_ARRAY Type
- RE$NV_ARRAY Type
- RE$NV_LIST Type
- RE$NV_NODE Type
- RE$RULE_HIT Type
- RE$RULE_HIT_LIST Type
- RE$TABLE_ALIAS Type
- RE$TABLE_ALIAS_LIST Type
- RE$TABLE_VALUE Type
- RE$TABLE_VALUE_LIST Type
- RE$VARIABLE_TYPE Type
- RE$VARIABLE_TYPE_LIST Type
- RE$VARIABLE_VALUE Type
- RE$VARIABLE_VALUE_LIST Type