/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 vote252 views1 answer
Call function sql oracle with output put line
SQL
5 votes229 views3 answers
Sql server utc to local
SQL
0 vote203 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
0 vote209 views2 answers
What is 1=2 in sql
SQL
3 votes171 views1 answer
How to remove characters from string in mysql
SQL
1 vote194 views1 answer
Mysql add fields
SQL
0 vote212 views1 answer
Sql tablo hangi sp de
SQL
5 votes180 views1 answer
Commentaire table oracle
SQL
4 votes208 views1 answer
Mysql set max connections
SQL
0 vote188 views1 answer
Prodection ready postgres database step by step
SQL