單項選擇題

oracle數(shù)據(jù)庫中,將temp表中name字段為’zhangsan’的同時age字段為23的數(shù)據(jù)age字段改為18的SQL 語句是()。

A.update temp set age =18where name =’zhangsan’age =23;
B.update table temp set age =18where name =’zhangsan’and age =23;
C.update temp set age =18where name =’zhangsan’and age =23;
D.update table temp set age =18where name =’zhangsan’;

微信掃碼免費搜題