Oracle CLOB字段的截取及字符长度统计

V_SQL CLOB;
V_SQL := DBMS_LOB.SUBSTR(V_SQL,DBMS_LOB.GETLENGTH(V_SQL)-2,1) || ' IS NOT NULL';
EXECUTE IMMEDIATE V_SQL USING V_PARAM1,V_PARAM2;
COMMIT;