Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Explain the PL/SQL Engine in DBMS
PL/SQL is oracle’s procedural language extension to SQL. PL/SQL allows you to mix SQL statements with procedural statements like IF statements. Looping structure etc, PL/SQL is the superset of SQL. It uses SQL for data retrieval and manipulation and uses its own statement for data processing.
Pl/SQL program units are generally categorized as follows −
Anonymous block
This is a PL/SQL block that appears within your application. In many applications PL/SQL blocks can appear where SQL statements can appear. Such blocks are called Anonymous blocks.
Stored procedures
This is a PL/SQL block that is stored in the database with a name. Application programs are executing these procedures using the name. Oracle allows you to create functions, which are the same as procedures but return a value, and packages, which are a collection of procedures and functions.
PL/SQL Engine
Every PL/SQL block is first executed by the PL/SQL engine. This is the engine that compiles and executes Pl/SQL blocks.
PL/SQL engine is available in oracle server and certain oracle tools such as oracle forms and oracle reports. It executes all procedural statements of a PL/SQL of the block, but sends SQL commands to SQL statement executors in the oracle RDBMS.
That means PL/SQL separates SQL commands from PL/SQL commands and executes PL/SQL commands using procedural statement executor, which is a part of the PL/SQL engine.
2K+ Views
