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


User's Guide and Reference, 10g Release 1 (10.1)

LOOP Statements

LOOP StatementsLOOP statements execute a sequence of statements multiple times. The LOOP and END LOOP keywords … enclose the statements. PL/SQL provides four kinds of loop statements: basic loop, WHILE loop, FOR loop … , and cursor FOR loop. For usage information,

User's Guide and Reference, 10g Release 1 (10.1)

4 Using PL/SQL Control Structures

Controlling Loop Iterations: LOOP and EXIT StatementsLOOP statements execute a sequence of statements multiple times. There are three forms of LOOP statements: LOOP, WHILE-LOOP, and FOR-LOOP.

Developer's Guide, 10g Release 1 (10.1)

Loop Counter Activity (Oracle Workflow Developer's Guide)

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, 10g Release 1 (10.1)

4 Using PL/SQL Control Structures

Using the LOOP StatementThe simplest form of LOOP statement is the basic 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 executed, then

Performance Tuning Guide, 10g Release 1 (10.1)

14 The Query 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

User's Guide and Reference, 10g Release 1 (10.1)

4 Using PL/SQL Control Structures

Using the WHILE-LOOP StatementThe WHILE-LOOP statement executes the statements in the loop body as long as a condition is true … : WHILE condition LOOP sequence_of_statements END LOOP; Before each iteration of the loop, the … top of the loop. If it is false or , the loop is skipped and control passes

User's Guide and Reference, 10g Release 1 (10.1)

4 Using PL/SQL Control Structures

Using the FOR-LOOP Statementbefore the loop is entered. A double dot (.. ) serves as the range operator: FOR counter IN [REVERSE … ] lower_bound..higher_bound LOOP sequence_of_statements END LOOP; The range is evaluated when the FOR … loop is first entered and is never re-evaluated. As the next example shows, the sequence of … statements

User's Guide and Reference, 10g Release 1 (10.1)

4 Using PL/SQL Control Structures

Labeling a PL/SQL Loopangle brackets, must appear at the beginning of the LOOP statement, as follows: > LOOP … sequence_of_statements END LOOP; Optionally, the label name can also appear at the end of the LOOP statement, as … the following example shows: > LOOP... END LOOP my_loop; When you nest labeled loops,

User's Guide and Reference, 10g Release 1 (10.1)

6 Performing SQL Operations from PL/SQL

Looping Through Multiple Rows: Cursor FOR Loopimmediately loop once through the rows of the result set. PL/SQL lets you use a simple FOR loop for this kind … of query: The iterator variable for the FOR loop does not need to be declared in advance. It is a … the loop. When you use expressions rather than explicit column names, use column aliases so that you

User's Guide and Reference, 10g Release 1 (10.1)

6 Performing SQL Operations from PL/SQL

Defining Aliases for Expression Values in a Cursor FOR LoopIn a cursor FOR loop, PL/SQL creates a %ROWTYPE record with fields corresponding to columns in the

User's Guide and Reference, 10g Release 1 (10.1)

6 Performing SQL Operations from PL/SQL

Querying Data with PL/SQL: Implicit Cursor FOR Looprecord, and process each row in a loop: You include the text of the query directly in the FOR loop. PL … to the fields of this record variable inside the loop. You can perform tests and calculations … '%$%' ) LOOP dbms_output.put_line('Index = ' || item.object_name || ', Status = ' || item.status); END … LOOP;

User's Guide and Reference, 10g Release 1 (10.1)

11 Tuning PL/SQL Applications for Performance

Reducing Loop Overhead for DML Statements and Queries (FORALL, BULK COLLECT)FORALL statement instead of a loop construct. To speed up SELECT statements, include the BULK COLLECT

Error Messages, 10g Release 1 (10.1)

46 NNL-00001 to NNL-01078

NNL-00902: ALIAS LOOP responses sent: numberCause: Control program statistic description Action: None. NNL-00902: ALIAS LOOP responses sent: number

Error Messages, 10g Release 1 (10.1)

16 ORA-29250 to ORA-32775

ORA-32612: invalid use of FOR loop-dimensional arguments. Action: Check the SQL statement and rewrite if necessary. ORA-32612: invalid use of FOR loop

Error Messages, 10g Release 1 (10.1)

46 NNL-00001 to NNL-01078

NNL-00999: ALIAS LOOP responses received: numberCause: Control program statistic description Action: None. NNL-00999: ALIAS LOOP responses received: number

Error Messages, 10g Release 1 (10.1)

44 NNC-00001 to NNC-00501

NNC-00407: alias loop in name request-try the failing operation with a global name that exists. NNC-00407: alias loop in name request

Error Messages, 10g Release 1 (10.1)

45 NNO-00050 to NNO-00854

NNO-00610: detected possible alias loop involving name " string "… NNO-00610: detected possible alias loop involving name " string "

Error Messages, 10g Release 1 (10.1)

16 ORA-29250 to ORA-32775

ORA-32627: illegal pattern in MODEL FOR LIKE loopCause: FOR loop allows only numeric and datetime without timezone type for bounds. Only constants … statement and rewrite if necessary. ORA-32627: illegal pattern in MODEL FOR LIKE loop

Error Messages, 10g Release 1 (10.1)

62 DRG-10000 to DRG-52210

DRG-12401: invalid template: query within a loopCause: The template is empty. Action: Check the template was installed successfully. DRG-12401: invalid template: query within a loop

Error Messages, 10g Release 1 (10.1)

36 PLS-00049 to PLS-01913

PLS-00364: loop index variable ' string ' use is invalidCause: A literal, constant, IN parameter, loop counter, or function call was mistakenly used as the … statement by using a valid assignment target. PLS-00364: loop index variable ' string ' use is invalid

Error Messages, 10g Release 1 (10.1)

16 ORA-29250 to ORA-32775

ORA-32626: illegal bounds or increment in MODEL FOR loopand rewrite if necessary. ORA-32626: illegal bounds or increment in MODEL FOR loop

Error Messages, 10g Release 1 (10.1)

36 PLS-00049 to PLS-01913

PLS-00373: EXIT label ' string ' must label a LOOP statementprocedure as a function. PLS-00373: EXIT label ' string ' must label a LOOP statement

Error Messages, 10g Release 1 (10.1)

45 NNO-00050 to NNO-00854

NNO-00633: detected fatal delegation loop involving server " string ": detected fatal delegation loop involving server " string "

Error Messages, 10g Release 1 (10.1)

16 ORA-29250 to ORA-32775

ORA-32608: missing INCREMENT or DECREMENT keyword in FOR loopvalue and retry the operation. ORA-32608: missing INCREMENT or DECREMENT keyword in FOR loop

Error Messages, 10g Release 1 (10.1)

16 ORA-29250 to ORA-32775

ORA-29379: resource plan string is involved in a loop in top-plan stringmapping priorities to unique integers within the ORA-29379: resource plan string is involved in a loop in top-plan string

Error Messages, 10g Release 1 (10.1)

36 PLS-00049 to PLS-01913

PLS-00170: the SQL statement in an OPEN statement or FOR loop must be a SELECTconflicting modifiers. PLS-00170: the SQL statement in an OPEN statement or FOR loop must be a SELECT

Error Messages, 10g Release 1 (10.1)

36 PLS-00049 to PLS-01913

PLS-00374: illegal EXIT statement; it must appear inside the loop labeled ' string 'Cause: The label in an EXIT statement does not refer to a loop. An EXIT statement need not specify … a label. However, if a label is specified (as in EXIT my_label), it must refer to a loop statement … . Action: Make sure the label name is spelled correctly and that it refers to a loop statement. PLS … -00374: illegal EXIT statement;

Error Messages, 10g Release 1 (10.1)

18 ORA-33000 to ORA-37134

ORA-36800: XSTBLFUNC00 The OLAP_TABLE function can only have a single LOOP statement within the LIMITMAP) The OLAP_TABLE function can only have a single LOOP statement within the LIMITMAP

Error Messages, 10g Release 1 (10.1)

36 PLS-00049 to PLS-01913

PLS-00376: illegal EXIT statement; it must appear inside a loopfrom outside a construct (a loop or exception handler, for example) that contains a sequence of … sequence of statements. PLS-00376: illegal EXIT statement; it must appear inside a loop

Error Messages, 10g Release 1 (10.1)

36 PLS-00049 to PLS-01913

PLS-00421: synonym definitions nested too deeply; possible loop in synonymsspecify a database link. PLS-00421: synonym definitions nested too deeply; possible loop in synonyms

User's Guide and Reference, 10g Release 1 (10.1)

EXIT Statement

EXIT StatementThe EXIT statement breaks out of a loop. The EXIT statement has two forms: the unconditional EXIT … and the conditional EXIT WHEN. With either form, you can name the loop to be exited. For more … information, see "Controlling Loop Iterations: LOOP and EXIT Statements". Syntax Description of the … returns the Boolean

Packages and Types Reference, 10g Release 1 (10.1)

13 DBMS_ALERT

SET_DEFAULTS ProcedureIn case a polling loop is required, use the SET_DEFAULTS procedure to set the polling interval.

Packages and Types Reference, 10g Release 1 (10.1)

114 DBMS_XMLGEN

Usage NotesThis function is used to determine the terminating condition if calling GETXML Functions in a loop.

User's Guide and Reference, 10g Release 1 (10.1)

4 Using PL/SQL Control Structures

Using the EXIT-WHEN StatementThe EXIT-WHEN statement lets a loop complete conditionally. When the EXIT statement is encountered … , the condition in the WHEN clause is evaluated. If the condition is true, the loop completes and … control passes to the next statement after the loop: LOOP FETCH c1 INTO... EXIT WHEN c1%NOTFOUND … ; -- exit loop

User's Guide and Reference, 10g Release 1 (10.1)

4 Using PL/SQL Control Structures

Using the EXIT StatementThe EXIT statement forces a loop to complete unconditionally. When an EXIT statement is encountered … , the loop completes immediately and control passes to the next statement: LOOP IF credit_rating … Remember, the EXIT statement must be placed inside a loop. To complete a PL/SQL block before its

DML Reference, 10g Release 1 (10.1)

OKFORLIMIT

NOYou cannot limit the dimension you are looping over within an explicit FOR loop. (Default) YES You … can limit the dimension you are looping over within an explicit FOR loop. Notes Related Statements … See the TEMPSTAT command to set the status of the dimension you are looping over in a loop that is … generated by a REPORT command.

DML Reference, 10g Release 1 (10.1)

SQL

cursorThe name of a declared and opened cursor. LOOP Specifies that Oracle OLAP should implicitly loop … individual fields to objects specified as target analytic workspace objects. When you include a LOOP clause … cursor, or an error occurs, or loopcount is satisfied. In most cases, you should use the LOOP clause

DML Reference, 10g Release 1 (10.1)

OKFORLIMIT

OKFORLIMITexplicit FOR loop. Data type BOOLEAN Syntax OKFORLIMIT = { NO |YES} Arguments

Pro*C/C++ Programmer's Guide, 10g Release 1 (10.1)

7 Embedded PL/SQL

7.1.3 Cursor FOR Loopsmanipulate a cursor. Instead, you can use a cursor FOR loop, which implicitly declares its loop index as a … empno, sal, comm FROM emp) LOOP IF emprec.comm / emprec.sal > 0.25 THEN...... END LOOP; END; Notice

Pro*COBOL® Programmer's Guide, 10g Release 1 (10.1)

6 Embedded PL/SQL

6.2.3 Cursor FOR Loopsmanipulate a cursor. Instead, you can use a cursor FOR loop, which implicitly declares its loop index as a … empno, sal, comm FROM emp) LOOP IF emprec.comm / emprec.sal > 0.25 THEN...... END LOOP; END; Notice

User's Guide and Reference, 10g Release 1 (10.1)

6 Performing SQL Operations from PL/SQL

Querying Data with PL/SQL: Explicit Cursor FOR Loopsdeclare a cursor that specifies the query, and process the results using a FOR loop. The following PL/SQ … object_type = 'TABLE' AND object_name NOT LIKE '%$%'; BEGIN FOR item IN c1 LOOP dbms_output.put_line … ('Table = ' || item.object_name || ', Status = ' || item.status); END LOOP; END; / See also: LOOP Statements

Release 1.8, 10g Release 1 (10.1)

Embedded SQL Commands and Directives

ExampleGOTO... LOOP EXEC SQL FETCH emp_cursor INTO:job_title1,:salary1; EXEC SQL FETCH emp_cursor INTO:job_title2,:salary2;... END LOOP;...

DML Reference, 10g Release 1 (10.1)

AGGMAP

These indexes are used in the MODEL in an aggregation statement and in statements that use the ACROSS…ACROSS phrase to help Oracle OLAP loop over variables that are dimensioned by composites. These

API Reference, 10g Release 1 (10.1)

Looping (Oracle Workflow API Reference)

Loopingbeen completed. The first activity that gets detected as a revisited activity is also called a loop … once. Reset the loop to the loop point before reexecuting by first running logic to undo the … activities within the loop. Reexecute the loop point and all activities within the loop

User's Guide and Reference, 10g Release 1 (10.1)

10 Handling PL/SQL Errors

Retrying a Transactiontechnique is: Encase the transaction in a sub-block. Place the sub-block inside a loop that repeats … , commit, then exit from the loop. If the transaction fails, control transfers to the exception handler … column. In that case, we change the value that needs to be unique and continue with the next loop … iteration. If the INSERT

DML Reference, 10g Release 1 (10.1)

WHILE

boolean-expressioncauses the Boolean expression to become FALSE. otherwise, the code becomes an endless loop … include a BREAK, RETURN, or EXIT command between DO... DOEND so the program can finish the loop … . Branching in a Loop You can use the BREAK, CONTINUE, and GOTO commands to branch within, or out of, a WHILE … loop, thereby

User's Guide and Reference, 10g Release 1 (10.1)

G Frequently Asked Questions About PL/SQL

How Do I Continue After a PL/SQL Exception?putting a BEGIN-END block with an exception handler inside a loop, you can continue executing the loop even if some loop iterations raise exceptions.

User's Guide and Reference, 10g Release 1 (10.1)

1 Overview of PL/SQL

Processing Queries with PL/SQL(SELECT * FROM employees) LOOP DBMS_OUTPUT.PUT_LINE('First name = ' || someone.first_name … ); DBMS_OUTPUT.PUT_LINE('Last name = ' || someone.last_name); END LOOP; You can use a simple loop like the one

DML Reference, 10g Release 1 (10.1)

ACROSS

ACROSSin a loop. The repetition of these statements is controlled by the status of the dimensions and composites specified in the ACROSS command.

Administrator's Guide, 10g Release 1 (10.1)

24 Using the Database Resource Manager

Creating the Environmentm NUMBER; BEGIN FOR i IN 1..100000 LOOP FOR j IN 1..100000 LOOP m:= sqrt(4567); END LOOP; END LOOP; END; END; /

Packages and Types Reference, 10g Release 1 (10.1)

156 UTL_HTTP

General Usage:= utl_http.get_response(req); LOOP utl_http.read_line(resp, value, TRUE); dbms_output.put_line … (value); END LOOP; utl_http.end_response(resp); EXCEPTION WHEN utl_http.end_of_body THEN … ) LOOP utl_http.get_header(resp, i, name, value); dbms_output.put_line(name || ': ' || value); END LOOP; utl_http.end_response(resp);

Packages and Types Reference, 10g Release 1 (10.1)

123 HTF

Parameters… cloop The value for the LOOP attribute. cattributes The other attributes to be included as-is in the tag.

DML Reference, 10g Release 1 (10.1)

FOR

dimensionstatus is restored to what it was before the loop, and execution of the program resumes with the … next statement. Status Inside a Loop The TEMPSTAT command limits the dimension you are looping over … inside a FOR loop or inside a loop that is automatically generated by the REPORT command. No Sorting … Because

Packages and Types Reference, 10g Release 1 (10.1)

128 HTP

Parameters… cloop The value for the LOOP attribute. cattributes The other attributes to be included as-is in the tag.

User's Guide and Reference, 10g Release 1 (10.1)

2 Fundamentals of the PL/SQL Language

Assigning Boolean Valuesdone != TRUE -- Compare to a literal value LOOP counter:= counter + 1; done:= (counter > 500); -- If counter > 500, DONE = TRUE END LOOP; END; /

Developer's Guide, 10g Release 1 (10.1)

Creating Multiple Transitions to a Single Activity (Oracle Workflow Developer's Guide)

If you have multiple incoming transitions from parallel branches, you should always use an AND, OR,parallel branches, you want to create a loop in your process. By using a joining activity to merge … parallel branches and designating the following activity as the start of the loop, you create a less

Reference, 10g Release 1 (10.1)

8 CTX_DOC Package

query_id… .the_tokens.count loop dbms_output.put_line(the_tokens(i).token); end loop; end;

Release 1.8, 10g Release 1 (10.1)

Using Embedded PL/SQL

SubprogramsDECLARE... BEGIN FOR emprec IN (SELECT empno, sal, comm FROM emp) LOOP IF emprec.comm / emprec.sal … > 0.25 THEN...... END LOOP; END; Notice that you use dot notation to reference fields in the

Reference, 10g Release 1 (10.1)

10 CTX_QUERY Package

part_name… .resarr.count loop dbms_output.put_line(resarr(i).word || ':' || resarr(i).doc_count); end loop; end;

DML Reference, 10g Release 1 (10.1)

TEMPSTAT

TEMPSTATThe TEMPSTAT command limits the dimension you are looping over, inside a FOR loop or inside a loop