/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 vote192 views1 answer
Sql select where more than one record exists
SQL
10 votes196 views2 answers
Tsql merge example
SQL
4 votes161 views2 answers
Oracle set date format
SQL
0 vote178 views1 answer
Update top 100 order by sql server
SQL
0 vote179 views1 answer
SQL Query to delete all the tables in a database
SQL
15 votes283 views2 answers
Sql order by alphabetical
SQL
4 votes169 views1 answer
Mac install mysql
SQL
1 vote196 views1 answer
Postgresql export output table as a csv
SQL
0 vote212 views2 answers
Suse Linux restart MySQL
SQL
0 vote169 views1 answer
Java sql connection
SQL