create table customer(
cid number(8) primary key,
cname varchar2(30) not null,
sex char(4) default '男' check (sex in ('男','女' )),
birth date,
idcard char(18) unique,
cage number(2) check(cage between 0 and 100)
);
insert into customer(cid,cname,sex,birth,idcard,cage) values(11111,'hh','女',to_date('2014-3-19','yyyy-MM-dd'),'111311111',25);
delete from customer where cname='joy';
update customer set sex='男' where cid='11111';
select * from customer;