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

From: Alex Filonov <afilonov_at_yahoo.com>
Date: 16 Jan 2003 11:04:26 -0800
Message-ID: <336da121.0301161104.4fa1b917@posting.google.com>

rmoleveld_at_hotmail.com (Ronald) 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????
>

Is it necessary to use PL/SQL? If you can write SQL query, you can just spool output from sqlplus. Size doesn't matter. Also, you can use PL/SQL to fill in some table and then run select from this table spooling output.

> Will appreciate any help.
>
> Best regards,
>
> Ronald.
Received on Thu Jan 16 2003 - 13:04:26 CST