1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| MERGE INTO T_UTILISATEUR_USR USR
USING (SELECT USR_ID,
USR_ID + (SELECT MAX(USR_ID)
FROM T_UTILISATEUR_USR) AS NEW_USR_ID,
USR_NOM, USR_PRENOM, USR_TITRE,
USR_MAIL, USR_ORGANISATION
FROM T_UTILISATEUR_USR) AS USS
ON USR.USR_NOM = USS.USR_NOM
AND USR.USR_ID <> USS.USR_ID
WHEN MATCHED THEN
UPDATE
SET USR_NOM = lower(USR_NOM),
USR_PRENOM = lower(USR_PRENOM)
WHEN NOT MATCHED THEN
INSERT (USR_ID, USR_NOM,
USR_PRENOM, USR_TITRE,
USR_MAIL, USR_ORGANISATION)
VALUES (USS.NEW_USR_ID,
UPPER(USS.USR_NOM),
UPPER(USS.USR_PRENOM), DEFAULT,
USS.USR_MAIL, 'BORLAND') |
Partager