Codedeclare pag number; len number; c varchar2(10); charpp number := 8132/2; begin for r in (select rowid rid,log_id, dbms_lob.getlength (CONTENT) len from temp_data_collect_log ) loop if r.len is not null then for page in 0..r.len/charpp loop begin select dbms_lob.substr (CONTENT, 1, 1+ (page * charpp)) into c from temp_data_collect_log where rowid = r.rid; exception when others then dbms_output.put_line ('Error on log_id' ||R.log_id||' page '||page); dbms_output.put_line (sqlerrm); end; end loop; end if; end loop; end;
Oracle 检测clog字段错误的SQL
最新推荐文章于 2021-05-30 20:05:07 发布