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 vote178 views3 answers
Divide by zero error in sql
SQL
1 vote142 views1 answer
Sql server select rows by distinct column
SQL
1 vote157 views2 answers
OSError: mysql_config not found mysql_config --version mariadb_config --version mysql_config --libs ---------------------------------------- ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command outpu
SQL
1 vote150 views1 answer
How to remove identity from a column in sql server
SQL
12 votes148 views4 answers
Mysql ifnull
SQL
0 vote161 views1 answer
Android studio SQLiteDatabase delete all data in database
SQL
1 vote152 views1 answer
How to subtract from the value of a table in sql
SQL
3 votes143 views2 answers
Mysql add 2 hours
SQL
3 votes161 views1 answer
Sql calculate working days between two dates excluding weekends and holidays
SQL
5 votes172 views1 answer
Oracle asynchronous query
SQL