經安全檢測,此網站為安全網站,請放心前往原始網址!

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

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 ...

stackoverflow.com

網址安全性掃描由 google 提供