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;

What is serial sql?

1038

---

Can pl sql procedure have a return statement?

1068

---

What is anonymous block in sql?

1168

---

what is meant by nl2br()? : Sql dba

1102

---

where are cookies actually stored on the hard disk? : Sql dba

1079

---

How to sort the rows in sql.

1113

---

How do I save a sql query?

1063

---

What are stored procedures in mysql?

1069

---

Cite the differences between execution of triggers and stored procedures?

1135

---

Do we need to create index on primary key?

963

---

What is pivot in sql?

965

---

how to do backup entire database? : Transact sql

1190

---

what is denormalization. : Sql dba

1157

---

Is the primary key an index?

1073

---

What is the use of sqldataadapter?

1020

---