How do you spool to txt file?

[napstar]

I have a table in oracle 7.3 and I use SQLPLUS 8.0.6.0.0 to work with is DB.I would like to know how to spool the contents of a table to a txt file.
i tried this

spool c:\companies.tx t
SELECT
COMPANY_NO ||','||
COMPANY_NAME
FROM companies

but i keep getting:ERROR at line 1:ORA-00900: invalid SQL statement

[debasisdas]

but that should work for you.

please post what exactly you are doing.