Re: sqlplus column underline

Thanks for the suggestions. Jonathan Gennick's worked. Another solution was to turn off all column headings and make the desired heading part of ttitle. But after all this sqlplus wouldn't keep the comment line with the rest of the fields if it was at the end of a page. And I couldn't get it to supress blank lines.

I wound up writing the data to a delimited format and then using Perl. Perl prevents the comments from going over a page break and will also supress blank lines.

In article <6ivts1$227$1_at_nnrp1.dejanews.com>,   cwass_at_dacotah.com wrote:
>
> 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
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed May 13 1998 - 21:34:15 CEST