0In Oracle Database Management System, PL/SQL is a procedural language extension to Structured Query Language (SQL). The purpose of PL/SQL is to combine database language and programming language. - From Wikipedia
- PL/SQL stands for Procedural Language / Structured Query Language.
- Extensively use to code Server Side Programming.
- Case Insensitive Programming Language.
Type of Blocks in PL/SQL:
- Anonymous Block
- Named Block
PL/SQL Writing Pattern:
Declaration Section
..... (Optional)
Execution Section
..... (Mandatory)
Exceptional Handling Section
..... (Optional)
Syntax:
DECLARE
Declaration Section;
BEGIN
Execution Section;
EXCEPTION
Exception Handling Section;
END;
