Re: Odd table name

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Tue, 16 Dec 2014 20:27:47 +0000
Message-ID: <CABe10sYr+Lr6cXnR7VDUPCZbLZR104XjqOSgGjnZf-onL2YtvQ_at_mail.gmail.com>

Spaces and case sensitivity are allowed on other platforms. Price of being database atheist I suppose.
On 16 Dec 2014 20:24, "Orlando L" <oralrnr_at_gmail.com> wrote:

> 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:27:47 CET