RelationalDBDesign
RedhatLinuxSys Seomining
prev next prev next
  Course navigation
 
Lesson 1
Writing control structures
 
Now that you know how to build your first PL/SQL block, let us learn how to write control structures.
Control structures allow you to program your logic based on a certain condition or while a particular condition is satisfied.
In this module, you will learn about conditional control statements such as IF-THEN, as well as iterative control statements such as LOOP and WHILE-LOOP.
Module objectives
By the end of this module, you will know how to:
  1. Build logic by using the IF-THEN-ELSE and ELSIF statements
  2. Determine how to begin and end a simple loop in a PL/SQL block
  3. Observe the structure of FOR and WHILE loops
  4. Define uses for labels and GOTO statements
In the next lesson, we will begin by building logic using IF-THEN-ELSE statements.
  Course navigation