Re: Data Dictionary Wierdness

cause they're idiots?

joe

Orr, Steve wrote:

> This does not work:
> select owner,table_name,cache from dba_tables
> where cache='Y';
>
> This does:
> select owner,table_name,cache from dba_tables
> where cache=' Y';
>
> The datatype for the column from desc dba_tables is VARCHAR2(5).
>
> So why would Oracle have leading spaces stored in a VARCHAR2 column?
>
>
> Whining in Bozeman, MT
> Steve Orr
>

-- 
Joe Testa, Oracle DBA
Want to have a good time with a bunch of geeks? Check out:
http://www.geekcruises.com/standard_interface/future_cruises.html
I'm presenting, when registering drop my name :)






-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  INET: teci_at_the-testas.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).