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 a Mapplet?

0 Answers   Informatica,

---

What are pl/sql exceptions? Tell me any three.

1 Answers  

---

How to get list of all tables from a database?

0 Answers  

---

can a stored procedure call itself or recursive stored procedure? : Sql dba

0 Answers  

---

Is sql sequential or random?

0 Answers  

---

Explain the two type of Cursors ?

8 Answers   Hi Caliber IT,

---

what is row? : Sql dba

0 Answers  

---

how many groups of data types? : Sql dba

0 Answers  

---

Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?

2 Answers  

---

Name the operator which is used in the query for pattern matching?

0 Answers  

---

What is data type in sql?

0 Answers  

---

How do I quit sql?

0 Answers  

---