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;


+ Recent posts