Introduction
Welcome to my Project Space, It’s hard to update this, as I don’t usually public what I have developed or developing, but here are the things which you might check.
Easy Access
To Easily navigate through my notes use tags…..
Posts for: #PL/SQL
PL/SQL Full Notes
What is PL/SQL?
PL/SQL stands for Procedural Language Extension to SQL- It is a Extension of SQL developed by Oracle.
- It adds SQL capabilities of procedural programming like variables, loops and conditional statements in SQL.
PL/SQL Architecture
Physical Architecture
- PL/SQL engine processes the entire PL/SQL block of code.
- It Separate SQL statements and Procedural statements.
Simple Architecture Flow
PL/SQL Logical Architecture
- Corporates with SQL Engine.
- Enables Subprograms -> Allows re-usability of code/script like variables and functions.
- Dynamic Queries-> We can modify or create new Queries.
- Case Insensitivity
- Optimizer-> It optimizes our code for better performance.
- Enables Object-Oriented Programming
- Web Development
#Extras
Context Switching:
When you write SQL Query in PL/SQL the PL/SQL send the query to SQL Engine and the result will be returned this operation is called Context Switching.
Pluggable Database
