utPLSQL vs "Advanced PLSQL unit tests"

Toad for Oracle & DevOps Toolkit
1

Im trying to decide which version of Toad I need and one deciding factor is what benefits "Advanced PLSQL unit tests" have over utPLSQL. Can someone explain this to me?

2

Code Tester is a Quest solution, initially developed by Steven Feuerstein, to give developers a faster way to create and maintain unit tests using a repository-based approach, allowing developers to be highly productive with a discipline (unit testing) that many are loathe to deal with, because proper code testing takes time to do right.

Code Tester's benefits include:

  • GUI interface to quickly define and maintain unit tests, test cases, and test suites, even BEFORE code is written (allows developers to be more proactive in thinking ahead about their test cases before any coding takes place)
  • Database Repository to maintain/version your test cases and suites
  • Support for dynamic test cases, where (multiple) inputs can be defined at random or from a priori sources (file contents, SQL, etc.)
  • Support for code coverage and related reports
  • Library of pre-defined boundary conditions to test for (NULL inputs, invalid argument types, etc.)
  • Unit tests and suites that evolve automatically as your code changes
  • One-touch unit test creation from within Toad when executing functions or procedures
  • One-touch unit test execution from within Toad against any function/procedure

The above are the main points... there are more. Bottom line is that Code Tester offers pre-packaged building blocks to avoid tedious coding usually involved with unit test cases and creation of test harness code. Code Tester comes with the Toad for Oracle Developer Edition, which costs a little more than the Toad product itself, but if one is doing a lot of unit testing, the ROI for the higher productivity gains offset the cost, IMO.

On the hand, utPLSQL is free within any version of Toad, and its library of templates allow ultimate, complete control of your testing granularity. But as is usually the case, "free" has its cost: e.g. the cost of taking much more time to define and develop your test code logic.

1 Like