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 vote76 views1 answer
Sql select rows with simlar names
SQL
0 vote126 views1 answer
Get who is hired in february in sql
SQL
1 vote138 views1 answer
Oracle activate job
SQL
2 votes108 views1 answer
Postgresql left join distinct on
SQL
1 vote132 views1 answer
T-sql disable system versioning
SQL
0 vote113 views1 answer
Sql server convert date to weekday
SQL
5 votes126 views2 answers
Mysql where in array
SQL
0 vote116 views1 answer
Oracle current timestamp insert statement
SQL
0 vote113 views1 answer
How to declare variable date in mysql
SQL
21 votes122 views5 answers
Oracle all tables
SQL