/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 vote257 views1 answer
Update database collation in postgresql
SQL
0 vote421 views1 answer
Redirection 301 htaccess nom de domaine
SQL
0 vote198 views2 answers
Sql use not in
SQL
0 vote215 views1 answer
Sql server alter table add column tinyint
SQL
0 vote197 views1 answer
Postgres jsonb array push new element
SQL
61 votes1.2K views6 answers
Mysql add column
SQL
0 vote207 views1 answer
Mysql add root password
SQL
0 vote198 views1 answer
Oracle drop default value
SQL
0 vote217 views2 answers
Postgresql get long running queries
SQL
2 votes251 views1 answer
Oracle Column Names of a table
SQL