PL/SQL Developer- Setting Path in Preferences

What is PL/SQL Developer?

Well, PL/SQL developer is like an IDE for ORACLE. You can connect PL/SQL Developer to ORACLE database and then create and compile procedures and function, create users, views,tables and much more that you do with ORACLE.

Setting the path

When you use it for the first time, you need to set the path in the Preferences. Set the following paths:

Oracle Home: This path contains the path of your database:

For example - C:\oracle\product\10.2.0\db_1

OCI Library: This contains the path of the file oci.dll in the BIN directory.

C:\oracle\product\10.2.0\db_1\BIN\oci.dll

Reopen PL/SQL developer so that the changes take place effectively.

Thats it, happy developing !!!