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 do you think about pl/sql?

0 Answers  

---

can we create index on index?

7 Answers   iFlex, Symphony,

---

What is TABLE SPACE?

4 Answers   ABB, TCS,

---

What packages(if any) has oracle provided for use by developers?

1 Answers  

---

Is sql developer case sensitive?

0 Answers  

---

What is a parameter query?

0 Answers  

---

I have a procedure in a procedure. The inner procedure contains out parameter. How I can call the inner procedure in the out procedure and send the inner procedure parameter value(out parameter value) into out procedure?

2 Answers  

---

How to export the table data (this table having 18 million records) to .csv file. Please tell me is there any faster way to export the data.

8 Answers  

---

what is the use of double ampersand (&&) in sql queries?

0 Answers  

---

What is pseudo column ?

6 Answers   ABB,

---

What are sql triggers used for?

0 Answers  

---

What are the different types of sql commands?

0 Answers  

---