Re: The invisible column !!!

In article 6377_at_cmutual.com.au, btc_at_cmutual.com.au (Tony Cook) writes:
>
>Try this:
>
>SQL+> select dummy t from dual;
>Press enter to continue
>
>
>
>
>1 row selected.
>
>Elapsed: 00:00:00.80
>
>------------------------
>
>What is going on here ? Where is my t column ?
>
>Is "t" a RESERVED word^h^h^h^h character ?????
>
there's nothing as secretive as reserved characters going on here, you have simply renamed the dummy column t. What did you want to do?? SELECT dummy,t FROM dual is illegal, but SELECT dummy,'t' FROM dual would yield

D '
- -
X t

Regards,
David TvE

---
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
David Thornewill von Essen                           Sr. Systems Analyst
Motorola ASIC Division                            I don't speak for Mot.
Chandler, AZ-85224                                   fax: (602) 814-4451
email: ttg242_at_email.sps.mot.com                      tel: (602) 814-4395
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-