How to insert multiple rows in one column using one INSERT statement in oracle 11g [duplicate]

Question

I'm trying this query, but it's not working

insert into REGIONS(region_name) values ('SOUTH_AFRICA') , ('NORTH_AFRICA');

it should be as below insert into REGIONS(region_name) values ('SOUTH_AFRICA'); insert into REGIONS(region_name) values ('NORTH_AFRICA'); — Chaitanya Kotha
– Chaitanya Kotha, Commented May 3, 2019 at 18:19
I know that but I'm required to use only one INSERT statment — Toqa Yousri
– Toqa Yousri, Commented May 3, 2019 at 18:21

Arulkumar · Accepted Answer · 2019-05-03 18:34:53Z

1

You can use INSERT INTO with SELECT as below:

INSERT INTO REGIONS (region_name) 
SELECT 'SOUTH_AFRICA' FROM DUAL
UNION
SELECT 'NORTH_AFRICA' FROM DUAL

edited May 3, 2019 at 18:34

answered May 3, 2019 at 18:24

Arulkumar

13.3k14 gold badges51 silver badges76 bronze badges

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

12 Comments

Toqa Yousri Over a year ago

" ERROR at line 3: ORA-00923: FROM keyword not found where expected "

Toqa Yousri Over a year ago

I got this error message

Toqa Yousri Over a year ago

it's not working , "FROM keyword not found where expected"

Arulkumar Over a year ago

@ToqaYousri Can you try to updated answer

Arulkumar Over a year ago

Seems you have a not null column named REGION_ID, so it is not allowing insert. You can include the column in the insert into and add the value for the same in the select

|

Collectives™ on Stack Overflow

How to insert multiple rows in one column using one INSERT statement in oracle 11g [duplicate]

1 Answer 1

12 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

12 Comments

Linked

Related