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 votes109 views4 answers
Truncate syntax in sql
SQL
0 vote110 views2 answers
Don't know how to set rpath on your system, if MySQL libraries are not in path mysql2 may not load
SQL
26 votes350 views6 answers
Modify column name in sql
SQL
8 votes119 views1 answer
Check mysql version phpmyadmin
SQL
22 votes119 views3 answers
SQL CHEATSHEET
SQL
0 vote97 views1 answer
Sql string length postgresql
SQL
8 votes112 views1 answer
Oracle tablespace datafile max size
SQL
0 vote113 views1 answer
Less than date query sqlachemy
SQL
1 vote110 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception table not found
SQL
14 votes112 views5 answers
Sql oracle limit
SQL