How to set a column x with the value x+y in Oracle?
I wanted the exact syntax for the following operation
UPDATE table1
SET colx= colx+y
WHERE ..some condtion..
Note: c开发者_C百科olx and y are of the type NUMBERs
Thanks, Amrutha
Your syntax is already correct. For example:
update emp
set sal = sal + 1000
where empno = 1234;
精彩评论