update statement expression code example

Example: update statement expression

UPDATE customer_tbl
SET outstanding_amt=outstanding_amt-(outstanding_amt*.10)
WHERE cust_country='India' AND grade=1;