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 company name */ 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.
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).
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).