FIGURE Ch08 SimpleCo database tables P8.1 Database name: Ch08_SimpleCo Table name: CUSTOMER Table name: INVOICE CUST NUM CUST LNAME CUST ENAME CUST BALANCE 1000 Smith 1001 Ortega INV_NUM CUST_NUM INV...

Write a procedure to add a new invoice record to the INVOICE table. Use the following values in the new record:

8006, 1000, '30-APR-14', 301.72

Name the procedure prc_invoice_add. Run a query to see if the record has been added. S

Extracted text: FIGURE Ch08 SimpleCo database tables P8.1 Database name: Ch08_SimpleCo Table name: CUSTOMER Table name: INVOICE CUST NUM CUST LNAME CUST ENAME CUST BALANCE 1000 Smith 1001 Ortega INV_NUM CUST_NUM INV DATE | INV_AMOUNT Jeanne 1050.11 8000 1000 23-Mar-14 235.89 Juan 840.90 8001 1001 23-Mar-14 312.82 8002 1001 30-Mar-14 528.10 Table name: CUSTOMER 2 8003 1000 12-Apr-14 194.78 CUST NUM CUST UNAME CUST FNAME 8004 1000 23-Apr-14 619.44 2000 McPherson Anne 2001 Ortega Juan 2002 Kowalski Jan 2003 Chen George Cengage Learning © 2015