/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

1 vote209 views1 answer
Limit offset order by mysql
SQL
0 vote208 views1 answer
Mysql join table with a text columns with ids splited by char
SQL
3 votes208 views1 answer
Force using index oracle
SQL
14 votes202 views3 answers
How to add default constraint in mysql
SQL
2 votes180 views1 answer
Alter table add column and foreign key mysql
SQL
3 votes170 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL
0 vote199 views1 answer
Disable database droping sql
SQL
0 vote178 views1 answer
Postgres call view
SQL
1 vote147 views1 answer
Ms sql how to see active job current run time
SQL
4 votes204 views2 answers
Oracle unlock account
SQL