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 -> Output a variable to screen/file

Output a variable to screen/file

From: Fabian Bakker <fbakke_at_ctp.com>
Date: Tue, 08 Dec 1998 15:56:21 +0100
Message-ID: <366D3E15.9D5C6ACE@ctp.com>


Hello,

Following is a pl / sql script example. I need to output the variable l_var1 to a file. How can I do that ? (spooling / print / show / print / refcursor??)

Thanx

DECLARE
   l_var1 VARCHAR2(2000);

BEGIN

      l_var1 := 'This line must be in my file';
     print l_var1;

END; Received on Tue Dec 08 1998 - 08:56:21 CST

Original text of this message

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