Tutorials
Oracle 9i
Tutorial 9 : Oracle 9i: PL/SQL Control Structures
Tutorial 9 : Oracle 9i: PL/SQL Control Structures - Page 2<
Sponsored Links
Control Structures
This chapter teaches about how to structure flow of control through a PL/SQL program. The control structures of PL/SQL are simple yet powerful. Control structures in PL/SQL can be divided into selection or conditional, iterative and sequential.
Conditional Control (Selection): This structure tests a condition, depending on the condition is true or false it decides the sequence of statements to be executed. Example
IF-THEN, CASE and searched CASE statements.
Syntax for IF-THEN
IF
Statements
END IF;
Example:

IF-THEN-ELSE:
IF
Statements
ELSE
statements
END IF;
Example:

IF-THEN-ELSIF:
IF
Statements
ELSIF
Statements
ELSE
Statements
END IF;

Iterative Control
LOOP statement executes the body statements multiple times. The statements are placed between LOOP – END LOOP keywords.
The simplest form of LOOP statement is an infinite loop. EXIT statement is used inside LOOP to terminate it.
Syntax for LOOP- END LOOP
LOOP
Statements
END LOOP;
Example:
BEGIN
LOOP
DBMS_OUTPUT.PUT_LINE (‘Hello’);
END LOOP;
END;

<
Sponsored Links
Labeling Loops
We can label Loops. A Label is undeclared identifier enclosed between double angle brackets( Ex. <
Next Page: Tutorial 9 : Oracle 9i: PL/SQL Control Structures - Page 2
|
I have completed working with control structures thoroughly.... |
| Can i have sub-loops in PL/SQL? like a loop inside a LOOP?? |
|
this is best tutorial...in real best..........its great |
|
Super site to learn PL/SQL. It had clarified most of my doubts on the subject. |