English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 1h 43m | 277 MB
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.
Table of Contents
Introduction
1 Oracle Database PL SQL Why use it with Oracle Database 19c
2 Prerequisites
PL SQL Elements
3 Overview of PL SQL
Procedures and Functions
4 Built-in PL SQL procedures and functions
5 Creating functions
6 Creating procedures
Declaration Section
7 Declaring variables
8 Declaring cursors
Security Model
9 Invoker rights versus definer rights
10 How blocks define scope
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
Using SQL SELECT Statements
16 Programming constructs SELECT INTO and ROWCOUNT
17 Running SQL statements Static
18 Running SQL statements Dynamic
Error Handling
19 Error handling with EXCEPTION
20 User-defined exception types
Leveraging User-Defined Types
21 Declaring and using user-defined types
22 Using type with TABLE functions
Conclusion
23 Keep going and connect
Resolve the captcha to access the links!