Answer Posted / hitendra yadav

Reference cursor is as like pointer in C ad PASCAL language
which is point the data's memory location,REF CURSOR is
dynamic cursor which can be open for more then one query.
there are two type of ref cursof:-
(1) WEEK REF CURSOR:- ref cursor which not have return
cluse in defination.
(2) STRONG REF CURSOR :- ref cursor which use return cluse
in defination.

for example:-

SET serveroutput ON
DECLAR
TYPE eref REF CURSOR; -- WEEK REF CURSOR
eref1 eref;
erec employees%ROWTYPE;
BEGIN
OPEN eref1 FOR SELECT *
FROM employees
WHERE dept_id=90;
LOOP
FETCH eref1
INTO erec;
DBMS_OUTPUT.PUT_LINE(erec.emp_id);
EXIT WHEN eref1%NOTFOUND;
END LOOP;
END;

Where can I learn sql for free?

977

---

Explain what is a column in a table?

1084

---

What are different functions in sql?

922

---

Mention what are different methods to trace the pl/sql code?

1173

---

How do you update a value in sql?

1021

---

What are character functions in sql?

920

---

what is oracle database ? : Sql dba

1007

---

How do you explain an index number?

1079

---

What is view? Can we update view

1411

---

What are the types of optimization?

927

---

Explain two easy sql optimizations.

994

---

what is the difference between $message and $$message? : Sql dba

977

---

what is the difference between cluster and non cluster index? : Sql dba

1006

---

What are sql constraints?

1159

---

What is a data manipulation language?

1006

---