2011-11-4 LEAST function

Http://www.itpub.net/thread-1499223-12-1.html

113th floor

The following options implement this process:

CREATE OR REPLACE PROCEDURE plch_show_lowest (number1_in IN NUMBER, number2_in IN NUMBER, number3_in IN NUMBER) IS

Which can display the smallest of the three numbers passed in? Assume that none of the actual values passed to plch_show_lowest are empty.

(A)

BEGIN DBMS_OUTPUT.put_line (LEAST (number1_in, LEAST (number2_in, number3_in)); END

(B)

BEGIN DBMS_OUTPUT.put_line (SMALLEST (number1_in, number2_in, number3_in); END

(C)

BEGIN DBMS_OUTPUT.put_line (MIN (number1_in, number2_in, number3_in); END

(D)

L_lowest NUMBER;BEGIN SELECT LEAST (number1_in, number2_in, number3_in) INTO l_lowest FROM DUAL; DBMS_OUTPUT.put_line (l_lowest); END

(E)

L_lowest NUMBER: = number1_in;BEGIN IF number2_in < l_lowest THEN l_lowest: = number2_in; END IF; IF number3_in < l_lowest THEN l_lowest: = number3_in; END IF; DBMS_OUTPUT.put_line (l_lowest); END

(F)

BEGIN DBMS_OUTPUT.put_line (LEAST (number1_in, number2_in, number3_in); END

Actual measurement

B error PLS-00201: identifier 'SMALLEST' must be declared

C error PLS-00103: the symbol ")" is required at one of the following:: =. (%; symbol "(" replaced by ")" to continue.

ADEF are all correct.