How To Set SQL Default Execution Directory
I have a one question that keep borthering me everytime I try to execute oracle sql script from command prompt, I have to enter the /. If there any way to set the default sql script execution directory so that I only need to enter the sql script name from the command prompt?
example steps which I current encountered:
a. open cmd prompt, the default dos prompt directory is set to c:\
b. type f:\oracle\iss\script\abc.sql
I would like to improve the environment such that I can do the following:
a. open cmd prompt, the default dos prompt directory is set to c:\
b. type abc.sql
<< the environment will know to go to f:\oracle\iss\script\ and look for the script and execute>>
note: I do not want to set f:\oracle\iss\script\ as either the environment variable or one of the search path.
Appreciate for advise.
Thanks