/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

12 votes164 views10 answers
Google
SQL
0 vote185 views1 answer
Mysql exception output
SQL
5 votes164 views1 answer
Oracle ORA-00054 origin
SQL
0 vote176 views1 answer
Convert int to varchar sql
SQL
0 vote173 views1 answer
Sum values by month mariadb
SQL
8 votes166 views3 answers
Postgresql connection string c#
SQL
3 votes169 views2 answers
Sqlite show table definition
SQL
8 votes193 views2 answers
Mysql grant all privileges to user from any host
SQL
13 votes146 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL
1 vote167 views1 answer
Sql get missing id
SQL