/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

2 votes255 views2 answers
Mysql write into table
SQL
0 vote207 views1 answer
Sql query to get column names and data types in sql server
SQL
21 votes189 views5 answers
Oracle all tables
SQL
0 vote194 views1 answer
Sql get user account
SQL
0 vote190 views1 answer
Show database not empty tables postgres
SQL
0 vote276 views1 answer
Show all mongodb
SQL
0 vote206 views1 answer
How to change mysql root password in windows 10
SQL
0 vote218 views1 answer
Multiple like values for single column postgres
SQL
0 vote196 views1 answer
Min:sec datediff mssql
SQL
1 vote244 views2 answers
Limit sqlserver
SQL