This course introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. In the course, you shall learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications.
You shall also learn to create anonymous PL/SQL blocks and are introduced to stored procedures and functions.
Learn about declaring variables, trapping exceptions and they also learn to declare and control cursors.
Learn also: Declaring PL/SQL Variables Working with Composite Data Types Creating the Executable Section Using Explicit Cursors Writing Control Structures Including Exception Handling
Course Objectives
Write PL/SQL code to interface with the database
Design PL/SQL program units that execute efficiently
Handle run-time errors
Describe stored procedures and functions
Course Topics
Introduction to PL/SQL
What is PL/SQL
PL/SQL Environment
Benefits of PL/SQL
Overview of the Types of PL/SQL blocks
Create and Execute a Simple Anonymous Block
Generate Output from a PL/SQL Block
Declaring PL/SQL Identifiers
Identify the Different Types of Identifiers in a PL/SQL subprogram
