1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
| CREATE OR REPLACE FORCE VIEW "REFUNI"."VUE1" ("ID_INDIVIDU", "titi", "toto", "uu", "uid", "mail", "Name", "sn", "login", "civilite", "listerouge", "affiliation", "affiliation") AS
SELECT DISTINCT i.id_individu,
titi,
toto,
uu,
uid_ldap,
mail,
name,
sn,
login,
civilite,
listerouge,
e.affiliation,
e.affiliation
FROM individu i,
civilite c,
sn s,
indiv_sn isn,
mail m,
indiv_autremail iam,
affiliation e,
indiv_affiliation ia,
categorie_affiliation ca
WHERE i.id_civilite = c.id_civilite
AND i.id_individu =isn.id_individu
AND isn.id_sn = s.id_sn
AND i.id_individu = iam.id_individu
AND iam.id_mail = m.id_mail
and i.affiliation =e.id_affiliation
and i.id_individu =ia.id_individu(+)
and ia.id_categorie=ca.id_categorie
and ca.id_affiliation=e.id_affiliation(+)
START WITH TO_DATE('18-octobre-2013 11:25:00','dd-mon-yyyy hh24:mi:ss') NEXT sysdate+1
ORDER BY 1; |
Partager