title: Write a PL/SQL block to display the department name and the total salary expenditure of the department from the Employee table
body: <p>Display the department name and the total salary expenditure of the department from the Employee table.</p>
  <p>To find the department name and the salary of the person from the particular department must be the output.</p>
  <pre><code>THIS IS THE EMPLOYEE TABLE:
  
  EMP_ID     EMP_NAME SALARY  DEPT
  101         Tom     54000   MECH
  102       William   43000   CSE
  103         John    34560   MECH
  104        Smith    56000   CSE
  105        Steve    23450   IT
  </code></pre>
  <p>CODING:</p>
  <p>I have tried this but i didn't get the output can somebody help me to get the output.</p>
  <pre><code>set serveroutput on;
  DECLARE
  Dept varchar2(25);
  Employee_salary VARCHAR2(25);
  SELECT
  Employee_salary
  FROM
  Employee;
  WHERE salary=23450;
  BEGIN
  DBMS_OUTPUT.PUT_LINE(‘Department-wise salary expenditure :’ || Dept salary);
  END;
  /
  </code></pre>
  <p>And the Sample Output:</p>
  <pre><code>Department-wise salary expenditure:
  IT department, total salary is 48000
  CSE department, total salary is 79000
  MECH department, total salary is 80000
  </code></pre>