title: Replacing values from a column with RegEx in Oracle
body: <p>I need edit the values of a column in Oracle database. In this, the values follow a pattern:</p>
  
  <p><code>123456789X</code></p>
  
  <p>The modification requires the following change:</p>
  
  <ul>
  <li>add six 0's </li>
  <li>add blank space between the 0's and the X</li>
  </ul>
  
  <p><code>123456789000000        X</code></p>
  
  <p>I need make this change with a pattern or RegExp in a single query.</p>
  
  <p>Thanks</p>