Re: replace or translate?

Thanks to Bill and everyone who responded.

I ran a test case on 10M rows (do have complex strings) with two nested REPLACE calls vs. a simple TRANSLATE. The result is opposite to yours.

Replace took 13 mins
Translate took 20 mins

On Thu, 10 Feb 2005 19:03:14 -0600, Bill Coulam <bcoulam_at_gmail.com> wrote:
> I ran a number of tests on 125K rows with three nested REPLACE calls
> vs. a simple TRANSLATE. On my box, the translate is not only cleaner
> to code, but edged out the REPLACE by a second every time. 'Course if
> I were replacing some complex string, I wouldn't even know where to
> being if I were forced to use TRANSLATE; I'd turn to REPLACE.
>
> - bill c.

--
http://www.freelists.org/webpage/oracle-l