title: How to split columns into two in oracle sql based in character?
body: <p>I have a data set as below</p>
  <p>Table name :  Customer_tbl</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Customer_ID</th>
  <th>Customer_post</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>12985</td>
  <td>201</td>
  </tr>
  <tr>
  <td>20917$@98821$@749021$@357831</td>
  <td>201$@29$@29$@29</td>
  </tr>
  <tr>
  <td>548357$@276031</td>
  <td>201$@34</td>
  </tr>
  <tr>
  <td>80315$@75344$@345621</td>
  <td>201$@29$@14</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Output I need is as below</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Customer_ID_1</th>
  <th>Customer_ID_2</th>
  <th>Customer_post_1</th>
  <th>Customer_post_2</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>12985</td>
  <td></td>
  <td>201</td>
  <td></td>
  </tr>
  <tr>
  <td>20917</td>
  <td>98821$@749021$@357831</td>
  <td>201</td>
  <td>29$@29$@29</td>
  </tr>
  <tr>
  <td>548357</td>
  <td>276031</td>
  <td>201$@34</td>
  <td>34</td>
  </tr>
  <tr>
  <td>80315</td>
  <td>75344$@345621</td>
  <td>201$@29$@14</td>
  <td>29$@14</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I got the Customer_ID_1  &amp; Customer_post_1   as below</p>
  <pre><code>SELECT 
    REGEXP_SUBSTR(Customer_ID,'[^|@]+',1,1)  as Customer_ID_1 ,
    REGEXP_SUBSTR(Customer_post,'[^|@]+',1,1)  as  Customer_post_1
  FROM Customer_tbl
  </code></pre>
  <p>How to get the  Customer_ID_2  and Customer_post_2 columns in the same select statement ?</p>