I insert a record in a table wich have an auto-increment ID column. I want to retrieve the newly inserted record by reading the generated ID.
I"m using Oracle 10g. What is the best way to do this? I'm looking for something similar than @@Identity in SQL Server.