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
Method/Step
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.
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:
Copy the network folder from the product\11.2.0\dbhome_1\ in the Oracle installation directory to your client folder.
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
Here we start setting environment variables, just like the Java setting environment variables, right-click on the computer-Properties-Advanced settings-environment variables.
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.
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;
Create a new Nls_lang environment variable with the input value: simplified Chinese_china. Zhs16gbk
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)