/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 vote283 views1 answer
Count in sql and diff
SQL
-2 votes267 views1 answer
Mysql see users and passwords
SQL
0 vote281 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
0 vote262 views1 answer
C# datetime to sql server datetime
SQL
0 vote277 views1 answer
Postgres read table structure
SQL
10 votes289 views2 answers
SQL rounding numbers
SQL
0 vote292 views1 answer
Oracle 11g forget password
SQL
4 votes257 views1 answer
Create column mysql terminal
SQL
1 vote264 views1 answer
How to select department from table
SQL
-1 vote280 views1 answer
Mysql case when multiple conditions
SQL