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

2 votes352 views1 answer
Oracle convert run_duration to number
SQL
3 votes360 views2 answers
Sql paging query
SQL
54 votes577 views6 answers
Sql rename column
SQL
3 votes346 views2 answers
Sqlite show table definition
SQL
0 vote359 views1 answer
To change the database owner in SQL server
SQL
2 votes387 views1 answer
Sql as
SQL
0 vote341 views1 answer
Getting next sequence value jpa postgress
SQL
1 vote370 views1 answer
Vagrant mysql downgrade version
SQL
2 votes376 views2 answers
Mysql add hours to time field
SQL
3 votes360 views2 answers
Brew restart mysql
SQL