Eine Einführung in

SQL

Conditional values

Oracle
The SQL Standard is the CASE statement


Specific to Oracle
The DECODE function is also available:
SELECT title, 
       score,
       DECODE(SIGN(score-8.5),
              1,  'Excellent',
	      0,  'OK',
	      -1, 'OK')
   FROM movie
   WHERE 10>id