Re: SQL*Plus Saving Environment?

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: Thu, 13 Jan 2000 13:58:00 GMT
Message-ID: <387DD9E8.519F0BC1@edcmail.cr.usgs.gov>

Instead of playing with the GLOGIN.SQL file (which affects all SQL*Plus users), why don't you create a LOGIN.SQL file which will get executed when you start SQL*Plus. In order for SQL*Plus to find the LOGIN.SQL file, you must set up the SQLPATH environment variable. In NT, it's in the registry. In Unix, it's an environment variable. Make sure that the directory that the LOGIN.SQL file resides is in the SQLPATH.

HTH,
Brian

Georg Schulte Althoff wrote:
>
> Thank you for this documentation. This is very good to save the whole
> setting.
> The only thing I'm still missing is how to execute the resulting file
> automatically
> at every start of SQL*Plus.
>
> Is there nothing like a "autoexec" at the start of SQL*Plus?
>
> Georg
Received on Thu Jan 13 2000 - 07:58:00 CST