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 35 36 37 38 39
| ALTER TABLE MaTable
ADD COMBINAISON CHAR(100);
UPDATE MaTable
SET COMBINAISON =
with calcul
AS ( select C1,
C2,
C3,
C4,
C5,
C6,
CASE WHEN C1 > 0
THEN 'Col C1,' ELSE '' END
|| CASE WHEN C2 > 0
THEN 'Col C2,' ELSE '' END
|| CASE WHEN C3 > 0
THEN 'Col C3,' ELSE '' END
|| CASE WHEN C4 > 0
THEN 'Col C4,' ELSE '' END
|| CASE WHEN C5 > 0
THEN 'Col C5,' ELSE '' END
|| CASE WHEN C6 > 0
THEN 'Col C6,' ELSE '' END
AS liste
FROM MaTable
)
SELECT C1,
C2,
C3,
C4,
C5,
C6,
CASE WHEN charlength(liste) > 0
THEN SUBSTRING(liste FROM 1 FOR charlength(liste) - 1)
ELSE ''
END
from calcul; |
Partager