Set the sqlplus path-sqlplus will directly read the file in the specified path

When executing some scripts in sqlplus, It is troublesome to specify the script location each time. Therefore, you can set the sqlplus path and place the script to be executed under the configured path, execute the script in sqlplus without specifying the location of the script.

The following describes how to set the sqlplus path:

Open my computer-properties-advanced-Environment Variables

Add the sqlplus variable to the system variable with the value D: \ oracle \ product \ 10.2.0 \ db_1 \ sqlplus (I will place this script in the path), as shown below: