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 vote169 views1 answer
Django mysqlclient connection string
SQL
1 vote186 views1 answer
Sql list all procedures
SQL
0 vote171 views1 answer
How to get specific salary in sql
SQL
0 vote169 views1 answer
Sql trying to delete database in use
SQL
0 vote184 views1 answer
Allow null in psql
SQL
10 votes153 views2 answers
Sql merge statement
SQL
0 vote298 views1 answer
Oracle sql alter view add column
SQL
8 votes166 views2 answers
Phpmyadmin default password
SQL
1 vote168 views2 answers
Mysql: command not found
SQL
2 votes173 views2 answers
Sql strip non alphanumeric characters
SQL