Control Structures

Control structures do two things; they check a logical condition to branch program execution, or they iterate over a condition until the condition is met or they are instructed to exit. The conditional structures section covers IF, ELSIF, ELSE, and CASE statements, and the iterative structures section 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; one is the IF statement and the other is the CASE statement. The IF statement that has two subtypes, the if-then-else and if-then-elsif-then-else. The elsifis not a typo but the correct reserved word in PL/SQL, as well ...

Get Oracle Database Ajax & PHP Web Application Development now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.