EXAMPLE PROGRAM USING IMPLICIT CURSOR

EXAMPLE:

DECLARE

V_DEPT    NUMBER:=&V_DEPT;

BEGIN

UPDATE  EMP  SET  SAL:=SAL+1000   WHERE   DEPTNO=&V_DEPT;

IF  SQL%NOTFOUND   THEN

DBMS_OUTPUT.PUT_LINE('UNABLE TO UPDATE ROWS NO SUCH DEPT EXIST');

ELSE

DBMS_OUTPUT.PUT_LINE(SQL%ROWCOUNT||'EMPLOYEES ARE UPDATED SUCCESSFULLY');

END IF;

END;