Re: UTL_FILE QUESTION

 ..the excel files are put on Cd and posted to the clients (the group) who, I can only assume, do not have oracle. Please tell me more about this bar delimiter....

Daniel A. Morgan <Daniel.Morgan_at_attws.com> wrote in message news:3B2A4EE6.CEF08CD2_at_attws.com...
> 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:34:42 CDT