/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

14 votes366 views3 answers
Oracle sql limit results
SQL
0 vote390 views1 answer
Min mysql
SQL
0 vote366 views2 answers
Tsql row number
SQL
1 vote348 views1 answer
Full sql mode
SQL
1 vote366 views1 answer
Launch sql script from docker in mysql
SQL
0 vote370 views1 answer
MySQL import data from large CSV file
SQL
0 vote378 views1 answer
SQL Server Enterprise
SQL
1 vote370 views3 answers
Divide by zero error in sql
SQL
1 vote342 views1 answer
Varchar plsql
SQL
0 vote365 views1 answer
Pl sql round
SQL