Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Getting last sequence number in c#

Re: Getting last sequence number in c#

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Thu, 29 Mar 2007 19:55:41 +0200
Message-ID: <euguf0$tvc$1@news2.zwoll1.ov.home.nl>


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.
>
> tia, chance.
>

Lookup the 'returning' part of an insert statement. At least - if that is what you mean by 'last'.

If not - check the data dictionary, but remember sequences may be cached.

The oracle documentation - free of charge (I charge €90/hr) is at http:/tahiti.oralce.com and comes with powerful search options

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
Received on Thu Mar 29 2007 - 12:55:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US