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 vote148 views1 answer
Postgresql combine values in one field
SQL
-1 vote181 views2 answers
Sql search all tables for attributes
SQL
0 vote139 views1 answer
Mysql server not starting in xampp in mac
SQL
3 votes149 views2 answers
Sql random integer
SQL
0 vote214 views1 answer
Example database query
SQL
0 vote153 views1 answer
Add timestamp column to existing table t-sql
SQL
0 vote275 views1 answer
Oracle convert int to date
SQL
8 votes139 views3 answers
Postgresql connection string c#
SQL
0 vote185 views1 answer
How to check event scheduler status mysql
SQL
4 votes139 views1 answer
Select nls_date_format
SQL