essay
Useful PL/SQL queries
20 July 2025
In this post, I’m sharing some handy PL/SQL queries that help with monitoring and maintaining Oracle databases...
essay
Job commands in Oracle PL/SQL
2 February 2024
Here I am listing the commands using for creating, running, and fetching the scheduler jobs in Oracle database for easy reference.
essay
Data Dictionary Views in PL/SQL
21 June 2023
This is cheat sheet for data dictionary views in PL/SQL
notes
List the months between two dates - PL/SQL
11 October 2022
PL SQL Query to list the months between two dates
SELECT TO_CHAR(ADD_MONTHS(TRUNC(TO_DATE('01-JAN-22','DD-MON-YY'), 'MM'), LEVEL -1),'MON-YY')
MONTH_YEAR
FROM DUAL
CONNECT BY LEVEL <= MONTHS_BETWEEN(TO_DATE('01-DEC-22','DD-MON-YY'),
TO_DATE('01-JAN -22','DD-MON-YY')) + 1
ORDER BY LEVEL;
Result set
MONTH_YEAR
JAN-22
FEB-22
MAR-22
APR-22
MAY-22
JUN-22
JUL-22
AUG-22
SEP-22
OCT-22
NOV-22
DEC-22