Re: Redefining keywords?

From: Robert William Vesterman <bob.work_at_vesterman.com>
Date: 2000/08/03
Message-ID: <3989b03e.87222743@News.CIS.DFN.DE>#1/1

On Thu, 03 Aug 2000 18:10:17 +0800, Connor McDonald <connor_mcdonald_at_yahoo.com> wrote:

>Robert William Vesterman wrote:
>>
>> I must name one of the columns in one of my tables "percent". I have
>> very little choice about doing so - if we don't do it, we lose a
>> significant portion of functionality, no two ways about it.
>>
>> Problem is, Oracle doesn't allow you to name a column "percent". It's
>> a keyword.
>>
>> However, I found the following statement on technet.oracle.com:
>>
>> "Keywords (...) have a special meaning to Oracle but are not reserved
>> words and so can be redefined."
>>
>> But I can't find anywhere instructions on how to redefine a keyword.
>> Does anyone know?
>>

>All references need to be double quotes...
>
>select "percent" from table...

Thanks, but unfortunately we have a tool - which we can't change - which is going to attempt to populate the table by doing inserts to the column percent, not the column "percent".

Bob Vesterman. Received on Thu Aug 03 2000 - 00:00:00 CDT