Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re:Suppressing a column heading

Re:Suppressing a column heading

From: <dgoulet_at_vicr.com>
Date: Fri, 27 Oct 2000 15:47:09 -0400
Message-Id: <10662.120499@fatcity.com>


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?




Kimberly Smith
EDS
Fujitsu/GMD
21015 SE Stark St
Gresham, OR
97030
Phone: (503) 669-6050
Fax : (503) 669-5705

--

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US