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;

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

0 Answers  

---

What is rowtype?

0 Answers  

---

what is primary key? : Sql dba

0 Answers  

---

How do you explain an index number?

0 Answers  

---

what is the difference between the query and corelated query

8 Answers   HSBC, IBM, TCS, Xenosoft,

---

What is a common use of group by in sql?

0 Answers  

---

Can we create table inside stored procedure?

0 Answers  

---

How to avoid duplicate records in a query?

0 Answers  

---

what is timestamp in mysql? : Sql dba

0 Answers  

---

What is pls_integer in pl sql?

0 Answers  

---

Does oracle use sql?

0 Answers  

---

What is a stored procedure ?

9 Answers  

---