Display the balance due

1. Create an anonymous PL/SQL block to determine sales commissions:

   1. The PL/SQL block should allow the user to enter a sales person’s name and the items sold.

50 to 69 200

0 to 49 0

2. 1. Download hr_popul_sql.zip file

   2. Uncompress hr_popul_sql.zip file

Enhance your solution so it shows the invoice data in three groups based on the balance due amounts with these headings:

$20,000 or More

• Submit a screen printout that gives the Oracle commands used to create the various objects listed in the requirements specified below (objects may include clusters, tables, indexes, stored procedure, functions, triggers) as described in each requirement. The printout should also give the commands and output for the various SQL commands as described in each requirement.

• Submit your answers just as you would submit work to your supervisor in a work environment, ensure output has sufficient margins, clearly identify answers by the requirement number, etc.  Neatness counts on this assignment as it affects the amount of time required in the grading process.