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.Through hands-on instruction from expert Oracle instructors, you'll learn to develop stored procedures, functions, packages and triggers and utilise Oracle provided packages.Learn To:Develop stored procedures to carry out database modifications.Write functions to be called from PL/SQL code or SQL statements.Use PL/SQL packages to group and contain related constructs.Create triggers to solve business challenges.Use Oracle supplied PL/SQL packages to generate console and file output.Examine the dependency chain on program units prior to implementing changes.Benefits to You:Develop sound, reliable program units to standardise and streamline your organisation's approach to maintaining data.You'll use Oracle SQL Developer to develop these program units. SQL*Plus is also available as an optional tool.
