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 vote360 views1 answer
Apex ORA-20999
SQL
0 vote344 views1 answer
Select count postgres double row count > 1
SQL
36 votes369 views6 answers
Delete from where sql
SQL
0 vote364 views1 answer
Postgresql auto increment not working
SQL
1 vote346 views1 answer
Set autoincrement to 0
SQL
27 votes356 views5 answers
Add column in table
SQL
0 vote350 views1 answer
Oracle SQL join three tables and group by column
SQL
0 vote354 views2 answers
What is the default password for sql server sa
SQL
11 votes360 views3 answers
Sql_mode=only_full_group_by
SQL
17 votes362 views4 answers
Postgres list users
SQL