can we insert multiple rows into a table.
suppose i have a table like follows
SQL> create table test (name varchar2(10));
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