Write a simple program on cursors
Answers were Sorted based on User's Feedback
Answer / a.jyothsna
declare
cursor cur_t is select * from test;
var_t test%rowtype;
begin
open cur_t;
loop
fetch cur_t into var_t;
exit when cur_t%notfound;
dbms_output.put_line('a: ' || var_t.a || ', b: ' ||
var_t.b);
end loop;
end;
/
Is This Answer Correct ? | 12 Yes | 2 No |
Answer / subhendu
CREATE OR REPLACE Function test( I_name IN varchar2 )
RETURN number
IS
CURSOR c1
IS
SELECT course_number,
instructor
from courses_tbl
where course_name = I_name
FOR UPDATE of instructor;
v_number courses_tbl.course_number%type;
v_instructor courses_tbl.instructor%type;
BEGIN
open c1;
fetch c1 into v_number,v_instructor ;
if c1%found then
UPDATE courses_tbl
SET instructor = 'SMITH'
WHERE CURRENT OF c1;
COMMIT;
end if;
close c1;
RETURN v_number;
END;
Is This Answer Correct ? | 5 Yes | 1 No |
Types of cursor locks and explanation each of them ?
How do I upgrade sql?
How do I know if I have sql express or standard?
How do I find sql profiler?
What is nested table in pl sql?
Can we use ddl commands in pl sql?
Does truncate release storage space?
What is package in pl sql with an examples?
Explain aggregate functions are available there in sql?
Explain normalization and what are the advantages of it?
What does (+) mean in sql joins?
What are the various restrictions imposed on view in terms of dml?