Re: Help, Help, Help

From: David Sisk <davesisk_at_ipass.net>
Date: 1998/12/17
Message-ID: <zM%d2.1043$kx1.1675@news.ipass.net>#1/1

Hi:

I'm not sure how you could output a tab-delimited flat file. However, outputting a comma-delimited (ie. CSV) would be very easy. You could probably do it with one SQL statement from SQL*Plus, like so:

SET HEADING OFF
SPOOL myfile.csv
SELECT column1||','||colum2||',||etc...FROM table1 WHERE..... SPOOL OFF MSExcel will open the CSV file just like a spreadsheet.

Good luck,

--
David C. Sisk
The Unofficial ORACLE on NT site
http://www.ipass.net/~davesisk/oont.htm


aziz basharyar wrote in message ...


>Hi,

>

>How can I create exportable to Excel File ("Tab Delimited Format")

>from Oracle database  using PL/SQL.

>

>Thanks

>

>Aziz

>AzizB_at_cpas.com

>AzizB_at_sprint.ca

>

>

>

Received on Thu Dec 17 1998 - 00:00:00 CST