RE: Strange workings of Oracle

Shreepad, found this line in the view text for dba_tables... lpad(decode(bitand(t.flags, 8), 8, 'Y', 'N'),5),

why use LPAD ?? and why not use YES AND NO if the columns is varchar2(5) ??

rahul

> ----------
> From: Shreepad Vaidya[SMTP:Shreepad.Vaidya_at_alltel.com]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Monday, October 16, 2000 1:05 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Strange workings of Oracle
>
>
>
> Hi everyone,
>
> I noticed something very strange when i tried to cache a table.
>
> 1) I cached a table
> alter table emp cache;
> 2) Did a describe on dba_tables
> One of the columns is :
> CACHE VARCHAR2(5)
> 3) SQL> select distinct cache from dba_tables ;
>
> CACHE
> -----
> N
> Y
> 4)SQL> select table_name,cache from dba_tables where cache='Y' ;
>
> no rows selected
>
> 5)select table_name,cache from dba_tables where cache like '%Y%';
> TABLE_NAME CACHE
> ------------------------------ -----
> EMP Y
>
> 6) SQL> select table_name,cache from
> dba_tables where cache=' Y';
>
> TABLE_NAME CACHE
> ------------------------------ -----
> EMP Y
>
> Gave 4 spaces before y
>
>
>
>
> If the column is varchar2 shouldn't it put only Y rather than
> prefixing it with spaces.
>
> Even for Datatype char , space are postfixed .
>
> I found this on Oracle 7.3.4 and Oracle 8.1.5
>
>
> Thanks
> shreepad.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Shreepad Vaidya
> INET: Shreepad.Vaidya_at_alltel.com
>
> 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).
Received on Mon Oct 16 2000 - 00:46:30 CDT