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

Home -> Community -> Usenet -> c.d.o.misc -> Output a variable to screen/file

Output a variable to screen/file

From: Fabian Bakker <fbakke_at_ctp.com>
Date: Tue, 08 Dec 1998 11:44:55 +0100
Message-ID: <366D0327.EF106B35@ctp.com>


Hello,

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

Thanx

DECLARE
   l_var1 VARCHAR2(2000);

BEGIN       l_var1 := 'This line must be in my file'; Received on Tue Dec 08 1998 - 04:44:55 CST

Original text of this message

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