Leap years in the Oracle database

Leap years in the Oracle database

This year 2024 is a leap year.   SQL> SELECT LAST_DAY(TO_DATE(’01/02/2024′,’DD/MM/YYYY’)) FECHA FROM DUAL; FECHA —————————– Thursday, 29 February 2024 In fact, each year divisible by four is a leap year, but throughout history many adjustments occurred to the...
Unordered sorts

Unordered sorts

For the result of an SQL query to be ordered, the only valid clause is ORDER BY. Oracle only guarantees the ordered return of rows when ORDER BY is set as the sort criteria. I have repeated these two phrases like a mantra thousands of times. Any other way to get the...