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: Vitaliy Mogilevskiy <vit100gain_at_earthlink.net>
Date: Fri, 07 May 1999 10:07:26 -0700
Message-ID: <37331DCE.3911B406@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 Fri May 07 1999 - 12:07:26 CDT

Original text of this message

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