returning random row from small resultset

[wwalice]

I would like to return 1 row of a set randomly, for instance:

(table test_table has 4 rows in it)

select from test_table

(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?

thanks much-

[kmesser]

use the dbms_random package.