Social Icons

Tuesday 3 December 2013

IMPLICIT Cursor in PL/SQL

set serveroutput on;
declare
idc number(2);

begin

update e1111 set id=id+500;


if sql%notfound then
dbms_output.put_line('not found');

ELSIF sql%found THEN
      idc := sql%rowcount;
      dbms_output.put_line( idc || ' customers selected ');
   END IF;
END;

No comments:

Post a Comment

 

Sample Text

Sample text

 
Just Programming Cse DriveReputation Management