oracle创建表并使主键自增步骤

-- 创建表

create table STAFF

(

ID              NUMBER(6) not null,

NUM            NUMBER(10),

NAME            VARCHAR2(50),

AGE            NUMBER(3,0),

SALARY          NUMBER(*,2),

EMPLOYMENT_DATE TIMESTAMP

)

-- 添加列表注释

comment on column STAFF.ID

is '唯一标识';

comment on column STAFF.NUM

is '编号 ';

comment on column STAFF.NAME

is '姓名';

comment on column STAFF.AGE

is '年龄';

comment on column STAFF.SALARY

is '薪水 ';

comment on column STAFF.EMPLOYMENT_DATE

is '入职日期';

-- 申明主键

alter table STAFF

add constraint PK_STAFF primary key (ID);

--创建序列

create sequence STAFF_SEQ start with 1 increment by 1;

--创建触发器

create or replace trigger STAFF_TRIGGER

before insert on STAFF

for each row

begin

select STAFF_SEQ.NEXTVAL into :NEW.ID from DUAL;

end ;