Re: get data from oracle into Excel or Lotus 123
From: Joe Enduser <firstname.lastname_at_ab.com>
Date: 1995/10/31
Message-ID: <47664k$j55_at_news1.cle.ab.com>#1/1
Date: 1995/10/31
Message-ID: <47664k$j55_at_news1.cle.ab.com>#1/1
Spool you query output into a flat file comma ot TAB delimited:
sqlplus> spool output_file.lst
sqlplus> select col1,',',col2,',',col3,',' ...
from your_table
sqlplus> spool off
this will write you data into a output_file.lst comma delimited. then load output_file.lst into Excel.
or
If you have Oracle data query, you can save your query output to
Excel format file.
Hope this helps.
Raghid Ajamoughli
ajamough_at_cle.ab.com
Received on Tue Oct 31 1995 - 00:00:00 CET