PLSQL Basics

1.       PL/SQL Architecture

·       PL/SQL Compiler

·       PL/SQL Runtime Engine

·       Database Engine

·       Caching of PL/SQL code

·       Modular programming

2.     PL/SQL Execution Environment

·       Oracle Database Server

·       Client-side tools (SQL*Plus, SQL Developer)

·       Compilation phase

·       Execution phase

·       Exception handling

3.     PL/SQL Block Structure

·       Declaration Section (optional)

·       Executable Section (mandatory)

·       Exception Section (optional)

4.     Anonymous Blocks

·       No name

·       Executed once

·       Used for ad-hoc tasks

5.     Nested Blocks

·       Inner blocks inside outer block

·       Own declaration, executable, exception sections

·       Localized error handling