select
d.itemid as ItemId,
d.itenname as ItenName
from dictionaryitem d
start with d.parent_id = #aa#
connect by prior d.itemid = d.parent_id
select
d.itemid as ItemId,
d.itenname as ItenName
from dictionaryitem d
start with d.parent_id = #aa#
connect by prior d.itemid = d.parent_id