/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 vote338 views1 answer
Sql dmv to capture updates
SQL
6 votes387 views2 answers
How to get last element sql
SQL
0 vote315 views2 answers
Which MySQL statement is used to delete data from a database
SQL
1 vote323 views1 answer
Sql delete all values in a column
SQL
3 votes528 views6 answers
Sql unique select
SQL
0 vote329 views1 answer
Postgres declare variable
SQL
1 vote312 views1 answer
Postgresql update auto_increment value
SQL
0 vote369 views1 answer
Plsql check how much space all databases are consuming
SQL
2 votes323 views1 answer
Apex date today add days
SQL
0 vote349 views1 answer
Sqlalchemy get schema from database
SQL