不用触发器和存储过程,只需要变换一下,加个子sql
insert into t1(id,name)
select PK_SEQ.NEXTVAL,t.* from (
select 'name1' from dual
union all
select 'name2' from dual
) t
不用触发器和存储过程,只需要变换一下,加个子sql
insert into t1(id,name)
select PK_SEQ.NEXTVAL,t.* from (
select 'name1' from dual
union all
select 'name2' from dual
) t