Re: Convert Oracle data to EXCEL

From: Luggy <dgh_consulting_at_my-deja.com>
Date: Thu, 14 Dec 2000 09:28:14 GMT
Message-ID: <91a3ra$brr$1@nnrp1.deja.com>

Hi Amy.

Your easiest options are:

Use MS Query via ODBC (Data > Get External Data > Create New Query).
Install oraxcel, and use it.
Create a CSV file in Oracle. Excel can use that.

To make a CSV (option 3) for the following table...

ATABLE

COL_A   DATE
COL_B   VARCHAR2(10)
COL_C   NUMBER(5)

...you could use the following script in SQL*Plus...

------------------------cut--------------------------
set linesize 32767
set trimspool on
set termout off
set pagesize 0

spool atable.csv

select COL_A||','||COL_B||','||COL_C
from atable;

spool off
------------------------cut--------------------------

To create the above file dynamically for multiple tables, I have written a PL/SQL script. Please let me know if you'd like this (I can email it if so).

HTH, Dave Henderson.

Sent via Deja.com
http://www.deja.com/ Received on Thu Dec 14 2000 - 03:28:14 CST