Filtering and Conditional Expressions

This section focuses on using filters and logical expressions to control what data gets returned.

  • IN, NOT IN, BETWEEN, LIKE
  • IS NULL vs = NULL
  • Logical Operators
  • CASE and DECODE
  • NULL functions