/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 vote194 views1 answer
Drop all triggers oracle
SQL
0 vote208 views1 answer
How to inner join 4 tables in sql
SQL
11 votes209 views5 answers
Sql server reset identity
SQL
0 vote195 views1 answer
Const pool = mysql.createpool()
SQL
0 vote229 views1 answer
Mysql random number between 1 and 100
SQL
0 vote246 views3 answers
Constraint sql
SQL
0 vote175 views5 answers
Sql table intermédiaire
SQL
1 vote198 views1 answer
Oracle stop job
SQL
0 vote297 views1 answer
Site:av.ru "files"
SQL
1 vote189 views1 answer
Apex ORA-20999
SQL