RE: Odd table name

From: Jeff Smith <>
Date: Tue, 16 Dec 2014 12:24:42 -0800 (PST)
Message-ID: <8a18fa64-33cc-46ef-bd78-4cfaee6a5a4c_at_default>

Maybe they like to break applications?

I frequently see people trying to name tables, TABLE and other silly things, just because they can.


From: Orlando L [] Sent: Tuesday, December 16, 2014 3:22 PM To:
Subject: Odd table name

We have a 9i system and I came across a table like this:  
SQL> select owner, object_name, object_type, status from dba_objects where object_name like 'WHI%'; OWNER           OBJECT_NAME               OBJECT_TYPE        STATUS
--------------- ------------------------- ------------------ -------
ABCDEFG         WHI Unique                TABLE              VALID SQL>
Never seen any table with a space in the name. Has anyone seen similar stuff? Why would the third party vendor name this way. I have to double quote the name to query and desc.  


-- Received on Tue Dec 16 2014 - 21:24:42 CET

Original text of this message