SQL in Oracle(LiveSQL)

Question

How to add multiple records at once using SQL in a table in Oracle Live SQL?

I have the used the statement in screenshot(as link) below but got an error-"ORA-00933: SQL command not properly ended"

Screenshot of the statements that I am using

score 3 · Accepted Answer · answered Jan 25 '21 at 12:01

Another option is to use INSERT ALL:

insert all
  into students (sr_no, name, class, sec, contact, total_marks) values (1, 'Ravi' , 10, 'A', 12345, 579)
  into students (sr_no, name, class, sec, contact, total_marks) values (2, 'Ria'  , 10, 'B', 98765, 580)
  into students (sr_no, name, class, sec, contact, total_marks) values (3, 'Aditi', 10, 'A', 98498, 570)
select * From dual;

score 2 · Answer 2 · answered Jan 25 '21 at 11:56

2

You can use values in select .. from dual union all and use INSERT INTO TABLE <t> SELECT ... as follows:

insert into your_table
select val1,2,3,4,5 from dual union all
select val1,2,3,4,5 from dual union all
select val1,2,3,4,5 from dual union all
select val1,2,3,4,5 from dual

db<>fiddle

answered Jan 25 '21 at 11:56

Popeye

35,427
4
10
31

Can I do it without using queries? – Ishika Jan 25 '21 at 12:02
Every database has its own way of doing the things. Why you don't want to use the query which is using the dual table. – Popeye Jan 25 '21 at 12:05
What is "dual table"? – Ishika Jan 25 '21 at 12:07
It is a dummy table provided by oracle having 1 column and 1 row. You must read about dual table as it is very useful in oracle – Popeye Jan 25 '21 at 12:08

SQL in Oracle(LiveSQL)

2 Answers2