Answer Posted / b.v.srinivas

Ref cursor is a cursor variable which acts as a pointer to
the sql memory area.
Ref cursor can be asssociated with multiple sql statements
where as a cursor can be associated with only one sql
statement.
Refcursor is dynamic where as cursor is static.
Ref cursors are of two types:
1)strong ref cursor:which retuns value.
2)week ref cursor:which doesn't return value.


thanks and regards
B.V.Srinivas.

What is a trigger word?

961

---

What is clause in sql?

1050

---

Is sql harder than python?

1034

---

How do I create an index in word?

965

---

Is sql between inclusive?

1057

---

how to get a list of columns in an existing table? : Sql dba

913

---

How to run sql*plus commands in sql developer?

1083

---

Can you have a foreign key without a primary key?

899

---

What is a record in a database?

989

---

define join and explain different type of joins? : Sql dba

897

---

What is the difference between row level and statement level trigger?

955

---

Is sql an operating system?

956

---

What is the use of count (*) in sql?

974

---

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

966

---

What is file based approach?

874

---