We just started to use Code tester and after watching the video “Test the contents of a database table against a control/copy table” some of my teammates got sceptical about the practicality of creating a control/copy table. It’s due to the fact that the tables we use are quite large and even if you copy only the subset of data it could be very bulky. At that point I thought of using the flashback queries to achieve exactly the same test. The attached xml file contains a new test case “Delete some rows (flashback query)” which shows how to do it.
Q##QCTOD#DELETE_MULT_ROWS.xml (227 KB)