Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Insert and get sys generated PK?
I have a table that has a numberic primary key.
I also have a sequence that populates the primary key via a Before
Insert trigger.
How can I insert a record, and GET the primary key assigned to that record all in one statement?
The trigger just
select filelist_seq.nextval
into :new.filelistnbr
from dual;
that is all..
Suggestions.. ?
-K Received on Wed Jun 09 1999 - 12:51:51 CDT