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;

 

posted @ 2023-05-06 16:54  Ayumie  阅读(705)  评论(0编辑  收藏  举报