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 field delimiter?

0 Answers  

---

Why truncate is faster than delete?

0 Answers  

---

Whis is not false in primary key?

0 Answers   Fintellix,

---

what is meant by nl2br()? : Sql dba

0 Answers  

---

What sql database should I use?

0 Answers  

---

How do you take the union of two tables in sql?

0 Answers  

---

Explain what is a view?

0 Answers  

---

What is optimistic concurrency control? : Transact sql

0 Answers  

---

how to create a database in oracle?

3 Answers  

---

i have a table like this. i want to output like this c1 c2 c1 c2 1 10 1 10 2 20 2 30 3 30 3 60 4 40 4 100 5 5 5 105 c1 and c2 are columns in a table .i want output like this c2 values are 10,10+20,10+20+30,10+20+30+40.10+20+30+40+5. write a sql query.pls help this i want urgent.

2 Answers   IBM, Loginworks, OFSS,

---

What is sql exception?

0 Answers  

---

What is database white box testing and black box testing?

0 Answers  

---