Insert and get sys 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 - 14:57:56 CDT