SELECT TRUNC (SYSDATE, 'YEAR') AS first_day
, ADD_MONTHS ( TRUNC (SYSDATE, 'YEAR')
, 12
) - 1 AS last_day
FROM dual;
| No. | Subject | Author | Date | Views |
|---|---|---|---|---|
| 66 | JAVA for delete | admin | 2016.04.28 | 181 |
| 65 | Delete Message - Are you sure you want to delete this object? | admin | 2016.04.28 | 181 |
| 64 | DELETE PROCESS | admin | 2016.04.28 | 180 |
| 63 | TAP ( Main & Sub ) / Button 의 Switch | admin | 2016.04.28 | 179 |
| 62 | INSERT PROCESS | admin | 2016.04.28 | 176 |
| 61 | NVL | admin | 2016.05.19 | 175 |
| 60 | MAX | admin | 2016.04.28 | 174 |
| 59 | Column Data 일괄 추가 | admin | 2023.11.24 | 173 |
| 58 | SQL SELECT DISTINCT Statement | admin | 2016.04.29 | 173 |
| 57 | COUNT | admin | 2016.04.28 | 170 |
| 56 | wwv_flow_files | admin | 2016.05.01 | 168 |
| 55 | PHONE NUMBER | admin | 2016.04.28 | 168 |
| 54 | CREATE (INSERT) PROCESS | admin | 2016.04.28 | 167 |
| 53 | SQL Developer Password change / EXPORT & IMPORT | admin | 2022.03.18 | 167 |
| 52 | How to Update Oracle XE | admin | 2018.04.25 | 161 |
| 51 | Null Display Value | admin | 2024.01.10 | 160 |
| 50 | BOOLEAN SAMPLE | admin | 2016.05.11 | 160 |
| 49 | Field Showing | admin | 2016.04.01 | 160 |
| 48 | Forgot Oracle username and password, how to retrieve? | admin | 2022.03.18 | 158 |
| » | LAST DAY SQL | admin | 2024.01.19 | 157 |
