C H A P T E R  5

PL/SQL Unit Testing

by Sue Harper

Any developer accessing the Oracle Database uses SQL whether running SQL reports and queries developed personally or provided by another developer. While it may not be true to say that every developer runs and uses PL/SQL when working with the Oracle Database, the number is no doubt very high as any procedural access to the Oracle Database is best done using PL/SQL. As a developer, if you create and work with PL/SQL, you should be debugging and testing the PL/SQL to ensure accurate and efficient code.

In this chapter, you’ll look at PL/SQL unit testing: what is meant by unit testing, why it’s important in the development lifecycle, and how to build tests. There are a few tools and utilities ...

Get Expert PL/SQL Practices for Oracle Developers and DBAs now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.