title: Oracle 11gR2: split string with multiple delimiters(add)
body: <pre><code>String val = &quot;ABC,abc|DEF,def|GHI,g hi|JKL,jkl&quot;;
  </code></pre>
  <p>How to split this string and insert into tables using sql, pl/sql or whatever.</p>
  <p><code>,</code> is column delimiter and <code>|</code> is row delimiter.</p>
  <p>is it possible?</p>
  <p>[expected result]</p>
  <pre><code>col1    col2
  ------------
  ABC     abc
  DEF     def
  GHI     g hi
  JKL     jkl
  </code></pre>
  <hr />
  <h2>Addition Question</h2>
  <p>Thanks reply.
  I have a another question.</p>
  <p>this is a string.</p>
  <pre><code>String val = &quot;ABC,abc||D|@EF,def||G|HI,g hi||JKL,jkl&quot;;
  </code></pre>
  <p>I want to split by only <code>||</code> delimiter. how to use the RegExp?</p>
  <p>I try it such as <code>'[^|]{2}+'</code>, <code>'^[|]{2}+', 1,</code> etc..</p>
  <p>this is my wrong result.</p>
  <p>[wrong result]</p>
  <pre><code>COL1       COL2
  ---------- ----------
  BC         abc
             D
  @EF        def
             G
  HI         g hi
  JKL        jkl
  </code></pre>
  <p>[expected result]</p>
  <pre><code>col1    col2
  -----------
  ABC     abc
  D|@EF   def
  G|HI    g hi
  JKL     jkl
  </code></pre>