Re: UTL_FILE: Excel

From: Gerrit-Jan Linker <gjlinker_at_oraxcel.com>
Date: Sat, 14 Jul 2001 21:12:25 +0100
Message-ID: <9iq8vr$ms$1@neptunium.btinternet.com>

Hi,

Consider using SQL*XL to fetch the data straight into Excel instead of in a csv first. There is are options in SQL*XL to be explicit about the format of the output. For example, if you wanted the empno's to be displayed as 8 digits you could execute:

column empno format '00000000';
select empno, ename, sal from emp;

Have a look at SQL*XL at www.oraxcel.com

Oh, the functionality you require is available in the FREE SQL*XL LITE!

--
Gerrit-Jan Linker
SQL*XL: addin for Excel for easy access to Oracle databases
http://www.oraxcel.com


"Richard Nield" <richard.nield_at_ntlworld.com> wrote in message
news:khJ27.14834$WS4.2363416_at_news6-win.server.ntlworld.com...


>

>  Hi

>

>  I am using PL/SQL to transfer  large amount of data to .csv fil on the

> UTL_FILE.  I would like to alter the defalt size of the Excel

> coolumns......can any one help?

>

>  Many thanks

>

>  Richard

>

>

Received on Sat Jul 14 2001 - 15:12:25 CDT