Multiple Inserts

[Guest]

hi
can we do multiple inserts into one statement???
for example in MYSQL....we can have following syntex

insert into emp (empno,ename) values(1234,'Asif'),(1235,'Ahmed'),(1236,'Ahsan');


so we are inserting three rown in a single statement...i have studdied about the INSERT ALL statement but it can be used to extract data from one table... and inserts into another...so do we have a syntex like MYSQL has as i mentioned above
Regards

[Tim...]

Hi.

Not really. You can do an INSERT INTO ... SELECT as you know, but not a single statement. For performance reasons you may decide to do a bulk bind like:

http://www.oracle-base.com/articles/9i/ ... sing9i.php

This allows the contents of a PL/SQL collection to be inserted into a table using a single statement.

Cheers

Tim...