A) Write a script that creates a cursor consisting of vendor_name, invoice_number, and balance_due (hint: our favorite equation) for each invoice with a balance due that's greater than or equal to $5,000. The rows in this cursor should be sorted in descending sequence by balance due. Then, for each invoice, display the balance due, invoice number, and vendor name so it looks something like this: $19,351.18 P-0608 Malloy Lithographing Inc Man b) Enhance your solution above so it uses a substitution variable to set a bind variable that you use to determine what the minimum balance due should be for the invoices that the SELECT statement is going to retrieve. You should also use this bind variable to display a heading like this before the list of invoices:
Invoice amounts greater than or equal to $2,000 Where 2,000 is the value of the bind variable.