/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 vote182 views1 answer
LoadError: cannot load such file -- mysql2/2.7/mysql2
SQL
53 votes286 views6 answers
Sql server alter column
SQL
0 vote159 views2 answers
Sql query unique
SQL
-1 vote122 views1 answer
Mysql how to set update or create
SQL
0 vote135 views1 answer
Print sum of values sql
SQL
0 vote190 views2 answers
How to prevent sql injection in java
SQL
3 votes180 views2 answers
Get current year sql
SQL
0 vote174 views1 answer
T sql less than date
SQL
9 votes184 views3 answers
Mysql run sql file
SQL
0 vote168 views4 answers
Sql server date format yyyy-mm-dd
SQL