Well, the example is hypothetical of course. But UTL_FILE will not
work, because I need the output on the client. We have no access to the
server filesystem.
DA Morgan wrote:
> zrwcvhsosoik001_at_sneakemail.com wrote:
> > Hi,
> >
> > I need to select a set of records, and then write each record to a
> > separate file.
> > Something like this (in pseudo code). The idea is to write the salary
> > of each employee to a separate file with the name of the employee.
> >
> > FOR rec in select * from emp LOOP
> > create file with filename rec.ename
> > write rec.sal to file
> > close file
> > END LOOP
> >
> > Is this possible using SQL*Plus? Or would you recommend another tool.
> >
> > Thanks!
>
> Use UTL_FILE. You can find a demo of this in Morgan's Library at
> www.psoug.org. You will need to modify it, however, to create each
> individual file and name it.
>
> I wonder how well this has been thought out from the business
> requirements standpoint. You are going to end up with a lot of
> separate files sitting on the server (where no one should be mucking
> about) that will then need to be moved or further processed. Why not
> just go directly to whatever end result is desired?
> --
> Daniel Morgan
> University of Washington
> Puget Sound Oracle Users Group
Received on Fri Sep 08 2006 - 09:13:30 CDT
