insert into member(member_id,name) values('22010203', '张三');
insert into idcard(member_id,id_card,validate_date) values('22010203','2342424242424234',TO_DATE('2009-09-01','YYYY-MM-DD'));
insert into member(member_id,name) values('22010204', '李四');
insert into idcard(member_id,id_card,validate_date) values('22010204','2342342342342345',TO_DATE('2009-09-01','YYYY-mm-dd'));
----
insert into USER_REG values('liheng','李森', 'liheng','学生' );
insert into USER_REG values('liuyupeng','刘玉朋', 'liuyupeng','学生' );
commit;
insert into USER_REG values('liuqiang','刘强', 'liuqiang','学生' );
insert into USER_REG values('huanyan','黄燕', 'huanyan','学生' );
insert into USER_REG values('lixin','李欣', 'lixin','学生' );
insert into USER_REG values('wangtong','王同', 'wangtong','讲师' );
insert into USER_REG values('cuiyongqiang','崔永强', 'cuiyongqiang','讲师' );
insert into USER_REG values('lijun','李军', 'lijun','讲师' );
insert into USER_REG values('zhanghui','张辉', 'zhanghui','讲师' );
insert into USER_REG values('zhangjuan','张娟', 'zhangjuan','咨询师' );
insert into USER_REG values('liuli','刘力', 'liuli','咨询师' );
insert into USER_REG values('liuhaipeng','刘海鹏', 'liuhaipeng','咨询师' );
insert into USER_REG values('wangailin','王爱玲', 'wangailin','班主任' );
insert into USER_REG values('lihe','李贺', 'lihe','班主任' );
insert into USER_REG values('sunaiping','孙爱平', 'sunaiping','班主任' );
insert into USER_REG values('zhangdong','张冬', 'zhangdong','班主任' );
insert into USER_REG values('wangbin','王兵', 'wangbin','班主任' );
insert into CLASS_REG values('QH10001',TO_DATE('2008-2-28','YYYY-MM-DD'),TO_DATE('2008-5-9','YYYY-MM-DD'));
insert into CLASS_REG values('QH10002',TO_DATE('2008-3-14','YYYY-MM-DD'),TO_DATE('2008-6-1','YYYY-MM-DD'));
insert into CLASS_REG values('QH10003',TO_DATE('2008-6-15','YYYY-MM-DD'),TO_DATE('2008-9-10','YYYY-MM-DD'));
insert into CLASS_REG values('QH10004',TO_DATE('2008-6-15','YYYY-MM-DD'),TO_DATE('2008-9-10','YYYY-MM-DD'));
insert into EMPLOYEE values(SQ_EMPLOYEE.NEXTVAL,'刘明','男',null,'海淀区',null,'讲师');
insert into EMPLOYEE values(SQ_EMPLOYEE.NEXTVAL,'李国鹏','男',null,'三国卧龙市某个山村',null,'讲师');
insert into EMPLOYEE values(SQ_EMPLOYEE.NEXTVAL,'贺晓燕','女',null,'房山区',null,'班主任');
insert into EMPLOYEE values(SQ_EMPLOYEE.NEXTVAL,'李芳','女',21,'殷墟',null,'咨询师');
insert into EMPLOYEE values(SQ_EMPLOYEE.NEXTVAL,'王惠方','女',21,'朝阳区',null,'咨询师');
insert into EMPLOYEE values(SQ_EMPLOYEE.NEXTVAL,'李燕','女',21,'房山区',null,'咨询师');
insert into EMPLOYEE values(SQ_EMPLOYEE.NEXTVAL,'张桂川','男',35,'三国',null,'讲师');
insert into EMPLOYEE values(SQ_EMPLOYEE.NEXTVAL,'张桐','女',35,'唐朝',null,'咨询师');
insert into EMPLOYEE values(SQ_EMPLOYEE.NEXTVAL,'陈国强','男',35,'未知',null,'班主任');
insert into STUDENT values(SQ_STUDENT.NEXTVAL,'QH10001','李森','男',17,'西城区西直门',null,TO_DATE('2008-1-19','YYYY-MM-DD'),'1',4);
insert into STUDENT values(SQ_STUDENT.NEXTVAL,'QH10001','刘玉朋','男',29,NULL,'88991234',TO_DATE('2008-1-21','YYYY-MM-DD'),'2',4);
insert into STUDENT values(SQ_STUDENT.NEXTVAL,'QH10001','刘强','男',20,'海淀区中关村一街8栋1906室',null,TO_DATE('2008-1-19','YYYY-MM-DD'),'1',5);
insert into STUDENT values(SQ_STUDENT.NEXTVAL,'QH10001','黄燕','女',21,'朝阳区朝阳公园','87654321',TO_DATE('2008-1-20','YYYY-MM-DD'),'3',6);
insert into STUDENT values(SQ_STUDENT.NEXTVAL,'QH10001','李欣','女',18,'东城区东四十条','67765337',TO_DATE('2008-1-23','YYYY-MM-DD'),'1',4);
insert into STUDENT values(SQ_STUDENT.NEXTVAL,'QH10001','王同','男',24,null,null,TO_DATE('2008-1-24','YYYY-MM-DD'),'3',6);
insert into STUDENT values(SQ_STUDENT.NEXTVAL,'QH10002','崔永强','男',17,'西城区西直门',null,TO_DATE('2008-1-29','YYYY-MM-DD'),'3',4);
insert into STUDENT values(SQ_STUDENT.NEXTVAL,'QH10002','李军','男',29,null,'12345678',TO_DATE('2008-2-2','YYYY-MM-DD'),'3',4);
insert into STUDENT values(SQ_STUDENT.NEXTVAL,'QH10002','张辉','女',20,'海淀区中关村2街',null,TO_DATE('2008-2-2','YYYY-MM-DD'),'3',4);
insert into STUDENT values(SQ_STUDENT.NEXTVAL,'QH10002','张娟','女',21,'朝阳区朝阳公园','87654321',TO_DATE('2008-2-4','YYYY-MM-DD'),'3',6);
insert into STUDENT values(SQ_STUDENT.NEXTVAL,'QH10002','刘力','女',18,'东城区东四十条','67765337',TO_DATE('2008-2-7','YYYY-MM-DD'),'2',6);
insert into STUDENT values(SQ_STUDENT.NEXTVAL,'QH10002','刘海鹏','男',28,'门头沟区',null,TO_DATE('2008-2-9','YYYY-MM-DD'),'1',6);
insert into STUDENT values(SQ_STUDENT.NEXTVAL,'QH10002','王爱玲','女',18,'东城区东直门','67765337',TO_DATE('2008-2-15','YYYY-MM-DD'),'1',6);
insert into STUDENT values(SQ_STUDENT.NEXTVAL,'QH10002','李贺','男',23,'大兴区',null,TO_DATE('2008-2-20','YYYY-MM-DD'),'1',6);
insert into STUDENT values(SQ_STUDENT.NEXTVAL,'QH10002','孙爱平','女',21,null,null,TO_DATE('2008-3-1','YYYY-MM-DD'),'2',4);
insert into STUDENT values(SQ_STUDENT.NEXTVAL,'QH10003','张冬','男',18,'大兴区',null,TO_DATE('2008-3-2','YYYY-MM-DD'),'1',5);
insert into STUDENT values(SQ_STUDENT.NEXTVAL,'QH10003','王兵','男',23,'大兴区',null,TO_DATE('2008-3-2','YYYY-MM-DD'),'3',6);
insert into STUDENT values(SQ_STUDENT.NEXTVAL,'QH10003','美女1号','女',16,'宣武区',null,TO_DATE('2008-2-29','YYYY-MM-DD'),'1',4);
insert into STUDENT values(SQ_STUDENT.NEXTVAL,'QH10003','帅男1','男',21,'大兴区',null,TO_DATE('2008-3-17','YYYY-MM-DD'),'3',4);
insert into STUDENT values(SQ_STUDENT.NEXTVAL,'QH10003','张江','男',21,'宣武区',null,TO_DATE('2008-3-22','YYYY-MM-DD'),'2',6);
insert into STUDENT_2 values(SQ_STUDENT_2.NEXTVAL,'QH10001','李森','男',17,'西城区西直门',null,TO_DATE('2008-1-19','YYYY-MM-DD'),'1',4);
insert into STUDENT_2 values(SQ_STUDENT_2.NEXTVAL,'QH10001','刘玉朋','男',29,NULL,'88991234',TO_DATE('2008-1-21','YYYY-MM-DD'),'2',4);
insert into STUDENT_2 values(SQ_STUDENT_2.NEXTVAL,'QH10001','刘强','男',20,'海淀区中关村一街8栋1906室',null,TO_DATE('2008-1-19','YYYY-MM-DD'),'1',5);
insert into STUDENT_2 values(SQ_STUDENT_2.NEXTVAL,'QH10001','黄燕','女',21,'朝阳区朝阳公园','87654321',TO_DATE('2008-1-20','YYYY-MM-DD'),'3',6);
insert into STUDENT_2 values(SQ_STUDENT_2.NEXTVAL,'QH10001','李欣','女',18,'东城区东四十条','67765337',TO_DATE('2008-1-23','YYYY-MM-DD'),'1',4);
insert into STUDENT_2 values(SQ_STUDENT_2.NEXTVAL,'QH10001','王同','男',24,null,null,TO_DATE('2008-1-24','YYYY-MM-DD'),'3',6);
insert into STUDENT_2 values(SQ_STUDENT_2.NEXTVAL,'QH10002','崔永强','男',17,'西城区西直门',null,TO_DATE('2008-1-29','YYYY-MM-DD'),'3',4);
insert into STUDENT_2 values(SQ_STUDENT_2.NEXTVAL,'QH10002','李军','男',29,null,'12345678',TO_DATE('2008-2-2','YYYY-MM-DD'),'3',4);
insert into STUDENT_2 values(SQ_STUDENT_2.NEXTVAL,'QH10002','张辉','女',20,'海淀区中关村2街',null,TO_DATE('2008-2-2','YYYY-MM-DD'),'3',4);
insert into STUDENT_2 values(SQ_STUDENT_2.NEXTVAL,'QH10002','张娟','女',21,'朝阳区朝阳公园','87654321',TO_DATE('2008-2-4','YYYY-MM-DD'),'3',6);
insert into STUDENT_2 values(SQ_STUDENT_2.NEXTVAL,'QH10002','刘力','女',18,'东城区东四十条','67765337',TO_DATE('2008-2-7','YYYY-MM-DD'),'2',6);
insert into STUDENT_2 values(SQ_STUDENT_2.NEXTVAL,'QH10002','刘海鹏','男',28,'门头沟区',null,TO_DATE('2008-2-9','YYYY-MM-DD'),'1',6);
insert into STUDENT_2 values(SQ_STUDENT_2.NEXTVAL,'QH10002','王爱玲','女',18,'东城区东直门','67765337',TO_DATE('2008-2-15','YYYY-MM-DD'),'1',6);
insert into STUDENT_2 values(SQ_STUDENT_2.NEXTVAL,'QH10002','李贺','男',23,'大兴区',null,TO_DATE('2008-2-20','YYYY-MM-DD'),'1',6);
insert into STUDENT_2 values(SQ_STUDENT_2.NEXTVAL,'QH10002','孙爱平','女',21,null,null,TO_DATE('2008-3-1','YYYY-MM-DD'),'2',4);
insert into STUDENT_2 values(SQ_STUDENT_2.NEXTVAL,'QH10003','张冬','男',18,'大兴区',null,TO_DATE('2008-3-2','YYYY-MM-DD'),'1',5);
insert into STUDENT_2 values(SQ_STUDENT_2.NEXTVAL,'QH10003','王兵','男',23,'大兴区',null,TO_DATE('2008-3-2','YYYY-MM-DD'),'3',6);
insert into STUDENT_2 values(SQ_STUDENT_2.NEXTVAL,'QH10003','美女1