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 vote176 views1 answer
Oracle call a function in a insert statement
SQL
2 votes188 views1 answer
Add default sql server
SQL
1 vote202 views1 answer
Moodle query first user access
SQL
0 vote180 views1 answer
Asp.net core sql server stored procedure
SQL
3 votes211 views2 answers
Sqlite show table definition
SQL
1 vote183 views2 answers
Sql left characters
SQL
0 vote174 views1 answer
Pgadmin see indexes
SQL
1 vote171 views1 answer
Ilike for date postgres
SQL
0 vote173 views1 answer
Mysql export and import
SQL
-1 vote196 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL