Re: Creating an ASCII flat-file from SQL-query results

Rene,

[Quoted] Take a look at the utl_file package supplied by Oracle. This provides file i/o functions similar to C (e.g. print, printf). Your DBA will have to identify the appropriate directories in the init<sid>.ora file before it will work.

Otherwise (assuming you're in SQL*Plus) you can fool around with dbms_output or simple spooling.

Ken F.

René Schutte <Rene_at_webhost.co.za> wrote in article <34A408B0.E11154E_at_webhost.co.za>...
> Hi there,
>
> (Season's greetings:)
>
> I need to get the results of a PL/SQL query:
> cursor c1 is
> select * from payments;
> d_c1 c1%rowtype;
>
> to be placed in an ASCII delimited "flat" file. Is there an easy way to
> do this. I am running Oracle 8.0.3, with Web Request Broker 3.
>
> Any help would really be appreciated.
>
> thanks&bye4now
> Rene
>
>
  Received on Mon Dec 29 1997 - 00:00:00 CET