Re: Help: Blank spaces
From: Austin Moseley <austinmoseley_at_hotmail.com>
Date: Tue, 02 Feb 1999 14:48:30 -0600
Message-ID: <36B7649E.4150C4E7_at_hotmail.com>
Date: Tue, 02 Feb 1999 14:48:30 -0600
Message-ID: <36B7649E.4150C4E7_at_hotmail.com>
[Quoted] The replace( str, r1, r2 ) function in Oracle will replace ALL occurrences of r1 in str with r2, regardless of how many times r1 appears.
[Quoted] ..REPLACE( 'test 1111', '1','2') ...
returns 'test 2222'.
No need to do the following:
> 2 REPLACE(
> 3 REPLACE('this is a string',
> 4 ' ', ' '), -- 4 blanks into 1
> 5 ' ', ' '), -- 3 blanks into 1
> 6 ' ', ' ') -- 2 blanks into 1
> 7 FROM DUAL;
>
> REPLACE(REPLACE(
Received on Tue Feb 02 1999 - 21:48:30 CET