Installation and configuration of the Sqlplus

Sqlplus:oracle Company provides tools for users to operate Oracle databases.

Install the required packages: 1.oracle client 2.sqlplus Tools

Official http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

Select the corresponding version and the version number to match

2. Unzip two packages to place all files of two packages in the same directory

3. Configuring the Sqlplus configuration file

Create a new Network/admin directory under the directory in step 2 and create a new file Tnsnames.ora

The 4.tnsnames.ora format is as follows

5. You can set the current directory to join the PATH environment variable to facilitate the operating system to find Sqlplus.exe running program

6. If no 5 can switch to the new directory

Complete.

Sqlplus is a client of Oracle's raw data operations, and the format of this command line is very logical, and if used frequently, it deepens the understanding of the database.

Installation and configuration of the Sqlplus