Connected to Oracle9i Enterprise Edition Release 9.2.0.7.0 
Connected as dsadmin
 
SQL> set serveroutput on;
SQL> 
SQL> declare
  2    src_email clob;
  3    cursor email is
  4    select a.nm nm1,b.nm nm2 from
  5  (select 'TEST1' nm from dual
  6  union all
  7  select 'TEST2' from dual
  8  union all
  9  select 'TEST4' from dual
 10  union all
 11  select 'TEST5' from dual
 12  union all
 13  select 'TEST6' from dual
 14  union all
 15  select 'TEST7' from dual
 16  ) a,
 17  (select 'GAS1' nm from dual
 18  union all
 19  select 'GAS2' from dual
 20  union all
 21  select 'GAS4' from dual
 22  union all
 23  select 'GAS5' from dual
 24  union all
 25  select 'GAS6' from dual
 26  union all
 27  select 'GAS7' from dual
 28  ) b;
 29  
 30    begin
 31    src_email := 'here it is';
 32    for cur_email in email loop
 33      src_email := src_email ||' Aha again!'||cur_email.nm1||cur_email.nm2||'this is the approach,Tried something like this way (There might be much more optimized /better sql.But this is what came to my mind. Thought about considering min and max value to define the range)(There might be much more optimized /better sql.But this is what came to my mind. Thought about considering min and max value to define the range)(There might be much more optimized /better sql.But this is what came to my mind. Thought about considering min and max value to define the range)(There might be much more optimized /better sql.But this is what came to my mind. Thought about considering min and max value to define the range)ried something like this way (There might be much more optimized /better sql.But this is what came to my mind. Thought about considering min and max value to define the range)(There might be much more optimized /better sql.But this is what came to my mind. Thought about considering min and max value to define the range)(There might be much more optimized /better sql.But this is what came to my mind. Thought about considering min and max value to define the range)(There might be much more optimized /better sql.But this is what came to my mind. Thought about considering min and max value to define the range)';
 34    end loop;
 35    dbms_output.put_line(to_char(length(src_email)));
 36    end;
 37  
 38  /
 
45658
 
PL/SQL procedure successfully completed
 
SQL>