Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE table_name ( task VARCHAR2(20), name VARCHAR2(20) ); 
INSERT INTO table_name ( TASK )
  SELECT 'Get Chicken'   FROM DUAL UNION ALL
  SELECT 'Clean Chicken' FROM DUAL UNION ALL
  SELECT 'Cook Chicken'  FROM DUAL UNION ALL
  SELECT 'Eat Chicken'   FROM DUAL UNION ALL
  SELECT 'Eat Corn'      FROM DUAL UNION ALL
  SELECT 'Takeout Trash' FROM DUAL
6 rows affected

CREATE TABLE employees ( NAME ) AS
SELECT 'John'    FROM DUAL UNION ALL
SELECT 'Lucy'    FROM DUAL UNION ALL
SELECT 'Fred'    FROM DUAL UNION ALL
SELECT 'Jasmine' FROM DUAL;
4 rows affected

MERGE INTO table_name dst
USING (
  WITH random_tasks ( rid, rn ) AS (
    SELECT ROWID,
           ROW_NUMBER() OVER ( ORDER BY DBMS_RANDOM.VALUE )
    FROM   table_name
  ),
  random_names ( name, rn, num_employees ) AS (
    SELECT name,
           ROW_NUMBER() OVER ( ORDER BY DBMS_RANDOM.VALUE ),
           COUNT(*) OVER ()
    FROM   employees
  )
  SELECT rid,
         name
  FROM   random_tasks t
         INNER JOIN
         random_names n
         ON ( MOD( t.rn, n.num_employees ) + 1 = n.rn )
) src
ON ( src.rid = dst.ROWID )
WHEN MATCHED THEN
  UPDATE SET name = src.name;
6 rows affected

SELECT * FROM table_name;


TASK
NAME


Get Chicken
John

Clean Chicken
Jasmine

Cook Chicken
Fred

Eat Chicken
Lucy

Eat Corn
Fred

Takeout Trash
Lucy

TASK	NAME
Get Chicken	John
Clean Chicken	Jasmine
Cook Chicken	Fred
Eat Chicken	Lucy
Eat Corn	Fred
Takeout Trash	Lucy