RE: insert data into excel

You can create a csv (comma separated values) file that Excel can read from SQL*Plus by doing the following:

set colsep ,

Steve Monaghan

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Joan Hsieh
> Sent: Thursday, August 03, 2000 1:20 PM
> To: Multiple recipients of list ORACLE-L
> Subject: insert data into excel
>
>
> Hi All,
>
> Is there any way to insert the result from a query into excel? I know a
> year ago I saw someone did that. I just have no clue how to do it.
> For example: I want to get all the tablespace used bytes insert into
> excel directly. So I can calculate the growth rate from excel monthly. I
> don't want create tables to store those data in the database.
>
> Thanks,
>
> Joan
> --
> Author: Joan Hsieh
> INET: jhsieh_at_infonet.tufts.edu
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Thu Aug 03 2000 - 11:58:10 CDT