sql串连接超出225的打印方法

 

VAR Number := 1;

 

WHILE VAR <= LENGTH(L_QUERY) LOOP
          DBMS_OUTPUT.PUT_LINE(SUBSTR(L_QUERY, VAR, 200));
          VAR := VAR + 200;

END LOOP;