Need SQL coverage tool

Hello all,

I want to test some SQL - Scripts (Oracle RDB). They contain statements like

   SELECT abc
   FROM xyz
   WHERE condition;

A condition consists of

• condition1 && condition2
• condition1 || condition2
• NOT condition
• EXISTS ( SELECT ... )
• op1 = op2
• op1 <> op2

etc. I guess you can imagine what it's like.

My duty now is to design tests which show that the SELECT statements are coded right.
Therefore I want to design the data such that it causes each condition to evaluate to TRUE at least one time during the tests.

I would be very obliged if one could tell me where to get/purchase a SQL coverage tool that helps me to build such test cases. Or do you know of any method to check which condition has been met for each hit?

Kind regards,
Jens Lippmann.

--

# Jens Lippmann                 lippmann_at_rbg.informatik.tu-darmstadt.de
#                              http://www.informatik.tu-darmstadt.de/TI

#
# Technische Universitaet Darmstadt          http://www.tu-darmstadt.de