- 12 Sep, 2023
- 0 Comments
- 1 Min Read
SQLPATH Environment Variable in Oracle
In this blog , we will see SQLPATH Environment Variable in Oracle.
What is SQLPATH Variable?
To execute any .sql script, we need to go to specific folder which contains .sql script, start sqlplus utility and then run the .sql script.
It will be great, if we can run any .sql script inside SQLPLUS UTILITY from any location !
SQLPATH points to a location on server which contains all the .sql scripts. Anytime you execute a .sql script without giving the script location, sqlplus will first search the script inside SQLPATH location. If the script is not available in the SQLPATH location, then sqlplus search the script in the current folder where you started sqlplus from.
Set SQLPATH Parameter
First we need to create a location which will contain all your .sql scripts.
Copy all the .sql scripts into above location and set SQLPATH parameter in .bash_profile
Now you can be in any location, start sqlplus and simply execute any .sql script
1 | mkdir -p /data/app/scripts |
1 | export SQLPATH=/data/app/scripts |
1 2 3 | cd /tmp > start sqlplus from /tmp locsqlplus / as sysdbaSQL> @database-size.sql --> runs from $SQLPATH loc |