Re: UTL_FILE QUESTION

 Thanks for that. Our clients need all the rows from the tables, as they use the data to bill their clients....

 I will try the |, although it is the wizard I am trying to avoid due to the rows limit set by the wizard.

Daniel A. Morgan <Daniel.Morgan_at_attws.com> wrote in message news:3B2A70F5.3037502B_at_attws.com...
> > ..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....
>
> Well that explains it. But usually one sends the clients metadata
 (summaries)
> rather than the detail rows.
>
> Anyway here's what you can do.
>
> SELECT field1, '|', field2, '|', field3
> FROM sometable
> WHERE blah, blah
> AND blah;
>
> You will get a file that can be easily read by Excell and doesn't have the
> liability of comma delimited files that there may be commas in the data.
>
> In Excell just do FILE / OPEN and point to the file. Excell will do the
 rest by
> popping up a wizard.
>
> Daniel A. Morgan
>
Received on Sat Jul 21 2001 - 16:22:21 CDT