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 vote137 views1 answer
Postegresql update to null
SQL
0 vote129 views1 answer
Sqlite to csv statement
SQL
0 vote157 views2 answers
Mysql insert into multiple tables
SQL
0 vote127 views1 answer
Mysql last 6 months
SQL
0 vote144 views1 answer
Guid string to binary better
SQL
1 vote132 views1 answer
Rows to comma separated values in mssql
SQL
0 vote136 views4 answers
Mysql on kubernetes
SQL
0 vote151 views1 answer
Unable to convert mysql date/time value to system.datetime
SQL
1 vote133 views2 answers
Sql for date greater than
SQL
3 votes145 views4 answers
Show databases in sql server
SQL