How to get all dates in a month in Oracle?
Use connect by clause to get all the dates in a month in Oracle. Below are the examples: Example-1: The following SQL query uses the trunc() function to get the numeric month value with connect by clause to get all the dates in a month: SELECT TRUNC(SYSDATE, 'MM') + LEVEL - 1 AS day FROM ... Read more