Question: how to export data from oracle table to csv file using shell script?
Answer: SET PAGESIZE 50000 => Set this to a much bigger value. ... 
SET COLSEP "," => Setting the column separator to ",". ... 
SET LINESIZE 200 => The number of characters per line. ... 
SET FEEDBACK OFF => When a select query is executed, a statement appears at the prompt, say "25 rows selected".