PL/SQL Developer configuration instructions, pldeveloper

PL/SQL Developer configuration instructions, pldeveloper

PL/SQL Developer is an integrated development environment dedicated to the development of Oracle database storage program units. Nowadays, more and more business logic and application logic are turning to Oracle Server. Therefore, 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, and gives full play to the main advantages of Oracle application development.

The following test environment is windows 7 32-bit.

PL/SQL Developer green Version Download link: http://pan.baidu.com/s/1hqwDToo

Oracle9i client lite download link: http://pan.baidu.com/s/1mgL8pXu

Detailed configuration instructions:

1) decompress plsql).zip, which is a green package. You can decompress the package:

2. When the file is in the unzipped folder, plsqldev.exe is the executable program, which is unavailable for the time being and must be configured accordingly. See the following description:

3) decompress oracle9iclient. rar:

4) after decompression, double-click the installation package to install it. By default, it can only be installed on drive C:

5) after the installation is successful, an Oracle folder is added to drive C:

6) set the Path environment variable for the oracle client:

A) first copy the path where the environment variable needs to be set:

B) Right-click the computer and choose Properties> advanced system Settings> advanced> environment variables:

Add the following Path at the beginning of Path, and separate the Path with a semicolon:

7) When PL/SQL Developer is configured, a login window will pop out and be canceled. Then, a Developer interface will be jumped in (No Logon ):

8) Tools> preferences:

Oracle main directory name-> C: \ Oracle \ ora90 \ BIN

OCI library-> C: \ Oracle \ ora90 \ BIN \ oci. dll

9) The application-> OK-> re-run the software, and found that there is another option "connection as" than the previous logon interface ":

10) Add the database server information. In the tnsnames. ora configuration file, add the server information:

11) in this example, add the following content 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 on to the database server and enter the logon information:

13) operation interface after Successful Logon:

Copyright Disclaimer: This blog post is mostly prepared by myself or collected on the Internet. For more information, see the source !!