var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: some environmental variable in SQL*Plus
I need to spool rows from a select statement to a text file.
What parameters in SQL*PLUS should I set if I
1) do not want to see the sql> prompts in the text file
sql> select col1, col2 from table1;
sql> spool off
2) set heading off, I get an extra line as the first line in my text file. How do I get rid of the extra line?
Any advice greatly appreciated.
try feedback off as well and you will see the net data only