Get ID of last inserted record in oracle db

Question

I want to retrieve the id of a newly inserted record with an auto incrementing id column (using the sequence and trigger method). What is the standard way to do this?

Answer 1

Use the PL/SQL RETURNING clause:

insert into mytable (...) values (...)
returning id into v_id;