inserting multiple records
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: inserting multiple records

  1. #1
    Join Date
    Mar 2001
    Posts
    20

    Wink

    is it possible to insert multiple records into oracle 8i through one SQL statement?

    i have tried:

    insert into table values ('1','2','3'),('2','3','4')

    without success.

    M

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    It is a clumsy and ugly sollution, but you can do it lik this:

    INSERT INTO TABLE tab1 (c1, c2, c3)
    SELECT '1', '2', '3' FROM dual
    UNION ALL
    SELECT '2', '3', '4' FROM dual;
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width