RE: Odd table name
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.
Jeff
From: Orlando L [mailto:oralrnr_at_gmail.com]
Sent: Tuesday, December 16, 2014 3:22 PM
To: oracle-l_at_freelists.org
Subject: Odd table name
List
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.
OL.
--
http://www.freelists.org/webpage/oracle-l Received on Tue Dec 16 2014 - 21:24:42 CET