1 2 3 4 5 6 7 8
|
create or replace procedure affichage is
cursor crs is select dm.id_prof,dtm.id_lycee,r.nom_region from demande dm join detaille_demande dtm on dm.id_demande = dtm.id_demande join lycee l on l.id_lycee=dtm.id_lycee join academie ac on ac.id_academie=l.id_academie join region r on r.id_region = ac.id_region where dm.id_prof not in (select p.id_prof from region r2 join academie ac on r2.id_region = ac.id_region join lycee l on l.id_academie=ac.id_academie join professeur p on p.id_lycee=l.id_lycee where r.id_region = r2.id_region);
begin
for i in crs loop
dbms_output.put_line(i.id_prof);
end loop;
end; |