Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Whitespace question
try
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 wrap off
-- Niall Litchfield Oracle DBA Audit Commission UK "Syltrem" <syltremspammenot_at_videotron.com> wrote in message news:vf8N8.3066$H67.16055_at_tor-nn1.netcom.ca...Received on Mon Jun 10 2002 - 16:37:01 CDT
>
> > 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)
>
>
>