| 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,
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____________________Subject: Suppressing a column heading 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?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kimberly Smith
INET: kimberly.smith_at_gmd.fujitsu.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Oct 27 2000 - 14:47:09 CDT
 |
 |