DBMS_LOB.GETLENGTH:
例如:SELECT id FROM t_attachment where type = 'WORD' and DBMS_LOB.GETLENGTH(contexts)>12 and tempath is null and ROWNUM<=1000
DBMS_LOB.GETLENGTH:
例如:SELECT id FROM t_attachment where type = 'WORD' and DBMS_LOB.GETLENGTH(contexts)>12 and tempath is null and ROWNUM<=1000