rem -----------------------------------------------------------------------
rem Filename:   leapyear.sql
rem Purpose:    Check if a year is a leap year
rem Author:     Frank Naude, Oracle FAQ
rem -----------------------------------------------------------------------

select year,
       decode( mod(year, 4), 0,
          decode( mod(year, 400), 0, 'Leap Year',
             decode( mod(year, 100), 0, 'Not a Leap Year', 'Leap Year')
          ), 'Not a Leap Year'
       ) as leap_year_indicator
from   my_table
/