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

Posted on 2004-10-26
Last Modified: 2008-01-09
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???
Question by:keznwichi
    LVL 12

    Accepted Solution

    If you are inserting multiple records from a source table then

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

    LVL 12

    Expert Comment

    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');


    Author Comment

    I'm not inserting from a source table unfortunately.

    Does that really mean i have to insert each record insert one by one?
    LVL 75

    Assisted Solution

    by:slightwv (䄆 Netminder)
    Sounds like a good candidate for SQL*Loader.....

    This will read from a flat text file and insert into a table.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Article by: Swadhin
    From the Oracle SQL Reference ( we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
    Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
    This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

    846 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    6 Experts available now in Live!

    Get 1:1 Help Now