Search

Top 60 Oracle Blogs

Recent comments

Recursive test data using plsql and the testdata_ninja package

Just the other day I was running a test of a system at work. I have already run several tests
against this system, so I already have a test data generator to generate clients in the system. This
time though I had to generate some orders within the system. So a really quick way to do that is to reuse
the existing generator for the client id reference (a foreign key in the real system) from the orders data
rows. This way I don't have to create an actual client table. I can just reference the plsql test data generator
directly in my definition of my order generator.