利用union(或union all);
union(或union all)两边的结果集的列数必须一致,相同位置的列类型必须一致;
下面的代码是向Channel_Act连续插入三条记录
INSERT INTO Channel_Act
(Channel_ID, ACT_ID, ACT_TYPE, ADD_TIME)
(select '2007081301', '20070118', '0', sysdate
from dual
union
select '2007081301', '20070114', '0', sysdate
from dual
union
select '2007081301', '20070002', '0', sysdate from dual)