Oracle Database 19c: PL/SQL
1h 44mAdvanced2020-10-09
Authors
Bob Bryla
30 years of experience in the database business
Course details
PL/SQL is the companion programming language to Oracle Database. Having a modern programming language that integrates with the database itself makes the Oracle Database platform scalable and extensible for more applications. In this course, Bob Bryla reviews the major features of Oracle PL/SQL under Oracle Database 19c. Bob covers key aspects of this procedural language, including looping, conditional statements, and exception handling when something goes wrong. He shows how to more effectively use the built-in procedures of PL/SQL, as well as write your own. Plus, he covers the PL/SQL security model and demonstrates how to run SQL queries and DDL statements from within PL/SQL.
Skills covered
Oracle DatabaseDatabase AdministrationOracleDatabase ManagementDeep Dive (X:Y)
Concepts
0. Introduction
- 01 - Oracle Database PL SQL - Why use it with Oracle Database 19c
- 02 - Prerequisites
1. PL SQL Elements
- 03 - Overview of PL SQL
2. Procedures and Functions
- 04 - Built-in PL SQL procedures and functions
- 05 - Creating functions
- 06 - Creating procedures
3. Declaration Section
- 07 - Declaring variables
- 08 - Declaring cursors
4. Security Model
- 09 - Invoker rights versus definer rights
- 10 - How blocks define scope
5. Conditional Statements
- 11 - Programming contstructs - FOR loop
- 12 - Programming constructs - WHILE loop
- 13 - Programming constructs - LOOP
- 14 - Programming constructs - IF statement
- 15 - Programming constructs - CONTINUE and EXIT
6. Using SQL SELECT Statements
- 16 - Programming constructs - SELECT INTO and ROWCOUNT
- 17 - Running SQL statements - Static
- 18 - Running SQL statements - Dynamic
7. Error Handling
- 19 - Error handling with EXCEPTION
- 20 - User-defined exception types
8. Leveraging User-Defined Types
- 21 - Declaring and using user-defined types
- 22 - Using type with TABLE functions
Conclusion
- 23 - Keep going and connect