oracle 在 SQLPlus 中使用 SPOOL 时显示数据行之间的空白行
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/20389770/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
blanks lines in between data rows show up when using SPOOL in SQLPlus
提问by lightweight
I'm trying to spool a large query in sqlplus but for some reason, I see 2 blank lines every 558 rows to be exact.
我正在尝试在 sqlplus 中假脱机一个大型查询，但由于某种原因，我看到每 558 行有 2 个空行，准确地说。
I spool as such:
我这样绕线机：
SET TERMOUT OFF
SET ECHO OFF
SET LINES 1000
SET FEEDBACK off
SET HEADING OFF
SET ARRAYSIZE 10000
SET NEWPAGE NONE
SET PAGESIZE 0
SET TRIMSPOOL ON
Spool D:\IPORT15.csv
select query
Spool OFF;
EXIT
I thought SET NEWPAGE was supposed to take care of that??
我认为 SET NEWPAGE 应该处理那个？？
回答by lightweight
I was able to resolve this by setting: "SET PAGES 0"
我能够通过设置来解决这个问题：“SET PAGES 0”
