By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table etudiants(
matricule varchar2(50) primary key,
nom VARCHAR2(50),
prenom VARCHAR2(50),
sexe CHAR(1),
ville VARCHAR2(50),
tel VARCHAR2(50) constraint fk_tel unique,
email VARCHAR2(50) constraint fk_email unique,
idDep varchar2(50)
--, constraint fk_dep foreign key (idDep) references departement(idDep)
);
Create view vetudiant(matricule,sexe,ville,tel,email,idDep) as select matricule,sexe,ville,tel,email,idDep from etudiants;