sql - Inserting multiple rows with one single query -

this question has answer here:

• best way multi-row insert in oracle? 5 answers

i able insert 2 rows following query. should insert more rows it?

insert friend_name(      friend_id,       first_name,       middle_name,       last_name) select        3,      'rich',      'mond',      'hill'  dual union select       4,      'monunica',      'bellu',      'cia'  dual 

you can try well:

insert     demo_table values (1, 'one', 'x' )     demo_table values (2, 'two', 'y' )     demo_table values (3, 'three', 'z' ) select * dual; 

@kiranavula..incase need insert records few column of table use below:

inserting record 1 column of table.

insert     demo_table(a) values ('one')     demo_table(a) values ('two')     demo_table(a) values ('three') select * dual;