today:
150
yesterday:
179
Total:
1,001,246

SQL TREE

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_ID
start with PARENT_PAGE_ID = 0

order by PARENT_PAGE_ID