Re: Non-columnar output possible from SQL/PLUS ?

From: Jomarlen <jomarlen_at_aol.com>
Date: 1998/03/06
Message-ID: <19980306212200.QAA05590_at_ladder03.news.aol.com>#1/1


>Does anyone know of a setting in SQL/Plus that will
>produce output with trailing blanks removed from each
>field such that the columns don't line up?
>I am using Oracle 7.3.
>
>I use the COLSEP parameter to produce Tab delimited rows
>like this:
> Column A Row1 <tab>Column B Row1 <tab>Column C Row1
> Column A Row 2 <tab>Column B Row 2 <tab>Column C Row 2
 

>But I would like the results to look like this:
> Column A Row1<tab>Column B Row1<tab>Column C Row1
> Column A Row 2<tab>Column B Row 2<tab>Column C Row 2
> ...

[Quoted] Select col_a||chr(9)||col_b||chr(9)||col_c etc....... Received on Fri Mar 06 1998 - 00:00:00 CET

Original text of this message