How To Write PL/SQL block using Implicit cursor.

INPUT

declare

            mjob emp.job%type;

begin

            mjob:='&mjob';

            update emp set sal=sal+sal*0.1 where job=mjob;

                        if sql%found then

                        dbms_output.put_line('no of rows updated are:'||sql%rowcount);

                        commit;

            else

                        dbms_output.put_line('no such record found');

            end if;

end;

/

OUTPUT

1)

Enter value for mjob: staff

old   4:  mjob:='&mjob';

new   4:  mjob:='staff';

no of rows updated are:6

PL/SQL procedure successfully completed.

        NO NAME     JOB               SAL    DEPT_NO

---------- -------- ---------- ---------- ----------

       101 renuka   staff           11000          1

       102 krishna  staff           11000          1

       103 rachna   HOD             20000          1

       201 mansi    staff           11000          2

       202 jenny    staff           11000          2

       203 teena    HOD             20000          2

       301 pooja    staff           11000          3

       302 pinky    staff           11000          3

       303 sevu     HOD             20000          3

       400 fairy    Principal       50000          4

2)

Enter value for mjob: manager

old   4:  mjob:='&mjob';

new   4:  mjob:='manager';

no such record found

PL/SQL procedure successfully completed.