/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

1 vote372 views1 answer
Base64 encode sql server
SQL
7 votes350 views4 answers
Lowest salary in sql
SQL
22 votes411 views1 answer
Mysql workbench
SQL
5 votes323 views2 answers
Oracle tables with column name
SQL
1 vote409 views1 answer
Oracle columns table
SQL
0 vote317 views1 answer
Mysql events not work
SQL
0 vote315 views1 answer
Difference between cross apply and inner join
SQL
0 vote314 views0 answer
SQL
1 vote331 views1 answer
Declare variables sql
SQL
0 vote333 views1 answer
Cast as decimal postgresql
SQL