- 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.
mkdir -p /data/app/scriptsCopy all the .sql scripts into above location and set SQLPATH parameter in .bash_profile
export SQLPATH=/data/app/scriptsNow you can be in any location, start sqlplus and simply execute any .sql script
cd /tmp > start sqlplus from /tmp loc sqlplus / as sysdba SQL> @database-size.sql --> runs from $SQLPATH loc