create table student (
snum varchar(20) not null,
sname varchar(20) not null,
ssex varchar(20) not null,
sclass varchar(20) not null,
semail varchar(30),
sbirthday date,
shouseaddress varchar(20)
);

 

表中输入信息

insert into studentvalues (1,'111','男',1,'10086@xx.com',to_date('1970-06-06','yyyy-mm-dd'),'沈阳');