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 vote174 views1 answer
Remove default constraint sql server
SQL
0 vote183 views2 answers
How to combine diff colmun value using group by postgres
SQL
11 votes174 views1 answer
Oracle insert into where
SQL
5 votes195 views2 answers
Oracle rename table
SQL
0 vote179 views1 answer
How to drop columns with constraint from a table in sql script
SQL
0 vote218 views1 answer
Renommer schema sql
SQL
4 votes182 views2 answers
Sql vs mysql
SQL
2 votes225 views1 answer
Revokeprivileges mysql
SQL
1 vote193 views2 answers
Check if word is in column sql
SQL
7 votes182 views3 answers
Sql update where id
SQL