Thursday, July 21, 2011

while loop in PLSQL

Declare
v_emp emp.ename%type;
v_no number := 1;
begin
while v_no <= 10   -- 10 times loop you can write any condition
loop
dbms_output.put_line('In LOOP '||v_no);

v_no := v_no +1;
end loop;

end;

end;

No comments:

Post a Comment