/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

1 vote196 views1 answer
Mysql strict_trans_tables
SQL
0 vote197 views1 answer
Migration graphql
SQL
2 votes176 views1 answer
Oracle table size
SQL
1 vote171 views1 answer
Sql not equal multiple columns
SQL
28 votes177 views4 answers
Delete database mysql
SQL
5 votes178 views1 answer
Oracle get nls settings
SQL
1 vote216 views1 answer
Mysql show long running queries
SQL
5 votes229 views1 answer
Oracle ora-00054 resource busy
SQL
10 votes183 views2 answers
Sql rtrim
SQL
0 vote176 views2 answers
Mysql updating multiple column values from array variable
SQL