Example of some triggers

create or replace trigger ddd
after insert on issue_master
for each row when (new.total_pending>0)
begin
insert into issue_master2(
issue_no,issue_date,chall_no,dealer_code,sr_code,sr_empno,no_of_item,tso_code,tso_empno,rsm_code,depot_code)
values(:new.issue_no||'-'||1,:new.issue_date,:new.chall_no,:new.dealer_code,
:new.sr_code,:new.sr_empno,:new.no_of_item,
:new.tso_code,:new.tso_empno,:new.rsm_code,:new.depot_code);
exception
when others then
null;
end;



create trigger dddd
after insert on issue_dtl
for each row
begin
if :new.pending_qty_piece>0 then
insert into issue_dtl2(issue_no,prod_code,chall_qty,chall_qty_pkt,chall_qty_piece,bonus_qty,
issue_qty,issue_qty_pkt,issue_qty_piece,pending_qty_piece)
values(:new.issue_no||'-'||1,:new.prod_code,:new.chall_qty,:new.chall_qty_pkt,
:new.chall_qty_piece,:new.bonus_qty,:new.issue_qty,:new.issue_qty_pkt,
:new.issue_qty_piece,:new.pending_qty_piece);
end if;
end;



trigger ddd
after insert on issue_master
for each row
begin
insert into issue_master2(
issue_no,issue_date,chall_no,dealer_code,sr_code,sr_empno,no_of_item,tso_code,ts
o_empno,rsm_code,depot_code)

values(:new.issue_no||'-'||1,:new.issue_date,:new.chall_no,:new.dealer_code,
:new.sr_code,:new.sr_empno,:new.no_of_item,
:new.tso_code,:new.tso_empno,:new.rsm_code,:new.depot_code);

TEXT
--------------------------------------------------------------------------------
end;



trigger dddd
after insert on issue_dtl
for each row
begin
if :new.pending_qty_piece>0 then
insert into issue_dtl2(issue_no,prod_code,chall_qty,chall_qty_pkt,chall_qty_piec
e,bonus_qty,

issue_qty,issue_qty_pkt,issue_qty_piece,pending_qty_piece)
values(:new.issue_no||'-'||1,:new.prod_code,:new.chall_qty,:new.chall_qty_pkt,
:new.chall_qty_piece,:new.bonus_qty,:new.issue_qty,:new.issue_qty_pkt,

TEXT
--------------------------------------------------------------------------------
:new.issue_qty_piece,:new.pending_qty_piece);
end if;
end;