Re: UTL_FILE QUESTION

From: Daniel A. Morgan <Daniel.Morgan_at_attws.com>
Date: Fri, 15 Jun 2001 13:32:53 -0700
Message-ID: <3B2A70F5.3037502B@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 Fri Jun 15 2001 - 15:32:53 CDT