I want to write the output of the sql statement into a text file. for that i am doing some thing like this,
set head off
then, it is creating a file but not writing anything.
if i comment the line 'spool off', it is working fine.
can anyone have a clue.
thanks in advance.