title: Replacing TAB in Oracle SQL query
body: <p>Below is the query ,I am facing problem in replacing TAB and display into in one column</p>
  
  <pre><code>with test as 
  (select 'ABC    DEF GHI JKL MNO' str from dual 
  ) 
  select regexp_substr (str, '[\t]+', 1, rownum) split 
    from test 
  connect by level &lt;= length (regexp_replace (str, '[\t]+'))  + 1
  </code></pre>
  
  <p>while query is working for comma in pace of tab [^,]</p>