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

LinkedIn Learning

Oracle Database 19c: PL/SQL

via LinkedIn Learning

Write review
Simplilearn Ad

Become an AI & ML Engineer with Cal Poly EPaCE — IBM-Certified Training

Learn More → Boot.dev Ad

Learn Backend Development Part-Time, Online

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One plan covers every Professional Certificate 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 602 ratings

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

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.