oracle sql devloper

Write a function invoiceCheck with one input parameter (invoice number) to check if the invoice exists in your database.

Write a procedure InvoiceDetail with one input parameter (invoice number). In the procedure, call the function invoiceCheck to check if the invoice exists, if yes, display the invoice_id, invoice_total and invoice_due_date for that invoice. If not, print out a message invoice not in the database from your procedure. (submit the code & screenshot of the result set for each test case)

NULLABLE DATA DEFAULTCOLUMN ID COMMENTS 1 (nul1) 2 (nul1) 3 (nul1) 4 (null) 5 (nul1) 6 (null) 7 (nul1) 8 (null) 9 (null) 10 (null) COLUMN NAME 1 INVOICE ID 2 VENDOR ID DATA TYPE NUMBER NUMBER 4 INVOICE DATE 5 INVOICE TOTAL NUMBER (9,2) 6 PAYMENT TOTALNUMBER (9,2) 7 CREDIT TOTAL 8 TERMS ID 9 INVOICE DUE DATE DATE 10 PAYMENT DATE No No 3 INVOICE NUMBER VARCHAR2 (50 BYTE) No No No No No No No (null) (null) (null) (null) (null) (null) (null) (null) (null) Yes (null) DATE NUMBER (9, 2) NUMBER DATE