title: How to replace comma separated text values in a column in Oracle?
body: <p><a href="https://i.stack.imgur.com/RDB9P.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/RDB9P.png" alt="Sample Data"></a></p>
  
  <p>I have a table <code>t1</code> with a varchar col <code>V_RELNIST_SKEY</code> which contains comma separated numbers between 1 and 12 as shown. I want to write a select statement to replace numbers by string. For e.g., value <code>5,6</code> should be replaced by <code>five,six</code> and so on.  </p>
  
  <pre><code>|V_RELNIST_SKEY|
  |6             |
  |5,6           |
  |1,12          |
  |1,2,3,12      |
  </code></pre>