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 vote307 views2 answers
How to create a table from another table in sql derby
SQL
0 vote310 views1 answer
Template MySQL Zabbix agent
SQL
1 vote317 views1 answer
Sql select all from one table and one column from another
SQL
0 vote310 views1 answer
Oracle archivelog usage
SQL
0 vote354 views1 answer
Wordpress make wp user in db
SQL
1 vote354 views1 answer
Oracle select first row order by
SQL
0 vote292 views1 answer
How to increase the width of the screen in oracle
SQL
5 votes303 views1 answer
Oracle ORA-00054 origin
SQL
12 votes323 views2 answers
Insert multiple rows from another table sql
SQL
2 votes299 views2 answers
Mysql date range
SQL