Write a procedure that automatically insert the paid invoices from invoices table into the paid_invoices table. Inserted
Fantastic news! We've Found the answer you've been seeking!
Question:
Write a procedure that automatically insert the paid invoices from invoices table into the paid_invoices table.
Inserted Invoices should be unique ( no duplicate invoices).
Write a function that check whether or not an invoice exists in paid_invoices.
The "INVOICES" and "PAID_INVOICES" have the same data types.
Only invoices paid in full ( Invoice_total = payment_total + credit_total) should be transferred to "PAID_INVOICES" table
**** EDIT ****
The invoice_id is a number like (33) and the Primary Key
The invoice_number is a varchar2 like ('Qb3295jd')
The same invoice_id can have multiple invoice_numbers
Related Book For
Introduction to Algorithms
ISBN: 978-0262033848
3rd edition
Authors: Thomas H. Cormen, Charles E. Leiserson, Ronald L. Rivest
Posted Date: