Trying to insert multiple rows in my table in SQL.Always showing SQL Command not ended properly

Question

I am trying to insert multiple rows into my table using the below query : INSERT INTO TABLE2(ID) VALUES(1),(2) .It is showing SQL Command Not Ended.

Is it some syntacital error?I have rechecked but still not clear what's going wrong.

Oracle doesn't allow that syntax. You can do separate inserts; or `insert all` but not sure that gains you much here. — Alex Poole, May 28 '21 at 19:40

score 0 · Accepted Answer · answered May 28 '21 at 19:41

Invalid syntax, of course. But, here are 3 options that work.

SQL> create table table2(id number);

Table created.

SQL>
SQL> insert into table2(id) values(1);

1 row created.

SQL> insert into table2(id) values(2);

1 row created.

SQL>
SQL> insert all
  2    into table2(id) values (1)
  3    into table2(id) values (2)
  4  select * from dual;

2 rows created.

SQL>
SQL> insert into table2(id)
  2  select 1 from dual
  3  union all
  4  select 2 from dual;

2 rows created.

SQL>

Thank you. Oracle doesn't allow multiple insert like the way I was doing it seems. — Ansih Mukherjee, May 28 '21 at 20:41

Trying to insert multiple rows in my table in SQL.Always showing SQL Command not ended properly

1 Answers1