若要在oracle中一次性插入多条记录,只能借用系统自带的第三张表dual
例:insert into test01(c1,c2)
select '你','好' from dual
union all
select '我','好' from dual
union all
select '他','好' from dual;
前提是表的两个字段c1和c2,都为varchar2格式
例:insert into test01(c1,c2)
select '你','好' from dual
union all
select '我','好' from dual
union all
select '他','好' from dual;
前提是表的两个字段c1和c2,都为varchar2格式