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
DML Triggers → A DML trigger is created on either a table or view, and its triggering event is composed of the DML … DML trigger is either simple or compound. A simple DML trigger fires at exactly one of these timing … -level AFTER trigger. ) A compound DML trigger created on a table or editioning view can fire at
Compound DML Triggers → A compound DML trigger created on a table or editioning view can fire at multiple timing points … statement causes an error. A compound DML trigger created on a noneditioning view is not really … Compound DML Trigger Structure Compound DML Trigger Restrictions Performance Benefit of Compound DML
INSTEAD OF DML Triggers → An INSTEAD OF DML trigger is a DML trigger created on a noneditioning view, or on a nested table … triggering DML statement. An INSTEAD OF trigger cannot be conditional. An INSTEAD OF trigger is the only … what operation was intended and do the appropriate DML operations on the underlying tables. An INSTEAD
Conditional Predicates for Detecting Triggering DML Statement → The triggering event of a DML trigger can be composed of multiple triggering statements. When one … . Example 9-1 Trigger Uses Conditional Predicates to Detect Triggering Statement This example creates a DML
DML Statements on Pipelined Table Function Results → triggers on the view. For information about INSTEAD OF triggers, see \" INSTEAD OF DML Triggers
Avoiding Inner Capture in SELECT and DML Statements → Avoid inner capture of references in SELECT, SELECT INTO, and DML statements by following these
In a FORALL statement, the DML statement can have a RETURNING BULK COLLECT INTO clause. For each iteration… → Using Compound DML Triggers with Bulk Insertion A compound DML trigger is useful for accumulating … (otherwise, the FORALL statement does a single-row DML operation multiple times). For more information
Contents → Conventions Changes in This Release for Oracle OLAP DML Reference Changes in Oracle OLAP in Oracle … Database 12 c Release 1 (12.1) 1 OLAP DML Basic Concepts What is the OLAP DML? Cube-Aware OLAP DML … Statements OLAP DML Statements that Work Directly on Analytic Workspace Objects Basic Syntactic Units
Every named cursor explicit cursor or cursor variable has four attributes, each of which returns information… → Formal Cursor Parameters with Default Values When you create an explicit cursor with formal parameters, you can specify default values for them. When a formal parameter has a default value, its corresponding actual parameter is optional. If you open the cursor without specifying the actual parameter, then the formal parameter has its default value. Example 6-12 creates an explicit cursor whose formal
A cursor is a pointer to a private SQL area that stores information about processing a specific SELECT… → Cursors A cursor is a pointer to a private SQL area that stores information about processing a specific SQL statement or PL/SQL SELECT INTO statement. You can use the cursor to retrieve the rows of the result set one at a time. You can use cursor attributes to get information about the state of the cursor—for example, how many rows the statement has affected so far. For more information about cursors,
DML Locks → A DML lock, also called a data lock, guarantees the integrity of data accessed concurrently by … multiple users. For example, a DML lock prevents two customers from buying the last copy of a book … available from an online bookseller. DML locks prevent destructive interference of simultaneous … conflicting DML
An explicit cursor is a named pointer to a private SQL area that stores information for processing a… → Variables in Explicit Cursor Queries An explicit cursor query can reference any variable in its scope. When you open an explicit cursor, PL/SQL evaluates any variables in the query and uses those values when identifying the result set. Changing the values of the variables later does not change the result set. In Example 6-8, the explicit cursor query references the variable factor. When the cursor
An explicit cursor is a named pointer to a private SQL area that stores information for processing a… → Declaring and Defining Explicit Cursors You can either declare an explicit cursor first and then define it later in the same block, subprogram, or package, or declare and define it at the same time. An explicit cursor declaration, which only declares a cursor, has this syntax: CURSOR cursor_name [ parameter_list ] RETURN return_type; An explicit cursor definition has this syntax: CURSOR cursor_name
DML → Data manipulation language. Includes statements such as SELECT, INSERT, UPDATE, and DELETE.
Data Manipulation Language (DML) Statements → Data manipulation language (DML) statements access and manipulate data in existing schema objects … a limited form of DML statement in that it can only access data in the database. It cannot … dynamically. All other DML statements are fully supported in PL/SQL.
34.1.1 DML and DDL Transactions → Some DML and DDL operations are supported in a distributed transaction. The following are the DML … (default and direct load) UPDATE LOCK TABLE SELECT SELECT FOR UPDATE You can execute DML and DDL … operations after issuing parallel DML/DDL or direct load INSERT. If the transaction begins using XA … synonym for
Data Manipulation Language (DML) Statements → Data manipulation language ( DML ) statements query or manipulate data in existing schema objects … . Whereas DDL statements change the structure of the database, DML statements query or change the … rows to the table. DML statements are the most frequently used SQL statements and enable you to … access by other users ( LOCK TABLE
Automatic Locks in DML Operations → The purpose of a DML lock, also called a data lock, is to guarantee the integrity of data being … accessed concurrently by multiple users. For example, a DML lock can prevent multiple customers from … buying the last copy of a book available from an online bookseller. DML locks prevent destructive … interference of simultaneous
Differences Between DML and DDL Processing → Oracle Database processes DDL differently from DML. For example, when you create a table, the … and carries out the command. In contrast to DDL, most DML statements have a query component. In a