I have scripts that I run in Oracle SQL Developer and then export the result to my pc as a csv. I now started using sqlplus with a .bat to run my scripts and spool the result to my pc. But I noticed that the export from sqlplus is twice as large as the export file from SQL Developer. The contents/result of the files are exactly the same. Here are my sql file called oracle_sql.sql
set embedded on; set pagesize 0; set colsep ','; set echo off; set feedback off; set linesize 1000; set trimspool on; set headsep off; set termout off; set heading on; set und off; spool mytable.csv select item, item_desc from mytable; spool off
here are my .bat file code
@echo off sqlplus jasons/jasons@localhost @oracle_sql.sql
Do I need to have an extra setting in my sql file that I am not aware off?