How do I get the last generated sequence number in Oracle?

  • Thread starter Thread starter chance
  • Start date Start date
C

chance

I need to write some c# code to get the last automatically generated
sequence number from an Oracle database. Can anyone provide an
example.

tia,
chance.
 
chance schreef:
I need to write some c# code to get the last automatically generated
sequence number from an Oracle database. Can anyone provide an
example.
Click to expand...

Simply use the following query SELECT SEQ_NAME.CURVAL FROM DUAL and do
the regular .net query stuff...
 

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

oracle import- and export-commands are contained in which .dll fil 2
Excel Sequential Numbering System 0
Access Append Query to update Sequence Generator in Oracle 9
Sequence Number generator on the server 2
IPhone sound quality gets worse each generation 5
What do I have to write in OracleConnection string for "Data Source" ? 2
Oracle Sequence Jumps by 3 from Excel 1
Keeping computer hostname in sequence 11

Back
Top