today:
122
yesterday:
242
Total:
1,004,280

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