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

1 vote221 views1 answer
How not to sort by average rating
SQL
4 votes197 views1 answer
Oracle select first 10 rows
SQL
0 vote189 views1 answer
Sql server alter table column nullable
SQL
9 votes190 views1 answer
Sql server get utc date
SQL
0 vote192 views1 answer
Create table sql generator
SQL
7 votes180 views3 answers
Add primary key to database sql
SQL
4 votes203 views3 answers
How to describe a table in sqlite3
SQL
0 vote205 views7 answers
10 random questions use python and SQL
SQL
0 vote199 views2 answers
2nd max salary query in sql
SQL
0 vote200 views1 answer
Cursor.execute (sql, value) ValueError: operation parameter must be str
SQL