I am doing a program in plsql that will make a draw. This draw besides being random also has a weighting.
I am based on this program in Excel: http://www.dailydoseofexcel.com/archive ... dom-sorts/
I wanted to know what the best way to deal with the following situation:
In my case, assigns the categories of the company. The employee will have a weighting value equal to that of its category.
If the weighting of the XPTO employee category has the value 6 I would have to create an array with 6 values, each of these values ??would be generated according to the formula ->
=(RAND()^LOG(1-1/(6+1); 0,5))*1000
Is this possible to do in PLSQL or will I have to take another way?
Thanks.
Greetings,
André.