Oracle 21c

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

CREATE TABLE MyTable (EmployeeID, SomeOtherColumns, ManagerName) AS
SELECT LEVEL, 'SomeData', CAST(NULL AS VARCHAR2(20))
FROM   DUAL
CONNECT BY LEVEL <= 5;
5 rows affected

CREATE TABLE OtherTable(EmployeeID, Name, ManagerID) AS
SELECT 1, 'Alice', NULL FROM DUAL UNION ALL
SELECT 2, 'Beryl', 1 FROM DUAL UNION ALL
SELECT 3, 'Carol', 1 FROM DUAL UNION ALL
SELECT 4, 'Debra', 2 FROM DUAL UNION ALL
SELECT 5, 'Emily', 3 FROM DUAL UNION ALL
SELECT 6, 'Fiona', 1 FROM DUAL;
6 rows affected

UPDATE mytable m
SET managername = (SELECT name
                   FROM   othertable
                   WHERE  LEVEL = 2
                   START WITH employeeid = m.employeeid
                   CONNECT BY PRIOR managerid = employeeid);
5 rows affected

SELECT * FROM MyTable;


EMPLOYEEID
SOMEOTHERCOLUMNS
MANAGERNAME


1
SomeData
null

2
SomeData
Alice

3
SomeData
Alice

4
SomeData
Beryl

5
SomeData
Carol

EMPLOYEEID	SOMEOTHERCOLUMNS	MANAGERNAME
1	SomeData	null
2	SomeData	Alice
3	SomeData	Alice
4	SomeData	Beryl
5	SomeData	Carol