oracle 当sql包含有text类型的语句执行

5：对Clob字符串的处理
declare myContext clob ;
begin
FOR rowData IN (select * from TBLTVDR_N8770B_STIH237)
   LOOP
     myContext := '';
      myContext := rowData.Cscdata1 || rowData.Cscdata2;
      update TBLTVDR_N8770B_STIH237 set cscdata = myContext where nuid = rowData.Nuid;
   END LOOP;
end;


select length(cscdata) as cscdata,length(Cscdata1) as Cscdata1, length(Cscdata2) as Cscdata2,( length(Cscdata1) + length(Cscdata2)) as total   from TBLTVDR_N8770B_STIH237;

select count(*) from TBLTVDR_N8770B_STIH237;

 

update tblembratel_n8770h_stih237 set cscdata = to_clob(Cscdata1)  || (Cscdata2)

commit;