/SQL/How to get all dates in a month in oracle

How to get all dates in a month in oracle

-- 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

0 vote310 views2 answers
Oracle create tablespace autoextend
SQL
3 votes293 views2 answers
Host is not allowed to connect to this mysql server
SQL
10 votes288 views4 answers
Join with multiple conditions sql
SQL
12 votes327 views6 answers
Distinct in sql server
SQL
0 vote307 views1 answer
How to get specific salary in sql
SQL
17 votes312 views4 answers
Mysql remove ubuntu
SQL
0 vote316 views1 answer
How to find total working hour in sql
SQL
1 vote317 views1 answer
Sql server today minus n
SQL
0 vote280 views1 answer
Sql orcale i forgot what my name & password was
SQL
11 votes310 views1 answer
Oracle view source
SQL