What is PL/SQL

• PL/SQL Environment
• Benefits of PL/SQL
• Stored Procedures, Functions, and Triggers
• Stored Procedures and SQL Scripts

Structure of a PL/SQL Block

• Header Section
• Declaration Section
• Execution Section
• Exception Section

Creating a PL/SQL Procedure

Creating a PL/SQL Function

PL/SQL Variables and Constants

• Declaring PL/SQL Variables
• Declaring PL/SQL Constants
• Assigning Values to Variables
• Using Variables

Control Structures in PL/SQL

• IF Statement
• Loops
• Cursors
• Nested Loops

Error Handling

• Exceptions
• System Defined Exceptions
• Programmer Defined Exceptions

Other PL/SQL Tools

• PL/SQL Packages
• Triggers
• Views used with PL/SQL