What is PL/SQL

PL/SQL

what-is-pl-sql
what is pl sql

History

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?

  1. TCS
  2. Infogain Corporation
  3. iPlace USA, Inc.
  4. First Republic Bank
  5. Luxoft Holding Inc

 

What it is used for?

  1. To return a set of values
  2. To perform database operations

 

Advantages

  1. Supports SQL
  2. Closer integration with Oracle leading to better performance
  3. Supports object-oriented programming

 

Average salary

In USA, the average salary of a PL/SQL developer is $96,877 per year.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s