/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 vote193 views1 answer
View to table sql
SQL
0 vote176 views5 answers
Mode sql course
SQL
0 vote171 views1 answer
Show the colums of table sql
SQL
0 vote167 views1 answer
How to use group_concat in sql server
SQL
0 vote213 views1 answer
Postgres truncate with cascade
SQL
7 votes179 views4 answers
Index in mysql
SQL
7 votes173 views2 answers
Create index mysql
SQL
0 vote174 views1 answer
Write a query to peint the pattern P(20)
SQL
0 vote178 views1 answer
Hoq to import database source
SQL
3 votes175 views1 answer
Show index table
SQL