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
LOOP → The simplest form of LOOP statement is the basic (or infinite) loop, which encloses a sequence of … statements between the keywords LOOP and END LOOP, as follows: LOOP sequence_of_statements END LOOP … ; With each iteration of the loop, the sequence of statements is
LOOP Statements → LOOP statements execute a sequence of statements multiple times. The loop encloses the sequence of … statements that is to be repeated. PL/SQL provides four kinds of loop statements: basic loop, WHILE … loop, FOR loop, and cursor FOR loop. For more information, see "Iterative
LOOP Statements → MERGE Statement NULL Statement
LOOP sparse_dimension → The LOOP clause identifies a single named composite that dimensions one or more measures specified
FOR-LOOP → Whereas the number of iterations through a WHILE loop is unknown until the loop completes, the … number of iterations through a FOR loop is known before the loop is entered. FOR loops iterate over a … keywords FOR and LOOP. A double dot (.. ) serves as the range operator. The syntax follows: FOR counter
WHILE-LOOP → The WHILE-LOOP statement associates a condition with a sequence of statements enclosed by the … keywords LOOP and END LOOP, as follows: WHILE condition LOOP sequence_of_statements END LOOP; Before each … iteration of the loop, the condition is evaluated. If the condition is true, the
Nested Loop Joins → Nested loop joins are useful when small subsets of data are being joined and if the join condition … the outer table, then the same rows are retrieved for every iteration of the outer loop, degrading … better. See Also: "Cartesian Joins" A nested loop join involves the following steps: The optimizer … . The outer loop
Loop Counter Activity → Use the Loop Counter activity to limit the number of times the Workflow Engine transitions through … a particular path in a process. The Loop Counter activity can have a result of Loop or Exit. This … Loop Counter activity calls the PL/SQL procedure named WF_STANDARD.LOOPCOUNTER. Activity Attribute The … Loop
Sample 1. FOR Loop → The following example uses a simple FOR loop to insert ten rows into a database table. The values … of a loop index, counter variable, and either of two character strings are inserted. Which string is inserted depends on the value of the loop index.
Oracle Workflow Guide Release 2.6.2 → Contents Index Glossary Master Index Feedback
Iterative Control: LOOP and EXIT Statements → Sequential Control: GOTO and NULL Statements
Passing Parameters to a Cursor FOR Loop → You can pass parameters to the cursor in a cursor FOR loop. In the following example, you pass a … emp_cursor. */ FOR emp_record IN emp_cursor(20) LOOP emp_record.comm:= NVL(emp_record.comm, 0 … IF; END LOOP; INSERT INTO temp VALUES (high_paid, higher_comm, 'Total Wages: ' || TO_CHAR(total_wages)); COMMIT; END;
Iterative Control: LOOP and EXIT Statements → LOOP statements let you execute a sequence of statements multiple times. There are three forms of LOOP statements: LOOP, WHILE-LOOP, and FOR-LOOP.
Defining Aliases for Expression Values in a Cursor FOR Loop → Fields in the implicitly declared record hold column values from the most recently fetched row. The fields have the same names as corresponding columns in the SELECT list. But, what happens if a select item is an expression? Consider the following example: CURSOR c1 IS SELECT empno, sal+NVL(comm,0), job FROM... In such cases, you must include an alias for the select item. In the following example,
Reducing Loop Overhead for Collections with Bulk Binds → when a loop executes a separate SQL statement for each element of a collection, specifying the … engine with each iteration of the FOR loop: DECLARE TYPE NumList IS VARRAY(20) OF NUMBER; depts NumList … := NumList(10, 30, 70); -- department numbers BEGIN... FOR i IN depts.FIRST..depts.LAST LOOP … DELETE FROM emp WHERE deptno =
"Reducing Loop Overhead for Collections with Bulk Binds" → "What Is a Record?" "Defining and Declaring Records" "Initializing Records"
NNL-00999 ALIAS LOOP responses received: number → Cause: Control program statistic description. Action: No action required.
NNC-00407 alias loop in name request → Cause: The name service detected an "alias loop" when trying to retrieve information associated … with a global name. An alias loop occurs when an alias name X points to another alias name Y, which in … your name server administrator to have the alias loop investigated and fixed.
NNL-00902 ALIAS LOOP responses sent: number → Cause: Control program statistic description. Action: No action required.
Output Table → -------- -------- ------------- 1000 1 in OUTER loop 1 2 inner loop 2 3 inner loop 3 4 inner loop 4 5 inner loop 2000 6 in OUTER loop … 1 7 inner loop 2 8 inner loop 3 9 inner loop 4 10 inner loop 3000 11 in OUTER loop