Oracle list days between two dates

-- 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 vote323 views2 answers
Insert into
SQL
0 vote344 views1 answer
Closure in sql
SQL
2 votes347 views2 answers
Mysql add hours to time field
SQL
1 vote323 views3 answers
Psql fatal database does not exist
SQL
4 votes326 views2 answers
Postgresql reset sequence
SQL
0 vote338 views1 answer
Get db connection detail from sql developer profile
SQL
1 vote334 views1 answer
Find difference in dates sql
SQL
0 vote359 views1 answer
Postgresql find biggest table
SQL
4 votes298 views2 answers
Select todays data postgres query
SQL
0 vote312 views1 answer
How to remove default in mysql
SQL