Skip Headers

Oracle® OLAP DML Reference
10g Release 1 (10.1)

Part Number B10339-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

CONTINUE

The CONTINUE command transfers program control to the end of a FOR or WHILE loop (just before the DO/DOEND command), allowing the loop to repeat. You can use CONTINUE only within programs and only with FOR or WHILE.

For more information on controlling program execution, see also BREAK, FOR, SWITCH, and WHILE.

Syntax

CONTINUE

Examples

Example 9-20 Skipping Over Code in a FOR Loop

In the following lines from a program, an IF command is used to test whether total sales for a district exceed 5,000,000. When sales are more this amount, the program goes on to produce a report for that district. However, when a district's sales are less than the amount, the CONTINUE command is used to transfer control to the end of the FOR loop (just before the DOEND command). No lines are produced for that district, and the program goes on to test the next district in the status list.

...
FOR district
    DO          
    IF TOTAL(sales, district) LT 5000000
      THEN CONTINUE
     ... "(report commands for districts with total sales above 5,000,000)
    DOEND
 ...