replace or translate?

  • From: Sami Seerangan <dba.orcl@xxxxxxxxx>
  • To: Oracle Discussion List <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 10 Feb 2005 12:07:39 -0500

Which one is better?
replace(replace(a.url_addr_text,';','/'),'?','/')  
translate(a.url_addr_text,';?','//') 

-- 
Sami Seerangan
Oracle DBA
--
//www.freelists.org/webpage/oracle-l

Other related posts: