Oracle alternative for mysql insert_id() or how to get last inserted ID properly

[eluser]Unknown[/eluser]
Is there an alternative to insert_id() for Oracle DB. I just want to get last inserted id properly.

please help!