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;