Hi is there a query in sql (oracle) that will tell me the number of test cases in each of the test sets. Note that I also need 0 returned if a test is not used in any of the test sets.
You can find the number of test cases in each test set but in order to do this you need to play with the following tables: TEST, CYCLE and TESTCYCL and depending on your task some other to.
The OTAG (Open Test Architecture Guide) book has all the info that you need in order to understand the relation between the tables.
Select COUNT(*) from table1 - this will return the number of rows from table1
you need to adjust this query.
"If I want something I've never had, I must do something I've never done!"