Trigger in oracle
account
----------
accno varchar
acctotal number
student
----------
id varchar
fees number
accno varchar
I want to create a trigger which updates 'account' table anytime a record
is deleted from 'student'. It subtracts fees of student from acctotal in
account.
thnx in advance.
No comments:
Post a Comment