Oracles @@Identity?

  • Thread starter Thread starter SDF
  • Start date Start date
S

SDF

Is there an equivalent? I have a sequence set up to create me a unique ID,
but I need to return that too!

Thanks,

Scott
 
Hi,

You should be able to select the CURRVAL from the sequence right after the
insert. For instance: select <mysequencenamegoeshere>.CURRVAL from dual;
AFAIK there is no true equivalent to @@Identity in Oracle

I hope this helps.
----------------------------------
 
SDF said:
Is there an equivalent? I have a sequence set up to create me a unique
ID,
but I need to return that too!
Click to expand...

The most direct equivilent is my_sequence.currval. This will return the
last my_sequence.nextval that your session retrieved.

David
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ODBCCommandBuilder produces different UpdateCommand with Oracle usingfield name aliases 2
error- System.Exception: Could not create an environment: OCIEnvCreate returned -1 4
Oracle integer is set to Decimal in the DataTable 1
Capture ID of newly inserted row 3
SqlBulkCopy and Oracle? 5
Access Append Query to update Sequence Generator in Oracle 9
how to get the id of the inserted datarow? 3
Transactionscope ? - "Unable to get error message (6107) {0}" 1

Back
Top