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: Can you define environment variables on Windows NT 4.0?

Re: Can you define environment variables on Windows NT 4.0?

From: Michael Pelzelmeyer <mikepelz_at_netway.at>
Date: 1998/02/08
Message-ID: <34DDCCD3.61CD@netway.at>#1/1

And to use the environment variables in sql-plus enclose them in '%'. e.g. > spool %logfile_name%

Michael

Mark Landa wrote:
>
> Environment variables can be set at a DOS command prompt. For instance,
> to see what SID you current have set type: echo %ORACLE_SID%
> To set and environment variable for that session use:
> SET ORACLE_SID=dev. If you want a more permanent solution
> then set the variables in manner described below.
>
> M.Landa
>
> Sarah Sikes wrote:
>
> > "Roger Jackson" <rjackson_at_wire.net.au> wrote:
> >
> > >Hi all,
> > >
> > >In the UNIX environment when executing SQL statements you can specify
> > >environment variables such as $ORACLE_HOME as below so you don't have to
> > >type in the whole path.
> > >
> > >eg. SQL>@$ORACLE_HOME/catproc.sql
> > >
> > >Can you create environment variables in Windows NT?
> > >
> > <SNIP>
> >
> > Yes you can...
> >
> > Settings > Control Panel > System > Environment
Received on Sun Feb 08 1998 - 00:00:00 CST

Original text of this message

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