1 2 3 4 5 6 7 8 9 10 11
| WITH table_transco AS (SELECT 88 bb, 'A' table_name, 'cd_aa' col_name, 2 ancienValue, 2 NewValue FROM dual
UNION ALL SELECT 90, 'A', 'cd_aa', 0, 3 FROM dual
)
SELECT bb, table_name, col_name, ancienvalue, newvalue,
DECODE(ancienvalue, newvalue, '', 'UPDATE '|| table_name ||' set '|| col_name ||'='|| newvalue ||' WHERE '|| col_name ||'='|| ancienvalue) AS req_Update
FROM table_transco
BB TABLE_NAME COL_NAME ANCIENVALUE NEWVALUE REQ_UPDATE
88 A cd_aa 2 2
90 A cd_aa 0 3 UPDATE A set cd_aa=3 WHERE cd_aa=0 |
Partager