/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 vote349 views1 answer
Find duplicate users by email address in mysql
SQL
1 vote382 views1 answer
Delete mysql ubuntu 20.04
SQL
15 votes621 views2 answers
How to sort names in alphabetical order in sql
SQL
23 votes368 views6 answers
How to create table in sql
SQL
0 vote353 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
0 vote356 views2 answers
How do I install microsoft SQL on my Mac?
SQL
0 vote336 views1 answer
Alter table fulltext
SQL
-1 vote339 views1 answer
Mysql #1064 error
SQL
1 vote349 views2 answers
Rebuild index sql server
SQL
7 votes331 views2 answers
Get database size mysql
SQL