/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

4 votes232 views1 answer
Create table if not exist in sqlite
SQL
0 vote251 views1 answer
What does leave do in mysql
SQL
2 votes231 views3 answers
Write sql query to find the second highest salary of employee
SQL
1 vote224 views1 answer
Input in mysql
SQL
2 votes237 views2 answers
Useradd postgres
SQL
3 votes239 views2 answers
Mysql config user password
SQL
0 vote235 views2 answers
Sql drop view if exists
SQL
0 vote233 views1 answer
Replace sqlalchemy
SQL
1 vote233 views2 answers
Setval max id postgresql sequence
SQL
2 votes250 views3 answers
Sql interview query questions
SQL