title: How to replace specific word on a large text in a column using Oracle
body: <p>I am looking to replace values in a particular column.
  For example the following column values</p>
  <pre><code>desc
  ----------
  Test1 words = 30 have so much words = 20 over 60 words +
  Test2 words = 30 have so much words = 20 over 60 words +
  Test3 words = 30 have so much words = 20 over 60 words +
  Test4 words = 30 have so much words = 20 over 60 words +
  </code></pre>
  <p>should be (replacing ords = 20 with Alpha = 20)</p>
  <p>result:</p>
  <pre><code>desc
  ----------
  Test1 words = 30 have so much Alpha = 20 over 60 words +
  Test2 words = 30 have so much Alpha = 20 over 60 words +
  Test3 words = 30 have so much Alpha = 20 over 60 words +
  Test4 words = 30 have so much Alpha = 20 over 60 words +
  </code></pre>
  <p>I have tried the following :</p>
  <p>update table set desc = REPLACE('words = 20', 'words', 'Alpha') where ;</p>
  <p>This results to :</p>
  <p>Alpha = 20  instead of the entire row.
  however, how can I keep the rest of the text just change &quot;words = 20&quot; but still keep the rest of the test?</p>