Oracle 插入多行记录

 

在Oracle 中插入多行，显然不可以用下面的方法：

insert into sys_defect (DEFECT_ID,DEFECT_CODE,DEFECT_LEVEL,DEFECT_DESC,UPDATE_USERID,UPDATE_TIME,SYS_DEFECT.ENABLED,DEFECT_TYPE,CODE_LEVEL,PARENT_DEFECT_ID)
values
('10001408','Get3KK05','0','執行AWB失敗','10017656',sysdate,'Y','CM','0','0'),
('10001409','Get3KK06','0','補償AWB異常','10017656',sysdate,'Y','CM','0','0'),
('10001410','Get3KK07','0','BIN檔異常','10017656',sysdate,'Y','CM','0','0'),
('10001411','Get3KK08','0','OTP已燒錄','10017656',sysdate,'Y','CM','0','0')

但可以借助union all实现如下：

insert into sys_defect (DEFECT_ID,DEFECT_CODE,DEFECT_LEVEL,DEFECT_DESC,UPDATE_USERID,UPDATE_TIME,SYS_DEFECT.ENABLED,DEFECT_TYPE,CODE_LEVEL,PARENT_DEFECT_ID)
select '10001408','Get3KK05','0','執行AWB失敗','10017656',sysdate,'Y','CM','0','0' from dual union all
select '10001409','Get3KK06','0','補償AWB異常','10017656',sysdate,'Y','CM','0','0' from dual union all
select '10001410','Get3KK07','0','BIN檔異常','10017656',sysdate,'Y','CM','0','0' from dual union all
select '10001411','Get3KK08','0','OTP已燒錄','10017656',sysdate,'Y','CM','0','0' from dual