In 1992, PL/SQL was released as an optional extension to Oracle 6. It works for the procedural languages associated with other relational databases. With each successive release of the Oracle Database, the functionality of PL/SQL can also be extended.
What is PL/SQL?
PL/SQL is Oracle’s procedural extension for SQL that stands for Procedural Language/Structured Query Language which is available in databases of Oracle, Times Ten, and IBM DB2. With each successive release of the Oracle Database, the functionality of PL/SQL can also be extended. The procedural language elements such as conditions and loops are included in the language. Constants and variables, procedures and functions, types and variables of those types, and triggers are also declared by using PL/SQL. PL/SQL collections also support arrays. PL/SQL units such as procedures, functions, packages, types, and triggers can be easily created and stored in database so that applications can reuse them.
Who uses PL/SQL?
- Infogain Corporation
- iPlace USA, Inc.
- First Republic Bank
- Luxoft Holding Inc
What it is used for?
- To return a set of values
- To perform database operations
- Supports SQL
- Closer integration with Oracle leading to better performance
- Supports object-oriented programming
In USA, the average salary of a PL/SQL developer is $96,877 per year.