Oracle----Modify data in a table

1. Modify the data in the table: UPDATE statement:

Grammar:

Updtae table_name SET = value1,... [WHERE conditions]

(2), unconditional update (without a Where condition update):

 sql>  update  userinfo set  userpwd=   " 111111   " ; 4 rows updated. SQL  >  select  userpwd from   UserInfo; Userpwd  -- ------------------ Span style= "color: #800000; Font-weight:bold; " >111111  111111  111111  111111  sql  >  

Change multiple fields so that they are separated;

Sql> UpdateUserInfoSetUserpwd='111', email='[email protected]'; 4 rows have been updated. SQL> SelectUserpwd,email fromUserInfo; Userpwd EMAIL-------------------- ------------------------------111                  111@163. com111                  111@163. com111                  111@163. com111                  111@163. Comsql>

(2), conditional update:

Sql> SelectUsername fromUserInfo; USERNAME--------------------Xxxyyysql> UpdateUserInfoSetUserpwd='123456'  2  whereUsername='XXX'; updated1line. SQL> SelectId,username,userpwd fromUserInfo; ID USERNAME userpwd---------- -------------------- --------------------         1Xxx123456         2yyy111         3                      111         4                      111SQL>

Oracle----Modify data in a table