Re: UTL_FILE: Excel

Many thanks for your message.

 I have tried SQL*XL. It was too slow in retrieving data for our needs.....the report I am working on at present produces about 20 files, many of them with 50000 results. Using SQL*XL took more than an hour to produce one file. The current method, using csv files creates all the files in (atmost) 40 minutes.

 regards

          Richard

Gerrit-Jan Linker <gjlinker_at_oraxcel.com> wrote in message news:9iq8vr$ms$1_at_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 - 19:23:35 CDT