/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 vote64 views1 answer
Mssql view column data type
SQL
0 vote113 views3 answers
Create and attach user to a postgresql database
SQL
4 votes112 views2 answers
Oracle unlock user
SQL
7 votes120 views3 answers
Convert ansi sql
SQL
0 vote103 views1 answer
Where case insensitive like mysql
SQL
0 vote114 views1 answer
Sql xampp gabungan nama awal dan akhir
SQL
3 votes73 views2 answers
Coalesce mysql
SQL
3 votes110 views1 answer
Oracle user privileges
SQL
1 vote124 views1 answer
Delete specific row in sql
SQL
0 vote108 views1 answer
How to avoid duplicate records in sqlite
SQL