Oracle 树查询

select t.*, t1.user_name as CREATOR_NAME, t2.user_name as LAST_UPDATE_USER_NAME

from t_sys_menu t

left join t_sys_user t1 on t.creator = t1.user_name

left join t_sys_user t2 on t.last_update_user = t2.user_name

where t.display_language = 'zh-CN'

start with t.parent_id = '01' connect by t.parent_id = prior t.primary_id

and t.display_language = prior t.display_language

转载于:https://www.cnblogs.com/Alex-ZJ/p/9935593.html