用包记录哪个ID吧 create package test_pack as p_id varchar2(10); end; / create trigger a_tri before insert on a for each row begin select id.nextnvl from :new.id from dual; select id.nextnvl into test_pack.p_id from dual; end; /
select id.nextnvl as myid from dual; 通过Java程序附值给一个变量 vmyid 再插入数据就行了 insert into table (id,...) values(vmyid,....)
create package test_pack
as
p_id varchar2(10);
end;
/
create trigger a_tri
before insert on a
for each row
begin
select id.nextnvl from :new.id from dual;
select id.nextnvl into test_pack.p_id from dual;
end;
/
通过Java程序附值给一个变量 vmyid
再插入数据就行了
insert into table (id,...) values(vmyid,....)