Insert Multiple Rows in Oracle

Asked Jun 12 '18 at 08:15

Active Jun 12 '18 at 08:25

Viewed 17 times

Suppose we have an insert script that is consist 10000 statement like following;

Insert into CATEGORIES(CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, PICTURE)
Values(1, 'Beverages', 'Soft drinks, coffees, teas, beers, and ales', 'beverages.gif');

Insert into CATEGORIES(CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, PICTURE)
Values(2, 'Condiments', 'Sweet and savory sauces, relishes, spreads, and seasonings', 'condiments.gif');

So how can I insert all the rows simultaneously? If I use ";" I can insert row by row but I don't want to insert this way. Or If I delete ";" I get error.

Thanks in advance..

edited Jun 12 '18 at 08:25

a_horse_with_no_name

497,550
91
775
843

asked Jun 12 '18 at 08:15

aprkturk

This is not duplicate. I want to learn how can I insert at a time without 10000 statement edit – aprkturk Jun 12 '18 at 08:29
1

That's precisely what the linked question is about – a_horse_with_no_name Jun 12 '18 at 08:32
1

Then the answers in the duplicated proposed will definitely help you – AxelH Jun 12 '18 at 08:32
This is not duplicate. Reference link valid for just 2-3 row, I mentioned for 10000 rows. 10000 rows can not edit so I want to learn practical way – aprkturk Jun 12 '18 at 08:43

Insert Multiple Rows in Oracle

0 Answers0