/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 vote287 views1 answer
Enable Rabbitmq management plugin
SQL
0 vote319 views1 answer
Sql injection payload list github
SQL
5 votes282 views4 answers
Sql check
SQL
0 vote302 views1 answer
Test sql query
SQL
6 votes294 views2 answers
Drop foreign key
SQL
0 vote285 views1 answer
Use between operator in mysql
SQL
0 vote355 views1 answer
Sql check if field is not null
SQL
0 vote293 views1 answer
Mysql select where field like in list
SQL
-1 vote299 views2 answers
Sql convert date to string yyyy-mm-dd
SQL
0 vote311 views1 answer
Check if record exists mysql
SQL