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 3461 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


OLAP DML Reference, 11g Release 2 (11.2)

OLAP DML Reference - Contents

ContentsConventions What's New in the OLAP DML? New Features in the OLAP DML OLAP DML Statement Changes for … Oracle Database 11 g OLAP DML Statement Changes for Oracle Database 10 g OLAP DML Statement Changes for … Oracle Database 9 i 1 OLAP DML Basic Concepts What is the OLAP DML?

Database PL/SQL Language Reference, 11g Release 2 (11.2)

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, 11g Release 2 (11.2)

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 … operation was intended and do the appropriate DML operations on the underlying tables. An INSTEAD OF

Database PL/SQL Language Reference, 11g Release 2 (11.2)

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 Administrator's Guide, 11g Release 2 (11.2)

Distributed Transactions Concepts

DML and DDL Transactionspermissible operations in distributed transactions: DML and DDL Transactions Transaction Control Statements … DML and DDL Transactions The following are the DML and DDL operations supported in a distributed … SELECT FOR UPDATE You can execute DML and DDL statements in parallel, and INSERT direct load … serial

Database SQL Language Reference, 11g Release 2 (11.2)

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, 11g Release 2 (11.2)

Managing Views, Sequences, and Synonyms

Using Synonyms in DML Statementsthe jward. employee synonym. A synonym can be referenced in a DML statement the same way that the

Database SQL Language Reference, 11g Release 2 (11.2)

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 Administrator's Guide, 11g Release 2 (11.2)

Distributed Transactions Concepts

Stage 1: Client Application Issues DML StatementsAt the Sales department, a salesperson uses SQL*Plus to enter a sales order and then commit it. The application issues several SQL statements to enter the order into the sales database and update the inventory in the warehouse database: CONNECT scott@sales.example.com...; INSERT INTO orders...; UPDATE inventory@warehouse.example.com...; INSERT INTO orders...; UPDATE inventory@warehouse.example.com...;

Database PL/SQL Language Reference, 11g Release 2 (11.2)

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, 11g Release 2 (11.2)

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 … predicate can appear wherever a BOOLEAN expression can appear. Example 9-1 creates a DML trigger that

Database Concepts, 11g Release 2 (11.2)

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 Administrator's Guide, 11g Release 2 (11.2)

Managing Tables

Avoiding Bulk INSERT Failures with DML Error LoggingAvoiding Bulk INSERT Failures wit h DML Error Logging When you load a table using an INSERT … situation by using the DML error logging feature. To use DML error logging, you add a statement clause … during DML operations. When you add this error logging clause to the INSERT statement, certain … statement continues.

Database PL/SQL Language Reference, 11g Release 2 (11.2)

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 Concepts, 11g Release 2 (11.2)

Glossary

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

Database Concepts, 11g Release 2 (11.2)

SQL

How Oracle Database Processes DML… The database must perform a hard parse at least once for every unique DML statement and performs … optimization during this parse. DDL is never optimized unless it includes a DML component such as a … only mandatory step in DML processing. Figure 7-5 is an execution tree, also called a parse tree … EXPLAIN PLAN statement

Database Concepts, 11g Release 2 (11.2)

SQL

Data Manipulation Language (DML) StatementsData manipulation language ( DML ) statements query or manipulate data in existing schema objects … . Whereas DDL statements enable you to change the structure of the database, DML statements enable you … INSERT adds one or more rows to the table. DML statements are the most frequently used SQL … Oracle Database Processes DML\".

Database Data Warehousing Guide, 11g Release 2 (11.2)

Maintaining the Data Warehouse

Optimizing DML Operations During Refreshstrategy addresses the business needs in the most optimal manner. Optimizing DML Operations During … Refresh You can optimize DML performance through the following techniques: Implementing an Efficient

Text Reference, 11g Release 2 (11.2)

CTX_DDL Package

DML BehaviorBecause this procedure is performed online, DML on the base table are permitted during this … operation, and are processed as normal. All DML statements that occur during RECREATE_INDEX_ONLINE are … duration when DML will fail with an error being raised stating that the index is in an in-progress … status. DML

OLAP DML Reference, 11g Release 2 (11.2)

Formulas, Models, Aggregations, and Allocations

OLAP DML FormulasYou can save an expression in a formula. Frequently, you define a formula for ease of use and to save storage space. Once you have defined a formula for an expression, you can use the name of the formula to represent the expression. Oracle OLAP does not store the data for a formula in a variable; instead it calculates the data at run time each time the data is requested. Before you create a formula,