recursion must come from my 'C' days.
"Syltrem" <syltremspammenot_at_videotron.com> wrote in message
news:5AmN8.3114$H67.16607_at_tor-nn1.netcom.ca...
> That works just great!
> A clever way to do it, too!
>
> Thanks
>
> --
>
> Syltrem
> http://pages.infinit.net/syltrem (OpenVMS related web site - en français)
> To reply to myself directly, remove .spammenot from my address
>
> "justme" <someq_at_rogers.com> a écrit dans le message de news:
> Vx9N8.245295$ah_.191253_at_news01.bloor.is.net.cable.rogers.com...
> > here is your function
> >
> > create or replace function F_SPACES( in_string varchar2)
> > return varchar2
> > is
> > lcl varchar2(2000);
> > double_space varchar2(2) := ' ';
> > single_space varchar2(1) := ' ';
> > BEGIN
> > lcl :=replace(in_string,double_space,single_space);
> >
> > if instr(lcl,double_space) > 0 then
> > lcl := f_spaces(lcl);
> > end if;
> >
> > return(lcl);
> > END;
> > /
> > "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 Wed Jun 12 2002 - 20:36:51 CDT
