Sql insert into

[arvin2006]

hi everyone, i just want to ask if it is possible for the SQL INSERT INTO to LOOP? for example, insert new records in TABLE ten times with the same values (colum1,column2,column3,etc..) is there an alternative way instead of typing (INSERT INTO.. 10x) statement repeatedly. thanks.

[selvaganapathy]

Hi,

I dont think so such query exist but u can use like this

INSERT INTO VALUES ( .... ) , ( .... ) , ....

Make such SQL and Execute the single query.

[debasisdas]

you can use loop inside a sub program for the purpose.