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 LOOP


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


User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Control Structures

LOOPThe 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

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Language Elements, 29 of 52

LOOP StatementsLOOP 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

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Language Elements, 1 of 52

LOOP StatementsMERGE Statement NULL Statement

OLAP User's Guide, 9i Release 2 (9.2.0.2)

OLAP_TABLE, 5 of 6

LOOP sparse_dimensionThe LOOP clause identifies a single named composite that dimensions one or more measures specified

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Control Structures

FOR-LOOPWhereas 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

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Control Structures

WHILE-LOOPThe 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

Performance Tuning Guide and Reference, 9i Release 2 (9.2.0.2)

Introduction to the Optimizer

Nested Loop JoinsNested 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

Workflow Guide (Oracle Workflow Help), 9i Release 2 (9.2.0.2)

Loop Counter Activity (Oracle Workflow Help)

Loop Counter ActivityUse 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

User's Guide and Reference, 9i Release 2 (9.2.0.2)

Sample PL/SQL Programs

Sample 1. FOR LoopThe 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.

Workflow Guide (Oracle Workflow Help), 9i Release 2 (9.2.0.2)

Loop Counter Activity (Oracle Workflow Help)

Oracle Workflow Guide Release 2.6.2                              Contents   Index   Glossary Master Index Feedback

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Control Structures

Iterative Control: LOOP and EXIT StatementsSequential Control: GOTO and NULL Statements

User's Guide and Reference, 9i Release 2 (9.2.0.2)

Interaction Between PL/SQL and Oracle

Passing Parameters to a Cursor FOR LoopYou 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;

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Control Structures

Iterative Control: LOOP and EXIT StatementsLOOP statements let you execute a sequence of statements multiple times. There are three forms of LOOP statements: LOOP, WHILE-LOOP, and FOR-LOOP.

User's Guide and Reference, 9i Release 2 (9.2.0.2)

Interaction Between PL/SQL and Oracle

Defining Aliases for Expression Values in a Cursor FOR LoopFields 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,

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Collections and Records

Reducing Loop Overhead for Collections with Bulk Bindswhen 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 =

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Collections and Records

"Reducing Loop Overhead for Collections with Bulk Binds""What Is a Record?" "Defining and Declaring Records" "Initializing Records"

Error Messages, 9i Release 2 (9.2.0.2)

Oracle Names Control Utility Messages (NNL)

NNL-00999 ALIAS LOOP responses received: numberCause: Control program statistic description. Action: No action required.

Error Messages, 9i Release 2 (9.2.0.2)

Oracle Names Client Messages (NNC)

NNC-00407 alias loop in name requestCause: 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.

Error Messages, 9i Release 2 (9.2.0.2)

Oracle Names Control Utility Messages (NNL)

NNL-00902 ALIAS LOOP responses sent: numberCause: Control program statistic description. Action: No action required.

User's Guide and Reference, 9i Release 2 (9.2.0.2)

Sample PL/SQL Programs

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