Hello,
I try to generate a CSV file from sqlplus 12.2, with the new instruction : set markup csv on delimiter ';'
set echo off
set feedback off
set term off
set timing off
set embedded on
set trimspool on
set underline off
set LINESIZE 32000
set markup csv on delimiter ';'
Spool PS_H_ACTIFLEET_BATCH.csv
SELECT
to_number(to_char(sysdate,'YYYY')) as YEAR,
to_number(to_char(sysdate,'MM')) as MONTH,
etc...
It works but I have a blank line on top of the file :(
If i do set heading off, it removes the blank row but also the header row....
Do you have a solution to remove this blank row on top of the CSV file with SQLPLUS in this context ?
Thank you...