Question: Consider the function AVG_GPA (deptName IN varchar) which returns a number. Identify the correct PL/SQL program that calls AVG_GPA. Begin a := AVG_GPA ('IS'); End;
Consider the function AVG_GPA (deptName IN varchar) which returns a number. Identify the correct PL/SQL program that calls AVG_GPA.
| Begin a := AVG_GPA ('IS'); End; | ||
| Declare a number := 0.0; Begin a := AVG_GPA ('IS'); End; | ||
| Declare a number := 0.0; Begin exec AVG_GPA ('IS'); End; | ||
| Declare a number := 0.0; Begin b := AVG_GPA ('IS'); End; |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
