spooling question

[leonard905]

Hi,
Can you spool data from Oracle running on Unix. if yes, is it simply as issuing the spool command? If no, how do you use the spool command on unix. please be detailed in your response.


Thanks in advance
Leonard905

[marist89]

Inside your .sql script, just issue spool with the filename and then spool off when you are done. For example:

spool xyz.txt
select * from xyz
/
spool off

[leonard905]

so just like oracle on NT. Spool filename and then spool off.

Thanks.

[badrinathn]

sql plus command are the same, which ever platform your database resides on.

It works fine with both windows and unix

Badrinath.

[marist89]

Originally posted by leonard905
so just like oracle on NT. Spool filename and then spool off.

Thanks.

Yup, that's it!