Oracle's Client Tools __oracle

One. Sql*plus Client Tools

1. Download, URL: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html (click to open link)

2. Select the corresponding version of the operating system of the client, the window system as an example, need to download the following two compression packs

3. Download the two compression pack together to select the decompression

4. A instantclient_*_* folder will be generated, * is the version number, and the disk path to the folder is added to the environment variable. According to the diagram configuration,

and add oracle_home to the path.

5. Open the DOS command window, the input sqlplus-version appears as shown in the following figure, the table name is successfully installed

6. Enter Oracle's connection information to operate the Oracle database

Two. Pl/sql Developer Client Tools

1. Download the tool, the URL for https://www.allroundautomations.com/plsqldev.html (click to open the link), because the client tools need to register, so download a registration machine,

2. Click on the execution file exe, to install, in the selection of installation path, the more you prepare to install the path, can not contain Chinese and space and special symbols

3. Then click Next until the installation is successful, of course, click on the next when you can choose according to their preferences, successful click to start

4. Double-click to open, will display the registration interface, open the registration machine, fill in the generated registration information

5. After successful registration, it is shown as follows

6. Click Cancel, enter the related configuration

7. Click Tools->preferences to configure

8. Copy the Tnsnames.ora from Oracle Server installation to a directory, edit the file, and finally configure it to the environment variable

File exists path:

Copy to D-Packing directory for editing (or other directory)

To configure environment variables:

9. Open Pl/sql again develper Enter login information for landing, after the successful landing as follows

Three. Sqldeveloper Client Tools

1. Download Address: http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html (click to open link)

2. After installation can be a new connection for landing

Summary: These are three client tools to connect to Oracle servers, and do your Oracle database!