Inserting multiple rows in a single Oracle SQL query:

Question

Inserting multiple rows in a single Oracle SQL query. Here is the following query I am trying to use. Can anyone tell me the error that I am having and how to go about it. Thanks.

INSERT ALL INTO 
     "SCOTT"."GREATCOLOR1" (
           COLOR, 
           PAUL, 
           JOHN, 
           TIM, 
           ERIC
     )VALUES (
           'White', 
           '1', 
           '5', 
           '1', 
           '3') 
     INTO "SCOTT"."GREATCOLOR1" (
           COLOR, 
           PAUL, 
           JOHN, 
           TIM, 
           ERIC
    )VALUES (
           'Yello', 
           '8', 
           '4', 
           '3', 
           '5') 
    INTO "SCOTT"."GREATCOLOR1" (
           COLOR, 
           PAUL, 
           JOHN, 
           TIM, 
           ERIC
    ) VALUES (
           'Black', 
           '2', 
           '2', 
           '9', 
           '1') 
    SELECT * FROM dual;

INSERT ALL INTO "SCOTT"."GREATCOLOR1" (COLOR, PAUL, JOHN, TIM, ERIC) VALUES ('White', '1', '5', '1', '3') INTO "SCOTT"."GREATCOLOR1" (COLOR, PAUL, JOHN, TIM, ERIC) VALUES ('Yello', '8', '4', '3', '5') INTO "SCOTT"."GREATCOLOR1" (COLOR, PAUL, JOHN, TIM, ERIC) VALUES ('Black', '2', '2', '9', '1') SELECT * FROM dual; — Gopu Alakrishna
– Gopu Alakrishna, Commented May 26, 2016 at 11:48
Possible duplicate of Inserting multiple rows in a single SQL query? — J. Chomel
– J. Chomel, Commented May 26, 2016 at 12:00

J. Chomel · Accepted Answer · 2016-05-26 11:59:41Z

1

You where close, but you have much to learn.

Here is how you could do it:

INSERT INTO "SCOTT"."GREATCOLOR1" (COLOR, PAUL, JOHN, TIM, ERIC)
          select 'White', '1', '5', '1', '3' from dual
union all select 'Yello', '8', '4', '3', '5' from dual
union all select 'Black', '2', '2', '9', '1' FROM dual
;

answered May 26, 2016 at 11:59

J. Chomel

8,44215 gold badges44 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Inserting multiple rows in a single Oracle SQL query:

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related