Help with Triggers and Procedures
439690Mar 6 2005 — edited Mar 2 2007I have been working with this for awhile. I m not sure how to do these. I have created them but they have compilation errros. Is there a way to view the syntax of a trigger or procedure that you create? Also here are the things that i dont know how to get done. Can anyone help?
14. 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:
8005, 1001, â27-APR-04â, 225.40
Name the trigger trg_updatecustbalance.
15. Write a procedure to add a new customer to the CUSTOMER table. Use the following values in the new record:
1002, âRauthorâ, âPeterâ, 0.00