Enhance your solution to exercise 3 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: You are using the bind variable to set the balance due minimum. In this case 2000 is not a hard coded value but is set using a bind variable. Invoice amounts greater than or equal to $2,000 where 2,000 is the value of the bind variable. SET SERVEROUTPUT ON;
DECLARE
CURSOR invoices_cursor IS
SELECT vendor_name, invoice_number, invoice_total - payment_total - credit_total AS balance_due
FROM ap. vendors v INNER JOIN ap. invoices i
ON v. vendor_id = i. vendor_id
WHERE invoice_total - payment_total - credit_total >= 5000
ORDER BY balance_due DESC;
invoice_row invoices_copy%ROWTYPE;
BEGIN
FOR invoice_row IN invoices_cursor LOOP
DBMS_OUTPUT. PUT_LINE(to_char(invoice_row. balance_due, '$99,999.99') || ' ' || invoice_row. invoice_number || ' ' || invoice_row. vendor_name);
END LOOP;
END;