Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: View current seq. no.
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