title: What is the difference between TRANSLATE and REPLACE in sql?
body: <p>select translate('flipflop','fl','h') from dual;</p>
  
  <p>select replace('flipflop','fl','h') from dual;</p>
  
  <p>These two queries give the same output,then why do we have different commands for carrying out the same operation?</p>