CASE
  WHEN boolean_expression THEN result_value
[ WHEN boolean_expression THEN result_value]... 
[ ELSE result_value]
END
Oracle
Copyright © 1996, 2012, Oracle and/or its affiliates. All rights reserved.
Legal Notices