title: (Oracle) SQL String Manipulation Update - Replace URL Substring
body: <p><strong>(Oracle)</strong></p>
  
  <p>I need to do a SQL update on a table column that stores URL strings. All strings in that column that look like</p>
  
  <pre><code>http://abc.site.com/...
  </code></pre>
  
  <p>should be replaced with</p>
  
  <pre><code>http://def.site.com/...
  </code></pre>
  
  <p>Is there a quick way to do this string replacement in SQL for the rows that satisfy the condition?</p>