Oracle/PL/SQL
15일차 # 5-20: WHILE Loop
Bohemian life
2012. 4. 24. 21:28
declare
i number := 20;
c number := 0;
begin
while (i > 10) loop
insert into players
values (i, 'Player '||to_char(i)||' entered.');
i := i - 1;
c := c + 1;
end loop;
p(to_char(c)||' data inserted');
end;
/
-----------------------------------------
select * from players;