Another option:
Code:
select  'Leap Year' from dual
 where 28 < to_char(last_day(to_date('20040201','YYYYMMDD')),'DD')