/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

0 vote183 views1 answer
How to add auto increment primary key
SQL
0 vote124 views1 answer
Change date format in oracle query
SQL
0 vote132 views1 answer
Get the previous column of a table in mysql
SQL
0 vote120 views1 answer
Mysql locate
SQL
1 vote137 views5 answers
Sql 2nd highest salary
SQL
0 vote178 views1 answer
Radius search with point data in mysql
SQL
3 votes135 views2 answers
How to force truncate a table in mysql
SQL
2 votes136 views2 answers
Mysql add hours to time field
SQL
0 vote154 views1 answer
SQL Cut part string
SQL
0 vote185 views1 answer
Import sql dump into postgresql database
SQL