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 vote177 views1 answer
Sql server roles and users
SQL
0 vote171 views1 answer
Sql server datetime to string
SQL
2 votes205 views1 answer
Oracle Column Names of a table
SQL
0 vote167 views1 answer
Docker ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
SQL
0 vote186 views1 answer
Calculate age in sql
SQL
2 votes177 views1 answer
Sql update from different table
SQL
17 votes158 views6 answers
Sql current date
SQL
3 votes175 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL
0 vote241 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
1 vote172 views2 answers
ImportError: No module named mysql.connector
SQL