Use environment variable in SQLPlus on Windows

From: Matthias Langbein <matthias_langbein_at_web.de>
Date: Thu, 25 Jan 2007 20:47:27 +0100
Message-ID: <7a2ir2hioo1qq63i5tktovg97gcd98acq8_at_4ax.com>

Hi all,
[Quoted] [Quoted] is there a way to use a environment variable in SQL PLus? On Linux I can use the $, but on Windows this doesn't work.

Example:

C:\> SET SQLOUT=C:\LOG\
C:\> SQLPLUS scott/tiger

SQL> SPOOL ${SQLOUT}TEST.LOG
SQL> PROMPT A
A
SQL> SPOOL OFF
SQL> EXIT This saves me the Log file in the current directory with the file name ${SQLOUT}TEST.LOG, but I want the log file with the name TEST.LOG stored in the directore C:\LOG

Any help??

THX, Langi Received on Thu Jan 25 2007 - 20:47:27 CET