0
I am trying to export the result of a query in SQL PLUS to a CSV. It is working, but I want used for extraction is coming in the first lines of the CSV file, which hinders the end user. Have some command I have to add so that the query does not come together, only the result?
The command used for export:
sqlplus login/senha << EOF
set echo on
set define on
set feedback off
set serveroutput on
set arraysize 500
set verify off
set pagesize 0
set linesize 10000
ser trimspool on
set termout off
alter session set nls_date_format = 'dd/mm/yyyy hh24:mi:ss';
spool /CAMINHO_ABSOLUTO/nome_do_arquivo.csv;
SELECT * FROM EXEMPLO;
I solved the problem using a command line extractor.
– Caroline Leite