SELECT decode(TO_CHAR(TO_DATE('11-JUN-00','DD-MON-YY'),'MONTH') ,
'FEBRUARY','02',
'JUNE', '06',
'APRIL', '04',
'JULY', '07',
'LAST OPTION' ) FROM DUAL
The expected output of the above query is 06, But it is displaying LAST OPTION. What is the wrong with above query?