Hi,
I am a junior dev. and I need help on some select statements on a Oracle db.
First I needed to get all the months of the year in 'MON' format and I did it like this:
SELECT DISTINCT TO_CHAR(dt,'MON') MONTH
FROM ( SELECT TRUNC(SYSDATE,'y')-1+ROWNUM dt
FROM all_objects
WHERE ROWNUM <= 366)
ORDER BY TO_DATE( MONTH, 'MON' )
Now, I need another statements to get only the month that have 31 days, then 30 days the leap year.
I cannot create strings that have the names like JANFEBMAR.. and then compare because we use this in a multilingual environment.
Any help would be appreciate it.
Unsolved 
