Oracle 11g Release 2

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

CREATE TABLE Table1 ( id, week, month, year, id_x ) AS
SELECT 1, 1, 1, 2019, 7819 FROM DUAL UNION ALL
SELECT 2, 2, 1, 2019, 7819 FROM DUAL UNION ALL
SELECT 3, 3, 1, 2019, 7819 FROM DUAL UNION ALL
SELECT 4, 4, 1, 2019, 7819 FROM DUAL UNION ALL
SELECT 5, 5, 1, 2019, 7819 FROM DUAL;
5 rows affected

CREATE TABLE Table2 ( employee_id, effort, id_x, week ) AS
SELECT 63, 100, 7819, 3 FROM DUAL;
1 rows affected

SELECT t2.employee_id,
       t1.week,
       t2.effort,
       t1.id_x
FROM   Table2 t2
       PARTITION BY ( employee_id )
       RIGHT OUTER JOIN table1 t1
       ON (
             t1.week = t2.week
         AND t1.id_x = t2.id_x
       )


EMPLOYEE_ID
WEEK
EFFORT
ID_X


63
1
null
7819

63
2
null
7819

63
3
100
7819

63
4
null
7819

63
5
null
7819

EMPLOYEE_ID	WEEK	EFFORT	ID_X
63	1	null	7819
63	2	null	7819
63	3	100	7819
63	4	null	7819
63	5	null	7819