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

12 votes168 views5 answers
Sql primary key
SQL
6 votes172 views1 answer
Rank function in oracle with example
SQL
0 vote181 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL
0 vote176 views1 answer
Postgresql add not null and not empty constraint
SQL
3 votes194 views1 answer
Postgres count distinct
SQL
1 vote184 views2 answers
Grab part of a string sql
SQL
0 vote185 views2 answers
Postgres show current role
SQL
5 votes183 views1 answer
Mysql count newlines in field
SQL
0 vote201 views1 answer
No query unable to fetch row sqlite
SQL
2 votes170 views3 answers
Postgres remove foreign key constraint
SQL