3,492
社区成员
发帖
与我相关
我的任务
分享
with t as
(select 10000 role_id, null parent_role_id, '01' roleno
from dual
union all
select 100001 role_id, 10000 parent_role_id, '0101' roleno
from dual
union all
select 100002 role_id, 10000 parent_role_id, '0102' roleno
from dual
union all
select 100003 role_id, 100001 parent_role_id, '010101' roleno from dual)
select t2.*,
(select roleno from t t1 where t1.role_id = t2.parent_role_id) parent_roleno
from t t2