multiple row insert

[sumit gupta]

how to insert multiple row in a table through single quesry execution in oracle.is it possible or not?

[debasisdas]

Try to INSERT ALL command.

Try to use on version 9 onwards

[amitpatel66]

how to insert multiple row in a table through single quesry execution in oracle.is it possible or not?

Are you looking at inserting a record in to more than one table or inserting a multiple copies of single row in to a single table?

[BMantri]

Hello,

You can use
insert into table values ('&col1', '&col2');

it will ask you the value of col1 and col2 every time you put / on sqlplus.



Regards,

BMantri