Re: How to set SQLPATH on NT for the SQLPLUS GUI

From: M.Balaji <muni_balaji_at_yahoo.com>
Date: 9 Jul 2002 18:09:11 -0700
Message-ID: <3ce48062.0207091709.71dcebe7@posting.google.com>

rgaffuri_at_cox.net (Ryan Gaffuri) wrote in message news:<1efdad5b.0207091048.7929e534_at_posting.google.com>...
> I have a book in front of me that tells me to right click on my
> computer and go to properties. Then click on the advanced tab.
>
> I dont have an advanced tab? The goal is to add a new Environment
> Variable.
>
> Does anyone know how to do this on NT 4.0?

Hi,
Right Click on My Computer, select Properties and it will come with a dialog box with 6 tab pages, select the tab page "ENVIRONMENT" and in user variable section enter SQLPATH in variable column and directory name you have the sql files to be executed like this c:\balaji\work. Click on Apply and press ok.Restart your pc. After restarting , login into sqlplus and in the sql prompt type @show_free_space.sql (my example) and you can see the file is getting executed.

Thanks and Regards
M.Balaji Received on Tue Jul 09 2002 - 20:09:11 CDT