Good day all,
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
"CORE 11.2.0.1.0 Production"
TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.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.
Thanks for looking at my issue.
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 |
| EMPLOYEE_ID | FIRST_NAME | LAST_NAME |
| 000001 | A | Smith |
| 000002 | B | Jones |
| 000003 | C | utler |
| 000004 | D | Thomas |
| 000005 | E | Marsh |
| 000006 | F | Ruppert |
| 000007 | G | Glenn |
| STRET_ADDRESS | CITY | HEAD_CNT | STATE |
| 737 Any Road | Anywhere | 3 | USA |
| 50 Some Road | Nowhere | 4 | USA |