set serveroutput on;
DECLARE
total_rows number(2);
BEGIN
UPDATE e1111
SET esalary = esalary + 500;
IF sql%notfound THEN
dbms_output.put_line('no customers selected');
ELSIF sql%found THEN
total_rows := sql%rowcount;
dbms_output.put_line( total_rows || ' customers selected ');
END IF;
END;
DECLARE
total_rows number(2);
BEGIN
UPDATE e1111
SET esalary = esalary + 500;
IF sql%notfound THEN
dbms_output.put_line('no customers selected');
ELSIF sql%found THEN
total_rows := sql%rowcount;
dbms_output.put_line( total_rows || ' customers selected ');
END IF;
END;
No comments:
Post a Comment