SQL Question,

Write the trigger to update the CUST_BALANCE in the CUSTOMER TABLE when a new invoice record is entered. (Assume that the sale is a credit sale.) Test the trigger using the following new INVOICE record:

9003, 101, 15-JUN-16,500.16

Name the trigger trg_updatecustbalance.

CUSTOMER CUST_NUM CUST_LAST - 100 Brown 101 Smith 102 Ortega 0 CUST_FNAME Sam Jean Juan CUST_BALANCE 1650.16 940.16 648.97 0.00 DOB Click to Add 10/2/1892 5/25/1996 11/21/1998 INVOICE INV_NUM Field 1 Click to CUSTOMER_NUM 9000 101 9001 100 9002 100 0 0 INV_DATE 23-Mar-16 24-May-16 30-May-16 INV_AMOUNT 235.16 $12.16 528.16 0.00 Record: + 2 of 3 No Filter Search