Re: replace or translate?

From: Sami Seerangan <dba.orcl@xxxxxxxxx>
To: jknight@xxxxxxxxxxxxxx
Date: Thu, 10 Feb 2005 12:17:15 -0500

I meant "better" in terms of performance


On Thu, 10 Feb 2005 11:12:18 -0600, Knight, Jon <jknight@xxxxxxxxxxxxxx> wrote:
>  All things being equal, I prefer the translate because it's cleaner/less
> code.  But, it really depends on how your using it and what you mean by
> "better".
> 
 -----Original Message-----
> From:   oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> On Behalf Of Sami Seerangan
> Sent:   Thursday, February 10, 2005 11:08 AM
> To:     Oracle Discussion List
> Subject:        replace or translate?
> 
> Which one is better?
> replace(replace(a.url_addr_text,';','/'),'?','/')
> translate(a.url_addr_text,';?','//')
>
--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

Re: replace or translate?
From: Bill Coulam

References:
- RE: replace or translate?
  - From: Knight, Jon

Re: replace or translate?

Other related posts: