Home >> FAQs/Tutorials >> Oracle Tutorials
Oracle Tutorials - Execution Flow Control Statements
(Continued from previous topic...)
What Are the Execution Flow Control Statements?
PL/SQL supports three groups of execution control statements:
- IF Statements - Conditionally executes a block of statements.
- CASE Statements - Selectively executes a block of statements.
- LOOP Statements - Repeatedly executes a block of statements.
- GOTO Statements - Unconditional changes the execution flow to a specified statement.
The script below shows execution control statements:
SQL> set serveroutput on;
2 total NUMBER;
4 total := 0;
6 total := total+1;
7 IF total >= 10 THEN
8 GOTO print;
9 END IF;
10 END LOOP;
12 DBMS_OUTPUT.PUT_LINE('Total counts: '
13 || TO_CHAR(total));
Total counts: 10
This sample script shows you how to use LOOP, IF, and GOTO statements.
(Continued on next topic...)
- What Is PL/SQL?
- What Are the Types PL/SQL Code Blocks?
- How To Define an Anonymous Block?
- How Many Anonymous Blocks Can Be Defined?
- How To Run the Anonymous Block Again?
- What Is a Stored Program Unit?
- How To Create a Stored Program Unit?
- How To Execute a Stored Program Unit?
- How Many Data Types Are Supported?
- What Are the Execution Flow Control Statements?
- How To Use SQL Statements in PL/SQL?
- How To Process Query Result in PL/SQL?
- How To Create an Array in PL/SQL?
- How To Manage Transaction Isolation Level?
- How To Pass Parameters to Procedures?
- How To Define a Procedure inside Another Procedure?
- What Do You Think about PL/SQL?