Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Redefining keywords?

Re: Redefining keywords?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: 2000/08/03
Message-ID: <39894509.5E28@yahoo.com>#1/1

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?
>
> Thanks,
>
> Bob Vesterman.

All references need to be double quotes...

select "percent" from table...

Have fun...

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse
Received on Thu Aug 03 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US