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 5000 SET COLSEP "," SET LINESIZE 2000 SET FEEDBACK OFF SET NEWPAGE NONE SET UNDERLINE OFF
Is 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