Re: PL/SQL and output
From: neeren <neeren_at_cyberway.com.sg>
Date: 1998/03/22
Message-ID: <3514B0CD.678E_at_cyberway.com.sg>#1/1
Date: 1998/03/22
Message-ID: <3514B0CD.678E_at_cyberway.com.sg>#1/1
Kevin Bass wrote:
>
> I have attempted to print output from a PL/SQL program into a file but
> received no results. Are there any other ways to print information (data)
> into a file without using DBMS_OUTPUT.PUT_LINE or DBMS_OUTPUT.PUT? If so,
> please send sample code.
>
> Kevin
In SQLPLUS do the following command
SET linesize 240 (or the length of the columns you are selecting)
set spool <filename>.lst
execute select
set spool off;
Received on Sun Mar 22 1998 - 00:00:00 CET