Oracle9i SQL Reference Release 1 (9.0.1) Part Number A90125-01 |
|
Functions, 59 of 166
least::=
least
LEAST
returns the least of the list of exprs. All exprs after the first are implicitly converted to the datatype of the first expr before the comparison. Oracle compares the exprs using nonpadded comparison semantics. If the value returned by this function is character data, 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
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|