In this course, you’ll learn how to test PL/SQL code using the Oracle SQL developer unit testing framework. It is a robust and feature rich framework which allows you to easily create test cases for your PL/SQL program units, organize them in test suites, reuse your work with libraries and share your tests in a team development environment.

First, you’ll discover that it allows you to analyze your code coverage and view previous runs and results with several built-in reports. Next, you’ll explore how it lets you synchronize your tests when the name or definition of the underlying program units change. Finally, you’ll learn how it gives you the ability to automate your tests using the SQL Developer command line interface, which is extremely useful in implementing your continuous testing strategy. When you’re finished with this course, you’ll have a foundational understanding of Oracle SQL Developer PL/SQL Unit Testing feature, which will help you immensely when implementing extensive test cases for your PL/SQL program units and achieving test automation.

Course Duration: 2 days
Course Outline:
  • Introduction to utPLSQL
  • User Guide
    • Installation
    • Getting Started
    • Annotations
    • Expectations
    • Running Unit Tests
    • Testing Best Practices
    • Upgrade utPLSQL
  • Reporting
    • Using Reporters
    • Reporting Errors
    • Code Coverage
  • Modules
    • Overview of Unit Testing
    • SQL Developer User Interface for Unit Testing
    • Unit Test Repository
    • Editing and Running a Unit Test
    • Using a Dynamic Value Query for Seed Data
    • Using Lookups to Simplify Unit Test Creation
    • Using Variable Substitution in Validation Actions
    • Unit Test Library
    • Unit Test Reports
    • Exporting and Importing Unit Test Objects
    • Using the Command-Line Interface
    • Example of Unit Testing (Tutorial)