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
