/SQL/Oracle generate list of dates in between a date range

Oracle generate list of dates in between a date range

-- 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

39 votes425 views4 answers
Select duplicates in sql
SQL
2 votes348 views2 answers
Compare date mysql
SQL
1 vote346 views1 answer
Get the User Name and Domain Name from an Email Address
SQL
7 votes364 views1 answer
Sql pagination oracle
SQL
5 votes353 views4 answers
Sqlite3.OperationalError: near "WHERE": syntax error
SQL
0 vote361 views1 answer
Sql gather statistics to increase performance
SQL
0 vote338 views1 answer
How to check even or odd in sql
SQL
0 vote341 views1 answer
Insert array into mysql column
SQL
1 vote327 views2 answers
Mysql order by date asc null last
SQL
0 vote385 views2 answers
Mysql insert into multiple tables
SQL