Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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;
dbms_output.put_line(n);
close c1;
end;
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;
dbms_output.put_line(n);
close c1;
end;
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started