Re: Autoincrement numeric primary key data type

Si wrote:
> What is the standard way in Oracle to have an autoincrementing integer type
> primary key data type? Does Oracle offer a built-in data type for this? Or
> should I use triggers?
>
>

Yes. Triggers.

And -as your background seems to be Sybase- buy Thomas Kyte's Expert one-on-one Oracle, read the first three chapters, read again, and then start with the Oracle concepts Manual at
http://tahiti.oracle.com

Oracle is quite a different beast; better learn how to treat it.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...