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.