每次一行,多行就多来几次,另外有字符数限制。请参照下例 -- 处理超过255个字符的行的输出 -- PROCEDURE dealline(initStr VARCHAR2) IS lineCount INTEGER; i INTEGER; BEGIN lineCount := ceil(length(initStr)/255); FOR i IN 1..lineCount LOOP dbms_output.put_line(substr(initStr,1 + 255 * (i - 1),255)); END LOOP; END dealline;
-- 处理超过255个字符的行的输出
--
PROCEDURE dealline(initStr VARCHAR2) IS
lineCount INTEGER;
i INTEGER;
BEGIN
lineCount := ceil(length(initStr)/255);
FOR i IN 1..lineCount LOOP
dbms_output.put_line(substr(initStr,1 + 255 * (i - 1),255));
END LOOP;
END dealline;