Oracle data update explanation
(1) update one column: update T_Person set Age=30 (2) update multiple columns: update T_Person set Age=30,Name='Tom' (3) update part of the data: update T_Person set Age=30 where Name='Tom', uses where statement to update only rows where Name is' Tom', note that SQL equals to judge with a single =, not = =. (4) complex logic judgment can also be used in where: update T_Person set Age=30 where Name='Tom' or Age=,), etc.
Original address: http://bbs.delit.cn/thread-156-1-1.html
Please indicate the source of the reprint:
Written by: measurement Technology http://www.delit.cn
