Control Structures

Control structures do one of two things: they check a logical condition to branch program execution, or they iterate over a condition until it is met or they are instructed to exit. The section “Conditional Structures” covers if, elsif, else, and case statements, and the section “Iterative Structures” covers looping with for and while structures.

Conditional Structures

Conditional statements check whether a value meets a condition before taking action. There are two types of conditional structures in PL/SQL: the IF statement and the CASE statement. The IF statement that has two subtypes: if-then-else and if-then-elsif-then-else. The elsif is not a typo but the correct reserved word in PL/SQL, as well as Pascal and Ada programming ...

Get Oracle Database 10g Express Edition PHP Web Programming now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.