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: View current seq. no.

Re: View current seq. no.

From: Shirley Kwan <sskwan_at_ingr.com>
Date: Mon, 10 May 1999 08:48:38 +0800
Message-ID: <qkZqy5nm#GA.154@pet.hiwaay.net> 





You can use this to view to current value of a sequence within that session
only. It means that you must get the seq.nextval before you select the
current value.



Shirley......



Vitaliy Mogilevskiy wrote in message <37331DCE.3911B406_at_earthlink.net>...


>Use this:


>


>SQL> select <seq_name>.currval from dual;


>


>Now knowing this you can create dynamic SQL


>to get all current values for all of them


>


>Vitaliy Mogilevskiy


>


>




Received on Sun May 09 1999 - 19:48:38 CDT












Original text of this message













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