Oracle的创建表、插入数据脚本

create table DOG_D
(
  ID   NUMBER not null,
  MZ   NVARCHAR2(20) not null
);

INSERT INTO DOG_D VALUES('1','金毛');
INSERT INTO DOG_D VALUES('2','萨摩耶');
INSERT INTO DOG_D VALUES('3','拉布拉多');
INSERT INTO DOG_D VALUES('4','边牧');
INSERT INTO DOG_D VALUES('5','秋田');
INSERT INTO DOG_D VALUES('6','田园');
INSERT INTO DOG_D VALUES('7','柯基');
INSERT INTO DOG_D VALUES('8','斗牛');
INSERT INTO DOG_D VALUES('9','比熊');
INSERT INTO DOG_D VALUES('10','贵宾');
INSERT INTO DOG_D VALUES('11','阿拉斯加');
INSERT INTO DOG_D VALUES('12','哈士奇');
INSERT INTO DOG_D VALUES('13','巴哥');
INSERT INTO DOG_D VALUES('14','博美');
INSERT INTO DOG_D VALUES('15','雪纳瑞');

SELECT * FROM DOG_D;