15일차 # 5-22: FOR Loop

       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;