PL/SQL: Procedures and Functions

Overview/Description
To provide the student with a detailed understanding of modular programming in PL/SQL using stored procedures and functions

Target Audience
Database administrators, system administrators, and application developers who are using PL/SQL version 2 for the first time, and experienced developers who are upgrading from a previous PL/SQL version or another 3GL programming language

Prerequisites
The course Relational Principles; the courses on SQL*Plus; and the courses PL/SQL: Fundamentals and PL/SQL: Exceptions and Scripts

Expected Duration
6:00 Hours

Objectives:

PL/SQL: Procedures and Functions

  • To introduce the concept of PL/SQL program units and to examine PL/SQL composite datatypes
  • To examine a sample PL/SQL program that uses composite datatypes
  • To examine how a PL/SQL procedure is created and executed and how parameters are passed at run-time
  • To examine a sample PL/SQL procedure that accepts parameters at run-time
  • To examine how a PL/SQL function is created and executed and how a value is returned to the calling program
  • To examine a sample PL/SQL function


    • Course Number: PLSPF