select dbms_lob.substr(lo.ldtext) as text from longdescription lo 转载于:https://www.cnblogs.com/xiaoliu66007/p/8391204.html