The Oracle Database: PL/SQL Fundamentals Ed 2 course introduces students to the PL/SQL programming language. In the class, students learn to create PL/SQL blocks of application code.
1. Introduction
2. Introduction to PL/SQL
3. Declaring PL/SQL Variables
4. Writing Anonymous PL/SQL blocks
5. Using SQL Statements within a PL/SQL Block
6. Writing Control Structures
7. Working with Composite Data Types
8. Using Explicit Cursors
9. Handling Exceptions
10. Creating Stored Procedures and Functions