單項選擇題

在oracle數(shù)據(jù)庫中,如何刪除sales表中產(chǎn)品類型為toys的profits列的列值?()

A.delete from sales
B.delete profits from sales where product_type=’TOYS’
C.delete from sales where product_type=’ToYS’
D.update sales set profits=null where product_type=’TOYS’

微信掃碼免費搜題