/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 vote271 views1 answer
Sql table to store status
SQL
0 vote333 views1 answer
Mariadb date equals to current_date plus days
SQL
0 vote325 views1 answer
Odd record sql query
SQL
0 vote331 views1 answer
Mysql max connections exceeded max_connections_per_hour
SQL
0 vote311 views1 answer
Tsql cmd exec script from file
SQL
0 vote355 views2 answers
Mysql missin expression near on
SQL
1 vote324 views1 answer
SQLite order random
SQL
0 vote302 views1 answer
Insert to first table if field A equals field B from a second table using sql
SQL
0 vote318 views1 answer
Check if table exists oracle
SQL
0 vote346 views2 answers
SQL FROM
SQL