/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 vote199 views1 answer
Create function in microsoft sql server
SQL
1 vote185 views1 answer
Lpad function in sql oracle
SQL
0 vote178 views1 answer
How to find total working hour in sql
SQL
0 vote190 views1 answer
To Create directory
SQL
0 vote186 views1 answer
Python sqlalchemy connection show server
SQL
5 votes169 views1 answer
Commentaire table oracle
SQL
0 vote181 views1 answer
Create dump file mysql workbench
SQL
0 vote157 views1 answer
Opening xampp mysql in cmd ubuntu
SQL
0 vote198 views1 answer
Mysql last friday of current month
SQL
24 votes173 views4 answers
Postgres delete database
SQL