/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

21 votes218 views4 answers
Oracle add column
SQL
0 vote205 views1 answer
Add column to table with default value plsql
SQL
15 votes210 views7 answers
MYSQL
SQL
1 vote222 views2 answers
How to check if sql query is correct online
SQL
0 vote242 views1 answer
Stored procedure function relation
SQL
3 votes202 views2 answers
Mysql add 2 hours
SQL
0 vote252 views1 answer
Mariadb.service failed with result 'exit-code'
SQL
0 vote230 views1 answer
Alter table engine mysql
SQL
20 votes235 views3 answers
How to open postgresql in mac
SQL
0 vote237 views1 answer
The fetch keyword oracle
SQL