首先我们建立表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.