Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Weird Table Name in Oracle 7.3.4
C. Mason wrote in message ...
>I an able to create, describe, drop a table called q198.jan.98 by enclosing
>the table name in double quotes. Try drop table "q198.jan.98";
>Steve Mitchell wrote in message
<3612B197.8ABA55FC_at_mitchells.demon.co.uk>...
>>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.
>>
>
>
As Pointed out by C. Mason if you enclose it in quotes you
can access and manipulate this table. The same thing applies
to column names if they exist.
How did the user do this? It's easy if he is using Access or Powerbuilder or S-Designor etc. etc. etc. which enclose the object names in quotes when it creates or manipulates them.
I used to have to caution every developer about this but gave up a long time ago.
CUL8R
Robert Hart
Received on Thu Oct 01 1998 - 14:30:00 CDT