/SQL/How to get all dates in a month in oracle

How to get all dates in a month in oracle

-- All dates between 01/01/2021 and 15/01/2021
SELECT to_date('01/01/2021', 'DD/MM/YYYY') + ROWNUM - 1
FROM ALL_OBJECTS
WHERE ROWNUM <= to_date('15/01/2021', 'DD/MM/YYYY') 
	- to_date('01/01/2021', 'DD/MM/YYYY') + 1;

Similar codes

1 vote191 views1 answer
How to print longest name in sql
SQL
8 votes208 views10 answers
Sql
SQL
0 vote177 views1 answer
Select value from previous row in postgresql
SQL
0 vote201 views1 answer
Mysql readable output
SQL
0 vote221 views3 answers
Postgres date difference seconds
SQL
4 votes203 views1 answer
Refresh postgres config
SQL
0 vote213 views1 answer
Dataframe lambda elif
SQL
0 vote200 views1 answer
UNION ALL LEFT JOIN
SQL
2 votes183 views1 answer
Convert series number to date in sql
SQL
0 vote204 views1 answer
How to drop a trigger in postgresql
SQL