http://www.itpub.net/showthread. ... ;highlight=sequence
create table person (id number, name varchar2(8), ....);
var i number;
insert into person (name, ...) values ('abcde', ...) returning id into :i;
就可以得到新插入的id的值了。
http://www.itpub.net/showthread. ... highlight=returning