How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- Then for a category with search results, click Select to choose your product and release filters, and then click OK.
For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"
How do I find the documentation for my product or service?
From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:
- Click the Find a product tab and search for your product or service.
- Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
- Apple Safari: Version 6
- Google Chrome: Version 29 and later
- Mozilla Firefox: Version 24 and later
- Microsoft Internet Explorer: Version 9 and later
Procedure → This section provides the following tables for the schema object Procedure: Create Drop Execute … Alter Create Table 3-2 Comparison of Creating the Procedure Schema Object in Oracle and Microsoft SQL … : CREATE PROCEDURE procedure [@formal_ parameter formal_parameter_data type [OUTPUT] [= default_value … ] procedural_statements
CommitGrid_Click() Procedure → Feedback CommitGrid_Click() Procedure The cmdCommitGrid_Click() procedure looks like: Private Sub
REVOKE_SYSTEM_PRIVILEGE Procedure → This procedure performs a revoke of a system privilege from a user or role.
GRANT_SWITCH_CONSUMER_GROUP Procedure → This procedure grants the privilege to switch to a resource consumer group.
COMMENT_ON_MVIEW_REPSITES Procedure → This procedure updates the SCHEMA_COMMENT field in the DBA_REPGROUP data dictionary view for the … materialized view group. This procedure must be executed at the materialized view site.
PREPARE_TABLE_INSTANTIATION Procedure → procedure at the source database. This procedure records the lowest SCN of the table for instantiation
DISABLE Procedure → This procedure disables the Flashback mode for the entire session.
ENABLE__GROUPED_POLICY Procedure → This procedure enables or disables a row-level group security policy.
GRANT_OBJECT_PRIVILEGE Procedure → option. To run this procedure, a user must meet at least one of the following requirements: Be the
GET_PERSISTENT_CONN_SUPPORT Procedure → This procedure checks: If the persistent connection support is enabled Gets the maximum number of persistent connections in the current session
SET_BODY_CHARSET Procedure → This procedure sets the character set of the response body when the media type is "text" but the … default to "ISO-8859-1". Use this procedure to change the default body character set a response inherits from the request.
APPLY_SET Procedure → Use this procedure to set and modify the values of initialization parameters that configure and … manage log apply services in a logical standby database environment. Log apply services cannot be running when you use this procedure.
CommitResolve Procedure → Ends a conflict resolution session and saves (makes permanent) any changes in the workspace since the BeginResolve Procedure was executed.
RecoverAllMigratingTables Procedure → after the Workspace Manager migration procedure failed.
SET_FILTER Procedure → SET_FILTER specifies restrictions on the objects to be retrieved, for example, the object name or schema.
TERMINATE Procedure → When you are finished with the package, call the TERMINATE procedure.
PURGE_DIRECT_LOAD_LOG Procedure → This procedure removes entries from the direct loader log after they are no longer needed for any … known materialized view. This procedure usually is used in environments using Oracle's data
AW_CUBE_CREATE Procedure → This procedure creates the containers within an analytic workspace to hold an OLAP Catalog cube
DROP_MASTER_REPGROUP Procedure → This procedure drops a master group from your current site. To drop the master group from all … master sites, including the master definition site, you can call this procedure at the master definition site, and set all_sites to true.
CREATE_QUEUE Procedure → This procedure creates a queue in the specified queue table.
GRANT_QUEUE_PRIVILEGE Procedure → This procedure grants privileges on a queue to users and roles. The privileges are ENQUEUE or … DEQUEUE. Initially, only the queue table owner can use this procedure to grant privileges on the queues.
CREATE_DESCRIPTOR_TYPE Procedure → This procedure creates a descriptor type. A descriptor type serves as a domain for descriptors … which its descriptors may apply. This procedure is only available to DBAs.
AW_CUBE_DEFINE_LOAD Procedure → This procedure creates a load definition for an OLAP Catalog cube. The load definition specifies
AW_DIMENSION_REFRESH Procedure → This procedure uses a load definition to load values from dimension tables into an analytic
CLEAN_ALTER_SESSION Procedure → Contents Index Master Index Feedback View PDF CLEAN_ALTER_SESSION Procedure This procedure removes
MR_REFRESH Procedure → This procedure refreshes the metadata tables that underlie the MRV_OLAP views, as described in "The … creates, drops, or updates OLAP Catalog metadata for the OLAP API. The MR_REFRESH procedure includes a
COMMENT_ON_REPSITES Procedure → If the replication group is a master group, then this procedure updates the MASTER_COMMENT field in … , this procedure updates the SCHEMA_COMMENT field in the DBA_REPGROUP view for a materialized view site … . This procedure can be executed at either a master site or a materialized view site. If you execute … this procedure
BEGIN_LOAD Procedure → This procedure disables triggers while data is imported to the new master site as part of offline … instantiation. You must call this procedure from the new master site. Note: This procedure is used to … procedure should not be confused with the procedures in the DBMS_OFFLINE_SNAPSHOT package (used for
DROP_ALL_TEMPLATE_SITES Procedure → This procedure removes all entries from the DBA_REPCAT_TEMPLATE_SITES view, which keeps a record of … sites that have instantiated a particular deployment template. Caution: This is a dangerous procedure that cannot be undone.
GET_TRANSFER_TIMEOUT Procedure → This procedure retrieves the default timeout value for all future HTTP requests.
ADD_TRANSFORM Procedure → ADD_TRANSFORM specifies a transform that FETCH_xxx applies to the XML representation of the retrieved objects. It is possible to add more than one transform.
SEGMENT_FIX_STATUS Procedure → With this procedure you can fix the corrupted state of a bitmap entry. The procedure either
FILECLOSE Procedure → This procedure closes a BFILE that has already been opened through the input locator. Note: Oracle
BEGIN_TABLE_REORGANIZATION Procedure → This procedure performs a process to preserve materialized view data needed for refresh. It must be called before a master table is reorganized.
Procedure Security → well as packages, is EXECUTE. Grant this privilege only to users who need to execute a procedure or … compile another procedure that calls it. Procedure Execution and Security Domains A user with the … EXECUTE object privilege for a specific procedure can execute the procedure or compile a program unit
REGISTER_USER_REPGROUP Procedure → This procedure assigns proxy materialized view administrator or receiver privileges at the master … site or master materialized view site for use with remote sites. This procedure grants only the
AW_DIMENSION_CREATE Procedure → This procedure creates the containers within an analytic workspace to hold an OLAP Catalog
REMOVEMAP_DIMTBL_HIERSORTKEY Procedure → This procedure removes custom sorting criteria associated with columns in a dimension table.
SET_SCHEMA_INSTANTIATION_SCN Procedure → … This procedure overwrites any existing instantiation SCN for the particular schema. This procedure … , the apply process applies the DDL LCR. The instantiation SCN specified by this procedure is used on … instantiation SCN set by this procedure is used for a DDL LCR with a command_type of CREATE TABLE and
DROP_RULE Procedure → Drops a rule. To run this procedure, a user must meet at least one of the following requirements … set without dropping the rule from the database, use the REMOVE_RULE procedure. The rule evaluation … context associated with the rule, if any, is not dropped when you run this procedure.
ATTACH_SESSION Procedure → This procedure notifies the debug session about the target program.
CREATE_QUEUE_TABLE Procedure → This procedure creates a queue table for messages of a predefined type. The sort keys for dequeue
COMMIT_FORCE Procedure → This procedure is equivalent to following SQL statement: COMMIT FORCE, "
ADD_GROUPED_POLICY Procedure → This procedure adds a policy associated with a policy group.
flush Procedure → This procedure transmits all data in the output buffer, if a buffer is used, to the server immediately.
READ_TEXT Procedure → This procedure reads the HTTP response body in text form and returns the output in the caller
DROP_EDIT_TABLES Procedure → This procedure drops outline editing tables in calling the user's schema.
SetWoOverwriteON Procedure → Enables the VIEW_WO_OVERWRITE history option that had been disabled by the SetWoOverwriteOFF Procedure.
SET_PARSE_ITEM Procedure → SET_PARSE_ITEM enables output parsing by specifying an object attribute to be parsed and returned. It should only be used in conjunction with FETCH_DDL.
ALLOW_ALL Procedure → This procedure empties the Trusted Servers List and specifies that all servers that are members of
START_REDEF_TABLE Procedure → This procedure initiates the redefinition process. After verifying that the table can be redefined
CONVERT_RAW_VALUE Procedure → This procedure converts the internal representation of a minimum or maximum value into a datatype
EXPORT_DATABASE_STATS Procedure → This procedure retrieves statistics for all objects in the database and stores them in the user stat tables identified by statown. stattab
ALTER_REFRESH_TEMPLATE Procedure → This procedure allows the DBA to alter existing deployment templates. Alterations may include
CLEAR_PROP_STATISTICS Procedure → This procedure clears the propagation statistics in the DEFSCHEDULE data dictionary view. When this … procedure is executed successfully, all statistics in this view are returned to zero and statistic … gathering starts fresh. Specifically, this procedure clears statistics from the following columns in
REFRESH Procedure → This procedure refreshes a list of materialized views.
COMMENT_ON_REPGROUP Procedure → This procedure updates the comment field in the DBA_REPGROUP view for a master group. This procedure must be issued at the master definition site.
PURGE_MASTER_LOG Procedure → This procedure removes local messages in the DBA_REPCATLOG view associated with a specified
DROP_ALL_OBJECTS Procedure → This procedure allows the DBA to drop all objects or specific object types from a deployment … template. Caution: This is a dangerous procedure that cannot be undone.