select t.code from (
select
p.plan_code code,
p.plan_parent_code parentCode
from
t_plan
where comments='comment'
) t start with code ='00'
connect by prior code = parentCode
order by code asc
select t.code from (
select
p.plan_code code,
p.plan_parent_code parentCode
from
t_plan
where comments='comment'
) t start with code ='00'
connect by prior code = parentCode
order by code asc