/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 vote254 views1 answer
Can sqldatareader be null
SQL
1 vote264 views1 answer
Flask sqlalchemy default value
SQL
1 vote250 views1 answer
Sql select contem uma palavra
SQL
0 vote246 views2 answers
What is 1=2 in sql
SQL
0 vote261 views1 answer
Sql case sttement with set
SQL
0 vote223 views2 answers
Sql update from two different database
SQL
1 vote246 views1 answer
Oracle first row
SQL
0 vote280 views2 answers
List all constraints in postgres
SQL
0 vote271 views1 answer
Sql filter rows with condition
SQL
0 vote255 views1 answer
Oracle merge insert if not exists
SQL