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 vote223 views1 answer
Create dump file mysql workbench
SQL
5 votes232 views1 answer
Get table columns from sql
SQL
0 vote239 views1 answer
Pl sql disable trigger
SQL
4 votes202 views2 answers
Sql select except null
SQL
10 votes235 views2 answers
Mysql drop database if exists
SQL
0 vote215 views1 answer
Install mysql for fedora 34
SQL
0 vote234 views1 answer
Sql server rtrim everything after character
SQL
3 votes232 views2 answers
Sql server current date without time
SQL
57 votes329 views6 answers
Sql alter table
SQL
0 vote226 views1 answer
Pl/pgsql declare variable
SQL