insertstudent.sql

来自「oracle 9培训基础教程」· SQL 代码 · 共 17 行

INSERT INTO "SCOTT"."STUDENT" ("STUDENT_ID" ,"NAME" ,"PROFESSIONAL" ,"BIRTHDAY" ,"DIRECTOR_ID" ) 
  VALUES (20020101 ,'周芷若' ,'软件工程' ,TO_DATE('20-11月-1976', 'dd-Mon-yyyy HH:MI:SS AM') ,200201  );
INSERT INTO "SCOTT"."STUDENT" ("STUDENT_ID" ,"NAME" ,"PROFESSIONAL" ,"BIRTHDAY" ,"DIRECTOR_ID" ) 
  VALUES (20020102 ,'赵敏' ,'计算机安全' ,TO_DATE('7-10月-1980', 'dd-Mon-yyyy HH:MI:SS AM') ,200202  );
INSERT INTO "SCOTT"."STUDENT" ("STUDENT_ID" ,"NAME" ,"PROFESSIONAL" ,"BIRTHDAY" ,"DIRECTOR_ID" )
  VALUES (20020103 ,'小昭' ,'图形图像' ,TO_DATE('22-10月-1973', 'dd-Mon-yyyy HH:MI:SS AM') ,200203  );
INSERT INTO "SCOTT"."STUDENT" ("STUDENT_ID" ,"NAME" ,"PROFESSIONAL" ,"BIRTHDAY" ,"DIRECTOR_ID" ) 
  VALUES (20020104 ,'蛛儿' ,'电子商务' ,TO_DATE('11-1月-1971', 'dd-Mon-yyyy HH:MI:SS AM') ,200204  );
INSERT INTO "SCOTT"."STUDENT" ("STUDENT_ID" ,"NAME" ,"PROFESSIONAL" ,"BIRTHDAY" ,"DIRECTOR_ID" ) 
  VALUES (20030101 ,'金花婆婆' ,'数据库' ,TO_DATE('6-8月-1945', 'dd-Mon-yyyy HH:MI:SS AM') ,200201  );
INSERT INTO "SCOTT"."STUDENT" ("STUDENT_ID" ,"NAME" ,"PROFESSIONAL" ,"BIRTHDAY" ,"DIRECTOR_ID" ) 
  VALUES (20030102 ,'胡青牛' ,'网络安全' ,TO_DATE('2-5月-1923', 'dd-Mon-yyyy HH:MI:SS AM') ,200203  );
INSERT INTO "SCOTT"."STUDENT" ("STUDENT_ID" ,"NAME" ,"PROFESSIONAL" ,"BIRTHDAY" ,"DIRECTOR_ID" ) 
  VALUES (20030103 ,'丁敏君' ,'Web技术' ,TO_DATE('12-4月-1967', 'dd-Mon-yyyy HH:MI:SS AM') ,200201  );
INSERT INTO "SCOTT"."STUDENT" ("STUDENT_ID" ,"NAME" ,"PROFESSIONAL" ,"BIRTHDAY" ,"DIRECTOR_ID" ) 
  VALUES (20030104 ,'殷素素' ,'Web安全' ,TO_DATE('14-7月-1971', 'dd-Mon-yyyy HH:MI:SS AM') ,200202  );