获取oracle db中最后插入记录的ID

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?

推荐答案

使用 PL/SQL RETURNING 子句:

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