insertgraduate.sql

来自「Oracle 9i中文版基础培训教程」· SQL 代码 · 共 10 行

INSERT INTO "SCOTT"."GRADUATE" ("BH" ,"XM" ,"LB" ,"YINGYU" ,"ZHENGZHI" ,"ZHUANYE1" ,"ZHUANYE2" ,"ZHUANYE3" ) VALUES (2003080520 ,'张三丰' ,'硕士' ,55 ,56 ,67 ,78 ,89  );
INSERT INTO "SCOTT"."GRADUATE" ("BH" ,"XM" ,"LB" ,"YINGYU" ,"ZHENGZHI" ,"ZHUANYE1" ,"ZHUANYE2" ,"ZHUANYE3" ) VALUES (2003060555 ,'张翠山' ,'硕士' ,66 ,78 ,78 ,89 ,92  );
INSERT INTO "SCOTT"."GRADUATE" ("BH" ,"XM" ,"LB" ,"YINGYU" ,"ZHENGZHI" ,"ZHUANYE1" ,"ZHUANYE2" ,"ZHUANYE3" ) VALUES (2003056066 ,'张无忌' ,'硕士' ,76 ,67 ,89 ,90 ,66  );
INSERT INTO "SCOTT"."GRADUATE" ("BH" ,"XM" ,"LB" ,"YINGYU" ,"ZHENGZHI" ,"ZHUANYE1" ,"ZHUANYE2" ,"ZHUANYE3" ) VALUES (2003010989 ,'赵敏' ,'硕士' ,45 ,59 ,74 ,66 ,56  );
INSERT INTO "SCOTT"."GRADUATE" ("BH" ,"XM" ,"LB" ,"YINGYU" ,"ZHENGZHI" ,"ZHUANYE1" ,"ZHUANYE2" ,"ZHUANYE3" ) VALUES (2003050677 ,'周芷若' ,'硕士' ,77 ,67 ,72 ,87 ,66  );
INSERT INTO "SCOTT"."GRADUATE" ("BH" ,"XM" ,"LB" ,"YINGYU" ,"ZHENGZHI" ,"ZHUANYE1" ,"ZHUANYE2" ,"ZHUANYE3" ) VALUES (2003869401 ,'小昭' ,'硕士' ,56 ,67 ,56 ,64 ,34  );
INSERT INTO "SCOTT"."GRADUATE" ("BH" ,"XM" ,"LB" ,"YINGYU" ,"ZHENGZHI" ,"ZHUANYE1" ,"ZHUANYE2" ,"ZHUANYE3" ) VALUES (2003340987 ,'阿离' ,'硕士' ,68 ,93 ,64 ,80 ,56  );
INSERT INTO "SCOTT"."GRADUATE" ("BH" ,"XM" ,"LB" ,"YINGYU" ,"ZHENGZHI" ,"ZHUANYE1" ,"ZHUANYE2" ,"ZHUANYE3" ) VALUES (2003056709 ,'宋远桥' ,'硕士' ,90 ,68 ,81 ,61 ,67  );
INSERT INTO "SCOTT"."GRADUATE" ("BH" ,"XM" ,"LB" ,"YINGYU" ,"ZHENGZHI" ,"ZHUANYE1" ,"ZHUANYE2" ,"ZHUANYE3" ) VALUES (2003100894 ,'殷素素' ,'硕士' ,69 ,73 ,62 ,70 ,75  );