Question: What does the following code do? Declare cursor c1 is solect salary from manager; 5 number(10), n number (10)=0; begin open c1; loop fetch c1

What does the following code do? Declare cursor c1 is solect

What does the following code do? Declare cursor c1 is solect salary from manager; 5 number(10), n number (10)=0; begin open c1; loop fetch c1 into s ; exit when c1% not found; n=n+s; end loop; dbms_output put_line(n); close c1, end

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

What does the following code do ? Declare cursor c1 is select salary from manager; s number(10); n number(10):=0; begin open c1; loop fetch c1 into s ; exit when c1%not found; n:=n+ s ; end loop;...

Q:

PL/SQL What does the following code do? Declare cursor c1 is select salary from manager; s number(10); n number (10):=0 begin open cl; loop fetch c1 into s; exit when c 1% not found; n:=n+s; end...

Q:

What does the following code do ? Declare cursor c1 is select salary from manager; s number(10); n number(10):=0; begin open c1; loop fetch c1 into s ; exit when c1%not found; n:=n+ s ; end loop;...

Q:

What does the following code do ? Declare cursor c1 is select salary from manager; s number(10); n number(10):=0; begin open c1; loop fetch c1 into s ; exit when c1%not found; n:=n+ s ; end loop;...

Q:

What does the following code do ? Declare cursor c1 is select salary from manager; s number(10); n number(10):=0; begin open c1; loop fetch c1 into s ; exit when c1%not found; n:=n+ s ; end loop;...

Q:

Can you please explain the code answers to me line by line with comments? I have the questions and answers but I am having trouble understanding everything that is going on. Thank you. This is in...

Q:

Using the film database you have, answer the following queries in your schema then write them down in this paper. Question one: a) Select the total rental_rate for films grouped by their categories....

Q:

Using the film database you have, answer the following queries in your schema then write them down in this paper. a) Convert the following for-cursor into: open, fetch, close one: DECLARE Cursor c1...

Q:

PL/SQL Questions Q1. Consider the following SELECT-INTO statement in a PL/SQL block. What happens if there is NO row satisfying the WHERE condition? ...... SELECT COUNT(*) INTO v_n FROM tab1 WHERE...

Q:

2. For this exercise, you use the employees and departments table. Create a PL/SQL block that fetches and displays the names of the five departments with the most employees (Hint: use a join...

Q:

Is a real estate agent a typical agent? Explain.

Q:

Alice Foyle, M.D. (lessee) has a non-cancelable 20-year lease with Brownback Realty, Inc. (lessor) for the use of a medical building. Taxes, insurance, and maintenance are paid by the lessee in...

Q:

Jenner & Jenner CPAs are the auditors for the Leno Company. In reviewing the accounts receivable aging, the auditors learn that there is a high number of accounts with large balances, there are some...

Q:

SIMAD UNIVERSITY Class: BACC25 Subject: Islamic Accounting Instructions: a) Follow The Instructions. Midterm Exam Instructor: All Ibrahim Date: 6-4-2022 b) You Have 1.5 Hrs. To Complete This Test. c)...

Q:

1. Identify three approaches to culture.

Q:

3. Identify and describe nine cultural value orientations.

Q:

4. Describe how cultural values influence communication.