Re: limit TABLE to only one record

On Mon, 19 Nov 2007 14:59:07 GMT, "Preston" <dontwantany_at_nowhere.invalid> wrote:

>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.

Thanx for the info.

B. Received on Mon Nov 19 2007 - 09:28:56 CST