Re: The invisible column !!!

In article <7797.2c6f4921_at_hayes.com> fgreene_at_hayes.com 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 ?
>>
>
>Beats the heck out of me. I just tried it on my Unix based system and it
>returned
>
> T
> -
> X
>
>(There is an X stored in the field DUMMY on my system.
>
>Are you sure that you have column headings turned on and that the field dummy
>does not contain a null value?

In SQL*Plus, you can do SET TERM OFF to achieve the desired result.

--
 Alvin W. Law .............................................. Oracle Corporation
 Senior Software Engineer ...................... 300 Oracle Parkway, Box 659306
 Manufacturing Applications .......................... Redwood Shores, CA 94065
 Email: alaw_at_oracle.com ........... Voice: 1.415.506.3390 . Fax: 1.415.506.7299