Pluralsight - Oracle PL / SQL Fundamentals - Part 2 - 2014

Year : 2014
Manufacturer : pluralsight
Author : Pankaj Jain
Duration : 5h 10m
Language : English
Format : MP4
Video : AVC, 1024x768, 4: 3, 15 fps, 155 Kbps
Audio : AAC, 106 Kbps, 2 channels, 44.1 KHz



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 consider the deeper procedures, functions, and packages. These program blocks are powerful programming constructs that can greatly enhance and optimize your code.


01. Overview 8:17
Overview 2:38
Benefits of Named Program Units 2:16
Prerequisites 0:52
Audience 1:05
Tools 1:25

02. Procedures 39:54
What is a Procedure? 3:00
Defining Procedures 4:39
Compiling Procedures & Native Compilation 3:29
PLSQL_OPTIMIZE_LEVEL & Compile for Debug 4:36
Errors and Warnings 6:45
Demo: Creating & Compiling Procedures, Errors and Warnings 9:42
Executing Dropping & Terminating Procedures 2:30
Demo: Executing Dropping & Terminating Procedures 3:48
Summary 1:21

03. Functions 33:11
What is a Function? 2:15
Oracle Provided Functions 3:31
Defining Functions 5:23
Compiling & Executing Functions 8:42
Dropping & Terminating Functions 3:23
Demo 8:55
Summary 0:58

04. Parameters in Procedures & Functions 49:34
Introduction 1:28
Formal vs. Actual Parameters 5:57
Parameter Modes 9:12
Passing by Reference & Value 4:50
NOCOPY hint 3:32
Demo:Parameter Modes & NOCOPY 6:13
Positional, Named & Mixed Notation 4:33
Default Values & Constraints on Formal Parameters 8:02
Demo: Default Values, Positional & Named Notations 4:11
Summary 1:32

05. Local Subprograms 18:26
Introduction 3:44
Defining Local Subprograms 2:36
Demo: Local Subprograms 2:12
Exceptions, Scope & Visibility of Variables 4:44
Demo: Exceptions, Scope & Visibility of Variables 4:22
Summary 0:46

06. Package Specification 28:42
Introduction 1:32
Why Use Package Specifications? 4:30
Package Structure & Contents 2:47
Defining Package Specification 4:37
Compiling Package Specification 2:42
Executing & Dropping Package Specification 3:21
Global Variables & Session State 1:09
Demo 6:57
Summary 1:02

07. Package Body 48:33
Introduction 0:49
Defining Package Body 8:12
Package Initialization 2:52
Compiling & Executing Package Body 3:06
Order of Subprograms & Forward Declaration 1:46
Stateful & Stateless Packages 3:08
Overloading Subprograms 8:27
Overloading Considerations 4:35
Demo: Compiling & Executing Packages 9:26
Demo: Stateful & Stateless Packages 4:50
Summary 1:16

08. Calling Functions from SQL 31:14
Where Can They Be Called? 4:15
Restrictions 5:03
Demo: Functions in SQL Statements 5:54
Deterministic 5:32
Parallel Enable 3:19
Demo: Deterministic Functions 2:55
Pragma Restrict References 2:45
Summary 1:30

09. Roles & Privileges With Subprograms 52:28
Subprogram Resolution 5:15
Demo: Subprogram Resolution 3:32
AUTHID DEFINER 7:02
AUTHID CURRENT_USER 7:32
Execution Flow Between Invoker & Executor 5:01
Demo: AUTHID Clause & Execution Flow 9:45
Direct Grants vs. Roles 7:35
Demo: Direct Grants vs. Roles 5:37
Summary 1:07