title: How to UPDATE by using REPLACE on different patterns within the same column value in Oracle?
body: <p>Here is a sample data of what I have in my <code>table FOO</code> -</p>
  
  <pre><code>        CREATE TABLE FOO 
             ( 
              NUMBERS VARCHAR2(4000 CHAR)
             );
  
             INSERT INTO FOO VALUES ('One,Five,Seven');
             INSERT INTO FOO VALUES ('One,Two,Three');
             INSERT INTO FOO VALUES ('Five,Five,Seven');
             INSERT INTO FOO VALUES ('Zero,Five,Seven');
         /*  .
             .
             .
            and so on.. */
  
  SELECT * FROM FOO;
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/R0obs.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/R0obs.png" alt="the sample data"></a></p>
  
  <p>I want to write an update statement to replace the text by their respective number. So the output should be like -</p>
  
  <p><a href="https://i.stack.imgur.com/YGss3.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/YGss3.png" alt="Output"></a></p>