Oracle PL/SQL Fundamentals - Part 2

In this course, we will take an in-depth look at Procedures, Functions, and Packages. These named program units are powerful programming constructs which can greatly enhance and optimize your code.
Course info
Rating
(160)
Level
Intermediate
Updated
Jun 14, 2014
Duration
5h 10m
Table of contents
Overview
Procedures
Functions
Parameters in Procedures & Functions
Local Subprograms
Package Specification
Package Body
Calling Functions from SQL
Roles & Privileges With Subprograms
Description
Course info
Rating
(160)
Level
Intermediate
Updated
Jun 14, 2014
Duration
5h 10m
Description

In this course, we will learn how to create, compile, and execute Procedures, Functions, and Packages which are named program units that are pre-compiled and stored in the database. These are powerful programming constructs which help with increasing the re-usability of code along with making it more efficient. We will also take a look at how to pass parameters to these subprograms, parameter modes, and how to pass parameters by reference and by value. We will discuss how roles and privileges come into play when compiling and executing subprograms along with the authid clause. We will also talk about local subprograms and calling functions from SQL statements. All of these are important concepts and will enable you to write efficient and highly performing PL/SQL code.

About the author
About the author

Experienced technologist, with expertise in various aspects of software development lifecycle, architecting software solutions and software development.

More from the author
Oracle REST Data Services
Beginner
5h 32m
Feb 13, 2018
Getting Productive with SQL Developer
Beginner
3h 54m
Apr 20, 2017
More courses by Pankaj Jain