create or replace and compile java source named out_reestr as
import java.io.BufferedReader;
import java.io.Reader;
import java.io.StringReader;
import java.io.*;
import java.util.StringTokenizer;
import java.sql.*;
import oracle.sql.CLOB;
import oracle.jdbc.driver.*;


 public class OUT_CSV_REESTR {

   public static oracle.sql.CLOB replaceClob(oracle.sql.CLOB cont, String find,String replace) throws SQLException,IOException {

      String content;
      int length;
      StringBuffer buf;
      CLOB clob=null;
      java.io.Writer out=null;
      Connection con = null;
        try {
            if (cont != null) {
               buf = new StringBuffer("");
               Reader is = cont.getCharacterStream();
               char buffer[] = new char[ 8192 ];
               while((length=is.read(buffer, 0 , 8192 )) != - 1 )
                 buf.append(buffer, 0 ,length);
               content=buf.toString();
               content=content.replaceAll(find,replace);
             }
             else
             return null;
             
            con=new OracleDriver().defaultConnection();
            clob = CLOB.createTemporary(con, true, CLOB.DURATION_SESSION);
            out=clob.setCharacterStream( 0 );
            out.write(content);
             
        } catch (Exception ex) {
           return null;
        }
        finally {
           if(out!=null) out.close();
     }
        return clob;
    }
 }

 -- Заменяет внутри clob подстроки
 create or replace function replaceClob(p_clob clob, p_find varchar2, p_replace varchar2)
    return clob as
    language java name 'OUT_CSV_REESTR.replaceClob(oracle.sql.CLOB, java.lang.String,java.lang.String)   return clob';

select
/* 
 regexp_substr(str,'[^'||chr(9)||']+',1,1) f1,
 regexp_substr(str,'[^'||chr(9)||']+',1,2) f1,
 regexp_substr(str,'[^'||chr(9)||']+',1,3) f1,
 */
* 
from (
select 
  extract(column_value,'/b/text()').getStringVal() str
 from
  table(
      xmlsequence(xmltype(
   '<a><b>'
    ||
   -- clob_replace
     java_pck.replaceclob ((select reestr from log_table where t.id= 2124 ),chr( 13 )||chr( 10 ),'</b><b>')
    ||
   '</b></a>'
   ).extract('//b')
  )
 )
)  

select 
extractvalue(column_value,'/b/c[1]'),
extractvalue(column_value,'/b/c[2]'),
extractvalue(column_value,'/b/c[3]'),
extractvalue(column_value,'/b/c[4]'),
extractvalue(column_value,'/b/c[5]'),
extractvalue(column_value,'/b/c[6]'),
extractvalue(column_value,'/b/c[7]')
from
table(
      xmlsequence(xmltype (
 '<a><b><c>'
    ||
    java_pck.replaceclob (
      java_pck.replaceclob ((select reestr from sverkareestr t where t.id= 2431  ),chr( 13 )||chr( 10 ),'</c></b><b><c>')
    ,chr( 9 ),'</c><c>')||'</c></b></a>' 
  ).extract('//b')
  )
 )

create or replace and compile java source named out_reestr as
import java.io.BufferedReader;
import java.io.Reader;
import java.io.StringReader;
import java.io.*;
import java.util.StringTokenizer;
import java.sql.*;
import oracle.sql.CLOB;
import oracle.jdbc.driver.*;


 public class OUT_CSV_REESTR {

 public static String  replace(String str, String find,String replace) {
    StringBuffer sb = new StringBuffer("");
    int index;
    int offset =  0 ;
    for(index = str.indexOf(find); index != - 1 ; index = str.indexOf(find)){
      sb.append( str.substring( 0 , index) );
      sb.append( replace );
      offset = index + find.length();
      str = str.substring( offset );
    }
   sb.append(str);
   return sb.toString();
}


  public static oracle.sql.CLOB replaceClob(oracle.sql.CLOB cont, String find,String replace) throws SQLException,IOException {

      String content;
      int length;
      StringBuffer buf;
      CLOB clob=null;
      java.io.Writer out=null;
      Connection con = null;
        try {
            if (cont != null) {
               buf = new StringBuffer("");
               Reader is = cont.getCharacterStream();
               char buffer[] = new char[ 8192 ];
               while((length=is.read(buffer, 0 , 8192 )) != - 1 )
                 buf.append(buffer, 0 ,length);
               content=buf.toString();
               content=replace(content,find,replace);
               //content.replaceAll(find,replace);
             }
             else
             return null;
             
            con=new OracleDriver().defaultConnection();
            clob = CLOB.createTemporary(con, true, CLOB.DURATION_SESSION);
            out=clob.setCharacterStream( 0 );
            out.write(content);
             
        } catch (Exception ex) {
           return null;
        }
        finally {
           if(out!=null) out.close();
     }
        return clob;
    }
}

select
*
from (
select 
extract(column_value,'/b/text()').getStringVal() str
from
table(
xmlsequence(xmltype(
'<a><b>'
||
java_pck.replaceclob ((select reestr from sverkareestr t where t.id= 1 ),chr( 10 ),'</b><b>')
||
'</b></a>'
).extract('//b')
)
)
) 

with t1 as (
    select rownum rn, str  from (
        select extract(column_value,'/b/text()').getStringVal() str from
        table( xmlsequence(xmltype('<a><b>'||
             java_pck.replaceclob ((select reestr from sverkareestr t where t.id= 1 ),chr( 10 ),'</b><b>')||
             '</b></a>').extract('//b'))))
          )
SELECT rn, (REGEXP_SUBSTR(str,
  '[^ ]+',  1 , Level)) wrd
     FROM t1 
     CONNECT BY 
     prior rn=rn and prior dbms_random.random is not null
     and
     REGEXP_SUBSTR(str, '[^ ]+',  1 , LEVEL) IS not NULL