This Oracle Database: Develop 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:
Describe stored procedures and functions
Create, use and debug stored procedures and functions
Design and use PL/SQL packages to group and contain related constructs
Create overloaded package subprograms for greater flexibility
Use Oracle supplied PL/SQL packages to generate console and file output
Write dynamic SQL for more coding flexibility
Create Triggers
Manage dependencies between PL/SQL subprograms
Oracle Database: Develop PL/SQL Program Units eLearning