CREATE VIEW S_RH.V_EMP_SALARIE_NNI
AS
SELECT EMP_ID, EMP_NOM, EMP_PRENOM, EMP_DATE_NAISSANCE, 
       CONCAT(EMP_NNI_SEXE, EMP_NNI_DATE_NAISS, EMP_NNI_COMMUNE_NAISS,
       EMP_NNI_RANG_NAISS) AS NNI, EMP_DATE_ENTREE, EMP_SALAIRE,
       EMP_FONCTION, EMP_SERVICE
FROM   S_RH.T_EMPLOYE_EMP;

INSERT INTO S_RH.V_EMP_SALARIE_NNI VALUES
(3, 'SCHMIDT', 'Albert', '1982-11-21', '1821154220030', 
 '2010-03-11', 1450, 'Manoeuvre', 'Logistique'),
(4, 'MOULIN', 'Marc', '1969-11-18', '1691125321007', 
 '2018-05-20', 3200, 'Vendeur', 'Commercial');

