Oracle list days between two dates

-- 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 vote184 views1 answer
What is the difference between now() and current_date()?
SQL
0 vote201 views1 answer
Python mysql query to dataframe
SQL
1 vote190 views2 answers
Postgresql remote connect
SQL
0 vote234 views1 answer
How to get distinct sets of rows using SQL (Oracle)?
SQL
3 votes197 views3 answers
How to set up an auto incrementing id db browser
SQL
0 vote238 views1 answer
Id INT NOT NULL AUTO_INCREMENT
SQL
0 vote174 views1 answer
How to get initials in sql
SQL
0 vote183 views3 answers
Sql all columns
SQL
5 votes274 views1 answer
Mysql last day of next month
SQL
4 votes253 views1 answer
Alter session set nls_date_format
SQL