Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Getting last sequence number in c#
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