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: Ubiquitous <weberm_at_polaris.net>
Date: Tue, 7 Dec 2004 18:04:20 +0000 (UTC)
Message-ID: <cp4rb3$ekm$5@news.utelfla.com> 





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.
 
Received on Tue Dec 07 2004 - 12:04:20 CST












Original text of this message













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