Home >> FAQs/Tutorials >> Oracle Tutorials

Oracle Tutorials - Types of Execution Flow Control Statements

By: FYIcenter.com

(Continued from previous topic...)

What Are the Execution 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 some execution control statements:

DECLARE
  total NUMBER;
BEGIN
  total := 0;
  LOOP
    total := total+1;
    IF total >= 10 THEN
      GOTO print;
    END IF;
  END LOOP;
  <>
  DBMS_OUTPUT.PUT_LINE('Total counts: ' || TO_CHAR(total));
END;

This script should print this:

Total counts: 10
`

(Continued on next topic...)

  1. Is PL/SQL Language Case Sensitive?
  2. How To Enter Comments in PL/SQL?
  3. What Are the Types of PL/SQL Code Blocks?
  4. What Is an Anonymous Block?
  5. What Is a Named Program Unit?
  6. What Is a Procedure?
  7. What Is a Function?
  8. How To Declare a Local Variable?
  9. How To Initialize Variables with Default Values?
  10. How To Assign Values to Variables?
  11. What Are the Arithmetic Operations?
  12. What Are the Numeric Comparison Operations?
  13. What Are the Logical Operations?
  14. How Many Categories of Data Types?
  15. How Many Scalar Data Types Are Supported in PL/SQL?
  16. How To Convert Character Types to Numeric Types?
  17. What Are the Execution Control Statements?
  18. How To Use "IF" Statements on Multiple Conditions?
  19. How To Use "WHILE" Loop Statements?
  20. How To Use "FOR" Loop Statements?
  21. What Is NULL in PL/SQL?
  22. How To Test NULL Values?

Oracle Tutorials:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...