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: How get the current value from a sequence?

Re: How get the current value from a sequence?

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Tue, 07 Dec 2004 12:31:57 -0800
Message-ID: <1102451413.152725@yasure>


Ubiquitous wrote:
> Someone pointed out a solution to my query; Instead of using dba_sequences,
> I used all_sequnces (or could have used user_sequences) to get the value
> of the LAST_VALUER field.

Any one of the three.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Tue Dec 07 2004 - 14:31:57 CST

Original text of this message

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