Question: How to I extract a table
in an Excel format? I want to load the table into a
spreadsheet.
Answer:
You can
also get an excel format by
selecting the rows in column-delimited format
(csv).
set heading off
set pages 0
set copsep ","
spool tablename.csv
select * from
my_table;
spool off
You can then load the resulting csv file into
an Excel spreadsheet.
spool myexcel.csv
select
col1||','||col2||','||col3
from
mytab;
spool off
