构造一个如下图所示的表:
№_001: 创建表 tb_a
DROP TABLE tb_a CASCADE CONSTRAINT;
COMMIT;
CREATE TABLE tb_a(
model_name varchar2(10),
parts_name varchar2(15));
COMMIT;
№_002: 导入数据
INSERT INTO tb_a (model_name, parts_name) VALUES ('飞机','轮胎');
INSERT INTO tb_a (model_name, parts_name) VALUES ('飞机','座椅');
INSERT INTO tb_a (model_name, parts_name) VALUES ('飞机','机翼');
INSERT INTO tb_a (model_name, parts_name) VALUES ('飞机','玻璃');
INSERT INTO tb_a (model_name, parts_name) VALUES ('汽车','轮胎');
INSERT INTO tb_a (model_name, parts_name) VALUES ('汽车','座椅');
INSERT INTO tb_a (model_name, parts_name) VALUES ('汽车','玻璃');
INSERT INTO tb_a (model_name, parts_name) VALUES ('自行车