Oracle General Comparison Functions

General comparison functions determine the maximum and/or minimum values in a set of values. This page summarizes the general comparison functions available in Oracle.

  1. GREATEST

    Oracle GREATEST() is a built-in function that returns the maximum value from a given list of parameters.

  2. LEAST

    Oracle LEAST() is a built-in function that returns the minimum value from a given list of parameters.