[오라클 DB 스터디] PL/SQL - 조건/반복문

1. 조건문

IF condition THEN
    statements;
END IF;

 

CASE selector
WHEN selector_value_1 THEN
    statements_1
WHEN selector_value_1 THEN 
    statement_2
...
ELSE
    else_statements
END CASE;

2. 반복문

<<label>> LOOP
    statements;
END LOOP loop_label;

WHILE condition
LOOP
    statements;
END LOOP;

FOR index IN lower_bound .. upper_bound
LOOP 
    statements; 
END LOOP;