PL/SQL Developer installation details (32-bit client-free installation version)

PL/SQL Developer is an integrated development environment that specializes in developing applications for Oracle databases. PL/SQL is also a programming language called the procedural SQL language (procedural language/sql). PL/SQL is an extension of the Oracle database to the statement. In the use of ordinary SQL statements to add the characteristics of the programming language, so PL-SQL to the data Operations and query statements organized in the PL/SQL code of the process unit, through logical judgment, loop and other operations to achieve complex functions or calculations.

Tools/Materials

• PL/SQL Developer

• 32-Bit free client Installation

Method/Step

2. Tool preparation I will not introduce you here, Baidu resources so much, we should all be able to find, ready tools to see this experience.

   First, unzip your Oracle client. , and install the PL/SQL developer software.

4. Copy your extracted Oracle client to the product directory under your Oracle's installation directory.

   After copying your directory structure should be given as shown:

6. Copy the network folder from the product\11.2.0\dbhome_1\ in the Oracle installation directory to your client folder.

8. The above work is done after the open your PL/ sql Developer software, to the landing interface is click Cancel, and then into the software work interface, in perference (tool)->connection (preferences) The OCI Library (OCI) and Oracle_home (Oracle home directory) are set up inside.

   The home directory setting is the directory where your clients are located for example: E:\app\QIANG\product\instantclient_12_1

   OCI set to E:\app\QIANG\product\instantclient_12_1\Oci.dll

10. Here we start setting environment variables, just like the Java setting environment variables, right-click on the computer-Properties-Advanced settings-environment variables.

12. In the path directory, enter the directory where your client is located: for example, E:\app\QIANG\product\instantclient_12_1;

    It is important to note that if you have path in the user environment variable in your environment variable, the path above will also be entered accordingly.

14. Create a new tns_admin environment variable with the value of the directory where the client resides, such as E:\app\QIANG\product\instantclient_12_1;

16. Create a new Nls_lang environment variable with the input value: simplified Chinese_china. Zhs16gbk

18. OK, make sure your Oracle service is turned on, enter your username and password to log in.

PL/SQL Developer installation details (32-bit client-free installation version)