Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE
- CURSOR dep_cur1 IS
- SELECT department_name, count(employee_id) emp_num1
- FROM hr.departments d, hr.employees e
- WHERE d.department_id = e.department_id
- GROUP BY department_name
- HAVING count(employee_id) < 3;
- CURSOR dep_cur2 IS
- SELECT department_name, count(employee_id) emp_num2
- FROM hr.departments d, hr.employees e
- WHERE d.department_id = e.department_id
- GROUP BY department_name
- HAVING count(employee_id) > 3;
- BEGIN
- DBMS_OUTPUT.PUT_LINE('Dept dengan jumlah karyawan < 3');
- FOR v_dept IN dep_cur1 LOOP
- DBMS_OUTPUT.PUT_LINE('Department ' || v_dept.department_name
- || ', jumlah karyawan: ' || v_dept.emp_num1);
- END LOOP;
- DBMS_OUTPUT.PUT_LINE(' ');
- DBMS_OUTPUT.PUT_LINE('Dept dengan jumlah karyawan > 3');
- FOR v_dept IN dep_cur2 LOOP
- DBMS_OUTPUT.PUT_LINE('Department ' || v_dept.department_name
- || ', jumlah karyawan: ' || v_dept.emp_num2);
- END LOOP;
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement