Re: How to control width of column headers on select

From: Bricklen Anderson <bricklen13_at_hotmail.com>
Date: 1 Mar 2002 10:04:46 -0800
Message-ID: <b416ca2d.0203011004.3423c8f0_at_posting.google.com>


in SQL*Plus, type:
column status_cd heading 'Status CD' format a10

(the heading 'Sta..' is optional. the format sets the width. 'a' means alphanumeric, 10 is the number of characters wide). when you want to get rid of the columns, just type in: clear columns (clears all formatting to your cols)

neo_thinker_at_hotmail.com (Neothinker) wrote in message news:<d351ed4f.0203010801.5171930f_at_posting.google.com>...
> If I have a table that has an ID (10 characters) and STATUS_CD (1
> character), when I do a SELECT the output will look like:
>
> ID S
> ---------- -
> ABCD123 C
>
> Since the STATUS_CD field is only one character, only the first
> character of the column header is displayed. How can I make it do
> this:
>
> ID STATUS_CD
> ---------- ---------
> ABCD123 C
Received on Fri Mar 01 2002 - 19:04:46 CET

Original text of this message