Oracle9i SQL Reference Release 2 (9.2) Part Number A96540-02 |
|
|
View PDF |
least::=
LEAST
returns the least of the list of expr
s. All expr
s after the first are implicitly converted to the datatype of the first expr
before the comparison. Oracle compares the expr
s using nonpadded comparison semantics. If the value returned by this function is character data, then its datatype is always VARCHAR2
.
The following statement is an example of using the LEAST
function:
SELECT LEAST('HARRY','HARRIOT','HAROLD') "LEAST" FROM DUAL; LEAST ------ HAROLD