PL/SQL Developer Configuration usage Instructions

PL/SQL Developer is an integrated development environment designed specifically for the development of Oracle Database storage program units. Now that more and more business logic and application logic has shifted to Oracle Server, PL/SQL programming has become an important part of the entire development process. PL/SQL developer focuses on ease of use, code quality, and productivity, giving full play to the key benefits of Oracle application development.

The following test environment is Windows 7 32-bit.

PL/SQL Developer Green Edition download Link: Http://pan.baidu.com/s/1hqwDToo

Oracle9i Client Lite Download Link: http://pan.baidu.com/s/1mgL8pXu

Detailed Configuration instructions:

1) Unzip the plsqldeveloper.zip, this is green package, decompression can be used:

2) into the unpacked folder, Plsqldev.exe is its executable program, temporarily can not use, but also the corresponding configuration, see the following introduction:

3) Unzip the Oracle9i client lite. RAR:

4) After decompression, double-click the installation package installed, the default can only be installed on the C drive:

5) The installation is successful, and the C-drive has an Oracle folder:

6) Set the PATH environment variable to the Oracle client:

A) first copy the path where the environment variables need to be set:

b) Environment variables, advanced system settings, properties--right-click Computer

Path begins with a semicolon-delimited path and path:

7) Configure PL/SQL Developer, Open will jump out of a login window, cancel, and then jump into a Developer interface (no login):

8) tools, Preferences:

Oracle Home Directory name- C:\Oracle\ora90\BIN

C:\Oracle\ora90\BIN\oci.dll , OCI Library

9) Application-----re-run the software, found more than the previous login interface an option " Connect as ":

10) Add the database server information, in the Tnsnames.ora configuration file, add the server information:

11) In this example, add the following at the end of Tnsnames.ora:

ORA90 =  (DESCRIPTION = (    address_list = (      ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.161.90) (PORT = 1521    ))    (Connect_data =      (service_name = ora11)    )  )

12) Log in to the database server and fill in the login information:

13) The user interface after successful login:

Copyright NOTICE: This blog post, mostly I compiled, or in the network collection, reproduced please indicate the source!!

PL/SQL Developer Configuration usage Instructions