/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

0 vote225 views1 answer
Set mysql socket file docker windows
SQL
10 votes201 views6 answers
Between sql
SQL
0 vote207 views1 answer
Regex any word except sql
SQL
1 vote220 views1 answer
Postgresql blocked on mac
SQL
1 vote180 views1 answer
Mamp mysql path mac
SQL
0 vote270 views1 answer
SQL check if record exist
SQL
0 vote191 views1 answer
Join in update query in mysql
SQL
0 vote194 views1 answer
Avoid duplicate in one to many relationship join in sql
SQL
0 vote179 views1 answer
Python sqlalchemy orm to select null values
SQL
0 vote177 views1 answer
How to convert DateTime to VarChar SQL
SQL