/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

3 votes137 views1 answer
Oracle undo tablespace schema
SQL
0 vote126 views1 answer
Sql recherche nom prenom
SQL
0 vote149 views1 answer
How to get parent and child record in single query using sql
SQL
0 vote130 views1 answer
Ajax error exception handeling
SQL
0 vote130 views1 answer
Select * from mysql.proc
SQL
0 vote103 views1 answer
Separator mysql
SQL
2 votes126 views1 answer
Oracle sql drop column if exists
SQL
0 vote123 views1 answer
Mysql workbench view
SQL
1 vote148 views2 answers
Create table if not exist
SQL
5 votes112 views2 answers
Oracle list columns schema
SQL