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
Statement Description → BREAK Transfers program control from within a SWITCH, FOR, or WHILE statement to the statement immediately following the DOEND associated with SWITCH, FOR, or WHILE. CONTINUE Transfers program control to the end of a FOR or WHILE loop (just before the DO/DOEND statement), allowing the loop to repeat. You can use CONTINUE only within programs and only with FOR or WHILE. DO... DOEND statements Brackets
Using Level Markers → When you are saving the values of several dimensions and options, then PUSHLEVEL and POPLEVEL statements provide a convenient way to save and restore the session environment. You first use a PUSHLEVEL statement to establish a level marker. Once the level marker is established, you use a PUSH statement to save the status of dimensions and the values of options or single-cell variables. When you place
Trapping an Error → To make sure the program works correctly, you should anticipate errors and set up a system for handling them. You can use a TRAP statement to turn on an error-trapping mechanism in a program. When error trapping is on and an error is signaled, then the execution of the program is not halted. Instead, error trapping does the following: Turns off the error-trapping mechanism to prevent endless looping
DML and DDL Transactions → The following are the DML and DDL operations supported in a distributed transaction: CREATE TABLE … DML and DDL statements in parallel, and INSERT direct load statements serially, but note the … cannot perform remote operations after issuing parallel DML/DDL or direct load INSERT. If the … is actually a synonym for a local object.
Data Manipulation Language (DML) Statements → To manipulate database data, you can include DML operations, such as INSERT, UPDATE, and DELETE … COMMIT statement To find out how many rows are affected by DML statements, you can check the value of … manipulation (DML) statement in PL/SQL, there are some situations when the value of a variable is undefined … , then the values
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.
DML Statements and Join Views → The general rule is that any UPDATE, DELETE, or INSERT statement on a join view can modify only one underlying base table. The following examples illustrate rules specific to UPDATE, DELETE, and INSERT statements.
Using Synonyms in DML Statements → the jward. employee synonym. A synonym can be referenced in a DML statement the same way that the
Performing DML Operations Inside Pipelined Table Functions → To execute DML statements, declare a pipelined table function with the AUTONOMOUS_TRANSACTION
Inserting Data with DML Error Logging → Inserting Data wit h DML Error Logging When you load a table using an INSERT statement with … the DML error logging feature. To use DML error logging, you add a statement clause that specifies … the name of an error logging table into which the database records errors encountered during DML … continues. You then
Performing DML Operations on Pipelined Table Functions → triggers can be defined for all DML operations on a view built on a table function.
Avoiding Inner Capture in DML Statements → You can avoid inner capture in DML statements by following these rules: Specify an alias for each … table in the DML statement. Keep table aliases unique throughout the DML statement. Avoid table
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 a number of SQL statements to enter the order into the sales database and update the inventory in the warehouse database: CONNECT email@example.com...; INSERT INTO orders...; UPDATE firstname.lastname@example.org...; INSERT INTO orders...; UPDATE email@example.com...;
Parallel DML → scale up large DML operations against large database tables and indexes. Note: Although DML generally … includes queries, in this chapter the term DML refers only to inserts, updates, merges, and deletes … . This section discusses the following parallel DML topics: Advantages of Parallel DML over Manual
DML Locks → The purpose of a DML lock (data lock) is to guarantee the integrity of data being accessed … concurrently by multiple users. DML locks prevent destructive interference of simultaneous conflicting DML … or DDL operations. DML statements automatically acquire both table-level locks and row-level locks … topics:
Running One DML Statement Multiple Times (FORALL Statement) → The keyword FORALL lets you run multiple DML statements very efficiently. It can only repeat a … single DML statement, unlike a general-purpose FOR loop. For full syntax and restrictions, see FORALL … ; END IF; END LOOP; -- Now it's easy to run one DML statement -- on one subset of elements, -- and … another DML
Parallel DML Tips → This section provides an overview of parallel DML functionality. The topics covered include … : Parallel DML Tip 1: INSERT Parallel DML Tip 2: Direct-Path INSERT Parallel DML Tip 3: Parallelizing INSERT … , MERGE, UPDATE, and DELETE Parallel DML Tip 1: INSERT The functionality available using an INSERT
Affinity and Parallel DML → For parallel DML (inserts, updates, and deletes), affinity enhancements improve cache performance … by routing the DML operation to the node that has affinity for the partition. Affinity determines how … to distribute the work among the set of instances or parallel execution servers to perform the DML … DML when
DML → Data manipulation language. Includes statements like INSERT, UPDATE, and DELETE, which change data in tables.
Reducing Loop Overhead for DML Statements and Queries with Bulk SQL → PL/SQL sends SQL statements such as DML and queries to the SQL engine for execution, and SQL … COLLECT clause brings back batches of results from SQL. If the DML statement affects four or more database … any number of rows, without requiring a FETCH statement for each one. Note: Parallel DML is disabled … the BULK COLLECT clause.