Re: sql processing of local tables

Richard,

First, of course you can create a flat file containing results of selected data from your database. There are many ways to do that, including sql/plsql processed in sqlplus -or- output produced from data obtained via some API to Oracle, like JDBC. As far as being able to run queries against this output data, you will probably want to define new tables to hold this data and then just access the data there, as well as send it to some loval file in whatever form you wish.

Regards... Jon

Jon Armstrong (Java, C, C++, Oracle, MySQL and much more) [ 24/7 Solutions - Any problem, on any platform, any time. ]

"Richard Booker" <rbooker_at_21stcentury.net> wrote in message news:3CA1B30C.B0D59534_at_21stcentury.net...
> Is it possible to do SELECT statements on the server and write result
> tables to my C: drive and then use SQL to further process them there?
>
> I'm brand new to Oracle and SQL.
>
> I need to produce a flat file (ASCII fixed) for another agency from an
> Oracle 8i database residing on a web server in our DMZ.
>
> Because the format of the flat file is so different from our Oracle
> tables, I will need to do a quite a bit of massaging of the data.
>
> Any help to point me in the right direction is appreciated.
>
Received on Wed Mar 27 2002 - 23:16:10 CET