/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 vote192 views1 answer
Mysql jdbc timezone
SQL
0 vote197 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL
0 vote196 views1 answer
Sql row number in result set
SQL
-1 vote213 views1 answer
Capitole toulouse
SQL
5 votes189 views3 answers
How to remove unique key constraint in mysql
SQL
1 vote193 views1 answer
Round function in sql oracle
SQL
0 vote205 views1 answer
Sql select all records from all tables where not empty
SQL
1 vote216 views1 answer
Mysql order by desc null last
SQL
2 votes182 views1 answer
Oracle sql drop column if exists
SQL
0 vote209 views1 answer
What logs are available on RDS MySQL?
SQL