1.建立表学生信息表（stu_info）并插入数据
www.2cto.com

create table stu_info (

stu_num number(10) primary key,

stu_name varchar2(10) not null,

stu_sex varchar2(2) check(stu_sex in('M','F')),

phone_num number(11),

idcard_num varchar2(18),

stu_school varchar2(50),

post_addr varchar2(50)

);

insert into stu_info values (2012100201,'zs','M',13800138000,'130822198804070011',' HBSJZDYZX','HB SJZSZXLWWJ47H');

insert into stu_info values (2012100202,'ls','M',13821138012,'130822198401170051','HBSJZDYZX','HBSJZSZXL
NJ143H');

insert into stu_info values (2012100203,'ml','F',13315819091,'131812198811031004',
'HBSJZDYZX','HBSJZS
KML33H');

insert into stu_info values (2012100204,'ww','M',18010078102,'131822198904173312
','HBCDDYZX',
'HBSJCDSTLJ42H');

insert into stu_info values (2012100205,'yb','M',13511313105,'130825198704143301','HBCDDYZX','HBCDDYZX');

insert into stu_info values (2012100206,'ff','F',18710013306,'100012198802041724',
'HBCDCYZX','HBCD
LHRXNJ270H');

insert into stu_info values (2012100207,'zx','F',13101108892,'130824198711122212',
'HBCDCYZX','HBCD
LHXDZC009H');

insert into stu_info values (2012100208,'tz','M',13800138010,'1308221988042701
21','HBCDLHDYZX','HB
CDLHXBZC191H');

insert into stu_info values (2012100209,'xf','M',18710081213,'13224219860612
913X','HBCDLHDYZX','HB
CDLHDYZX');

insert into stu_info values (2012100210,'aq','F',13800138001,'1308221984021
10134','HBCDLHDYZX','H
BCDLHDYZX');

insert into stu_info values (2012100211,'lm','F',13800138100,'211800198805313114',
'HBCDLHDYZX','BJSXCQZLGL134H');

insert into stu_info values (2012100212,'lw','M',18113081412,'130998198608093919
','HBCDCYZX','BJSXCQZLGL134H');

insert into stu_info values (2012211101,'bk','M',18133065974,'701822198706090115'
,'HBSJZDYZX','HBSJZDYZX');

insert into stu_info values (2012211102,'by','M',13900139001,'12932119880407091X
','HBSJZDYZX','HBSJZSZXLWWJ90H');

insert into stu_info values (2012211103,'mm','F',13800138041,'900838198612011136'
,'HBSJZDYZX','HBSJZDYZX');

insert into stu_info values (2012211104,'wj','M',13611829910,'887990198711
871117','HBCDDYZX','HBCDDYZX');

insert into stu_info values (2012211105,'jf','F',17988011992,'1308261987011
71008','HBSCDDYZX','HBCDDYZX');

insert into stu_info values (2012211106,'sf','F',18890988138,'1308221988040
70012','HBSCDDYZX','HBSCDSGYL110H');

insert into stu_info values (2012211107,'st','M',17799088897,'187908198811
070013','HBSCDLHDYZX','HBSCDSLHZXL998H');

insert into stu_info values (2012211108,'zd','M',13800981786,'2998221988040
71021','HBSCDLHDYZX','HBSCDLHDYZX');

insert into stu_info values (2012211109,'xx','F',18900000909,'1318251987092
21414','HBSLHDYZX','HBSLHDYZX');

insert into stu_info values (2012311110,'ll','M',1380
0090099,'13081819851009','HBSLHDYZX','HBSLHDYZX');

insert into stu_info values (2012341401,'sq','M',18010179986,'197876198909220
00X','HBSJZDYZX','HBSJZSZXLDXJ10H');