Oracle PL/SQL Unit Testing with Oracle SQL Developer
Good testing is essential to reduce bugs and produce quality software. Oracle SQL Developer offers the PL/SQL unit testing feature which lets developers and analysts effectively write and share test cases and suites to test their PL/SQL code.
What you'll learn
At the core of developing a high quality, bug free application lies our skills and knowledge to test our applications thoroughly and effectively. In this course, Oracle PL/SQL Unit Testing with Oracle SQL Developer, you'll learn how to test your 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.