Class Summary

PL SQL is an extension of SQL language, designed for seamless processing of SQL statements enhancing the security, portability and robustness of the database. This tutorial explain some important aspect of PL SQL language like block structure, data types, packages, triggers, exception handling, etc.

What should I know?

Basic knowledge of SQL will be required.


1. Introduction to PL/SQL

2. Blocks in PL/SQL

3. PL SQL First Program: Hello World

4. PL/SQL Data Types

5. Complex Data Types in PL/SQL

6. PL/SQL Decision Making Statements

7. Loops in PL/SQL

8. Subprograms: Procedures and Functions in PL/SQL

9. Exception Handling in PL/SQL

10. SQL in PL/SQL

11. Packages in PL/SQL

12. Triggers in PL/SQL

13. Object Types in PL/SQL

14. Dynamic SQL in PL/SQL

15. Nested Blocks in Pl/Sql

16. PL/SQL Identifiers