Back

Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
in SQL by (9k points)
What is PL/SQL?

1 Answer

0 votes
by (45.3k points)

PL/SQL is used in Oracle as a procedural language extension to SQL. Its purpose is to combine both database and procedural programming language. It combines SQL’s data manipulation power with procedural language’s processing power in order to create powerful SQL queries. It instructs the compiler what it needs to do via SQL and how a task needs to be done through the procedural way. It gives control to the coders and programmers with conditions, loops, and concepts of object-oriented programming.

PL/SQL consists of a number of units including:

  • Function
  • Package Specification
  • Procedure
  • Trigger
  • Anonymous Block
  • Library
  • Package Body
  • Type
  • Type Body

If you wish to make a career in PL/SQL then you must go through PL/SQL Interview Questions.

Also, check out this video tutorial on PL/SQL:

Related questions

0 votes
1 answer
asked Dec 10, 2020 in SQL by dev_sk2311 (44.2k points)
0 votes
1 answer
asked Oct 19, 2020 in SQL by dev_sk2311 (44.2k points)
0 votes
1 answer
asked Jan 29, 2020 in SQL by anmolj (9k points)
0 votes
1 answer
0 votes
1 answer
asked Dec 10, 2020 in SQL by dev_sk2311 (44.2k points)

Browse Categories

...