Oracle SQL and PL/SQL Practice Quiz For Developers. It consists of 30 basic to advanced programming questions to assist you in your practicing session. All the best as you go down to tackle these questions.
Questions: 35 | Attempts: 15765 | Last updated: Mar 22, 2022
Sample Question
Which of the following statements contains an error?
Questions: 42 | Attempts: 4271 | Last updated: Mar 22, 2022
Sample Question
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?