I would like to return 1 row of a set randomly, for instance:
(table test_table has 4 rows in it)
(this should give me back 1 of the 4 rows randomly, but with a normal distribution. i.e. After calling this function 100 times I should get each row about 25 times each)
Is this possible in Oracle? What is the best performing method to do it?