PL/SQL Exception

PL/SQL Exception

PL/SQL Interview Questions

PL/SQL Interview Questions and Answers


What is PL/SQL?

PL/SQL is a procedural language extension to Structured Query Language (SQL) and it is integrated with Oracle database (since version 7). The purpose of PL/SQL is to combine SQL and procedural programming language.

PL/SQL is a units of block, which is made up of three parts: a declarative part, an executable part, and an exception-building part. A PL/SQL is a set of compiled program stored in a database is called stored procedure.

Science PL/SQL is a mixed of SQL statement and procedural structure, you can use procedural language elements such as conditions and loops to group SQL statement. It also allows you to declare constants and variables, procedures and functions, types and variables of those types, and triggers.

PL/SQL also provides functionality like decision making, iteration and many more features like other procedural programming languages. Science SQL is a non procedural, to enhance the capabilities of SQL Oracle Corporation introduced PL/SQL in the early 90's.

Features of PL/SQL

PL/SQL has the following features -

  • It is tightly integrated with SQL.
  • PL/SQL is high performance transaction processing language.
  • Unlike SQL, it support code re-usability, no need to write code again and again.
  • It consists of blocks of code, each and every block forms a unit of a task.
  • It offers extensive error checking and user friendly error messages.
  • It offers a variety of programming structures.
  • It supports structured programming through functions and procedures.