You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. 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
Results for DML


1 to 20 of 3552 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Triggers

DML TriggersA DML trigger is created on either a table or view, and its triggering event is composed of the DMLDML 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

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Triggers

Compound DML TriggersA 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

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Triggers

INSTEAD OF DML TriggersAn 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

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Triggers

Conditional Predicates for Detecting Triggering DML StatementThe 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

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Optimization and Tuning

DML Statements on Pipelined Table Function Resultstriggers on the view. For information about INSTEAD OF triggers, see \" INSTEAD OF DML Triggers

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Name Resolution

Avoiding Inner Capture in SELECT and DML StatementsAvoid inner capture of references in SELECT, SELECT INTO, and DML statements by following these

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Triggers

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

OLAP DML Reference, 12c Release 1 (12.1)

OLAP DML Reference - Contents

ContentsConventions 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

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Static SQL

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

Database PL/SQL Language Reference, 12c Release 1 (12.1)

Overview of PL/SQL

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,

Database Concepts, 12c Release 1 (12.1)

Data Concurrency and Consistency

DML LocksA 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

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Static SQL

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

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Static SQL

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

Database Concepts, 12c Release 1 (12.1)

Glossary

DMLData manipulation language. Includes statements such as SELECT, INSERT, UPDATE, and DELETE.

Database SQL Language Reference, 12c Release 1 (12.1)

Types of SQL Statements

Data Manipulation Language (DML) StatementsData 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.

Database Administrator's Guide, 12c Release 1 (12.1)

Distributed Transactions Concepts

34.1.1 DML and DDL TransactionsSome 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

Database Concepts, 12c Release 1 (12.1)

SQL

Data Manipulation Language (DML) StatementsData 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

Database SQL Language Reference, 12c Release 1 (12.1)

Automatic Locks in DML Operations

Automatic Locks in DML OperationsThe 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

Database Concepts, 12c Release 1 (12.1)

SQL

Differences Between DML and DDL ProcessingOracle 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

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Views, Sequences, and Synonyms

24.1.5 DML Statements and Join ViewsRestrictions apply when issuing DML statements on join views.