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;

Types of locks in database ?

8 Answers   HCL, TCS, Tieto,

---

Is there a way to automate sql execution from the command-line, batch job or shell script?

0 Answers  

---

how to start mysql server? : Sql dba

0 Answers  

---

What is the difference between an inner and outer join?

0 Answers  

---

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

0 Answers   MCN Solutions,

---

sql query to get zero records from a table having n no of records

8 Answers   CTS,

---

Can we use insert statement in function?

0 Answers  

---

What is difference between cursor and ref cursor?

1 Answers  

---

How do I copy a table in sql?

0 Answers  

---

Can we use delete in merge statement?

0 Answers  

---

How do you declare a variable in pl sql?

0 Answers  

---

What are the difference between Functions/Stored Procs and Triggers and where are they used.

1 Answers   CGI, TCS,

---