1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| CREATE OR REPLACE VIEW toto.ESSAI(no_individu,tem_ind,tem_indiv_email,tem_indiv_tel,tem_affect,tem_affec_rech,tem_personnel)
as
select i.no_individu,
nvl((select 1 from dual where i.d_modification >'01/01/13'),0),
nvl((select 1 from dual where iem.d_modification > '01/01/13'),0),
nvl((select 1 from dual where it.d_modification > '01/01/13'),0),
nvl((select 1 from dual where aff.d_modification > '01/01/13'),0),
nvl((select 1 from dual where affr.d_modification >'01/01/13'),0),
nvl((select 1 from dual where pers.d_modification > '01/01/13'),0)
from
indiv i,
indiv_mail iem,
indiv_tel it,
affect aff,
affect_2 affr,
perso pers
where
i.no_individu = iem.no_individu(+)
and i.no_individu = it.no_individu(+)
and i.no_individu = aff.no_dossier_pers(+)
and i.no_individu = affr.no_dossier_pers(+)
and i.no_individu = pers.no_dossier_pers
order by 1; |
Partager