UPDATE dept A
SET parent_depe_name =
(SELECT B.depe_name FROM (SELECT * FROM dept ) B WHERE B.dept_id = A.parent_depe_id)
WHERE A.parent_depe_name IS NULL;
UPDATE dept A
SET parent_depe_name =
(SELECT B.depe_name FROM (SELECT * FROM dept ) B WHERE B.dept_id = A.parent_depe_id)
WHERE A.parent_depe_name IS NULL;