Re: Making a (big) flat file in plsql.

From: FC <flavio_at_tin.it>
Date: Wed, 15 Jan 2003 13:44:15 GMT
Message-ID: <PAdV9.45166$AA2.2014625@news2.tin.it>

What about redirecting the output to a file ?

sqlplus user/pwd_at_somedb @writebigfile.sql > hugefile.txt

Bye,
Flavio

"Ronald" <rmoleveld_at_hotmail.com> wrote in message news:8e80cdcb.0301150537.2fe4228e_at_posting.google.com...
> Hi all,
>
> Known problem for a lot of you I suppose.
> Need to make a flat file in plsql. This goes beyond the 1000000 of
> serveroutput and I don't have utl_file (what can be used for this I
> understand).
>
> Need to retrieve thousands of record and put them in a flat file,
> normal recordlenght, about 200.
> No need to display them on screen as long they get in the file.
> Any solution for this????
>
> Will appreciate any help.
>
> Best regards,
>
> Ronald.
Received on Wed Jan 15 2003 - 07:44:15 CST