/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

4 votes321 views1 answer
Id increment ms sql server
SQL
0 vote338 views1 answer
Sql: extract day text from datetime value
SQL
0 vote301 views1 answer
Alter table fulltext
SQL
4 votes352 views2 answers
Postgresql float data type
SQL
1 vote308 views1 answer
Mysql view command
SQL
0 vote310 views2 answers
Update query with between in mysql
SQL
0 vote298 views1 answer
Mysql show create db
SQL
0 vote356 views1 answer
Postgresql alter table sequence
SQL
0 vote292 views1 answer
Mysql delete from where like
SQL
1 vote318 views1 answer
Drop column if exists sql server
SQL