Oracle 18c

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

CREATE TABLE EMPLOYEE(EMP_ID VARCHAR(4), EMP_NM VARCHAR(10))
INSERT INTO EMPLOYEE(EMP_ID, EMP_NM) VALUES ('101', 'EMP_1')
1 rows affected

INSERT INTO EMPLOYEE(EMP_ID, EMP_NM) VALUES ('102', 'EMP_2')
1 rows affected

INSERT INTO EMPLOYEE(EMP_ID, EMP_NM) VALUES ('103', 'EMP_3')
1 rows affected

INSERT INTO EMPLOYEE(EMP_ID, EMP_NM) VALUES ('104', 'EMP_4')
1 rows affected

CREATE TABLE TEAM_EMP_MAP (ORG_ID VARCHAR(4), EMPLOYEES VARCHAR(100))
INSERT INTO TEAM_EMP_MAP (ORG_ID, EMPLOYEES) VALUES ('1111', '101,103,104')
1 rows affected

SELECT t.ORG_ID TEAM_ID, 
       e.EMP_NM EMPLOYEE_NAME 
FROM TEAM_EMP_MAP t INNER JOIN EMPLOYEE e
ON ',' || t.EMPLOYEES || ',' LIKE '%,' || e.EMP_ID || ',%'


TEAM_ID
EMPLOYEE_NAME


1111
EMP_1

1111
EMP_3

1111
EMP_4