1- write sql that will get data to csv

file name: allsql.sql

SET PAGESIZE 0;SET LINESIZE 5000;SET TRIMSPOOL ON;SET TERMOUT OFF;SET TIMING OFF;SET FEEDBACK OFF;spool file.csv;# there are sql sentences here end with ;# e.g.:select * from u;spool off;quit;

2- login sql, execute sql, write to csv file and add headers

@echo offsqlplus account/password@address @allsql.sql:: generator the  csv fileecho FIELD1,FIELD2>INDEX.csvtype index.csv >> INDEX.csvdel index.csv