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;
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