Re: invalid tablenames

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Wed, 8 Dec 1999 11:19:32 +0100
Message-ID: <82lb4h$10sop$1@oceanite.cybercable.fr>

You have to enclose these names with double-quotes, for example:
select "GROUP" from "VIEW";

--
Have a nice day
Michel

Jasper Thoen <jthoen_at_iv-software.nl> a écrit dans le message : 82l7a5$8og$1_at_news1.xs4all.nl...
> Hi,
>
> I migrated a Dataflex-database to Oracle8, but I have troubles with tables
> having bad chosen names. Those Dataflex-tables have names like VIEW, GROUP
> and SYSTEM. Of course this causes problems, because these names are SQL
> keywords. So far, so good: I know there is a very easy way to handle this
> using special SQL-syntax , without renaming the tables. Unfortunately I
> can't remember how to do it.
>
> Anyone here who could help me? Thanks.
>
> Regards,
>
> Jasper Thoen
>
>
>
>
>
>
>
Received on Wed Dec 08 1999 - 04:19:32 CST