How can you Insert Multiple Records at once with Oracle SQL Plus

I'm a novice studying sql plus at uni.

I know how to insert records one at a time with
Insert into TABLENAME
 values ('bla' 'bla' 'bla');

..BUT how do you insert multiple records at once???
keznwichiAsked:
Who is Participating?
 
catchmeifuwantCommented:
If you are inserting multiple records from a source table then

insert into table1(col1,col2,col3)
select col1,col2,col3
from table2;

0
 
catchmeifuwantCommented:
But with this, you have to do it one-by-one :

Insert into TABLENAME
values ('bla' 'bla' 'bla');

Insert into TABLENAME
values ('bla1' 'bla1' 'bla1');

commit;
0
 
keznwichiAuthor Commented:
I'm not inserting from a source table unfortunately.

Does that really mean i have to insert each record insert one by one?
0
 
slightwv (䄆 Netminder) Commented:
Sounds like a good candidate for SQL*Loader.....

This will read from a flat text file and insert into a table.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.