ORCAL创建触发器
create or replace trigger trigger_rtxnotify -- trigger_rtxnotify触发器名
before insert on RTXNOTIFY --RTXNOTIFY表名
for each row
when (new.id is null)
declare
begin
select S_RTXNOTIFY.nextval into:new.id from dual;
end trigger_rtxnotify;
ORCAL创建序列
create sequence S_RTXNOTIFY -- S_RTXNOTIFY 序列名
minvalue 1
maxvalue 99999999999
start with 1
increment by 1
cache 20;
ORCAL触发器小例子
最新推荐文章于 2024-03-12 17:16:01 发布