I'm trying to get data in output file from sqlplus but it doesn't show me headers. Could anybody help me please? Thanks
sqlplus -s /nolog <<EOF | egrep -v connected > data.csv
connect us/pas@sid
set feedback off
set heading on
set wrap off
set pagesize 50000
set linesize 3000
set pages 0
select job from try_table;
EOF
Remove this line, it should work.
set pages 0
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With