can we insert multiple rows using single statement ?

[gsprince]

There is something like "Bulk Binding", (I guess from oracle 8.0.5 onwards)

You can put all ur values into an PL/SQL array and insert them at once.

FOR j IN lower_bound..upper_bound LOOP
var1(j) := j; -- put the values in PL/SQL array
END LOOP;

FORALL i IN lower_bound..upper_bound --see "FORALL"
INSERT INTO tab1 VALUES (var1(i)) ;

This runs much fater than the normal insert.

Note: Not sure this is of any assistance to ur original posting.