## RVY_ETUDIANTS

Colonnes
Droits
Dépendances
Détails
Déclencheurs

Name | Value
--- | ---
CREATED | 29/09/12
LAST_DDL_TIME | 29/09/12
OWNER | ARELV3
VIEW_NAME | RVY_ETUDIANTS
TEXT_LENGTH | 368
TEXT | SELECT NUM, NOM, PRENOM, NUM_PROMO FROM RVY_ETUDIANTS_FULL WHERE NUM_CAMPUS=( SELECT GP3.PF_PERE FROM ACTEURS A INNER JOIN GROUPES_PARENTES GP3 ON A.PF_GROUPE=GP3.PF_FILS WHERE UPPER(A.LOGIN)=(SELECT sys_context('USERENV','SESSION_USER') FROM DUAL) AND GP3.PF_PERE BETWEEN 1990 AND 1991 ) WITH CHECK OPTION
TYPE_TEXT_LENGTH | null
TYPE_TEXT | null
OID_TEXT_LENGTH | null
OID_TEXT | null
VIEW_TYPE_OWNER | null
VIEW_TYPE | null
SUPERVIEW_NAME | null
EDITIONING_VIEW | N
READ_ONLY | N