/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 vote287 views1 answer
Altrer name column postgres
SQL
1 vote258 views2 answers
Sql left characters
SQL
0 vote288 views1 answer
SQL Server Splitting a string column into multiple rows, while repeating ID column
SQL
1 vote256 views1 answer
Check message id sql server
SQL
1 vote276 views1 answer
How to delete data from sql database in android
SQL
0 vote212 views1 answer
Copy table dbeaver
SQL
0 vote259 views2 answers
Timing sql queries
SQL
0 vote316 views1 answer
Hierarchal database table
SQL
0 vote276 views1 answer
Oracle dynamic select into
SQL
18 votes263 views3 answers
Mysql number format
SQL