i want to automate the subtraction of the pay_amount from the balance. The columns are on different tables?
create or replace trigger test1
after insert or update or delete
of pay_amount on payment
for each row
BEGIN
select pay_amount into :new.balance from payment;
END;
/
create or replace trigger test1
after insert or update or delete
of pay_amount on payment
for each row
BEGIN
select pay_amount into :new.balance from payment;
END;
/