努力~中 2019-06-09 16:55 采纳率: 0%
浏览 1586

oracle insert 出现无效字符

  1. 图片说明
CREATE TABLE scott.score
(
编号 number(10,0) not null primary key ,
学号 char(10) not null,
课程号 char(4) not null,
成绩 number(3, 0)   ,
foreign key (学号) references scott.student(学号) ,
foreign key (课程号) references scott.course(课程号) ,
CONSTRAINT score_check  check ( 成绩 is null or (成绩  <=100  and 成绩 >0) )
);

INSERT INTO scott.score VALUES (1,'2009030101', 'J001', 99);
INSERT INTO scott.score VALUES (2,'2009030101', 'J002', 77);
INSERT INTO scott.score VALUES (3,'2009030101', 'J005', 86);
INSERT INTO scott.score  (编号,学号,课程号) VALUES (4,'2009030101', 'A001');
INSERT INTO scott.score  (编号,学号,课程号) VALUES (5,'2009030101', 'A002');
INSERT INTO scott. score  (编号,学号,课程号)  VALUES (6,'2009030101', 'A005');
INSERT INTO scott.score  (编号,学号,课程号) VALUES (7,'2009030102', 'A001');
INSERT INTO scott.score  (编号,学号,课程号) VALUES (8,'2009030102', 'A002');
INSERT INTO scott.score VALUES (9,'2009030102', 'A005', 78);
INSERT INTO scott.score VALUES (10,'2009030102', 'J001', 44);
INSERT INTO scott.score VALUES (11,'2009030102', 'J005', 76);
INSERT INTO scott.score VALUES (12,'2009030102', 'J003', 74);
INSERT INTO scott.score  (编号,学号,课程号) VALUES (13,'2009030103', 'A001');
INSERT INTO scott.score  (编号,学号,课程号) VALUES (14,'2009030103', 'A002');
INSERT INTO scott.score (编号,学号,课程号)  VALUES (15,'2009030103', 'A005');
INSERT INTO scott.score  (编号,学号,课程号) VALUES (16,'2009030103', 'J005');
INSERT INTO scott.score  (编号,学号,课程号) VALUES (17,'2009030103', 'J002');
INSERT INTO scott.score  (编号,学号,课程号) VALUES (18,'2009030103', 'J003');
INSERT INTO scott.score VALUES (19,'2009030104', 'A001', 85);
INSERT INTO scott.score VALUES (20,'2009030104', 'A002', 83);
INSERT INTO scott.score VALUES (21,'2009030104', 'A005', 71);
INSERT INTO scott.score (编号,学号,课程号)  VALUES (22,'2009030104', 'J001');
INSERT INTO scott.score  (编号,学号,课程号) VALUES (23,'2009030104', 'J002');
INSERT INTO scott.score  (编号,学号,课程号) VALUES (24,'2009030104', 'J003');
INSERT INTO scott.score VALUES (25,'2009030105', 'A001', 64);
INSERT INTO scott.score VALUES (26,'2009030105', 'A002', 61);
INSERT INTO scott.score VALUES (27,'2009030105', 'A005', 86);
INSERT INTO scott.score  (编号,学号,课程号) VALUES (28,'2009030105', 'J001');
INSERT INTO scott.score  (编号,学号,课程号) VALUES (29,'2009030105', 'J002');
INSERT INTO scott.score  (编号,学号,课程号) VALUES (30,'2009030105', 'J005');
INSERT INTO scott.score   VALUES (31,'2009030301', 'A005', 33);
INSERT INTO scott.score  (编号,学号,课程号) VALUES (32,'2009030301', 'J001');
INSERT INTO scott.score  (编号,学号,课程号) VALUES (33,'2009030301', 'J002');
INSERT INTO scott.score  (编号,学号,课程号) VALUES (34,'2009030301', 'J003');
INSERT INTO scott.score  (编号,学号,课程号) VALUES (35,'2009030302', 'J001');
INSERT INTO scott.score  (编号,学号,课程号) VALUES (36,'2009030302', 'J005');
INSERT INTO scott.score  (编号,学号,课程号) VALUES (37,'2009030302', 'J003');
INSERT INTO scott.score VALUES (38,'2009030302', 'A001', 77);
INSERT INTO scott.score VALUES (39,'2009030302', 'A002', 83);
INSERT INTO scott.score VALUES (40,'2009030302', 'A005', 64);
INSERT INTO scott.score  (编号,学号,课程号) VALUES (41,'2009030303', 'J005');
INSERT INTO scott.score  (编号,学号,课程号) VALUES (42,'2009030303', 'J002');
INSERT INTO scott.score  (编号,学号,课程号) VALUES (43,'2009030303', 'J003');
INSERT INTO scott.score VALUES (44,'2009030303', 'A001', 97);
INSERT INTO scott.score VALUES (45,'2009030303', 'A002', 93);
INSERT INTO scott.score VALUES (46,'2009030303', 'A005', 94);
INSERT INTO scott.score  (编号,学号,课程号) VALUES (47,'2009030304', 'J001');
INSERT INTO scott.score  (编号,学号,课程号) VALUES (48,'2009030304', 'J005');
INSERT INTO scott.score  (编号,学号,课程号) VALUES (49,'2009030304', 'J002');
INSERT INTO scott.score  (编号,学号,课程号) VALUES (50,'2009030304', 'J003');
INSERT INTO scott.score VALUES (51,'2009030304', 'A001', 87);
INSERT INTO scott.score VALUES (52,'2009030304', 'A002', 81);
INSERT INTO scott.score VALUES (53,'2009030304', 'A005', 77);
  • 写回答

1条回答 默认 最新

  • glen_huang2046 2019-06-10 16:42
    关注

    字段名没有写啊,

    INSERT INTO scott.score VALUES (3,'2009030101', 'J005', 86);
    INSERT INTO scott.score  (编号,学号,课程号) VALUES (4,'2009030101', 'A001');
    

    按下面的方法写就行吧

    评论

报告相同问题?

悬赏问题

  • ¥15 ROS Turtlebot3 多机协同自主探索环境时遇到的多机任务分配问题,explore节点
  • ¥15 Matlab怎么求解含参的二重积分?
  • ¥15 苹果手机突然连不上wifi了?
  • ¥15 cgictest.cgi文件无法访问
  • ¥20 删除和修改功能无法调用
  • ¥15 kafka topic 所有分副本数修改
  • ¥15 小程序中fit格式等运动数据文件怎样实现可视化?(包含心率信息))
  • ¥15 如何利用mmdetection3d中的get_flops.py文件计算fcos3d方法的flops?
  • ¥40 串口调试助手打开串口后,keil5的代码就停止了
  • ¥15 电脑最近经常蓝屏,求大家看看哪的问题