| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Suppressing a column heading
Kimberly,
Following up on this thought, if you 'set underline off', then you can format the column headings for col1 and col2 to include the underline, like this:
set underline off
column col1 heading "COL1|----" column col2 heading "COL2|----" column col3 heading ""
select 'xxxx' col1, 'yyyy' col2, 'zzzz' col3 from dual;
COL1 COL2
---- ----
xxxx yyyy zzzz
So this gives you exactly what you want, and you can ignore my earlier lame attempt at this.
Good Luck,
Ron Alldaffer
Ciber Inc. Consultant
Maple Grove, MN
On Friday, October 27, 2000 3:57 PM, dgoulet_at_vicr.com
[SMTP:dgoulet_at_vicr.com] wrote:
> Kimberly,
>
> Sure: column <column_name> heading ""
>
> Regretabbly you still get the dashes above the column data unless you 'set
> underline off' in which case there are NO dashes at all. As in this:
>
> MODEL_NUMBER SERIAL_NUMBER ARCH_TAPE_ID
> IP-231-07 529904080326 14-APR-1999 3
> VI-910402 01990413084838 16-APR-1999 3
> MI-220-MW 009611071361 08-NOV-1999 1
> MI-220-MW 009611071358 13-MAY-1999 1
> IP-HAMD-CM-02 519912160440 18-DEC-1999 0
> VI-264-IU 110007295792 08-AUG-2000 0
> MI-22L-IW 010010055773 10-OCT-2000 0
> VI-260-CV 999999999 12-OCT-2000 0
> VI-260-CV 89999 12-OCT-2000 0
>
> Dick Goulet
>
> ____________________Reply Separator____________________
> Author: Kimberly Smith <kimberly.smith_at_gmd.fujitsu.com>
> Date: 10/27/00 11:53 AM
>
> I have a developer here who would like to suppress a column heading
> for one column but have it normal for the rest. The following is an
> example of what he wants.
>
> select col1, col2, col3
> from table1;
>
> col1 col2
> ------ ------
> value value value
>
> Is this possible?
>
>
 |
 |