For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
select level lvl,lpad(' ',5*(level-1)) || to_char(a.childcd) cd, lpad(' ',5*(level-1))||a.childnm nm from tabname a start with a.childnm = :child connect by prior a.childcd=a.parentcd;