Re: sql processing of local tables

From: arlan <arlandraca_at_yahoo.it>
Date: 27 Mar 2002 06:11:15 -0800
Message-ID: <ffda3590.0203270611.61588c52@posting.google.com>

Richard Booker <rbooker_at_21stcentury.net> wrote in message news:<3CA1B33A.F201FD6B_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.

hi,
you can write all query results in a flat file on your machine using

"SQL>spool <path\file_name.sql>
 SQL>select statement
 SQL>spool off".

if you wont formatting the output you can use the function provided by sqlplus, you can find it on all oracle handbook.

bye Received on Wed Mar 27 2002 - 08:11:15 CST