set serveroutput on;
declare
a1 varchar2(100);
begin
select count(*) into a1 from employees;
for i in 1..a1 loop
dbms_output.put_line('Current value is:'|| i);
end loop;
end;
/
declare
a1 varchar2(100);
begin
select count(*) into a1 from employees;
for i in 1..a1 loop
dbms_output.put_line('Current value is:'|| i);
end loop;
end;
/
No comments:
Post a Comment