CREATE OR REPLACE FUNCTION getSalaire(nomEmploye IN VARCHAR2)
    RETURN NUMBER IS
        salaire NUMBER(6);
        n NUMBER(4);
    BEGIN
        SELECT COUNT(*) INTO n FROM EMP WHERE NOMCOMPLET = nomEmploye;
        IF n = 0 THEN
            salaire := 0;
        ELSE
            SELECT SALAIRE INTO salaire FROM EMP WHERE NOMCOMPLET = nomEmploye;
        END IF;
        RETURN salaire;
END getSalaire;

CREATE OR REPLACE FUNCTION getSalaireString(nomEmploye IN VARCHAR2)
    RETURN VARCHAR2 IS
        salaire NUMBER(6);
        numero NUMBER(6);
        poste VARCHAR2(50);
        chaine VARCHAR2(50);
        n NUMBER(4);
    BEGIN
        SELECT COUNT(*) INTO n FROM EMP WHERE NOMCOMPLET = nomEmploye;
        IF n = 0 THEN
            chaine := ('L''employé ' || nomEmploye || ' n''existe pas');
        ELSE
            SELECT SALAIRE, NUMEMP, PROFESSION INTO salaire, numero, poste FROM EMP WHERE NOMCOMPLET = nomEmploye;
            chaine := ('Numéro : ' || numero || ', Salaire : ' || salaire || ', Poste : ' || poste);
        END IF;
        RETURN chaine;
END getSalaireString;