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

3 votes151 views1 answer
Sql calculate working days between two dates excluding weekends and holidays
SQL
59 votes344 views6 answers
Alter table sql
SQL
0 vote225 views1 answer
Site:av.ru "files"
SQL
94 votes200 views4 answers
Create database postgres
SQL
1 vote148 views1 answer
Postgres convert date to string
SQL
0 vote175 views1 answer
Mysql get hour from datetime
SQL
1 vote139 views1 answer
Loading local data is disabled mysql
SQL
-1 vote153 views1 answer
Sql select data from one database and insert into a different database
SQL
0 vote152 views1 answer
Ms sql filter all sympbol
SQL
0 vote138 views1 answer
Mysqldump ignore table
SQL