a trigger so that after a new item is inserted into invoice_line_item table, the corresponding invoice in
Fantastic news! We've Found the answer you've been seeking!
Question:
a trigger so that after a new item is inserted into invoice_line_item table, the corresponding invoice in the invoices table should have its invoice_total value incremented with the newly inserted line item's line_item_amount. After defining the trigger, insert a new invoice_line_item for Invoice id 78. Test how the trigger impacts the corresponding invoice in invoices table.
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date: