title: Using replace with select statement for a specific column in SQL oracle
body: <p>Lets say I have a following table named INFO:</p>
  
  <pre><code>NAME   CITY                PROFESSION
  A      New-Mexico          Software-Developer
  B      Tampa               Software-Analyst
  </code></pre>
  
  <p>I only wish to replace the "-" in the PROFESSION column with a '/'. What should be the query to display ALL contents of the table INFO , with the above mentioned change?</p>
  
  <p>I tried :</p>
  
  <pre><code>SELECT REPLACE(PROFESSION,'-','/') , * from INFO;
  </code></pre>
  
  <p>But this does not work.</p>