Reference no: EM13853336 , Length:
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).
|
What is the marginal cost of a flight
: Suppose an airline is losing money because they cannot fill enough seats in their flights with passengers. The airline would offer a flight only if at least 70% of the seats could be filled. The average total cost for the typical flight is $12,600. W..
|
|
Required reserves and excess reserves
: Suppose that Best National Bank currently has $50,000 in demand deposits and $32,500 in outstanding loans. The Federal Reserve has set the reserve requirement at 10%. Required Reserves?: Excess Reserves?:
|
|
Eight major classifications of management skills
: What are the eight major classifications of management skills? Which skills do you feel you are strong in? Why?
|
|
Tightening of consumer credited effected individual spending
: How has the tightening of consumer credited effected individual spending and in turn the U.S. economy? Has this strategy by the financial institutions helped our economic recovery?
|
|
Implicit cursor to print out the mid of manager of bob
: Write an anonymous PL/SQL program to compute the sum of 1, 3, 5, 7, 9. You must use a loop - implicit cursor to print out the MID of manager of Bob.
|
|
Consider the goods and services
: Consider the following goods and services. Which are the most likely to be produced in a perfectly competitive industry? Which are not? Explain why you made the choices you did, relating your answer to the assumptions of the model of perfect competit..
|
|
Physician-ethicist at hope hospital in nirvana
: You are a physician-ethicist at Hope hospital in Nirvana, USA. Your state is voting this month whether to allow PAS, under the exact guidelines and safeguards instituted in Oregon. The local news station has asked you to join a televised multi-discip..
|
|
Calculate the net present value to the society
: Suppose El Centro California decides to tackle the problem of nitrates in the water. Nitrates are compounds derived from synthetic fertilizers that are not assimilated by plants and leached out into the underground water and affect the human health. ..
|
|
What is the slope of the above budget constraint
: Sidney makes $200 per week. She buys only two items: pizza and beer. The price of a pizza is $5 and the price of each beer is $2. What is the y-axis intercept for the above budget constraint? What is the x-axis intercept for the above budget constrai..
|