oracle 根据出生年份计算生肖

第一种方法：

select decode(mod(1996, 12),

              0,
              '猴',
              1,
              '鸡',
              2,
              '狗',
              3,
              '猪',
              4,
              '鼠',
              5,
              '牛',
              6,
              '虎',
              7,
              '兔',
              8,
              '龙',
              9,
              '蛇',
              10,
              '马',
              11,
              '羊') sx

  from dual;

第二种方法：

select substr(to_char('鼠牛虎兔龙蛇马羊猴鸡狗猪'),
mod(to_number(to_char(to_date('1996', 'yyyy'),'yyyy'))-1900,12)+1,1) from dual;