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

Source: Internet
Author: User

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
  1. 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.

  2. 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:

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

  4. 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

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

  6. 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.

  7. 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;

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

  9. 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)

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.