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

14 votes222 views3 answers
Oracle sql limit results
SQL
1 vote228 views1 answer
Show databases mysql docker
SQL
0 vote231 views1 answer
Check if a column is a primary key in sql server
SQL
1 vote171 views1 answer
Database run
SQL
1 vote192 views1 answer
Truncate table in postgresql and reset id
SQL
2 votes192 views1 answer
Check isolation level in mysql
SQL
1 vote203 views1 answer
Create procedure with encryption
SQL
0 vote193 views1 answer
Create function syntax sql server
SQL
0 vote230 views1 answer
Add new column in sql with foreign key
SQL
0 vote381 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL