Oracle/PL/SQL
15일차 # 5-22: FOR Loop
Bohemian life
2012. 4. 24. 21:28
begin
for i in 1..10 loop
insert into players
values (i, 'Player '||to_char(i)||' entered.');
end loop;
p(to_char(i)||' data inserted'); --> 에러가 발생하면서 Tx 롤백 되었습니다.
end;
/
↓ ↓ ↓
declare
c number := 0;
begin
for i in 1..10 loop
insert into players
values (i, 'Player '||to_char(i)||' entered.');
c := c + 1;
end loop;
p(to_char(c)||' data inserted');
end;
/
-----------------------------------------
select * from players;