To Convert File in Xml Format

SQL>set head on feed on
SQL>spool <File name>.xls
SQL>set markup html on
SQL>@script.sql
SQL>set markup html off
SQL>spool off



Output in execl format
==========================

SET LINESIZE 4000
SET VERIFY OFF
SET FEEDBACK OFF
SET PAGESIZE 999
SET MARKUP HTML ON ENTMAP ON SPOOL ON PREFORMAT OFF
SPOOL Prod.xls
select NAME,VALUE from gv$parameter;
spool off;


SET LINESIZE 4000
SET VERIFY OFF
SET FEEDBACK OFF
SET PAGESIZE 999
SET MARKUP HTML ON ENTMAP ON SPOOL ON PREFORMAT OFF
SPOOL Prod.xls
select count(*) from aps_params order by 1;
spool off;