Re: how to define a pseudo auto value column in oracle?

From: Robert Wehofer <thalion77_at_graffiti.net>
Date: Thu, 10 Feb 2005 12:49:33 GMT
Message-ID: <xLIOd.43111$2e4.19026@news.chello.at>

> Hated by who exactly? Joe Celko has made it more than clear in numerous
> communications that those "beloved" identity columns don't even belong
> in a relational database. And exactly what is it about typing:
> CREATE SEQUENCE x;
> that is so hard on your fingers?
>
> Or is it using the sequence in your insert statement that causes you so
> much pain?
>
> INSERT INTO t VALUES (x.NEXTVAL);

You don't understand the problem. The problem is, that sequences don't allow database independent programming (by means of ADO). Most of database types do have the datatype Autovalue. Oracle don't support this datatype.

Robert Received on Thu Feb 10 2005 - 06:49:33 CST