Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Oracle Database 19c: PL/SQL

via LinkedIn Learning

Write review

Details

Provider

LinkedIn Learning
Pricing

Free Trial Available
Languages

English
Certificate

Certificate Available
Effort

1 hour 47 minutes
Sessions

Self-Paced
Level

Beginner

Found in

DataCamp

Power BI Fundamentals - Create visualizations and dashboards from scratch

TrainSec

Master Windows Internals - Kernel Programming, Debugging & Architecture

Overview

Google, IBM & Meta Certificates – 40% Off

One Coursera Plus subscription covers most Professional Certificates on Coursera.

Unlock All Certificates

Learn about the major features of Oracle PL/SQL, the programming language included with Oracle Database 19c.

Syllabus

Introduction

Oracle Database PL/SQL: Why use it with Oracle Database 19c?
Prerequisites

1. PL/SQL Elements

Overview of PL/SQL

2. Procedures and Functions

Built-in PL/SQL procedures and functions
Creating functions
Creating procedures

3. Declaration Section

Declaring variables
Declaring cursors

4. Security Model

Invoker rights versus definer rights
How blocks define scope

5. Conditional Statements

Programming contstructs: FOR loop
Programming constructs: WHILE loop
Programming constructs: LOOP
Programming constructs: IF statement
Programming constructs: CONTINUE and EXIT
New features of PL/SQL loop constructs

6. Using SQL SELECT Statements

Programming constructs: SELECT INTO and %ROWCOUNT
Running SQL statements: Static
Running SQL statements: Dynamic

7. Error Handling

Error handling with EXCEPTION
User-defined exception types

8. Leveraging User-Defined Types

Declaring and using user-defined types
Using type with TABLE functions

Conclusion

Keep going and connect

Taught by

Bob Bryla

Reviews

4.5 rating at LinkedIn Learning based on 720 ratings

Start your review of Oracle Database 19c: PL/SQL