Re: Weird Table Name in Oracle 7.3.4

From: <Clive>
Date: Wed, 30 Sep 1998 23:57:35 GMT
Message-ID: <3612c516.3516640@news.demon.co.uk>

On Wed, 30 Sep 1998 23:32:55 +0100, Steve Mitchell <steve_at_mitchells.demon.co.uk> wrote:

>One of our users has managed to create a table name as follows:
>
> q198.jan.98
>
>This is how it shows when querying dba_tables. Note that it is in lower
>case and contains periods.
>
>How was the user able to do this? I am not able to describe it in
>SQL*Plus or even attempt to remove the offending table. I am thinking
>of directly changing the data in the data dictionary so that I can
>remove this table but would rather not.
>
>Steve.
>

The table was created by placing its name in double quotes, and that is how you should try and reference it.

Cheers

Clive. Received on Wed Sep 30 1998 - 18:57:35 CDT