Re: Whitespace question

From: Syltrem <syltremspammenot_at_videotron.com>
Date: Mon, 10 Jun 2002 16:47:41 -0400
Message-ID: <vf8N8.3066$H67.16055@tor-nn1.netcom.ca>

> There may be a translation issue here and his English is far better than
my
> French. So here's another shot at it.
>
> 1. Look at the NVL function in your SQL
> 2. Look at setting trimout to off in SQL*Plus
> 3. Look at setting head to off in SQL*Plus
>
> Daniel Morgan
>
>

I'll try keep it as simple as possible:
Let's see:

create table temp (a varchar2(80)
                  ,b varchar2(80)
                  ,c varchar2(80));
insert into temp values ('A1',null.'C1');
insert into temp values ('A2',null,'C2');

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

set linesize 80
set recsep off
set pagesize 0
break by a
select a, b, c from temp;
A2

C2
A3

C3
A4
B1
C4

3 rows selected.

I DO NOT WANT THE 2 BLANK LINES, AND ONLY THOSE ! :-)
I think I should have given this example from the start. That's the best way I can explain this.
Thanks!

--

Syltrem
http://pages.infinit.net/syltrem (OpenVMS related web site - en français)

Received on Mon Jun 10 2002 - 15:47:41 CDT