/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 vote233 views1 answer
Oracle to_number
SQL
0 vote221 views1 answer
Update table sql multiple set
SQL
1 vote240 views3 answers
Nth highest salary
SQL
0 vote218 views1 answer
Back up stored procedures mysql
SQL
1 vote228 views2 answers
ImportError: No module named mysql.connector
SQL
16 votes236 views3 answers
Tsql rename column name
SQL
2 votes227 views1 answer
Oracle apex list connected users
SQL
-1 vote221 views3 answers
Update mongodb version ubuntu
SQL
0 vote232 views1 answer
Sql change column in existing table
SQL
0 vote241 views1 answer
Sqlite trim
SQL