首先是创建一个表
create Table blog(id number primary key,title varchar2(10),author_id number references author(id));
其次要创建一个序列:
Create
Sequence s_blog
Increment by
1
start
with 1
nomaxvalue
nocycle
cache
10
;
创建触发器
Create trigger addblog before
insert on blog for each row /*对每一行都检测是否触发*/
begin
select s_blog.nextval into:NEW.id from dual;
end;
转载请注明原文地址: https://www.6miu.com/read-1750061.html