Re: Use environment variable in SQLPlus on Windows

On Jan 25, 12:04 pm, "Gerard H. Pille" <g..._at_skynet.be> wrote:
> 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.
>

I just tried it and it worked.

> Stick to Linux.

Rather stick to a real unix, but there you go.

jg

--
@home.com is bogus.
http://lists.village.virginia.edu/lists_archive/Humanist/v20/0080.html