Re: sqlplus column underline

From: Prasad Chavali <pchavali_at_assettech.com>
Date: 8 May 1998 16:33:00 -0700
Message-ID: <6j04nc$4vp_at_nntp02.primenet.com>


Try changing the linewidth.

SQL> Set Line 100
(Or whatever you need for your underline to be in one line.

HTH Prasad Chavali
cwass_at_dacotah.com wrote in message <6ivts1$227$1_at_nnrp1.dejanews.com>...
>I have a comment field that I am selecting for a report. I am trying to
get
>the underline off the comment but not the rest of the fields.
>
>I'm doing this:
>
>COLUMN Comments newline heading '' format a40
>
>SELECT Location, Resdate, Restime, Name, Comments
>FROM Reservation
>WHERE somecriteria;
>
>And I'm getting this: (whithout the line of '+')
>
>++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Location Resdate Restime Name
>-------- --------- ------- --------------
>-----------------------------------------
>BALT130 10-MAY-98 12:00 JOHN DOE
>comments for john doe party appear here
>
>BALT130 10-MAY-98 12:00 JANE DOE
>jane doe comments appear here
>
>++++++++++++++++++++++++++++++++++++++++++++++++++
>
>
>I want the comments to show up on the next line like they are doing. How
do
>I get rid of the long line of '-'? SET UNDERLINE OFF is all or nothing. I
>need underlines under the other fields.
>
>Any ideas?
>
>TIA
>
>Craig
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Sat May 09 1998 - 01:33:00 CEST

Original text of this message