admin 2016.05.18 09:55 Views : 722
select PAGE_ID, PARENT_PAGE_ID , PAGE_NAME name from DEMO_PAGE_HIERARCHY connect by prior PAGE_ID = PARENT_PAGE_IDstart with PARENT_PAGE_ID = 0order by PARENT_PAGE_ID