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

a.The PL/SQL block should allow the user to enter a sales persons name and the items sold.

b.The PL/SQL block determines the sales commission and prints appropriate messages. Use the following criteria:

Items sold Commission
>= 100 1500
70 to 99 600
50 to 69 200
0 to 49 0

2.Create an anonymous PL/SQL block to do the following:

a.The PL/SQL block should allow the user to input a number between 1 and 10

b.The PL/SQL block calculates and prints a list of the number, the number squared and the number cubed (hint: use For loop or While loop)

3.Create and populate your own database schema by running the hr_popul_sql script file(s) (Unzip hr_popul_sql.zip).

a.Download hr_popul_sql.zip file

b.Uncompress hr_popul_sql.zip file

c.Run script files to create and populate your schema database

4.Extra credit: Log on to Oracle using ap/ap account. Write an anonymous PL/SQL block that creates a cursor consisting of vendor_name, invoice_number, and balance_due for each invoice with a balance due thats 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

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
$10,000 to $20,000
$5,000 to $10,000

Each group should have a heading followed by the data for the invoices that fall into that group. Also, the groups should be separated by one blank line.

Academic Honesty!
It is not our intention to break the school's academic policy. Posted solutions are meant to be used as a reference and should not be submitted as is. We are not held liable for any misuse of the solutions. Please see the frequently asked questions page for further questions and inquiries.
Kindly complete the form. Please provide a valid email address and we will get back to you within 24 hours. Payment is through PayPal, Buy me a Coffee or Cryptocurrency. We are a nonprofit organization however we need funds to keep this organization operating and to be able to complete our research and development projects.