title: Handle wordrap deliminator in CLOB fields
body: <p>I have this request below that does exactly what I want but  it does it only if the fields Author_ID and Author_Name are VARCHAR and values within them are separated by stars like in this table:</p>
  
  <pre><code>ID_BOOK | ID_AUTHOR |       NAME AUTHOR       |
  -----------------------------------------------
  001     |01         | AuthorU                 | 
  -----------------------------------------------
  002     |02*03*04   | AuthorX*AuthorY*AuthorZ |
  -----------------------------------------------
  </code></pre>
  
  <p>The request will give me this result:</p>
  
  <pre><code>ID_BOOK | ID_AUTHOR |       NAME AUTHOR       |
  -----------------------------------------------
  001     |01         | AuthorU                 |
  -----------------------------------------------
  002     |02         | AuthorX                 |
  -----------------------------------------------
  002     |03         | AuthorY                 |
  -----------------------------------------------
  002     |04         | AuthorZ                 |
  -----------------------------------------------
  </code></pre>
  
  <p>BUT in real life these two fields are CLOB and there is no star deliminator, there i a wordrap deliminator, so data looks like that in real life:</p>
  
  <pre><code>ID_BOOK | ID_AUTHOR |       NAME AUTHOR       |
  -----------------------------------------------
  001     |01         | AuthorU                 | 
  -----------------------------------------------
  002     |02*03*04   | AuthorXAuthorYAuthorZ   |
  </code></pre>
  
  <p>I'm trying to have the same result that i got it with the Varchar fields and the star deliminator because with CLOB I can't use REGEXP_SUBSTR and I don't know how to handle the wordrap deliminator. Could you please help me with some hints. Many thanks. </p>
  
  <pre><code>SELECT
   ID_Book,
   REGEXP_SUBSTR(ID_Author, '[^*]+', 1, Counter) AS AuthID,
   REGEXP_SUBSTR(Name_Author, '[^*]+', 1, Counter) AS AuthName
  FROM Books
  CROSS JOIN (
    SELECT LEVEL Counter
      FROM DUAL
      CONNECT BY LEVEL &lt;= (      
        SELECT MAX(REGEXP_COUNT(ID_Author, '[^*]+'))
        FROM Books))
  WHERE REGEXP_SUBSTR(Name_Author, '[^*]+', 1, Counter) IS NOT NULL
  ORDER BY 1, 2
  </code></pre>