SQL Developer


Set heading off is not working in SQLcl when set sqlformat csv


I am generating a csv output using SQLcl.  
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
 But I am getting the heading which I don't want. I imagine set heading off should turn off the heading (as it does in SQLPlus) why it's not working in SQLcl. If I clear the sql formatting (set sqlformat) then heading off works. Is it a bug in SQLcl? -Sabya
Correct the SET SQLFORMAT, or export formatters bypass any of the SQL*Plus report formatting settings. 
Thanks Jeff. Is it a bug? May I ask if there is any plan to fix it. In my project one consultant has advised to use SQLPLUS to generate csv and text files using. But I am thinking to propose SQLcl (because I am quite impressed by it). But I am not sure how to eliminate the headers (which can be done in SQLPLUS easily)
not a bug, it's working as intended do you have one batch of data per csv file? if so, just nuke the first line of your file. you can probably do this as a new command using the SCRIPT/js stuff

Related Links

Other Users filter loses the list
Upgrade problem. Connection lost.
Compile for Debug Results in "Error: No more data to read from socket"
Problems Generating Data Move Scripts in v1.5.1
Oracle SQL Developer 1.5.1
User define reports - Columns tab
Worksheet hang -> SQLDeveloper Hang.
Failed to disable constraints
Code Insight Problem ?
Constraint on Views
How can I see privileges of current user?
Remote Debugger Not Stopping on Break Point
Can't download sql developer
CVS integration
Script with parameter and string concatenate (sqlplus and plsql-developer)
How to disable type ahead feature?

Categories

ORACLE DEV
Sample Code
Data Warehousing
TopLink/JPA
E-Commerce (iStore)
Discrete Manufacturing
Calendar
Communications and Media
Calendar SDK
Real-Time Collaboratio...
Email SDK
BI Publisher
Workspaces
MapViewer
Web Access Client
Developer Suite (Korean)
JSP (Korean)
Install (Korean)
ODBC (Korean)
LCM: Maintenance Wizard
Enterprise Pack for Ec...
Performance Management...
CRM On Demand Analytic...
WebCenter - Interaction
Data Service Integrator
weblogic.developer.int...
weblogic.developer.int...
weblogic.developer.int...
Self-Service
weblogic.developer.int...
weblogic.developer.int...
Pages
应用软件
Primavera Contractor
Evolve
Primavera Earned Value...
Smart View
存档论坛
小憩一会
广州 User Group
Oracle WebLogic Commun...
Exadata
Primavera EVM User Com...
Java APIs
Conventional & Interru...
Sun Java System Identi...
Java Programming [Arch...
ONE Portal Server 3
Oracle Developer Suite...
CRM On Demand Marketing
Mobile Services Archit...
ADF Mobile Preview
Customer Advisory Board
Oracle Coherence (MOSC...
VirtualBox
Engineered Systems
Throwback Thursday
Road to Revenue Tour
Eloqua Users with Orac...
Oracle Compute Cloud S...
Local Eloqua User Groups
Eloqua 10 Product Docu...
Pune People
SQL
Systems Track
Oracle Process Cloud S...
OKM
Oracle and TCS Initiat...
Colombia
Oracle Supply Chain Ma...
Topliners Tips and Tricks
Process Manufacturing
LWUIT
SouJava Campinas JUG
Ventana/Roche
电子商务套件
Oracle Database Cloud ...
Sites Cloud Service (SCS)
OTN at Oracle OpenWorld
Oracle SOA Suite 12c: ...
Brasil
Uruguay
Java Microservices
Tajikistan Oracle User...
Fusion Middleware Arch...
EPM System Management ...
Tuxedo (Chinese)
历史的天空
JavaServer Faces
Sun Management Center
Technical
Oracle Financials Clou...
Argentina
Forms Gruppe

Resources

Encrypt Message