--创建学生表
create table StudentTable
(
studentID varchar2(50) not null,
studentName varchar2(50) not null,
studentSex char(4) default '男',
studentAge number(3,0),
studentNative varchar2(50),
studentDepartment varchar(50),
sudentBirthday date,
constraint PK_StudentTable_studentID primary key(studentID),
constraint check_studentSex check(studentSex in ('男','女')),
constraint check_studentAge check(studentAge > 1)
);
--插入数据
insert into studenttable values('s001','孙悟空','男',20,'花果山','少林派', to_date('2011-12-2','yyyy-mm-dd'));
insert into studenttable values('s002','猪八戒','男',15,'高老庄','月亮上', to_date('2001-10-20','yyyy-mm-dd'));
insert into studenttable values('s003','沙悟净','男',26,'流沙河','黑龙江', to_date('1903-1-02','yyyy-mm-dd'));
insert into studenttable values('s004','唐三藏','男',21,'长安城','龙门庙', to_date('1991-01-30','yyyy-mm-dd'));
select * from studenttable2
--查找数据
select studentID,studentName,studentSex,studentAge,studentNative,studentDepartment,to_char(sudentBirthday,'yyyy-mm-dd') from studenttable;
--删除一张表(把标的结构和表的数据一起删除)
drop table StudentTable ;