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;

How do you declare a constant?

910

---

Can variables be used in sql statements?

980

---

explain normalization concept? : Sql dba

996

---

What is aggregate function in sql?

984

---

List the different type of joins?

1000

---

How would you convert date into julian date format?

947

---

What information is needed to connect sql*plus an oracle server?

978

---

Is sql a backend language?

1038

---

What does the file extension accdb stand for?

916

---

Can we use distinct and group by together?

990

---

How can you load multi line records? : aql loader

1020

---

what are the advantages and disadvantages of cascading style sheets? : Sql dba

1006

---

Why commit is not used in triggers?

992

---

What is lookup table in sql?

980

---

Is not equal in sql?

958

---