Oracle PL/SQL Fundamentals - Part 2

MP4 | AVC 327kbps | English | 1024x768 | 15fps | 5h 10mins | AAC stereo 113kbps | 645 MB

Genre: Video Training

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.

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.

Overview8m 17s

Procedures39m 54s

Functions33m 11s

Parameters in Procedures & Functions49m 34s

Local Subprograms18m 26s

Package Specification28m 42s

Package Body48m 33s

Calling Functions from SQL31m 14s

Roles & Privileges With Subprograms52m 28s