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 ;