Re: incrementing function in Oracle

Hello ...

you can use the sequence everytime you need it and in every field in a table. If you just want the next number then use

SELECT <sequencename>.nextval FROM DUAL;

A sequence is a table independend object.

Hope this helps

Greetings
Manfred Peter
(Alligator Company)
www.alligatorsql.com Received on Fri Jul 06 2001 - 07:49:17 CDT