Re: How to out to flat file from PL/SQL
From: Matt B. <gtimatt_at_home.com>
Date: Wed, 04 Jul 2001 05:59:34 GMT
Message-ID: <ahy07.11259$5Z5.3499162_at_news1.elcjn1.sdca.home.com>
Date: Wed, 04 Jul 2001 05:59:34 GMT
Message-ID: <ahy07.11259$5Z5.3499162_at_news1.elcjn1.sdca.home.com>
"pankaj" <pankaj.patel_at_ladbrokes.com> wrote in message
news:3b41fa0d$1_5_at_Newsfeeds.com...
> Hi All,
>
> Oracle 8i(8.1.6)
> Sun Solaris 7
>
> I am a newbie to Oracle and PL/SQL. I have a question :-
>
>
> How can I use PL/SQL to output a column to a flat file ? I seem to hit a
> limit to do with
>
> SET SERVEROUTPUT ON SIZE 100000;
>
> TIA
>
> Pankaj :-)
Grab a reference book and use the UTL_FILE package (it's for file i/o).
-Matt Received on Wed Jul 04 2001 - 07:59:34 CEST