Oracle - 5. Modifique la tabla empleados añadiendo el campo salario (integer). Añadirle un valor por defecto

Set SERVEROUTPUT ON;

declare

cursor c_manager is select * from emp where job= 'MANAGER';

cursor c_president is select * from emp where job= 'PRESIDENT';

cursor c_Analyst is select * from emp where job= 'ANALYST';

cursor c_salesman is select * from emp where job= 'SALESMAN';

begin

DBMS_OUTPUT.PUT_LINE('--MANAGER--');

for varcont in c_manager loop

DBMS_OUTPUT.PUT_LINE(varcont.ename);

end loop;

DBMS_OUTPUT.PUT_LINE('--PRESIDENT--');

for varcontpre in c_president loop

DBMS_OUTPUT.PUT_LINE(varcontpre.ename);

end loop;

DBMS_OUTPUT.PUT_LINE('--ANALYST--');

for varcontpre in c_analyst loop

DBMS_OUTPUT.PUT_LINE(varcontpre.ename);

end loop;

DBMS_OUTPUT.PUT_LINE('--SALESMAN--');

for varcontpre in c_salesman loop

DBMS_OUTPUT.PUT_LINE(varcontpre.ename);

end loop;

end;

CREATE OR REPLACE TRIGGER TR_VALIDAR_JEFES

BEFORE

INSERT ON EMPLEADOS

FOR EACH ROW

DECLARE

NumEmpSupervisados INTEGER;

BEGIN

SELECT count (*) INTO NumEmpSupervisados

FROM EMPLEADOS

WHERE cojefe = :new.cojefe;

IF NumEmpSupervisados > 4 THEN

raise_application_error (-20600, :new.cojefe || 'NO SE PUEDE SUPERVISAR MAS DE 5');

END IF;

END;

create TABLE EMPLEADOS

(

dni char(4),

nomemp varchar2(15),

COJEFE char(4),

PRIMARY KEY (dni)

);

INSERT INTO EMPLEADOS (DNI,NOMEMP,COJEFE)

    VALUES ('D1','Director',null);

    INSERT INTO empleados VALUES ('D2','D.Comercial','D1');

INSERT INTO empleados VALUES ('D3','D.Producción','D1');

INSERT INTO empleados VALUES ('D4','Jefe Ventas','D1');

INSERT INTO empleados VALUES ('D5','Jefe Marketing','D1');

INSERT INTO empleados VALUES ('D6','Vendedor 2','D1');

INSERT INTO empleados VALUES ('D7','Vendedor 3','D1');

SELECT cojefe, count(*) FROM empleados GROUP BY cojefe;