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

Home -> Community -> Usenet -> c.d.o.server -> Re: Getting currval from a sequence with out incrementing nextval

Re: Getting currval from a sequence with out incrementing nextval

From: Cgl3863 <Cgl3863.27520z_at_no-mx.forums.yourdomain.com.au>
Date: Mon, 1 May 2006 12:42:55 -0400
Message-ID: <Cgl3863.27520z@no-mx.forums.yourdomain.com.au> 






Typical of DBA's!!!: over complicating a simple question
if you want the to find the current number of a given Sequence



SELECT last_number FROM ALL_SEQUENCES Where Sequence_name='sequence
name'



from lazy developer



-- 
Cgl3863
------------------------------------------------------------------------
Cgl3863's Profile: http://www.dbtalk.net/m261
View this thread: http://www.dbtalk.net/t289463


Received on Mon May 01 2006 - 11:42:55 CDT












Original text of this message













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