Question: 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

PL/SQL
PL/SQL What does the following code do? Declare cursor c1 is select

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 loop; dbms_output.put_line(n); close cl 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 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;...

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:

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:

Use the following EMPLOYEES table to translate the following PL/SQL code, show the output of resulting data EmplD EmpName Salary 466 Mohammad 280 467 Samer 350 468 Rami 350 469 Ali 400 500 Khaled 515...

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:

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:

Find the Inverse Z-transform of the sequence 2 X(Z) = ROC : |Z|>1. 2z-3z +1

Q:

Vision, the owner of the registered trademarks VISION QUEST for hotel services and VISION for a variety of goods and services (and the owner of the domain name www. vision.com) recently discovered...

Q:

The risk premium for an individual securities is equal to the _ _ _ _ _ _

Q:

Calculate the minimum and maximum takt time for the given

Q:

. A very sweet pie made from molasses that originated with the Pennsylvania Dutch: a. Mincemeat pie b. Sugar pie c. Shoofly pie d. Lancaster pie

Q:

4. Which of the following is not the name of a Native American tribe? a. Seminole b. Apache c. Arapaho d. Illini

Q:

8. Explain the relationship between communication and context.