Random Assignment of Employees to Locations Oracle SQL
Use the random function to generate a number. "Number" your locations with slots equal to the number of positions they need. For example, if location A needs 15 and location B 16 then request a random number from 1 to 31 and:


1-15 go to A
16-31 go to B


Save that result to a table, and then pull all employees assigned per site.