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 vote181 views1 answer
Vagrant mysql downgrade version
SQL
0 vote181 views1 answer
Oracle procedure teamplate
SQL
5 votes182 views1 answer
Oracle list packages
SQL
1 vote265 views1 answer
How to select the nth row in a SQL database table?
SQL
0 vote196 views1 answer
Regex any word except sql
SQL
1 vote227 views1 answer
Sql server: difference between hashtable and table declared using declare keyword
SQL
2 votes211 views1 answer
Oracle current date without time
SQL
0 vote176 views1 answer
Pl/ sql change currency
SQL
0 vote184 views1 answer
Oracle sql add column auto generated value
SQL
0 vote178 views1 answer
Sql select min
SQL