Oracle Database 19c: PL/SQL

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

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