/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 vote167 views1 answer
Authentication modes in sql server
SQL
0 vote99 views1 answer
Sql count how many times a value appears
SQL
0 vote133 views1 answer
Report in database
SQL
7 votes142 views2 answers
Create index mysql
SQL
2 votes143 views1 answer
Add default sql server
SQL
0 vote141 views1 answer
How to add more columns to a table in mysql
SQL
16 votes139 views6 answers
Mysql find and replace
SQL
11 votes140 views1 answer
Ddl materialized view
SQL
0 vote169 views1 answer
Wordpress sql find and replace
SQL
4 votes127 views1 answer
Search column by name mysql
SQL