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

16 votes366 views6 answers
Install sqlite3 python
SQL
0 vote414 views2 answers
How to check if a column exists in a SQL Server table?
SQL
0 vote345 views2 answers
The metadata storage is not up to date, please run the sync-metadata-storage command to fix this issue.
SQL
3 votes360 views5 answers
Import MySQLdb as Database ModuleNotFoundError: No module named 'MySQLdb'
SQL
0 vote362 views1 answer
How to select a row in sql
SQL
0 vote349 views1 answer
Sql remove last 2 digit
SQL
0 vote352 views1 answer
What is default mysql database password in linux
SQL
1 vote354 views2 answers
Laravel get sql query eloquent with parameters
SQL
0 vote340 views1 answer
Min salary in sql
SQL
6 votes342 views1 answer
Oracle rank() over (partition)
SQL