assume the following:
SQL>describe tablex
NAME NULL? TYPE
------- ------ -----------
col1 varchar2(1)
col3 varchar2(1)
col3 number


SQL> select col1 as "User", col2 as "Gender", col3 as "Age" from tablex;

quotes allow column header format as specified. ...therefore, could
issue query as:
SQL> select col1 user, col2 gender, col3 age from tablex;
expected results:

USER GENDER AGE
A M 12
B F 14



On 2/27/2006 1:56 PM, Manasa wrote:

> SELECT COLUMN_NAME
> FROM USER_TAB_COLUMNS
> WHERE TABLE_NAME = 'PUT_YOUR_TABLE_NAME_HERE'
>
>
>
> -----Original Message-----
>
>>From: Michael Bacchus <oracledba-ezmlmshield-x21298745.[Email address protected]
>>Sent: Feb 27, 2006 1:49 PM
>>To: LazyDBA Discussion <[Email address protected]
>>Subject: Column names
>>
>>
>>Hello all,
>>
>>I am trying to query the column names of a table and am having some
>>challenges doing so, egg
>>
>> User Gender Age
>> A M 20
>> B F 25
>> C M 30
>>
>>I want the query to return the column headings (user, gender, age etc)
>>for such a table.
>>
>>please help.
>>
>>Best regards,
>>Michael Bacchus
>>
>>Research In Motion Ltd.
>>BlackBerry: 519.573.6823
>>Phone: 519.888.7465 x 5853
>>Fax: 519.886.0863
>>mailto:[Email address protected]
>>www.rim.com or www.blackberry.com
>>
>>
>>
>>
>>---------------------------------------------------------------------
>>This transmission (including any attachments) may contain confidential information, privileged material (including material protected by the solicitor-client or other applicable privileges), or constitute non-public information. Any use of this information by anyone other than the intended recipient is prohibited. If you have received this transmission in error, please immediately reply to the sender and delete this information from your system. Use, dissemination, distribution, or reproduction of this transmission by unintended recipients is not authorized and may be unlawful.
>>
>>
>>--------
>>website: http://www.LazyDBA.com
>>Please don't reply to RTFM questions
>>Oracle documentation is here: http://tahiti.oracle.com
>>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>>To subscribe: see http://www.lazydba.com
>>By using this list you agree to these terms:http://www.lazydba.com/legal.html
>>
>
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these terms:http://www.lazydba.com/legal.html
>
>
>


Oracle LazyDBA home page