/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 vote298 views1 answer
Dasebase_url-postgres for windows
SQL
1 vote297 views1 answer
Postgresql last element of array
SQL
0 vote289 views1 answer
INSERT INTO table using OpenQuery
SQL
4 votes302 views1 answer
Oracle select first 10 rows
SQL
0 vote307 views1 answer
Create database store
SQL
0 vote335 views1 answer
Add week ending date sql server
SQL
0 vote304 views1 answer
Lesser than or equal to symbol in postgres
SQL
1 vote308 views2 answers
How to search date in sql query
SQL
8 votes316 views3 answers
Alter user root mysql
SQL
0 vote304 views1 answer
Sql revert migration
SQL