Oracle9i SQL Reference Release 2 (9.2) Part Number A96540-01 |
|
Functions, 61 of 177
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
|
Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved. |
|