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

5 votes233 views1 answer
Add column table sql default value
SQL
18 votes198 views4 answers
Uninstall mysql on ubuntu
SQL
-1 vote185 views2 answers
Get day in sql
SQL
0 vote201 views1 answer
Connect laravel to mysql on mac
SQL
3 votes201 views3 answers
Postgresql random number
SQL
1 vote207 views1 answer
Oracle grant select on schema
SQL
7 votes217 views2 answers
Mysql Public Key Retrieval is not allowed
SQL
1 vote198 views1 answer
Sql count value greater than
SQL
0 vote193 views1 answer
Flask sqlalchemy remove duplicates
SQL
1 vote212 views1 answer
Get current date in pyspark sql
SQL