Using Sqlplus in Instantclient

Following the "PL/SQL Developer Installation", another requirement was found, and because of the habit of using sqlplus, there was no way to directly use Sqlplus in addition to installing Oracle client. After tossing and finding the http://dldx.csdn.net/fd.php?i=734377271495498&s=0da1949af5bd8fef941acc56ffc86593, you can download the Sqlplus plugin, After downloading, unzip it and put it into the instantclient extract directory, then add the Instantclient directory to the PATH environment variable.

You can take care of the environment variables in the PL/SQL Developer installation when you are done with the above, or if you encounter character set problems. Here it is important to record how batches are used.

In the experiment, I was extracting the instantclient into the PL/SQL Developer installation path, so I created the batch file Sqlplus.bat under the PL/SQL Developer installation path, and wrote the environment variable settings:

Set nls_lang=simplified CHINESE.ZHS16GBK

In order to call Sqlplus.exe correctly, and to meet the requirements of subsequent greening, using%~dp0 to get the current path and stitching, and because there are spaces in the PL/SQL Developer installation path, the full code is:

"%~dp0" Instantclient\sqlplus.exe

So far, can normally be called in cmd, but there is no way to follow the sqlplus username/[email protected]/sid way to call, add parameters after not recognized, need further improvement, Allows Sqlplus.exe to receive parameters. The improved code is as follows:

%

After this processing, the test can be used normally, and then the PATH environment variable instantclient to the PL/SQL Developer installation path, you can directly use the familiar sqlplus.

For the sake of convenience, you can also directly delete the path of instantclient, and then directly in the System32 path to establish a sqlplus.bat shortcut, the same can be used normally sqlplus.

Using Sqlplus in Instantclient