Oracle 插入多行记录

 

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

?

1 2 3 4 5 6

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实现如下：

?

1 2 3 4 5

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