title: How to split a CLOB content based on a delimiter?
body: <p>I have a CLOB content like below,</p>
  
  <pre>
  Thu Jun 24 12:04:58 PDT 2004|jnarayan|Scott from Sales
          called, missing payment, I will let Antonio know of this and ask
          him to reverse payment. However, still short of the total past
          due. I am UNLOCKING THE PORTS, BUT COSTOMER HAS TO SEND IN THE
          REMAINING PAST DUE BALANCES AT THE EARLIEST.
  </pre>
  
  <p>Based on the Delimiter '|' I want to split this content and I want to insert into a new table </p>
  
  <pre>
  'TEST'
  -------
  </pre>
  
  <p>and columns like </p>
  
  <pre>
  note_date,
  name,
  note_text
  </pre>