DBMS_LOB.SUBSTR (
lob_loc IN BLOB,
amount IN INTEGER := 32767,
offset IN INTEGER := 1)select dbms_lob.substr(blob_item,32767,1) as b from table1;因为无法估算其长度,只能用一个笨办法:
select dbms_lob.substr(blob_item,32767,1)||dbms_lob.substr(blob_item,32767,32767)||... as b from table1;
lob_loc IN BLOB,
amount IN INTEGER := 32767,
offset IN INTEGER := 1)select dbms_lob.substr(blob_item,32767,1) as b from table1;因为无法估算其长度,只能用一个笨办法:
select dbms_lob.substr(blob_item,32767,1)||dbms_lob.substr(blob_item,32767,32767)||... as b from table1;
用GetChuck()出错。