Testing Oracle PL/SQL with SQL Developer

by Richard Thrust

In this tutorial we will look at PL/SQL automated unit testing techniques using the SQL Developer test repository. You will

1. How to download and install Oracle XE 11g,
2. How to download and install SQL Developer,
3. How to perform all the DBA tasks required to support this tutorial,
4. How to install the unit test repository,
5. Testing techniques Boundary value analysis, Equivalence partitioning and Static testing,
6. An overview of code coverage metrics and code complexity metrics,
7. To create unit tests for a procedure, how to group tests in a test suite and how to execute a test suite,
8. About the test reports that come with the SQL Developer unit test repository,
9. To unload and load test suites and learn to execute test suites from the command line,

After completing this self-contained tutorial you will have gained the knowledge to automate PL/SQL testing using the test repository.
This is an important step forward in automating the testing of PL/SQL. Learn it today.

Tutorial Table of contents

Introduction
Chapter 1 – Creating a test environment
1.1 Download and install Oracle XE
1.2 Download and install SQL Developer
1.3 DBA tasks to set up the database
1.4 Installing the unit test repository
1.5 SQL Developer compiler options
1.6 In conclusion
Chapter 2 – Unit testing techniques
2.1 Testing Methods
2.2 Boundary Value Analysis
2.3 Equivalence Partitioning
2.4 State transition Testing
2.5 Static Testing
2.6 Sample Code – Unreachable Example
Chapter 3 – Code Coverage Metrics
3.1 Code Coverage
3.2 Statement Coverage
3.3 Branch Coverage
3.4 Number of lines of code metric
3.5 McCabe’s Cyclomatic Index Metric
Chapter 4 – Unit testing with SQL Developer
4.1 SQL Developer tweaks
4.2 The sample code we will test
4.3 Creating our first simple test
4.4 Creating more test cases
4.5 Executing test cases
4.6 Creating a test suite
4.7 Executing a test suite
4.8 In summary
Chapter 5 - SQL Developer Unit Test Reports
5.1 The Unit Test Repository Reports
5.2 All suite Runs
5.3 All Test Implementations
5.4 All Test Runs
5.5 Suite Runs Code Coverage
5.6 Suite Test Implementation Runs
5.7 Suite Test Runs
5.8 Test Implementation Runs
5.9 Test Runs Code Coverage
5.10 User Test Runs
5.11 Conclusions about the test reports
Chapter 6 - Manipulating Test Suites
6.1 Loading and unloading test suites
6.2 Executing test suites from the command line
6.3 A Custom report on the repository
Chapter 7 – In Conclusion
7.1 Repository Benefits
7.2 Repository Dis-advantages
7.3 In summary
Appendices
Software Testing Related Standards
Bonus Material related to this eBook
More titles from Richard Thrust

71 pages, Kindle Edition

First published February 28, 2013