This Oracle Database: PL/SQL Program Units course builds on existing knowledge of PL/SQL block structure, variables, control structures and exception handling to explore the benefits of building Program Units in this powerful programming language.
On successful Completion of this course you will be able to:
Create, execute, and maintain Procedures and functions
Create, execute, and maintain Package constructs
Create, execute, and maintain Database triggers
Manage PL/SQL subprograms and triggers
Use a subset of Oracle-supplied packages to generate screen and file output
Identify various techniques that impact your PL/SQL code design considerations
Use the PL/SQL compiler and manage dependencies
Oracle Database 19c: Program with PL/SQL Units eLearning