insert_students.sql

一个挺好的招生管理系统

INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日) 
		VALUES (STUNO_SQU.NEXTVAL, '陈文政','1',1010,1001,'0',19860503); 

		INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日) 
		VALUES(STUNO_SQU.NEXTVAL,'李敏','2',1009,1010,'1',19861106);

		INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日) 
VALUES(STUNO_SQU.NEXTVAL,'黄宾','1',1001,1002,'0',19881203);

		INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日) 
		VALUES(STUNO_SQU.NEXTVAL,'张晓羽','2',1002,1003,'1',19891120);

		INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日) 
		VALUES(STUNO_SQU.NEXTVAL,'许小猛','1',1008,1009,'0',19841220);

INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日) 
		VALUES(STUNO_SQU.NEXTVAL,'杨煌','1',1005,1007,'0',19871001);

		INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日) 
		VALUES(STUNO_SQU.NEXTVAL,'陈丽明','2',1006,1008,'0',19861011);

		INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日) 
		VALUES(STUNO_SQU.NEXTVAL,'尹文哲','1',1004,1010,'1',19860501);

INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日)  
		VALUES(STUNO_SQU.NEXTVAL,'段然','1',1010,1006,'1',19860423);

		INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日)  
		VALUES(STUNO_SQU.NEXTVAL,'袁慧瑶','2',1009,1010,'0',19860701);

		INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日) 
		VALUES(STUNO_SQU.NEXTVAL,'罗卓群','2',1003,1008,'1',19860223);

INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日)  
		VALUES(STUNO_SQU.NEXTVAL,'张婷','2',1001,1009,'0',19871204);

		INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日) 
		VALUES(STUNO_SQU.NEXTVAL,'李婷','2',1002,1003,'1',19860210);

		INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日) 
VALUES(STUNO_SQU.NEXTVAL,'林树金','1',1005,1006,'1',19860423); 

		INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日)  
		VALUES(STUNO_SQU.NEXTVAL,'吴岳','2',1009,1010,'0',19860601);
		INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日)  
		VALUES(STUNO_SQU.NEXTVAL,'周易','2',1010,1009,'0',19860810);
INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日)  
		VALUES(STUNO_SQU.NEXTVAL,'罗惯通','1',1007,1008,'1',19860215);
		INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日) 
		VALUES(STUNO_SQU.NEXTVAL,'石海林','2',1005,1009,'0',19860306);
		INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日) 
VALUES(STUNO_SQU.NEXTVAL,'李旋','2',1002,1004,'1',19860408);
		INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日) 
		VALUES(STUNO_SQU.NEXTVAL,'张建锋','1',1001,1002,'0',19860909);
		INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日) 
		VALUES(STUNO_SQU.NEXTVAL,'何健飞','1',1001,1002,'0',19860910);
		INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日) 
VALUES( STUNO_SQU.NEXTVAL, '徐子钊','1',1001,1003,'0',19860912); 
		INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日) 
		VALUES( STUNO_SQU.NEXTVAL, '张庆旭','1',1008,1010,'1',19861011); 
		INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日) 
		VALUES( STUNO_SQU.NEXTVAL, '张蜡','1',1008,1009,'1',19861120); 
		
INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日) 
		VALUES( STUNO_SQU.NEXTVAL, '李香','2',1003,1004,'0',19861021); 
		INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日) 
		VALUES( STUNO_SQU.NEXTVAL, '陈衬欢','2',1009,1010,'0',19861107); 
		INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日) 
VALUES( STUNO_SQU.NEXTVAL, '胡笛','2',1001,1002,'1',19861105); 
		INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日) 
		VALUES( STUNO_SQU.NEXTVAL,'舒娜','2',1003,1004,'0',19861110); 
		INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日) 
		VALUES( STUNO_SQU.NEXTVAL, '普伟','1',1004,1009,'1',19861111); 
		
INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日) 
		VALUES( STUNO_SQU.NEXTVAL, '国丹丹','2',1009,1010,'0',19861112); 
		INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日) 
		VALUES( STUNO_SQU.NEXTVAL, '李冠军','1',1005,1007,'0',19861113); 

		INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日)  
		VALUES( STUNO_SQU.NEXTVAL, '郭亚军','1',1004,1006,'0',19861104); 

		INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日) 
		VALUES( STUNO_SQU.NEXTVAL, '陈兵','1',1010,1008,'1',19861109); 
		INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日) 
		VALUES( STUNO_SQU.NEXTVAL, '洪智力','1',1003,1005,'1',19861121); 
		
INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日) 
		VALUES( STUNO_SQU.NEXTVAL, '李丽','2',1002,1006,'0',19861124); 
		INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日) 
		VALUES( STUNO_SQU.NEXTVAL, '吴子俊','1',1002,1005,'1',19861130); 
		INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日) 
VALUES( STUNO_SQU.NEXTVAL, '黄炎炎','1',1009,1008,'0',19861115); 
		INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日) 
		VALUES( STUNO_SQU.NEXTVAL, '黄源源','2',1008,1010,'1',19861108); 
		INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日) 
		VALUES( STUNO_SQU.NEXTVAL, '曹万吉','2',1003,1004,'0',19861020); 
INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日) 
		VALUES( STUNO_SQU.NEXTVAL, '谢敏','2',1005,1006,'1',19861026); 
		INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日) 
		VALUES( STUNO_SQU.NEXTVAL, '林晨曦','1',1007,1008,'1',19870112); 
		INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日) 
VALUES( STUNO_SQU.NEXTVAL, '邓树林','2',1002,1009,'0',19871025); 
		INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日) 
		VALUES( STUNO_SQU.NEXTVAL, '邱雨林','2',1006,1008,'0',19860708); 
		INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日) 
		VALUES( STUNO_SQU.NEXTVAL, '唐文文','1',1008,1009,'0',19860706);
INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日) 
		VALUES( STUNO_SQU.NEXTVAL, '张韦','2',1005,1007,'1',19860710); 
		INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日) 
		VALUES( STUNO_SQU.NEXTVAL, '胡月','2',1007,1009,'1',19861030); 
		INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日) 
		VALUES( STUNO_SQU.NEXTVAL, '高飞云','2',1005,1006,'0',19860321); 
INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日) 
		VALUES( STUNO_SQU.NEXTVAL, '陆文浩','1',1006,1010,'1',19860606); 
		INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日) 
		VALUES( STUNO_SQU.NEXTVAL, '孙庆','2',1001,1002,'1',19860607); 
		INSERT INTO STUDENT(编号,姓名,性别,一志愿,二志愿,同意调剂,出生年月日) 
		VALUES( STUNO_SQU.NEXTVAL, '王聪','1',1003,1004,'0',19860405); 

COMMIT;