Wednesday, 4 May 2011

Examples of Case statement in Oracle

select a,
  case
    when b = '*' then 'star'
    when b = '+' then 'plus'
    when b = '-' then 'minus'
    else '????'
  end
from test_case_when;

No comments:

Post a Comment