📋Steps in this guide1/2

SQLPATH Environment Variable in Oracle

In this blog , we will see SQLPATH Environment Variable in Oracle.

oracle configurationintermediate

by OracleDba

14 views

Overview

In this blog , we will see SQLPATH Environment Variable in Oracle. 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.

Code/Command (click line numbers to comment):

1
2
3

mkdir -p /data/app/scripts

export SQLPATH=/data/app/scripts

Section 2

Code/Command (click line numbers to comment):

1
2
3

cd /tmp > start sqlplus from /tmp loc
sqlplus / as sysdba
SQL> @database-size.sql --> runs from $SQLPATH loc

Comments (0)

Please to add comments

No comments yet. Be the first to comment!