- Oracle Database 11g Enterprise Edition Release 184.108.40.206.0 - Production
- PL/SQL Release 220.127.116.11.0 - Production "CORE 18.104.22.168.0 Production"
- TNS for 32-bit Windows: Version 22.214.171.124.0 - Production
- NLSRTL Version 126.96.36.199.0 - Production
I will base this question of the HR Schema for simplicity. I have two tables Employees and Locations. For this example, I have 37 locations and 173 employees.
My locations have a specific number assigned indicating the number of employees that need to be assigned to the location. What I am attempting to do is randomly assign the number of required employees for each location from the employees table.
As such an example of desired results would be:
EMPLOYEE_ID FIRST_NAME LAST_NAME STREET_ADDRESS CITY STATE 1 A Smith 737 Any Road Anywhere USA 2 B Jones 50 Some Road Nowhere USA 3 C Butler 737 Any Road Anywhere USA 4 D Thomas 50 Some Road Nowhere USA 5 E Marsh 737 Any Road Anywhere USA 6 F Ruppert 50 Some Road Nowhere USA 7 G Glenn 50 Some Road Nowhere USA