1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
| INSERT INTO LISTE_IDENTIFIANTS(ID_IDENT,AGT_MATRICULE, APP_C_APPLI, L_IDENT, D_DER_MAJ,B_ACTIF, APP_PROFIL, APP_ENV,APP_SAISIE)
WITH ALL_COMPTES_AD AS
(
SELECT matricule, cast(t.column_value.extract('//text()') AS varchar2(50)) unmemberof
FROM COMPTES_AD,
TABLE( xmlsequence( xmltype(
'<x><x>' || REPLACE(REPLACE(MEMBEROF,' ',NULL), ',', '</x><x>') || '</x></x>'
).EXTRACT('//x/*'))) T
)
SELECT s_ide.nextval, MATRICULE, 'INTRANET' AS APP_C_APPLI, UNMEMBEROF, SYSDATE, 'O' AS B_ACTIF, '', '', 'N' AS APP_SAISIE
FROM ALL_COMPTES_AD
WHERE unmemberof LIKE 'yga_dossier%'
ORDER BY MATRICULE |
Partager