decode

Oracleのif文

decode(A, 0, 1, -1)

if (A == 0){
  return 1;
}else{
  return -1;
}

http://homepage2.nifty.com/sak/w_sak3/doc/sysbrd/sq_kj07_4.htm