设置sqlform csv时，设置标题关闭在SQLcl中不起作用

Question

我正在使用SQLcl生成csv输出。

set sqlformat csv  
set heading off  
select * from hr.employees where rownum < 10;  

"EMPLOYEE_ID","FIRST_NAME","LAST_NAME","EMAIL","PHONE_NUMBER","HIRE_DATE","JOB_ID","SALARY","COMMISSION_PCT","MANAGER_ID","DEPARTMENT_ID"  
100,"Steven","King","SKING","515.123.4567",17-JUN-03,"AD_PRES",24000,,,90  
101,"Neena","Kochhar","NKOCHHAR","515.123.4568",21-SEP-05,"AD_VP",17000,,100,90  
102,"Lex","De Haan","LDEHAAN","515.123.4569",13-JAN-01,"AD_VP",17000,,100,90  
103,"Alexander","Hunold","AHUNOLD","590.423.4567",03-JAN-06,"IT_PROG",9000,,102,60  
104,"Bruce","Ernst","BERNST","590.423.4568",21-MAY-07,"IT_PROG",6000,,103,60  

但我得到了我不想要的标题。我认为set heading off应该关闭heading（就像在SQLPlus中一样）为什么它在SQLcl中不工作。如果我清除了sql格式（设置sqlformat），那么标题就行了。它是SQLcl中的一个bug吗？

Answer 1

你不想在结果中看到标题吗？

在SQLPLUS中，您可以使用

set pagesize 0

Answer 2

使用当前版本的sqlcl（截至2017年6月30日），同时使用11g和12c数据库，效果良好：

alter session set NLS_DATE_FORMAT='DD-MON-YYYY';
set feedback off
set sqlformat csv
spool <spool loc>
SELECT <column list> FROM <table list> WHERE <where clause
ORDER BY <order by clause>;
spool off;

Answer 3

SET PAGESIZE 0

允许您在不分页的情况下运行。

set heading off

应该工作，但坏了。下一个版本将修复它...像这样

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

BARRY@orcl☘ >set sqlformat csv
BARRY@orcl☘ >set heading off
BARRY@orcl☘ >select * from demo;

1,"Barry"
2,"Lisa"
3,"Rebecca"
4,"Katie-Ellen"
BARRY@orcl☘ >