Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Whitespace question
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 Mon Jun 10 2002 - 17:15:17 CDT