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;
/

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;

What is the difference between delete and truncate statement in sql?

0 Answers  

---

What is sql constant?

0 Answers  

---

What is pl/sql table? Why is it used?

0 Answers  

---

Types of locks in database ?

8 Answers   HCL, TCS, Tieto,

---

What are % type and % rowtype?

0 Answers  

---

Does SQL*Plus contains pl/sql Engine?

1 Answers   TCS,

---

Can a trigger call a stored procedure?

0 Answers  

---

Explain the components of sql?

0 Answers  

---

How to display Row Number with Records in Oracle SQL Plus?

0 Answers   MCN Solutions,

---

what are all different types of collation sensitivity? : Sql dba

0 Answers  

---

Can we use joins in subquery?

0 Answers  

---

Does inner join remove duplicates?

0 Answers  

---