---漲工資
UPDATE temp_salary T
SET T.SALARY = T.SALARY + (CASE T.POSITON
WHEN '總裁' THEN
300
WHEN '經(jīng)理' THEN
200
ELSE
100
END);
COMMIT;
UPDATE temp_salary T
SET T.SALARY = T.SALARY + (CASE T.POSITON
WHEN '總裁' THEN
300
WHEN '經(jīng)理' THEN
200
ELSE
100
END);
COMMIT;
2016-12-26
就算不學(xué)這個,完全去聽老師的存儲過程和存儲函數(shù),光標(biāo)都能全部搞懂,因為老師講的太仔細(xì)了,嘻嘻
2016-11-25