Re: Whitespace question

From: Richard Spee <rhpspee_at_wxs.nl>
Date: Mon, 10 Jun 2002 20:38:15 +0200
Message-ID: <ae2s48$icd$1@reader12.wxs.nl>

Run the following script in Sqlplus

/*
I'm not very proud of it, but the result is what you want */

create table temp (a varchar2(10)

                  ,b varchar2(10)
                  );
insert into temp values ('A1',null);
insert into temp values ('A2',null);

insert into temp values ('A3',null);
insert into temp values ('A4','B1');

set linesize 80
set pagesize 0

select  rpad('A',80,' ')
||      rpad('-',80,'-')
||      decode(b,null,null,rpad('B',80,' '))
||      decode(b,null,null,rpad('-',80,'-'))
||      rpad(a,80,' ')
||      decode(b,null,null,rpad(b,80,' '))

from temp
/

"Syltrem" <syltremspammenot_at_videotron.com> wrote in message news:1W2N8.3017$H67.15842_at_tor-nn1.netcom.ca...
> Good morning everyone!
>
> I've been researching for :
> a) a function that converts multiple spaces or tabs to a single space in a
> string
> b) a way to suppress blank lines from the output of a SELECT in SQL*Plus
>
> For b) here's an example
> set linesize 80
> column a format a80
> column b format a80
> select 'xxx' a, ' ' b from dual;
>
> Since b is empty, a blank line is displayed. I would like to know if there's
> any way to avoid printing blank lines. The thing is (in real life) b is
> almost always empty so the reports looks like double-spaced.
>
> Merci beaucoup!
>
> --
>
> Syltrem
> http://pages.infinit.net/syltrem (OpenVMS related web site - en français)
> To reply to myself directly, remove .spammenot from my address
>
>
>
Received on Mon Jun 10 2002 - 13:38:15 CDT