| 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 | ||