hai
here i have one doubt on pragma restrict refernces...... .........
can any one help me in the fallowing options?
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;
SELECTS HITS/AT_BATS
INTO V_AVG
FROM PLAYER_BAT_STAT
WHERE PLAYER_ID_V_ID;
RETURN(V_AVG);
END;
This function must be moved to a package. Which additional statement must be
added to the function to allow you to continue using the function in the group by the
clause of a select statement?
A. PRAGMA RESTRICT_REFERE NCES (CALC_PLAYER_AV G, WNDS, WNPS);
B. PRAGMA RESTRICT_REFERE NCES (CALC_PLAYER_AV G, WNPS);
C. PRAGMA RESTRICT_REFERE NCES (CALC_PLAYER_AV G, RNPS, WNPS);
D. PRAGMA RESTRICT_REFERE NCES (CALC_PLAYER_AV G, ALLOW_GROUP_BY) ;
here i have one doubt on pragma restrict refernces...... .........
can any one help me in the fallowing options?
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;
SELECTS HITS/AT_BATS
INTO V_AVG
FROM PLAYER_BAT_STAT
WHERE PLAYER_ID_V_ID;
RETURN(V_AVG);
END;
This function must be moved to a package. Which additional statement must be
added to the function to allow you to continue using the function in the group by the
clause of a select statement?
A. PRAGMA RESTRICT_REFERE NCES (CALC_PLAYER_AV G, WNDS, WNPS);
B. PRAGMA RESTRICT_REFERE NCES (CALC_PLAYER_AV G, WNPS);
C. PRAGMA RESTRICT_REFERE NCES (CALC_PLAYER_AV G, RNPS, WNPS);
D. PRAGMA RESTRICT_REFERE NCES (CALC_PLAYER_AV G, ALLOW_GROUP_BY) ;
Comment