oracle脚本:drop table t_student cascade constraints;
?
/*==============================================================*/
/*?Table:?t_student???????????????????????????????????????????*/
/*==============================================================*/
create?table?t_student??(
???s_id??????????????char(10)????????????????????????not?null,
???s_name?????????????varchar2(20)????????????????????not?null,
???s_age??????????????char(2)?????????????????????????not?null,
???s_sex??????????????char(2)?????????????????????????not?null,
???s_class????????????varchar2(20),
???constraint?PK_T_STUDENT?primary?key?(s_id)
);
insert?into?t_student?values('0001','张三','20','男','08级二班')?;
insert?into?t_student?values('0002','李四','21','女','08级二班'
/*?Table:?t_student???????????????????????????????????????????*/
/*==============================================================*/
create?table?t_student??(
???s_id??????????????char(10)????????????????????????not?null,
???s_name?????????????varchar2(20)????????????????????not?null,
???s_age??????????????char(2)?????????????????????????not?null,
???s_sex??????????????char(2)?????????????????????????not?null,
???s_class????????????varchar2(20),
???constraint?PK_T_STUDENT?primary?key?(s_id)
);
insert?into?t_student?values('0001','张三','20','男','08级二班')?;
insert?into?t_student?values('0002','李四','21','女','08级二班'