Hi Ingo, are you able to provide answers to the remaining two questions? You already provided assistance with the first question in a previous post.
Suppose you have created tables in assignment 1 listed below. Please write an anonymous PL/SQL program for each the following problems. Tables: Company(cid, cname, city, state) /* city is the company’s location, cname is ***** ***** */ Employee(eid, ename,
street, city, state, salary, cid) /* city is where the employee lives*/ Manages(eid, mid) /* mid is manager’s ID*/
Problem 1: Write an anonymous PL/SQL program to compute the sum of 1, 3, 5, 7, 9. You must use a loop. Tip: consider how to update your loop
variable. [30 points]
Problem 2: Use an implicit cursor to print out the MID of manager of Bob. Please handle exceptions. If you do not have Bob as ename in your employee table, use any name you have (e.g., Jeff). [35 points]
Problem 3: Use an explicit cursor
to print out the ename, street, and city of all employees working for Verizon (you can also use any company name you have in your company table if you do not have Verizon as company_name). [35 points]