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
Contents → Conventions 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?
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
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 … operation was intended and do the appropriate DML operations on the underlying tables. An INSTEAD OF
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
DML and DDL Transactions → permissible 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
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.
Using Synonyms in DML Statements → the jward. employee synonym. A synonym can be referenced in a DML statement the same way that the
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
Stage 1: Client Application Issues DML Statements → At 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 firstname.lastname@example.org...; INSERT INTO orders...; UPDATE email@example.com...; INSERT INTO orders...; UPDATE firstname.lastname@example.org...;
DML Statements on Pipelined Table Function Results → triggers on the view. For information about INSTEAD OF triggers, see \"INSTEAD OF DML Triggers
Conditional Predicates for Detecting Triggering DML Statement → The 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
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
Avoiding Bulk INSERT Failures with DML Error Logging → Avoiding 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.
Avoiding Inner Capture in SELECT and DML Statements → Avoid inner capture of references in SELECT, SELECT INTO, and DML statements by following these
DML → Data manipulation language. Includes statements such as SELECT, INSERT, UPDATE, and DELETE.
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
Data Manipulation Language (DML) Statements → Data 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\".
Optimizing DML Operations During Refresh → strategy 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
DML Behavior → Because 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 Formulas → You 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,