select PAGE_ID,
       PARENT_PAGE_ID ,
       PAGE_NAME name     
from DEMO_PAGE_HIERARCHY

 connect by prior PAGE_ID = PARENT_PAGE_ID
start with PARENT_PAGE_ID = 0

order by PARENT_PAGE_ID

I want to