1IF condition1 THEN
2 statements;
3ELSEIF condition2 THEN # OPTIONAL
4 statements;
5ELSE # OPTIONAL
6 statements;
7END IF;
1-- PL/SQL
2BEGIN
3 IF my_val = 1 THEN [...]
4 ELSE [...]
5 END IF;
6END;
7-- In a query
8SELECT CASE WHEN my_col = 1 THEN 'Ok' ELSE 'Ko' END AS my_result;