DECLARE v_ave_sal NUMBER(10,2); v_deptno NUMBER NOT NULL := 60; BEGIN SELECT AVERAGE(salary) INTO v_ave_sal FROM emp WHERE deptid = v_deptno; DBMS_OUTPUT.PUT_LINE('Dep #60 Average Salary: ' || v_ave_sal); END; a. Dep #60 Average Salary:500 b. Dep #60 Average Salary:400 c. Dep #60 Average Salary:1000 d. Dep #60 Average Salary:600 Extracted text: What is the output of the given anonymous block? Refer to the EMP table: EMP_ID DEPTID SALARY 101 10 200 1002 50 500 1003 60 400 1004 60 600

DECLARE v_ave_sal NUMBER(10,2); v_deptno NUMBER NOT NULL := 60; BEGIN SELECT AVERAGE(salary) INTO v_ave_sal FROM emp WHERE deptid = v_deptno; DBMS_OUTPUT.PUT_LINE('Dep #60 Average Salary: ' ||...

DECLARE

v_ave_sal NUMBER(10,2);

v_deptno NUMBER NOT NULL := 60;

BEGIN

SELECT AVERAGE(salary)

INTO v_ave_sal FROM emp

WHERE deptid = v_deptno;

DBMS_OUTPUT.PUT_LINE('Dep #60 Average Salary: ' || v_ave_sal);

END;

Dep #60 Average Salary:500

Dep #60 Average Salary:400

Dep #60 Average Salary:1000

Dep #60 Average Salary:600

What is the output of the given anonymous block?<br>Refer to the EMP table:<br>EMP_ID<br>DEPTID<br>SALARY<br>101<br>10<br>200<br>1002<br>50<br>500<br>1003<br>60<br>400<br>1004<br>60<br>600<br>

Extracted text: What is the output of the given anonymous block? Refer to the EMP table: EMP_ID DEPTID SALARY 101 10 200 1002 50 500 1003 60 400 1004 60 600

Jun 08, 2022

SOLUTION.PDF