Re: Remove whitespaces in varchar2

From: Jan Gelbrich <j_gelbrich_at_westfalen-blatt.de>
Date: Thu, 31 Jul 2003 13:20:09 +0200
Message-ID: <bgau57$mo54h$1@ID-152732.news.uni-berlin.de>

from scratch; I do not recall ASCII codes from my mind ...

SQL> declare
  2 n Number := 1;
  3 begin

  4     loop
  5     exit when n=50;
  6        dbms_output.put_line (n|| ' : token is >'||chr(n)||'<');
  7     n := n+1;
  8     end loop;

  9 end;
 10 /

1 : token is >
<
2 : token is ><
3 : token is ><
4 : token is ><
5 : token is ><
6 : token is ><
7 : token is ><
8 : token is ><
9 : token is >  <        --here it is: Tab = Chr(9) . Then You can use

REPLACE for your work.
10 : token is >
<

11 : token is ><
12 : token is ><
13 : token is >

<
14 : token is ><
...

30 : token is ><
31 : token is ><
32 : token is > <
33 : token is >!<
34 : token is >"<
35 : token is >#<
36 : token is >$<
37 : token is >%<
38 : token is >&<
39 : token is >'<
40 : token is >(<
41 : token is >)<
42 : token is >*<
43 : token is >+<
44 : token is >,<
45 : token is >-<
46 : token is >.<
47 : token is >/<
48 : token is >0<
49 : token is >1<

...
hth, Jan

"Marc Eggenberger" <marc.eggenberger_at_itc.alstom.com> schrieb im Newsbeitrag news:MPG.1992fe16a5b0317b9896c0_at_iww.cacti.ch.alstom.com...
> In article <bgak3r$mudi0$1_at_ID-152732.news.uni-berlin.de>,
> j_gelbrich_at_westfalen-blatt.de says...
>
> > Do You mean ' ' (one space) and ' ' (two spaces) and so forth ?
>
> Yes .. those. and tabulators
>
> [...]
>
> --
> mfg
> Marc Eggenberger
Received on Thu Jul 31 2003 - 06:20:09 CDT