Live ORACLE

DECLARE

  CURSOR c1 IS

    SELECT employee_id,

           last_name,

           salary,

           rowid

    FROM   employees;

   emp_rec  c1%ROWTYPE;

BEGIN

  OPEN c1;

  

  LOOP

    FETCH c1 INTO emp_rec;

    

    EXIT WHEN c1%NOTFOUND;

    

    IF emp_rec.salary = 0 THEN

      DELETE FROM employees

      WHERE       rowid = emp_rec.rowid;

    END IF;

  END LOOP;

  

  CLOSE c1;

END;

/

Using %ROWTYPE with Cursors reference ROWID