I am attempting to populate tables in my database using the generate data option. The function works beautifully except for one seemingly minor problem: I have read in documentation that it is possible to create a list of possible data members for toad to randomly choose from to fill a column in a table. For example, I have a column labeled “SEX” and i want to randomly populate it with ‘M’ or ‘F’ only, (not a random single character). When i use the “constant value” option in the generate data box it only populates with both values together, concatenated, as a single string.
If there is an sql statement that could be used under the sql statement option in that same box, maybe that could be suggested as well.
Any help would be greatly appreciated.