第一种:
SELECT LENGTH(msg_content) 总长度,
msg_content,
TO_CHAR(SUBSTR(T.msg_content, 0, 4000)) "0~4000",
TO_CHAR(SUBSTR(T.msg_content, 4001, 8000)) "4001~8000",
TO_CHAR(SUBSTR(T.msg_content, 8001, 12000)) "8001~12000"
FROM his_sf_inter_msg_a T where t.receive_object_value='21720160513165604B40763551';
第二种:查出来这个字段导出为CSV文件,再查看导出文件;