IF boolean-expression THEN <statements> END IF;
IF-THEN statements are the simplest form of IF. The statements between THEN and END IF are executed if the condition is TRUE. Otherwise, they are skipped.
IF-THEN
IF
THEN
END IF
TRUE
This example uses IF-THEN statement to test and display employees who have a commission:
DECLARE v_empno emp.empno%TYPE; v_comm emp.comm%TYPE; CURSOR emp_cursor IS SELECT empno, comm FROM emp; BEGIN OPEN emp_cursor; DBMS_OUTPUT.PUT_LINE('EMPNO COMM'); DBMS_OUTPUT.PUT_LINE('----- -------'); LOOP FETCH emp_cursor INTO v_empno, v_comm; EXIT WHEN emp_cursor%NOTFOUND; -- -- Test whether or not the employee gets a commission -- IF v_comm IS NOT NULL AND v_comm > 0 THEN DBMS_OUTPUT.PUT_LINE(v_empno || ' ' || TO_CHAR(v_comm,'$99999.99')); END IF; END LOOP; CLOSE emp_cursor; END;
The following is the output from this program:
EMPNO COMM ----- ------- 7499 $300.00 7521 $500.00 7654 $1400.00
IF statement
IF-THEN-ELSE