请看如下的创建视图PARTS_VIEW的DDL语句:
CREATE OR REPLACE parts_view
AS
SELECT
manufacturer_id, COUNT (part_id) TOTAL_PARTS
FROM
parts
GROUP BY manufacturer_id;
基于以上PARTS_VIEW视图,可以使用如下哪个SQL语句A.SELECT *
FROM parts_view;
B.UPDATE parts_view
SET
total_parts=10000
WHERE manufacturer_id=3983;
C.DELETE FROM parts_view
WHERE
manufacturer_id=340394;
D.INSERT INTO parts_view
VALUES (89485, 1009);