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

1 vote258 views1 answer
Mysql tables max count
SQL
0 vote257 views1 answer
Oracle to_number
SQL
0 vote276 views4 answers
Creating a comment and reply system PHP and MySQL
SQL
0 vote251 views1 answer
Update using case in mysql
SQL
0 vote258 views1 answer
Set Mamp mysql globally
SQL
12 votes242 views1 answer
How to change the value of a table in sql
SQL
0 vote253 views1 answer
Sql select min
SQL
4 votes289 views4 answers
Remove duplicate old value in mysql
SQL
1 vote271 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL
1 vote284 views1 answer
Opensuse restart MySQL
SQL