Oracle Database 19c: PL/SQL

Oracle Database 19c: PL/SQL

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

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

23 Keep going and connect