User Tools

Site Tools


kurs:tri_2

Insert, Update, Delete

Timing After
Object Event Inseert, Update, Delete
Fire for Each Row
declare
  v_mode varchar2(10);
begin
  if inserting then
    v_mode := 'I';
  elsif updating then
    v_mode := 'U';
  else
   v_mode := 'D';
  end if;
insert into XL_TEST_JN
  (wert,
  change_date,
  change_type,
  orig_ind)
values
  -- nvl() gibt den ersten (von zwei) Wert zurück, der nicht null ist.
  (nvl(:old.wert, :new.wert),
  sysdate,
  v_mode,
  nvl(:old.ind, :new.ind));
end;
kurs/tri_2.txt · Last modified: 2014/09/10 21:22 (external edit)