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 vote226 views1 answer
Install sql server windows 10
SQL
1 vote250 views1 answer
Opensuse restart MySQL
SQL
1 vote225 views1 answer
Oracle update with sequence
SQL
12 votes228 views10 answers
Google
SQL
0 vote229 views1 answer
SQL Server Altering Column to be Unique
SQL
1 vote214 views1 answer
Check constraint to check if date greater than todays date
SQL
2 votes244 views1 answer
Drop all foreign key constraints mysql
SQL
0 vote218 views1 answer
Oracle last character of string
SQL
0 vote264 views1 answer
Postgresql alter table sequence
SQL
0 vote235 views1 answer
Mysql 8 geo to json
SQL