Hi All,

can we insert multiple rows into a table.

suppose i have a table like follows

SQL> create table test (name varchar2(10));

Table created.


and now i can insert one row with asingle statement like

insert into test values ('vas');

this will work fine , but i want to insert more than one row with a single statement . i think using 'values' its not possible .
Is there any other method to do this?

for any help thanks

SrinivasM