/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 vote220 views1 answer
Como verificar registros duplicados no sql postgresql
SQL
2 votes246 views1 answer
Sql server current date minus 5 years
SQL
0 vote233 views2 answers
Android sqlite query join
SQL
0 vote227 views1 answer
Get server date mysql
SQL
0 vote239 views1 answer
Oserror mysql_config not found virtualenv
SQL
0 vote255 views2 answers
What is rownum in oracle
SQL
0 vote227 views1 answer
Minecraft duping allowed servers
SQL
1 vote240 views3 answers
Mysql connection string
SQL
0 vote222 views1 answer
Hive batch drop table
SQL
1 vote244 views1 answer
Print all records of table in mysql
SQL