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…..

📌 Quick Tag Index

#Agile (6) • #blender (1) • #blog (2) • #C (1) • #cheatsheet (1) • #Chennai (1) • #COA (1) • #Code (1) • #COURSE (1) • #custom (1) • #database (1) • #DBMS (2) • #devops (1) • #Elite_Tech_Park (1) • #GATE (3) • #Hands (1) • #Hands_On (1) • #hibernate (1) • #incubator (1) • #interview-prep (1) • #java (1) • #joins (1) • #js (1) • #linkedin (3) • #loadtesting (1) • #MCA (1) • #mysql (1) • #On (1) • #PL/SQL (1) • #post (9) • #Practical (1) • #python (1) • #react (1) • #SASTRA (1) • #security (1) • #selenium (1) • #shortcuts (1) • #spring (1) • #springboot (2) • #SQL (4) • #subqueries (1) • #TCS (8) • #testing (2) • #Theory (7) • #Theory/code (3) • #tricks (1) • #UDEMY (1) • #Visit (1) • #webtech (1) • #welcome (1) • #window-functions (1) • #Zoho (1)

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…..

📌 Quick Tag Index

#Agile (6) • #blender (1) • #blog (2) • #C (1) • #cheatsheet (1) • #Chennai (1) • #COA (1) • #Code (1) • #COURSE (1) • #custom (1) • #database (1) • #DBMS (2) • #devops (1) • #Elite_Tech_Park (1) • #GATE (3) • #Hands (1) • #Hands_On (1) • #hibernate (1) • #incubator (1) • #interview-prep (1) • #java (1) • #joins (1) • #js (1) • #linkedin (3) • #loadtesting (1) • #MCA (1) • #mysql (1) • #On (1) • #PL/SQL (1) • #post (9) • #Practical (1) • #python (1) • #react (1) • #SASTRA (1) • #security (1) • #selenium (1) • #shortcuts (1) • #spring (1) • #springboot (2) • #SQL (4) • #subqueries (1) • #TCS (8) • #testing (2) • #Theory (7) • #Theory/code (3) • #tricks (1) • #UDEMY (1) • #Visit (1) • #webtech (1) • #welcome (1) • #window-functions (1) • #Zoho (1)

What is PL/SQL?

1. PL/SQL stands for Procedural Language Extension to SQL
2. It is a Extension of SQL developed by Oracle.
3. 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