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 rank function in sql?

1066

---

What is trigger explain with example?

1087

---

how to enter characters as hex numbers? : Sql dba

1098

---

List the various privileges that a user can grant to another user?

1086

---

What is sqlca in db2?

1030

---

Is record in pl sql?

1009

---

What is procedure and function in sql?

1042

---

What are the advantages of normalization?

1127

---

Explain how can you save or place your msg in a table?

1074

---

Is sql a backend?

1067

---

How to select all records from the table?

1179

---

Is sql easier than java?

1063

---

Explain about various levels of constraint.

996

---

What is a pl/sql block?

1322

---

What does (+) mean in sql joins?

1114

---