Home » SQL & PL/SQL » SQL & PL/SQL » Re: problem with for loop
Re: problem with for loop [message #1939] Wed, 12 June 2002 04:57
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
SQL> ed
Wrote file afiedt.buf

  1  begin
  2  for mag in 1..10 loop
  3  insert into temp values ('a'||mag);
  4  end loop;
  5* end;
  6  /

PL/SQL procedure successfully completed.

SQL> select * from temp;

NAME
------------------------------
a1
a2
a3
a4
a5
a6
a7
a8
a9
a10
Previous Topic: trigger source code
Next Topic: Problem with Inner Join (converting SQL from Access)
Goto Forum:
  


Current Time: Mon May 20 13:55:50 CDT 2024