/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

2 votes304 views2 answers
How to run postgresql in linux
SQL
2 votes301 views2 answers
Storing timezones in postgres
SQL
0 vote270 views1 answer
Show function mysql
SQL
4 votes303 views1 answer
List tables sqlite
SQL
2 votes298 views1 answer
Sqlite3 show columns name
SQL
0 vote295 views1 answer
Find usage of table in sql server
SQL
0 vote299 views1 answer
Mysql extract day from date leading zero
SQL
5 votes271 views2 answers
Update all rows mysql
SQL
0 vote276 views1 answer
T-SQL Retry (deadlock)
SQL
5 votes299 views2 answers
Mysql create database charset utf8mb4
SQL