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

Good ole' dos can help here too. I use the dos pl/sql - plus33.exe which is also in with the windows pl/sql on out setup - and create the query in a text file and pipe the output. Works great but only generates fixed column width w/no delimiters

An example from a dos window...

    plus33 -s loginname/password_at_server < inscript.sql > results.out

Give it a try. I hope it helps.

Regards
Jeff Smith

In article ,
  "Ken Friday" wrote:
>
> Rene,
>
> 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.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 wrote in article
> ...
> > 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
> >
> >

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet