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 votes306 views2 answers
Oracle drop sequence
SQL
0 vote275 views1 answer
How to check event scheduler status mysql
SQL
0 vote258 views1 answer
Postgressql uuid
SQL
0 vote268 views1 answer
Populate db from command line postgres
SQL
12 votes265 views2 answers
Delete all entries postgres
SQL
0 vote257 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL
0 vote261 views1 answer
Aktor yang pernah terlibat lebih dari 3 film di sql
SQL
17 votes311 views2 answers
T_sql contains
SQL
1 vote336 views1 answer
Mysql get max value and id
SQL
2 votes272 views1 answer
Mysql ALTER TABLE ADD COLUMN BOOLEAN AFTER DEFAULT "1";
SQL