QUESTION 102
Examine this function:
CREATE OR REPLACE FUNCTION CALC_PLAYER_AVG
(V_ID in PLAYER_BAT_STAT.PLAYER_ID%TYPE)
RETURN NUMBER
IS
V_AVG NUMBER;
BEGIN
SELECT HITS / AT_BATS
INTO V_AVG
FROM PLAYER_BAT_STAT
WHERE PLAYER_ID = V_ID;
RETURN (V_AVG);
END;
Which statement will successfully invoke this function in SQL *Plus?
long
(A) SELECT CALC_PLAYER_AVG(PLAYER_ID)
FROM PLAYER_BAT_STAT;
(B) EXECUTE CALC_PLAYER_AVG(31);
(C) CALC_PLAYER('RUTH');
(D) CALC_PLAYER_AVG(31);
(E) START CALC_PLAYER_AVG(31)
阿摩線上測驗
登入