Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL How to output to file - beginner

Re: PL/SQL How to output to file - beginner

From: Desmond Chan <kychan_at_netvigator.com>
Date: 1997/12/02
Message-ID: <3483CEF8.9A0BD0C9@netvigator.com>#1/1 







    
  
  1.   set serverout on in sqlplus
  
  2.   spool <file>
  
  3.   use the DBMS_OUTPUT package to display the text in your PL/SQL
program
  
  4.   spool off
  
  5.   all text will output in the <file>






Desmond





Me wrote:



> I'm a beginner using PL/SQL and I can't figure out how to print

> output from the database to a file.

Received on Tue Dec 02 1997 - 00:00:00 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US