Oracle插入多个值的问题

时间:2021-09-29 18:41:08

首先我们建立表T123

SQL> create table t123 (name char(10),age int);

然后试图向表中像DB2一样插入多个value,却得到了错误的信息。

SQL> insert into t123 values('Jack',24),('Vicky',24);
insert into t123 values('Jack',24),('Vicky',24)
*
ERROR at line 1:
ORA-00933: SQL command not properly ended

同样的表在DB2中的结果

[db2inst1@win ~]$ db2 "create table t123 (name char(10),age int)"
DB20000I The SQL command completed successfully.
[db2inst1@win ~]$ db2 "insert into t123 values('Jack',24),('Vicky',24)"
DB20000I The SQL command completed successfully.