Overview
-
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
- Overview of PL/SQL
- Built-in PL/SQL procedures and functions
- Creating functions
- Creating procedures
- Declaring variables
- Declaring cursors
- Invoker rights versus definer rights
- How blocks define scope
- Programming contstructs: FOR loop
- Programming constructs: WHILE loop
- Programming constructs: LOOP
- Programming constructs: IF statement
- Programming constructs: CONTINUE and EXIT
- Programming constructs: SELECT INTO and %ROWCOUNT
- Running SQL statements: Static
- Running SQL statements: Dynamic
- Error handling with EXCEPTION
- User-defined exception types
- Declaring and using user-defined types
- Using type with TABLE functions
- Keep going and connect
