以员工表单表为例
create table emp1(
id varchar2(20) primary key,
name varchar2(20)unique not null,
password varchar2(6)check(length(password)=6)not null,
salary number(8,2),
age varchar2(3),
sex varchar2(3)check(sex in('男','女')),
entryday date,
status varchar(2)check(status in('1','2')));--创建 序列
create sequence empid_seq start with 1 increment by 1;