Re: UTL_FILE QUESTION

Richard Nield wrote:

> Hi
>
> I am trying to copy lots of records from the dbase to a UTL_FILE on the
> server. My problem lies in the number of records retrieved and the file
> name. As the file has to be imported into excel after, I have to limit the
> records in each file to < 50000.
>
> does any know if there is anyway way of using some sort of sequence
> alphabetically, as I can't use numbers in the file name?
>
> i.e filename = group||file_name
>
> where file name = AA for the 1st file
> then AB and so on
>
> or is there way of formatting the UTL_FILE in such a way as to avoid the
> Excel import wizard?
>
> Any help appreciated.
>
> Thanks
>
> Richard

I can't help you directly ... partically because I would never use UTL_FILE to do what you are doing. I'd just spool the data out of SQL*Plus using a vertical bar delimiter.

But I am fascinated ... why ... if you have so much data are you moving it to Excel? What could anyone possibly do in Excell they couldn't do in Oracle faster and better?

Thanks.

Daniel A. Morgan Received on Fri Jun 15 2001 - 13:07:34 CDT