Re: Getting currval from a sequence with out incrementing nextval

Bonk wrote:
> I was looking for a way to avoid bumping up the sequence by selecting
> the next value, I thought there might be a $ table that contained the
> values, but I guess not. I don't see see it in any of the DBA/SQL
> references for 10G

You are looking for a way to make your application unscalable to cover up for organizational incompetence.

Fix the real problem.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)