Select DISTINCT(TO_NUMBER(TO_CHAR(VISIT_DATE, 'YYYY'))) as YEAR from HISTORY
| No. | Subject | Author | Date | Views |
|---|---|---|---|---|
| 6 | GitHub.com/Oracle/APEX. | admin | 2023.05.04 | 48 |
| 5 | DATE -> DAY CONVERT SQL | admin | 2023.05.25 | 47 |
| 4 | Global pages | admin | 2023.05.09 | 46 |
| 3 | ORACLE COLLECTION | admin | 2023.05.08 | 46 |
| 2 | TEST | admin | 2023.05.03 | 46 |
| » | YEAR EXPRESSIONS | admin | 2023.05.25 | 44 |
