Re: Please help with no-gap autoincrement field

g_chime_at_yahoo.com wrote:
> I am converting from MySQL to ORACLE and having problems with an
> autoincrement field.
> MySQL has a built-in autoincrement feature ORACLE doesn't seem to.

Oracle does it just is implemented in a different manner.

Go to Morgan's Library at www.psoug.org
Click on Sequences.

You can implement the numbering as part of your insert statement or using a BEFORE INSERT trigger.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org