Which code successfully calculates tax?
A.
CREATE OR REPLACE PROCEDURE calctax (p_no IN NUMBER) RETURN tax IS
v_sal NUMBER;
tax Number;
BEGIN
SELECT sal INTO v_sal
FROM emp
WHERE empno = p_no;
tax := v_sal * 0.05;
END;
B.
CREATE OR REPLACE FUNCTION calctax (p_no NUMBER)
RETURN NUMBER IS
v_sal NUMBER
BEGIN
SELECT sal INTO v_sal
FROM emp
WHERE empno = p_no;
RETURN:= v_sal * 0.05;
end
C.
CREATE OR REPLACE FUNCTION calctax (p_no NUMBER)
RETURN NUMBER IS
v_sal NUMBER;
tax NUMBER;
BEGIN
SELECT sal INTO v_sal
FROM emp
WHERE empno = p_no;
tax := v_sal * 0.05;
END
D.
CREATE OR REPLACE FUNCTION calctax (p_no NUMBER) IS v_sal NUMBER;
tax NUMBER;
BEGIN
SELECT sal INTO v_sal
FROM emp
WHERE empno = p_no;
tax := v_sal * 0.05;
return (tax);
END;
Explanation:
Incorrect AnswersA: A RETURN clause is only valid in a function
C: Missing a RETURN clause in the executable section D: The header portion of the function is missing the RETURN keyword.
Should the answer not be D? B treats RETURN as a variable, which would be incorrect.
All answers are bad