Advertisement
Guest User

Untitled

a guest
Mar 19th, 2019
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.87 KB | None | 0 0
  1. DECLARE
  2. CURSOR dep_cur1 IS
  3. SELECT department_name, count(employee_id) emp_num1
  4. FROM hr.departments d, hr.employees e
  5. WHERE d.department_id = e.department_id
  6. GROUP BY department_name
  7. HAVING count(employee_id) < 3;
  8.  
  9. CURSOR dep_cur2 IS
  10. SELECT department_name, count(employee_id) emp_num2
  11. FROM hr.departments d, hr.employees e
  12. WHERE d.department_id = e.department_id
  13. GROUP BY department_name
  14. HAVING count(employee_id) > 3;
  15.  
  16. BEGIN
  17. DBMS_OUTPUT.PUT_LINE('Dept dengan jumlah karyawan < 3');
  18. FOR v_dept IN dep_cur1 LOOP
  19. DBMS_OUTPUT.PUT_LINE('Department ' || v_dept.department_name
  20. || ', jumlah karyawan: ' || v_dept.emp_num1);
  21. END LOOP;
  22. DBMS_OUTPUT.PUT_LINE(' ');
  23. DBMS_OUTPUT.PUT_LINE('Dept dengan jumlah karyawan > 3');
  24. FOR v_dept IN dep_cur2 LOOP
  25. DBMS_OUTPUT.PUT_LINE('Department ' || v_dept.department_name
  26. || ', jumlah karyawan: ' || v_dept.emp_num2);
  27. END LOOP;
  28. END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement