<div>
in oracle, the &quot;identity&quot; is translated into a sequence object, eventually combined with a trigger:<br />
<a href="http://www.techonthenet.com/oracle/sequences.php" rel="ugc">http://www.techonthenet.com/oracle/sequences.php</a><br />
<a href="http://www.databaseanswers.org/sql_scripts/ora_sequence.htm" rel="ugc">http://www.databaseanswers.org/sql_scripts/ora_sequence.htm</a>
</div>


in oracle, the "identity" is translated into a sequence object, eventually combined with a trigger:
http://www.techonthenet.com/oracle/sequences.php [http://www.techonthenet.com/oracle/sequences.php]
http://www.databaseanswers.org/sql_scripts/ora_sequence.htm [http://www.databaseanswers.org/sql_scripts/ora_sequence.htm]

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
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.<br />
<br />
I&quot;m using Oracle 10g. What is the best way to do this? I'm looking for something similar than @@Identity in SQL Server.<br />
<br />
Thanks
</div>
</div>


Hi,

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.

Thanks

How to get the record ID of a newly inserted record

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

Enterprise software, also known as enterprise application software (EAS), is computer software used to satisfy the needs of an organization, including businesses, schools, interest-based user groups, clubs, charities, or governments. Services provided by enterprise software are typically business-oriented tools such as online shopping and online payment processing, interactive product catalogue, automated billing systems, security, enterprise content management, IT service management, customer relationship management (CRM), enterprise resource planning (ERP), business intelligence (BI), project management, human resource management (HR), manufacturing and supply chain management, enterprise application integration (EAI), and enterprise forms automation. Enterprise software is often available as a suite of customizable programs that require specialist capabilities.