oracle 打印长sql到控制台

之前用过一个，用程序写的，忘记了，mark一个最简单的

DBMS_OUTPUT.put_line(length(v_sql));
DBMS_OUTPUT.put_line(subStr(v_sql,1,900));
DBMS_OUTPUT.put_line(subStr(v_sql,901,900));
DBMS_OUTPUT.put_line(subStr(v_sql,1801,900));
DBMS_OUTPUT.put_line(subStr(v_sql,2701,900));
DBMS_OUTPUT.put_line(subStr(v_sql,3601,900));
DBMS_OUTPUT.put_line(subStr(v_sql,4501,900));
DBMS_OUTPUT.put_line(subStr(v_sql,5401,900));
DBMS_OUTPUT.put_line(subStr(v_sql,6301,900));
DBMS_OUTPUT.put_line(subStr(v_sql,7201,900));
DBMS_OUTPUT.put_line(subStr(v_sql,8101,900));
DBMS_OUTPUT.put_line(subStr(v_sql,9001,900));
DBMS_OUTPUT.put_line(subStr(v_sql,9901));