Totals of Raak-trans-detail ( Voucher-Detail ) Debit, Credit should get stored in raak-trans-master (Voucher Master ) on each insert or update or delete on voucher details, Hence we shall create another after insert or update or delete trigger on raak- trans- details as follows insert or update trigger
How to use after insert or update trigger
create or replace trigger "RAAK_TRANS_DETAIL_AIUD" AFTER
insert or update or delete on "RAAK_TRANS_DETAIL" begin
update raak_trans_master set
debit_total - (select sum(nvl(debit,0)) from raak_trans_detail
where raak_trans_detail.voucher_number - raak_trans_master.voucher_number),
credit_total - (select sum(nvl(credit,0)) from
raak_trans_detail
where raak_trans_detail.voucher_number - raak_trans_master.voucher_number);
end;
This concludes creation of these three table properties, leaving any business rules left on these tables and like to create new application with a play role of above tables, Before we proceed on creation of application, we will try to learn some more PLlSQL Concepts and creation of procedures, functions for some time,