Saving Query output in a file

Database
Enthusiast

Saving Query output in a file

Hi,

I want to execute a query and want to save the output including column header in a xls file. i.e. something like colheader, spool etc. of Oracle.
In the result set one of the column is large object like byte-2147483647.

Can any please provide the syntax for doing that. Please also provide where the query should be executed means equivalent to sqlplus of Oracle.

Thanks in advance,
Koushik Chandra