Re: replace or translate?

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

Other related posts: