【SQL开源代码栏目提醒】:网学会员为广大网友收集整理了,insertstudent.sql,希望对大家有所帮助!
insert into scott.student (student_id, name, professional, birthday, director_id)
values (2009001, '张小萌', '图形图像', to_date('19-02-1990', 'dd-mm-yyyy'), 200802);
insert into scott.student (student_id, name, professional, birthday, director_id)
values (2009003, '张世华', '数据库', to_date('19-03-1984', 'dd-mm-yyyy'), 200805);
insert into scott.student (student_id, name, professional, birthday, director_id)
values (2009002, '王志强', '电子商务', to_date('23-03-1982', 'dd-mm-yyyy'), 200801);
insert into scott.student (student_id, name, professional, birthday, director_id)
values (2009004, '任晓翔', '网络安全', to_date('23-07-1985', 'dd-mm-yyyy'), 200802);
insert into scott.student (student_id, name, professional, birthday, director_id)
values (2009005, '张国力 ', 'web技术', to_date('13-08-1987', 'dd-mm-yyyy'), 200803);
insert into scott.student (student_id, name, professional, birthday, director_id)
values (2009006, '刘泽云', '计算机基础', to_date('24-04-1989', 'dd-mm-yyyy'), 200804);
insert into scott.student (student_id, name, professional, birthday, director_id)
values (2009007, '张智芳', 'c语言', to_date('28-03-1982', 'dd-mm-yyyy'), 200805);
insert into scott.student (student_id, name, professional, birthday, director_id)
values (2009008, '刘晓倩', '影视
设计', to_date('12-06-1984', 'dd-mm-yyyy'), 200805);
insert into scott.student (student_id, name, professional, birthday, director_id)
values (2009009, '张明', 'vb语言', to_date('14-06-1982', 'dd-mm-yyyy'), 200803);
insert into scott.student (student_id, name, professional, birthday, director_id)
values (2009010, '郭玉才', 'c语言', to_date('16-08-1984', 'dd-mm-yyyy'), 200802);
insert into scott.student (student_id, name, professional, birthday, director_id)
values (2009011, '章果果', '
网络安全', to_date('20-09-1982', 'dd-mm-yyyy'), 200806);
insert into scott.student (student_id, name, professional, birthday, director_id)
values (2009012, '于丽黎', '电子商务', to_date('24-12-1985', 'dd-mm-yyyy'), 200805);
insert into scott.student (student_id, name, professional, birthday, director_id)
values (2009013, '谢学兴', '
计算机基础', to_date('22-11-1986', 'dd-mm-yyyy'), 200802);
insert into scott.student (student_id, name, professional, birthday, director_id)
values (2009014, '张小雪', '
web技术', to_date('28-03-1983', 'dd-mm-yyyy'), 200801);
insert into scott.student (student_id, name, professional, birthday, director_id)
values (2009015, '王华桦', 'vb语言', to_date('23-05-1985', 'dd-mm-yyyy'), 200806);