Lalita.p

• Sep 13th, 2006

 

Cursors allow you process the resultset row by row.
Advantage of cursors it improve the query performance.

tariq_oracle

 Profile Answers by tariq_oracle 

• Jun 7th, 2008

 

1. This is a dynamic cursor which can holds multiple value at run time
2. Actually this is nothing but a data type of cursor variable

krishnaindia2007

 Profile Answers by krishnaindia2007 

• Jun 22nd, 2008

 

Ref cursor is basically a data type. A variable declared based on that data type is called cursor variable. The main advantage of using this variable is we can dynamically assosiate with different  queries at runtime depending upon  our requirement.