- drop table book;
- --创建表
- create table book(
- bookId varchar2(4) primary key,
- name varchar2(20)
- );
- --创建序列
- create sequence book_seq start with 1 increment by 1;
- --创建触发器
- create or replace trigger book_trigger
- before insert on book
- for each row
- begin
- select book_seq.nextval into :new.bookId from dual;
- end ;
- --添加数据
- insert into book(name) values ('cc');
- insert into book(name) values ('dd');
- commit;