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;

how to use regular expression in pattern match conditions? : Sql dba

0 Answers  

---

Is subquery faster than join?

0 Answers  

---

Explain isolation levels. : Transact sql

0 Answers  

---

difference between anonymous blocks and sub-programs.

0 Answers  

---

What is data control language?

0 Answers  

---

What is sql dialect?

0 Answers  

---

what is variable in package specification

3 Answers  

---

write a query filter the null value data following source? name age john 30 smith null null 24 sharp 35 i want output name age john 30 sharp 35

1 Answers   TCS,

---

Can 2 queries be executed simultaneously in a distributed database system?

0 Answers  

---

What are the two characteristics of a primary key?

0 Answers  

---

How do I view an execution plan in sql?

0 Answers  

---

What is delimiter sql?

0 Answers  

---