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".