Live ORACLE

DECLARE

v_job_id  VARCHAR2(10);

 v_emp_id  NUMBER(6) := 110;

BEGIN

SELECT job_id

INTO   v_job_id

FROM   employees

WHERE  employee_id = v_emp_id;



IF v_job_id = 'SA_REP' THEN

  UPDATE employees

  SET    commission_pct = commission_pct * 1.2;

ELSE

  NULL; -- do nothing if not a sales representative

END IF;

END;

/

Using the NULL Statement to Show No Action