| 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,
The other way to do this is to change the SQL statement:
select col1, rpad(col2, LENGTH OF COLUMN 2) || col3 col2 from table1;
This appends the col3 value to col2 and therefore does not put a heading above col3, just uses the col2 heading.
With this option all of the formatting of the column must be doe as part of the SELECT statement, and does not work very well if col2 or col3 might wrap.
If changing the SELECT statement like this does not work, then I think the only thing you can do is format with no heading as shown below.
Good Luck,
Ron Alldaffer
Ciber, Inc. Consultant
Maple Grove, MN
On Friday, October 27, 2000 3:39 PM, KLOPPING, JEFFREY L
[SMTP:jklopping_at_oppd.com] wrote:
> This comes close...
>
> SQL> column showme format a06;
>
> SQL> column notme format a06 heading ' '
>
> SQL> select dummy showme, dummy notme from dual;
>
>
>
> SHOWME
>
> ------ ------
>
> X X
>
>
>
> SQL>
>
> > -----Original Message-----
> > From: Kimberly Smith [SMTP:kimberly.smith_at_gmd.fujitsu.com]
> > Sent: Friday, October 27, 2000 2:53 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Suppressing a column heading
> >
> > 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?
> >
> >
 |
 |