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 current sequence value

Re: Getting current sequence value

From: David Lane <dlane_at_cix.compulink.co.uk>
Date: Tue, 30 Mar 1999 21:58:33 GMT
Message-ID: <F9FH1L.ECJ@cix.compulink.co.uk> 





You could try querying the user_sequences table
Dave Lane (dlane_at_pt.lu)



In article <36FECA76.A2A8D15A_at_bigfoot.com>, dcowles_at_bigfoot.com (Doug 
Cowles) wrote:



> Is there any way to get the current value of a sequence number without


> incrementing it?  You can't use currval unless you define the sequence


> for the session by calling nextval first.  Is there any way around this?




Received on Tue Mar 30 1999 - 15:58:33 CST












Original text of this message













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