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.

How is debugging done?

977

---

What are database links used for?

1046

---

what is the different between now() and current_date()? : Sql dba

1022

---

What is the mutating table and constraining table?

1026

---

how to get help information from the server? : Sql dba

940

---

Explain the difference between 'between' & 'and' operators in sql

998

---

What is group by in sql?

1083

---

what are the differences among rownum, rank and dense_rank? : Sql dba

1040

---

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

1190

---

Does sql view stored data?

957

---

what are ddl statements in mysql? : Sql dba

1201

---

how to delete an existing column in a table? : Sql dba

1005

---

What is data manipulation language?

1187

---

The select into statement is most often used to create backup copies of tables or for archiving records?

1064

---

What is view explain with example?

930

---