declare
l_data varchar2(20000);
l_clob clob;
begin
select news_desc into l_clob from ehc.el_news where id='db76b159e40e4dc08cd4a73f5ee31bf7';
l_data := dbms_lob.substr( l_clob, 9500, 1 );
dbms_output.put_line( 'length = ' || length(l_data) );
dbms_output.put_line(l_data);
end;
l_data varchar2(20000);
l_clob clob;
begin
select news_desc into l_clob from ehc.el_news where id='db76b159e40e4dc08cd4a73f5ee31bf7';
l_data := dbms_lob.substr( l_clob, 9500, 1 );
dbms_output.put_line( 'length = ' || length(l_data) );
dbms_output.put_line(l_data);
end;
--select max(dbms_lob.getlength(news_desc)) from ehc.el_news
--select id from ehc.el_news where dbms_lob.getlength(news_desc)=9148;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/110321/viewspace-626969/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/110321/viewspace-626969/