Data Generator, putting data in a relation

[tgav95]

Hello everybody! I'm having a problem with the PL/SQL Developer data generator and hoped to find some help in this forum. My problem is, that I have to put a row in a relation to another. For example, I want to generate data about food, one row defines the kind of food, and the second row defines the color. Now I need to tell the data generator, that only the apples can be red or green and that only the prunes can be purple, like: "if 'kind of food' = 'apple', then 'color' = list('red', 'green') else 'color' = 'purple'"
Many thanks in advance and I hope you'll forgive my bad english.

 

[Marco Kalter]

This is currently not possible. This is on the list of enhancement requests though.

 

[tgav95]

Well the problem solved it self I found a way to solve this riddle. For everyone who is interested: I just made a list in the directory C:\Programme\PLSQL Developer\DataGenerator\UserData. The list looks like this(the list is called "fruity_problem"):

[kind, color]
apple, red
prune, purple

then you just have to type "fruity_problem.kind" in the field that defines the kind of fruit and type "fruity_problem.color" in the field that defines the color of the fruit.