/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 vote365 views1 answer
Condition in orderby mysql
SQL
0 vote370 views1 answer
Print boolean in plsql
SQL
0 vote401 views1 answer
Look at running processes redshift
SQL
13 votes370 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
2 votes399 views2 answers
Oracle create table if not exists
SQL
-1 vote400 views4 answers
Full outer join in sql
SQL
0 vote337 views1 answer
Mysqlimport
SQL
6 votes364 views3 answers
Oracle all dates between two dates
SQL
0 vote326 views1 answer
Hallo
SQL
13 votes362 views3 answers
Sql select from multiple tables without join
SQL