Command Line One Liner To Save Oracle Query Result In CSV File

Home › System Administration

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

Also Check Out:


The most beautiful Russian women

Strange Statues

Persian Models

Ugliest Dog in the World

More Collections

We have a lot more to share. Check out more collections.


Leave a Comment

Name
Email (Optional)
Web Site (Optional)
Comment
Type 8822 here