Re: sqlplus column underline

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: Sat, 09 May 1998 03:34:56 GMT
Message-ID: <6j0isu$192_at_bgtnsc01.worldnet.att.net>

On Fri, 08 May 1998 21:36:00 GMT, cwass_at_dacotah.com wrote:

>
>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.

This is a bit hokey, but I've done it before and it does work.

1. SET UNDERLINE OFF

Now you have no underlines at all, so you have to manually put them in where you want them.

COLUMN not_the_comment heading "Location|________"

The vertical bar in your heading should start a new line. This way you get underlines only where you want them. CAVEAT, I've never tried this technique, and at the same time tried to wrap columns to a new line like you are doing.

Hope this helps,

Jonathan Received on Sat May 09 1998 - 05:34:56 CEST