How to insert multiple values in 11g?

Question

How to insert multiple values in a table in oracle 11g using query?

I tried This

It takes a simple google search : https://stackoverflow.com/questions/39576/best-way-to-do-multi-row-insert-in-oracle — Kaushik Nayak, Apr 21 '18 at 10:55
Welcome to SO. Please have a look here to learn how to improve your questions (formatting, proofreading, providing code etc.): https://stackoverflow.com/help/how-to-ask — petezurich, Apr 21 '18 at 10:56

Barbaros Özhan · Answer 1 · 2018-04-21T11:11:01.980

3

Use the following DML known as INSERT ALL statement :

insert all into departmentstrigger values(4,'Hello') 
           into departmentstrigger values(5,'HEy There')
           into departmentstrigger values(6,'sup')
           into departmentstrigger values(7,'Hii')
  select * from dual;

SQL Fiddle Demo

For a detailed explanation you may look at : Insert All Statement

edited Apr 21 '18 at 11:11

answered Apr 21 '18 at 10:54

Barbaros Özhan

59,113
10
31
55

2

@uzi I'd like to thank you but have you really tried with `from departmentstrigger` instead of `from dual`? – Barbaros Özhan Apr 21 '18 at 11:07

How to insert multiple values in 11g?

1 Answers1