Trigger example

define trigger overdraft on update of account T

(if new T.balance < 0

then (insert into loan values

(T.bname , T.acctNo, - new T.balance)

insert into borrower

(select cname,acctNo

from depositor

where T.acctNo = depositor.acctNo)

update account S

set S.balance = 0 where S.acctNo = T.acctNo))

Previous slide

Next slide

Back to first slide

View graphic version