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

Re: Output a variable to screen/file

From: Rolf Hauck <Rolf.Hauck_at_datenrevision.de>
Date: Wed, 09 Dec 1998 09:44:44 +0100
Message-ID: <366E387C.8FB03464@datenrevision.de>


Hi, Fabian,
take a loook at the documentation of the package utl_file.

Rolf

Fabian Bakker schrieb:
>
> 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 Wed Dec 09 1998 - 02:44:44 CST

Original text of this message

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