I'm using this unix script which it is fetching records in the form of csv. I have a SQL query used for this purpose. It contains below information SET PAGESIZE 5000SET COLSEP ,SET LINESIZE 2000SET FEEDBACK OFFSET NEWPAGE NONESET UNDERLINE OFFIs it due to PAGESIZE it is consuming more space?The script returns 4MB of CSV(OBTM.csv) file whereas if I'm converting the same to (OBTM.xlsx) it is 48KB.Kindly clarify my query
why csv is consuming more file size in my unix script?
shell script;solaris;ksh;database