/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 vote270 views1 answer
Sql query contains multiple ids
SQL
0 vote254 views1 answer
Sql create text column limited values
SQL
1 vote252 views1 answer
Sql server locks
SQL
6 votes238 views1 answer
Rank function in oracle with example
SQL
0 vote241 views1 answer
How to get all values in a table mysql in c#
SQL
-1 vote267 views5 answers
Not in sql
SQL
0 vote283 views1 answer
Mysql change default collation
SQL
3 votes248 views1 answer
Show index table
SQL
0 vote261 views1 answer
After kill process Failed to start mysqld.service: Unit mysqld.service not found.
SQL
0 vote263 views1 answer
Cross apply top for each row t1
SQL