不同于MySQL的 insert into A values(a,b,c),(d,e,f).....ORACLE中插入多条语句语法如下:
注意,没有values
INSERT INTO CC_DEV_CI c (c. ID,
c.ci_name)
SELECT 1, '11' FROM dual
UNION
SELECT 2,'11' FROM dual
这样,两条数据就插进去了
不同于MySQL的 insert into A values(a,b,c),(d,e,f).....ORACLE中插入多条语句语法如下:
注意,没有values
INSERT INTO CC_DEV_CI c (c. ID,
c.ci_name)
SELECT 1, '11' FROM dual
UNION
SELECT 2,'11' FROM dual
这样,两条数据就插进去了