How to convert month number to full month name in oracle?

SELECT TO_CHAR(TO_DATE(7, 'MM'), 'MONTH') AS monthname FROM DUAL;

outputs

monthname
---------
JULY

If you really want the month names in lower case or capitalised, you can also use:

TO_CHAR(TO_DATE(7, 'MM'), 'month')
TO_CHAR(TO_DATE(7, 'MM'), 'Month')

Related