RE: Odd table name
- From: Jeff Smith <jeff.d.smith@xxxxxxxxxx>
- To: oralrnr@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Tue, 16 Dec 2014 12:24:42 -0800 (PST)
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@xxxxxxxxx]
Sent: Tuesday, December 16, 2014 3:22 PM
To: oracle-l@xxxxxxxxxxxxx
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
