Program with PL/SQL
(8 Hours)

Series: Database Series

Audience and Prerequisites Overview Course Outline Detail

AUDIENCE AND PREREQUISITES

This course is designed for individuals who have knowledge of Oracle Structured Query Language. (SQL). Contact us at 703-993-1551 for more information on this course or Oracle career paths.

Return to Top

OVERVIEW

This hands-on course will give you an introduction to PL/SQL, which is Oracle's proprietary programming language.

Return to Top

COURSE OUTLINE

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

 

 

Return to Top