Oracle LAST_DAY function
select LAST_DAY('08-MAR-08') from dualresult : 31-MAR-08
select LAST_DAY('01-FEB-08') from dualresult : 29-FEB-08
More functions: Oracle ASCII function | Oracle DECODE function | Oracle INSTR function