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 vote328 views3 answers
Constraint sql
SQL
6 votes308 views2 answers
Mysql 1 day ago
SQL
2 votes280 views1 answer
While loop sql
SQL
0 vote312 views1 answer
Soql queries for not contact related account records in salesforce
SQL
11 votes283 views2 answers
Having in sql
SQL
0 vote281 views1 answer
Grepper sql workbench download
SQL
0 vote340 views1 answer
Com.mysql.cj.exceptions.InvalidConnectionAttributeException more than one time zone. You must configure either the server or JD value if you want to utilize time zone support.
SQL
0 vote336 views1 answer
Sql datum formatieren
SQL
0 vote266 views1 answer
How to get n result in sql
SQL
1 vote309 views3 answers
Sql union
SQL