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 vote137 views2 answers
Zsh: command not found: mysq
SQL
3 votes133 views1 answer
Oracle apex warning message
SQL
15 votes148 views3 answers
Create table with primary key auto increment in sql
SQL
1 vote167 views1 answer
How to fetch data in between startfromdate to starenddate in sql
SQL
7 votes161 views3 answers
Sql server check if temp table exists
SQL
-1 vote144 views1 answer
Mysql change database charset and collation
SQL
0 vote147 views1 answer
Sql server union if table exist
SQL
1 vote144 views1 answer
Show structure of table in sql
SQL
9 votes135 views2 answers
Sql limit order by
SQL
1 vote140 views2 answers
Logical operators in sql
SQL