how to create a function in oracle for last_insert_id() in MySQL
<p>I have a procedure in MySQL and I want to convert it into Oracle procedure, All is ok but MySQL inbuilt function "last_insert_id()" raise the error. Is there any solution to resolve it? Can i create a function for same in oracle. </p>

<pre><code>  SELECT LAST_INSERT_ID();
</code></pre>