1 2 3 4 5 6 7 8 9
| select distinct Table1.matricule,
decode(to_date(sysdate,'MM'),'01',decode(region,'Corse', C.Contact1),
decode(to_date(sysdate,'MM'),'02',decode(region,'Occitanie', C.Contact1),
decode(to_date(sysdate,'MM'),'03',decode(region,'Nouvelle aquitaine', C.Contact1)
decode(to_date(sysdate,'MM'),'01',decode(region,'Corse', C.Contact2),
decode(to_date(sysdate,'MM'),'02',decode(region,'Occitanie', C.Contact2),
decode(to_date(sysdate,'MM'),'03',decode(region,'Nouvelle aquitaine', C.Contact2)
from table1,Contact C
where Table1.matricule.c.matricule |
Partager