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 vote125 views1 answer
Will graphql replace sql
SQL
0 vote125 views1 answer
Bigquery declare
SQL
-1 vote73 views3 answers
Ubuntu install mssql
SQL
40 votes198 views4 answers
PostgreSQL add column
SQL
1 vote153 views1 answer
Oracle repeat_interval 5 minutes
SQL
2 votes153 views1 answer
Show max_allowed_packet mysql
SQL
0 vote143 views1 answer
Running percentage of total postgres
SQL
0 vote118 views1 answer
Lost connection to MySQL server during query when dumping table
SQL
10 votes129 views4 answers
SELECT FROM WHERE
SQL
0 vote139 views1 answer
How to create a new db from dumb file mysql
SQL