Thanks for the thought, but I'd really like to run something
from apps, i.e. a report or similar...
Noah
--
Noah Arc
Remove ".spam.begone"
Anthony Hogan <anon_at_spain.es> wrote in message
news:3BD01FFF.8C4192AA_at_spain.es...
> Hi Noah,
> Use spool from a sqlplus session.
>
> SQL> set hea off;
> SQL> spool c:\dba\test.csv;
> SQL> select col1 || ',' || col2 || ',' || etc..
> 2 from table;
> SQL> spool off;
>
> You will need to clean the top & end lines of the csv
>
> hth
> Anthony Hogan
> hogananthony_at_hotmail.com
>
> Noah Arc wrote:
> >
> > Is there any way of creating delimited output in a file
> > on the client's PC from the server? I can create CSVs
> > using, say, Reports, but am unsure of a way of
> > transferring the file from the server to the client
> > (across OSes).
> >
> > We have Oracle Apps, so can't use anything
> > client-based, such as Access or Excel; that'd be
> > too easy! I'm looking for a server-based solution
> > (which I'm currently doubtful that there is).
> >
> > Thanks for any thoughts.
> > --
> > Noah Arc
> > Remove ".spam.begone"
Received on Fri Oct 19 2001 - 08:27:41 CDT
