RE: replace or translate?

From: Knight, Jon <jknight_at_concordefs.com>
Date: Thu, 10 Feb 2005 11:12:18 -0600
Message-ID: <17ECCBDCF27C544583F2CAD928F953260221FAF8@memex1.corp.cefs.int>

  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".

Jon Knight
Senior Database Analyst
2525 Horizon Lake Drive, Suite 120
Memphis, TN 38133
JKnight_at_concordefs.com

901.371.8000 - Phone
800.238.7675 - Phone
901.380.8336 - Fax
www.FirstData.com

First Data's merger with Concord creates "One Company" with enhanced choice, voice and innovation for all customers.

 -----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,';?','//')

--

Sami Seerangan
Oracle DBA
--

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

http://www.freelists.org/webpage/oracle-l Received on Thu Feb 10 2005 - 12:15:08 CST