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 vote354 views1 answer
Mysql vs sql server performance benchmark
SQL
15 votes307 views2 answers
How to know the username of postgresql
SQL
1 vote328 views1 answer
Psql lst trigger
SQL
3 votes343 views1 answer
Oracle APEX elapsed time
SQL
5 votes314 views2 answers
Mysql drop table cascade
SQL
0 vote320 views1 answer
SQL Server Altering Column to be Unique
SQL
0 vote303 views1 answer
Sql compound operators
SQL
53 votes631 views6 answers
How to install mysql ubuntu
SQL
1 vote290 views1 answer
Postgres kill pid
SQL
8 votes324 views1 answer
Oracle add months to sysdate
SQL