Problème avec mon code PL/SQL
ENONCE
Ecrire un programme pl/sql exécutable sur sql developper
qui invite un utilisateur à specifier une numéro de département
et si le département existe le programme affichera l'état sur le département
sous la forme
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xx Nom: __________________ xxxxxxxxxxxxxxx
xx Manager: ______________ xxxxxxxxxxxxxxx
xx Employees: ____________ xxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
ESSAIE DE SOLUTION
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
| DECLARE
v_fname VARCHAR2(20);
v_fmanager VARCHAR2(20);
v_femployees NUMBER;
BEGIN
SELECT d.department_name,e.first_name,COUNT(emp.employee_id),&d.department_id
INTO v_fname,v_fmanager,v_femployees
FROM departments d JOIN employees e
ON d.department_id = e.department_id
JOIN employees emp
ON e.manager_id = emp.manager_id group by d.department_name, e.first_name, &d.department_id;
DBMS_OUTPUT.PUT_LINE('**********************************************');
DBMS_OUTPUT.PUT_LINE('** Nom: ' || v_fname ||'**********************');
DBMS_OUTPUT.PUT_LINE('** Manager: ' || v_fmanager ||'******************');
DBMS_OUTPUT.PUT_LINE('** Employees ' || v_femployees ||'*****************');
DBMS_OUTPUT.PUT_LINE('**********************************************');
END; |
