In this article, we will discuss the PL SQL developer installation. PL/SQL is not a standalone programming language. It is a tool inside the Oracle programming environment.
If you missed the previous topic of this tutorial, then please click here.
Let’s get start….
At first, we need to install Oracle in our system.
This document of environment setup is based on:
- ORACLE 11g,12c
- PL SQL Developer 10.x
Some visual tools to working with Oracle
While SQLServer or MySQL has a download package, in which after you install it, a visual tool is available, after installing Oracle, we need to install another additional visual tool. But it has a variety of choices. Based on my experience, I think that PL/SQL Developer is the best Oracle PL/SQL tool. However, we still look at some other choices:
Oracle SQL Developer
Oracle also provides an Oracle SQL Developer visual tool for free, and you can download it at from Oracle official site click here
Set Environment Variables for oracle
In this section, you have set your environment variable on your PC.
Note: this installation article is only for Windows’s laptop/ desktops.
(My Computer–>Properties–>Advanced system settings –>Environment Variables)
In this step, we have to fill the positions of variable name and value.
Variable Value= D:\Oracle_12c\client\sysops\product\12.2.0\client_1
Variable Value= D:\Oracle_12c\client\sysops\product\12.2.0\client_1\bin
Now we are proceeding for PL/SQL installation and path setup. This is commercial software. Compared with other software, it is the best one.
You can download the PL/SQL Developer tool from here mentioned link: Click
Here we installing the software.
Installing PL/SQL Developer
After the installation process, we see the pop up of Oracle logon where you have to put our username and password.
Open the PL/SQL Developer app:
Click OK and then you get an error message:
Do not worry about it. Click OK to return. Then click Cancel.
PL/SQL Developer opened, but you can’t use.
You need to configure the location of the OCI.DLL file. Make sure you have installed the Oracle Client. This is the Oracle Client folder that you have installed.
Now setting the preference with the path: (Tools–>Preferences)
Set Preferences in PL\SQL Developer
Here, we need to set both ORACLE_HOME, and OCI library for reference screenshot is given below:
Click OK. And rerun PL/SQL Developer. And now, you’re ready to work with PL/SQL Developer.
Configuring the PL/SQL Developer connects to the Oracle DB on another computer. (your computer has already installed Oracle)
This is a connection model between PL/SQL Developer and Oracle Database on another computer. On your computer Oracle Database is available.
I can assume that you have successfully installed PL/SQL Developer tool to Oracle DB on the same computer. To connect to Oracle DB on another computer, you need to configure the tnsnames.ora file. In the case of Oracle tnsnames.ora file located in the directory:
PATH be LIKE THIS:
Here screenshot is attached for reference:-
The “tnsnames.ora” file contains the client-side network’s form (configuration) parameters. It can be present in the “$ORACLE_HOME/network/admin” directory on the client. This file will also be existing on the server if client style connections practice on the server itself.
Here is an example of a “tnsnames.ora” file.
LISTENER = (ADDRESS = (PROTOCOL = TCP)(HOST = myserver.example.com)(PORT = 1521)) orcl.example.com = (TECHORACLE = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = myserver.example.com)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) )
After completing the configuration, now connect to the Oracle Database Server. And you finished all the process of PL/ SQL developer installation.
1.Launch ……………….. from the directory where you created your PL/SQL file.
Answer: The SQL*Plus command prompt
2. Saving the file with which extension in the home directory?
Ans : .sql extension
3. choose True or False. If False, explain why.
Answer: True, The Routines were written in PL/SQL can be called in Oracle call interface, Java, Pro*C/C++, COBOL, and so on.
4. What are the basic sections of a PL/SQL block?
Answer: There are three sections in the PL/SQL block:
I hope this PL/SQL installation guide is quite helpful for you. If you have any problems with PL/SQL installation, then please feel free to contact us. In the coming article, we will discuss Datatypes, their types in PL/SQL tutorial.