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.