title: How can I achieve the following in oracle without creating a stored procedure?
body: <p>data set:</p>
  
  <pre><code>employee_id   phone_number
   1              123
   2              456
   3              789
  </code></pre>
  
  <p>result:</p>
  
  <pre><code>employee_id   phone_number
   1              123456
   2              456789
   3              789...
  </code></pre>