How to so select on sequence ?

Hi:

I am rather new to Oracle. I am currently using sequences for generating unique numbers. I am able to use seq.nextval and seq.currval successfully in insert and update statements.

I want to do a select on the sequence, increment the value and save the value in a variable. The book says that I can do select on a sequence - but i can't figure out how.

select nextVal from seq

fails.

Shinu Gupta Received on Wed Sep 18 1996 - 00:00:00 CEST