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 vote146 views2 answers
Mysql between
SQL
0 vote131 views1 answer
Sql convert datetime to year
SQL
0 vote136 views1 answer
Sql quary intervewi question
SQL
1 vote146 views1 answer
How to select multiple columns from different tables in mysql
SQL
0 vote133 views1 answer
Count columns psql(PostreSQL)
SQL
1 vote132 views1 answer
Deleting database in sql
SQL
0 vote129 views1 answer
Sqlcmd xml output insert line break after every 2033 characters
SQL
1 vote118 views1 answer
Tsql update datetime
SQL
1 vote164 views1 answer
Sql select sum group by id laravel
SQL
0 vote132 views2 answers
Sqlite unique
SQL