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

1 vote229 views3 answers
How to pass password to mysql command line
SQL
4 votes310 views2 answers
Convert utc to est sql
SQL
0 vote186 views1 answer
Ms sql database data size
SQL
1 vote201 views1 answer
Delete row mssql
SQL
0 vote192 views1 answer
Sql inserted
SQL
0 vote266 views1 answer
How do you insert boolean to postgresql
SQL
-1 vote200 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
1 vote208 views1 answer
How to subtract from the value of a table in sql
SQL
0 vote192 views1 answer
Power query case when
SQL
0 vote186 views1 answer
Check if table exists oracle
SQL