abdeen-ahmad
3/4/2016 - 8:36 AM
Validation on trigger
Validation on trigger
create or replace trigger m_test
before insert on emp
for each row
when (:new.job ='ANALYST')
begin
if (:new.comm is not null) then
:new.comm := null;
end if;
end; Validation on trigger
create or replace trigger m_test
before insert on emp
for each row
when (:new.job ='ANALYST')
begin
if (:new.comm is not null) then
:new.comm := null;
end if;
end;