PL/SQL Query to ADD Month to a Period Name

Summary:

I have a scenario where a user will pass input period name. The query should return data of both the current period entered by the user and the previous period.

User entered : Aug-24
output : Aug-24, Jul-24

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):