sql - UPDATE with CASE and IN - Oracle - Stack Overflow

sql - UPDATE with CASE and IN - Oracle - Stack Overflow

瀏覽:1188
日期:2025-04-28
The query looks like this i SQL: UPDATE tab1 SET budgpost_gr1= CASE WHEN (budgpost in (1001,1012,50055)) THEN 'BP_GR_A' WHEN (budgpost in (5,10,98,0)) THEN 'BP_GR_B' WHEN (budgpost in (11,876,7976,67465)) ELSE 'Missing' END ......看更多