Getting primary key right after insertion into the record

How do I obtain the primary key ID right after a record is inserted in Oracle?

Such primary key is generated by trigger/sequence. And I am doing it within a Java JDBC environment

And this has to work in a multithreaded environment.

I thought about using

select max(id) from table

right after the insert.

Would this be the best way? Received on Fri Sep 15 2000 - 10:23:35 CDT