Oracle PL/SQL Fundamentals - Part 2
Pluralsight
Course Summary
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 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.
-
+
Course Syllabus
Overview- 8m 17s
—Overview 2m 38s
—Benefits of Named Program Units 2m 16s
—Prerequisites 0m 52s
—Audience 1m 5s
—Tools 1m 25sProcedures- 39m 54s
—What is a Procedure? 3m 0s
—Defining Procedures 4m 39s
—Compiling Procedures & Native Compilation 3m 29s
—PLSQL_OPTIMIZE_LEVEL & Compile for Debug 4m 36s
—Errors and Warnings 6m 45s
—Demo: Creating & Compiling Procedures, Errors and Warnings 9m 42s
—Executing Dropping & Terminating Procedures 2m 30s
—Demo: Executing Dropping & Terminating Procedures 3m 48s
—Summary 1m 21sFunctions- 33m 11sParameters in Procedures & Functions- 49m 34sLocal Subprograms- 18m 26sPackage Specification- 28m 42sPackage Body- 48m 33sCalling Functions from SQL- 31m 14sRoles & Privileges With Subprograms- 52m 28s