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 vote303 views1 answer
Change date format in oracle query
SQL
0 vote314 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL
1 vote294 views2 answers
Mysql grant all privileges on *.* to 'root'@' ' identified by
SQL
0 vote302 views1 answer
Sqlite woth cmake
SQL
1 vote322 views1 answer
Sql select sum group by id laravel
SQL
0 vote269 views1 answer
Create sql table from script inline primary key constraint
SQL
11 votes280 views1 answer
Oracle view ddl
SQL
1 vote284 views2 answers
Group_concat limit mysql
SQL
0 vote257 views1 answer
Sqlite referential integrity
SQL
0 vote291 views1 answer
Sql alchemy escape ; in insert statement
SQL