Oracle Greatest()函數 GREATEST

are implicitly converted to the data type of the first expression before the comparison.

the data type of the first expression.

greatest (expr [, expr]...)

<dl></dl>

<dt>expr</dt>

<dd></dd>

an expression.

the following statement selects the longest string.

the following statement selects the number with the greatest value.