Introduction to PL/SQL

This 2 day course will give you an introduction to Oracle Corporation’s proprietary procedural extension to the SQL database language, PL/SQL. PL/SQL (Procedural Language/Structured Query Language) is embedded in the Oracle Database, and allows the creation of powerful programming blocks - procedures and functions - which interact with SQL to dramatically increase the functionality of your Oracle database. A basic level of SQL knowledge, and some understanding of relational database (RDBMS) concepts is assumed. For students who do not have experience in these areas the Introduction to SQL class is recommended.

Introduction to PL/SQL

• Relation between SQL and PL/SQL


• Advantages of PL/SQL


• A Simple PL/SQL Block


• Declaration using attributes


• Loop Statements


• Displaying the user messages on screen

Cursors and Error Handling

• Cursors


• Using the Explicit Cursors


• Explicit Cursor Attributes


• Implicit Cursor Attributes


• Example of an Explicit Cursor and Attribute


• Error handling in PL/SQL


• Stored Procedures, Functions and Packages

Stored Procedures

• Stored Procedures


• How Oracle creates a Procedure?


• Advantages of Procedures


• Deleting the Procedure

Functions

• Stored Functions


• How Oracle creates a Function?


• Advantages of Functions


• Creating a Function


• Deleting a Function

Triggers

• Use of Database Triggers


• Applying a Database Trigger


• Types of Triggers


• Before Vs After Triggers


• Creating a Trigger


• Deleting a Trigger