Oracle Database: Develop PL SQL Program Units

Overview

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.

Prerequisites

Required

• Oracle Database: SQL Workshop (or equivalent knowledge)
• Oracle Database: PL/SQL Fundamentals

Suggested

• Familiarity with data processing concepts and techniques
• Familiarity with programming languages

Audience

• Database Administrator
• Developer
• Implementer
• Tester

Objectives

• 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

Outline

• Creating Stored Procedures
• Creating Functions
• Debugging Subprograms
• Creating Packages
• Working with Packages
• Using Oracle-Supplied Packages in Application Development
• Using Dynamic SQL
• Creating Triggers
• Creating Compound, DDL and Event Database Triggers
• Design Considerations for PL/SQL Code
• Tuning the PL/SQL Compiler
• Managing Dependencies