consider CASE statements (SQL and PL/SQL)