Command Line One Liner to Save Oracle Query Result in CSV File

nohup echo -e "set colsep \n set heading off \n set linesize 3000 \n set pagesize 1000000 \n set echo off \n set feedback off \n set trimspool on \n set newpage none \n set underline off \n select * from YOUR_TABLE;" | /usr/oracle/bin/sqlplus username/password@//192.168.0.1:1521/your_sid.com > outputfile.csv &

Copyright © Ahmad Anvari