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

Home -> Community -> Usenet -> c.d.o.misc -> Re: LEVEL as a fieldname

Re: LEVEL as a fieldname

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Wed, 7 Jul 2004 22:23:25 +0100
Message-ID: <40ec69bb$0$6448$cc9e4d1f@news-text.dial.pipex.com>


First use quotes to identify the column, then shoot the designer.

alter table rename column might be handy for you as well if available.

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
"spita" <a.spit_at_spitsoft.demon.nl> wrote in message
news:10eomo09r7uj6b0_at_corp.supernews.com...

> Hai everybody,
>
> Can anybody tell me what to do when you have for example an oracle
database
> and a table contains a field called LEVEL.
>
> How do I use the select command then ?
>
> When I use:
> SELECT level
> FROM table
>
> I will get an error message, because LEVEL is also a command known in SQL.
>
>
Received on Wed Jul 07 2004 - 16:23:25 CDT

Original text of this message

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