Oracle 21c

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

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
CREATE TABLE table_name(User_id, User_name,  Department, id_depto, id_manage) AS
SELECT 165, 'Jhonson',   'Purchasing management',    900, 900 FROM DUAL UNION ALL
SELECT 356, 'David',     'purchasing department R1', 343, 900 FROM DUAL UNION ALL
SELECT 545, 'Mary',      'purchasing department R2', 326, 900 FROM DUAL UNION ALL
SELECT 825, 'Alexander', 'Finance department',       925, 800 FROM DUAL;
4 rows affected

SELECT CONNECT_BY_ROOT user_id AS user_id,
       CONNECT_BY_ROOT user_name AS user_name,
       CONNECT_BY_ROOT department AS department,
       id_depto,
       id_manage
FROM   table_name
CONNECT BY NOCYCLE
       PRIOR id_depto = id_manage;


USER_ID
USER_NAME
DEPARTMENT
ID_DEPTO
ID_MANAGE


825
Alexander
Finance department
925
800

165
Jhonson
Purchasing management
900
900

165
Jhonson
Purchasing management
343
900

165
Jhonson
Purchasing management
326
900

356
David
purchasing department R1
343
900

545
Mary
purchasing department R2
326
900


User_id  User       Department                  id_depto   id_manage
165  Jhonson    Purchasing management   900    900
165  Jhonson    Purchasing management   343    900
165  Jhonson    Purchasing management   326    900
356  David      purchasing department R1    343    900
545  Mary       purchasing department R2    326    900
825  Alexander  Finance department          925    800
ORA-00900: invalid SQL statement

USER_ID	USER_NAME	DEPARTMENT	ID_DEPTO	ID_MANAGE
825	Alexander	Finance department	925	800
165	Jhonson	Purchasing management	900	900
165	Jhonson	Purchasing management	343	900
165	Jhonson	Purchasing management	326	900
356	David	purchasing department R1	343	900
545	Mary	purchasing department R2	326	900