I meant "better" in terms of performance
On Thu, 10 Feb 2005 11:12:18 -0600, Knight, Jon <jknight_at_concordefs.com> 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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> 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
Received on Thu Feb 10 2005 - 12:21:48 CST
