Re: limit TABLE to only one record

From: Preston <dontwantany_at_nowhere.invalid>
Date: Mon, 19 Nov 2007 14:59:07 GMT
Message-ID: <%wh0j.41203$T8.40783@newsfe5-win.ntli.net>

Brian Tkatch wrote:

> On Sun, 18 Nov 2007 23:16:24 -0800, DA Morgan <damorgan_at_psoug.org>
> wrote:
>
> > PS: ID and DATA are both reserved words in Oracle.
>
> Where? I know DATA is used in SQL*Loader. On second thought, "datum"
> would probably be more appropriate anyway. :P
>
> Where is ID a reserved word? I have always defaulted to Id as the PK
> on a TABLE that defines an entity in the system.

They're both in v$reserved_words, but with the 'reserved' flag set to 'N'. So it's (currently) ok to use them, but possibly best not to in case their status changes in future versions. Although given the millions of tables out there with 'ID' as a column name, I can't see Oracle changing that ones status.

-- 
Preston.

Received on Mon Nov 19 2007 - 08:59:07 CST