Control Structures Notes

PL/SQL Control Statement

·     IF THEN

·     IF THEN ELSE

·     IF THEN ELSIF

·     Simple CASE

·     Searched CASE

LOOP Statements

·     Basic LOOP

·     EXIT

·     EXIT WHEN

·     CONTINUE

·     CONTINUE WHEN

·     FOR LOOP Statement

·     FOR LOOP Index

·     Lower Bound and Upper Bound

·     EXIT WHEN or CONTINUE WHEN Statement in FOR LOOP

·     WHILE LOOP

Sequential Control Statements

·     GOTO Statement

·     NULL Statement