oracle 数据库中创建自增主键的表

一 案例操作

1.1 创建表

#创建表
create  table  BOOK(
 id number(15) primary key not null,
book_name varchar2(50),
create_time  date
)

1.2.创建序列

create sequence BOOK_SE
minvalue 1
maxvalue 999999999999
start with 1
increment by 1 
cache 20;

1.3.创建触发器

create or replace trigger BOOK_TR
before insert on BOOK
for each row
begin
 select BOOK_SE.nextval into:new.id from dual;
 end;

1.4.插入数据

insert into BOOK(id,book_name,create_time) values(null,'shanghai',TO_DATE('2021-01-12 10:35:56','yyyy-mm-dd hh24:mi:ss'))

1.5.查询数据

select * from BOOK