代碼內容:創建觸發器
create or replace trigger auid
before
insert on
person
for each row
declare
begin
select s_person.nextval into :new.pid from dual;
end;
創建表:create sequence s_person;
create table person(
pid number(25),
pname varchar2(10)
);
操作:
insert into person values (1,'a');
commit;
uj5u.com熱心網友回復:
報錯一直是 ORACLE觸發器無效且未通過重新驗證uj5u.com熱心網友回復:
trigger電池也是沒有紅叉額轉載請註明出處,本文鏈接:https://www.uj5u.com/shujuku/268383.html
標籤:開發
上一篇:select rownum,e.* from emp e where rownum<=3; 求大佬告知 這個e.*是什么意思
