Re: replace or translate?

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.


On Thu, 10 Feb 2005 12:17:15 -0500, Sami Seerangan <dba.orcl@xxxxxxxxx> wrote:
> 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
> 


-- 
bill coulam
bcoulam@xxxxxxxxx
--
http://www.freelists.org/webpage/oracle-l

Other related posts: