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
| No. | Subject | Author | Date | Views |
|---|---|---|---|---|
| 106 | TEST | admin | 2023.04.28 | 40 |
| 105 | WHDR email address | admin | 2023.04.13 | 55 |
| 104 | TEST | admin | 2023.03.27 | 97 |
| 103 | GP 영수증 (3) -01/04/2023 | admin | 2023.01.04 | 53 |
| 102 | GP - 영수증 (2) | admin | 2022.11.07 | 63 |
| 101 | GP 영수증 본문 | admin | 2022.11.07 | 61 |
| 100 | STARTUP | admin | 2022.09.01 | 83 |
| 99 | SQL Developer Password change / EXPORT & IMPORT | admin | 2022.03.18 | 157 |
| 98 | Forgot Oracle username and password, how to retrieve? | admin | 2022.03.18 | 150 |
| 97 |
SQL DEVELOPER
 | admin | 2022.03.17 | 106 |
| 96 |
How to Install Oracle 11g on Windows 10 - 64 bit | Download / Install Oracle 11g Database
| admin | 2022.03.17 | 120 |
| 95 | QRCODE | admin | 2020.05.25 | 405 |
| 94 | JK | admin | 2019.02.05 | 700 |
| 93 | ACTION | admin | 2019.01.11 | 6454 |
| 92 | SELECT last_name FROM | admin | 2018.12.12 | 742 |
| 91 | IMP | admin | 2018.10.08 | 717 |
| 90 | CREATE TABLE | admin | 2018.09.25 | 471 |
| 89 | Change Admin PASSWORD | admin | 2018.07.31 | 225 |
| 88 | VERY IMPORTANT | admin | 2018.06.26 | 224 |
| 87 | IF/ELSE ... CASE WHEN | admin | 2018.06.25 | 208 |
