数据库实例名是 orcl,账号/密码为:scott/tiger
数据表(STUDENT)
添加数据记录
alter session set nls_date_format = 'yyyy-mm-dd';
insert into student(zj,name,age,sex,score,today)values ('1','李连杰',18,'0',99,'2010-10-1');
insert into student(zj,name,age,sex,score,today)values ('2','成龙',19,'1',89,'2010-10-1');
insert into student(zj,name,age,sex,score,today)values ('3','李小龙',20,'0',97,'2010-10-1');
insert into student(zj,name,age,sex,score,today)values ('4','甄子丹',19,'1',100,'2010-10-1');
insert into student(zj,name,age,sex,score,today)values ('5','黄飞鸿',18,'0',93,'2010-10-1');
insert into student(zj,name,age,sex,score,today)values ('6','方世玉',18,'1',94,'2010-10-1');
insert into student(zj,name,age,sex,score,today)values ('7','张三丰',21,'0',96,'2010-10-1');
insert into student(zj,name,age,sex,score,today)values ('8','霍元甲',19,'1',97,'2010-10-1');
insert into student(zj,name,age,sex,score,today)values ('9','陈真',18,'0',88,'2010-10-1');
insert into student(zj,name,age,sex,score,today)values ('10','洪熙官',20,'1',90,'2010-10-1')