Difference between REF Cursor & Normal Cursor in oracle

          

Difference between REF Cursor & Normal Cursor

Next question>>
Difference between REF Cursor & Normal Cursor in Oracle - Feb 18, 2010 at 11:00 PM by Rajmeet Ghai

What is the difference between REF Cursor & Normal Cursor in oracle?

REF cursor is typically used to return record set or a cursor from stored procedure. REF Cursor is basically a data type. It is normally declared as type r_cursor is REF CURSOR; REF cursor supports dynamic change of query.

Normal cursor is a static cursor in which the query is assigned at design time and cant be changed at run time.

Difference between REF Cursor & Normal Cursor in Oracle - April 08, 2009 at 13:00 PM by Rajmeet Ghai

What is the difference between REF Cursor & Normal Cursor in oracle?

Normal cursors fall under the category of static cursors while REF cursors are dynamic. This means that normal cursors can only be used again not defined. Ref cursors on the other hand can be changed. A Ref cursor can be passed from one procedure to another. A normal cursor cannot.


Also read     

Oracle cursors interview questions

What a SELECT FOR UPDATE cursor represent?, What WHERE CURRENT OF clause does in a cursor?, Can you pass a parameter to a cursor?, Explain the functioning of CURSOR FOR LOOP with example., Define Simple/Explicit , Parametric and Internal/Implicit cursor.............

What is the difference between REF Cursor & Normal Cursor in oracle?

Normal cursors fall under the category of static cursors while REF cursors are dynamic.........

What is use of a cursor variable in oracle?

A cursor variable works like pointer in C. It is used to hold address of an item rather than the item itself. Cursor variables can be used to hold different values at run time............

Explain how to prevent tablespace fragmentation in oracle.

Tablespace fragmentation can be prevented by using PCTINCREASE command......... 

What is difference between open_form and call_form? What is new_form built-in in oracle form?

Open_form opens the indicated form. Call_form not just opens the indicated form, but also keeps the parent form alive........

What is a cursor? What are its types?

Oracle engine uses private working area to process queries. This work area is called as cursor. The data that is stored in the cursor is called as Active Data Set.............

Explain the attributes of implicit cursor

There are four attributes of implicit cursor in oracle: SQL%IsOPEN - Implicit cursor always returns FALSE as it gets closed automatically...........

Explain the attributes of explicit cursor.

There are four attributes of explicit cursor in oracle. %IsOPEN - This evaluates TRUE when cursor is open else FALSE...........

Next question>>

 
Interview questions
 
Home | Want a Job? Submit Key Skills | Employer login | My key skills | About us | Sitemap | Contact us