Re: Use environment variable in SQLPlus on Windows

Matthias Langbein wrote:
> Hi all,
> 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

The normal syntax on Whinedoze is %SQLOUT%, but I didn't say this will work from within SQL*Plus.

Stick to Linux.

Gerard Received on Thu Jan 25 2007 - 14:04:47 CST